One of the best gauges for increasing data volumes from Laboratory Information Management Systems (LIMS) is whether your lab is exceeding the scalability of a native ODBC driver. From recent engagements, I am seeing a growing trend with pharmaceutical companies running LIMS software on Oracle. These environments are increasing their data access loads that require DataDirect Connect for ODBC Oracle Wire Protocol drivers.
More specifically, integrating LIMS and Chromotography Data Systems (CDS) can exceed the capabilities of native ODBC drivers. The wire protocol architecture of DataDirect Oracle Wire Protocol drivers is designed for these environments (i.e. StarLims or Labware interfaces to Empower), and it is exciting to consult on data access for systems that are constantly adapting to advancements in scientific innovation and instrumentation.
Below is an interview focused around data connectivity with an end user PhD Biologist from a multinational pharmaceutical company in Research Triangle Park (RTP), NC. The DataDirect office in RTP is conveniently surounded by thousands of professionals using LIMS software (45% of tenants in the park are in Life Sciences).
What kind of data is stored in the LIMS systems?
As a biologist, the type of data we store is derived from biological experiments. This includes multiple fields starting from dates and unique experiment identifiers to type of cell lines, numbers of cells used, specific compounds tested, and the end results such as cytotoxicity concentrations or inhibitory concentrations.
What are the sources of the data?
The source is biological experiments in my set
Do you know the vendors of the LIMS application?
I have used generic applications such as ActivityBase and also home grown software that is specific (and integral) to each company.
How does performance of the system impact your daily work, and work done in the lab?
The system needs to be up and running consistently so that we can document any results produced in the lab on a regular basis for two reasons: IP purposes and the ability to share data in a time-sensitive manner.
What changes have you observed over time in these systems?
We are doing most of these things to ease accessibility and accommodate large data volumes. All of our systems are also integrated so that different data sets are linked based on a unique identifier. We use multiple software add-ons (mostly for Excel) that tailor to our specific needs, but there are biostatistic-specific software available for more involved data analysis.
Get started today:
Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.