Database management system and method for query process for the same

Inactive Publication Date: 2005-11-24
HITACHI LTD
View PDF8 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

[0012] According to the query processing method of the present invention, the number of nodes can be decided in correspondence with the database operation which is executed in each node. When there is a scattering in distribution of data, the data is equally

Problems solved by technology

In the case of the former, the load for generating the processing procedure is small, though there is a problem imposed in the propriety of the rules which are set uniformly and there is also a problem imposed in the optimization of the selected internal processing procedure.
Therefore, there is a problem imposed that a processing procedure which is obtained by the query analysis process beforehand is not always optimum.
However, when the parallelism is excessively i

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database management system and method for query process for the same
  • Database management system and method for query process for the same
  • Database management system and method for query process for the same

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034]FIG. 1 is a block diagram showing the conceptual structure of the database system of this embodiment. In FIG. 1, the database system has a plurality of application programs (hereinafter abbreviated to AP) 10 and 11 which are prepared by a user, a database management system (hereinafter abbreviated to DBMS) 20 for managing the entire database system such as query process and resource management, an operating system (hereinafter abbreviated to OS) 30 for reading and writing data for I / O processing in the database process and managing the entire computer system, a database 40 for storing data for database processing, and a dictionary 50 for managing database definition information. In the dictionary 50, the column value frequency information on the join columns which are used in this embodiment is stored.

[0035] The DBMS 20 has a system controller 21 for managing input and output of data in addition to management and control of the entire system, a logical processor 22 for perfor...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

A database management system for executing database operations in parallel by a plurality of nodes and a query processing method for it are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

Description

BACKGROUND OF THE INVENTION [0001] The present invention relates to a database management system and more particularly to a database processing method which is suitable for parallel query process suited to a relational database management system. [0002] A database management system (hereinafter abbreviated to DBMS), particularly a relational DBMS processes a query which is represented in a non-procedural database language, decides the internal processing procedure, and executes the query process according to this internal processing procedure. As a database language, a database language which is regulated in Database Language SQL ISO 9075:1989 and called SQL is widely used. Among main conventional query processing methods, there are a method for deciding a single internal processing procedure on the basis of the predefined rule and a method for deciding an optimum procedure from a plurality of candidate processing procedures which are selected using various statistical information a...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F12/00G06F15/173G06F15/177G06F17/30
CPCG06F17/30445G06F17/3056Y10S707/99937Y10S707/99933Y10S707/99932G06F16/24532G06F16/252
Inventor TSUCHIDA, MASASHINAKANO, YUKIOKAWAMURA, NOBUONEGISHI, KAZUYOSHITORII, SHUNICHI
Owner HITACHI LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap