Unlock instant, AI-driven research and patent intelligence for your innovation.

Managing queries in a distributed database system

A database and distributed technology, applied in the field of database systems, can solve problems that cannot be well applied to distributed data systems

Active Publication Date: 2008-07-30
SAP AG
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, such optimizations are often not well suited for distributed data systems

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
  • Managing queries in a distributed database system
  • Managing queries in a distributed database system
  • Managing queries in a distributed database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] FIG. 1 is a schematic diagram illustrating an example of a distributed database system 100 for managing queries. System 100 includes a plurality of computing devices across which data may be stored distributed and queries may be performed on the data. Specifically, the computer devices in system 100 determine which computer device to perform the query on based on information about the computer devices in system 100 . The terms computer equipment and computer are used interchangeably herein to refer to a device capable of processing instructions or equipped with one or more processors, such as a computer workstation, laptop, desktop, server, scanner, reader etc.

[0016] System 100 is a hierarchical network of data storage computer devices in a retail company's inventory system. Alternatively, the data storage computer devices of system 100 may be non-hierarchical, such as peer-to-peer devices. System 100 includes a data center 102, a network 104, storage servers 106a...

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

Queries in a distributed database system are received at computer devices participating in the database system. A determination is made as to which of the respective, participating computer devices has data relevant to the query. Information about the computer devices(s) which has or have the relevant data is communicated to the participating computer devices. Such information is used to determine, at each of the respective participating computer devices, a benefit value for at least one of the participating computer devices. A determination is made as to which the participating computer devices will process the query by comparing the benefit values for the participating computer devices.

Description

technical field [0001] This disclosure relates to database systems. Background technique [0002] Materializing views, building indexes, and creating horizontal partitions can enhance the performance of database systems. However, such optimizations generally do not work well with distributed data systems. Contents of the invention [0003] According to one embodiment, a method of managing queries in a distributed database system includes receiving queries at computers (ie, computer devices) participating in the database system. Determine which participating computers may have data relevant to the query. In one possible implementation, the query has been broadcast to all participating computers. Communications of information about those computer devices having relevant data are sent to the participating computers. At each of the respective participating computer devices, the communicated information is used to determine a corresponding benefit value. Each computer dete...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F17/3051G06F17/30545G06F16/24565G06F16/2471
Inventor 伦纳德·W·F·查维斯
Owner SAP AG