Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A 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 achieve the effect of simple migration process

Active Publication Date: 2022-05-17
民生科技有限责任公司
View PDF5 Cites 0 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
  • A SQL-based distributed data unified access system and method
  • A SQL-based distributed data unified access system and method
  • A 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 a system and method for unified access to distributed data based on SQL. The system includes a data access interface layer, a SQL parser, a SQL converter, an execution component, an ODBC component, and PayHiredis Client and connection manager; it can parse SQL statements, select data sources, access redis or databases, and manage database connections at the same time. The invention supports the use of SQL to access relational databases and redis; supports connection management, and business modules do not need to be concerned; uses ODBC components to support access to multiple relational databases; provides a batch execution interface for data access, which can meet the requirements of distributed development of payment systems all needs.

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 Patents(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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com