CN108563772A - Inter-system data sharing method based on general-purpose interface - Google Patents
Inter-system data sharing method based on general-purpose interface Download PDFInfo
- Publication number
- CN108563772A CN108563772A CN201810361901.1A CN201810361901A CN108563772A CN 108563772 A CN108563772 A CN 108563772A CN 201810361901 A CN201810361901 A CN 201810361901A CN 108563772 A CN108563772 A CN 108563772A
- Authority
- CN
- China
- Prior art keywords
- dbms
- general
- purpose interface
- application system
- vernier
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of inter-system data sharing method based on general-purpose interface, includes the following steps：Ask application system by OSB buses to intended application database transmission data solicited message；After intended application system database receives the data request information by general-purpose interface, calls data request information described in DBMS analyzing components and generate vernier；DBMS_SQL components split the data request information after parsing, obtain type of service, and according to the corresponding attribute of dynamic column addition that the type of service is the vernier；After DBMS_SQL components execute the vernier, the business datum that intended application system database returns is obtained；Dynamic column and business datum are reassembled into JSON formatted datas by DBMS_SQL components, and return to request application system by general-purpose interface and OSB buses.
Description
Technical field
The present invention relates to a kind of data sharing methods, specifically, relate to number between a kind of system based on general-purpose interface
According to sharing method.
Background technology
Information-based major reform is to lead with artificial intelligence, big data, cloud platform and container technique under the new situation, enterprise-level
System is also gradually promoting quality data service to new technical field, stores in systems and have the business number of potential value
According to the emphasis for being statistical analysis.Traditional inter-system data is shared or relies on " single business sheet service ".
According to traditional mentality of designing, i.e., single business will individually develop a socket.According to one 10,000 yuan of interface of implementation
Cost payout, needed if 20 business develop 20 interfaces, spend 200,000 expense.As follow-up business increases, then
The interface of corresponding later development can be also continuously increased, expense higher.
It solves the problems, such as present on, people are seeking always a kind of ideal technical solution.
Invention content
The purpose of the present invention is in view of the deficiencies of the prior art, to provide number between a kind of system based on general-purpose interface
According to sharing method.
To achieve the goals above, the technical solution adopted in the present invention is：Number between a kind of system based on general-purpose interface
According to sharing method, include the following steps：
Ask application system by OSB buses to intended application database transmission data solicited message；
After intended application system database receives the data request information by general-purpose interface, call described in DBMS analyzing components
Data request information simultaneously generates vernier；
DBMS_SQL components split the data request information after parsing, obtain type of service, and according to the service class
Type is the corresponding attribute of dynamic column addition of the vernier；
After DBMS_SQL components execute the vernier, the business datum that intended application system database returns is obtained；
Dynamic column and business datum are reassembled into JSON formatted datas by DBMS_SQL components, and pass through general-purpose interface and OSB
Bus returns to request application system.
The present invention has substantive distinguishing features outstanding and significant progress compared with the prior art, and specifically, the present invention will
Multi-service form is considered as a kind of big business, using big business as a kind of parameter, by design allow target database according to
The request of data of different-format returns to its corresponding business datum, has design science, method is simple, the low advantage of expense.
Description of the drawings
Fig. 1 is the flow diagram of the present invention.
Specific implementation mode
Below by specific implementation mode, technical scheme of the present invention will be described in further detail.
According to traditional mentality of designing, i.e., single business will individually develop a socket.1 is needed according to an interface is implemented
Ten thousand yuan of cost payout calculates, and 20 business then need to develop 20 interfaces, spend 200,000 expense.As follow-up business increases
Add, the interface of corresponding later development can be also continuously increased, expense higher.
In fact, from the angle of business realizing, each interface is different, but is analyzed from technical standpoint,
Total interface does not have difference.Business and technology are considered and taken into account based on this, and single interface multi-service is realized using general-purpose interface
Idea arise spontaneously.
As shown in Figure 1, the present invention provides a kind of inter-system data sharing method based on general-purpose interface, including following step
Suddenly：
Ask application system by OSB buses to intended application database transmission data solicited message；
After intended application system database receives the data request information by general-purpose interface, call described in DBMS analyzing components
Data request information simultaneously generates vernier；
DBMS_SQL components split the data request information after parsing, obtain type of service, and according to the service class
Type is the corresponding attribute of dynamic column addition of the vernier；
After DBMS_SQL components execute the vernier, the business datum that intended application system database returns is obtained；
Dynamic column and business datum are reassembled into JSON formatted datas by DBMS_SQL components, and pass through general-purpose interface and OSB
Bus returns to request application system.
The present invention utilizes oracle database dbms_sql block analysis dynamic sqls, then by data according to the business form
It splits, requesting party is finally returned to JSON formats, it is shared " single business, single service " to efficiently solve inter-system data in enterprise
Technical barrier, with " single service, multi-service " allow data transmission without barrier, it is accessible, establish close association whenever and wherever possible, have
Design science is effective.Low-cost advantage.
Finally it should be noted that:The above embodiments are merely illustrative of the technical scheme of the present invention and are not intended to be limiting thereof；To the greatest extent
The present invention is described in detail with reference to preferred embodiments for pipe, those of ordinary skills in the art should understand that：Still
It can modify to the specific implementation mode of the present invention or equivalent replacement is carried out to some technical characteristics；Without departing from this hair
The spirit of bright technical solution should all cover within the scope of the technical scheme claimed by the invention.
Claims (1)
1. a kind of inter-system data sharing method based on general-purpose interface, which is characterized in that include the following steps：
Ask application system by OSB buses to intended application database transmission data solicited message；
After intended application system database receives the data request information by general-purpose interface, call described in DBMS analyzing components
Data request information simultaneously generates vernier；
DBMS_SQL components split the data request information after parsing, obtain type of service, and according to the service class
Type is the corresponding attribute of dynamic column addition of the vernier；
After DBMS_SQL components execute the vernier, the business datum that intended application system database returns is obtained；
Dynamic column and business datum are reassembled into JSON formatted datas by DBMS_SQL components, and pass through general-purpose interface and OSB
Bus returns to request application system.
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 true CN108563772A (en) | 2018-09-21 |
| CN108563772B 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 (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101819596A (en) * | 2010-04-28 | 2010-09-01 | 烽火通信科技股份有限公司 | Memory-based XML script buffer |
| CN104717179A (en) * | 2013-12-13 | 2015-06-17 | 中国移动通信集团河南有限公司 | Communication service processing method and device |
| 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 |
| 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 (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101819596A (en) * | 2010-04-28 | 2010-09-01 | 烽火通信科技股份有限公司 | Memory-based XML script buffer |
| CN104717179A (en) * | 2013-12-13 | 2015-06-17 | 中国移动通信集团河南有限公司 | Communication service processing method and device |
| 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 |
| CN106547766A (en) * | 2015-09-18 | 2017-03-29 | 华为技术有限公司 | A kind of data access method and device |
Non-Patent Citations (3)
| Title |
|---|
| HISRAY: "使用Oracle的DBMS_SQL包执行动态SQL语句", 《HTTPS://BLOG.CSDN.NET/HISRAY/ARTICLE/DETAILS/83080465》 * |
| 红无酒伤: "ORACLE中使用DBMS_SQL获取动态SQL执行结果中的列名和值", 《HTTPS://WWW.CNBLOGS.COM/HUANGHONGBO/P/7650499.HTML》 * |
| 鞠胜利等: "ESB在电信行业中应用的研究与实现", 《西安文理学院学报：自然科学版》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108563772B (en) | 2022-06-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107491858A (en) | A kind of electric power transaction platform based on micro services application architecture | |
| CN106776936A (en) | intelligent interactive method and system | |
| Cho et al. | Foreign direct investment and income inequality in southeast Asia: a panel unit root and panel cointegration analysis, 1990–2013 | |
| CN116127020A (en) | Method for training generated large language model and searching method based on model | |
| CN109977216A (en) | Dialogue recommended method and system based on scene | |
| CN103369038B (en) | Platform serves PaaS management platform and method | |
| CN105912723A (en) | Storage method of custom field | |
| Bui et al. | Impacts of fiscal decentralization on local development in Vietnam: A disaggregated analysis | |
| CN108563772A (en) | Inter-system data sharing method based on general-purpose interface | |
| Hugo | From permanent settlement to transnationalism–Contemporary population movement between Italy and Australia: Trends and implications | |
| CN114611859A (en) | Method and system for intelligent recruitment of software platform | |
| Jiang et al. | Digital economy, agglomeration, and entrepreneurship in Chinese cities | |
| US11683285B2 (en) | Enhancing a social media post with content that is relevant to the audience of the post | |
| CN113379464B (en) | Block chain-based site selection method, device, equipment and storage medium | |
| CN111163237B (en) | Call service flow control method and related device | |
| CN109167724A (en) | The method of data prediction is realized in a kind of API gateway | |
| CN111159512B (en) | Processing method and server of track information | |
| CN115292467A (en) | Information processing and model training method, apparatus, device, medium, and program product | |
| CN108133035A (en) | A kind of activity management method and device of the cultural cloud platform based on big data | |
| CN114356889A (en) | Data conversion method, migration method, conversion device and migration device | |
| CN110555201B (en) | Knowledge document generation method, device, electronic equipment and storage medium | |
| CN113590575A (en) | Service integration sharing-based method, device, terminal and storage medium | |
| CN113239034A (en) | Big data resource integration method and system based on artificial intelligence and cloud platform | |
| CN104320457A (en) | Network invoice system based on distributed management | |
| CN112632371A (en) | Anti-fraud method and system for banking business |
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 |