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

See full text
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

all claims..

Related Publications

Loading Related Publications... loading....

Patent Owner(s)

Patent OwnerAddressTotal Patents
INTERNATIONAL BUSINESS MACHINES CORPORATIONARMONK, NY73171

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Bireley, William Robert Morgan Hill, CA 13 119
Dang, Tammie Morgan Hill, CA 18 100
Desai, Paramesh Sampatrai San Jose, CA 6 178
Haderle, Donald James Los Gatos, CA 2 82
Lin, Fen-Ling San Jose, CA 47 373
McDevitt, Maureen Mae San Jose, CA 1 68
Shibamiya, Akira Los Altos, CA 22 438
Smith, Bryan Frederick Morgan Hill, CA 18 211
Teng, James Zu-Chia San Jose, CA 56 620
Tie, Hong Sang Morgan Hill, CA 15 363
Wang, Yun Shanghai, CN 292 1977
Wong, Jerome Quan Mountain View, CA 3 136
Yang, Kou Horng Allen Santa Clara, CA 2 103
Zeidenstein, Kathryn Ruth Chicago, IL 4 107

Cited Art Landscape

Patent Info (Count) # Cites Year
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (4)
4,633,387 Load balancing in a multiunit system 132 1983
5,392,430 Hierarchical scheduling method for processing tasks having precedence constraints on a parallel processing system 81 1992
5,495,606 System for parallel processing of complex read-only database queries using master and slave central processor complexes 116 1993
5,437,032 Task scheduler for a miltiprocessor system 126 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 258 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 136 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 98 1995

Patent Citation Ranking

Forward Cite Landscape

Patent Info (Count) # Cites Year
 
LEXISNEXIS RISK SOLUTIONS FL INC. (21)
8,266,168 Database systems and methods for linking records and entity representations with sufficiently high confidence 17 2008
8,316,047 Adaptive clustering of records and entity representations 2 2009
8,275,770 Automated selection of generic blocking criteria 12 2009
8,250,078 Statistical record linkage calibration for interdependent fields without the need for human interaction 1 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,661,026 Entity representation identification using entity representation level information 0 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 1 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 2 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 0 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 0 2012
 
INTERNATIONAL BUSINESS MACHINES CORPORATION (19)
6,754,656 System and method for selective partition locking 20 1996
6,081,801 Shared nothing parallel execution of procedural constructs in SQL 97 1997
6,792,424 System and method for managing authentication and coherency in a storage area network 23 1999
6,959,291 Management of a concurrent use license in a logically-partitioned computer 36 1999
6,691,146 Logical partition manager and method 32 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 46 1999
6,625,593 Parallel query optimization strategies for replicated and partitioned tables 39 1999
6,546,403 Mechanism to resubmit queries in a parallel database system 46 2000
7,454,742 System and method for automatically starting a document on a workflow process 1 2003
7,447,693 Dynamic cluster database architecture 4 2003
7,480,653 System and method for selective partition locking 2 2004
7,805,434 Performing a non-invasive runtime simulation for a database system 1 2006
7,937,377 Dynamic cluster database architecture 1 2007
8,095,512 Managing database resources used for optimizing query execution on a parallel computer system 1 2007
7,890,482 System for controlling concurrent access to data in a database system 1 2008
7,970,797 Dynamic cluster database architecture 0 2008
7,933,882 Dynamic cluster database architecture 1 2008
8,484,649 Amortizing costs of shared scans 0 2011
 
ORACLE INTERNATIONAL CORPORATION (9)
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 1 2004
8,554,806 Cross platform transportable tablespaces 0 2004
7,571,173 Cross-platform transportable database 4 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 9 2000
 
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
 
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 50 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 13 2004
8,126,870 System and methodology for parallel query optimization using semantic-based partitioning 8 2005
 
BMC SOFTWARE, INC. (1)
6,009,271 Method of retrieving data from a relational database 32 1996
 
CISCO TECHNOLOGY, INC. (1)
7,225,188 System and method for performing regular expression matching with high parallelism 83 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 16 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 2 2009
 
LEXISNEXIS RISK DATA MANAGEMENT INC. (1)
7,668,840 System and method for configuring a parallel-processing database system 22 2007
 
TELCORDIA TECHNOLOGIES, INC. (1)
6,412,054 Storage disk declustering method 3 2000
 
THALVEG DATA FLOW LLC (1)
6,308,168 Metadata-driven data presentation module for database system 92 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