CN102567334A - Office automation system based on heterogeneous data - Google Patents
Office automation system based on heterogeneous data Download PDFInfo
- Publication number
- CN102567334A CN102567334A CN2010105895429A CN201010589542A CN102567334A CN 102567334 A CN102567334 A CN 102567334A CN 2010105895429 A CN2010105895429 A CN 2010105895429A CN 201010589542 A CN201010589542 A CN 201010589542A CN 102567334 A CN102567334 A CN 102567334A
- Authority
- CN
- China
- Prior art keywords
- data
- heterogeneous database
- integration device
- group
- automation system
- 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 discloses an office automation system based on heterogeneous data, which comprises a group of heterogeneous databases, a data integration device, an application layer and a client side, wherein the heterogeneous databases are constructed according to different data; the data integration device is connected with the heterogeneous databases and used for data exchange with each heterogeneous database, the data integration device is used for data exchange with one heterogeneous database by using the data structure consistent with the heterogeneous database, the data integration device is used for data exchange conversion for data acquired from the heterogeneous database, the data with an unified data format are formed and stored in a storage, and the data in the storage are synchronous with the data in the heterogeneous databases in content; the application layer is connected with the data integration device and comprises a group of service logic modules which accesses the storage and acquires the data from the storage to execute service logic; and the client side is connected with the application layer and used for invoking the service logic modules to execute the service logic and acquire executing results of the service logic.
Description
?
Technical field
The present invention relates to Automated Technology in Office, relate in particular to a kind of office automation system based on isomeric data.
Background technology
The generation of the office automation system has greatly improved work efficiency.The office automation system need all be transferred to computing machine by the work of written, statistics of manually-operated complicacy or the like with script and carry out, and even more advantageously, the office automation system is carried out data aggregation and data processing in the larger context by means of database.Database technology helps to have accumulated the rich data resource, has also further promoted the work efficiency and the ability to work of the office automation system.
The combination of the office automation system has also run into some problems in using but data base set is unified.Because the difference on time and the space, data source has nothing in common with each other, and the data type of each infosystem, data access mode etc. also all varies.This just causes can not carrying out efficiently between each data source, the system exchanges data and shares, and becomes " information island ".The data sharing problem produces thus, and the isomeric data sharing problem also receives more and more people's attention.Isomeric data not only refers to the isomery between the different Database Systems, like Oracle and SQL Server database, also comprises the isomery between the different structure data, like structurized database data and semi-structured data.The difficult problem outstanding behaviours of data sharing is in the following aspects: 1) consistance of data can't guarantee.Same data but are inconsistent in the application system of different departments, and correctness is difficult to judge.On the other hand, information can't obtain sharing timely and feedback.Information has ageing, and some Useful Informations have surpassed certain period, has just become useless information.2) " information island " can produce very adverse influence to daily management and service operation, if untimely solution " information island " problem can cause the appearance of more new " information island ".Cause the stagnation of data sharing degree.
Owing to receive the restriction of data sharing and problem of detached island of information, make the development of the office automation system that the binding data storehouse is technological also be restricted, especially in the processing of isomeric data, present technology seems unable to do what one wishes.
Summary of the invention
The present invention is intended to propose a kind of office automation system that can effectively handle isomeric data, to promote the application level of the office automation system.
According to the present invention, a kind of office automation system based on isomeric data is proposed, comprising: one group of heterogeneous database, data integration device, application layer and client.
One group of heterogeneous database makes up according to different data structures.
Data integration device is connected to one group of heterogeneous database; In data integration device and the heterogeneous database each is carried out exchanges data; When data integration device and a heterogeneous database carry out exchanges data; Use the data structure that conforms to this heterogeneous database; Data integration device will be carried out Data Format Transform from the data that heterogeneous database obtains, and the data that form the uniform data form also are kept in the storer, and the data in the data in the storer and the one group of heterogeneous database are synchronous in terms of content.
Application layer is connected to data integration device, and application layer comprises one group of business logic modules, and this group of business logic modules reference-to storage obtains data and carries out service logic from storer.
Client is connected to application layer, and the business logic modules in the client call application layer is carried out service logic and obtained the execution result of service logic.
One group of heterogeneous database makes up according to Oracle data structure or SQL data structure.
Data integration device will be carried out data that Data Format Transform forms uniform data format from the data that heterogeneous database obtains and comprised and form the data that meet HTTP, XML or soap protocol.
Data integration device comprises the data-switching instrument, and the data-switching that the data-switching instrument will meet first data layout of appointment becomes to meet the data of second data layout of appointment.The data-switching instrument comprises: Oracle-HTTP crossover tool, Oracle-XML crossover tool, Oracle-SOAP crossover tool, SQL-HTTP crossover tool, SQL-XML crossover tool and SQL-SOAP crossover tool.
One group of business logic modules of application layer comprises: word processing module, statistical module, communication module, authority management module.
The office automation system based on isomeric data of the present invention can integrated isomerous effectively data; Make the office automation system to overcome because the problem that the difference on the data structure is brought; In wider data resource, operate, promote the application level and the work efficiency of the office automation system.
Description of drawings
Fig. 1 has disclosed the structural drawing according to the office automation system based on isomeric data of the present invention.
Embodiment
Look back the development of the office automation system, can roughly be divided into three phases.
First generation office system is to be traditional mis system of processing enter with data; It is an outstanding feature with PC, office suite; Application is storage and process object based on file system and system R with the structural data, has realized data statistics and document writing electronization; Stress that its maximum contribution has been to accomplish the Working information carrier from the leap of original paper Jie mode to the electronics bit-wise to data computing and statistical power.But the deficiency that the office system in this stage exists is to lack public basic communication platform, and not only versatility is poor, and re-usability is low, and does not have the ability of communication and collaborative work, can not set up unified office integrated platform.The robotization of the office workflow that still is unrealized be confined to the management of internal information etc., thereby its automatic capability is very limited.
The second generation office automation system is the center with the workflow; Be the basis with network technology and collaborative work technology principal character; And with E-mail, document data library management, duplicate, technology such as directory service, groupware collaborative work support, and have realized workflow automation.The office automation system in this period in the office mechanism that it covered, is set up the environment of collaborative work, and communication and information sharing mechanism between each intelligent department are provided, and has realized the robotization of flow of work process.Its maximum contribution has been to realize that circulation of official document is from the leap of traditional hand mode to workflow robotization mode.But second generation office automation lacks the managerial ability to knowledge.
It is core that the third generation office automation system is stressed with the data resource, is the decision level back-up system of technical foundation with the artificial intelligence of computing machine, pays close attention to how to obtain being distributed in not comprovincial data resource, and abundant shared mechanism is provided.Compare with the second generation, the robotization of workflow is not only simulated and realized to the third generation office automation system, simulated more and realized that each unit in the workflow and each staff use the process of resource.The infosystem that combines through workflow robotization and resource management realizes, is intended to realize that operation flow and office workflow are collaborative, traversing space-time is collaborative etc.Third generation office automation on the basis that with the workflow is the center more each link of file processing provide this step needed data resource.
For the third generation office automation system, the collection of data resource seems most important.Therefore, must overcome obstacle in this data-gathering process of isomeric data.
With reference to shown in Figure 1, the present invention has disclosed a kind of office automation system based on isomeric data, comprising: one group of heterogeneous database 10, data integration device 11, application layer 12 and client 13.
One group of heterogeneous database 10 makes up according to different data structures, and data wherein are so-called isomeric data.In one embodiment; Embodiment for example shown in Figure 1 comprises the database that makes up according to the Oracle data structure in one group of heterogeneous database 10, for example the heterogeneous database among Fig. 1 101; The database that perhaps makes up, the for example heterogeneous database among Fig. 1 102 according to the SQL data structure.In a further embodiment, one group of heterogeneous database also can be structured database or semi-structured data storehouse.
The office automation system based on isomeric data of the present invention can integrated isomerous effectively data; Make the office automation system to overcome because the problem that the difference on the data structure is brought; In wider data resource, operate, promote the application level and the work efficiency of the office automation system.
Claims (6)
1. the office automation system based on isomeric data is characterized in that, comprising:
One group of heterogeneous database, said one group of heterogeneous database makes up according to different data structures;
Data integration device; Be connected to said one group of heterogeneous database; In said data integration device and the heterogeneous database each is carried out exchanges data; When data integration device and a heterogeneous database carry out exchanges data, use the data structure that conforms to this heterogeneous database, data integration device will be carried out Data Format Transform from the data that heterogeneous database obtains; The data that form the uniform data form also are kept in the storer, and the data in the data in the said storer and the one group of heterogeneous database are synchronous in terms of content;
Application layer is connected to said data integration device, and application layer comprises one group of business logic modules, and this group of business logic modules is visited said storer, from storer, obtains data and carries out service logic;
Client is connected to said application layer, and the business logic modules in the said application layer of client call is carried out service logic and obtained the execution result of service logic.
2. the office automation system based on isomeric data as claimed in claim 1 is characterized in that,
Said one group of heterogeneous database makes up according to Oracle data structure or SQL data structure.
3. the office automation system based on isomeric data as claimed in claim 1 is characterized in that,
Said data integration device will be carried out data that Data Format Transform forms uniform data format from the data that heterogeneous database obtains and comprised and form the data that meet HTTP, XML or soap protocol.
4. the office automation system based on isomeric data as claimed in claim 1 is characterized in that,
Said data integration device comprises the data-switching instrument, and the data-switching that said data-switching instrument will meet first data layout of appointment becomes to meet the data of second data layout of appointment.
5. the office automation system based on isomeric data as claimed in claim 4 is characterized in that,
Said data-switching instrument comprises: Oracle-HTTP crossover tool, Oracle-XML crossover tool, Oracle-SOAP crossover tool, SQL-HTTP crossover tool, SQL-XML crossover tool and SQL-SOAP crossover tool.
6. the office automation system based on isomeric data as claimed in claim 1 is characterized in that, one group of business logic modules of said application layer comprises:
Word processing module, statistical module, communication module, authority management module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105895429A CN102567334A (en) | 2010-12-15 | 2010-12-15 | Office automation system based on heterogeneous data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010105895429A CN102567334A (en) | 2010-12-15 | 2010-12-15 | Office automation system based on heterogeneous data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102567334A true CN102567334A (en) | 2012-07-11 |
Family
ID=46412775
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010105895429A Pending CN102567334A (en) | 2010-12-15 | 2010-12-15 | Office automation system based on heterogeneous data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102567334A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
| CN103839138A (en) * | 2014-03-08 | 2014-06-04 | 成都文昊科技有限公司 | System for supporting interaction of multiple heterogeneous systems |
| CN104715051A (en) * | 2015-03-30 | 2015-06-17 | 东南大学 | Integrated processing method for power station system heterogeneous data fusion |
| CN105426525A (en) * | 2015-12-09 | 2016-03-23 | 浪潮通用软件有限公司 | Isomerous data integration method and device based on data storage |
| CN106357452A (en) * | 2016-09-29 | 2017-01-25 | 上海和付信息技术有限公司 | High-availability framework system with single-point heterogeneous data storage function and realizing method thereof |
| CN107330026A (en) * | 2017-06-22 | 2017-11-07 | 物链（北京）科技有限公司 | A kind of method and system of compatible isomery block platform chain |
| CN113806332A (en) * | 2021-08-23 | 2021-12-17 | 北京金蝶云基科技有限公司 | Heterogeneous system integrated data processing method and device and computer equipment |
| CN114253480A (en) * | 2021-12-21 | 2022-03-29 | 北京云迹科技股份有限公司 | Data storage method and device, electronic equipment and storage medium |
-
2010
- 2010-12-15 CN CN2010105895429A patent/CN102567334A/en active Pending
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103685543A (en) * | 2013-12-23 | 2014-03-26 | 中国电子科技集团公司第三十研究所 | Method and system for data synchronism between heterogeneous databases |
| CN103839138A (en) * | 2014-03-08 | 2014-06-04 | 成都文昊科技有限公司 | System for supporting interaction of multiple heterogeneous systems |
| CN104715051A (en) * | 2015-03-30 | 2015-06-17 | 东南大学 | Integrated processing method for power station system heterogeneous data fusion |
| CN104715051B (en) * | 2015-03-30 | 2019-02-15 | 东南大学 | A kind of integral treatment method towards the fusion of electric power station system isomeric data |
| CN105426525A (en) * | 2015-12-09 | 2016-03-23 | 浪潮通用软件有限公司 | Isomerous data integration method and device based on data storage |
| CN106357452A (en) * | 2016-09-29 | 2017-01-25 | 上海和付信息技术有限公司 | High-availability framework system with single-point heterogeneous data storage function and realizing method thereof |
| CN106357452B (en) * | 2016-09-29 | 2019-06-04 | 上海和付信息技术有限公司 | A kind of the High Availabitity frame system and its implementation of the storage of single-point isomeric data |
| CN107330026A (en) * | 2017-06-22 | 2017-11-07 | 物链（北京）科技有限公司 | A kind of method and system of compatible isomery block platform chain |
| CN107330026B (en) * | 2017-06-22 | 2021-03-23 | 物链（北京）科技有限公司 | Method compatible with heterogeneous block chain platform |
| CN113806332A (en) * | 2021-08-23 | 2021-12-17 | 北京金蝶云基科技有限公司 | Heterogeneous system integrated data processing method and device and computer equipment |
| CN113806332B (en) * | 2021-08-23 | 2024-03-19 | 北京金蝶云基科技有限公司 | Heterogeneous system integrated data processing method and device and computer equipment |
| CN114253480A (en) * | 2021-12-21 | 2022-03-29 | 北京云迹科技股份有限公司 | Data storage method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102567334A (en) | Office automation system based on heterogeneous data | |
| CN101388904B (en) | GIS service aggregating method, device and system | |
| US8443374B2 (en) | Business application integration adapters management system | |
| CN102262680B (en) | Distributed database proxy system based on massive data access requirement | |
| CN102567378A (en) | Information retrieval system based on heterogeneous data | |
| CN105809356A (en) | Information system resource management method based on application integrated cloud platform | |
| CN108446335B (en) | Heterogeneous system data extraction and unified external data exchange method based on database | |
| CN104754045A (en) | Data center service and application interface management platform | |
| CN102567330A (en) | Heterogeneous database integration system | |
| CN104796389A (en) | Basic data sharing system and method thereof | |
| CN102932431A (en) | Message-routing-based state monitoring data interface configuration method | |
| CN108108460A (en) | A kind of standardized work flows intelligent management system framework and system | |
| CN102375894A (en) | Method for managing different types of file systems | |
| CN103092982B (en) | Based on the information service system of multi views business model | |
| CN103064916A (en) | Emin DI data integration engine and report generation method | |
| CN104636840A (en) | Construction project field management information acquisition and subsequent application processing technology | |
| CN101266545A (en) | Electric power industry integral supporting platform | |
| CN114218291A (en) | Portrait generation method, apparatus, device and storage medium based on target object | |
| Yeh et al. | Analysis of E-government service platform based on cloud computing | |
| CN103729455B (en) | Master data storage method based on primary copy storage pattern | |
| Dai | Design and implementation of ESB based on SOA in power system | |
| CN112150042A (en) | Planning review management method and system based on micro application and micro service architecture | |
| CN103064688A (en) | Workflow universal service method and system | |
| CN103023740A (en) | Information interaction bus system and electric power data transmission method | |
| Kouzmanov | Analysis and classification of business software systems integration approaches |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120711 |