Unified sql processing method and device for heterogeneous relational database

The invention discloses a unified sql processing method and device for a heterogeneous relational database, and relates to the field of database software development. Comprising the steps of 01, obtaining and caching all table information of a database and column information corresponding to a table...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LI RUI, WEI ZIZHONG, YANG SHANGYONG
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention discloses a unified sql processing method and device for a heterogeneous relational database, and relates to the field of database software development. Comprising the steps of 01, obtaining and caching all table information of a database and column information corresponding to a table, 02, defining an interceptor and intercepting all sql operations for addition, deletion and modification of a table structure, 03, configuring an sql grammar processing mode, 04, analyzing an abstract syntax tree corresponding to the sql according to the sql, step 05, detecting whether a table name and a column name of the abstract syntax tree are in cached table information and column information of a database, if detection is not passed, performing step 06, if detection is passed, performing step 07, step 06, throwing an exception and giving an error reason, step 07, storing a capital and lowercase mapping relation of the table information and the column information in the abstract syntax tree and the cache, and