Materialized views
R Chirkova, J Yang - Foundations and Trends® in …, 2012 - nowpublishers.com
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 …
Ti: an efficient indexing mechanism for real-time search on tweets
Real-time search dictates that new contents be made available for search immediately
following their creation. From the database perspective, this requirement may be quite easily …
following their creation. From the database perspective, this requirement may be quite easily …
Multiple dimensioned database architecture
O Herrnstadt - US Patent 8,150,850, 2012 - Google Patents
A database management system stores data form a plurality of logical tables as independent
copies in different format. In one specific example the system organizes tables into table …
copies in different format. In one specific example the system organizes tables into table …
Raven: Accelerating execution of iterative data analytics by reusing results of previous equivalent versionsFree GPT-4
Using GUI-based workflows for data analysis is an iterative process. During each iteration,
an analyst makes changes to the workflow to improve it, generating a new version each …
an analyst makes changes to the workflow to improve it, generating a new version each …
Coupling materialized view selection to multi query optimization: hyper graph approach
Materialized views are queries whose results are stored and maintained in order to facilitate
access to data in their underlying base tables of extremely large databases. Selecting the …
access to data in their underlying base tables of extremely large databases. Selecting the …
Selecting and using views to compute aggregate queries
We consider a workload of aggregate queries and investigate the problem of selecting views
that (1) provide equivalent rewritings for all queries, and (2) are optimal, in that the cost of …
that (1) provide equivalent rewritings for all queries, and (2) are optimal, in that the cost of …
A framework for systematic database de-normalization
Y Pinto - 2009 - irgu.unigoa.ac.in
It is currently the norm that relational database designs should be based on a normalized
logical data model. The primary objective of this design technique is data integrity and …
logical data model. The primary objective of this design technique is data integrity and …
Quickpoint: Efficiently identifying densest sub-graphs in online social networks for event stream dissemination
Efficient event stream dissemination is a challenging problem in large-scale Online Social
Network (OSN) systems due to the costly inter-server communications caused by the per …
Network (OSN) systems due to the costly inter-server communications caused by the per …
Selecting and using views to compute aggregate queries
We consider a workload of aggregate queries and investigate the problem of selecting
materialized views that (1) provide equivalent rewritings for all the queries, and (2) are …
materialized views that (1) provide equivalent rewritings for all the queries, and (2) are …
SQL scorecard for improved stability and performance of data warehouses
N Rahman - International Journal of Software Innovation (IJSI), 2016 - igi-global.com
Scorecard-based measurement techniques are used by organizations to measure the
performance of their business operations. A scorecard approach could be applied to a …
performance of their business operations. A scorecard approach could be applied to a …