Enhanced user view/update capability for managing data from relational tables
J Gardner - US Patent 6,058,391, 2000 - Google Patents
707/4; 707/10; 707/100; 707/102 57 ABSTRACT 58 Field of Search................................ 707/1-
3, 8, 103, 707/200, 4, 10, 100, 102; 705/26 A System and method for creating customizable …
3, 8, 103, 707/200, 4, 10, 100, 102; 705/26 A System and method for creating customizable …
Outerjoin simplification and reordering for query optimization
C Galindo-Legaria, A Rosenthal - ACM Transactions on Database …, 1997 - dl.acm.org
Conventional database optimizers take full advantage of associativity and commutativity
properties of join to implement efficient and powerful optimizations on select/project/join …
properties of join to implement efficient and powerful optimizations on select/project/join …
Hypergraph based reorderings of outer join queries with complex predicates
G Bhargava, P Goel, B Iyer - Proceedings of the 1995 ACM SIGMOD …, 1995 - dl.acm.org
Complex queries containing outer joins are, for the most part, executed by commercial
DBMS products in an" as written" manner. Only a very few reorderings of the operations are …
DBMS products in an" as written" manner. Only a very few reorderings of the operations are …
Method and apparatus for efficiently refreshing sets of summary tables and materialized views in a database management system
WD Norcott, M Ziauddin - US Patent 6,334,128, 2001 - Google Patents
A method and apparatus for refreshing stale materialized views is provided. Prior to
executing a query to refresh a materialized view from data in the base tables of the …
executing a query to refresh a materialized view from data in the base tables of the …
The Ode active database: Trigger semantics and implementation
BF Lieuwen, N Gehani, R Arlein - Proceedings of the Twelfth …, 1996 - ieeexplore.ieee.org
Ode is an active database system and environment based on the object paradigm. Triggers
are the basic ingredient of active databases. Ode triggers are event-action pairs. An event …
are the basic ingredient of active databases. Ode triggers are event-action pairs. An event …
Context-based prefetch–an optimization for implementing objects on relations
PA Bernstein, S Pal, D Shutt - The VLDB Journal, 2000 - Springer
When implementing persistent objects on a relational database, a major performance issue
is prefetching data to minimize the number of round-trips to the database. This is especially …
is prefetching data to minimize the number of round-trips to the database. This is especially …
Incremental maintenance of materialized views containing one-to-one lossless joins
A Witkowski, K Dias - US Patent 6,134,543, 2000 - Google Patents
[57] ABSTRACT A method and apparatus are provided for performing incre mental refreshes
to materialized views de? ned by one-to one lossless joins. Each base table of the …
to materialized views de? ned by one-to one lossless joins. Each base table of the …
Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins
R Bello, J Finnerty, M Ziauddin, A Witkowski - US Patent 6,477,525, 2002 - Google Patents
A method and system are provided for processing queries. According to one aspect of the
invention, a query that does not reference a particular materialized view is rewritten to …
invention, a query that does not reference a particular materialized view is rewritten to …
Using estimated cost to schedule an order for refreshing a set of materialized views (MVS)
NK Folkert, A Gupta, A Witkowski - US Patent 7,890,497, 2011 - Google Patents
US. PATENT DOCUMENTS 6,560,476 B1 5/2003 Pelletier et al. 6,629,094 B1 9/2003 Colby
et al. 5,444,842 A 8/1995 Bentson et al. 6,741,997 B1 5/2004 Liu et al '5,548,755 A 8/1996 …
et al. 5,444,842 A 8/1995 Bentson et al. 6,741,997 B1 5/2004 Liu et al '5,548,755 A 8/1996 …
Object-oriented materialized views
W Smith, M Subramaniam, S Muralidhar - US Patent 7,158,994, 2007 - Google Patents
5,261,098 A 11/1993 Katin et al. 5,276,870 A 1/1994 Shan et al. 5,404,506 A 4/1995
Fujisawa et al. 5,418,946 A 5, 1995 Mori 5,444,842 A 8, 1995 Bentson et al. 5,548,755 A …
Fujisawa et al. 5,418,946 A 5, 1995 Mori 5,444,842 A 8, 1995 Bentson et al. 5,548,755 A …