Filters








73,656 Hits in 4.7 sec

Cost-Based Query Optimization in Centralized Relational Databases

Nawaraj Paudel, Jagdish Bhatta
2019 Journal of Institute of Science and Technology  
Query optimization is the most significant factor for any centralized relational database management system (RDBMS) that reduces the total execution time of a query.  ...  In this paper, cost is considered by counting number of disk accesses for each query plan because disk access tends to be the dominant cost in query processing for centralized relational databases.  ...  Cost estimation for queries experiencing multiple contention states in dynamic multi-database environments. Journal of Knowledge and Information Systems Publishers 5(1): 26-49.  ... 
doi:10.3126/jist.v24i1.24627 fatcat:krutrycy3vekfaxqvwctt37so4

A Cost Estimation Technique for Recursive Relational Algebra

Muideen Lawal, Pierre Genevès, Nabil Layaïda
2020 Proceedings of the 29th ACM International Conference on Information & Knowledge Management  
CCS CONCEPTS • Information systemsDatabase management system engines; • Theory of computation → Database theory; Database query processing and optimization (theory).  ...  In this paper, we propose a new cost estimation technique for recursive terms of the extended relational algebra.  ...  This contribution can be implemented in mainstream database management systems supporting recursive query evaluation.  ... 
doi:10.1145/3340531.3417460 dblp:conf/cikm/LawalGL20 fatcat:zi23ffpkv5gxfjhyklq4u3e5pq

A Review on Query Optimization in Generic RDBMS

Purushottam Patel
2019 International Journal for Research in Applied Science and Engineering Technology  
Fig. 4: Executing SQL queries in a relational database system  ...  The query execution plan is evaluated and results are passed back to the user in the form of a relational table. Figure 2.1: Executing SQL queries in a relational database system.  ...  Relational database management systems (RDBMSs) let users specify queries using high level declarative languages such as SQL.  ... 
doi:10.22214/ijraset.2019.3021 fatcat:zirwkihi3vbabbasvpwvrpyv4m

Why it is time for a HyPE

Sebastian Breß, Gunter Saake
2013 Proceedings of the VLDB Endowment  
GPU acceleration is a promising approach to speed up query processing of database systems by using low cost graphic processors as coprocessors.  ...  database systems, because of their analytical-algorithm-specific cost models.  ...  cost estimation and query plan selection and (2) a database system dependent layer, which basically maps the first layer to a concrete database management system.  ... 
doi:10.14778/2536274.2536325 fatcat:vjo2yeoswnd4vps62jh5mmz5py

Technical perspectiveRelational query optimization

Surajit Chaudhuri
2009 Communications of the ACM  
rELATIONAL SySTEMS HAVE made it possible to query large collections of data in a declarative style through languages such as SQL.  ...  I invite you to read the following paper to sample a subfield that lies at the intersection of database management systems, statistics, and algorithms.  ...  rELATIONAL SySTEMS HAVE made it possible to query large collections of data in a declarative style through languages such as SQL.  ... 
doi:10.1145/1562764.1562786 fatcat:z2nlikm6kvhtrjiabrv7sh3ety

Automated Performance Tuning of Data Management Systems with Materializations and Indices

Nan N. Noon, Janusz R. Getta
2016 Journal of Computer and Communications  
In this paper, we propose a new technique for automated performance tuning of data management systems.  ...  Automated performance tuning of data management systems offer various benefits such as improved performance, declined administration costs, and reduced workloads to database administrators (DBAs).  ...  In this paper, we present two group of algorithms for automated tuning of database management systems.  ... 
doi:10.4236/jcc.2016.45007 fatcat:f5bykiumqfa2dfojn5yqamlsku

A Study on Optimization of Top-k Queries in Relational Databases

Neha Singh Neha Singh
2013 IOSR Journal of Computer Engineering  
Efficient execution of top-k queries is increasingly becoming a major challenge for relational database technology. Top-k query has emerged as a key requirement in modern application.  ...  This property directly impacts the optimization of top-k queries by optimizing for the first k results. Traditionally, most real world database systems offer the feature of first n row optimization.  ...  Relational Database A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.  ... 
doi:10.9790/0661-01043840 fatcat:ho2rm5lj3bgn5k64nnsbk47vli

Online Energy Estimation of Relational Operations in Database Systems

Zichen Xu, Yi-Cheng Tu, Xiaorui Wang
2015 IEEE transactions on computers  
The quantification of the energy cost of database systems is an important task in design.  ...  Our models are implemented in a real database management system and evaluated on a physical test bed.  ...  Energy management in database systems: work in energyefficient database systems can be traced back to the early 1990's.  ... 
doi:10.1109/tc.2015.2394309 fatcat:ocysnqvqmjcjdiq4sghb2fp5vi

TIMBER

