Database

Re: Batch reporting framework for Oracle databases. Needed?

29-May-12 0:54

Dmitri Novikov wrote:
Is there a need for such an application? Will be there any sense to maintain and
develop it? Try to sell it?

Write an article explaining how it works, and you'll get answers to these questions Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

Dmitri Novikov29-May-12 8:22

Dmitri Novikov

29-May-12 8:22

Eddy, a rather good proposal! But If I publish an article at CodeProject, don't I have to publish also the source files of this application?

Re: Batch reporting framework for Oracle databases. Needed?

Eddy Vluggen29-May-12 8:51

Re: Batch reporting framework for Oracle databases. Needed?

29-May-12 8:51

I have seen some articles without an associated download. On the other hand, if the app is commercial, it might be seen as "advertising".

Spend a day Googeling for commercial alternatives to your app. If there's more than three, there's probably a market. If there's not, there still might be one.

Bastard Programmer from Hell Suspicious | :suss:

Dmitri Novikov29-May-12 9:35

Dmitri Novikov

29-May-12 9:35

Yet, I can't decide whether it can be done as commercial. Maybe a point will be in maintaining both commercial and freeware version. I'll think about posting an article, I will not be able to post it until the weekend.

The first version of my program was written in old 2005 Smile | :)

I investigated the area that days and found nothing I could use to do the job I neeeded for free. But the time passed, things might have changed. You're right, I need to do the investigation nowadays also.

If someone else will post answers here, I will be greatful!

Database driven Controls

mauricemcse25-May-12 3:27

mauricemcse

25-May-12 3:27

Following the Head First eBook on C# development. The current chapter requires controls for a small contacts database already created. It should be a matter of dragging the form, then the database on to the IDE. Have not been able to do so after several attempts. Seeking guidance on how to get this done. Images are uploaded to the link below.

https://skydrive.live.com/redir?resid=52B21D2F3F75A51A!1222[^]

Much thanks for guidance

Re: Database driven Controls

Corporal Agarn27-May-12 1:58

Corporal Agarn

27-May-12 1:58

This may be better asked in the C# forum. The biggest hurdle to database access is the security. Once you have solved that them it becomes more of a C# problem of object typing.

Linking ITS Typing Test System to database

abhijitp8422-May-12 23:01

abhijitp84

22-May-12 23:01

i need to create a login interface and link ITS Typing Test System to a database to capture following:

1. Name (new field, to be created in login interface)
2. (document.JobOp.typed.value.replace(/ /g, " ").split(" ").length)
3. totalTime
4. wpmType
5. aftReport

Re: Linking ITS Typing Test System to database

Mycroft Holmes23-May-12 13:00

Mycroft Holmes

23-May-12 13:00

And your question is?

Never underestimate the power of human stupidity
RAH

SQL Query Issue

Nayan Ambaliya22-May-12 19:09

Nayan Ambaliya

22-May-12 19:09

Dear all,

I have this sort of weird question in terms of sql data and query.

Consider the dataset below. I have this results in to a table variable (SQL 2008)

SQL

EmailAddress          ID
----------------------------
abc@test.com          1000
def@test.com          1001
ppp@test.com          1002
iii@test.com          1002
ttt@test.com          1000
----------------------------

Now, what I want out of this table variable is the below result

SQL

EmailAddress          ID
----------------------------
abc@test.com          1000
def@test.com          1001
ppp@test.com          1002
----------------------------

What I want is to have first available unique ID and their email address. Can anyone please write a query or direct me.

Thanks.

Mycroft Holmes22-May-12 22:36

Mycroft Holmes

22-May-12 22:36

There are a number of solutions to this one.

Use a sub query select the top 1 from table order by ID

Or you can use the Row_Number() and partition grouped and ordered by the ID and an outer query that selected row 1 for each ID.

There is also a CTE solution I have seen posted but don't know the details.

Never underestimate the power of human stupidity
RAH

vvashishta24-May-12 23:44

vvashishta

24-May-12 23:44

You can do this by using Row_Number functionality with 'Partition By' on ID Column.
Then put in Where Claue with condition as RowNum =1.

- Happy Coding -
Vishal Vashishta

Eddy Vluggen25-May-12 0:01

25-May-12 0:01

SQL

SELECT ID, MIN(EmailAddress)
  FROM TEST
 GROUP BY ID

Bastard Programmer from Hell Suspicious | :suss:

Pete O'Hanlon25-May-12 0:22

Pete O'Hanlon

25-May-12 0:22

Are you sure you've got that query right?

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Eddy Vluggen25-May-12 0:25

25-May-12 0:25

Is there are reason that you want me to doubt the post?

Bastard Programmer from Hell Suspicious | :suss:

Pete O'Hanlon25-May-12 1:23

Pete O'Hanlon

25-May-12 1:23

Look at the field in the min as a hint.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Eddy Vluggen25-May-12 1:28

Could anyone recommend an interactive application for mass data analysis?

25-May-12 1:28

I did. He wants the ID's unique, and the first mailadress for that ID.

Did I miss something? Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

bestbird778822-May-12 16:24

