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

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

Related Publications

Loading Related Publications... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
INTERNATIONAL BUSINESS MACHINES CORPORATIONARMONK, NY68841

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Bireley, William Robert Morgan Hill, CA 12 103
Dang, Tammie Morgan Hill, CA 14 82
Desai, Paramesh Sampatrai San Jose, CA 6 163
Haderle, Donald James Los Gatos, CA 2 70
Lin, Fen-Ling San Jose, CA 44 325
McDevitt, Maureen Mae San Jose, CA 1 56
Shibamiya, Akira Los Altos, CA 18 404
Smith, Bryan Frederick Morgan Hill, CA 14 180
Teng, James Zu-Chia San Jose, CA 54 583
Tie, Hong Sang Morgan Hill, CA 13 333
Wang, Yun Shanghai, CN 213 1681
Wong, Jerome Quan Mountain View, CA 3 121
Yang, Kou Horng Allen Santa Clara, CA 2 91
Zeidenstein, Kathryn Ruth Chicago, IL 3 89

Cited Art

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (4)
4,633,387 Load balancing in a multiunit system 131 1983
5,392,430 Hierarchical scheduling method for processing tasks having precedence constraints on a parallel processing system 66 1992
5,495,606 System for parallel processing of complex read-only database queries using master and slave central processor complexes 102 1993
5,437,032 Task scheduler for a miltiprocessor system 116 1994
 
Honeywell Bull Inc. (1)
4,769,772 Automated query optimization method using both global and parallel local optimizations for materialization access planning for distributed databases 240 1985
 
INDIANA BUSINESS MODERNIZATION AND TECHNOLOGY CORPORATION (1)
5,548,770 Method and apparatus for improving retrieval of data from a database 26 1993
 
INFORMATION BUILDERS, INC. (1)
5,590,319 Query processor for parallel processing in homogenous and heterogenous databases 119 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 77 1995

Patent Citation Ranking

Forward Cites

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (18)
6,754,656 System and method for selective partition locking 20 1996
6,081,801 Shared nothing parallel execution of procedural constructs in SQL 77 1997
6,792,424 System and method for managing authentication and coherency in a storage area network 21 1999
6,959,291 Management of a concurrent use license in a logically-partitioned computer 29 1999
6,691,146 Logical partition manager and method 27 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 6 1999
6,467,007 Processor reset generated via memory access interrupt 43 1999
6,625,593 Parallel query optimization strategies for replicated and partitioned tables 36 1999
6,546,403 Mechanism to resubmit queries in a parallel database system 35 2000
7,454,742 System and method for automatically starting a document on a workflow process 0 2003
7,447,693 Dynamic cluster database architecture 4 2003
7,480,653 System and method for selective partition locking 1 2004
7,805,434 Performing a non-invasive runtime simulation for a database system 0 2006
7,937,377 Dynamic cluster database architecture 0 2007
8,095,512 Managing database resources used for optimizing query execution on a parallel computer system 0 2007
7,890,482 System for controlling concurrent access to data in a database system 0 2008
7,970,797 Dynamic cluster database architecture 0 2008
7,933,882 Dynamic cluster database architecture 0 2008
 
LEXISNEXIS RISK SOLUTIONS FL INC. (13)
8,266,168 Database systems and methods for linking records and entity representations with sufficiently high confidence 3 2008
8,316,047 Adaptive clustering of records and entity representations 0 2009
8,275,770 Automated selection of generic blocking criteria 3 2009
8,250,078 Statistical record linkage calibration for interdependent fields without the need for human interaction 0 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 0 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 0 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 1 2009
8,285,725 System and method for identifying entity representations based on a search query using field match templates 0 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 0 2009
8,090,733 Statistical measure and calibration of search criteria where one or both of the search criteria and database is incomplete 1 2009
 
ORACLE INTERNATIONAL CORPORATION (8)
6,549,901 Using transportable tablespaces for hosting data of multiple users 12 2000
6,804,671 Pluggable tablespaces for database systems 3 2003
7,873,684 Automatic and dynamic provisioning of databases 1 2003
8,311,974 Modularized extraction, transformation, and loading for a database 0 2004
7,571,173 Cross-platform transportable database 2 2004
7,620,635 Data mining agents for efficient hardware utilization 1 2005
7,610,314 Online tablespace recovery for export 0 2005
8,161,085 Automatic and dynamic provisioning of databases 0 2010
 
HITACHI, LTD. (2)
6,076,085 Routine executing method in database system 7 1998
6,374,238 Routine executing method in database system 8 2000
 
SABRE 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 45 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
 
SYBASE, INC. (2)
7,574,424 Database system with methodology for parallel schedule generation in a query optimizer 6 2004
8,126,870 System and methodology for parallel query optimization using semantic-based partitioning 6 2005
 
BMC SOFTWARE, INC. (1)
6,009,271 Method of retrieving data from a relational database 29 1996
 
CISCO TECHNOLOGY, INC. (1)
7,225,188 System and method for performing regular expression matching with high parallelism 60 2002
 
FITNESS FOODS, INC. (1)
7,844,620 Real time data replication for query execution in a massively parallel computer 2 2007
 
GOOGLE INC. (1)
7,146,365 Method, system, and program for optimizing database query execution 11 2003
 
IANYWHERE SOLUTIONS, INC. (1)
7,849,073 Load balancing for complex database query plans 3 2006
 
KYUNGPOOK NATIONAL UNIVERSITY INDUSTRY-ACADEMIC COOPERATION FOUNDATION (1)
8,166,022 System, method, and apparatus for parallelizing query optimization 1 2009
 
LEXISNEXIS RISK DATA MANAGEMENT INC. (1)
7,668,840 System and method for configuring a parallel-processing database system 16 2007
 
TELCORDIA TECHNOLOGIES, INC. (1)
6,412,054 Storage disk declustering method 2 2000
 
THALVEG DATA FLOW LLC (1)
6,308,168 Metadata-driven data presentation module for database system 82 1999
 
UNIVERSITY OF VERMONT AND STATE AGRICULTURAL COLLEGE (1)
8,112,440 Relational pattern discovery across multiple databases 1 2008
 
VERISIGN, INC. (1)
8,356,081 Automated domain name registration 0 2005