Annotating database schemas to help enterprise search

Annotating database schemas to help enterprise search

In large enterprises, data discovery is a common problem faced by users who need to find relevant information in relational databases. In this scenario, schema annotation is a useful tool to enrich a database schema with descriptive keywords. In this paper, we demonstrate Barcelos, a system that aut...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Proceedings of the VLDB Endowment 2015-08, Vol.8 (12), p.1936-1939
Hauptverfasser: Cortez, Eli, Bernstein, Philip A., He, Yeye, Novik, Lev
Format: Artikel
Sprache:eng
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page 1939
container_issue 12
container_start_page 1936
container_title Proceedings of the VLDB Endowment
container_volume 8
creator Cortez, Eli
Bernstein, Philip A.
He, Yeye
Novik, Lev
description In large enterprises, data discovery is a common problem faced by users who need to find relevant information in relational databases. In this scenario, schema annotation is a useful tool to enrich a database schema with descriptive keywords. In this paper, we demonstrate Barcelos, a system that automatically annotates corporate databases. Unlike existing annotation approaches that use Web oriented knowledge bases, Barcelos mines enterprise spreadsheets to find candidate annotations. Our experimental evaluation shows that Barcelos produces high quality annotations; the top-5 have an average precision of 87%.
doi_str_mv 10.14778/2824032.2824105
format Article
fullrecord <record><control><sourceid>crossref</sourceid><recordid>TN_cdi_crossref_primary_10_14778_2824032_2824105</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>10_14778_2824032_2824105</sourcerecordid><originalsourceid>FETCH-LOGICAL-c158t-b4089acc965fdccc3172360d5ef27d6a601361907751b9d47cd07cbebc21fa723</originalsourceid><addsrcrecordid>eNpNj0tPwzAQhC0EEqVw55g_kLLrxI8cq4qXVIkLnKP12iZFbVLZvvDvaSEHTjPSjEbzCXGPsMLWGPsgrWyhkauzIqgLsZCooLbQmct__lrc5PwFoK1GuxBqPY5TobIbPytPhRzlUGUewoFyVaZqCPtjFcYS0jHtzlGgxMOtuIq0z-Fu1qX4eHp837zU27fn1816WzMqW2rXgu2IudMqemZu0MhGg1chSuM1acBGYwfGKHSdbw17MOyCY4mRTt2lgL9dTlPOKcT-9OJA6btH6H-x-xm7n7GbH_qqSiM</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype></control><display><type>article</type><title>Annotating database schemas to help enterprise search</title><source>ACM Digital Library Complete</source><creator>Cortez, Eli ; Bernstein, Philip A. ; He, Yeye ; Novik, Lev</creator><creatorcontrib>Cortez, Eli ; Bernstein, Philip A. ; He, Yeye ; Novik, Lev</creatorcontrib><description>In large enterprises, data discovery is a common problem faced by users who need to find relevant information in relational databases. In this scenario, schema annotation is a useful tool to enrich a database schema with descriptive keywords. In this paper, we demonstrate Barcelos, a system that automatically annotates corporate databases. Unlike existing annotation approaches that use Web oriented knowledge bases, Barcelos mines enterprise spreadsheets to find candidate annotations. Our experimental evaluation shows that Barcelos produces high quality annotations; the top-5 have an average precision of 87%.</description><identifier>ISSN: 2150-8097</identifier><identifier>EISSN: 2150-8097</identifier><identifier>DOI: 10.14778/2824032.2824105</identifier><language>eng</language><ispartof>Proceedings of the VLDB Endowment, 2015-08, Vol.8 (12), p.1936-1939</ispartof><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c158t-b4089acc965fdccc3172360d5ef27d6a601361907751b9d47cd07cbebc21fa723</citedby><cites>FETCH-LOGICAL-c158t-b4089acc965fdccc3172360d5ef27d6a601361907751b9d47cd07cbebc21fa723</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>314,776,780,27901,27902</link.rule.ids></links><search><creatorcontrib>Cortez, Eli</creatorcontrib><creatorcontrib>Bernstein, Philip A.</creatorcontrib><creatorcontrib>He, Yeye</creatorcontrib><creatorcontrib>Novik, Lev</creatorcontrib><title>Annotating database schemas to help enterprise search</title><title>Proceedings of the VLDB Endowment</title><description>In large enterprises, data discovery is a common problem faced by users who need to find relevant information in relational databases. In this scenario, schema annotation is a useful tool to enrich a database schema with descriptive keywords. In this paper, we demonstrate Barcelos, a system that automatically annotates corporate databases. Unlike existing annotation approaches that use Web oriented knowledge bases, Barcelos mines enterprise spreadsheets to find candidate annotations. Our experimental evaluation shows that Barcelos produces high quality annotations; the top-5 have an average precision of 87%.</description><issn>2150-8097</issn><issn>2150-8097</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2015</creationdate><recordtype>article</recordtype><recordid>eNpNj0tPwzAQhC0EEqVw55g_kLLrxI8cq4qXVIkLnKP12iZFbVLZvvDvaSEHTjPSjEbzCXGPsMLWGPsgrWyhkauzIqgLsZCooLbQmct__lrc5PwFoK1GuxBqPY5TobIbPytPhRzlUGUewoFyVaZqCPtjFcYS0jHtzlGgxMOtuIq0z-Fu1qX4eHp837zU27fn1816WzMqW2rXgu2IudMqemZu0MhGg1chSuM1acBGYwfGKHSdbw17MOyCY4mRTt2lgL9dTlPOKcT-9OJA6btH6H-x-xm7n7GbH_qqSiM</recordid><startdate>201508</startdate><enddate>201508</enddate><creator>Cortez, Eli</creator><creator>Bernstein, Philip A.</creator><creator>He, Yeye</creator><creator>Novik, Lev</creator><scope>AAYXX</scope><scope>CITATION</scope></search><sort><creationdate>201508</creationdate><title>Annotating database schemas to help enterprise search</title><author>Cortez, Eli ; Bernstein, Philip A. ; He, Yeye ; Novik, Lev</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c158t-b4089acc965fdccc3172360d5ef27d6a601361907751b9d47cd07cbebc21fa723</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2015</creationdate><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Cortez, Eli</creatorcontrib><creatorcontrib>Bernstein, Philip A.</creatorcontrib><creatorcontrib>He, Yeye</creatorcontrib><creatorcontrib>Novik, Lev</creatorcontrib><collection>CrossRef</collection><jtitle>Proceedings of the VLDB Endowment</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Cortez, Eli</au><au>Bernstein, Philip A.</au><au>He, Yeye</au><au>Novik, Lev</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Annotating database schemas to help enterprise search</atitle><jtitle>Proceedings of the VLDB Endowment</jtitle><date>2015-08</date><risdate>2015</risdate><volume>8</volume><issue>12</issue><spage>1936</spage><epage>1939</epage><pages>1936-1939</pages><issn>2150-8097</issn><eissn>2150-8097</eissn><abstract>In large enterprises, data discovery is a common problem faced by users who need to find relevant information in relational databases. In this scenario, schema annotation is a useful tool to enrich a database schema with descriptive keywords. In this paper, we demonstrate Barcelos, a system that automatically annotates corporate databases. Unlike existing annotation approaches that use Web oriented knowledge bases, Barcelos mines enterprise spreadsheets to find candidate annotations. Our experimental evaluation shows that Barcelos produces high quality annotations; the top-5 have an average precision of 87%.</abstract><doi>10.14778/2824032.2824105</doi><tpages>4</tpages></addata></record>
fulltext fulltext
identifier ISSN: 2150-8097
ispartof Proceedings of the VLDB Endowment, 2015-08, Vol.8 (12), p.1936-1939
issn 2150-8097
2150-8097
language eng
recordid cdi_crossref_primary_10_14778_2824032_2824105
source ACM Digital Library Complete
title Annotating database schemas to help enterprise search
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-12T22%3A12%3A35IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-crossref&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Annotating%20database%20schemas%20to%20help%20enterprise%20search&rft.jtitle=Proceedings%20of%20the%20VLDB%20Endowment&rft.au=Cortez,%20Eli&rft.date=2015-08&rft.volume=8&rft.issue=12&rft.spage=1936&rft.epage=1939&rft.pages=1936-1939&rft.issn=2150-8097&rft.eissn=2150-8097&rft_id=info:doi/10.14778/2824032.2824105&rft_dat=%3Ccrossref%3E10_14778_2824032_2824105%3C/crossref%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true