Workflow handbook 1997
SchemaSQL: An extension to SQL for multidatabase interoperability
ACM Transactions on Database Systems (TODS)
Spatial SQL: A Query and Presentation Language
IEEE Transactions on Knowledge and Data Engineering
Information Systems - Special issue: Data management in bioinformatics
A bioinformatics discovery-oriented computing framework
A bioinformatics discovery-oriented computing framework
SIBIOS: A System for the Integration of Bioinformatics Services
CLADE '04 Proceedings of the 2nd International Workshop on Challenges of Large Applications in Distributed Environments
| Hi-index | 0.00 |
Many biological information systems rely on relational database management systems (RDBMS) to manage high-throughput biological data. While keeping these data well archived, organized, and integrated in a common repository is still a challenging task, performing complex queries, i.e., explorative and abstract ad hoc user questions in biology, is an even formidable task often substituted by writing complicated software programs. In this work, we propose a "complex query modeling" method to address the challenge of complex querying in biological domains. Query modeling consists of four distinct but interdependent phases of activities: representation of high-level problems, transformation of problems into connected query interfaces, designing database query structures, and translating query plans into high-performing SQL statements. At each stage, we use different notations and query modeling practices. Using gene indexing project as a case study, we show that query modeling enables prototypical development of high-quality SQL solutions to an inherently abstract and vague user query question, which requires GeneChip designers to sift through millions of database records, process data in dozens of steps, and make myriads of intermediate decisions. We believe our "complex query modeling" method is applicable to other bioinformatics domains with needs for complex database queries.