Specifications

History
Development tools
LIMS Architecture
System specification (Hardware and Software)
Database connection
Data transfer (exporting)

History

Online LIMS started in 1988 with a UNIX based LIMS. Two years later, Online LIMS was rewritten as a DOS based client for Novell networks.

The new Windows version of Online LIMS, Online LIMS OnREPO and OnSAMPLE had to compete against Online's successful DOS version. This new version was completely rewritten and incorporates all of the well defined and proven concepts of the previous DOS version. A lot of time was spent on the database structure and query design resulting in a very fast and efficient LIMS.

Online LIMS has been active in Germany, Canada, US, Chile, Peru, Brazil, South Africa and UK.

1989 Online LIMS 1.0, UNIX based system
1992 DOS LIMS 2.0, Novell network
1993 DOS LIMS 3.1
1994 DOS LIMS 4.2
1996 LmView, Win32 SDK App for LIMS 4.2
1998 Online Worksheet 5.0
1999 Online LIMS Y2K 4.5 (DOS/Win32)
2000 Online LIMS OnRepo 5.0
2001 Online LIMS OnRepo 5.2
2002 OnSample, Sample oriented
2003 Web LIMS
2007 Online LIMS OnLab 7.2

Development

Online LIMS SE was developed using Microsoft C++ and MFC. These are state of the art tools for Object Oriented Software development. The result is a compact and very efficient program code (true Win32), optimized for speed and network traffic.

Language C++, MFC
Development Tool MS Visual Studio
Grid Stingray
Printing VPE
XML Standard 5.0
Number system LFL Maskot

Architecture

The Online LIMS SE application is divided in five modules. These modules can be grouped into two main groups:
  1. Production: reporting and statistics, management
  2. Laboratory bench: Worksheet and QA/QC

Online LIMS has a client server architecture and can use either MS SQL Server or Oracle for the database engine.

Worksheets and instrument raw data are stored in flat files, this allows for additional flexibility and backup.

The small application size is the product of the efficient program coding in C++. This directly translates into a very fast and responsive LIMS.


Application Description ~ Size
OnSETUP Static data management and configuration 224K
OnLAB Login, Reporting, Statistics and Management 800K
OnWSH Instrument interfacing and Worksheet 800K
OnLQC Interactive QA/QC 330K
OnVIEW Client sample tracking system 195K
DLL's Description ~ Size
LimsLIB General LIMS library 510K
LimsEXPO LIMS Export functions 120K
PLUGIN Worksheet plugin 164K

System specification

In some labs it is common practice to shuffle down older computers from office areas into the lab. This is not always the best solution. We recommend fairly high end systems on the client side to reap the full benefit of the LIMS. However, due to budget constraints this is not always possible.

As a rule of thumb as far as performance goes, if MS Word or Excel performance is acceptable on your computer, then Online LIMS should run fine.

We can help provide ideas and computer solutions to make your lab a more efficient and comfortable work environment. This picture shows a great idea how to install the computers in a balance room.

Balance room

Minimal HW Specifications

Server HW

Pentium IV 1.6 GHz
2 GB Ram
SVGA graphic ( 1024x768 pixel, High Color )
Good Internet connection for remote support
One disk of 60 GB for LIMS data, to store ~ 3 years of raw data.
Must meet the networks system specs.
Client HW
Pentium IV 1.2 GHz
1 GB Ram
SVGA graphic (1024x768 pixel, High Color )
COM1 or COM2 free
Client OS
Windows 95/98/NT/2000/XP
32-bit ODBC
MS Excel for custom statistics
Server OS
Windows 2000 Server +
TCP/IP protocol
NetSupport 7.0, 3 licenses +
Database
MS SQL Server 2000 +
MS SQL Server 7.0 SP2 +

Data Transfer, exporting

Online LIMS provides a wide range of standard export format files. Customized export formats are also available. Exporting formats and export paths can be predefined for each client in the client table to make reporting a little easier.

Plain text files

CSV formats

Excel

Vulcan

XML

PI Osisoft

acQuire

Any custom format on request