(57) ABSTRACT A method, System and article of manufacture are provided which enhance
the ability to aggregate, analyze and report data from a multidimensional database in a …

Database query optimizers benefit greatly from accurate cardinality estimation; however, this
is hard to achieve on tables with correlated and/or skewed columns. We present a novel …

(57) ABSTRACT A query rewrite optimization method eliminates condition predicates of
conditional expressions defining the values of a column that is referenced in the predicate of …

(57) ABSTRACT A System for automated installation and maintenance of databases. One or
more embodiments provide a user inter face (or wizard) that obtains information from a user …

US7249120B2 - Method and apparatus for selecting candidate statistics to estimate the selectivity
value of the conditional selectivity expression in optimize queries based on a set of predicates …

Disclosed is a method, system, and program for performing a join operation on a multi-
column table and at least two satellite tables having a join condition. Each satellite table is …

A database management system and method provides access to a data table having
structured data and unstructured data. A user interface allows a user to issue instructions to …

Methods are provided for automatically discovering correlations between values in columns
of tables. A set of significantly correlated columns is identified by identifying correlated …

A computer-implemented database and method providing an efficient, ordered reduced
space representation of multi-dimensional data. The data values for each attribute are stored …

A method, computer program, and database system are disclosed for executing database
queries. The database includes a first table (T1) having a primary key (PK) column and a first …