Supercharge Your Innovation With Domain-Expert AI Agents!

A method and system for converting data source configuration into SQL

A data source, conversion technology, applied in the computer field

Inactive Publication Date: 2019-04-16
BANK OF CHINA
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Because these SQL statements cannot be used by other systems, even if the business functions are the same, developers have to abandon the system that has been tested and put into production, and redevelop a system and test all codes

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 method and system for converting data source configuration into SQL
  • A method and system for converting data source configuration into SQL
  • A method and system for converting data source configuration into SQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0081] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0082]The embodiment of the present invention discloses a method and system for converting data source configuration into SQL. The configuration information is read from the SQL data source configuration table. The configuration items in the configuration information include: data source ID, source data field name, source data Table name, target data field name, target data table name, filter conditions, executable complete SQL statement and data operation type...

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 discloses a method and system for converting data source configuration into SQL. The method includes: reading configuration information from an SQL data source configuration table, wherein configuration items in the configuration information comprise a data source ID, a source data field name, a source data table name, a target data field name, a target data table name, a screening condition, an executable complete SQL statement and a data operation type; And then based on the data operation type, generating all SQL statements corresponding to the data source ID by adopting an SQL assembly rule corresponding to the data operation type. According to the method, the same SQL assembly rule is adopted for the same data operation type (namely the same service function); Therefore,when the service functions are the same and the data are processed differently, a set of system does not need to be redeveloped, that is, the source code does not need to be changed, and only data inthe data source configuration information needs to be modified, so that tedious operation caused by developing a new system and testing all codes in the new development system is greatly omitted.

Description

technical field [0001] The present invention relates to the field of computer technology, more specifically, to a method and system for converting data source configuration into SQL. Background technique [0002] In the remittance settlement business of most overseas countries, the business processes involved are roughly the same, but due to the inconsistent database structure design, data reading and storage requirements used in the remittance fund settlement business in different countries, it is necessary to target remittance funds in different countries The clearing business develops multiple sets of different clearing systems. [0003] During the development process of the clearing system, it is necessary to customize and customize the SQL (Structured Query Language, Structured Query Language) statements required for reading and writing databases according to the requirements of different clearing systems, and hard-code the SQL statements in the code. Because these SQL...

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/242
Inventor 赵佳佳曾新奋石炜程天柱
Owner BANK OF CHINA
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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