US Patent No: 5,692,174

Number of patents in Portfolio can not be more than 2000

Query parallelism in a shared data DBMS system

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A system and method for a computer system having a plurality of DBMS providing a coordinating and assisting function. If a DBMS performs a coordinating function, it is referred to as a coordinating DBMS. If a DBMS performs an assisting function, it is referred to as an assisting DBMS. Each coordinating DBMS receives a query from a user application, decomposes the query into multiple parallel tasks, and allocates the parallel tasks to all of the DBMSs in the system. Each assisting DBMS receives one or more parallel tasks from a coordinating DBMS, executes the parallel tasks and returns the results to the coordinating DBMS. The coordinating DBMSs and assisting DBMSs access one or more storage devices. Furthermore, the present invention comprises a system and method for dynamically disabling a parallel mode on the coordinating DBMSs and the assisting DBMSs.

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

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
INTERNATIONAL BUSINESS MACHINES CORPORATIONARMONK, NY39112

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Bireley, William Robert Morgan Hill, CA 8 154
Dang, Tammie San Jose, CA 11 129
Desai, Paramesh Sampatrai San Jose, CA 6 210
Haderle, Donald James Los Gatos, CA 2 99
Lin, Fen-Ling San Jose, CA 35 493
McDevitt, Maureen Mae San Jose, CA 1 84
Shibamiya, Akira Los Altos, CA 17 519
Smith, Bryan Frederick Morgan Hill, CA 14 260
Teng, James Zu-chia San Jose, CA 45 740
Tie, Hong Sang Morgan Hill, CA 13 463
Wang, Yun Saratoga, CA 311 2818
Wong, Jerome Quan Mountain View, CA 3 164
Yang, Kou Horng Allen Santa Clara, CA 2 122
Zeidenstein, Kathryn Ruth Chicago, IL 3 127

Cited Art Landscape

Patent Info (Count) # Cites Year
 
INDIANA BUSINESS MODERNIZATION AND TECHNOLOGY CORPORATION (1)
* 5,548,770 Method and apparatus for improving retrieval of data from a database 29 1993
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (4)
* 4,633,387 Load balancing in a multiunit system 133 1983
* 5,392,430 Hierarchical scheduling method for processing tasks having precedence constraints on a parallel processing system 95 1992
* 5,495,606 System for parallel processing of complex read-only database queries using master and slave central processor complexes 130 1993
* 5,437,032 Task scheduler for a miltiprocessor system 149 1994
 
HONEYWELL BULL INC., A CORP. OF DE. (1)
* 4,769,772 Automated query optimization method using both global and parallel local optimizations for materialization access planning for distributed databases 279 1985
 
Information Builders, Inc. (1)
* 5,590,319 Query processor for parallel processing in homogenous and heterogenous databases 158 1993
 
Paralogic, Inc. (1)
* 5,471,622 Run-time system having nodes for identifying parallel tasks in a logic program and searching for available nodes to execute the parallel tasks 112 1995
* Cited By Examiner

Patent Citation Ranking

Forward Cite Landscape

Patent Info (Count) # Cites Year
 
THALVEG DATA FLOW LLC (1)
6,308,168 Metadata-driven data presentation module for database system 106 1999
 
SYBASE, INC. (4)
7,574,424 Database system with methodology for parallel schedule generation in a query optimizer 25 2004
* 2006/0080,285 Database System with Methodology for Parallel Schedule Generation in a Query Optimizer 47 2004
8,126,870 System and methodology for parallel query optimization using semantic-based partitioning 16 2005
* 2006/0218,123 System and Methodology for Parallel Query Optimization Using Semantic-Based Partitioning 150 2005
 
FITNESS FOODS, INC. (1)
* 7,844,620 Real time data replication for query execution in a massively parallel computer 4 2007
 
LINKEDIN CORPORATION (2)
7,805,434 Performing a non-invasive runtime simulation for a database system 1 2006
* 2007/0162,418 Method and system for performing a non-invasive runtime simulation for a database system 0 2006
 
AMAZON TECHNOLOGIES, INC. (6)
9,055,067 Flexible-location reservations and pricing for network-accessible resource capacity 1 2012
9,294,236 Automated cloud resource trading system 0 2012
9,240,025 Dynamic pricing of network-accessible resources for stateful applications 0 2012
9,246,986 Instance selection ordering policies for network-accessible resources 0 2012
9,306,870 Emulating circuit switching in cloud networking environments 0 2012
9,154,589 Bandwidth-optimized cloud resource placement service 0 2012
 
NS HOLDING COMPANY (1)
* 2005/0203,891 Automated domain name registration 3 2005
 
SERVICENOW, INC. (1)
* 8,095,512 Managing database resources used for optimizing query execution on a parallel computer system 3 2007
 
