CN103186576A - Method and cooperative system for performing cooperative processing on heterogeneous system data - Google Patents
Method and cooperative system for performing cooperative processing on heterogeneous system data Download PDFInfo
- Publication number
- CN103186576A CN103186576A CN2011104511290A CN201110451129A CN103186576A CN 103186576 A CN103186576 A CN 103186576A CN 2011104511290 A CN2011104511290 A CN 2011104511290A CN 201110451129 A CN201110451129 A CN 201110451129A CN 103186576 A CN103186576 A CN 103186576A
- Authority
- CN
- China
- Prior art keywords
- basic data
- data
- list
- template
- configuration information
- 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
Images
Abstract
The invention discloses a method for cooperative processing on heterogeneous system data. The method for performing cooperative processing on heterogeneous system data comprises the following steps of: adding basic data to a to-be-processed form by utilizing a basic data template; setting configuration information of the added basic data by utilizing a form designer; analyzing the configuration information by a form analyzer, calling a heterogeneous system database, and acquiring associated data of the added basic data from the heterogeneous system database according to the configuration information; and filling the associated data selected by a user in the to-be-processed form. The embodiment of the invention also provides a corresponding cooperative system. According to the technical scheme disclosed by the invention, when the basic data are added to the cooperative system, secondary development does not need to be performed on the cooperative system, and only corresponding setting needs to be performed on an operation interface provided by the cooperative system.
Description
Technical field
The present invention relates to technical field of data processing, be specifically related to a kind of method and cooperative system of the heterogeneous system data being carried out associated treatment.
Background technology
Heterogeneous system is the set of a plurality of Database Systems of being correlated with, and can realize sharing and transparent access of data.Enterprise customers etc. often utilize cooperative system to coordinate the interior a plurality of Database Systems of heterogeneous system, and the heterogeneous system data are carried out associated treatment.In processing procedure, cooperative system need be obtained data usually from the heterogeneous system database, perhaps write data to heterogeneous system.
Example as shown in Figure 1, in the process of in cooperative system, the procurement request document being examined, cooperative system need read basic data from heterogeneous system, as, material code, stock etc., examine finish after, service system needs again data such as commodities purchased title, quantity are write in the heterogeneous system.
Yet the enterprise customer often changes upgrading according to demand or changes the heterogeneous system that it adopts, and making increases some new basic datas in the heterogeneous system, and the basic data project in the cooperative system has been determined well when system development, can not adjust.
Can identify and obtain these newly-increased basic datas in order to make cooperative system, and these newly-increased basic datas are handled, the common way of prior art is, mode with hard coded is carried out secondary development to cooperative system, rewrite the source code of cooperative system, in order in cooperative system, increase these basic data projects.
For the enterprise customer, cooperative system is carried out secondary development suitable difficulty, needs very big workload, and repeatedly its core code of the cooperative system of Gai Xieing is too redundant, and poor, the poor stability of extendability is unfavorable for later maintenance; For service provider, then need the source code of cooperative system is offered the enterprise customer, be quite unsafe and provide source code to the client.
Summary of the invention
The embodiment of the invention provides a kind of the heterogeneous system data is carried out method and the cooperative system of associated treatment, to solve prior art in cooperative system during newly-increased basic data, the technical matters that need carry out secondary development in the hard coded mode.
A kind of the heterogeneous system data are carried out the method for associated treatment, comprising:
Utilize the basic data template in pending list, to add basic data;
Utilize the list designer arrange add the configuration information of basic data;
The described configuration information of list resolver resolves calls the heterogeneous system database, according to described configuration information from the heterogeneous system database, obtain add the associated data of basic data;
The associated data that the user selects is inserted in the described pending list.
A kind of cooperative system is used for the heterogeneous system data are carried out associated treatment, comprising:
Template management module is used for utilizing the basic data template to add basic data to pending list;
The list designer adds the configuration information of basic data for arranging;
The list resolver be used for to be resolved described configuration information, calls the heterogeneous system database, according to described configuration information from the heterogeneous system database, obtain add the associated data of basic data; The associated data that the user selects is inserted in the described pending list.
Embodiment of the invention technical scheme, at first utilize the basic data template in pending list, to add basic data, follow-up then by the list resolver resolves from the heterogeneous system database, obtain add the associated data of basic data, make when needing in cooperative system, to add basic data, need not carry out secondary development to cooperative system, only need carry out relative set at the operation interface that cooperative system provides and get final product.
Description of drawings
Fig. 1 is the process flow diagram of an example of prior art;
Fig. 2 is the embodiment of the invention is carried out the method for associated treatment to the heterogeneous system data process flow diagram;
Fig. 3 is the building-block of logic of the cooperative system that provides of the embodiment of the invention.
Embodiment
The embodiment of the invention provides a kind of method of the heterogeneous system data being carried out associated treatment, this method utilizes the basic data template to add basic data in pending list, utilize the list resolver resolves from the heterogeneous system database, obtain add the associated data of basic data, make when needing in cooperative system, to add basic data, need not carry out secondary development to cooperative system, only need carry out relative set at the operation interface that cooperative system provides and get final product.The embodiment of the invention also provides corresponding cooperative system.Below be elaborated respectively.
Embodiment one,
Please refer to Fig. 2, the embodiment of the invention provides a kind of the heterogeneous system data is carried out the method for associated treatment, comprising:
101, utilize the basic data template in pending list, to add basic data.
The cooperative system of the embodiment of the invention comprises a template management module, and the user can perhaps, safeguard the basic data template that has disposed by the new basic data template of this template management module configuration.Definition basic data information in the basic data template.User by selecting loads corresponding basic data template, corresponding basic data can be added in the pending list.
Said template management module is the input interface that cooperative system is reserved, the basic data information that defines in the basic data template of being selected to load by the user can be imported in the cooperative system, and cooperative system is added the basic data that obtains in the pending list to.
Concrete, when in template management module, storing the basic data template corresponding with the interpolation basic data, select the basic data template of described correspondence; When in template management module, not having the basic data template corresponding with the interpolation basic data, by the new basic data template of interpolation basic data configuration.
Suppose and do not comprise basic data " user list " in the pending list, and the user needs " user list " this basic data is added in the list, then the user can select from template management module or newly-built " user list " template, template management module loads is somebody's turn to do " user list " template, " user list " added in the pending list, as the new column in the pending list.
102, utilize the list designer arrange add the configuration information of basic data.
Be added new basic data in the pending list, the user can be by the list designer by being added basic data, and for example " user list " arranges configuration information.Said list designer is another input interface that cooperative system is reserved, the information that the user imports in the list designer can be input in the cooperative system by the list designer, and cooperative system is then preserved the information that obtains from the list designer as the configuration information of interpolation basic data.
The configuration information that arranges can comprise: contents such as data source, display mode, assignment field, querying condition, display list, query statement.Wherein, data source is used to specify the new basic data of adding and derives from which database in the heterogeneous system, for example ERP system database; Display mode is used to specify new display mode of adding basic data, for example drop-down menu; Display list is used to specify which associated data relevant with this basic data, for example title, coding and classification etc. of demonstration.It should be noted that the above only is an example, in the practical application, configuration information needn't comprise above-described full content, also can comprise other above unlisted content.
103, the described configuration information of list resolver resolves calls the heterogeneous system database, according to described configuration information from the heterogeneous system database, obtain add the associated data of basic data.
Through 101 and 102, though be added the basic data project in the pending list, for example " Perform Project Financial Aanalysis " guide look, concrete associated data is stored in the heterogeneous system database in detail, is difficult to directly obtain.In the prior art, the user when cooperative system is carried out secondary development, by the interpolation basic data be provided with the link of pointing to Relational database, in the subsequent processes, the user clicks the link of the basic data correspondence of new interpolation, can read corresponding associated data from heterogeneous system.
In the present embodiment, in order from heterogeneous system, to read corresponding associated data, in service system, increased the list resolver.The list designer is the IO interface that cooperative system is reserved, function with configuration information of pending list in the cooperative system obtained, write the function of information in the pending list in the cooperative system, and visit heterogeneous system database function that can be transparent fully.
This list resolver can be used for resolving in the pending list configuration information of newly-increased basic data, calls heterogeneous system simultaneously, according to described configuration information from the heterogeneous system database, obtain add the associated data of basic data.In concrete the application, the list resolver can convert the configuration information of resolving to executable sql statement, and the heterogeneous system database is operated; Wherein, the sql statement is a kind of language that database is operated.This list resolver can be considered a kind of basic data container.
Illustrate, having specified data source in the configuration information of " user list " data that increase newly is certain ERP system database, display list has been specified title, coding and classification, then the list resolver obtains title, each title corresponding codes and classification of all users from this ERP system database, and shows at display interface.For example, " user list " can comprise three users down, and its title is respectively user A, user B, user C etc., and these three user's corresponding codes are respectively 002,003,004, and classification is the client.Simultaneously, can also provide options before each user's name, this user's name can be selected.
104, the associated data that the user is selected is inserted in the described pending list.
The enterprise customer is in examining processing procedure, be used for can from the list resolver obtain and show add the associated data of basic data, select corresponding associated data, for example, can choose " user B ", determine to submit to, then associated data " user B " just is received in described pending list.
To sum up, the embodiment of the invention provides a kind of method of the heterogeneous system data being carried out associated treatment, at first utilize the basic data template in pending list, to add basic data, follow-up then by the list resolver resolves from the heterogeneous system database, obtain add the associated data of basic data, make when needing in cooperative system, to add basic data, only need carry out relative set at the operation interface that cooperative system provides and get final product.Thereby service provider need not offer the enterprise customer with the source code of cooperative system, has guaranteed the security of source code, enterprise is used for and need not carries out secondary development to cooperative system, alleviate workload, and kept the stable of service system core code and simplify, be conducive to later maintenance.
Embodiment two,
Please refer to Fig. 3, the embodiment of the invention provides a kind of cooperative system, is used for the heterogeneous system data are carried out associated treatment, and this cooperative system comprises:
Wherein, can also comprise a data source module 404, be used for carrying out data with heterogeneous system and link up, list resolver 403 can by data source module 404 from heterogeneous system, obtain add the associated data of basic data.
Described template management module 401 specifically can be used for selecting the data template on the basis of described correspondence when template management module stores the basic data template corresponding with the interpolation basic data; When in template management module, not having the basic data template corresponding with the interpolation basic data, by the new basic data template of interpolation basic data configuration.
Described list designer 402 specifically can add data source, display mode, assignment field, querying condition, display list and the query statement of basic data for arranging.
Described list resolver 403 specifically can comprise:
Resolution unit is used for resolving described configuration information;
Call unit is for the heterogeneous system database that calls described data source correspondence;
Acquiring unit is used for according to described configuration information, from the heterogeneous system database of described data source correspondence, obtain add the associated data of basic data;
Writing unit is used for the associated data that the user selects is inserted described pending list.
Concrete, the said write unit, can be used for the associated data that the user selects insert pending list add the column of basic data correspondence.
To sum up, the embodiment of the invention provides a kind of cooperative system, be used for the heterogeneous system data are worked in coordination with, this cooperative system can utilize the basic data template to add basic data in pending list, utilize the list resolver resolves from the heterogeneous system database, obtain add the associated data of basic data, make when needing in cooperative system, to add basic data, only need carry out relative set at the operation interface that cooperative system provides and get final product.Thereby service provider need not offer the enterprise customer with the source code of cooperative system, has guaranteed the security of source code, enterprise is used for and need not carries out secondary development to cooperative system, alleviate workload, and kept the stable of service system core code and simplify, be conducive to later maintenance.
One of ordinary skill in the art will appreciate that all or part of step in the whole bag of tricks of above-described embodiment can finish by hardware, also can finish by the relevant hardware of programmed instruction, this program can be stored in the computer-readable recording medium, and storage medium can comprise: ROM (read-only memory), random-access memory, disk or CD etc.
More than method and cooperative system that the heterogeneous system data are carried out associated treatment that the embodiment of the invention is provided be described in detail, but the explanation of above embodiment just is used for helping to understand method of the present invention and core concept thereof, should not be construed as limitation of the present invention.Those skilled in the art are in the technical scope that the present invention discloses, and the variation that can expect easily or replacement all should be encompassed within protection scope of the present invention.
Claims (10)
1. one kind is carried out the method for associated treatment to the heterogeneous system data, it is characterized in that, comprising:
Utilize the basic data template in pending list, to add basic data;
Utilize the list designer arrange add the configuration information of basic data;
The described configuration information of list resolver resolves calls the heterogeneous system database, according to described configuration information from the heterogeneous system database, obtain add the associated data of basic data;
The associated data that the user selects is inserted in the described pending list.
2. method according to claim 1 is characterized in that, describedly utilizes the basic data template to add basic data in the pending list to comprise:
When in template management module, storing the basic data template corresponding with the interpolation basic data, select the basic data template of described correspondence;
When in template management module, not having the basic data template corresponding with the interpolation basic data, by the new basic data template of interpolation basic data configuration.
3. method according to claim 1 is characterized in that, described utilize the list designer arrange add basic data configuration information comprise:
Arrange add data source, display mode, assignment field, querying condition, display list and the query statement of basic data.
4. method according to claim 3 is characterized in that, the described configuration information of described list resolver resolves calls the heterogeneous system database and comprises:
The described configuration information of list resolver resolves calls the heterogeneous system database of described data source correspondence.
5. method according to claim 1 is characterized in that, the described associated data that the user is selected is inserted in the described pending list and comprised:
The associated data that the user is selected insert pending list add in the column of basic data correspondence.
6. a cooperative system is used for the heterogeneous system data are carried out associated treatment, it is characterized in that this cooperative system comprises:
Template management module is used for utilizing the basic data template to add basic data to pending list;
The list designer adds the configuration information of basic data for arranging;
The list resolver be used for to be resolved described configuration information, calls the heterogeneous system database, according to described configuration information from the heterogeneous system database, obtain add the associated data of basic data; The associated data that the user selects is inserted in the described pending list.
7. cooperative system according to claim 6 is characterized in that:
Described template management module, concrete being used for selected the data template on the basis of described correspondence when template management module stores the basic data template corresponding with the interpolation basic data; When in template management module, not having the basic data template corresponding with the interpolation basic data, by the new basic data template of interpolation basic data configuration.
8. method according to claim 6 is characterized in that:
Described list designer, concrete data source, display mode, assignment field, querying condition, display list and the query statement that adds basic data for arranging.
9. method according to claim 8 is characterized in that, described list resolver comprises:
Resolution unit is used for resolving described configuration information;
Call unit is for the heterogeneous system database that calls described data source correspondence;
Acquiring unit is used for according to described configuration information, from the heterogeneous system database of described data source correspondence, obtain add the associated data of basic data;
Writing unit is used for the associated data that the user selects is inserted described pending list.
10. method according to claim 6 is characterized in that:
The said write unit, concrete be used for the associated data that the user selects insert pending list add the column of basic data correspondence.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110451129.0A CN103186576B (en) | 2011-12-29 | 2011-12-29 | Heterogeneous system data are carried out to method and the cooperative system of associated treatment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110451129.0A CN103186576B (en) | 2011-12-29 | 2011-12-29 | Heterogeneous system data are carried out to method and the cooperative system of associated treatment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103186576A true CN103186576A (en) | 2013-07-03 |
| CN103186576B CN103186576B (en) | 2016-04-06 |
Family
ID=48677745
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110451129.0A Active CN103186576B (en) | 2011-12-29 | 2011-12-29 | Heterogeneous system data are carried out to method and the cooperative system of associated treatment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103186576B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122363A (en) * | 2016-02-25 | 2017-09-01 | 镇江雅迅软件有限责任公司 | A kind of intelligent form system |
| CN108509448A (en) * | 2017-02-27 | 2018-09-07 | 北京京东尚科信息技术有限公司 | Data processing method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101639842A (en) * | 2008-07-29 | 2010-02-03 | 阿里巴巴集团控股有限公司 | Characteristics data statistic method and system of members |
| CN101930464A (en) * | 2010-08-25 | 2010-12-29 | 华南理工大学 | RFID logistics application-orientated loose heterogeneous data exchange system and method |
| CN102034152A (en) * | 2010-12-13 | 2011-04-27 | 东莞市高鑫机电科技服务有限公司 | SOA (Service Oriented Architecture) based heterogeneous software system data integration method and system |
-
2011
- 2011-12-29 CN CN201110451129.0A patent/CN103186576B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101639842A (en) * | 2008-07-29 | 2010-02-03 | 阿里巴巴集团控股有限公司 | Characteristics data statistic method and system of members |
| CN101930464A (en) * | 2010-08-25 | 2010-12-29 | 华南理工大学 | RFID logistics application-orientated loose heterogeneous data exchange system and method |
| CN102034152A (en) * | 2010-12-13 | 2011-04-27 | 东莞市高鑫机电科技服务有限公司 | SOA (Service Oriented Architecture) based heterogeneous software system data integration method and system |
Non-Patent Citations (2)
| Title |
|---|
| 张小波等: "基于协同数据库的数据迁移模型研究与实现", 《计算机工程与设计》, vol. 26, no. 5, 31 May 2005 (2005-05-31) * |
| 郑丽丽: "基于XML的异构数据交换模型的研究", 《中国优秀硕士学位论文全文数据库（电子期刊）》, 15 August 2008 (2008-08-15) * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122363A (en) * | 2016-02-25 | 2017-09-01 | 镇江雅迅软件有限责任公司 | A kind of intelligent form system |
| CN108509448A (en) * | 2017-02-27 | 2018-09-07 | 北京京东尚科信息技术有限公司 | Data processing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103186576B (en) | 2016-04-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3353672B1 (en) | Method and apparatus for transferring data between databases | |
| US8340995B2 (en) | Method and system of using artifacts to identify elements of a component business model | |
| US8818975B2 (en) | Data model access configuration and customization | |
| CN104133772A (en) | Automatic test data generation method | |
| US20100161648A1 (en) | Flexible multi-tenant support of metadata extension | |
| US20140310233A1 (en) | Tracing data through a transformation process using tracer codes | |
| CN103778107A (en) | Method and platform for quickly and dynamically generating form based on EXCEL | |
| US9619533B2 (en) | System and method for reporting multiple objects in enterprise content management | |
| US20110112973A1 (en) | Automation for Governance, Risk, and Compliance Management | |
| US11922146B2 (en) | Systems and method for creating enterprise software | |
| CN102096588A (en) | Control-containing page establishing method | |
| US20140136472A1 (en) | Methodology supported business intelligence (BI) software and system | |
| CN106557307B (en) | Service data processing method and system | |
| US10332010B2 (en) | System and method for automatically suggesting rules for data stored in a table | |
| CN112328224A (en) | Service interface docking method and device, storage medium and electronic equipment | |
| CN111126019A (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN110046287A (en) | A kind of the data query method, apparatus and storage medium unrelated with type of database | |
| US20120109998A1 (en) | Retrieval and storage of localized instances of data objects | |
| US20130014082A1 (en) | Method of configuring business logic supporting multi-tenancy | |
| CN108804685B (en) | Asset hosting and monitoring task processing method and device | |
| CN102109990A (en) | Intelligent display system and method for report | |
| CN108241620B (en) | Query script generation method and device | |
| CN103186384A (en) | Business-component-oriented software designing and analyzing system and using method thereof | |
| CN103186576B (en) | Heterogeneous system data are carried out to method and the cooperative system of associated treatment | |
| US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |