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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ONIZUKA MAKOTO, FUKUMOTO KEISHI
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
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.