• Home
  • Search
  • SORTEZ: a relational translator for NCBI's ASN.1 database.
  • Cite Icon12
  • https://doi.org/10.1093/bioinformatics/10.4.369Copy DOI Icon

SORTEZ: a relational translator for NCBI's ASN.1 database.

Show More
  • Abstract
  • Literature Map
  • Citations
  • Similar Papers
Abstract

The National Center for Biotechnology Information (NCBI) has created a database collection that includes several protein and nucleic acid sequence databases, a biosequence-specific subset of MEDLINE, as well as value-added information such as links between similar sequences. Information in the NCBI database is modeled in Abstract Syntax Notation 1 (ASN.1) 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.1 data model currently lacks an ad hoc query language for general-purpose data access. For that reason, we have developed a software package, SORTEZ, that transforms the ASN.1 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 database transformation. We show that transformation from the ASN.1 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.

Similar Papers
  • Research Article

De Novo Genome Assembly and Sequence Analysis of Chlorogloeopsis sp. ULAP01 Isolated from a Copper Mine Tailing Environment

  • Oct 01, 2024
  • Philippine Journal of Science
  • Marione Mae Enriquez +4
  • PDF
  • Research Article
  • Citations3

Multifactor dimensionality reduction analysis identifies specific nucleotide patterns promoting genetic polymorphisms

  • Mar 30, 2009
  • BioData Mining
  • Eric Arehart +4
  • Research Article

Phenotypic and molecular diagnosis of <i>Trichoderma</i> spp. isolated from the local soil of Nineveh Governorate, Iraq

  • Jun 20, 2025
  • Journal of Applied and Natural Science
  • Mohammad Abdullah Almashhadani +1
  • Research Article

ANALISIS KEANEKARAGAMAN GEN MYOSTATIN (MSTN) SECARA IN-SILICO PADA CATTLE DI INDONESIA

  • Jul 31, 2023
  • Bioma
  • Naufal Ma'Arif +2
  • Research Article
  • Citations1

Mpt64 mutations in Mycobacterium tuberculosis with negative MPT64 antigen assay results from a tertiary hospital in Southeastern China.

  • Feb 26, 2025
  • Frontiers in medicine
  • Xinling Pan +6
  • Research Article
  • Citations8

Identification of Whey Acidic Protein (WAP) in Dog Milk

  • Jan 01, 2012
  • Experimental Animals
  • Mami Seki +7
  • Research Article

Low-coverage whole-genome sequencing for differentiating cervical cancer from cervical intraepithelial neoplasia and benign diseases

  • Jan 01, 2025
  • Chromosome Research
  • Tingting Zhang +10
  • Research Article
  • Citations220

Development and Evaluation of a Quality-Controlled Ribosomal Sequence Database for 16S Ribosomal DNA-Based Identification of Staphylococcus Species

  • Nov 01, 2004
  • Journal of Clinical Microbiology
  • Karsten Becker +6
  • PDF
  • Research Article
  • Citations4

Genetic Diversity and Maternal Lineage of Indo-Pacific Bottlenose Dolphin (Tursiops aduncus) in the Andaman Sea of Thailand

  • Dec 09, 2022
  • Diversity
  • Wareerat Prasitwiset +10
  • Research Article
  • Citations674

Database resources of the National Center for Biotechnology Information

  • Nov 21, 2010
  • Nucleic Acids Research
  • E W Sayers +41
  • PDF
  • Research Article
  • Citations3

Two Particularly Evolutionary Loci of <i>trn</i>L-<i>ndh</i>J of cpDNA of Yulania Baotaina, a New Species (Magnoliaceae) from China

  • Jan 01, 2019
  • American Journal of Agriculture and Forestry
  • Da-Li Fu +5
  • Research Article
  • Citations1162

Database resources of the National Center for Biotechnology.

  • Jan 01, 2003
  • Nucleic Acids Research
  • D L Wheeler
  • Research Article
  • Citations914

Database Resources of the National Center for Biotechnology Information.

  • Nov 28, 2016
  • Nucleic Acids Research
  • Ncbi Resource Coordinators
  • Abstract

IDDF2024-ABS-0357 Veillonella parvula reduces the lactylation of SMAD3 in CTLA4+ TIGIT+ treg cells to promote colorectal cancer

  • Aug 01, 2024
  • Gut
  • Tian-Hui Zou +2
  • Research Article

ANTIBIOTIC SUSCEPTIBILITY PROFILE AND SLIME LAYER FORMATION OF A CLINICAL ISOLATE OF STREPTOCOCCUS SANGUINIS FROM INFECTED ROOT CANALS

  • May 11, 2025
  • Journal of Medical Genetics and Clinical Biology
  • Mohammed M Ramadhan +1
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.