DISTRIBUTED DATABASE MANAGEMENT DEVICE AND DISTRIBUTED DATABASE MANAGEMENT PROGRAM
PROBLEM TO BE SOLVED: To provide a distributed database management device and a distributed database management program capable of performing combining processing on plural tables without transmission processing on data in the tables between DB servers.SOLUTION: A distributed database management dev...
Gespeichert in:
Hauptverfasser: | , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | PROBLEM TO BE SOLVED: To provide a distributed database management device and a distributed database management program capable of performing combining processing on plural tables without transmission processing on data in the tables between DB servers.SOLUTION: A distributed database management device 10 obtains data stored in each DB server 20; extracts, for each table in a database, a main key division table in which records are sorted and divided using a main key of the table and a schema of the main key for each table and an external key; and generates a table for combination in which records of the extracted schema are sorted and divided using the external key. Then, according to an execution plan of a received retrieval request, the distributed database management device 10 writes the table for combination over a table that is a target of combination indicated by the external key in a table combining condition, and performs retrieval processing. |
---|