Database Discussion Boards

Member 467943628-Jan-09 23:10

28-Jan-09 23:10

Hello Friends,

How to create DFD for my project documents.

My project definition is Inventory System.

Please help me.

Thanks in advance.

Pin

Re: How to create DFD

Wendelius29-Jan-09 4:03

Wendelius

29-Jan-09 4:03

I'm curious, what's DFD? Data Flow Diagram?

The need to optimize rises from a bad design.My articles[^]

Re: How to create DFD

Member 467943629-Jan-09 20:23

Member 4679436

29-Jan-09 20:23

DFD Stands for Data Flow Diagram.

It is one kind of Graphical Representation of the flow of Data in Project.

For example my project is about Inventory Management System.

In My project there is :
Stock - inward
Stock - Outward
Customer
Suppliers
Bank
Order process
etc...

how to represent this using Data Flow Diagram. (dfd 1.0, 2.0...)

Please help me,

Thanks in advance.
Pin

Re: How to create DFD

Wendelius30-Jan-09 7:46

Wendelius

30-Jan-09 7:46

So could you use this: Creating Package Data Flow[^] or do you need to model database tables for describing a data flow.

The need to optimize rises from a bad design.My articles[^]

Re: How to create DFD

RC_Sebastien_C29-Jan-09 14:53

RC_Sebastien_C

29-Jan-09 14:53

Please clarify your question

"It reads like a B3 page (and for those who don't know what B3 is, it means bullsh*t Baffles Brains)" - Pete O'Hanlon

Re: How to create DFD

Member 467943629-Jan-09 20:25

Member 4679436

29-Jan-09 20:25

DFD Stands for Data Flow Diagram.

It is one kind of Graphical Representation of the flow of Data in Project.

my project is about Inventory Management System.

In My project module is :
Stock - inward
Stock - Outward
Customer
Suppliers
Bank
etc...

how to represent this using Data Flow Diagram. (dfd 1.0, 2.0...)

Please help me,

Thanks in advance.
Pin

Re: How to create DFD

Ashfield29-Jan-09 21:06

Ashfield

29-Jan-09 21:06

And it sounds like a homework question. Ask your tutor or read a book. you never learn if someone else does it for you.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: How to create DFD

Member 467943629-Jan-09 22:35

Member 4679436

29-Jan-09 22:35

You are absolutely right.

refer any site(if u have any) from which i can get basic idea.

thanks for your reply.
Pin

Aman786Singh28-Jan-09 20:34

Aman786Singh

28-Jan-09 20:34

Kindly Let Me know the maximum Value which is recommended for the rows in a particular table.
Some of my tables have more than 60 lakhs rows..
Kindly Suggest??????????

Thanks in Advance...

Ashfield28-Jan-09 21:14

Ashfield

28-Jan-09 21:14

There is no real limit, it is all dependant on disk space and hardware performance. You may want to look at partitioned tables for performance. Also when you get to these volumes of data indexing is crucial.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

PIEBALDconsult29-Jan-09 5:43

PIEBALDconsult

29-Jan-09 5:43

As many as you need, and no more.

Member 467943629-Jan-09 23:19

Member 4679436

29-Jan-09 23:19

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Lookups

Mustafa Ismail Mustafa28-Jan-09 1:18

Mustafa Ismail Mustafa

28-Jan-09 1:18

I have several multi-selection options and its becoming a pain to handle them in a n-n fashion, does SQL2K5 offer an alternative that I might use?

I'll give you an example. I have a patient and a patient can have several symptoms.

This would be the exact opposite of sending an array to the database, it'll be bringing back an array.

Don't forget to vote if the response was helpful

Sig history

"dad" Ishmail-Samuel Mustafa

Unix is a Four Letter Word, and Vi is a Two Letter Abbreviation

Re: Lookups

Wendelius28-Jan-09 1:28

Wendelius

28-Jan-09 1:28

So you have tables like the following?
Patient
- PatientId (PK)
- Name

Symptom
- SymptomId (PK)
- Description

PatientSymptom
- PatientId (FK)
- SymptomId (FK)

If so, what's the biggest pain in this?

The need to optimize rises from a bad design.My articles[^]

Re: Lookups

Mustafa Ismail Mustafa28-Jan-09 1:33

Mustafa Ismail Mustafa

28-Jan-09 1:33

That is exactly how it is only you would have a "versioning" of it for the patient. So that for each admittance (the one you helped me out with this morning Smile | :)

) the patient can and most likely will have different symptoms. I just find it painful that it has to go like this, it sorta like sawing against the grain. Implementation wise its not difficult and one can easily knock up a view to end up with a comma separated list of symptoms.

I don't know, I guess I'm just complaining.

Don't forget to vote if the response was helpful

Sig history

"dad" Ishmail-Samuel Mustafa

Unix is a Four Letter Word, and Vi is a Two Letter Abbreviation

Re: Lookups

Wendelius28-Jan-09 1:42

Wendelius

28-Jan-09 1:42

Could you post any example what operation is painful or is it querying or something else? That would help to understand the problems and to give suggestions.

