A Searching and Reporting System for Relational Databases Using a Graph-Based Metadata Representation
- 19 May 2005
- journal article
- Published by American Chemical Society (ACS) in Journal of Chemical Information and Modeling
- Vol. 45 (4) , 863-869
- https://doi.org/10.1021/ci050062e
Abstract
Relational databases are the current standard for storing and retrieving data in the pharmaceutical and biotech industries. However, retrieving data from a relational database requires specialized knowledge of the database schema and of the SQL query language. At Anadys, we have developed an easy-to-use system for searching and reporting data in a relational database to support our drug discovery project teams. This system is fast and flexible and allows users to access all data without having to write SQL queries. This paper presents the hierarchical, graph-based metadata representation and SQL-construction methods that, together, are the basis of this system's capabilities.Keywords
This publication has 4 references indexed in Scilit:
- ArQiologist: An Integrated Decision Support Tool for Lead OptimizationJournal of Chemical Information and Modeling, 2004
- Process-Driven Information Management System at a Biotech Company: Concept and ImplementationJournal of Chemical Information and Computer Sciences, 2004
- EnsMart: A Generic System for Fast and Flexible Access to Biological DataGenome Research, 2004
- CKB − The Compound Knowledge Base: A Text Based Chemical Search SystemJournal of Chemical Information and Computer Sciences, 2002