This is a discussion on (MySQL) Newbie design question within the MySQL Database forums, part of the Database Forums category; Raven wrote: > I need to develop a MySQL database for a data logging application. This > would be easy ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Raven wrote:
> I need to develop a MySQL database for a data logging application. This > would be easy if I just had one data logger but I need a scalable solution > that can support hundreds if not thousands of loggers. Basically each logger > has anywhere from 1 to 32 channels. Data will be sent directly to the web > server from the loggers every minute. There will be other features like > alarms, set points etc. The database is going to get big very fast. I need a > good efficient structure. Can anyone offer suggestions or pointers? > > Thanks > > > Google for "Database Normalization". Most good database designs are around 3rd normal form (3NF). -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ================== |
|
|||
|
I need to develop a MySQL database for a data logging application. This
would be easy if I just had one data logger but I need a scalable solution that can support hundreds if not thousands of loggers. Basically each logger has anywhere from 1 to 32 channels. Data will be sent directly to the web server from the loggers every minute. There will be other features like alarms, set points etc. The database is going to get big very fast. I need a good efficient structure. Can anyone offer suggestions or pointers? Thanks |