Click here to Skip to main content
15,899,679 members
Home / Discussions / C#
   

C#

 
GeneralLaboratory Data Program in C# Pin
dr4davis7-Jun-05 9:37
dr4davis7-Jun-05 9:37 
GeneralRe: Laboratory Data Program in C# Pin
Christian Graus7-Jun-05 12:31
protectorChristian Graus7-Jun-05 12:31 
GeneralRe: Laboratory Data Program in C# Pin
dr4davis7-Jun-05 14:55
dr4davis7-Jun-05 14:55 
GeneralRe: Laboratory Data Program in C# Pin
Christian Graus7-Jun-05 14:58
protectorChristian Graus7-Jun-05 14:58 
GeneralRe: Laboratory Data Program in C# Pin
dr4davis7-Jun-05 17:08
dr4davis7-Jun-05 17:08 
GeneralRe: Laboratory Data Program in C# Pin
Scott Serl7-Jun-05 15:10
Scott Serl7-Jun-05 15:10 
GeneralRe: Laboratory Data Program in C# Pin
dr4davis7-Jun-05 17:03
dr4davis7-Jun-05 17:03 
GeneralRe: Laboratory Data Program in C# Pin
Scott Serl7-Jun-05 18:40
Scott Serl7-Jun-05 18:40 
I did that to really simplify the design. A nvarchar(in ms sql server) will not take up much space if unused, that way you can keep all results in the same table. Most LIMS work I have done has been in the environmental and bioanalytical fields. I have never had results that were text, therefore, I would expect the TextResult field to usually be blank.

It could be done with 2 tables, but the added complexity for the extra indirection could be avoided. If most of the results will be float, then there is very little waste of space. It's just a design decision for which I have too little information to make a call.

A commercial LIMS would have a table structure closer to the example I gave than what yours is like. The reason is flexibility (a commercial product has to meet more general needs). It makes adding new things easier(new tests, new materials, etc.), but requires more complex queries to get back the result data(joining data from Samples, Materials, Results, TestCodes just to get a report). As long as the database is designed well, a 7 table join can pull data from a multi million row database in a second or two, but if not well designed, could take 20 or more seconds.
In the end, if its working now, just go with it! If you have the time and want to play with a new design, go ahead, but please make sure you don't try anything on the live database; make a new database for your redesign efforts.

GeneralPassing Data to SQL Server Pin
noneformenoneforme7-Jun-05 9:35
noneformenoneforme7-Jun-05 9:35 
GeneralRe: Passing Data to SQL Server Pin
Jon Sagara7-Jun-05 10:18
Jon Sagara7-Jun-05 10:18 
GeneralString problem Pin
Tom Wright7-Jun-05 8:41
Tom Wright7-Jun-05 8:41 
GeneralRe: String problem Pin
Carsten Zeumer7-Jun-05 8:48
Carsten Zeumer7-Jun-05 8:48 
GeneralRe: String problem Pin
Tom Wright7-Jun-05 12:31
Tom Wright7-Jun-05 12:31 
GeneralMonth Calendars Pin
scotlandc7-Jun-05 7:28
scotlandc7-Jun-05 7:28 
GeneralRe: Month Calendars Pin
Alex Korchemniy7-Jun-05 13:59
Alex Korchemniy7-Jun-05 13:59 
GeneralRe: Month Calendars Pin
scotlandc7-Jun-05 21:59
scotlandc7-Jun-05 21:59 
GeneralInherit Tree View property problem! Pin
drey17-Jun-05 7:00
drey17-Jun-05 7:00 
GeneralRe: Inherit Tree View property problem! Pin
Carsten Zeumer7-Jun-05 8:52
Carsten Zeumer7-Jun-05 8:52 
GeneralRe: Inherit Tree View property problem! Pin
drey17-Jun-05 10:56
drey17-Jun-05 10:56 
Generalusing MS Word as mail Editor like outlook : C# Pin
parviz_rashidi7-Jun-05 6:35
parviz_rashidi7-Jun-05 6:35 
GeneralRe: using MS Word as mail Editor like outlook : C# Pin
Alex Korchemniy7-Jun-05 14:08
Alex Korchemniy7-Jun-05 14:08 
GeneralRe: using MS Word as mail Editor like outlook : C# Pin
Anonymous7-Jun-05 19:33
Anonymous7-Jun-05 19:33 
GeneralRe: using MS Word as mail Editor like outlook : C# Pin
Alex Korchemniy7-Jun-05 20:52
Alex Korchemniy7-Jun-05 20:52 
GeneralDataSet and Date in PostgreSQL Pin
sanfacio7-Jun-05 5:40
sanfacio7-Jun-05 5:40 
GeneralVisual Studio Debugger Pin
MarkMokris7-Jun-05 5:07
MarkMokris7-Jun-05 5:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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