CN102402557A - Integration method of web information management system breaking through multidatabase coexistence restrictions - Google Patents
Integration method of web information management system breaking through multidatabase coexistence restrictions Download PDFInfo
- Publication number
- CN102402557A CN102402557A CN2010102871865A CN201010287186A CN102402557A CN 102402557 A CN102402557 A CN 102402557A CN 2010102871865 A CN2010102871865 A CN 2010102871865A CN 201010287186 A CN201010287186 A CN 201010287186A CN 102402557 A CN102402557 A CN 102402557A
- Authority
- CN
- China
- Prior art keywords
- web
- management system
- information management
- database
- master
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides an integration method of a web information management system breaking through multidatabase coexistence restrictions. According to the invention, when the web information management system is required to read data from different databases, the incompatibility among products of different databases, the incompatibility among products of different versions in a same database and the incompatibility (such as character set incompatibility) among products of a same version in the same database are broken through, so that the web information management system can simultaneously process data of different data sources. In the integration method, a master server module, a series of mediation server modules and a web frame structure are utilized, the master server module comprises port mapping software and is corresponding to the master database and web master program of the web information management system; each mediation server module is corresponding to one auxiliary database and one web subprogram; and the web frame structure is used for integrating the web master program and the web subprograms.
Description
Technical field
What the present invention relates to is a kind of method of computer information management system, specifically is a kind of web information management system integrated approach of breaking through multiple database and depositing restriction.
Background technology
In the process of computer information management system exploitation, single data source usually can not be satisfied the demand, and must make this moment management system support multiple database to connect and deposit, and can realize the required function of management service simultaneously from different data source reading of data.Currently marketed business database is of a great variety, like Oracle, and SQL Server; MySQL and DB2 etc.; Though these databases can use the database engine (like ODBC and JDBC etc.) of specialty to conduct interviews basically, because database software belongs to the system software of comparison bottom, possibly have certain modification to being provided with of operating system; If therefore attempt different database software (comprising server end or client) is installed on the station server simultaneously; May cause sizable compatibility issue, like environmental variance conflict, registration table conflict and d11 version conflict etc., the appearance of these conflicts may cause database stop to serve even the losing of data; Between the not only different databases, even also compatibility issue possibly appear between the different editions of same database.
Prior art is general direct from causing incompatible reason itself to start with; As occur the environmental variance conflict just the environmental variance of the same name of disparate databases be set to different titles; The dll version conflict occurs and just dispose dll of different editions or the like respectively for disparate databases; This strategy is directly perceived and effective, but belongs to " particular problem concrete analysis ", and is different to the strategy that different compatibility issues is taked; And must know the origin cause of formation of compatibility issue, but the origin cause of formation is difficult to obtain under considerable situation.Therefore, prior art can only solve current known compatibility issue, and can not be disposable the solution new problem that possibly occur future.
Summary of the invention
The present invention provides a kind of web information management system integrated approach that can break through multiple database fully and deposit restriction; This invention can be need be when different database reads fetch data based on the information management system of web; Incompatibility between the incompatibility between breakthrough disparate databases product, the different editions of same database product and the incompatibility (like the character set incompatibility) between same database product identical version make the web information management system handle the data in different pieces of information source simultaneously.
In order to reach the object of the invention, the present invention is achieved in that
A kind of web information management system integrated approach of breaking through multiple database and depositing restriction is characterized in that, comprises following concrete steps:
(1) master server module operation web master routine is responsible for connecting MDL, and all of master server are provided with according to the requirement of MDL and handle;
(2) step (1) master server is handled according to the requirement of MDL, if do not visit the intermediary server module, carries out step (4);
(3) intermediary server module operation web subprogram is responsible for connecting auxilliary database, and all of intermediary server are provided with according to the requirement of auxilliary database and handle;
(4) the web software framework structure is used for the mutual communication of integrated web master routine and subprogram, if accomplish all business, execution in step (1) is if accomplish all professional required function, end.
Described a kind of web information management system integrated approach of breaking through multiple database and depositing restriction is characterized in that the master server module comprises a port mapping software.
The database (server end or client) that the present invention possibly produce compatibility issue is installed on respectively on a master server and a plurality of intermediary server; Physically different databases is being separated, fundamentally solving multiple database and deposited restricted problem.Use the web framed structure will be seamless integrated from the data of disparate databases simultaneously, the inner structure of total system be transparent fully to the user, does not influence user's experience.
Description of drawings
Fig. 1 is the inventive method FB(flow block).
Fig. 2 is a specific embodiment of the invention workflow diagram.
Embodiment
Below in conjunction with specific embodiment the present invention is described in further detail.
According to Fig. 1; A kind of web information management system integrated approach flow process that breaks through multiple database and deposit restriction provided by the invention is: client computer is at first visited the master server module, then according to the needs of business function through the corresponding auxilliary database of a series of intermediary server module dereference; Repeat above-mentioned flow process, then whole integrated approach finishes after having accomplished whole business functions.Master server module and a series of intermediary server are integrated together through the Web framed structure, and internal logic is transparent fully to the user.
Fig. 2 is a specific embodiment of the invention legend; Server end and client according to Fig. 2 MDL are installed on the master server; Because the notebook data base management system is based on web, so client computer need not install any database software, only needs the support of web browser.The database client software of corresponding external data source A and external data source B is installed respectively on intermediary server A and the intermediary server B; Be responsible for and the communicating by letter of external data source; Through web framework architecture (promptly using HTML standard earlier version in browser window, to show webpage simultaneously) data of these 3 databases are carried out integratedly on the client computer, unified be shown to the user from different server with regard to < frameset>label that begins to support.The big frame table of some horizontal line in the accompanying drawing shows the compass of competency of notebook data library management infosystem.
Because from needing mutual communication usually between the web webpage between the different server; And the safety standard of web browser will limit the interior communication from webpage between different server of same frameset usually; Therefore on master server, need to install port mapping software; Client computer is directly visited the particular port of master server, and the master server proxy client conducts interviews to intermediary server, thereby avoids the restriction of the safety standard of web browser.Access path between client computer and the intermediary server is just shown in the dotted arrow in the accompanying drawing at this moment.
What more than enumerate only is specific embodiment framework of the present invention, and all distortion that those of ordinary skill in the art can directly derive or associate from content disclosed by the invention all should be thought protection scope of the present invention.
Claims (2)
1. the web information management system integrated approach breaking through multiple database and deposit restriction is characterized in that, comprises following concrete steps:
(1) master server module operation web master routine is responsible for connecting MDL, and all of master server are provided with according to the requirement of MDL and handle;
(2) step (1) master server is handled according to the requirement of MDL, if do not visit the intermediary server module, carries out step (4);
(3) intermediary server module operation web subprogram is responsible for connecting auxilliary database, and all of intermediary server are provided with according to the requirement of auxilliary database and handle;
(4) the web software framework structure is used for the mutual communication of integrated web master routine and subprogram, if accomplish all business, execution in step (1) is if accomplish all professional required function, end.
2. a kind of web information management system integrated approach of breaking through multiple database and depositing restriction according to claim 1 is characterized in that the master server module comprises a port mapping software.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010102871865A CN102402557A (en) | 2010-09-17 | 2010-09-17 | Integration method of web information management system breaking through multidatabase coexistence restrictions |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010102871865A CN102402557A (en) | 2010-09-17 | 2010-09-17 | Integration method of web information management system breaking through multidatabase coexistence restrictions |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102402557A true CN102402557A (en) | 2012-04-04 |
Family
ID=45884770
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2010102871865A Pending CN102402557A (en) | 2010-09-17 | 2010-09-17 | Integration method of web information management system breaking through multidatabase coexistence restrictions |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102402557A (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1399209A (en) * | 2001-07-20 | 2003-02-26 | 华为技术有限公司 | Parallel distributed-data base processing method and device |
CN101247391A (en) * | 2007-12-28 | 2008-08-20 | 上海电力学院 | OPC safety proxy system and proxy method thereof |
CN101493826A (en) * | 2008-12-23 | 2009-07-29 | 中兴通讯股份有限公司 | Database system based on WEB application and data management method thereof |
CN101727459A (en) * | 2008-10-16 | 2010-06-09 | 上海宝信软件股份有限公司 | WEB-based data exchange system and method applicable to distributed database |
-
2010
- 2010-09-17 CN CN2010102871865A patent/CN102402557A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1399209A (en) * | 2001-07-20 | 2003-02-26 | 华为技术有限公司 | Parallel distributed-data base processing method and device |
CN101247391A (en) * | 2007-12-28 | 2008-08-20 | 上海电力学院 | OPC safety proxy system and proxy method thereof |
CN101727459A (en) * | 2008-10-16 | 2010-06-09 | 上海宝信软件股份有限公司 | WEB-based data exchange system and method applicable to distributed database |
CN101493826A (en) * | 2008-12-23 | 2009-07-29 | 中兴通讯股份有限公司 | Database system based on WEB application and data management method thereof |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10545981B2 (en) | Virtual repository management | |
US11308031B2 (en) | Resolving in-memory foreign keys in transmitted data packets from single-parent hierarchies | |
CN104794147A (en) | Heterogeneous database access method | |
CN102054025A (en) | Traffic information resource integration processing method and system | |
CN108073688B (en) | Data migration method and device | |
CN102081611A (en) | Method and device for synchronizing databases of master network management system and standby network management system | |
CN105224613A (en) | Based on integrating heterogeneous data source system and the integration method thereof of the federal technology of data | |
CN103309977B (en) | Heterogeneous data resource integration method | |
CN107515933A (en) | Change method, server, system and the storage medium of source data database table structure | |
US20130232266A1 (en) | Techniques for generically accessing data | |
WO2021030524A1 (en) | System and method for querying multiple data sources | |
Bruckner et al. | A framework for a multidimensional OLAP model using topic maps | |
CN102402557A (en) | Integration method of web information management system breaking through multidatabase coexistence restrictions | |
CN102902516A (en) | Control inversion based pop-up frame design for call center | |
CN103198140A (en) | Database storage system and data storage method | |
US7974945B2 (en) | System and method for synchronizing a BlackBerry with a Macintosh | |
CN105653532A (en) | Method for synchronizing heterogeneous database | |
WO2004077216A2 (en) | System and method for heterogeneous data migration in real-time | |
EP1979817B1 (en) | Virtual repository management to provide functionality | |
Fiore et al. | An architectural overview of the GRelC data access service | |
CN102096673A (en) | Full text retrieval method for structured data and unstructured data | |
CN103092591A (en) | XML (Extensive Makeup Language) and Web Service based data integration middleware method | |
EP4016332A1 (en) | Systems and methods using generic database search models | |
Li et al. | Heterogeneous system integration based on service component | |
CN101887453A (en) | Method and system for quoting enterprise resource planning (ERP) service metadata by using commercial intelligent system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120404 |