Sciweavers

37 search results - page 5 / 8
» Optimal load shedding with aggregates and mining queries
Sort
View
ECAI
2010
Springer
13 years 8 months ago
Learning Aggregation Functions for Expert Search
Abstract. Machine learning techniques are increasingly being applied to problems in the domain of information retrieval and text mining. In this paper we present an application of ...
Ronan Cummins, Mounia Lalmas, Colm O'Riordan
DAWAK
2003
Springer
14 years 22 days ago
Fighting Redundancy in SQL
Abstract. Many SQL queries with aggregated subqueries exhibit redundancy (overlap in FROM and WHERE clauses). We propose a method, called the for-loop, to optimize such queries by ...
Antonio Badia, Dev Anand
SIGMOD
1999
ACM
101views Database» more  SIGMOD 1999»
13 years 11 months ago
Join Synopses for Approximate Query Answering
In large data warehousing environments, it is often advantageous to provide fast, approximate answers to complex aggregate queries based on statistical summaries of the full data....
Swarup Acharya, Phillip B. Gibbons, Viswanath Poos...
CIDR
2011
266views Algorithms» more  CIDR 2011»
12 years 11 months ago
Consistency in a Stream Warehouse
A stream warehouse is a Data Stream Management System (DSMS) that stores a very long history, e.g. years or decades; or equivalently a data warehouse that is continuously loaded. ...
Lukasz Golab, Theodore Johnson
VLDB
1998
ACM
126views Database» more  VLDB 1998»
13 years 11 months ago
Materialized Views in Oracle
Oracle Materialized Views (MVs) are designed for data warehousing and replication. For data warehousing, MVs based on inner/outer equijoins with optional aggregation, can be refre...
Randall G. Bello, Karl Dias, Alan Downing, James J...