Logic-based approach to semantic query optimization
ACM Transactions on Database Systems (TODS)
A method for automatic rule derivation to support semantic query optimization
ACM Transactions on Database Systems (TODS)
Query evaluation techniques for large databases
ACM Computing Surveys (CSUR)
Mining association rules between sets of items in large databases
SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
An overview of query optimization in relational systems
PODS '98 Proceedings of the seventeenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Logic and Databases: A Deductive Approach
ACM Computing Surveys (CSUR)
Index selection in a self-adaptive data base management system
SIGMOD '76 Proceedings of the 1976 ACM SIGMOD international conference on Management of data
Access path selection in a relational database management system
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Accurate estimation of the number of tuples satisfying a condition
SIGMOD '84 Proceedings of the 1984 ACM SIGMOD international conference on Management of data
Dynamic Selectivity Estimation for Multidimensional Queries
FODO '93 Proceedings of the 4th International Conference on Foundations of Data Organization and Algorithms
Fast Algorithms for Mining Association Rules in Large Databases
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Efficient Evaluation of Queries with Mining Predicates
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Query optimization by semantic reasoning
Query optimization by semantic reasoning
Index Selection for Databases: A Hardness Study and a Principled Heuristic Solution
IEEE Transactions on Knowledge and Data Engineering
ACM Computing Surveys (CSUR)
Interestingness measures for data mining: A survey
ACM Computing Surveys (CSUR)
The history of histograms (abridged)
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
Bigtable: A Distributed Storage System for Structured Data
ACM Transactions on Computer Systems (TOCS)
Data mining-based materialized view and index selection in data warehouses
Journal of Intelligent Information Systems
Attribute extraction and scoring: A probabilistic approach
ICDE '13 Proceedings of the 2013 IEEE International Conference on Data Engineering (ICDE 2013)
| Hi-index | 0.00 |
Indexing technique has been used extensively in order to facilitate and optimize query processing in various data retrieval and storage systems. Although an index technique can be used to reduce searching cost in both horizontal and vertical dimensions, it incurs both storage and maintenance costs. Index selection has been an active research subject, and various index selection methods have been given in literature. This paper will present a framework to mine frequent query patterns to select most frequently used access paths as candidates for index selection, and a Bayesian based method will be used to select index fields from the candidate set.