VERISIGN, INC. (1)
* 8,356,081 Automated domain name registration 0 2005
 
HITACHI, LTD. (3)
* 6,076,085 Routine executing method in database system 7 1998
6,374,238 Routine executing method in database system 10 2000
* 2006/0074,918 Method and accelerating data search for data archive system 2 2004
 
University of Vermont and State Agricultural College (2)
8,112,440 Relational pattern discovery across multiple databases 2 2008
* 2010/0179,955 Relational Pattern Discovery Across Multiple Databases 1 2008
 
ORACLE INTERNATIONAL CORPORATION (13)
* 6,549,901 Using transportable tablespaces for hosting data of multiple users 15 2000
* 6,804,671 Pluggable tablespaces for database systems 6 2003
7,873,684 Automatic and dynamic provisioning of databases 6 2003
8,311,974 Modularized extraction, transformation, and loading for a database 3 2004
8,554,806 Cross platform transportable tablespaces 0 2004
7,571,173 Cross-platform transportable database 10 2004
* 2005/0256,908 Transportable database 15 2004
* 7,620,635 Data mining agents for efficient hardware utilization 1 2005
* 2005/0177,549 Data mining agents for efficient hardware utilization 7 2005
7,610,314 Online tablespace recovery for export 2 2005
* 2007/0083,563 Online tablespace recovery for export 2 2005
8,909,599 Efficient migration of binary XML across databases 0 2006
8,161,085 Automatic and dynamic provisioning of databases 1 2010
 
LEXISNEXIS RISK DATA MANAGEMENT, INC. (3)
* 7,668,840 System and method for configuring a parallel-processing database system 28 2007
* 2008/0010,296 SYSTEM AND METHOD FOR CONFIGURING A PARALLEL-PROCESSING DATABASE SYSTEM 36 2007
9,189,505 System of and method for entity representation splitting without the need for human interaction 0 2010
 
Lexisnexis Risk Management Inc. (1)
9,015,171 Method and system for linking and delinking data records 0 2009
 
KABUSHIKI KAISHA TOSHIBA (1)
* 2009/0037,576 DATA ANALYZING SYSTEM AND DATA ANALYZING METHOD 0 2008
 
GOOGLE INC. (2)
7,146,365 Method, system, and program for optimizing database query execution 21 2003
* 2004/0148,273 Method, system, and program for optimizing database query execution 5 2003
 
BMC SOFTWARE, INC. (1)
* 6,009,271 Method of retrieving data from a relational database 50 1996
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (31)
* 6,754,656 System and method for selective partition locking 22 1996
* 6,081,801 Shared nothing parallel execution of procedural constructs in SQL 133 1997
6,792,424 System and method for managing authentication and coherency in a storage area network 33 1999
6,959,291 Management of a concurrent use license in a logically-partitioned computer 48 1999
6,691,146 Logical partition manager and method 49 1999
6,681,240 Apparatus and method for specifying maximum interactive performance in a logical partition of a computer system independently from the maximum interactive performance in other partitions 9 1999
6,467,007 Processor reset generated via memory access interrupt 49 1999
6,625,593 Parallel query optimization strategies for replicated and partitioned tables 51 1999
6,546,403 Mechanism to resubmit queries in a parallel database system 55 2000
7,454,742 System and method for automatically starting a document on a workflow process 2 2003
* 2004/0172,585 System and method for automatically starting a document on a workflow process 2 2003
* 7,447,693 Dynamic cluster database architecture 5 2003
* 2003/0182,264 Dynamic cluster database architecture 4 2003
7,480,653 System and method for selective partition locking 2 2004
* 2004/0199,512 System and method for selective partition locking 12 2004
* 2007/0100,783 Method, system, and program for determining discrepancies between database management systems 0 2005
* 2008/0010,283 METHOD AND SYSTEM FOR CONTROLLING CONCURRENT ACCESS TO DATA IN A DATABASE SYSTEM 5 2007
7,937,377 Dynamic cluster database architecture 3 2007
* 2008/0016,028 Dynamic Cluster Database Architecture 6 2007
* 2009/0063,807 DATA REDISTRIBUTION IN SHARED NOTHING ARCHITECTURE 2 2007
* 2009/0132,609 REAL TIME DATA REPLICATION FOR QUERY EXECUTION IN A MASSIVELY PARALLEL COMPUTER 6 2007
7,890,482 System for controlling concurrent access to data in a database system 1 2008
* 2009/0164,468 SYSTEM FOR CONTROLLING CONCURRENT ACCESS TO DATA IN A DATABASE SYSTEM 2 2008
7,970,797 Dynamic cluster database architecture 1 2008
* 2008/0288,554 DYNAMIC CLUSTER DATABASE ARCHITECTURE 13 2008
7,933,882 Dynamic cluster database architecture 2 2008
* 2010/0125,555 EFFICIENT UNDO-PROCESSING DURING DATA REDISTRIBUTION 13 2008
* 2011/0047,144 SYSTEM, METHOD, AND APPARATUS FOR PARALLELIZING QUERY OPTIMIZATION 19 2009
8,484,649 Amortizing costs of shared scans 1 2011
* 9,092,430 Assigning shared catalogs to cache structures in a cluster computing system 0 2013
* 2014/0188,888 ASSIGNING SHARED CATALOGS TO CACHE STRUCTURES IN A CLUSTER COMPUTING SYSTEM 1 2013
 