Re: Could anyone recommend an interactive application for mass data analysis?

22-May-12 16:24

Hi, everybody
I need to conduct a large amount of data analysis on database. Could anyone recommend an interactive application for data analysis?
The requirements are:
1. Able to cope with the unexpected requirement rapidly.
2. Able to perform further computations on results interactively (base on the mass data).
3. Easy to confront even a large amount of complex computations
What would you great expert recommend?
Thanks in advance.

Eddy Vluggen23-May-12 0:30

Re: Could anyone recommend an interactive application for mass data analysis?

23-May-12 0:30

Microsoft Excel and Sql Server. Those are the most-used all-purpose tools to do what you want. You can adapt using VBScript if Excel if those requirements change.

Most data-mining applications are written to mine for specific stuff.

Bastard Programmer from Hell Suspicious | :suss:

bestbird778823-May-12 20:56

Re: Could anyone recommend an interactive application for mass data analysis?

23-May-12 20:56

Thank you for reply.
SQl lacks stepwise computation ablility, so It is not a ideal solution. What I mean about stepwise is:
1. In excel, I can write number "10" in A1 cell, then formula "=A1*5" in A2 cell. then formula "=A2+2" in A3 cell. A1->A2->A3, It's stepwise.
2. When I change 10 to 9 in A1, then result in A2 and A3 will changed automatic.
3. an example: a. to select out the 10 categories of best sellers b. as a further computation on the basis of result from a., to select out the top 20 products from each category, c. as a further comparison with that of the last year based on the result from a.
let's call SQL_A,SQL_B,SQL_C as SQL statements for a,b,c. when I changed SQL_A (for example change 10 categories to 9 categories ), I must change SQL_B and SQL_C. why? because SQL_B and SQL_C is based on SQL_A. that is, SQL_B may like:

with SQL_A as A

selet.......

Excel has another problem, It is too simple to process mass data analysis. for example, to compute the product whose annual sales values are all among the top 100.
data structure( sales table's fields): productID, time, value .
the sql solution is:

SQL

WITH sales1 AS (
 SELECT productID, YEAR(time) AS year, SUM(value) AS value1
 FROM sales
 GROUP BY productID, YEAR(time)
)
SELECT productID
FROM (
 SELECT productID
 FROM (
 SELECT productID,RANK() OVER(PARTITION BY year ORDER BY value1 DESC) rankorder
FROM sales1 ) T1
 WHERE rankorder<=100) T2
GROUP BY productID
HAVING COUNT(*)=(SELECT COUNT(DISTINCT year ) FROM sales1)

above code is hard to write in Excel.
So what I want is some like SQL + Excel, do you have some idea?

Eddy Vluggen24-May-12 0:26

Re: Could anyone recommend an interactive application for mass data analysis?

24-May-12 0:26

bestbird7788 wrote:
So what I want is some like SQL + Excel, do you have some idea?

Use Sql and Excel.

bestbird7788 wrote:
above code is hard to write in Excel.

It is. I'd suggest writing it in Sql, as a stored procedure.

bestbird7788 wrote:
Excel has another problem, It is too simple to process mass data analysis.

It's one of the most advanced spreadsheets that I know. Alternatively, you could check out DMTL[^].

Bastard Programmer from Hell Suspicious | :suss:

bestbird778824-May-12 16:53

Re: Could anyone recommend an interactive application for mass data analysis?

24-May-12 16:53

you are so funny Big Grin | :-D

I mean SQL+Excel in one tools, not one of them or both of them.

I will check DMTL, It seems like what I want. but I'm not sure does DMTL have stepwise ablility like excel? It seems just a code library. I should take a deeper research.
BTW, does DMTL support computing data with multiple dataset, just as join statement in SQL. Under my impression, other data mining tools can only work on one dataset.

thank you in advance!

Eddy Vluggen25-May-12 0:04

Re: Could anyone recommend an interactive application for mass data analysis?

25-May-12 0:04

bestbird7788 wrote:
you are so funny

I was not joking.

bestbird7788 wrote:
I mean SQL+Excel in one tools, not one of them or both of them.

You can use Sql Server to prepare the dataset (and yes, it can operate on the previous record), and Excel to visualize that data.

bestbird7788 wrote:
I'm not sure does DMTL

Neither do I. Never needed anything beyond the two tools I already named.

Bastard Programmer from Hell Suspicious | :suss:

bestbird778827-May-12 23:16

Re: Could anyone recommend an interactive application for mass data analysis?

27-May-12 23:16

hi,thank you for your suggestion.

this line:
You can use Sql Server to prepare the dataset (and yes, it can operate on the previous record), and Excel to visualize that data.
------------------------------------
look at this scene:
1. I use sql to get some data, filled them in Excel, called it dataset1.
2. In Excel, I made some computation, then I got dataset2.
3. I need join the dataset2 with a table in database to generate dataset3.

how to do? creat a new table in database, fill dataset2 to database? and run join statment? then fill dataset3 to Excel? No, It's a big trouble.

so I need a tools like SQL+Excel.

Eddy Vluggen28-May-12 1:25