title: A searching and reporting system for relational databases using a graph-based metadata representation.
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.
authors.affiliation: Hewitt Consulting, San Diego, California 92103, USA. rhewitt@acm.org
authors.forename: Robin
authors.initials: R
authors.lastname: Hewitt
authors.forename: Alberto
authors.initials: A
authors.lastname: Gobbi
authors.forename: Man-Ling
authors.initials: ML
authors.lastname: Lee
mesh_terms: D003198:Computer Simulation; D016208:Databases, Factual / Q000592:standards*; D015195:Drug Design; D012107:Research Design; D012985:Software Design