Hi!
I've read a lot of informoation about the Microsoft Sequence
Clustering algorithm, but the more i read more confused i get. Here's
my doubt:
Can it discover sequences of "tokes" and then group them? Or only compare sequences in order to group them?
Thanks in advance
I€™m a college student currently studying 10th semester in the Universidad de los Andes, Colombia and I€™m working on a data mining project. I need to use the cluster sequence approach; therefore I need to completely understand how it works. In order to understand it, I need to know which inputs it uses, how the algorithm works and which type of outputs does the approach throw. Do you have any idea where I can find this type of information? and examples?
Any help would be appreciated.
Thank-you for your time.
I get this message when I deploy my sequence clustering model:
Error 1 Error (Data mining): Duplicate Key Sequence values in an input case for SeqCluster. Ambiguous case(s) may lead to unreliable results. Disambiguate the data (recommended) or increase ErrorLog KeyErrorLimit server parameter. 0 0
I don't have any duplicate keys in my case table. I'm using a date for my key sequence column in my nested table. Is that the problem?
How do I limit (or partition) a sequence clustering by year? I would like to do it within the sequence clustering mining structure instead of partition at the OLAP cube/
View 1 Replies View RelatedHi
I read the paper of sequence clustering. It seems that the major application of the algorithm is for the web site. I was just thinking that can I apply this algorithm on the purchase sequences of credit card data?
If so,please also tell me the difference between sequence clustering and association rules on credit card data application. Although I realize that sequence clustering is a fully probabilistic model and it has the capability of prediction, association rules also give the probabilities of purchasing the other products.
Thanks in advance.
To Wong
hi
where i can find some data bases to see how the sequence clustering works?.
thanks a lot
Hi, all experts here,
Thank you very much for your kind attention.
I have a question on sequence clustering algorithm. As generally it is used for sequence analysis especially for web path visiting analysis. Besides that, what else scenarios could we apply this algorithm as well?
Thanks a lot in advance and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
somebody help me??
View 4 Replies View Related
I am using Sequence Clustering algorithm. (I've built several models with Clustering algorithm and Decision Trees for this client, which work fine.).
Background: Sequence data must be stored in a nested table, which can have only 1 non-key attribute.
I specify a mining model structure with the nested table key as the datetime, and the nested table discrete prediction column as [sort name] . this builds the model fine.
When I try to process this data mining model, I get Process failed: "Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect".
Iit may be that OLAP distinct count requests numerical data type, but not from the examples I've seen. Tried this anyway €“ doesn€™t work on numeric either €“ same problem.
Any Suggestions?
I am starting on a project where we will be using SSIS. I am totally new to it and would like to ask for your input on whether SSIS can do what I want it to do.
What we are wanting to do is to take data that is loaded into a queue table, and then possibly transform it a bit and load it into a common db as a batch. After that, subsets of that data should then be replicated to other databases based on some criteria. So what we end up with is one database with all the data and two (for now) databases, each with a subset of that data.
Ideally we would want our backend apps to work with the data in the common database and our frontend apps to work with the data in the two other databases.
So I have a couple of questions.
Can SSIS do two-way replication? So if the frontend changed one of the subset databases, could it replicate the change to the common database? And likewise, if the backend changed the common database, could it replicate the change to one of the subset databases?
What is a good way to execute a package from code? For example, from code we would load some tables, and then we would like to execute the SSIS package after that to go through the tables and transform and send that to other tables in one big batch job.
Is it possible to look at the status of package execution from another computer other than the one running the package? I know one way is just for the package to write to a table what it is doing and that table can then be looked at. I was wondering if there was some more elegant way of doing this.
We are also looking at whether we can do our archiving process from SSIS. All it involves is taking the data in the common database and transforming it to xml and outputting it as a file. Is there a way to write out to an xml file? I saw that you can read in xml in SSIS, but I didn't see a way to output xml.
Those are all my questions for now. If you can help me out with even one of them, it would be much appreciated.
Thanks,
Raphael
What are my limitations with search? Can I search on a phrase? If I search for "bookshelf" will I get everything with 'book' and 'shelf'? Can I search using "and"? Can I sort the results like yahoo does? Can I rank the results? For example, if I search for a product can I sort the results by price?
View 1 Replies View RelatedI'm composing a comparison table of database capabilities of severaldifferent products. I've read the Transact-SQL reference and havegathered most of the information needed for SQL Server 2000 (MSSQL),but there are some things that I'm not very sure of. Could someoneconfirm or complete the points below?* MSSQL can index binary data but only for BINARY & VARBINARY fieldsand not IMAGE.* ALTER TABLE can't rename column name/index name/constraint name.* A functional index (index on expression/function) can be definedusing user-defined function, e.g. CREATE INDEX idx ON t (MY_FUNC(f))* Maximum number of indexes per table?* SEQUENCE (as in PostgreSQL) is not supported, but there is a datatype called TIMESTAMP/ROWVERSION that is 64-bit. SEQUENCE can also beimplemented using a 'counter table'.* Regexp is not recognized, only standard SQL LIKE pattern.* Maximum number of schemas per database?* There is no BOOLEAN data type, but one can use BIT as analternative.* Does MSSQL use a generational/MVCC/record-versioning architecture,to allow writers to not block readers and vice versa?* Can several user-defined functions be created with the same name butwith different signatures (argument type)? For example, REVERSE(text)and REVERSE(varbinary).* Does MSSQL have/use WAL (write-ahead logs)?* Can a unique index contain multiple NULLs?
View 2 Replies View RelatedHello all,
I have a winform application, where in we get the parameters from the reporting service and we display them in a panel for user's to input their criteria. So far everything worked good, but now we have a requirement wherein dynamic functionality is needed.
For Example:
Based on a selection of a combobox value, we want the other control to be enabled or disabled. Also we want default value of a control to be calculated based on another control's value like .. if user enters value "1" in textbox1 then texbox 2 should have default value of "6". (Textbox1 + 5).........and mix and match of such capabilities.
The Question is........IS IT POSSIBLE??? and if yes...HOW!!!
I've been given a brief to create a web based MI solution to enable users to gain information about their departments and drill down and analyse information presented to them.
I've been asked to look at Reporting services for this, we have been using Crystal Reports, but not to the extent of public facing MI delivery that this project demands.
Could I ask the forum some basic Questions?
1> Is it possible to produce live interactive reports for use on the internet with reporting services.
2> Can I produce reports that can drill down on data, and that can be tweaked so that they are extremly 'user freindly?
3> What are the chart options available, I have been asked to look into providing 'stickmen graphs'. In that a chart is produced to represent a population, and each item of the population is represented by a little man graphic.
4> Are there any good websites that have code snippets and the like to SSRS?
5> Can you recommend any good books.
Thanks in advance for any reponses to these queries.
Greetings,
My desire is to have my primary db in FL and an online hot standby in both my MI and CA offices. The hardware is in place, as well as T1 size pipes. The solution I'm looking for would have all databases online in case of hardware / environmental failure although the application would only be pointing at the primary (or designated) database server. We have another 3rd party solution available, but I'd like to stay native SQL if possible.
Is replication the way to go?
Does one-to-many work?
Can all the db's be online and available while replicating?
Can I catch up if switched to one of the other db's temporarily?
note:This is 100% SQL 2005.
Thanks -- sorry for the newbie-flavor of the question, but I'm sure a gazillion people have already been down this decision branch.
Dan Ribar
Simply put, I have a 'Date and Time', (06/03/2006 11:40:00), passed to the SelectCommand via the QueryString. I would like to gain data that is between the supplied time and 1 hour prior.Is there a simple way to take 1 hr off the 'Date and Time" value or is it necessary to build code that parses the string then adjusts it?
The 'Time' and 'TimeStamp' entities below are both of type 'Date and Time' and all values are gained from the same sql database. I.e. the time used as the basis for selecting the hr period is from the same database as the one where the hour period will be selected from.
Any help would be great.
SelectCommand="SELECT [Timestamp], [Volume] FROM [out8$] WHERE (([CustomerLvl1] = @CustomerLvl1) AND ([Timestamp] = @Timestamp))">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="TNT Express" Name="CustomerLvl1" QueryStringField="Cust"
Type="String" />
<asp:QueryStringParameter DefaultValue="20/02/2006 22:20:00" Name="Timestamp" QueryStringField="Time"
Type="DateTime" />
We have 2 env. : Testing and Production, both are running Windows 2003 Enterprise Server with SQL Server 2005. The difference is Testing is NOT running Windows cluster but Production do so, what is the best way to transfer a database from testing to production?
We have another systems that both testing and production are running on NON-cluster and we use backup/restore to transfer the database, can it apply in this case.
And I found that there are a tools called DTC, which can transfer all DB objects from one DB to another, is it a best way to transfer between non-cluster and cluster env.?
I've been looking into ways to accomplish a fuzzy search and SSIS makes that possible if I want to do a bulk import or something like it. But what it I just want to look stuff up at any given time not haveing to run the package?
Is it possible to expose the fuzzy lookup outside of SSIS to for example t-sql?
Here's an example:
I want to lookup the music artist "Notorious BIG" but in the database it is "Notorious B.I.G." if I use the SSIS fuzzy lookup I basically get what I'm looking for. But how would I call this from a web application? So then I tried Full text search but this doesn't really work out as well.
Will I have to re-write the logic that the fuzzy lookup uses to enable it to work? i.e. using Full Text Indexes and FreeTextTable, ContainsTable, SoundEx and the like to somewhat even come close to what the Fuzzy Lookup has?
What is clustering?Why is it done?
Any suggestion appreciated.
Cheers!
I need to cluster two NT Enterrpise Servers with SQL 7 running on them. I have been looking all over the Net for info but not much luck. I need to have some specifics. Can you help me with some good sites or books or both? I have tried Microsoft and they had some info but not much.
Please help!
thanks
We are in the process of consolidating all our SQL6.5 and SQL7 databases to a single SQL 7 server - once completed we want to setup a 2 node SQL7/2000 cluster on either NT4 Enterprise or W2k Advanced Server. I would therefore appreciate any advice in choosing between the two platforms based on cost, ease of setup & configuration and ongoing reliabilty & uptime etc - we currently have no NT4 Enterprise Servers so would have to purchase these licenses anyway. Correct me if I am wrong but I also understand that setting up a cluster on NT4 Enterprise is considerabely more complicated and time consuming than on W2K Advanced Server? Any advice would be greatly appreciated..
regards
Marcfw
I have a job interview and I need to know what type of questions can be asked about working in a cluster environment, I don't have much experience in clustering, can someone please give me an idea?
Thanks in advance!!
Can I implement failover clustering between SQL Server 2000 & SQL Server 7.0? Or do they both need to be the same version of SQL Server.
View 3 Replies View RelatedI have a question relating more to documentation and support. I'm trying to find documentation on clustering.
I remember quite some time ago I found a white paper that literally walked you through every step involved in setting up a SQL Server failover cluster. I had also found a white paper that walked you through setting up an Active/Active cluster.
I've been going through Microsoft's site, but all I've found are little bits and pieces.
If anyone can point me in the right direction, or even provide a link, etc. as to where to find some good solid documentation, that would be awesome.
Thanks!!
Anthony
If i have an activepassive cluster for SQL Server, under what circumstances would it prompt to automatic changeover to the passive cluster ? Failure of the SQL Server, or let's say 1 user database out of 25 becomes suspect?
View 1 Replies View RelatedIs this possible with Express Edition.
We have two servers both running SQL 2005 express. Is there anyway that any changes on one could be replicated on the other?
Thanks
HiI would like to know if it's possible to make a basic SQL cluster withwindows 2003 server and SQL 2000 standard edtition. It has to be abasic cluster, I dont need it to be very quick, I can have minutes ofservers down and it's ok.In case the answer is Yes, can you recommend some links to build itup, please?Thanks in advance!!Ignacio
View 2 Replies View Relatedwhat is clustering tell me in detail
We currently have a cluster configuration that is running as failover with one shared SAN storage solution. Two servers running Windows Server 2003 Enterprise and SQL 2005 Enterprise. We have two nodes right now running in failover and we will be purchasing a third.
Everything is working now, but we would like to move to an N+1 configuration with two active nodes hosting a separate SQL instance each with one failover node. I've seen N+1 mentioned on about a dozen Microsoft websites, but I cant find any documentation on how to setup or configure this clustering method. Has anyone ever set up a configuration like this or seen any documentation on how to do it? Is it possible to run failover with three nodes, two of them being active?
Any insight would be greatly appreciated.
Hi,
Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster?
Thanks
Hi All,
Is anyone can tell me the difference between log shipping and clustering? I look at it and I think that this is the same thing as they use two different servers.
TIA
Does anyone know the answers to either of these, given that we are talking about an active/passive cluster using MSCS, and we use Groupwise for mail (don't ask!)?
1) How do I configure Agent Mail on the cluster under this setup?
2) How do I set up linked servers from this setup to other (non-clustered) SQL servers - I can set up the cluster virtual server as a linked server from the others OK, but the other way around doesn't work - perhaps not surprisingly, but is there a way around it?
Thanks
Martin
I need some documentation on how to trouble shoot clustering SQL7EE. I have setup the cluster and looks like it is working but I missed somthing. When I test a failover by pulling the Network cable to the main network not the heartbeat network both boxes lock up. I can failover by powering down one box and using the MSCluster Admin. I am using NT40 6a on Dell PowerEdge 2400 and PowerValut 211s
View 3 Replies View Related