Filters








14,257 Hits in 5.6 sec

Optimizing SQL Queries over Text Databases

Alpa Jain, AnHai Doan, Luis Gravano
<span title="">2008</span> <i title="IEEE"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/vuw5ktdyknehrehttg5qm4rfqm" style="color: black;">2008 IEEE 24th International Conference on Data Engineering</a> </i> &nbsp;
We optimize the execution of SQL queries over text databases in a principled, cost-based manner, incorporating this tradeoff between efficiency and result quality in a user-specific fashion.  ...  By processing a text database with information extraction systems, we can materialize a variety of structured "relations," over which we can then issue regular SQL queries.  ...  In the rest of the paper, we elaborate on our solution to process SQL queries over text databases, called SQOUT (for "SQL queries over unstructured text databases").  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/icde.2008.4497472">doi:10.1109/icde.2008.4497472</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/icde/JainDG08.html">dblp:conf/icde/JainDG08</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/zdiggonxhvcuhmeahucjolhmyy">fatcat:zdiggonxhvcuhmeahucjolhmyy</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170706052715/http://www.cs.columbia.edu/%7Egravano/Papers/2008/icde08.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/c8/1a/c81a0b8e4bb79cd72dc22bcf966a58504a04e979.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/icde.2008.4497472"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> ieee.com </button> </a>

User Generated SQL Queries Inform Evaluation of NSSP ESSENCE

Aaron Kite-Powell, Michael Coletta, Jamie Smimble
<span title="2018-05-22">2018</span> <i title="University of Illinois Libraries"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/u4k6gfb6nncyfg3hvo3dvjo2ay" style="color: black;">Online Journal of Public Health Informatics</a> </i> &nbsp;
SQL query text was parsed so that we could isolate, 1) Syndromes queried, 2) Sub-syndromes queried, 3) Keyword categories queried, and 4) Free text query terms used.  ...  Over this entire time period there was a weekly mean of 4,785 SQL queries performed by users.  ...  SQL query text was parsed so that we could isolate, 1) Syndromes queried, 2) Sub-syndromes queried, 3) Keyword categories queried, and 4) Free text query terms used.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.5210/ojphi.v10i1.8914">doi:10.5210/ojphi.v10i1.8914</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/mxf4bohc4bbnfd6rwldqql2zqy">fatcat:mxf4bohc4bbnfd6rwldqql2zqy</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20200216093942/https://journals.uic.edu/ojs/index.php/ojphi/article/download/8914/7302" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/3f/e8/3fe8f7af33944e50ac5df3034a9dab198954929e.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.5210/ojphi.v10i1.8914"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="unlock alternate icon" style="background-color: #fb971f;"></i> Publisher / doi.org </button> </a>

SQL Queries Over Unstructured Text Databases

Alpa Jain, AnHai Doan, Luis Gravano
<span title="">2007</span> <i title="IEEE"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/vuw5ktdyknehrehttg5qm4rfqm" style="color: black;">2007 IEEE 23rd International Conference on Data Engineering</a> </i> &nbsp;
By processing a text database with information extraction systems, we can define a variety of structured "relations," over which we can then issue SQL queries.  ...  Processing SQL queries in this text-based scenario presents multiple challenges.  ...  Discussion We performed an extensive evaluation of our query processing approach, which relies on document sampling to estimate the goodness of the candidate query execution strategies.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/icde.2007.368986">doi:10.1109/icde.2007.368986</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/icde/JainDG07.html">dblp:conf/icde/JainDG07</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/ggmyaurtynhx5khoktgmppg7ay">fatcat:ggmyaurtynhx5khoktgmppg7ay</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170312113233/http://pages.cs.wisc.edu/%7Eanhai/projects/papers/sqout-icde07.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/56/08/560877311db77387ce1e822e3374f43eb41be692.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1109/icde.2007.368986"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> ieee.com </button> </a>

ROX [chapter]

