Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 db design help

Author  Topic 

abk
Starting Member

29 Posts

Posted - 2012-03-20 : 02:40:49
I want to design a db which will store raw packets of data from many devices. The method and the format of raw data varies . The client app must read data and parse them . I want a good db schema which will store the info and will be have good ER relationship. It must be fast while inserting and querying . I am new to db design and any help will be good.

Thanks

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-20 : 02:48:57
Describe the "Things" That you will have. Do you have any sample Data.

Usually I collect all data elements first (attributes/Fields/Columns).

Then I place them in unique containers (Entities/Tables) that they make sense to belong to

Then I establish relationships between those containers

So...Whatcha got?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

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

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

abk
Starting Member

29 Posts

Posted - 2012-03-20 : 05:17:42
The devices are GPS devices and will send packets of info in different formats. What db structure would be useful ?

basically I want devices and their packets of data in a ER

Thanks
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-20 : 09:51:10
Please describe the data that you will be receiving

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

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

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -