MySQL Forums
Forum List  »  MySQL Workbench

Re: Database design for scientific tests
Posted by: Martin Karm
Date: June 25, 2009 02:01PM

Each test will track different data. Total there are probably 20-30 different possible data types with 5 or so applying to each test (occasionally some overlap, two different tests may track temperature or something). The front end software can deal with finding the right columns, I suppose.

The only issue with one giant table I see is that there will be a lot of nulls. This may not be a bad thing, though.

Options: ReplyQuote

Written By
Re: Database design for scientific tests
June 25, 2009 02:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.