Based on our previous conversation I understood that you don't use surrogate keys (identity for example). If that's correct, perhaps the problems are related to that.

The need to optimize rises from a bad design.My articles[^]

Re: Lookups

Mustafa Ismail Mustafa28-Jan-09 2:27

Mustafa Ismail Mustafa

28-Jan-09 2:27

I'm just whining because I had little sleep last night. My baby son is teething.

Don't forget to vote if the response was helpful

Sig history

"dad" Ishmail-Samuel Mustafa

Unix is a Four Letter Word, and Vi is a Two Letter Abbreviation

Re: Lookups

Wendelius28-Jan-09 2:53

Wendelius

28-Jan-09 2:53

Mustafa Ismail Mustafa wrote:
My baby son is teething

I remember those nights. Luckily it was always one or two nights at a time with both of my kids. If it helps you in anyway, it goes over soon. And then again if you start counting the good sides and the bad sides of having children, there's no question which count is higher Smile | :)

I wish you strength and hopefully you get a good night sleep after this day. Perhaps we continue searching another data modeling solution for you another day Smile | :)

The need to optimize rises from a bad design.My articles[^]

Re: Lookups

Mustafa Ismail Mustafa28-Jan-09 2:55

Mustafa Ismail Mustafa

28-Jan-09 2:55

Yeah, he's a bundle of joy alright when the poor kid is not in pain.

Don't forget to vote if the response was helpful

Sig history

"dad" Ishmail-Samuel Mustafa

Unix is a Four Letter Word, and Vi is a Two Letter Abbreviation

Re: Lookups

Luc Pattyn28-Jan-09 5:06

Luc Pattyn

28-Jan-09 5:06

Mika Wendelius wrote:
what's the biggest pain in this?

(patient=OP, symptom=Headache) Big Grin | :-D

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Re: Lookups

Wendelius28-Jan-09 5:35

Wendelius

28-Jan-09 5:35

It took me awhile to get this since I had completely forgotten the context... After reading the original post I got it. Think I'm Sleepy | :zzz:

The need to optimize rises from a bad design.My articles[^]

To get the current value for SORT_IN_TEMPDB

Arun Abraham Jose27-Jan-09 18:59

Arun Abraham Jose

27-Jan-09 18:59

I would like to rebuild the indexes of my database by using the query 'ALTER INDEX ALL'. With this I would like to set the option SORT_IN_TEMPDB to ON. But before that I want to know the value set for this particular flag in the table indexes. How can I get the current value of this flag?

I tried using the tables like sys.indexes, sys.stats, sys.schemas etc but miserably failed.

Please advice

With Regards,

Abraham Chethuvelil

Re: To get the current value for SORT_IN_TEMPDB

Wendelius27-Jan-09 19:42

Wendelius

27-Jan-09 19:42

AFAIK this information isn't stored when index is created or recreated.

The need to optimize rises from a bad design.My articles[^]

Re: To get the current value for SORT_IN_TEMPDB

Arun Abraham Jose30-Jan-09 0:33

Arun Abraham Jose

30-Jan-09 0:33

Hi,

Then how do we know what is the value for this flag?

I want to set it on in our database now but I am not sure whether the people who created or maintained this database before were already set it or not?

Another doubt regarding setting this flag is that, will it cause any issues in the future w.r.t. Size or performance and w.r.t. Tempdb as well?

With Regards,

Abraham Chethuvelil

Re: To get the current value for SORT_IN_TEMPDB

Wendelius30-Jan-09 7:27

Wendelius

30-Jan-09 7:27

Arun Abraham Jose wrote:
Then how do we know what is the value for this flag

I don't think it's possible to say afterwards if an index is created with SORT_IN_TEMPDB On or Off. Since this option affects only when the index is created, it isn't necessary information for SQL Server when index is used.

Arun Abraham Jose wrote:
I want to set it on in our database now but I am not sure whether the people who created or maintained this database before were already set it or not

Since this isn't found in the system tables the only thing that comes in mind is that you create a standard that you add an extended property to your indexes. In this property you can document what option was used when the index was created.

Property can be set for example like this:

EXEC sys.sp_addextendedproperty 
       @name=N'SORT_IN_TEMPDB', 
       @value=N'True' , 
       @level0type=N'SCHEMA',
       @level0name=N'DatabaseName', 
       @level1type=N'TABLE',
       @level1name=N'TableName', 
       @level2type=N'INDEX',
       @level2name='IndexName'

After adding this property you can see it's value in system tables and in Management Studio.

Arun Abraham Jose wrote:
Another doubt regarding setting this flag is that, will it cause any issues in the future w.r.t. Size or performance and w.r.t. Tempdb as well?

SORT_IN_TEMPDB affects only index creation. It does not affect how the index behaves after creation so it's creation time option only.

The need to optimize rises from a bad design.My articles[^]

Last Visit: 31-Dec-99 18:00 Last Update: 30-Apr-24 18:27

Refresh

ᐊ Prev 1...922 923 924 925926927 928 929 930 931 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.