Data Bases For Sequence Clustering
Aug 24, 2007
hi
where i can find some data bases to see how the sequence clustering works?.
thanks a lot
ADVERTISEMENT
Sequence Clustering Capabilities
Nov 10, 2006Hi!
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
Information Of Sequence Clustering
Aug 14, 2007I€™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.
Sequence Clustering Error
Oct 10, 2006I 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?
Year Based Sequence Clustering
Nov 1, 2006How 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 RelatedSequence Clustering And Association Rules
Jul 13, 2006Hi
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
Question On Sequence Clustering Algorithm
May 1, 2007Hi, 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,
How To View Results From Sequence Clustering Using DMX Query
Mar 4, 2007somebody help me??
View 4 Replies View RelatedSequence Clustering Model Processing Fails Due To Sort Order
Dec 18, 2007
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?
Linked Data Bases
Feb 23, 2006We recently copied(replicated) a data base for development. everything wentwell until yesterday we had rows start to disappeared in the source database. I then found out that the rows disappearing from the source data basewere being deleted from the database copy and this was being replicated inthe source database. I am sure this is a great feature but I need to stopit from doing this. HELPthankspaul
View 1 Replies View RelatedVxWorks And SQL Data Bases
Oct 2, 2007Hello!
I'm about to start a project to design an RTOS application that also will communicate with some sort
of relational data base accessed by SQL-commands (this is as general as a description can get, I know)
For various reasons I am forced to use wind-rivers VxWorks plattform for my development.
So my questions are these:
- Does anyone of you know what types of SQL-data bases that the latest VxWorks plattform supports ?
- Does the Tornado design environment provide ready made objects for Microsoft SQL-server, Oracle
and/or MySQL for instance ?
I would really appreciate anwers or deferance to some forum where I can get answers on these topics !
Thank you!
Per
Query On 2 Bases
Jul 20, 2005How to make a query which contains fields from two different bases ?Thanks in advance.ReN
View 2 Replies View RelatedReturn Columns For Different Sql Bases
Nov 3, 2006I want in one query return columns from tables where exist in different sql bases.
In MS Access can link tables from many defferents sql bases or other MSAccess bases and finally can make a simple query where return columns from tables where exist in different bases.
How can i have the same functionality in Visual Basic .Net 2005 (or Visual Basic 6.0)
How Do I Insert Into Multiple Tables Bases On Conditions?
Jan 6, 2004I have a record that I want to insert into (2) tables. The first thing I want to do is see if a record already exists in the table for the user, if it does - I just want to skip over the insert.
next I want to do the same thing in the SW_REQUEST table. If there is a record in there for the member, I want to just skip the insert.
My code works as long as there isn't an existing record in the tables. Can someone give me a hand?
Here's what I have (and it doesn't work)
CREATE PROCEDURE b4b_sw_request
@FName as varchar(50)= NULL,
@LName as varchar(50)=NULL,
@Address1 as varchar(100) = NULL,
@Address2 as varchar(100) = NULL,
@City as varchar(50) = NULL,
@State as char(2) = NULL,
@Zip as char(5) = NULL,
@Email as varchar(100) = NULL,
@Send_Updates as smallint = '0'
AS
IF EXISTS
(SELECT FName, LName, Address1, Zip from MEMBERS WHERE FName = @FName AND LName = @LName AND Zip = @Zip)
BEGIN
RETURN
END
ELSE
BEGIN
INSERT INTO MEMBERS
(FName, LName, Address1, Address2, City, State, Zip, Email)
Values
(@FName, @LName, @Address1, @Address2, @City, @State, @Zip, @Email)
END
IF EXISTS
(SELECT MEMBER_ID FROM SW_REQUESTS WHERE MEMBER_ID = @@Identity)
BEGIN
RETURN
END
ELSE
BEGIN
INSERT INTO SW_REQUESTS
(MEMBER_ID, Send_Updates)
Values
(@@Identity, @Send_Updates)
END
GO
Create A Line Chart Showing Bases
Mar 13, 2012I am trying to create a report using the below data:
Report_Date Base_Name
2010-12-15 00:00:00.000Main
2011-01-27 00:00:00.000Outer
2011-06-27 00:00:00.000Main
2011-06-28 00:00:00.000Main
2011-07-18 00:00:00.000Inner
2011-09-21 00:00:00.000Inner
2011-10-11 00:00:00.000Outer
2011-10-04 00:00:00.000Outer
2011-10-14 00:00:00.000Central
2012-01-18 00:00:00.000Inner
I want to create a line chart showing the bases, split by 6 month periods, on the X axis and a count on the Y. I have tried but am well and trult stuck!
Clustering Of The Data
Jun 21, 2007Hi Everybody !
I am working on Clustering of the data.I have database of the dictionary including Antonyms and Synonyms.
I have to detect the sense and throw a output for the relevant words [ you can say including the Antonyms].
please tell me how to cluster the data so that it can be more efficient and it can throw more relevant words.
For expamles : if i put the input " Hotel"
it can throw "public house, resort, roadhouse, rooming house, scratch crib, spa, tavern"
like more near to these words....
Please help me to find the good algorithm.
Regards,
Clustering Data
Nov 5, 2007Dear sir,
thanks in advance
want your advice concerning this question,
i am trying to cluster some (numerical and categorical) data, i read that the EM clustering algorithm support data which follows normal distribution i assessed my data using MATLAB and found that there is no clear probability distribtion.
i think my data is mix of different distributions.
please, what i should do?
thank you
alsadek
Data Sequence In Tables, Please Help
Jul 8, 2007I'm new to sql server 2005. Previously I used Access. I've noticed that in sql server when a record is inserted into the database table, the data does not get entered sequentially. I looked at the id column and saw that the order numbers are mixed up. Is this something that is common in sql server, and how can I change this. I need the data to be ordered in the order that it was inserted into the database.
Can someone please help.
Add Sequence Number To Data
Sep 17, 2007
Hi all, I need some your help.
I want to add sequence number to data flow below:
Cust_Name | Month
=======================
Chonnathan | 5
Chonnathan | 4
Chonnathan | 7
Derec | 3
Derec | 9
and the result i need is:
SEQ_nbr | Cust_Name | Month
================================
1 | Chonnathan | 4
2 | Chonnathan | 5
3 | Chonnathan | 7
1 | Derec | 3
2 | Derec | 9
How can I do it in Integration Service to show like the above?
Thank you for your respones,
Chonnathan
Transact SQL :: Getting Sequence Data
Oct 27, 2015Please find the necessary SQL to create the table with sample data down below.In this simple table, I'm keeping project status logs i.e. what project, what happened and when.I want to create a select statement that will give me the ProjectId and the time stamps from "Contract Signed" to "First Meeting". So, I'd like my data to look like this:
ProjectId - FromStatus - FromTimeStamp - ToStatus - ToTimeStamp
123 Â - 'Contract Signed' - 6/21/2015 3:33PM - 'First Meeting' - 6/27/2015 8:45AM
456 Â - 'Contract Signed' - 6/25/2015 9:00AM - 'First Meeting' - 6/29/2015 2:50PM
987 Â - 'Contract Signed' - 9/29/2015 11:00AM - 'First Meeting' - 7/11/2015 10:00AM
Please notice that in my SELECT statement, I don't want to see anything else. For example, I don't want ProjectId: 555 included because it never made it to "First Meeting". I also don't want to see any information about "Press Release" for ProjectId: 123. I only want to see those projects that went from "Contract Signed" to "First Meeting".
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ProjectStatus](
[LogId] [int] NOT NULL,
[code]...
Transfer A Database From Non-clustering To Clustering Env.
Nov 13, 2007We 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.?
Sequence Execution At Data Flow Task ?
Apr 25, 2008
I have one Data flow, which trasfer data into two table (Parent & Child) .
My question is : Is there a way, i can load data first into parent and then child table. because child table getting load first after that parent table loading. (Execution should be Source Parent --> Destination Parent) First , (Source Child --> Destination Child) Second.
In my case its executing reverse. So i have foreign key constraints at child table , its giving foreign contraints error while running ssis package
Can any one tell me,
How to define my own sequence execution at the Data flow task (Source - Destination) ?
Thanks
Select Data Horizontally - Max Sequence Number May Vary
Sep 8, 2012I have the following table:
Policy Sequence LossDate Description Amt
123 1 9-1-2012 property 100
123 2 10-1-2012 property 200
345 1 9-1-2012 property 100
345 2 10-1-2012 property 100
678 1 9-1-2012 property 100
I want to select the data as follows:
Policy LossDate1 Description1 Amt1 LossDate2 Description2 Amt2
123 9-1-2012 property 100 10-1-2012 property 200
345 9-1-2012 property 100 10-1-2012 property 100
678 9-1-2012 property 100 NULL NULL NULL
Is there a way to do this using T-SQL?
The max sequence number can vary, so far the max has been 12, but may be higher in the future.
SSIS Sequence Container,data Flow Task
Nov 28, 2005I am creating a staging database in which I am loading required tables from 2 different sources.
I have 30 different tables to load from source 1 and 10 different tables from source 2.
This is the way I am doing, in Control flow task I am using Sequence container and in that I included the data flow task, the data flow task
has source OLD DB connection from where I select the table and then destination OLE DB connection where I load the data.
So for 30 tables I have one Sequence container with 30 different data flow task and each data flow task has OLE DB source and OLD DB destination.
I wanted to find out if this is the efficient way to do, or if there is any other way to do this.
And for source 2 shall I put in another package or shall I use the same package with different sequence container and follow the same steps
as for Source 1 tables.
Please advice.
Thanks,
Data Mining :: Updating Two Columns With Sequence Numbers With Where Clause
Jun 29, 2015I have a question  in SQL server. For example I have a table which has two column like following table and I don't know how can I update theses two column with identity numbers but just the fields which are equal 111.
Example table:
numez numhx
111 111
111 111
0 111
111 0
111 0
and my results should be:
numez numhx
1 2
3 4
0 5
6 0
7 0
How To Append A New Values Like Uniqueidentifiers, Sequence Numbers To Data Flow?
May 9, 2006Hi,
I would like to know different possible ways in appending extra values like new uniqueidentifiers, sequence numbers, random number. Can you please tell what type of data flow components helps us ?
Transact SQL :: How To Change Auto-sequence Numbers To Match Sorted Data
Jun 15, 2015I have a database that has entries that I want sorted by date order. Each entry has an auto ID number allocated (primary key auto sequencing), which I want to change to reflect the sorting (so the first date has the first auto ID number and so on).I've gone into the database and sorted the entries as I want them. Then I've gone into Design View to delete and restablish the primary key autosequence. However, it is not keeping the date order in the database (ie entry ID 3140 date is 12/06/2015, but 3141 is 02/02/2012). How do I get it to maintain the order?
View 3 Replies View RelatedClustering
Dec 4, 2000What is clustering?Why is it done?
Any suggestion appreciated.
Cheers!
SQL 7 Clustering
Sep 14, 1999I 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
SQL Clustering-NT Vs W2K?
Nov 20, 2001We 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
SQl Clustering
Oct 13, 2005I 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!!
Clustering
Mar 19, 2001Can 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 RelatedClustering
Feb 14, 2005I 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