A survey of view selection methods
Materialized view selection is a critical problem in many applications such as query
processing, data warehousing, distributed and semantic web databases, etc. We refer to the …
processing, data warehousing, distributed and semantic web databases, etc. We refer to the …
Llm-pbe: Assessing data privacy in large language models
Large Language Models (LLMs) have become integral to numerous domains, significantly
advancing applications in data management, mining, and analysis. Their profound …
advancing applications in data management, mining, and analysis. Their profound …
C-store: a column-oriented DBMS
This paper presents the design of a read-optimized relational DBMS that contrasts sharply
with most current systems, which are write-optimized. Among the many differences in its …
with most current systems, which are write-optimized. Among the many differences in its …
[PDF][PDF] Automated selection of materialized views and indexes in SQL databases
Automatically selecting an appropriate set of materialized views and indexes for SQL
databases is a non-trivial task. A judicious choice must be cost-driven and influenced by the …
databases is a non-trivial task. A judicious choice must be cost-driven and influenced by the …
Efficient and extensible algorithms for multi query optimization
Complex queries are becoming commonplace, with the growing use of decision support
systems. These complex queries often have a lot of common sub-expressions, either within …
systems. These complex queries often have a lot of common sub-expressions, either within …
ROLAP implementations of the data cube
Implementation of the data cube is an important and scientifically interesting issue in On-
Line Analytical Processing (OLAP) and has been the subject of a plethora of related …
Line Analytical Processing (OLAP) and has been the subject of a plethora of related …
[كتاب][B] Database modeling and design: logical design
TJ Teorey, SS Lightstone, T Nadeau, HV Jagadish - 2011 - books.google.com
Database Modeling and Design, Fifth Edition, focuses on techniques for database design in
relational database systems. This extensively revised fifth edition features clear …
relational database systems. This extensively revised fifth edition features clear …
Materialized views
Materialized views are queries whose results are stored and maintained in order to facilitate
access to data in their underlying base tables. In the SQL setting, they are now considered a …
access to data in their underlying base tables. In the SQL setting, they are now considered a …
Database tuning principles, experiments, and troubleshooting techniques
As our reliance on computers and computerized data has increased, we have come to
expect more from our computers. We no longer expect our computers to act as large …
expect more from our computers. We no longer expect our computers to act as large …
[كتاب][B] Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more
SS Lightstone, TJ Teorey, T Nadeau - 2010 - books.google.com
The rapidly increasing volume of information contained in relational databases places a
strain on databases, performance, and maintainability: DBAs are under greater pressure …
strain on databases, performance, and maintainability: DBAs are under greater pressure …