Summary table management in a computer system

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 6249791
SERIAL NO

09314457

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

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

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
ORACLE INTERNATIONAL CORPORATIONREDWOOD SHORES, CA6457

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

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

Cited Art Landscape

Patent Info (Count) # Cites Year
 
Other [Check patent profile for assignment information] (1)
5519859 Method and apparatus for automatic table selection and generation of structured query language instructions 86 1993
 
ORACLE INTERNATIONAL CORPORATION (1)
5404510 Database index design based upon request importance and the reuse and modification of similar existing indexes 146 1992
 
CA, INC. (1)
5675785 Data warehouse which is accessed by a user using a schema of virtual tables 143 1994
 
MICROSOFT TECHNOLOGY LICENSING, LLC (1)
5664173 Method and apparatus for generating database queries from a meta-query pattern 73 1995
 
SIEMENS CORPORATION (1)
5864846 Method for facilitating world wide web searches utilizing a document distribution fusion strategy 232 1996
* Cited By Examiner

Patent Citation Ranking

Forward Cite Landscape

Patent Info (Count) # Cites Year
 
Other [Check patent profile for assignment information] (1)
* 2011/0099,167 Graph Server Querying for Managing Social Network Information Flow 4 2010
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (22)
* 7110991 IDE integration with JDBC 7 2002
* 2003/0172,076 Ide integration with JDBC 4 2002
7447687 Methods to browse database query information 7 2002
* 2003/0212,667 Systems, methods, and computer program products to browse database query information 0 2002
7716167 System and method for automatically building an OLAP model in a relational database 26 2002
7181450 Method, system, and program for use of metadata to create multidimensional cubes in a relational database 71 2002
* 2004/0122,646 System and method for automatically building an OLAP model in a relational database 35 2002
7020649 System and method for incrementally maintaining non-distributive aggregate functions in a relational database 17 2002
* 2004/0128,289 System and method for incrementally maintaining non-distributive aggregate functions in a relational database 1 2002
7953694 Method, system, and program for specifying multidimensional calculations for a relational OLAP engine 7 2003
* 7895191 Improving performance of database queries 28 2003
* 2004/0215,626 Method, system, and program for improving performance of database queries 146 2003
* 7707143 Systems, methods, and computer program products that automatically discover metadata objects and generate multidimensional models 12 2004
* 2005/0278,290 Systems, methods, and computer program products that automatically discover metadata objects and generate multidimensional models 23 2004
7480663 Model based optimization with focus regions 14 2004
* 2005/0283,494 Visualizing and manipulating multidimensional OLAP models graphically 24 2004
* 2007/0174,234 Data quality and validation within a relational database management system 2 2006
* 2008/0033,912 Query Workload Statistics Collection in a Database Management System 6 2007
7873664 Systems and computer program products to browse database query information 4 2008
* 2008/0133,582 SYSTEMS AND COMPUTER PROGRAM PRODUCTS TO BROWSE DATABASE QUERY INFORMATION 14 2008
7984024 Statistics management 1 2008
* 2009/0030,875 STATISTICS MANAGEMENT 3 2008
 
Yanicklo Technology Limited Liability (1)
8321373 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) 2 2009
 
TAMIRAS PER PTE. LTD., LLC (10)
* 7315849 Enterprise-wide data-warehouse with integrated data aggregation engine 56 2002
* 2003/0229,652 Enterprise-wide data-warehouse with integrated data aggregation engine 41 2002
8463736 Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements 2 2009
8473450 Relational database management system (RDBMS) employing multi-dimensional database (MDDB) for servicing query statements through one or more client machines 1 2009
8195602 Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines 11 2009
8170984 System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner 16 2009
8452804 Database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) for servicing query statements in a manner transparent to client machine 1 2009
8041670 Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines 18 2010
8788453 Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines 0 2011
8799209 Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines 5 2011
 
ORACLE INTERNATIONAL CORPORATION (3)
* 7467152 Query generator 3 2000
8856083 Framework to optimize delete all row operations on database objects to improve throughput, query ability and flashback 0 2006
* 2007/0288,529 Framework to optimize delete all rows operations on database objects 6 2006
 
CISCO TECHNOLOGY, INC. (2)
* 8738583 Efficiently delivering event messages using compiled indexing and paginated reporting 0 2011
* 2012/0203,794 EFFICIENTLY DELIVERING EVENT MESSAGES USING COMPILED INDEXING AND PAGINATED REPORTING 1 2011
 
LINKEDIN CORPORATION (1)
* 7814072 Management of database statistics 1 2004
 
FACEBOOK, INC. (3)
8572221 System and method for managing an online social network 4 2004
9241027 System and method for managing an online social network 0 2013
9703879 Graph server querying for managing social network information flow 0 2015
 
GOOGLE INC. (5)
* 7254584 Relationship-based inherited attributes system 12 2000
* 7167853 Matching and compensation tests for optimizing correlated subqueries within query using automatic summary tables 8 2002
* 2003/0088,558 Optimizing correlated queries using automatic summary tables 12 2002
* 7302422 Query workload statistics collection in a database management system 20 2004
* 2005/0234,900 Query workload statistics collection in a database management system 7 2004
 
YANICKLO TECHNOLOGY LIMITED LIABILITY COMPANY (6)
* 2002/0129,032 Database management system having a data aggregation module integrated therein 39 2001
* 2002/0129,003 Data database and database management system having data aggregation module integrated therein 38 2001
* 2003/0225,752 Central data warehouse with integrated data aggregation engine for performing centralized data aggregation operations 23 2002
* 2005/0091,237 Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements 12 2004
* 2005/0055,329 Database management system having data aggregation module integrated therein 31 2004
* 2005/0060,325 Method of and apparatus for data aggregation utilizing a multidimensional database and multi-stage data aggregation operations 38 2004
* Cited By Examiner