A metadata approach to query interoperation between molecular biology databases.
A metadata approach to query interoperation between molecular biology databases.
复制标题
查询分子生物学数据库之间互操作的元数据方法。
DOI：
10.1093/bioinformatics/14.6.486
复制
发表时间：
1998
期刊：
影响因子：
--
通讯作者：
Shin,DG
中科院分区：
文献类型：
--
作者：
Cheung,KH;Nadkarni,PM;Shin,DG
动机：分子生物学数据库一直在迅速增长。它们的异构性和复杂性给数据库互操作带来了巨大的挑战。为了最小化异构数据库互操作的努力，开发一种系统是有用的，该系统允许特定基因组数据库的用户访问另一个相关数据库，就好像后者在结构上与前者相似。结果：我们扩展了一个结构简单的模型-实体属性值（EAV）模型-统一描述与各个数据库相关的元数据。执行数据库比较所必需的这种元数据包括原始数据库对象（包括实体、属性、域值和实体关系）的描述和数据库对象之间的对应关系的规范。我们展示了如何分解SQL查询，并将它们从一个数据库映射到另一个基于EAV表示的基本数据库对象。实现了一个原型系统来演示两个染色体图谱数据库之间的查询互操作。可用性：根据作者的要求免费提供（Cold Fusion源代码和包含映射知识的Access数据库）。联系人：kei. yale.edu
MOTIVATION: Molecular biology databases have been proliferating rapidly. Their heterogeneity and complexity pose a great challenge to efforts in database interoperation. To minimize the efforts of interoperating heterogeneous databases, it is useful to develop a system that lets a user of a particular genomic database access another related database as if the latter is structurally similar to the former. RESULTS: We extend a structurally simple model-the entity-attribute-value (EAV) model-to describe uniformly metadata relating to individual databases. Such metadata, which are necessary for performing database comparisons, include descriptions of primitive database objects (including entities, attributes, domain values and entity relationships) and specification of correspondences among the database objects. We show how to decompose SQL queries and map them from one database to another based on the EAV representation of the basic database objects. A prototype system is implemented to demonstrate query interoperation between two chromosome map databases. AVAILABILITY: Freely available (Cold Fusion source code and an Access database containing the mapping knowledge) upon request from the author. CONTACT: kei.cheung@yale.edu