SQL-based distributed data unified access system and method

A distributed data and access system technology, applied in the field of bank payment system transformation, to facilitate migration and access, and improve efficiency

Active Publication Date: 2020-01-14
民生科技有限责任公司
View PDF5 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The current distributed data access components in the industry cannot meet the following expectations at the same time:

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
  • SQL-based distributed data unified access system and method
  • SQL-based distributed data unified access system and method
  • SQL-based distributed data unified access system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] Specific embodiments of the present invention will be described in detail below in conjunction with specific drawings. It should be noted that the technical features or combinations of technical features described in the following embodiments should not be regarded as isolated, and they can be combined with each other to achieve better technical effects.

[0053] Such as figure 1As shown, a SQL-based distributed data unified access system in the embodiment of the present invention includes:

[0054] The data access interface layer provides a unified data access interface for applications to access different types of data storage devices. The interface of the data access interface layer is consistent with the system interface before transformation;

[0055] SQL parser, used for SQL syntax parsing, extracts relevant information such as table names, fields, and field values ​​from SQL statements to form a syntax tree;

[0056] SQL converter, according to the syntax tree ...

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 the technical field of bank payment system transformation, and provides an SQL-based distributed data unified access system and method, and the system comprises a data accessinterface layer, an SQL analyzer, an SQL converter, an execution assembly, an ODBC assembly, a PayHiredis client, and a connection manager. According to the method, grammatical analysis can be carriedout on SQL statements, data sources are selected, redis or a database is accessed, and meanwhile database connection is managed. The SQL is supported to be used for accessing the relational databaseand redis; connection management is supported, and service modules do not need to be concerned; an ODBC assembly is used for supporting access to various relational databases; a batch execution interface for data access is provided, and all requirements of distributed development of a payment system can be met.

Description

technical field [0001] The invention relates to the technical field of bank payment system reconstruction, in particular to a system and method for unified access to distributed data based on SQL. Background technique [0002] The PCIP payment channel integration platform is a system for a commercial bank to connect with the People's Bank of China's "non-bank payment institution network payment and clearing platform", which realizes functions such as fast payment, end-of-day clearing, gateway payment, and certified payment. [0003] The PE system is the payment bus system of a commercial bank. All accounting operations are processed by the PE system. The system has high requirements for stability, performance, and capacity indicators. [0004] The above two systems both have the need for distributed transformation, expand multiple databases, eliminate the bottleneck of database access, and improve the load capacity of the system. Since the business modules of these two syst...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/2455G06F16/2458G06F16/27G06F16/28
CPCG06F16/24552G06F16/2471G06F16/27G06F16/284
Inventor 邢志岩刘元勋王飞王鑫
Owner 民生科技有限责任公司
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