Distributed databases principles and systems
Distributed databases principles and systems
Probabilistic counting algorithms for data base applications
Journal of Computer and System Sciences
File systems: design & implementation
File systems: design & implementation
The first electronic computer: the Atanasoff story
The first electronic computer: the Atanasoff story
Physical database design for relational databases
ACM Transactions on Database Systems (TODS)
An algorithm for multidimensional data clustering
ACM Transactions on Mathematical Software (TOMS)
File systems: structures and algorithms
File systems: structures and algorithms
Mind children: the future of robot and human intelligence
Mind children: the future of robot and human intelligence
A case for redundant arrays of inexpensive disks (RAID)
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
Defining data types in a database language
ACM SIGMOD Record
File organization for database design
File organization for database design
Failure correction techniques for large disk arrays
ASPLOS III Proceedings of the third international conference on Architectural support for programming languages and operating systems
Distributed database design: a practical approach and example
ACM SIGMOD Record
The relational model for database management: version 2
The relational model for database management: version 2
Optimal Selection of Secondary Indexes
IEEE Transactions on Software Engineering
Principles of distributed database systems
Principles of distributed database systems
Comments on an Optimal Set of Indices for a Relational Database
IEEE Transactions on Software Engineering
Parallel database systems: the future of high performance database systems
Communications of the ACM
Partially preemptible hash joins
SIGMOD '93 Proceedings of the 1993 ACM SIGMOD international conference on Management of data
On the relative cost of sampling for join selectivity estimation
PODS '94 Proceedings of the thirteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
A decomposition-based simulated annealing technique for data clustering
PODS '94 Proceedings of the thirteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Performance and design evaluation of the RAID-II storage server
Distributed and Parallel Databases - Special issue on disk arrays
On the selection of secondary indices in relational databases
Data & Knowledge Engineering
The COMFORT automatic tuning project
Information Systems
A new approach to I/O performance evaluation: self-scaling I/O benchmarks, predicted I/O performance
ACM Transactions on Computer Systems (TOCS) - Special issue on computer architecture
Terabytes teraflops or why work on processors when I/O is where the action is? (abstract)
CSC '94 Proceedings of the 22nd annual ACM computer science conference on Scaling up : meeting the challenge of complexity in real-world computing applications: meeting the challenge of complexity in real-world computing applications
Multi-table joins through bitmapped join indices
ACM SIGMOD Record
Balancing histogram optimality and practicality for query result size estimation
SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
An introduction to genetic algorithms
An introduction to genetic algorithms
BIRCH: an efficient data clustering method for very large databases
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Implementing data cubes efficiently
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Bifocal sampling for skew-resistant join size estimation
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Goal-oriented buffer management revisited
SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
Selectivity and cost estimation for joins based on random sampling
Journal of Computer and System Sciences
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Automatic subspace clustering of high dimensional data for data mining applications
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
AutoAdmin “what-if” index analysis utility
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Random sampling for histogram construction: how much is enough?
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Memory management during run generation in external sorting
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Microsoft index turning wizard for SQL Server 7.0
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
Computer architecture (2nd ed.): a quantitative approach
Computer architecture (2nd ed.): a quantitative approach
Memory allocation strategies for complex decision support queries
Proceedings of the seventh international conference on Information and knowledge management
A spatial data mining method by clustering analysis
Proceedings of the 6th ACM international symposium on Advances in geographic information systems
Semantic clustering and querying on heterogeneous features for visual data
MULTIMEDIA '98 Proceedings of the sixth ACM international conference on Multimedia
Dynamic maintenance of multidimensional range data partitioning for parallel data processing
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
Snakes and sandwiches: optimal clustering strategies for a data warehouse
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Multi-dimensional selectivity estimation using compressed histogram information
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Join synopses for approximate query answering
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
Ripple joins for online aggregation
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
DynaMat: a dynamic view management system for data warehouses
SIGMOD '99 Proceedings of the 1999 ACM SIGMOD international conference on Management of data
The Asilomar report on database research
ACM SIGMOD Record
Statistical estimators for relational algebra expressions
Proceedings of the seventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
Clustering techniques for large data sets—from the past to the future
KDD '99 Tutorial notes of the fifth ACM SIGKDD international conference on Knowledge discovery and data mining
Entropy-based subspace clustering for mining numerical data
KDD '99 Proceedings of the fifth ACM SIGKDD international conference on Knowledge discovery and data mining
CACTUS—clustering categorical data using summaries
KDD '99 Proceedings of the fifth ACM SIGKDD international conference on Knowledge discovery and data mining
Evaluating a class of distance-mapping algorithms for data mining and clustering
KDD '99 Proceedings of the fifth ACM SIGKDD international conference on Knowledge discovery and data mining
System R: an architectural overview
IBM Systems Journal
SAC '95 Proceedings of the 1995 ACM symposium on Applied computing
Rules-based object clustering: a data structure for symbolic VLSI synthesis and analysis
DAC '86 Proceedings of the 23rd ACM/IEEE Design Automation Conference
The Grid File: An Adaptable, Symmetric Multikey File Structure
ACM Transactions on Database Systems (TODS)
Algorithm and performance evaluation of adaptive multidimensional clustering technique
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
View indexing in relational databases
ACM Transactions on Database Systems (TODS)
A progressive view materialization algorithm
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Clustering declustered data for efficient retrieval
Proceedings of the eighth international conference on Information and knowledge management
Indexing techniques for wireless data broadcast under data clustering and scheduling
Proceedings of the eighth international conference on Information and knowledge management
A multiple-resolution method for edge-centric data clustering
Proceedings of the eighth international conference on Information and knowledge management
ACM Computing Surveys (CSUR)
Density biased sampling: an improved method for data mining and clustering
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
A clustering approach to multi-model ensemble analysis using SAMEX data: preliminary results
SAC '00 Proceedings of the 2000 ACM symposium on Applied computing - Volume 1
Database (2nd ed.): principles, programming, and performance
Database (2nd ed.): principles, programming, and performance
Efficient clustering of high-dimensional data sets with application to reference matching
Proceedings of the sixth ACM SIGKDD international conference on Knowledge discovery and data mining
A relational model of data for large shared data banks
Communications of the ACM - Special 25th Anniversary Issue
A relational model of data for large shared data banks
Communications of the ACM
Optimizing queries using materialized views: a practical, scalable solution
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
What's next in high-performance computing?
Communications of the ACM - Ontology: different ways of representing the same concept
ACM SIGMOD Record
Operating System Concepts
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Database Management Systems
Database Systems: The Complete Book
Database Systems: The Complete Book
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Automating physical database design in a parallel database
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Database tuning: principles, experiments, and troubleshooting techniques
Database tuning: principles, experiments, and troubleshooting techniques
Decision Support in the Data Warehouse
Decision Support in the Data Warehouse
Design of Database Structures
Access path selection in a relational database management system
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Extending the data base relational model to capture more meaning
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
SIGMOD '83 Proceedings of the 1983 ACM SIGMOD international conference on Management of data
Horizontal data partitioning in database design
SIGMOD '82 Proceedings of the 1982 ACM SIGMOD international conference on Management of data
Achieving scalability in OLAP materialized view selection
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Toward autonomic computing with DB2 universal database
ACM SIGMOD Record
Exact and Approximate Algorithms for the Index Selection Problem in Physical Database Design
IEEE Transactions on Knowledge and Data Engineering
A Pareto Model for OLAP View Size Estimation
Information Systems Frontiers
Adaptive and Automated Index Selection in RDBMS
EDBT '92 Proceedings of the 3rd International Conference on Extending Database Technology: Advances in Database Technology
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Indexing Techniques for Historical Databases
Proceedings of the Fifth International Conference on Data Engineering
fAST Refresh using Mass Query Optimization
Proceedings of the 17th International Conference on Data Engineering
Overcoming Limitations of Sampling for Aggregation Queries
Proceedings of the 17th International Conference on Data Engineering
Dynamic Memory Adjustment for External Mergesort
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
DBMSs on a Modern Processor: Where Does Time Go?
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Automated Selection of Materialized Views and Indexes in SQL Databases
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Multi-Dimensional Database Allocation for Parallel Data Warehouses
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Weaving Relations for Cache Performance
Proceedings of the 27th International Conference on Very Large Data Bases
Practical Skew Handling in Parallel Joins
VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
Managing Memory to Meet Multiclass Workload Response Time Goals
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Dynamic Memory Allocation for Multiple-Query Workloads
VLDB '93 Proceedings of the 19th International Conference on Very Large Data Bases
Memory-Contention Responsive Hash Joins
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Towards Automated Performance Tuning for Complex Workloads
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Sampling-Based Estimation of the Number of Distinct Values of an Attribute
VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Managing Intra-operator Parallelism in Parallel Database Systems
VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies
VLDB '96 Proceedings of the 22th 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
Query-Adaptive Data Space Partitioning using Variable-Size Storage Clusters
SSD '93 Proceedings of the Third International Symposium on Advances in Spatial Databases
Dynamic Reconfiguration Algorithm: Dynamically Tuning Multiple Buffer Pools
DEXA '00 Proceedings of the 11th International Conference on Database and Expert Systems Applications
Data placement in shared-nothing parallel database systems
The VLDB Journal — The International Journal on Very Large Data Bases
Storage estimation for multidimensional aggregates in OLAP
CASCON '99 Proceedings of the 1999 conference of the Centre for Advanced Studies on Collaborative research
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Managing Distributed Memory to Meet Multiclass Workload Response Time Goals
ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Rules of Thumb in Data Engineering
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
DB2 Advisor: An Optimizer Smart Enough to Recommend its own Indexes
ICDE '00 Proceedings of the 16th International Conference on Data Engineering
Goal-oriented dynamic buffer pool management for data base systems
ICECCS '95 Proceedings of the 1st International Conference on Engineering of Complex Computer Systems
Improving OLAP Performance by Multidimensional Hierarchical Clustering
IDEAS '99 Proceedings of the 1999 International Symposium on Database Engineering & Applications
An Introduction to Database Systems
An Introduction to Database Systems
Who Invented the Computer?: The Legal Battle That Changed Computing History
Who Invented the Computer?: The Legal Battle That Changed Computing History
Removing the Genetics from the Standard Genetic Algorithm
Removing the Genetics from the Standard Genetic Algorithm
Multi-dimensional clustering: a new data layout scheme in DB2
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Design and Evaluation of Alternative Selection Placement Strategies in Optimizing Continuous Queries
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Physical database design decision algorithms and concurrent reorganization for parallel database systems
Techniques for automatically sizing multiple buffer pools in DB2
CASCON '03 Proceedings of the 2003 conference of the Centre for Advanced Studies on Collaborative research
Physical Database Design Using Oracle
Physical Database Design Using Oracle
Feedback Control of Computing Systems
Feedback Control of Computing Systems
Outrageous Ideas and/or Thoughts While Shaving
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
A critique of the SQL database language
ACM SIGMOD Record
Database Systems Concepts
Incorporating Cost of Control into the Design of a Load Balancing Controller
RTAS '04 Proceedings of the 10th IEEE Real-Time and Embedded Technology and Applications Symposium
Where the Rubber Meets the Sky: The Semantic Gap between Data Producers and Data Consumers
SSDBM '04 Proceedings of the 16th International Conference on Scientific and Statistical Database Management
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
A bi-level Bernoulli scheme for database sampling
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Integrating vertical and horizontal partitioning into automated physical database design
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Data integration through database federation
IBM Systems Journal
Communications of the ACM - Voting systems
Fundamentals of Database Systems, Fourth Edition
Fundamentals of Database Systems, Fourth Edition
Professional SQL Server Analysis Services 2005 with MDX
Professional SQL Server Analysis Services 2005 with MDX
Automatic physical database tuning: a relaxation-based approach
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Database Modeling and Design: Logical Design (The Morgan Kaufmann Series in Data Management Systems)
Database Modeling and Design: Logical Design (The Morgan Kaufmann Series in Data Management Systems)
Recommending Materialized Views and Indexes with IBM DB2 Design Advisor
ICAC '04 Proceedings of the First International Conference on Autonomic Computing
ICCD '05 Proceedings of the 2005 International Conference on Computer Design
Scalable Exploration of Physical Database Design
ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
Load Balancing for Multi-tiered Database Systems through Autonomic Placement of Materialized Views
ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
Adaptive self-tuning memory in DB2
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming and Delivering Data
Statistics for the Utterly Confused, 2nd edition (Utterly Confused)
Statistics for the Utterly Confused, 2nd edition (Utterly Confused)
Modern Database Management (8th Edition)
Modern Database Management (8th Edition)
Oracle Data Warehouse Tuning for 10g
Oracle Data Warehouse Tuning for 10g
VLDB '81 Proceedings of the seventh international conference on Very Large Data Bases - Volume 7
SQL memory management in Oracle9i
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Optimal File Allocation in a Multiple Computer System
IEEE Transactions on Computers
On the Selection of an Optimal Set of Indexes
IEEE Transactions on Software Engineering
Efficient query processing for multi-dimensionally clustered tables in DB2
VLDB '03 Proceedings of the 29th international conference on Very large data bases - Volume 29
DB2 design advisor: integrated automatic physical database design
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Automatic SQL tuning in oracle 10g
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Automated design of multidimensional clustering tables for relational databases
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Self-managing technology in database management systems
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
The Data Warehouse Lifecycle Toolkit
The Data Warehouse Lifecycle Toolkit
Physical design refinement: the "merge-reduce" approach
EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
Self-tuning database systems: a decade of progress
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Preserving consistency and security of data in e-business applications
MCBE'10/MCBC'10 Proceedings of the 11th WSEAS international conference on mathematics and computers in business and economics and 11th WSEAS international conference on Biology and chemistry
Optimization of disk accesses for multidimensional range queries
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part I
On support of ordering in multidimensional data structures
ADBIS'10 Proceedings of the 14th east European conference on Advances in databases and information systems
Efficient content-based image retrieval using Multiple Support Vector Machines Ensemble
Expert Systems with Applications: An International Journal
Multidimensional implementation of stream ADT
WAIM'11 Proceedings of the 2011 international conference on Web-Age Information Management
Normalization in a mixed OLTP and OLAP workload scenario
TPCTC'11 Proceedings of the Third TPC Technology conference on Topics in Performance Evaluation, Measurement and Characterization
On the efficiency of multiple range query processing in multidimensional data structures
Proceedings of the 17th International Database Engineering & Applications Symposium
Hi-index | 0.00 |
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book.· The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition.· Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft).· Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!