CN108563772B - Data sharing method between systems based on universal interface - Google Patents
Data sharing method between systems based on universal interface Download PDFInfo
- Publication number
- CN108563772B CN108563772B CN201810361901.1A CN201810361901A CN108563772B CN 108563772 B CN108563772 B CN 108563772B CN 201810361901 A CN201810361901 A CN 201810361901A CN 108563772 B CN108563772 B CN 108563772B
- Authority
- CN
- China
- Prior art keywords
- data
- dbms
- application system
- request information
- cursor
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 12
- 238000005516 engineering process Methods 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000004888 barrier function Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000001737 promoting effect Effects 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method for sharing data among systems based on a universal interface, which comprises the following steps: the request application system sends data request information to a target application database through an OSB bus; after receiving the data request information through a general interface, the target application system database calls a DBMS component to analyze the data request information and generate a cursor; the DBMS _ SQL component splits the analyzed data request information, acquires a service type and adds corresponding attributes to the dynamic column of the cursor according to the service type; after the DBMS _ SQL component executes the cursor, business data returned by the target application system database is obtained; the DBMS _ SQL component recombines the dynamic columns and the service data into JSON format data, and returns the JSON format data to the request application system through the general interface and the OSB bus.
Description
Technical Field
The invention relates to a data sharing method, in particular to an intersystem data sharing method based on a universal interface.
Background
Under the new trend of informatization major innovation, artificial intelligence, big data, cloud platform and container technologies are taken as leads, enterprise-level systems are gradually promoting high-quality data service to new technical fields, and business data which are stored in the systems and have potential values are the key points of statistical analysis. Conventional intersystem data sharing still relies on "single-service".
According to the traditional design concept, a set of interfaces is separately developed for a single service. At a cost of 1 ten thousand dollars for implementing one interface, 20 interfaces would need to be developed for 20 services, at a cost of 20 ten thousand dollars. With the increase of subsequent services, the corresponding interfaces developed at the later stage are also increased continuously, and the cost is higher.
To solve the above problems, people are always seeking an ideal technical solution.
Disclosure of Invention
The invention aims to overcome the defects in the prior art, and provides a method for sharing data among systems based on a universal interface.
In order to achieve the purpose, the invention adopts the technical scheme that: a data sharing method between systems based on a universal interface comprises the following steps:
the request application system sends data request information to a target application database through an OSB bus;
after receiving the data request information through a general interface, the target application system database calls a DBMS component to analyze the data request information and generate a cursor;
the DBMS _ SQL component splits the analyzed data request information, acquires a service type, and adds corresponding attributes to the dynamic column of the cursor according to the service type;
After the DBMS _ SQL component executes the cursor, business data returned by the target application system database is obtained;
and the DBMS _ SQL component recombines the dynamic columns and the service data into JSON format data, and returns the JSON format data to the request application system through the universal interface and the OSB bus.
Compared with the prior art, the method has outstanding substantive characteristics and remarkable progress, particularly, the method takes the multi-service form as a large service, takes the large service as a parameter, enables the target database to return the corresponding service data according to data requests of different formats through design, and has the advantages of scientific design, simple method and low cost.
Drawings
FIG. 1 is a schematic flow diagram of the present invention.
Detailed Description
The technical solution of the present invention is further described in detail by the following embodiments.
According to the traditional design concept, a set of interfaces is separately developed for a single service. According to the cost calculation of 1 ten thousand yuan for implementing one interface, 20 interfaces are developed for 20 services, and 20 ten thousand expenses are spent. With the increase of subsequent services, the corresponding interfaces developed at the later stage are also increased continuously, and the cost is higher.
In fact, each interface is different from a service implementation point of view, but all interfaces have no difference from a technical point of view. Based on this consideration and taking into account services and technologies, the idea of implementing single-interface multi-service with a generic interface is natural.
As shown in fig. 1, the present invention provides a method for sharing data between systems based on a universal interface, which includes the following steps:
the request application system sends data request information to a target application database through an OSB bus;
after receiving the data request information through a general interface, the target application system database calls a DBMS component to analyze the data request information and generate a cursor;
the DBMS _ SQL component splits the analyzed data request information, acquires a service type, and adds corresponding attributes to the dynamic column of the cursor according to the service type;
after the DBMS _ SQL component executes the cursor, business data returned by the target application system database is obtained;
the DBMS _ SQL component recombines the dynamic columns and the service data into JSON format data, and returns the JSON format data to the request application system through the general interface and the OSB bus.
The invention utilizes the Oracle database dbms _ SQL component to analyze the dynamic SQL, then splits the data according to the business form, and finally returns the split data to the requesting party in the JSON format, thereby effectively solving the technical problem of data sharing between systems in enterprises, namely 'single business and single service', establishing close association at any time and any place without barriers and obstacles in data transmission by 'single service and multiple services', and having scientific and effective design. Low cost.
Finally, it should be noted that the above examples are only used to illustrate the technical solutions of the present invention and not to limit the same; although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art will understand that: modifications of the embodiments of the invention or equivalent substitutions for parts of the technical features are possible; without departing from the spirit of the present invention, it is intended to cover all aspects of the invention as defined by the appended claims.
Claims (1)
1. A data sharing method between systems based on a universal interface is characterized by comprising the following steps:
the request application system sends data request information to a target application database through an OSB bus;
after receiving the data request information through a general interface, the target application system database calls a DBMS component to analyze the data request information and generate a cursor;
the DBMS _ SQL component splits the analyzed data request information, acquires a service type, and adds corresponding attributes to the dynamic column of the cursor according to the service type;
after the DBMS _ SQL component executes the cursor, business data returned by the target application system database is obtained;
the DBMS _ SQL component recombines the dynamic columns and the service data into JSON format data, and returns the JSON format data to the request application system through the general interface and the OSB bus.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810361901.1A CN108563772B (en) | 2018-04-20 | 2018-04-20 | Data sharing method between systems based on universal interface |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810361901.1A CN108563772B (en) | 2018-04-20 | 2018-04-20 | Data sharing method between systems based on universal interface |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108563772A CN108563772A (en) | 2018-09-21 |
| CN108563772B true CN108563772B (en) | 2022-06-14 |
Family
ID=63536123
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810361901.1A Active CN108563772B (en) | 2018-04-20 | 2018-04-20 | Data sharing method between systems based on universal interface |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108563772B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101819596A (en) * | 2010-04-28 | 2010-09-01 | 烽火通信科技股份有限公司 | Memory-based XML script buffer |
| CN104994122A (en) * | 2015-05-12 | 2015-10-21 | 深圳市微阳信息技术有限公司 | Business communication method and system based on JSON data protocol |
| CN105589876A (en) * | 2014-10-22 | 2016-05-18 | Tcl集团股份有限公司 | Method and device for creating dynamic cursor pool for Mysql database and method and device for processing concurrent request under multithreading |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104717179B (en) * | 2013-12-13 | 2018-01-30 | 中国移动通信集团河南有限公司 | A kind of processing method and processing device of communication service |
| CN106547766A (en) * | 2015-09-18 | 2017-03-29 | 华为技术有限公司 | A kind of data access method and device |
-
2018
- 2018-04-20 CN CN201810361901.1A patent/CN108563772B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101819596A (en) * | 2010-04-28 | 2010-09-01 | 烽火通信科技股份有限公司 | Memory-based XML script buffer |
| CN105589876A (en) * | 2014-10-22 | 2016-05-18 | Tcl集团股份有限公司 | Method and device for creating dynamic cursor pool for Mysql database and method and device for processing concurrent request under multithreading |
| CN104994122A (en) * | 2015-05-12 | 2015-10-21 | 深圳市微阳信息技术有限公司 | Business communication method and system based on JSON data protocol |
Non-Patent Citations (2)
| Title |
|---|
| ESB在电信行业中应用的研究与实现;鞠胜利等;《西安文理学院学报：自然科学版》;20140131(第1期);第112页 * |
| 使用Oracle的DBMS_SQL包执行动态SQL语句;hisray;《https://blog.csdn.net/hisray/article/details/83080465》;20051017;第1-2页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108563772A (en) | 2018-09-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Miller et al. | Complementary components and returns from coordination within ecosystems via standard setting | |
| CN111461874A (en) | Credit risk control system and method based on federal mode | |
| WO2017023566A1 (en) | Contact center virtual assistant | |
| CN108536778A (en) | A kind of data application shared platform and method | |
| CN106097083A (en) | Method for realizing integrated self-service tax handling based on background of changing operation into increase operation | |
| CN108566448A (en) | IP address association analysis method and analysis system based on Internet basic resource | |
| CN109636610A (en) | A kind of data transacting system and method for decentralization | |
| CN110708358A (en) | Session message processing method, electronic device and computer-readable storage medium | |
| CN108335146A (en) | A kind of distribution system | |
| CN108563772B (en) | Data sharing method between systems based on universal interface | |
| Sungau et al. | On IT enabling of business process reengineering in organizations | |
| CN105912723A (en) | Storage method of custom field | |
| CN111191050B (en) | Knowledge graph ontology model construction method and device | |
| CN109756556B (en) | One-stop cloud service ecosystem | |
| US11599521B2 (en) | Systems and methods for providing real-time discrepancies between disparate execution platforms | |
| CN110519471A (en) | A kind of conversational services method and device based on operator attendance | |
| CN114943590A (en) | Object recommendation method and device based on double-tower model | |
| CN112328683A (en) | Data transmission method, system and storage medium supporting database and library direct | |
| CN111159512B (en) | Processing method and server of track information | |
| CN110555201B (en) | Knowledge document generation method, device, electronic equipment and storage medium | |
| CN104320457A (en) | Network invoice system based on distributed management | |
| CN112925846A (en) | Historical operation tracing method and system based on block chain and identity authentication | |
| CN102300006A (en) | Computer-aided telephone access system | |
| CN111897839A (en) | Data processing method and system | |
| CN109543079A (en) | Data query method, apparatus calculates equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address |
Address after: 450001 No.100, Kangning street, Zhengzhou area (Zhengdong), Henan pilot Free Trade Zone, Zhengzhou City, Henan Province Patentee after: ZHENGZHOU METRO GROUP Co.,Ltd. Country or region after: China Address before: 450000 xiongerhe Road, caigao street, Zhengdong New District, Zhengzhou City, Henan Province Patentee before: ZHENGZHOU TRACK TRAFFIC CO.,LTD. Country or region before: China |
|
| CP03 | Change of name, title or address |