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...
Gespeichert in:
Hauptverfasser: | , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
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 |
---|