KYUNGPOOK NATIONAL UNIVERSITY INDUSTRY-ACADEMIC COOPERATION FOUNDATION (1)
8,166,022 System, method, and apparatus for parallelizing query optimization 6 2009
 
LexisNexis Risk Solution FL Inc. (2)
8,572,070 Statistical measure and calibration of internally inconsistent search criteria where one or both of the search criteria and database is incomplete 0 2009
8,572,052 Automated calibration of negative field weighting without the need for human interaction 0 2012
 
IANYWHERE SOLUTIONS, INC. (2)
* 7,849,073 Load balancing for complex database query plans 5 2006
* 2008/0147,599 Load balancing for complex database query plans 13 2006
 
CISCO TECHNOLOGY, INC. (1)
* 7,225,188 System and method for performing regular expression matching with high parallelism 132 2002
 
LEXISNEXIS RISK SOLUTIONS FL INC. (26)
8,266,168 Database systems and methods for linking records and entity representations with sufficiently high confidence 40 2008
8,316,047 Adaptive clustering of records and entity representations 4 2009
8,275,770 Automated selection of generic blocking criteria 18 2009
8,250,078 Statistical record linkage calibration for interdependent fields without the need for human interaction 2 2009
8,195,670 Automated detection of null field values and effectively null field values 0 2009
8,135,679 Statistical record linkage calibration for multi token fields without the need for human interaction 16 2009
8,135,680 Statistical record linkage calibration for reflexive, symmetric and transitive distance measures at the field and field value levels without the need for human interaction 1 2009
8,135,681 Automated calibration of negative field weighting without the need for human interaction 0 2009
8,135,719 Statistical record linkage calibration at the field and field value levels without the need for human interaction 14 2009
8,046,362 Statistical record linkage calibration for reflexive and symmetric distance measures at the field and field value levels without the need for human interaction 16 2009
8,661,026 Entity representation identification using entity representation level information 1 2009
8,639,691 System for and method of partitioning match templates 0 2009
8,639,705 Technique for recycling match weight calculations 0 2009
8,484,211 Batch entity representation identification using field match templates 0 2009
8,285,725 System and method for identifying entity representations based on a search query using field match templates 7 2009
8,190,616 Statistical measure and calibration of reflexive, symmetric and transitive fuzzy search criteria where one or both of the search criteria and database is incomplete 1 2009
8,090,733 Statistical measure and calibration of search criteria where one or both of the search criteria and database is incomplete 3 2009
* 2010/0005,079 SYSTEM FOR AND METHOD OF PARTITIONING MATCH TEMPLATES 1 2009
8,495,076 Statistical measure and calibration of search criteria where one or both of the search criteria and database is incomplete 0 2011
8,484,168 Statistical record linkage calibration for multi token fields without the need for human interaction 14 2012
8,489,617 Automated detection of null field values and effectively null field values 0 2012
8,495,077 Database systems and methods for linking records and entity representations with sufficiently high confidence 14 2012
9,043,359 Internal linking co-convergence using clustering with no hierarchy 0 2013
9,037,606 Internal linking co-convergence using clustering with hierarchy 0 2013
9,031,979 External linking based on hierarchical level weightings 0 2013
9,020,971 Populating entity fields based on hierarchy partial resolution 0 2013
 
TELCORDIA TECHNOLOGIES, INC. (1)
* 6,412,054 Storage disk declustering method 3 2000
 
G&H NEVADA-TEK (1)
8,793,275 Method, apparatus and system for distributing queries and actions 1 2003
 
INTEL CORPORATION (2)
* 9,183,109 Method and system for analyzing the performance of multi-threaded applications 0 2010
* 2011/0296,420 METHOD AND SYSTEM FOR ANALYZING THE PERFORMANCE OF MULTI-THREADED APPLICATIONS 3 2010
 
SABRE GLBL INC. (2)
* 6,122,642 System for propagating, retrieving and using transaction processing facility airline computerized reservation system data on a relational database processing platform 60 1996
6,714,945 System, method, and article of manufacture for propagating transaction processing facility based data and for providing the propagated data to a variety of clients 7 2000
 
SIEMENS INDUSTRY, INC. (1)
* 2005/0027,425 System and method for slip slide control 1 2004
* Cited By Examiner