CN111198913A - A method and system for network fusion of heterogeneous databases - Google Patents
A method and system for network fusion of heterogeneous databases Download PDFInfo
- Publication number
- CN111198913A CN111198913A CN201911264767.4A CN201911264767A CN111198913A CN 111198913 A CN111198913 A CN 111198913A CN 201911264767 A CN201911264767 A CN 201911264767A CN 111198913 A CN111198913 A CN 111198913A
- Authority
- CN
- China
- Prior art keywords
- database
- interface
- network
- databases
- king
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/256—Integrating or interfacing systems involving database management systems in federated or virtual databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a system for network fusion of heterogeneous databases, which comprises an interface king system, wherein the interface king system can clearly know each operation command of each database in a network through a network probe, simultaneously, the basic logic of the database is restored by using a 'mimicry robot' through the path of the operation command, the interface king system can access different database systems by restoring the logic of each database, and simultaneously, interfaces are standardized and complete data and data structures are integrated. The method and the system for network convergence of the heterogeneous databases save development time by more than 60% and development cost by more than 60%, and each application system can add required databases at any time according to needs without waiting for interface development of each database.
Description
Technical Field
The invention relates to the technical field of database networks, in particular to a heterogeneous database network fusion method and system.
Background
The existing connection or fusion among databases needs to respectively open interfaces to each other to inquire and interoperate data, and in a complex system with multiple databases, along with the increasing of the databases, the inquiry and interoperation complexity among the databases is higher and higher, the difficulty is higher and higher, the implementation is more and more difficult, and the cost is higher and higher.
In response to the above problems we have developed: the 'interface king software system' can uniformly connect all databases in the system without providing interfaces for respective databases to form a standardized interface, help to solve the inquiry and interoperation among all databases, form the fusion of a plurality of heterogeneous databases, help all large application systems to solve various problems and requirements by more and more databases, and the connection and interoperation among all databases become difficult points of all large application systems, and only the connection and interoperability among all databases are solved, all application systems can form unified management and standardized data. Otherwise, each application system faces the problem that data is unavailable and difficult to manage. The patent solves the difficulty and problem and promotes the development of the informatization industry better and faster.
Disclosure of Invention
The present invention is directed to a method and system for network convergence of heterogeneous databases, so as to solve the problems in the background art.
In order to achieve the purpose, the invention provides the following technical scheme: a method and a system for merging heterogeneous database networks comprise an interface king system, wherein the interface king system can clearly know each operation command of each database in the network through a network probe, simultaneously, the basic logic of the database is restored through the path of the operation command by using a 'mimicry robot', the interface king system can access different database systems by restoring the logic of the databases, and simultaneously, interfaces are standardized and complete data and data structures are integrated.
Preferably, the interface king system integrates the network probe and the mimicry robot, so that the interface king system can be connected with each database to complete the connection and the interoperation among different databases. While providing a standardized interface and complete data and data structures.
Preferably, the network probe is linked to an sql database, an oracle database, a mysql, a mangoDB database.
Preferably, the mimicry robot searches each operation command of each database through a network probe, records an operation path at the same time, and obtains the basic logic of each database according to the operation path.
Preferably, the interface king system obtains logics accessed to different databases by integrating the network probe and the mimicry robot, and simultaneously performs standardized encapsulation on the logics to obtain standardized interfaces.
Preferably, the interface king system can realize query and interoperation among different databases, namely fusion among heterogeneous databases.
Compared with the prior art, the invention has the beneficial effects that: the method and the system for network fusion of the heterogeneous databases save development time by more than 60% and development cost by more than 60%, and each application system can add required databases at any time according to needs without waiting for interface development of each database, so that a master key for expanding the system is mastered.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention provides a technical scheme that: a method and a system for merging heterogeneous database networks comprise an interface king system, wherein the interface king system can clearly know each operation command of each database in the network through a network probe, simultaneously utilizes a 'mimicry robot' to restore the basic logic of the database through the path of the operation command, can access different database systems by restoring the logic of the databases, standardizes interfaces and integrates complete data and data structures, and integrates the network probe and the mimicry robot, so that the interface king system can be butted with the databases to complete the connection and the mutual operation among the different databases. The network probe is connected with an sql database, an oracle database, a mysql and a mangoDB database, the mimicry robot obtains logics accessed to different databases by integrating the network probe and the mimicry robot, and simultaneously performs standardized packaging on the logics to obtain a standardized interface, and the interface king system can realize inquiry and interoperation among different databases, namely fusion among heterogeneous databases.
To sum up, in the field of medical informatization: the hospital information system includes: HIS, LIS, CIS, EMR, PACS and other systems, for a total of tens to hundreds of systems, with SQL databases, ORACLE databases, MYSAQL and the like.
Hospitals need to connect all database systems for unified management, and the traditional method is that each system opens a development interface to perform mutual connection and interoperation, but the workload of such many system development operations is huge, and meanwhile, many new database applications need to be continuously accessed, so that the work difficulty is large, the time is long, the problems are many, the whole cost is extremely huge, and huge manpower and material resources are consumed for system connection.
The Kangsha interface Wang system software can be accessed into a network, forms a standardized interface through a proprietary technology, is connected with each database system, helps each system to complete connection and interoperation, helps a hospital to quickly complete connection and interoperation of the systems, and forms unified management and data standardization. The method plays a great help role in the management and informatization of hospitals.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (6)
1. A method and a system for merging heterogeneous database networks comprise an interface king system, wherein the interface king system can clearly know each operation command of each database in the network through a network probe, simultaneously, the basic logic of the database is restored through the path of the operation command by using a 'mimicry robot', the interface king system can access different database systems by restoring the logic of the databases, and simultaneously, interfaces are standardized and complete data and data structures are integrated.
2. The method and system for network convergence of heterogeneous databases according to claim 1, wherein: the interface king system integrates the network probe and the mimicry robot, so that the interface king system can be in butt joint with each database, complete connection and interoperation among different databases, and provide a standardized interface and a complete data and data structure.
3. The method and system for network convergence of heterogeneous databases according to claim 2, wherein: the network probe is connected with an sql database, an oracle database, a mysql database and a mangoDB database.
4. The method and system for network convergence of heterogeneous databases according to claim 2, wherein: and the mimicry robot searches each operation command of each database through a network probe, records an operation path at the same time, and obtains the basic logic of each database according to the operation path.
5. The method and system for network convergence of heterogeneous databases according to claim 1, wherein: the interface king system obtains logics accessed to different databases by integrating the network probes and the mimicry robot, and simultaneously carries out standardized encapsulation on the logics to obtain standardized interfaces.
6. The method and system for network convergence of heterogeneous databases according to claim 1, wherein: the interface king system can realize the query and interoperation among different databases, namely the fusion among heterogeneous databases.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911264767.4A CN111198913A (en) | 2019-12-10 | 2019-12-10 | A method and system for network fusion of heterogeneous databases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911264767.4A CN111198913A (en) | 2019-12-10 | 2019-12-10 | A method and system for network fusion of heterogeneous databases |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111198913A true CN111198913A (en) | 2020-05-26 |
Family
ID=70747189
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911264767.4A Pending CN111198913A (en) | 2019-12-10 | 2019-12-10 | A method and system for network fusion of heterogeneous databases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111198913A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197023A (en) * | 2007-11-19 | 2008-06-11 | 清华大学 | A method for establishing a visual document management system for small and medium-sized enterprises |
| CN101639879A (en) * | 2008-07-28 | 2010-02-03 | 成都市华为赛门铁克科技有限公司 | Database security monitoring method, device and system |
| CN102387137A (en) * | 2011-10-11 | 2012-03-21 | 杭州东信北邮信息技术有限公司 | Implementation method and system of intelligent operation logic of a plurality of network devices |
| CN104657491A (en) * | 2015-03-06 | 2015-05-27 | 成都维远艾珏信息技术有限公司 | Method for transmitting data to client |
| CN105389319A (en) * | 2014-09-09 | 2016-03-09 | 中兴通讯股份有限公司 | Database operation method and device |
| CN106503007A (en) * | 2015-09-08 | 2017-03-15 | 阿里巴巴集团控股有限公司 | database operation method and device |
| CN106844485A (en) * | 2016-12-23 | 2017-06-13 | 航天星图科技（北京）有限公司 | A kind of system and method for enterprise's heterogeneous database intelligent integrated |
| CN107291893A (en) * | 2017-06-21 | 2017-10-24 | 天津光电通信技术有限公司 | A kind of database generalization management method based on .NET technologies |
| CN109144982A (en) * | 2018-09-29 | 2019-01-04 | 北京友友天宇系统技术有限公司 | Multidimensional holographic Database Dynamic constructing technology system |
-
2019
- 2019-12-10 CN CN201911264767.4A patent/CN111198913A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197023A (en) * | 2007-11-19 | 2008-06-11 | 清华大学 | A method for establishing a visual document management system for small and medium-sized enterprises |
| CN101639879A (en) * | 2008-07-28 | 2010-02-03 | 成都市华为赛门铁克科技有限公司 | Database security monitoring method, device and system |
| CN102387137A (en) * | 2011-10-11 | 2012-03-21 | 杭州东信北邮信息技术有限公司 | Implementation method and system of intelligent operation logic of a plurality of network devices |
| CN105389319A (en) * | 2014-09-09 | 2016-03-09 | 中兴通讯股份有限公司 | Database operation method and device |
| CN104657491A (en) * | 2015-03-06 | 2015-05-27 | 成都维远艾珏信息技术有限公司 | Method for transmitting data to client |
| CN106503007A (en) * | 2015-09-08 | 2017-03-15 | 阿里巴巴集团控股有限公司 | database operation method and device |
| CN106844485A (en) * | 2016-12-23 | 2017-06-13 | 航天星图科技（北京）有限公司 | A kind of system and method for enterprise's heterogeneous database intelligent integrated |
| CN107291893A (en) * | 2017-06-21 | 2017-10-24 | 天津光电通信技术有限公司 | A kind of database generalization management method based on .NET technologies |
| CN109144982A (en) * | 2018-09-29 | 2019-01-04 | 北京友友天宇系统技术有限公司 | Multidimensional holographic Database Dynamic constructing technology system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104063482B (en) | A kind of business datum integration method towards Immovable Property Registration | |
| CN105787089A (en) | Power distribution network scheduling foundation data integrating method | |
| CN105677875A (en) | Visual modeling platform based on unified constraint of normal data elements | |
| CN104346377A (en) | Method for integrating and exchanging data on basis of unique identification | |
| CN101086782A (en) | Public platform of collaborative electronic commercial system oriented to business service | |
| CN104823185A (en) | Systems and methods for interest-driven data sharing in interest-driven business intelligence systems | |
| CN106161620A (en) | A kind of cloud computing resources Internet of Things supervision and service platform | |
| CN107766493A (en) | A kind of patch source power network resources Model analysis system and method | |
| CN105405070A (en) | Distributed memory power grid system construction method | |
| CN102306355A (en) | Management system for IT (Information Technology) operation and maintenance configuration | |
| Kan et al. | Topology modeling and analysis of a power grid network using a graph database | |
| CN112084177B (en) | Data pool application method and device based on data acquisition treatment and mining analysis | |
| GB2534374A (en) | Distributed System with accelerator-created containers | |
| CN112084385A (en) | Part-process-equipment association relation topological view generation method based on digital twinning | |
| CN105808853A (en) | Engineering application oriented body establishment management and body data automatic obtaining method | |
| CN104200331A (en) | Power grid model joining method and system of power system | |
| CN104616213A (en) | General framework of two-stage data centers of hydropower industry | |
| Arputhamary et al. | A review on big data integration | |
| Helmann et al. | Reference architectures for industry 4.0: Literature review | |
| Jiang et al. | Efficient software test management system based on microservice architecture | |
| CN111198913A (en) | A method and system for network fusion of heterogeneous databases | |
| CN102298648A (en) | Out-of-process access method of open real-time database | |
| CN102609802B (en) | Information interaction method of automatic container managing system and billboard production managing system | |
| CN116680445A (en) | Multi-source heterogeneous data fusion method and system for electric power optical communication system based on knowledge graph | |
| CN112256493B (en) | A Fast Data Access Method of Four-machine Hot Backup Computer Based on Data Pool |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200526 |
|
| RJ01 | Rejection of invention patent application after publication |