Challenges inbuilding a DBMS Resource Advisor
Infoscience (Ecole Polytechnique Fédérale de Lausanne)Published 1 January 2006Open access
Dushyanth Narayanan, Eno Thereska, Anastassia Ailamaki
Citations104
Generate an AI Snapshot to get a quick, structured summary of this paper.
Study Snapshot
ObjectiveStudy objective
MethodsResearch methodology
PopulationPopulation studied
Sample sizeSample sizes
OutcomesStudy outcomes here
ResultsStudy results comes here
LimitationsResearch study limitations comes here
A concise AI-generated summary of the paper will appear here once you click Generate AI Snapshot.
TL;DR
This work proposes the use of probabilistic database techniques as the formal underpinnings of information extraction systems so as to maintain high precision while increasing recall, and builds a framework where rule-based annotators can be mapped to queries in a database system.
Abstract
The AVATAR Information Extraction System (IES) at the IBM Almaden Research Center enables highprecision, rule-based, information extraction from text-documents. Drawing from our experience we propose the use of probabilistic database techniques as the formal underpinnings of information extraction systems so as to maintain high precision while increasing recall. This involves building a framework where rule-based annotators can be mapped to queries in a database system. We use examples from AVATAR IES to describe the challenges in achieving this goal. Finally, we show that deriving precision estimates in such a database system presents a significant challenge for probabilistic database systems.
Keywords
Computer Science
The VLDB JournalEfficient query evaluation on probabilistic databases
979 Citations2006Nilesh Dalvi, Dan Suciu
It is shown that the data complexity of some queries is #P-complete, which implies that these queries do not admit any efficient evaluation methods, and an optimization algorithm is described that can compute efficiently most queries.
Natural Language EngineeringUIMA: an architectural approach to unstructured information processing in the corporate research environment
889 Citations2004David Ferrucci, Adam Lally
A general introduction to U IMA is given focusing on the design points of its analysis engine architecture and how UIMA is helping to accelerate research and technology transfer is discussed.
Combining lexical, syntactic, and semantic features with maximum entropy models for extracting relations
608 Citations2004Nanda Kambhatla
This work employs Maximum Entropy models to combine diverse lexical, syntactic and semantic features derived from the text to obtain competitive results in the Automatic Content Extraction (ACE) evaluation.
Operating Systems Design and ImplementationUsing magpie for request extraction and workload modelling
578 Citations2004Paul Barham, Austin Donnelly +2 more
This paper describes and evaluates the capability of Magpie to accurately extract requests and construct representative models of system behaviour, and constructs concise workload models suitable for performance prediction and change detection.
Benchmark Handbook: For Database and Transaction Processing Systems
428 Citations1992Jim Gray
The handbook provides the tools to evaluate different systems, different software products on a single machine, and different machines within a single product family.
ACM Transactions on Information SystemsA probabilistic relational algebra for the integration of information retrieval and database systems
406 Citations1997Norbert Fuhr, Thomas Rölleke
The concept of vague predicates which yield probabilistic weights instead of Boolean values are introduced, thus allowing for queries with vague selection conditions and implements uncertainty and vagueness in combination with the relational model.
The object data standard: ODMG 3.0
342 Citations2000Mark Berler, Jeff Eastman +7 more
The Object Model and Object Specification Languages are described, in detail, as well as providing a description of how these languages are implemented, and some examples of how they might be implemented in practice are described.
DB2 advisor: an optimizer smart enough to recommend its own indexes
290 Citations2002Gary Valentin, Michael J. Zuliani +3 more
The implementation of index recommendation, the user interface, and measurements on the quality of the recommended indexes are discussed, to introduce the concept of letting an RDBMS optimizer optimize its own environment.
Elsevier eBooksDatabase Tuning Advisor for Microsoft SQL Server 2005
208 Citations2004Sanjay Agrawal, Surajit Chaudhuri +4 more
Elsevier eBooksSelf-tuning Database Technology and Information Services
177 Citations2002Gerhard Weikum, Axel Moenkeberg +2 more
A major conclusion is that self-tuning database technology should be based on the paradigm of a feedback control loop, but is also bound to build on mathematical models and their proper engineering into system components.
Self-tuning Database Technology and Information Services: from Wishful Thinking to Viable Engineering
102 Citations2002Gerhard Weikum, Axel Mönkeberg +2 more
Community Information Management.
90 Citations2006AnHai Doan, Raghu Ramakrishnan +6 more
This work describes the envisioned working of a software platform that can be rapidly deployed and customized to manage data-rich online communities and its prototype, DBLife, which is a community portal being developed for the database research community.
Infoscience (Ecole Polytechnique Fédérale de Lausanne)Continuous resource monitoring for self-predicting DBMS
62 Citations2005Dushyanth Narayanan, Eno Thereska +1 more
This paper proposes changes to database system design that enable a Resource Advisor to answer "what-if" questions about resource upgrades and shows the efficacy of the approach in predicting the effect of upgrading a key resource-buffer pool size-on OLTP workloads in a highly concurrent system.
arXiv (Cornell University)Information Extraction - A User Guide
36 Citations1997Hamish Cunningham
This technical memo describes Information Extraction from the point-of-view of a potential user of the technology.
End-to-end tracing considered essential
4 Citations2005Dushyanth Narayanan
End-to-end event tracing is advocated as the correct way to expose performance information for both human and automated analysis, and its uses in performance visualization, prediction for capacity planning, and anomaly detection are illustrated.