SORTEZ: a relational translator for NCBI's ASN.1 database.
SORTEZ: a relational translator for NCBI's ASN.1 database.
复制标题
SORTEZ：NCBI 的 ASN.1 数据库的关系翻译器。
DOI：
10.1093/bioinformatics/10.4.369
复制
发表时间：
1994
期刊：
影响因子：
--
通讯作者：
Overton,GC
中科院分区：
文献类型：
--
作者：
Hart,KW;Searls,DB;Overton,GC
美国国家生物技术信息中心（NCBI）创建了一个数据库集合，其中包括几个蛋白质和核酸序列数据库，MEDLINE的非生物序列特异性子集，以及增值信息，如相似序列之间的链接。NCBI数据库中的信息以抽象符号1（Abstract Notation 1，缩写为IBI）建模，IBI是一种开放系统互连协议，设计用于在软件应用程序之间交换结构化数据，而不是作为数据库系统的数据模型。虽然NCBI数据库分布有一个易于使用的信息检索系统，ENTREZ，但目前缺乏用于通用数据访问的专用查询语言。出于这个原因，我们已经开发了一个软件包，SORTEZ，它将数据库转换为关系数据模型，并随后转换为关系数据库管理系统（SQL），在该系统中，可以通过关系查询语言SQL访问信息。由于需要将数据从一个数据模型和模式转换为另一个自然出现在几个重要的情况下，包括有效执行特定的应用程序，访问多个数据库和适应数据库的演变，这项工作也作为一个实际的研究所涉及的问题在数据库转换的各个阶段。我们表明，从B2B.l数据模型到关系数据模型的转换可以在很大程度上自动化，但模式转换和数据转换需要相当多的领域专业知识，并将大大受益于额外的支持工具。
The National Center for Biotechnology Information (NCBI) has created a database collection that includes several protein and nucleic acid sequence databases, abiosequence-specific subset of MEDLINE, as well as valueadded information such as links between similar sequences. Information in the NCBI database is modeled in Abstract Syntax Notation 1 (ASN.l), an Open Systems Interconnection protocol designed for the purpose of exchanging structured data between software applications rather than as a data model for database systems. While the NCBI database is distributed with an easy-to-use information retrieval system, ENTREZ, the ASN.l data model currently lacks an ad hoc query language for generalpurpose data access. For that reason, we have developed asoftware package, SORTEZ, that transforms the ASN.l database (or other databases with nested data structures) to a relational data model and subsequently to a relational database management system (Sybase) where information can be accessed through the relational query language, SQL. Because the need to transform data from one data model and schema to another arises naturally in several important contexts, including efficient execution of specific applications, access to multiple databases and adaptation to database evolution, this work also serves as a practical study of the issues involved in the various stages of databasetransformation. We show that transformation from the ASN.l data model to a relational data model can be largely automated, but that schema transformation and data conversion require considerable domain expertise and would greatly benefit from additional support tools.