Live briefing
Everything about Materialized view
In databases, cached query results
In computing, a materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary using an aggregate function. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Materialized viewA 5-minute orientation
- Skim a recent paper: Multi‐objective materialized view selection using flamingo search optimization algorithmInfluential work since 2022
- Pick up a classic book: Nicomachean EthicsThe most-reprinted book on the subject
- Read the landmark paper: Materialized view selection as constrained evolutionary optimizationCited 77 times
- Go sideways: Comparison of relational database management systemsA closely related topic
- Go sideways: Spatial databaseA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Materialized view selection as constrained evolutionary optimization
Materialized view selection and maintenance using multi-query optimization
Materialized view maintenance and integrity constraint checking
Evolutionary game theory approach to materialized view selection in data warehouses
Materialized view selection under the maintenance time constraint
Materialized view selection using HBMO
Materialized View Selection using Artificial Bee Colony Optimization
Materialized View Selection using Improvement based Bee Colony Optimization
🆕 Influential since 2022
Multi‐objective materialized view selection using flamingo search optimization algorithm
Materialized View Selection & View-Based Query Planning for Regular Path Queries
Proactive and intelligent evaluation of big data queries in edge clouds with materialized views
AutoView: An Autonomous Materialized View Management System with Encoder-Reducer
ProRes: Proactive re-selection of materialized views
📚 Books worth reading
Nicomachean EthicsAristotle · 1558
MoraliaPlutarch · 1500
Mein KampfAdolf Hitler · 1922
La Pensée politique et sociale de BalzacBernard Guyon · 1947- 📕Gramsci, Materialism, and PhilosophyEsteve Morera · 2014
Karl MarxAllan Megill · 2001- 📕Marx's TemporalitiesMassimiliano Tomba, Sara R. Farris · 2012
Aristotle's Theory of Material SubstanceGad Freudenthal · 1995
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
- Spatial database A spatial database is a general-purpose database (usually a relational database) that has been enhanced to include spatial data that represents objects…
- Hierarchical and recursive queries in SQL A hierarchical query is a type of SQL query that handles hierarchical model data. These are useful for working with databases of graph-structured data…
- PostgreSQL PostgreSQL (/ˈpoʊstɡrɛskjuˌɛl/ POHST-gres-kew-EL), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing…
- View (SQL) In a database, a view is the result set of a stored query that presents a limited perspective of the database to a user. This pre-established query command…
- Merge (SQL) A relational database management system uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE or DELETE existing records depending…
- Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
- List of databases using MVCC The following database management systems and other software use multiversion concurrency control. Altibase Berkeley DB Cloudant Cloud Spanner Clustrix…