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...
Gespeichert in:
1. Verfasser: | |
---|---|
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 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. |
---|