US Patent No: 6,249,791

Number of patents in Portfolio can not be more than 2000

Summary table management in a computer system

Stats

ATTORNEY / AGENT: (SPONSORED)
 

Importance

Loading Importance Indicators... loading....

Abstract

A self monitoring system that identifies optimum summary table(s) for use by a database management system, and that automatically creates or deletes summary tables based on selected summary table recommendations.

Loading the Abstract Image... loading....

First Claim

Related Publications

Loading Related Publications... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
ORACLE INTERNATIONAL CORPORATIONREDWOOD SHORES, CA3637

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Cave, Stephen D Gloucester, GB 3 88
Lavender, Robert L Somerset, GB 3 88
Osborn, Andrew P Bath, GB 4 164

Cited Art

Patent Info (Count) # Cites Year
 
COMPUTER ASSOCIATES THINK, INC. (1)
5,675,785 Data warehouse which is accessed by a user using a schema of virtual tables 106 1994
 
MICROSOFT CORPORATION (1)
5,664,173 Method and apparatus for generating database queries from a meta-query pattern 60 1995
 
ORACLE INTERNATIONAL CORPORATION (1)
5,404,510 Database index design based upon request importance and the reuse and modification of similar existing indexes 112 1992
 
SIEMENS CORPORATION;INTELLECTUAL PROPERTY DEPARTMENT (1)
5,864,846 Method for facilitating world wide web searches utilizing a document distribution fusion strategy 129 1996
 
OTHER [CHECK PATENT PROFILE FOR ASSIGNMENT INFORMATION] (1)
5,519,859 Method and apparatus for automatic table selection and generation of structured query language instructions 67 1993

Patent Citation Ranking

Forward Cites

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (12)
7,110,991 IDE integration with JDBC 4 2002
7,447,687 Methods to browse database query information 6 2002
7,716,167 System and method for automatically building an OLAP model in a relational database 8 2002
7,181,450 Method, system, and program for use of metadata to create multidimensional cubes in a relational database 49 2002
7,020,649 System and method for incrementally maintaining non-distributive aggregate functions in a relational database 6 2002
7,953,694 Method, system, and program for specifying multidimensional calculations for a relational OLAP engine 0 2003
7,895,191 Improving performance of database queries 7 2003
7,707,143 Systems, methods, and computer program products that automatically discover metadata objects and generate multidimensional models 2 2004
7,480,663 Model based optimization with focus regions 6 2004
7,814,072 Management of database statistics 1 2004
7,873,664 Systems and computer program products to browse database query information 0 2008
7,984,024 Statistics management 0 2008
 
YANICKLO TECHNOLOGY LIMITED LIABILITY COMPANY (4)
7,315,849 Enterprise-wide data-warehouse with integrated data aggregation engine 35 2002
8,195,602 Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines 0 2009
8,170,984 System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner 1 2009
8,041,670 Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines 3 2010
 
GOOGLE INC. (2)
7,167,853 Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables 5 2002
7,302,422 Query workload statistics collection in a database management system 16 2004
 
BRIGHT SUN TECHNOLOGIES (1)
7,254,584 Relationship-based inherited attributes system 9 2000
 
ORACLE INTERNATIONAL CORPORATION (1)
7,467,152 Query generator 2 2000
 
YANICKLO TECHNOLOGY LIMITED LIABILITY (1)
8,321,373 Method of servicing query statements from a client machine using a database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) 2009

Maintenance Fees

Fee Large entity fee small entity fee micro entity fee due date
11.5 Year Payment $7400.00 $3700.00 $1850.00 Dec 19, 2012
Fee Large entity fee small entity fee micro entity fee
Surcharge - 11.5 year - Late payment within 6 months $160.00 $80.00 $40.00
Surcharge after expiration - Late payment is unavoidable $700.00 $350.00 $175.00
Surcharge after expiration - Late payment is unintentional $1,640.00 $820.00 $410.00