Stelios Paparizos, Yuqing Wu, Cong Yu, Shurug Al-Khalifa, Adriane Chapman, H. V. Jagadish, Laks V. S. Lakshmanan, Andrew Nierman, Jignesh M. Patel, Divesh Srivastava, Nuwee Wiwatwattana
2003 Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03  
XML has become ubiquitous, and XML data has to be managed in databases. The current industry standard is to map XML data into relational tables and store this information in a relational database.  ...  We believe that the key intellectual contribution of this system is a comprehensive set-at-a-time query processing ability in a native XML store, with all the standard components of relational query processing  ...  SYSTEM OVERVIEW The central idea in the TIMBER [4] project is to construct an XML database that has an overall architecture similar to that of a relational database.  ... 
doi:10.1145/872858.872862 fatcat:7et2izo53jhrviksvlvanqu72e

An Expert System for Metal Resources Exploration and Mining Feasibility Evaluation

Jianhong Chen, Qinghua Song, Shan Yang, Zhiyong Zhou
2017 Geo-Resources Environment and Engineering  
management and comprehensive query.  ...  The system is an auxiliary management system for metal resources technical and economic evaluation and has the basic functions of auxiliary decision analysis, metal resources database management, data  ...  , investment estimation of mine construction, cost estimation of other engineering construction, cost estimation, wage estimation and main indexes of project.  ... 
doi:10.15273/gree.2017.02.014 fatcat:2bpoaqoxofhmfptrw45toaquoa

Analysis of Query Using Join and Semi-join
IJARCCE - Computer and Communication Engineering

GURMINDER SINGH BOPARAI, SATISH KUMAR
2014 IJARCCE  
Query optimization is much more difficult in Distributed Database as compared to the Centralised Database System.  ...  We have two approaches for storing and managing database namely Centralised Database management system and Distributed Database management system.  ...  The integration of a query processing subsystem into a distributed database management system is used for analyzing query response time across fragmentations of global relations.  ... 
doi:10.17148/ijarcce.2014.31106 fatcat:n42anaxw5jfapmldkkbushabom

TIMBER

Stelios Paparizos, Yuqing Wu, Cong Yu, Shurug Al-Khalifa, Adriane Chapman, H. V. Jagadish, Laks V. S. Lakshmanan, Andrew Nierman, Jignesh M. Patel, Divesh Srivastava, Nuwee Wiwatwattana
2003 Proceedings of the 2003 ACM SIGMOD international conference on on Management of data - SIGMOD '03  
XML has become ubiquitous, and XML data has to be managed in databases. The current industry standard is to map XML data into relational tables and store this information in a relational database.  ...  We believe that the key intellectual contribution of this system is a comprehensive set-at-a-time query processing ability in a native XML store, with all the standard components of relational query processing  ...  SYSTEM OVERVIEW The central idea in the TIMBER [4] project is to construct an XML database that has an overall architecture similar to that of a relational database.  ... 
doi:10.1145/872757.872862 dblp:conf/sigmod/PaparizosACJLNPSWWY03 fatcat:kmq6yiwnojcu3kkbmohsobaxei

Designing workshop management system supporting decision making with OODB

İlhami M. Orak, Beyza Yaman, Giovanna Guerrini
2012 Procedia Technology - Elsevier  
of production from planned cost, cost estimation of new production, etc.  ...  In this study, a workshop production management system supporting decision making is designed for use in small and mediumsized machine workshops.  ...  In order to develop an effective system, the basic idea is considered as follows: All information which is related to cost is to be defined and stored in the database.  ... 
doi:10.1016/j.protcy.2012.02.006 fatcat:7i2z53sqxbgxhlglk5d4fyjrjq

Building a power-aware database management system

Zichen Xu
2010 Proceedings of the Fourth SIGMOD PhD Workshop on Innovative Database Research - IDAR '10  
This paper describes the author's thesis work on creating a poweraware database management (P-DBMS) and initial ideas on the design of such systems, with the focus on a power-aware query optimization module  ...  We focus our discussions on a power model to accurately measure the energy costs of query executions plans, and a cost evaluation model for plan selection.  ...  We review related work in energy consumption in database systems and some experimental studies in database hardware configurations 1.1.  ... 
doi:10.1145/1811136.1811137 fatcat:uq55gqp3cvdvnkutigo4w2m444

Query optimization

Yannis E. Ioannidis
1996 ACM Computing Surveys  
Given a query, there are many access plans that a database management system (DBMS) can follow to process it and produce its answer.  ...  It compares these plans based on estimates of their cost derived by the Cost Model and the Size-Distribution Estimator modules and selects the overall cheapest one to be used to generate the answer to  ...  Given a query, there are many access plans that a database management system (DBMS) can follow to process it and produce its answer.  ... 
doi:10.1145/234313.234367 fatcat:3grgnzzrkjhtfdf6k32eosugzy
« Previous Showing results 1 — 15 out of 73,656 results