Alan Halverson, Vanja Josifovski, Guy Lohman, Hamid Pirahesh, Mathias Mörschel
<span title="">2004</span> <i title="Elsevier"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/mzoohkksfjcxhp55kw6j3idhme" style="color: black;">Proceedings 2004 VLDB Conference</a> </i> &nbsp;
We also weigh the implications of ROX for manageability and query optimization.  ...  This paper explores the feasibility of accessing natively-stored XML data through traditional SQL interfaces, called Relational Over XML (ROX), in order to avoid the costly conversion of legacy applications  ...  Optimization Compiling SQL queries on XML documents presents new challenges for query optimization.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/b978-012088469-8.50026-7">doi:10.1016/b978-012088469-8.50026-7</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/vldb/HalversonJLPM04.html">dblp:conf/vldb/HalversonJLPM04</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/gn6lrkd6bnh3vlci6cb6ineqme">fatcat:gn6lrkd6bnh3vlci6cb6ineqme</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170706093656/http://www.vldb.org/conf/2004/RS7P2.PDF" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/b0/89/b089c04fd84f28134505fdd28f6c747c8116fc13.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1016/b978-012088469-8.50026-7"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> elsevier.com </button> </a>

Managing XML Data to optimize Performance into Object-Relational Databases

Iuliana BOTHA
<span title="">2011</span> <i title="Bucharest Academy of Economic Studies Publishing House"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/6spcxqebrze7jnthgymv3o524i" style="color: black;">Database Systems Journal</a> </i> &nbsp;
It is detailed the possibility of storing XML data into such databases, using for exemplification an Oracle database and there are tested some optimizing techniques of the queries over XMLType tables,  ...  This paper propose some possibilities for manage XML data in order to optimize performance into object-relational databases.  ...  When a query is executed over a table with XMLType columns, the query optimizer takes into consideration many factors related to the objects referenced and the conditions specified in the query, in order  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener" href="https://doaj.org/article/237a7f5a3b404277bc90170b0aa207ea">doaj:237a7f5a3b404277bc90170b0aa207ea</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/lr6u4q4exzhutjjdqcme3ltjzy">fatcat:lr6u4q4exzhutjjdqcme3ltjzy</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20171202094144/http://www.dbjournal.ro/archive/4/1_Iuliana_Botha.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/22/4b/224bab17094099fa89692561ac71cf506c1ef8e5.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a>

Declarative Ajax Web Applications through SQL++ on a Unified Application State [article]

Yupeng Fu, Kian Win Ong, Yannis Papakonstantinou
<span title="2014-06-16">2014</span> <i > arXiv </i> &nbsp; <span class="release-stage" >pre-print</span>
FORWARD's architecture is based on two novel cornerstones: (a) A Unified Application State (UAS), which is a virtual database over the multiple data sources.  ...  The UAS is accessed via distributed SQL++ queries, therefore resolving the distributed data access problem.  ...  Holistic query optimizations FORWARD holistically optimizes the SQL++ queries of the page.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener" href="https://arxiv.org/abs/1308.0656v2">arXiv:1308.0656v2</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/qc4khs7sbrg25cbtz7gtfusefa">fatcat:qc4khs7sbrg25cbtz7gtfusefa</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20200831210944/https://arxiv.org/pdf/1308.0656v2.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/d3/0e/d30eb3d1a27c8933f0a504d930878d1856a75595.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener" href="https://arxiv.org/abs/1308.0656v2" title="arxiv.org access"> <button class="ui compact blue labeled icon button serp-button"> <i class="file alternate outline icon"></i> arxiv.org </button> </a>

XML and relational database management systems

Michael Rys
<span title="">2005</span> <i title="ACM Press"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/vxrc3vebzzachiwy3nopwi3h5u" style="color: black;">Proceedings of the 2005 ACM SIGMOD international conference on Management of data - SIGMOD &#39;05</a> </i> &nbsp;
While first concentrating on enabling the transport of relational data via XML with the SQL Server 2000 release, SQL Server 2005 now additionally provides native XML storage and query support.  ...  This part of the tutorial will provide an insight into how SQL Server 2005 fits XML functionality into its core relational database management framework.  ...  [34] provides more information about the query compilation and optimization.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1066157.1066301">doi:10.1145/1066157.1066301</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/sigmod/Rys05.html">dblp:conf/sigmod/Rys05</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/yuewb5jqrfav3fjudmidbzk2ji">fatcat:yuewb5jqrfav3fjudmidbzk2ji</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170705110020/http://web.cs.wpi.edu/~cs561/s07/papers/SIGMOD05-MS-XML-rys.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/a2/97/a2975cb67fc53200b3db9ac19116a425f95cd8aa.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1066157.1066301"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>

A Uniform Query Framework for Heterogenous Data Management Systems

