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