EXECUTION PROCESSING METHOD FOR SQL SENTENCE AND STORAGE MEDIUM

PROBLEM TO BE SOLVED: To make it unnecessary to prepare a work file for temporarily storing a sort result, and to make it unnecessary to preliminarily prepare an index at the time of designating sort-designated ORDER BY phrase, and updating a line at a cursor position at the time of the execution pr...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: ISHIGURO WATARU
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 make it unnecessary to prepare a work file for temporarily storing a sort result, and to make it unnecessary to preliminarily prepare an index at the time of designating sort-designated ORDER BY phrase, and updating a line at a cursor position at the time of the execution processing of a relational data base management system RDBMS. SOLUTION: In the execution processing in an RDBMS 2 of an SQL (structured query language) sentence buried in a program for performing access to a data base, an index 8 in which only a line made coincident with a retrieval condition is extracted, and a column designated by an ORDER BY phrase is sorted to a key is dynamically generated, and a real chart is updated through the index 8. Also, the extraction of a line under the retrieval condition is operated at the time of generating the index so that only a line fulfilling the condition can be obtained as the object of access, and the number of times of retrieval execution can be prevented from being increased.