Jayant B. Karanjekar
<span title="2018-10-31">2018</span> <i title="BioAxis DNA Research Centre"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/grcyvowbjbbnfdmv2azpa6ltf4" style="color: black;">Helix</a> </i> &nbsp;
For several decades before NoSQL databases became popular, there was only one query language i.e. SQL for all relational database systems.  ...  This paper demonstrates how an SQL style query mechanism can be used to fetch data from both relations and NoSQL database systems. It also supports filters, joins, aggregates and nested queries.  ...  Our previous paper [8] we proposed an SQL-like query mechanism for a combination of relational and NoSQL databases such as MySQL, MongoDB, Cassandra and CSV files.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.29042/2018-4441-4445">doi:10.29042/2018-4441-4445</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/33hcj4cnvjarppftpflcgxvfr4">fatcat:33hcj4cnvjarppftpflcgxvfr4</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20190429014913/http://helix.dnares.in/wp-content/uploads/2018/11/4441-4445.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/6f/a6/6fa647f9414c278c216543aa3ee7644d2ccb7626.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.29042/2018-4441-4445"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> Publisher / doi.org </button> </a>

Towards a Natural Language Query Processing System [article]

Chantal Montgomery, Haruna Isah, Farhana Zulkernine
<span title="2020-09-25">2020</span> <i > arXiv </i> &nbsp; <span class="release-stage" >pre-print</span>
However, the evolution of unstructured big data such as text, images, and video has exposed the limitations of traditional structured query interfaces.  ...  Previous research efforts mainly focused on developing structured query interfaces to relational databases.  ...  Query over graph databases is increasingly attracting much attention [13] .  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener" href="https://arxiv.org/abs/2009.12414v1">arXiv:2009.12414v1</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/wiz6fy4nvzbi3nhz4ey6434ds4">fatcat:wiz6fy4nvzbi3nhz4ey6434ds4</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20201005174028/https://arxiv.org/ftp/arxiv/papers/2009/2009.12414.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] </button> </a> <a target="_blank" rel="external noopener" href="https://arxiv.org/abs/2009.12414v1" title="arxiv.org access"> <button class="ui compact blue labeled icon button serp-button"> <i class="file alternate outline icon"></i> arxiv.org </button> </a>

GALO

Guilherme Damasio, Spencer Bryson, Vincent Corvinelli, Parke Godfrey, Piotr Mierzejewski, Jaroslaw Szlichta, Calisto Zuzarte
<span title="2019-08-01">2019</span> <i title="VLDB Endowment"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/p6rqwwpkkjbcldejepcehaalby" style="color: black;">Proceedings of the VLDB Endowment</a> </i> &nbsp;
GALO's knowledge base is built on RDF and SPARQL, which is well-suited for manipulating and querying over SQL query plans, which are graphs themselves.  ...  It then uses the knowledge base online to re-optimize queries queued for execution to improve performance, often quite dramatically. PVLDB Reference Format:  ...  Large SQL queries are decomposed into smaller parts corresponding to sub-queries to find problematic patterns that can be applied over the query workloads for re-optimization.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.14778/3352063.3352064">doi:10.14778/3352063.3352064</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/kflxftkslzhvtifq24l7t4eawi">fatcat:kflxftkslzhvtifq24l7t4eawi</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20200320094314/http://www.vldb.org/pvldb/vol12/p1778-damasio.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/a0/ed/a0ed6ff889c851e477a2d8fa7b6f389eebbfc223.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.14778/3352063.3352064"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> Publisher / doi.org </button> </a>

Adaptive Query Processing

Amol Deshpande, Zachary Ives, Vijayshankar Raman
<span title="">2007</span> <i title="Now Publishers"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/waqifvssrfedlidcnrqddey6ki" style="color: black;">Foundations and Trends in Databases</a> </i> &nbsp;
that the traditional optimize-then-execute paradigm is insufficient.  ...  Our goal with this paper is to be a "value-add" over the existing papers on the material, providing not only a brief overview of each technique, but also a basic framework for understanding the field of  ...  Except for certain embedded SQL queries, which may be pre-optimized or optimized once for multiple possible input bindings.Full text available at: http://dx.doi.org/10.1561/1900000001 1.2 Motivations for  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1561/1900000001">doi:10.1561/1900000001</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/oqg667kvabfqfd5kvydxmkcej4">fatcat:oqg667kvabfqfd5kvydxmkcej4</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20201212033450/https://www.nowpublishers.com/article/DownloadSummary/DBS-001" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/5c/98/5c9867a9c822d9a3146bd12774881cf838b23f12.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1561/1900000001"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="unlock alternate icon" style="background-color: #fb971f;"></i> Publisher / doi.org </button> </a>

