A metadata approach to query interoperation between molecular biology databases
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 d...
Gespeichert in:
| Veröffentlicht in: | Bioinformatics (Oxford, England) England), 1998, Vol.14 (6), p.486-497 |
|---|---|
| Hauptverfasser: | , , |
| Format: | Artikel |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 497 |
|---|---|
| container_issue | 6 |
| container_start_page | 486 |
| container_title | Bioinformatics (Oxford, England) |
| container_volume | 14 |
| creator | CHEUNG, K.-H NADKARNI, P. M SHIN, D.-G |
| description | 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.
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.
Freely available (Cold Fusion source code and an Access database containing the mapping knowledge) upon request from the author.
kei.cheung@yale.edu |
| doi_str_mv | 10.1093/bioinformatics/14.6.486 |
| format | Article |
| fullrecord | <record><control><sourceid>proquest_cross</sourceid><recordid>TN_cdi_proquest_miscellaneous_80056317</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>80056317</sourcerecordid><originalsourceid>FETCH-LOGICAL-c337t-45ecf564e14029d000c59a969c845d4851a1b29d3d6f032d14928e3e8ea2cbff3</originalsourceid><addsrcrecordid>eNpVkF9LwzAUxYMoc04_gpgH8W1b0qRp-ziG_2CwF30Ot-mtVtqmJimyb29kZeBTAuece3_3EHLH2YqzQqzLxjZ9bV0HoTF-zeVKrWSuzsicC5UtZc75-enPxCW58v6LMZayVM3IrFCFLPJsTvYb2mGACgJQGAZnwXzSYOn3iO5Amz6gswO6uMX2tMTwg9jTzrZoxhYcjRit_TjQv3wJHv01uaih9XgzvQvy_vT4tn1Z7vbPr9vNbmmEyMJSpmjqVEnkkiVFFcFMWkCkMrlMK5mnHHgZBVGpmomk4rJIchSYIySmrGuxIA_HuRE5svqgu8YbbFvo0Y5e5_FUJXgWjdnRaJz13mGtB9d04A6aM_1Xpf5fpeZSKx2rjMnbacVYdlidclN3Ub-fdPAG2tpBbxp_siVSyjTO_wXG8oJM</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>80056317</pqid></control><display><type>article</type><title>A metadata approach to query interoperation between molecular biology databases</title><source>MEDLINE</source><source>Elektronische Zeitschriftenbibliothek - Frei zugängliche E-Journals</source><source>Alma/SFX Local Collection</source><creator>CHEUNG, K.-H ; NADKARNI, P. M ; SHIN, D.-G</creator><creatorcontrib>CHEUNG, K.-H ; NADKARNI, P. M ; SHIN, D.-G</creatorcontrib><description>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.
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.
Freely available (Cold Fusion source code and an Access database containing the mapping knowledge) upon request from the author.
kei.cheung@yale.edu</description><identifier>ISSN: 1367-4803</identifier><identifier>EISSN: 1367-4811</identifier><identifier>DOI: 10.1093/bioinformatics/14.6.486</identifier><identifier>PMID: 9694987</identifier><language>eng</language><publisher>Oxford: Oxford University Press</publisher><subject>Biological and medical sciences ; Chromosome Mapping ; Computational Biology ; Computer Simulation ; Database Management Systems ; Databases, Factual ; Fundamental and applied biological sciences. Psychology ; General aspects ; Mathematics in biology. Statistical analysis. Models. Metrology. Data processing in biology (general aspects) ; Molecular Biology</subject><ispartof>Bioinformatics (Oxford, England), 1998, Vol.14 (6), p.486-497</ispartof><rights>1998 INIST-CNRS</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c337t-45ecf564e14029d000c59a969c845d4851a1b29d3d6f032d14928e3e8ea2cbff3</citedby></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>314,776,780,4010,27900,27901,27902</link.rule.ids><backlink>$$Uhttp://pascal-francis.inist.fr/vibad/index.php?action=getRecordDetail&idt=2444509$$DView record in Pascal Francis$$Hfree_for_read</backlink><backlink>$$Uhttps://www.ncbi.nlm.nih.gov/pubmed/9694987$$D View this record in MEDLINE/PubMed$$Hfree_for_read</backlink></links><search><creatorcontrib>CHEUNG, K.-H</creatorcontrib><creatorcontrib>NADKARNI, P. M</creatorcontrib><creatorcontrib>SHIN, D.-G</creatorcontrib><title>A metadata approach to query interoperation between molecular biology databases</title><title>Bioinformatics (Oxford, England)</title><addtitle>Bioinformatics</addtitle><description>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.
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.
Freely available (Cold Fusion source code and an Access database containing the mapping knowledge) upon request from the author.
kei.cheung@yale.edu</description><subject>Biological and medical sciences</subject><subject>Chromosome Mapping</subject><subject>Computational Biology</subject><subject>Computer Simulation</subject><subject>Database Management Systems</subject><subject>Databases, Factual</subject><subject>Fundamental and applied biological sciences. Psychology</subject><subject>General aspects</subject><subject>Mathematics in biology. Statistical analysis. Models. Metrology. Data processing in biology (general aspects)</subject><subject>Molecular Biology</subject><issn>1367-4803</issn><issn>1367-4811</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1998</creationdate><recordtype>article</recordtype><sourceid>EIF</sourceid><recordid>eNpVkF9LwzAUxYMoc04_gpgH8W1b0qRp-ziG_2CwF30Ot-mtVtqmJimyb29kZeBTAuece3_3EHLH2YqzQqzLxjZ9bV0HoTF-zeVKrWSuzsicC5UtZc75-enPxCW58v6LMZayVM3IrFCFLPJsTvYb2mGACgJQGAZnwXzSYOn3iO5Amz6gswO6uMX2tMTwg9jTzrZoxhYcjRit_TjQv3wJHv01uaih9XgzvQvy_vT4tn1Z7vbPr9vNbmmEyMJSpmjqVEnkkiVFFcFMWkCkMrlMK5mnHHgZBVGpmomk4rJIchSYIySmrGuxIA_HuRE5svqgu8YbbFvo0Y5e5_FUJXgWjdnRaJz13mGtB9d04A6aM_1Xpf5fpeZSKx2rjMnbacVYdlidclN3Ub-fdPAG2tpBbxp_siVSyjTO_wXG8oJM</recordid><startdate>1998</startdate><enddate>1998</enddate><creator>CHEUNG, K.-H</creator><creator>NADKARNI, P. M</creator><creator>SHIN, D.-G</creator><general>Oxford University Press</general><scope>IQODW</scope><scope>CGR</scope><scope>CUY</scope><scope>CVF</scope><scope>ECM</scope><scope>EIF</scope><scope>NPM</scope><scope>AAYXX</scope><scope>CITATION</scope><scope>7X8</scope></search><sort><creationdate>1998</creationdate><title>A metadata approach to query interoperation between molecular biology databases</title><author>CHEUNG, K.-H ; NADKARNI, P. M ; SHIN, D.-G</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c337t-45ecf564e14029d000c59a969c845d4851a1b29d3d6f032d14928e3e8ea2cbff3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1998</creationdate><topic>Biological and medical sciences</topic><topic>Chromosome Mapping</topic><topic>Computational Biology</topic><topic>Computer Simulation</topic><topic>Database Management Systems</topic><topic>Databases, Factual</topic><topic>Fundamental and applied biological sciences. Psychology</topic><topic>General aspects</topic><topic>Mathematics in biology. Statistical analysis. Models. Metrology. Data processing in biology (general aspects)</topic><topic>Molecular Biology</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>CHEUNG, K.-H</creatorcontrib><creatorcontrib>NADKARNI, P. M</creatorcontrib><creatorcontrib>SHIN, D.-G</creatorcontrib><collection>Pascal-Francis</collection><collection>Medline</collection><collection>MEDLINE</collection><collection>MEDLINE (Ovid)</collection><collection>MEDLINE</collection><collection>MEDLINE</collection><collection>PubMed</collection><collection>CrossRef</collection><collection>MEDLINE - Academic</collection><jtitle>Bioinformatics (Oxford, England)</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>CHEUNG, K.-H</au><au>NADKARNI, P. M</au><au>SHIN, D.-G</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>A metadata approach to query interoperation between molecular biology databases</atitle><jtitle>Bioinformatics (Oxford, England)</jtitle><addtitle>Bioinformatics</addtitle><date>1998</date><risdate>1998</risdate><volume>14</volume><issue>6</issue><spage>486</spage><epage>497</epage><pages>486-497</pages><issn>1367-4803</issn><eissn>1367-4811</eissn><abstract>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.
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.
Freely available (Cold Fusion source code and an Access database containing the mapping knowledge) upon request from the author.
kei.cheung@yale.edu</abstract><cop>Oxford</cop><pub>Oxford University Press</pub><pmid>9694987</pmid><doi>10.1093/bioinformatics/14.6.486</doi><tpages>12</tpages></addata></record> |
| fulltext | fulltext |
| identifier | ISSN: 1367-4803 |
| ispartof | Bioinformatics (Oxford, England), 1998, Vol.14 (6), p.486-497 |
| issn | 1367-4803 1367-4811 |
| language | eng |
| recordid | cdi_proquest_miscellaneous_80056317 |
| source | MEDLINE; Elektronische Zeitschriftenbibliothek - Frei zugängliche E-Journals; Alma/SFX Local Collection |
| subjects | Biological and medical sciences Chromosome Mapping Computational Biology Computer Simulation Database Management Systems Databases, Factual Fundamental and applied biological sciences. Psychology General aspects Mathematics in biology. Statistical analysis. Models. Metrology. Data processing in biology (general aspects) Molecular Biology |
| title | A metadata approach to query interoperation between molecular biology databases |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-08T22%3A56%3A41IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_cross&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=A%20metadata%20approach%20to%20query%20interoperation%20between%20molecular%20biology%20databases&rft.jtitle=Bioinformatics%20(Oxford,%20England)&rft.au=CHEUNG,%20K.-H&rft.date=1998&rft.volume=14&rft.issue=6&rft.spage=486&rft.epage=497&rft.pages=486-497&rft.issn=1367-4803&rft.eissn=1367-4811&rft_id=info:doi/10.1093/bioinformatics/14.6.486&rft_dat=%3Cproquest_cross%3E80056317%3C/proquest_cross%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=80056317&rft_id=info:pmid/9694987&rfr_iscdi=true |