Introduction to SamplingDB

What is SamplingDB?

SamplingDB is the database backend for SamplingXL on Microsoft SQL Server.

It defines the basic Sampling objects:

SampleSheet

SampleSheetType

as well as other support objects like SampleSection etcetera.

SamplingDB allows one to perform Assay updates and extracts directly on the database. In fact many bulk operations on SampleSheets can be done right in the database without using any front end.

Sample sheets are stored as SQL Server User Defined Types. This is for performance reasons and accessibility reasons. However this does not mean that the data is locked in.

The UTD's have methods to export all the objects into XML for easy integration and backup to external systems.