Data management with SAPs in-memory computing engine

Joos-Hendrik Boese, Cafer Tosun, Christian Mathis, Franz Faerber
<span title="">2012</span> <i title="ACM Press"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/25kc37fuhndb5axzv75226fwem" style="color: black;">Proceedings of the 15th International Conference on Extending Database Technology - EDBT &#39;12</a> </i> &nbsp;
as graph or text processing for semi-and unstructured data.  ...  The HANA database management system [1] was developed to meet changed requirements of modern business applications.  ...  Focusing on well understood SQL query optimization is not sufficient anymore. Automatic optimization and parallelization of arbitrary procedural parts of application code is required.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/2247596.2247661">doi:10.1145/2247596.2247661</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/edbt/BoeseTMF12.html">dblp:conf/edbt/BoeseTMF12</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/bzwwv5nbz5e2diyt4fcur6queu">fatcat:bzwwv5nbz5e2diyt4fcur6queu</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170808183527/http://openproceedings.org/2012/conf/edbt/BoeseTMF12.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/24/df/24df074f35ed91db0bcace32fbe93f74fa28b396.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/2247596.2247661"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>

The perm provenance management system in action

Boris Glavic, Gustavo Alonso
<span title="">2009</span> <i title="ACM Press"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/vxrc3vebzzachiwy3nopwi3h5u" style="color: black;">Proceedings of the 35th SIGMOD international conference on Management of data - SIGMOD &#39;09</a> </i> &nbsp;
Thus, provenance data and provenance computations are represented as relational data and queries and, hence, can be queried, stored and optimized using standard relational database techniques.  ...  For example, Perm supports lazy and eager provenance computation, external provenance and various contribution semantics for an almost complete subset of SQL..  ...  Perm benefits from the query, optimization and storage techniques developed for relational databases and supports provenance computation for complex SQL queries.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1559845.1559980">doi:10.1145/1559845.1559980</a> <a target="_blank" rel="external noopener" href="https://dblp.org/rec/conf/sigmod/GlavicA09.html">dblp:conf/sigmod/GlavicA09</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/ag6xechwzzf2nlbghajvjqqwqa">fatcat:ag6xechwzzf2nlbghajvjqqwqa</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20170809125059/http://cs.iit.edu/~glavic/pdfs/GA09b.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/a6/73/a6733300dff08735eb1e2b510791fd66e1d8d1c1.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1559845.1559980"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>

Pathfinder meets DB2®

Manuel Mayr
<span title="">2008</span> <i title="ACM Press"> Proceedings of the 2008 EDBT Ph.D. workshop on - Ph.D. &#39;08 </i> &nbsp;
For that reason we are able to rest this work on query optimization techniques that have proven their effectiveness for pure SQL workloads.  ...  profiles, a final fallback that enables fine-grained control over DB2's query execution plans.  ...  challenge for the RDBMS' built-in SQL-centric query optimizer.  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1387150.1387160">doi:10.1145/1387150.1387160</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/gemixmeuofecpgqan4r64loimy">fatcat:gemixmeuofecpgqan4r64loimy</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20200709231825/https://db.inf.uni-tuebingen.de/staticfiles/publications/pathfinder-meets-db2.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/48/77/48772c0f54c394c7ef2aaf9b03db22a203cb6a47.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1145/1387150.1387160"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> acm.org </button> </a>

Keyword querying and ranking in databases

Surajit Chaudhuri, Gautam Das
<span title="2009-08-01">2009</span> <i title="VLDB Endowment"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/p6rqwwpkkjbcldejepcehaalby" style="color: black;">Proceedings of the VLDB Endowment</a> </i> &nbsp;
He has worked in the areas of query optimization, physical database design, data cleaning, and text search. He is an ACM Fellow.  ...  We then discuss how today's database systems allow text columns integrated as part of their SQL querying environment (Full Text Search Indexes), and point out their key differences from traditional B+  ... 
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.14778/1687553.1687622">doi:10.14778/1687553.1687622</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/t4c2i64dzzbj3cirbybgg65c7q">fatcat:t4c2i64dzzbj3cirbybgg65c7q</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20200709115121/http://www.vldb.org/pvldb/vol2/vldb09-tutorial3.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/ed/5b/ed5bc9667c619fd6a8359ba8a74c444cdc3d9a54.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.14778/1687553.1687622"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> Publisher / doi.org </button> </a>
&laquo; Previous Showing results 1 &mdash; 15 out of 14,257 results