Universal cross-database access method

An access method and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as poor versatility, poor user experience, and poor scalability, achieve good user experience, reduce learning costs, The effect of good scalability

Active Publication Date: 2016-01-20
GUANGDONG TOONE TECH CO LTD
View PDF3 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At the same time, various well-known databases such as SQLServer, Oracle, DB2, Mysql, and Postgresq need to communicate across databases in the same management system. The methods between different databases, the access statements and methods of the existing technology, have a lack of versatility. Strong, we must pay attention to the complex correspondence such as field types of various databases, and a

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Universal cross-database access method
  • Universal cross-database access method
  • Universal cross-database access method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention will be described in detail below with reference to the accompanying drawings and examples.

[0035] SQL language is Structured Query Language (Structured Query Language), a widely used database query and programming language, used to access data and query, update and manage relational database systems. However, a single SQL language cannot achieve seamless integration with various databases. It must pay attention to the field types of various databases, the differences in functions and parameters of various databases, and the consistency of function return results, which affects efficiency.

[0036] The present invention constructs VStructuredQuevyLanguage (VSQL for short), which adopts unified table structure, index definition, update grammar standard, unified function definition standard, unified multi-table association update grammar standard, pagination grammar standard, and unified custom Function and stored procedure call syntax standard, un...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to a universal cross-database access method. The method comprises: based on grammars, comprising a data manipulation language (DML) and a database definition language (DDL), of a structured query language (SQL), adding predefined functions and grammars in combination with various databases, and defining and/or constructing a VSQL (V Structured Query Language) statement; a grammar analysis engine performing VSQL morphology analysis and VSQL grammar analysis on the VSQL statement, performing word segmentation on a VSQL, and performing word segmentation organization on the VSQL according to the defined grammars to obtain a corresponding grammar tree; an object analysis engine performing structural analysis on the VSQL grammar tree and performing object analysis on SQL grammars corresponding to each database and comprising fields, functions and pages to obtain a native SQL statement; and sending the statement to the database for execution to obtain a result. The universal cross-database access method can effectively realize seamless combination with various databases, and has rich secondary development interfaces and good user experience and expansibility.

Description

technical field [0001] The invention belongs to the technical field of computer information, and in particular relates to a universal cross-database access method. Background technique [0002] With the continuous development of computer and software technology, the division of labor in the software field is becoming more and more refined. Different industries, different projects, and even different stages of the same project may have different focuses. The technical tools, data models and databases adopted Management systems can all be completely different. At the same time, various well-known databases such as SQLServer, Oracle, DB2, Mysql, and Postgresq need to communicate across databases in the same management system. The methods between different databases, the access statements and methods of the existing technology, have a lack of versatility. Strong, we must pay attention to the complex correspondence such as field types of various databases, and at the same time m...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
CPCG06F16/2433
Inventor 刘洪舟赵军罗洪臣涂高翔张亮
Owner GUANGDONG TOONE TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap