all groups > sql server data mining > july 2003
How to know a database is available for connection
Posted by John Xu at 7/31/2003 1:38:37 PM
I want to check if a database server is listening for
connection before to connect to this database server. I
heard that Weblogic comes with a class called
java.util.dbping which does this. However, I am not sure
whether other lagnuages have a similar one. To make it
short, I am looking fo... more >>
How can I understand that there is an online backup now?
Posted by Fatih. at 7/31/2003 6:30:05 AM
Hi. I was searching which table in msdb database holds the
information of "backup session started" or is this data
written to somewhere?
Thanks in advance.... more >>
How to use data mining tools in SQL Server 2000?
Posted by Kyle at 7/29/2003 9:20:42 PM
I know there are some data mining tools which can be used in SQL Server
2000, but I don't know what they are? Could any one tell me
what the tools are and how to use them in SQL Server 2000, eg. how to
install, anything I must notice in configeration and so on.
Thanks a lot.
... more >>
couldn't get the list of data mining algorithms
Posted by P.W. at 7/28/2003 6:03:31 PM
Hi,
I am trying to perform some data mining tasks on SQL
server 2000. I installed the Analysis Manager and
registered server. Then, I created a new database and
created the data source. After that, I launched the Mining
Model Wizard, selected the Relation Database and saw the
tables tha... more >>
Someone can tell me the outlook of Datamining now?
Posted by Kyle at 7/27/2003 8:42:06 PM
I am a freshman to data mining. Could anyone tell me the outlook of
dataming now?
I want to know the application of data mining and I want to know whether
there are tools, including any demo software or any api , can help me study
data mining?
Are there any websites have the latest ... more >>
simple query
Posted by Al G. at 7/24/2003 10:51:02 AM
I am trying to write a SQL Statement that will return a
recordset of the last updated records for a given status.
Can anyone help?
For example in the data below I want to return the latest
open statuses and should get 2 records: Order 1 Open
1/5/03 and Order 2 Open 2/4/03.
Order Status... more >>
Datasets for clustering & classification
Posted by John Sandiford at 7/24/2003 2:28:53 AM
Hi, I am trying to find datasets for Data Mining, with a
mixture of continuous and discrete attributes, which have
well known clustering or classification results. I am
aware of the UCI repository, but would really appreciate
any information on others.
Thanks for any help
John Sandifo... more >>
SQL Sum Query
Posted by Peter Newman at 7/17/2003 4:32:24 AM
I am trying to do a complicated count query and need some
assistance
Table 1 contains a the nomanal codes and discriptions of
our account types ( approx 40 records )
Table 2 contains all the transactions recieved from our
customers.
select * from Table1 a, Table2 b
where (b.ACCY... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Data mining model for Finding products sold togeter
Posted by John Jayaseelan at 7/7/2003 7:10:30 AM
Hi,
Sales transaction containing columns(product,month & year of sales,sale
price) are available. Please tell how to identify the products sold
together. How the minning model needs to built using which algorthim?
Thanks
John Jayaseealn
*** Sent via Developersdex http://www.developersdex... more >>
Query ntext fields
Posted by Charles at 7/4/2003 6:45:40 AM
Hi there,
I=B4m trying to export a "ntext" field in which I have=20
stored notes (a lot of text). I'm using the Query=20
Analizer, but the select command only returns the first=20
line of the text in each field. It seems that when an=20
enter is found it just finishes displaying the text of=2... more >>
sequence number in a view
Posted by Max at 7/3/2003 9:10:44 AM
Hi folks,
I' like to display a sequence number in a view, something
like:
Name SeqNo
==== =====
John 10
Peter 20
Mary 30
Does anyone know how to generate a sequence number?
Best Regards,
Max.
... more >>
error in DTS mining analysis task
Posted by Ken England at 7/3/2003 12:18:18 AM
Hi,
I'm trying to process a relational data mining model in
the DTS Analysis Processing Task. I have already created
and trained the model using the Analysis Manager interface
with no problems. However, when I try and execute the DTS
task I get:
Invalid rectangle. Cannot save object i... more >>
How can I use ASP to represent the DM results of analysis services.
Posted by WebDB at 7/2/2003 6:42:19 PM
hi, everyone,
I want to use ASP to represent the results of decision tree, etc. How can I
do it?
Thanks.
... more >>
Table design
Posted by Shamim at 7/2/2003 11:24:35 AM
SQL 2K
I am creating a table for holding data used for data wear-housing project.
This table will eventually going to have millions of records.
Planned to have a primary key and proper indexing in this table.
This table will be queried against various columns and will be refreshed
(fill data)... more >>
Accessing the List of Olap databases from Analysis server
Posted by John Jayaseelan at 7/2/2003 10:26:22 AM
Hi,
The following (VB.NET) code is used to access the list of Olap databases
from Analysis server. It only select one database, even that is not the
first database in the Analysis server. Please tell why and what change
in the code required.
______________
DC1 = New ADODB.Connectio... more >>
|