Is this right if i will do my project this way?..

Question

Is this right if i will do my project this way?..

enriquezreyjoseph

Ten Centuries

Points: 1291
More actions
October 1, 2013 at 9:51 pm

#298429

Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

What kind of project is this?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Normally you'd go a lot further into the design phase before considering physical implementations.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Brandie Tarvin SSC Guru Points: 172991 More actions · Answer 3

Your picture doesn't give a lot of detail and your question is just as vague. What do you define "right" as? What are you trying to accomplish?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 4

enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment

If it's strictly an ETL project, maybe. Otherwise, probably not.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

To me it looks like all of the arrows are going in the wrong direction.

You have a class that populates a dataset and that class also gets shipped off to a server.

It looks like there is nothing being done with the dataset.

With nothing being done by the dataset and the apparent misdirection of the arrows (assuming), I would say it looks completely wrong.

Then again, we have no real project requirements to make any determinations of right or wrong.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

enriquezreyjoseph Ten Centuries Points: 1291 More actions · Answer 6

SQLRNNR (10/2/2013)
To me it looks like all of the arrows are going in the wrong direction.
You have a class that populates a dataset and that class also gets shipped off to a server.
It looks like there is nothing being done with the dataset.
With nothing being done by the dataset and the apparent misdirection of the arrows (assuming), I would say it looks completely wrong.
Then again, we have no real project requirements to make any determinations of right or wrong.

SQLRNNR...i think you are the only one who get it right...thanks for the advise my friend:-)

enriquezreyjoseph Ten Centuries Points: 1291 More actions · Answer 7

my classes contains a connectionString to a different server, because every server contains a different databases, so meaning in every classes i have different connectionString that will open the connection to a certain database....and mydataset contains all tables in a certain database...

Is this clear explaination? or should i elaborate more my friends(ladys and gentlemen) ?....

cheers 🙂

enriquezreyjoseph Ten Centuries Points: 1291 More actions · Answer 8

Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.

What do you mean ETL project??...

"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.
What do you mean ETL project??...
"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan

ETL - Extract, Transform, Load

Usually done when moving data from OLTP databases to DW databases.

Brandie Tarvin SSC Guru Points: 172991 More actions · Answer 10

enriquezreyjoseph (10/2/2013)
my classes contains a connectionString to a different server, because every server contains a different databases, so meaning in every classes i have different connectionString that will open the connection to a certain database....and mydataset contains all tables in a certain database...

Given this information, I think the graph is seriously wrong. Either each class leads to a server and a set of tables within that server's database, or you have 3 classes acting upon one database's information and then sending information to two other servers.

How well do you know the data? And what exactly are you trying to do here, because your explanation doesn't tell us what you're doing. It just tells us a very generalized layout.

And why do you need classes to point to a dataset anyway? You should be able to derive a dataset independently of the class. The class should only define what to do with that data once you have it.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 11

Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.
What do you mean ETL project??...
"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan
ETL - Extract, Transform, Load
Usually done when moving data from OLTP databases to DW databases.

Or moving data from external sources to databases.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Brandie Tarvin SSC Guru Points: 172991 More actions · Answer 12

Jeff Moden (10/3/2013)
Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.
What do you mean ETL project??...
"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan
ETL - Extract, Transform, Load
Usually done when moving data from OLTP databases to DW databases.
Or moving data from external sources to databases.

Or moving data from databases to external sources.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 13

Brandie Tarvin (10/3/2013)
Jeff Moden (10/3/2013)
Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.
What do you mean ETL project??...
"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan
ETL - Extract, Transform, Load
Usually done when moving data from OLTP databases to DW databases.
Or moving data from external sources to databases.
Or moving data from databases to external sources.

Or moving data from external sources to external sources 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

enriquezreyjoseph Ten Centuries Points: 1291 More actions · Answer 14

Koen Verbeeck (10/3/2013)
Brandie Tarvin (10/3/2013)
Jeff Moden (10/3/2013)
Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.
What do you mean ETL project??...
"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan
ETL - Extract, Transform, Load
Usually done when moving data from OLTP databases to DW databases.
Or moving data from external sources to databases.
Or moving data from databases to external sources.
Or moving data from external sources to external sources 😀

huh??...