LIMS WAREHOUSING Archiving and Migrating of LIMS Data
- Slides: 10
LIMS WAREHOUSING Archiving and Migrating of LIMS Data Examples: • Annual Product Review and Trending with Beckmann LIMS data • Query for historical specifications
Current Situation LIMS systems n Productive LIMS Systems are storing data in their own data strcuture since 10 + years n Some systems are archiving submission / sample / test data internal n A lot of systems are a on the end of their Life Cycle (no longer supported by the vendor) n l Beckmann Labmanager l Collier / Quasi-P l HP LIMS l QDIS/QM l SQL*LIMS Archiving and Trending of data of 10 years+ is a regualtory requirement (MUST)
Our Solution - LIMS Warehouse n Good News: Most of the data are in a common format (Oracle, CSV Export, etc. ) n Legacy LIMS Data can be archived in a RDBM database n Potential technology solutions on the market l SAP BI/BO l Oracle Warehouse l SQL Server Parallel Data Warehouse l Native LIMS Databases (Oracle , SQL*Server) l Reporting Software (e. G. SAP Crystal reports, Oracle reports, Impromptu, etc. )
Archive and reporting of Beckmann Labmanager Architecture Beckmann LIMS Oracle 7 database Migration User Oracle 11 database Specification_Tests View Specification Head View Crystal Reports
Example: Beckmann LIMS Annual Product Review - Trend analysis User selects: 1. Product number 2. Time frame From - To
Example: Beckmann LIMS Annual Product Review - Trend report Methods / Values Samples / Batches
Example: Beckmann LIMS Annual Product Review - Statistics
Example: Beckmann LIMS Annual Product Review - Control charts
Example: Beckmann LIMS Specifications - Historical versions User selects: 1. Product type 2. Product number 3. Vendor 4. Type of Analysis 5. Status 6. Version number
Example: Beckmann LIMS Specifications - Historical versions
- Data mining in data warehouse
- Data warehousing and data mining in crm
- Olap data mining
- Introduction to data warehousing and data mining
- Best practices for migrating from rdbms to mongodb
- Dell migrating software
- Bird migration routes
- Migrating hp qtp scripts to selenium
- Javachive
- Data warehouse modeling best practices
- Oracle database archiving