CN104615637A - Data exchange method and data exchange intermediate device - Google Patents

Data exchange method and data exchange intermediate device Download PDF

Info

Publication number
CN104615637A
CN104615637A CN201410675395.5A CN201410675395A CN104615637A CN 104615637 A CN104615637 A CN 104615637A CN 201410675395 A CN201410675395 A CN 201410675395A CN 104615637 A CN104615637 A CN 104615637A
Authority
CN
China
Prior art keywords
database
different application
data
description file
rule description
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
Application number
CN201410675395.5A
Other languages
Chinese (zh)
Inventor
唐进
李志海
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Jiesai Hujiaotong Communication Technology Co Ltd
Original Assignee
Guangzhou Jiesai Hujiaotong Communication Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangzhou Jiesai Hujiaotong Communication Technology Co Ltd filed Critical Guangzhou Jiesai Hujiaotong Communication Technology Co Ltd
Priority to CN201410675395.5A priority Critical patent/CN104615637A/en
Publication of CN104615637A publication Critical patent/CN104615637A/en
Pending legal-status Critical Current

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a data exchange method. The data exchange method includes the steps that regulation description files of different application programs are loaded, the regulation description files comprises database information, database source lists, database target lists and database filtering conditions; the database information, the database source lists, the database target lists and the database filtering conditions are analyzed; the database source lists of the different application programs are inquired; data of the database source lists of the different application programs are filtered according to the database filtering conditions of the different application programs; the filtered data are stored in the database target lists of the different application programs respectively. The invention further provides a data exchange intermediate device. By means of the data exchange method and the data exchange intermediate device, the different application programs are allowed to use a uniform service logic visit database and generate data required by the different application programs, function reuse is achieved, the complex rate of developing work is reduced, the coupling relation between the different application programs and the service logic of the different application programs and data sources can be relieved, a system is allowed to further possess expansibility, and changeful application requirements are met.

Description

Method for interchanging data and exchanges data middle device
Technical field
The present invention relates to computer communication field, particularly relate to method for interchanging data and the exchanges data middle device of integrated multi-application system.
Background technology
Current integrated multi-application system, the tidal data recovering gathered by each field apparatus disposed is to database system, and application software is according to the service logic accessing database of application and to user side pushed information.Along with the change of application demand, service logic is abundant, complicated gradually, and the mode of the multiple business of single application software process lacks dirigibility, is difficult to the development adapting to application; Multiple application runs the mode of respective service logic accesses database, faces again the input of a lot of function overlapping development.
In sum, in prior art, at least there are the following problems: multiple application runs respective service logic accesses database, cause overlapping development, different application cannot use unified service logic accessing database, cannot practical function multiplexing, reduce development.
Summary of the invention
Respective service logic accesses database is run for overcoming multiple application in prior art, cause overlapping development, different application cannot use unified service logic accessing database, cannot practical function multiplexing, reduce the problem of development, the embodiment of the present invention provides a kind of method for interchanging data on the one hand, comprising:
Load the rule description file of different application, this rule description file comprises database information, database source table, database object table and data filtering condition;
Resolve the database information in the rule description file of described different application, database source table, database object table and data filtering condition;
The database source table of inquiry different application, and the data in the database source table of different application are filtered according to the data filtering condition of different application;
By the data of having filtered respectively stored in the described database object table in different application.
On the other hand, embodiments provide a kind of exchanges data middle device, comprising:
Load-on module, for loading the rule description file of different application, this rule description file comprises database information, database source table, database object table and data filtering condition;
Parsing module, for resolving database information, database source table, database object table and the data filtering condition in the rule description file of described different application;
Query filter module, for inquiring about the database source table of different application, and filters the data in the database source table of different application according to the data filtering condition of different application;
Point storing module, for the data of will filter respectively stored in the described database object table in different application.
The embodiment of the present invention is by exchanges data middle device, load, resolve the rule description file of all different application, and perform data query, filtration and point operation of depositing, make multiple different application can use unified service logic and above-mentioned method for interchanging data accessing database and the data generated needed for different application by this exchanges data middle device, practical function is multiplexing, reduce the complexity of development, the coupled relation of different application and service logic and data source can be removed, make system have more extendability, can changeable application demand be adapted to.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, below the accompanying drawing used required in describing embodiment is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the schematic flow sheet of the first embodiment of method for interchanging data of the present invention;
Fig. 2 is the schematic flow sheet of the second embodiment of method for interchanging data of the present invention;
Fig. 3 is the structural representation of the first embodiment of exchanges data middle device of the present invention;
Fig. 4 is the structural representation of the embodiment of parsing module of the present invention;
Fig. 5 is the structural representation of the second embodiment of exchanges data middle device of the present invention.
Embodiment
In order to make technical matters solved by the invention, technical scheme and beneficial effect clearly understand, below in conjunction with drawings and Examples, the present invention is further elaborated.Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
Please refer to Fig. 1, be the schematic flow sheet of the first embodiment of method for interchanging data of the present invention, method for interchanging data of the present invention comprises:
Step S101, load the rule description file of different application, this rule description file comprises database information, database source table, database object table and data filtering condition.
In this step, described different application, if the application in campus, can be the multiple different application with different demand such as the attendance query of student whether normally to school is applied, students' result enquiry application, message application; If the application in enterprise, can be office OA application, work attendance application, customer information application, supply chain application etc.; Can also be some similar application of other industry.
In this step, by the unified rule description file loading all different application of host process, separating Different Rule description document according to the rule description file of different application needs the database information of operation, database source table, database object table and data filtering condition.
In this step, rule description file dynamic loads, and rule description file uses json, and (English full name is JavaScript Object Notation, is a kind of data interchange format of lightweight.It is a subset based on JavaScript (Standard ECMA-2623rd Edition-December 1999).JSON adopts the text formatting being totally independent of language, but also using the custom (comprising C, C++, C#, Java, JavaScript, Perl, Python etc.) being similar to C language family.The data interchange language that these characteristics make JSON become desirable.Be easy to people read and write, be also easy to machine simultaneously and resolve and generate.) language description, same with the reading of computing machine friendly to people, can be undertaken increasing, deleting and retouching operation by outside.
Step S102, resolves the database information in the rule description file of described different application, database source table, database object table and data filtering condition.
Particularly, this step comprises:
Resolve the database information in the rule description file of different application, and for the corresponding database connection pool of each Database, this database connection pool is used for distributing, managing and release DataBase combining; Described database information comprises database address, database port, database name, database user name and database password.In this step, described DataBase combining is a kind of resource of limited costliness of key, and this point embodies particularly outstanding in the Web page application program of multi-user.Retractility and the robustness of whole application program can be significantly impacted the management of DataBase combining, have influence on the performance index of program.Database connection pool puts forward for this problem just.Database connection pool is responsible for distributing, managing and release DataBase combining, and its allows application program to reuse an existing DataBase combining, and is or else re-establish one; The DataBase combining that the releasing idling time exceedes maximum idle time avoids the DataBase combining caused because of not discharging DataBase combining to omit.This technology can significantly improve the performance to database manipulation.The DataBase combining creating some is put in connection pool when initialization by database connection pool, and the quantity of these DataBase combining is set by minimum data storehouse linking number.No matter whether these DataBase combining are used, and connection pool all will ensure at least to have so many numbers of connection always.The maximum data storehouse number of connection of connection pool defines the maximum number of connections that this connection pool can occupy, and when application program exceedes maximum number of connections amount to the linking number of connection pool request, these requests will be added in waiting list.
Resolve the database source table in the rule description file of different application, determine all database source tables, described database source table comprises affiliated database and table name.
Resolve the database object table in the rule description file of different application, determine all database object tables, described datum target table comprises affiliated database and table name.In this step, if database object table does not exist, then according to the data structure newdata storehouse object table of the database source table in the rule description file of different application, namely copy a duplicate database object table of data structure according to database source table.
Resolve the data filtering condition in the rule description file of different application, and set up the condition data structure.In this step, described data filtering condition, can be different according to the different demand of application, can be the filterconditions such as time, numeral, content.In addition, the condition data structure set up in this step, is the condition data structure that the program converted to by data filtering condition can identify, is generally made up of Hash table, array, numerical value, character string, Boolean.
Step S103, the database source table of inquiry different application, and the data in the database source table of different application are filtered according to the data filtering condition of different application.
This step specifically comprises: the database source table of inquiry different application, and according to the data in the database source table of the described condition data structured filter different application set up.
Step S104, by the data of having filtered respectively stored in the described database object table in different application.
The inventive method embodiment is by loading, resolving the rule description file of all different application, and perform data query, filtration and point operation of depositing, make multiple different application can use unified service logic accessing database and the data generated needed for different application by this method, practical function is multiplexing, reduce the complexity of development, the coupled relation of different application and service logic and data source can be removed, make system have more extendability, can changeable application demand be adapted to.
Please refer to Fig. 2, be the schematic flow sheet of the second embodiment of method for interchanging data of the present invention, method for interchanging data of the present invention comprises:
Step S201, according to the demand of different application, to receive by arbitrary money text editor the direct amendment of the rule description file of different application, preserves operation.
In this step, (English full name is JavaScript Object Notation to the rule description file use json of described different application, is a kind of data interchange format of lightweight.It is a subset based on JavaScript (Standard ECMA-2623rd Edition-December 1999).JSON adopts the text formatting being totally independent of language, but also using the custom (comprising C, C++, C#, Java, JavaScript, Perl, Python etc.) being similar to C language family.The data interchange language that these characteristics make JSON become desirable.Be easy to people read and write, be also easy to machine simultaneously and resolve and generate.) language description, same with the reading of computing machine friendly to people, can be increased it by arbitrary money text editor, delete or retouching operation by outside.
Step S202, according to above-mentioned amendment, preserves operation, generates the timestamp information of renewal in the attribute of rule description file.
In this step, as long as rule description file has amendment, then in the attribute of rule description file, generate the timestamp information of renewal, provide basis for estimation for whether recognition rule description document is modified.
Step S203, receives instruction of restarting.
In this step, instruction of restarting can be realized by terminal console program by operating personnel or monitor supervision platform.
Step S204, according to instruction of restarting, reads the timestamp information in the attribute of rule description file.
In this step, reading the timestamp information in the attribute of rule description file, is in order to whether recognition rule description document is modified.
Step S205, if the timestamp information read is the timestamp information upgraded, the then amended rule description file of dynamic load, this amended rule description file comprises database information, database source table, database object table and data filtering condition equally.
In this step, described different application, if the application in campus, can be the multiple different application with different demand such as the attendance query of student whether normally to school is applied, students' result enquiry application, message application; If the application in enterprise, can be office OA application, work attendance application, customer information application, supply chain application etc.; Can also be some similar application of other industry.
In this step, by the unified rule description file loading all different application of host process, separating Different Rule description document according to the rule description file of different application needs the database information of operation, database source table, database object table and data filtering condition.
Step S206, resolves the database information in the rule description file of described different application, database source table, database object table and data filtering condition.
Particularly, this step comprises:
Resolve the database information in the rule description file of different application, and for the corresponding database connection pool of each Database, this database connection pool is used for distributing, managing and release DataBase combining; Described database information comprises database address, database port, database name, database user name and database password.In this step, described DataBase combining is a kind of resource of limited costliness of key, and this point embodies particularly outstanding in the Web page application program of multi-user.Retractility and the robustness of whole application program can be significantly impacted the management of DataBase combining, have influence on the performance index of program.Database connection pool puts forward for this problem just.Database connection pool is responsible for distributing, managing and release DataBase combining, and its allows application program to reuse an existing DataBase combining, and is or else re-establish one; The DataBase combining that the releasing idling time exceedes maximum idle time avoids the DataBase combining caused because of not discharging DataBase combining to omit.This technology can significantly improve the performance to database manipulation.The DataBase combining creating some is put in connection pool when initialization by database connection pool, and the quantity of these DataBase combining is set by minimum data storehouse linking number.No matter whether these DataBase combining are used, and connection pool all will ensure at least to have so many numbers of connection always.The maximum data storehouse number of connection of connection pool defines the maximum number of connections that this connection pool can occupy, and when application program exceedes maximum number of connections amount to the linking number of connection pool request, these requests will be added in waiting list.
Resolve the database source table in the rule description file of different application, determine all database source tables, described database source table comprises affiliated database and table name.
Resolve the database object table in the rule description file of different application, determine all database object tables, described datum target table comprises affiliated database and table name.In this step, if database object table does not exist, then according to the data structure newdata storehouse object table of the database source table in the rule description file of different application, namely copy a duplicate database object table of data structure according to database source table.
Resolve the data filtering condition in the rule description file of different application, and set up the condition data structure.In this step, described data filtering condition, can be different according to the different demand of application, can be the filterconditions such as time, numeral, content.In addition, the condition data structure set up in this step, is the condition data structure that the program converted to by data filtering condition can identify, is generally made up of Hash table, array, numerical value, character string, Boolean.
Step S207, the database source table of inquiry different application, and the data in the database source table of different application are filtered according to the data filtering condition of different application.
This step specifically comprises: the database source table of inquiry different application, and according to the data in the database source table of the described condition data structured filter different application set up.
Step S208, by the data of having filtered respectively stored in the described database object table in different application.
The rule description file of the different application of the embodiment of the present invention uses json language to describe, can revise at any time and dynamic load, dynamic load, after parsing, get final product the amended new data query of implementation rule description document, filter and point operation of depositing, with existing single application when running into function and changing or expand, first need revise code, then recompilate, the technology of application deployment is compared again, the present invention directly can be modified operation to rule description file by arbitrary text editor by outside, when function changes or expands, retouching operation is simpler, convenient, without the need to again compiling and disposing, system is made to have more extendability, changeable application demand can be adapted to.
Fig. 1, Fig. 2 embodiment to method for interchanging data of the present invention elaborates, and will continue by reference to the accompanying drawings below, is described the device (i.e. exchanges data middle device) corresponding to said method flow process.
Please refer to Fig. 3, is the structural representation of the first embodiment of exchanges data middle device of the present invention, and this exchanges data middle device 100 comprises load-on module 110, parsing module 120, query filter module 130 and point storing module 140.
Load-on module 110, for loading the rule description file of different application, this rule description file comprises database information, database source table, database object table and data filtering condition.Described different application, can be the multiple different application with different school controls demand such as the attendance query of student whether normally to school is applied, students' result enquiry application, message application, also can be the application of the different regulatory requirement of enterprises, as OA application, work attendance application, customer information application, the supply chain application etc. of handling official business, can also be some similar application of other industry.The unified rule description file loading all different application of load-on module 1001, separating Different Rule description document according to the rule description file of different application needs the database information of operation, database source table, database object table and data filtering condition.
Parsing module 120, for resolving database information, database source table, database object table and the data filtering condition in the rule description file of described different application.
Query filter module 130, for inquiring about the database source table of different application, and filters the data in the database source table of different application according to the data filtering condition of different application.
Point storing module 140, for the data of will filter respectively stored in the described database object table in different application.
Further, please refer to Fig. 4, is the structural representation of the embodiment of parsing module of the present invention, and described parsing module 120 comprises:
Database information resolution unit 121, for resolving the database information in the rule description file of different application, and for the corresponding database connection pool of each Database, this database connection pool is used for distributing, managing and release DataBase combining; Described database information comprises database address, database port, database name, database user name and database password.
Database source table resolution unit 122, for resolving the database source table in the rule description file of different application, determine all database source tables, described database source table comprises affiliated database and table name.
Database object table resolution unit 123, for resolving the database object table in the rule description file of different application, determine all database object tables, described datum target table comprises affiliated database and table name.
Data filtering condition resolution unit 124, for resolving the data filtering condition in the rule description file of different application, and set up the condition data structure.Described data filtering condition, can be different according to the different demand of application, can be the filterconditions such as time, numeral, content.Described condition data structure, is the condition data structure that the program converted to by data filtering condition can identify, is generally made up of Hash table, array, numerical value, character string, Boolean.
Further, described query filter module 130 comprises:
Query filter unit, for inquiring about the database source table of different application, and according to the data in the database source table of the described condition data structured filter different application set up.
Again further, described database object table resolution unit 123 also comprises the newly-built subelement of database object table, the newly-built subelement of this database object table is used for the database object table in the rule description file of resolving different application, determine in the process of all database object tables, when database object table does not exist, according to the data structure newdata storehouse object table of the database source table in the rule description file of different application.
Notebook data exchanges middle device and can independent part be deployed on a station server, by cluster server network access data storehouse server, data exchange logics is obtained by the business rule description document reading different application, can dynamic conditioning service logic, support new applied business.The startup of this exchanges data middle device, restart, stop to be realized by terminal console program by operating personnel or monitor supervision platform.Exchanges data middle device can concurrent running, during operation expanding, realizes by running multiple exchanges data middle device.
The embodiment of the present invention loads, resolves the rule description file of all different application by exchanges data middle device, and perform data query, filtration and point operation of depositing, make multiple different application can use unified service logic and above-mentioned method for interchanging data accessing database and the data generated needed for different application by this exchanges data middle device, practical function is multiplexing, reduce the complexity of development, the coupled relation of different application and service logic and data source can be removed, make system have more extendability, can changeable application demand be adapted to.
Please refer to Fig. 5, is the structural representation of the second embodiment of exchanges data middle device of the present invention, and this exchanges data middle device 200 comprises load-on module 210, parsing module 220, query filter module 230 and point storing module 240.
Load-on module 210, for loading the rule description file of different application, this rule description file comprises database information, database source table, database object table and data filtering condition.Described different application, can be the multiple different application with different school controls demand such as the attendance query of student whether normally to school is applied, students' result enquiry application, message application, also can be the application of the different regulatory requirement of enterprises, as OA application, work attendance application, customer information application, the supply chain application etc. of handling official business, can also be some similar application of other industry.The unified rule description file loading all different application of load-on module 210, separating Different Rule description document according to the rule description file of different application needs the database information of operation, database source table, database object table and data filtering condition.The rule description file of the different application that described load-on module 210 loads uses json language to describe, and can revise at any time and dynamic load, this load-on module 210 comprises further:
Operation receiving element 211 is preserved in amendment, for the demand according to different application, to receive by arbitrary money text editor the direct amendment of the rule description file of different application, preserves operation.
Timestamp information generation unit 212, for according to above-mentioned amendment, preservation operation, generates the timestamp information of renewal in the attribute of rule description file.
Instruction of restarting receiving element 213, for receiving instruction of restarting.
Timestamp information reading unit 214, for according to instruction of restarting, reads the timestamp information in the attribute of rule description file.
Dynamic load unit 215, during for being the timestamp information upgraded at the timestamp information read, then the amended rule description file of dynamic load.
Parsing module 220, for resolving database information, database source table, database object table and the data filtering condition in the rule description file of described different application.
Query filter module 230, for inquiring about the database source table of different application, and filters the data in the database source table of different application according to the data filtering condition of different application.
Point storing module 240, for the data of will filter respectively stored in the described database object table in different application.
Further, described parsing module 220 comprises:
Database information resolution unit, for resolving the database information in the rule description file of different application, and for the corresponding database connection pool of each Database, this database connection pool is used for distributing, managing and release DataBase combining; Described database information comprises database address, database port, database name, database user name and database password.
Database source table resolution unit, for resolving the database source table in the rule description file of different application, determine all database source tables, described database source table comprises affiliated database and table name.
Database object table resolution unit, for resolving the database object table in the rule description file of different application, determine all database object tables, described datum target table comprises affiliated database and table name.
Data filtering condition resolution unit, for resolving the data filtering condition in the rule description file of different application, and set up the condition data structure.Described data filtering condition, can be different according to the different demand of application, can be the filterconditions such as time, numeral, content.Described condition data structure, is the condition data structure that the program converted to by data filtering condition can identify, is generally made up of Hash table, array, numerical value, character string, Boolean.
Further, described query filter module 230 comprises:
Query filter unit, for inquiring about the database source table of different application, and according to the data in the database source table of the described condition data structured filter different application set up.
Again further, described database object table resolution unit also comprises the newly-built subelement of database object table, the newly-built subelement of this database object table is used for the database object table in the rule description file of resolving different application, determine in the process of all database object tables, when database object table does not exist, according to the data structure newdata storehouse object table of the database source table in the rule description file of different application.
Notebook data exchanges middle device and can independent part be deployed on a station server, by cluster server network access data storehouse server, data exchange logics is obtained by the business rule description document reading different application, can dynamic conditioning service logic, support new applied business.The startup of this exchanges data middle device, restart, stop to be realized by terminal console program by operating personnel or monitor supervision platform.Exchanges data middle device can concurrent running, during operation expanding, realizes by running multiple exchanges data middle device.
The rule description file of the different application of the embodiment of the present invention uses json language to describe, can revise at any time and dynamic load, dynamic load, after parsing, get final product the amended new data query of implementation rule description document, filter and point operation of depositing, with existing single application when running into function and changing or expand, first need revise code, then recompilate, the technology of application deployment is compared again, the present invention directly can be modified operation to rule description file by arbitrary text editor by outside, when function changes or expands, retouching operation is simpler, convenient, without the need to again compiling and disposing, system is made to have more extendability, changeable application demand can be adapted to.
One of ordinary skill in the art will appreciate that all or part of flow process realized in above-described embodiment method, that the hardware that can carry out instruction relevant by computer program has come, described program can be stored in a computer read/write memory medium, this program, when performing, can comprise the flow process of the embodiment as above-mentioned each side method.Wherein, described storage medium can be magnetic disc, CD, read-only store-memory body (Read-Only Memory, ROM) or random store-memory body (Random Access Memory, RAM) etc.
Be one or more embodiments provided in conjunction with particular content as mentioned above, do not assert that specific embodiment of the invention is confined to these explanations.Method all and of the present invention, structure etc. are approximate, identical, or for making some technology deduction or replace under concept thereof of the present invention, all should be considered as protection scope of the present invention.

Claims (10)

1. a method for interchanging data, is characterized in that, comprising:
Load the rule description file of different application, this rule description file comprises database information, database source table, database object table and data filtering condition;
Resolve the database information in the rule description file of described different application, database source table, database object table and data filtering condition;
The database source table of inquiry different application, and the data in the database source table of different application are filtered according to the data filtering condition of different application;
By the data of having filtered respectively stored in the described database object table in different application.
2. method for interchanging data according to claim 1, it is characterized in that, in the step of the rule description file of described loading different application, the rule description file of different application uses json language to describe, can revise at any time and dynamic load, this step comprises further:
According to the demand of different application, to receive by arbitrary money text editor the direct amendment of the rule description file of different application, preserve operation;
According to above-mentioned amendment, preserve operation, in the attribute of rule description file, generate the timestamp information of renewal;
Receive instruction of restarting;
According to instruction of restarting, read the timestamp information in the attribute of rule description file;
If the timestamp information read is the timestamp information upgraded, then the amended rule description file of dynamic load.
3. method for interchanging data according to claim 1 and 2, is characterized in that, the step of the database information in the rule description file of the described different application of described parsing, database source table, database object table and data filtering condition comprises:
Resolve the database information in the rule description file of different application, and for the corresponding database connection pool of each Database, this database connection pool is used for distributing, managing and release DataBase combining; Described database information comprises database address, database port, database name, database user name and database password;
Resolve the database source table in the rule description file of different application, determine all database source tables, described database source table comprises affiliated database and table name;
Resolve the database object table in the rule description file of different application, determine all database object tables, described datum target table comprises affiliated database and table name;
Resolve the data filtering condition in the rule description file of different application, and set up the condition data structure.
4. method for interchanging data according to claim 3, is characterized in that, the database source table of described inquiry different application, and filters the step of the data in the database source table of different application according to the data filtering condition of different application, comprising:
The database source table of inquiry different application, and according to the data in the database source table of the described condition data structured filter different application set up.
5. method for interchanging data according to claim 4, it is characterized in that, database object table in the rule description file of resolving different application, determine in the step of all database object tables, if database object table does not exist, then according to the data structure newdata storehouse object table of the database source table in the rule description file of different application.
6. an exchanges data middle device, is characterized in that, comprising:
Load-on module, for loading the rule description file of different application, this rule description file comprises database information, database source table, database object table and data filtering condition;
Parsing module, for resolving database information, database source table, database object table and the data filtering condition in the rule description file of described different application;
Query filter module, for inquiring about the database source table of different application, and filters the data in the database source table of different application according to the data filtering condition of different application;
Point storing module, for the data of will filter respectively stored in the described database object table in different application.
7. exchanges data middle device according to claim 6, is characterized in that, the rule description file of the different application that described load-on module loads uses json language to describe, and can revise at any time and dynamic load, this load-on module comprises further:
Operation receiving element is preserved in amendment, for the demand according to different application, to receive by arbitrary money text editor the direct amendment of the rule description file of different application, preserves operation;
Timestamp information generation unit, for according to above-mentioned amendment, preservation operation, generates the timestamp information of renewal in the attribute of rule description file;
Instruction of restarting receiving element, for receiving instruction of restarting;
Timestamp information reading unit, for according to instruction of restarting, reads the timestamp information in the attribute of rule description file;
Dynamic load unit, during for being the timestamp information upgraded at the timestamp information read, then the amended rule description file of dynamic load.
8. the exchanges data middle device according to claim 6 or 7, is characterized in that, described parsing module comprises:
Database information resolution unit, for resolving the database information in the rule description file of different application, and for the corresponding database connection pool of each Database, this database connection pool is used for distributing, managing and release DataBase combining; Described database information comprises database address, database port, database name, database user name and database password;
Database source table resolution unit, for resolving the database source table in the rule description file of different application, determine all database source tables, described database source table comprises affiliated database and table name;
Database object table resolution unit, for resolving the database object table in the rule description file of different application, determine all database object tables, described datum target table comprises affiliated database and table name;
Data filtering condition resolution unit, for resolving the data filtering condition in the rule description file of different application, and set up the condition data structure.
9. exchanges data middle device according to claim 8, is characterized in that, described query filter module comprises:
Query filter unit, for inquiring about the database source table of different application, and according to the data in the database source table of the described condition data structured filter different application set up.
10. exchanges data middle device according to claim 9, it is characterized in that, described database object table resolution unit also comprises the newly-built subelement of database object table, the newly-built subelement of this database object table is used for the database object table in the rule description file of resolving different application, determine in the process of all database object tables, when database object table does not exist, according to the data structure newdata storehouse object table of the database source table in the rule description file of different application.
CN201410675395.5A 2014-11-20 2014-11-20 Data exchange method and data exchange intermediate device Pending CN104615637A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410675395.5A CN104615637A (en) 2014-11-20 2014-11-20 Data exchange method and data exchange intermediate device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410675395.5A CN104615637A (en) 2014-11-20 2014-11-20 Data exchange method and data exchange intermediate device

Publications (1)

Publication Number Publication Date
CN104615637A true CN104615637A (en) 2015-05-13

Family

ID=53150081

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410675395.5A Pending CN104615637A (en) 2014-11-20 2014-11-20 Data exchange method and data exchange intermediate device

Country Status (1)

Country Link
CN (1) CN104615637A (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105512168A (en) * 2015-11-16 2016-04-20 天津南大通用数据技术股份有限公司 Cluster database composite data loading method and apparatus
CN106484800A (en) * 2016-09-22 2017-03-08 济南浪潮高新科技投资发展有限公司 A kind of implementation method efficiently collecting multisystem big data
CN107145540A (en) * 2017-04-24 2017-09-08 北京邮电大学 The diagram file textual conversion equipment and method of the version control function of class uml diagram
CN108255623A (en) * 2018-01-22 2018-07-06 深圳市卓讯信息技术有限公司 Realize the data exchange monitoring method and device of thread inside and outside dual reconciliation mechanism
CN109359093A (en) * 2018-12-19 2019-02-19 杭州安恒信息技术股份有限公司 A kind of rule file update method and system
CN110019442A (en) * 2017-09-04 2019-07-16 华为技术有限公司 Access method and device
CN111124548A (en) * 2019-12-31 2020-05-08 科大国创软件股份有限公司 Rule analysis method and system based on YAML file

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100337235C (en) * 2003-06-23 2007-09-12 华为技术有限公司 Method and apparatus for accessing database
CN101930469B (en) * 2010-09-02 2012-05-30 江西省电力公司超高压分公司 Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform
CN102323945B (en) * 2011-09-02 2013-05-01 南京中兴力维软件有限公司 SQL (Structured Query Language)-based database management method and device

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100337235C (en) * 2003-06-23 2007-09-12 华为技术有限公司 Method and apparatus for accessing database
CN101930469B (en) * 2010-09-02 2012-05-30 江西省电力公司超高压分公司 Universal data access method of cross-platform multi-heterogeneous database in scheduling data service platform
CN102323945B (en) * 2011-09-02 2013-05-01 南京中兴力维软件有限公司 SQL (Structured Query Language)-based database management method and device

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105512168A (en) * 2015-11-16 2016-04-20 天津南大通用数据技术股份有限公司 Cluster database composite data loading method and apparatus
CN106484800A (en) * 2016-09-22 2017-03-08 济南浪潮高新科技投资发展有限公司 A kind of implementation method efficiently collecting multisystem big data
CN107145540A (en) * 2017-04-24 2017-09-08 北京邮电大学 The diagram file textual conversion equipment and method of the version control function of class uml diagram
CN110019442A (en) * 2017-09-04 2019-07-16 华为技术有限公司 Access method and device
CN110019442B (en) * 2017-09-04 2023-10-13 华为技术有限公司 Method and device for fetching number
CN108255623A (en) * 2018-01-22 2018-07-06 深圳市卓讯信息技术有限公司 Realize the data exchange monitoring method and device of thread inside and outside dual reconciliation mechanism
CN108255623B (en) * 2018-01-22 2022-03-15 深圳市卓讯信息技术有限公司 Data exchange monitoring method and device for realizing internal and external double account checking mechanism of thread
CN109359093A (en) * 2018-12-19 2019-02-19 杭州安恒信息技术股份有限公司 A kind of rule file update method and system
CN111124548A (en) * 2019-12-31 2020-05-08 科大国创软件股份有限公司 Rule analysis method and system based on YAML file
CN111124548B (en) * 2019-12-31 2023-10-27 科大国创软件股份有限公司 Rule analysis method and system based on YAML file

Similar Documents

Publication Publication Date Title
CN104615637A (en) Data exchange method and data exchange intermediate device
CN101504672B (en) Method and system for dynamically configuring physical data table
US8364683B2 (en) Importing and reconciling resources from disjoint name spaces to a common namespace
US9372880B2 (en) Reclamation of empty pages in database tables
CN102938784A (en) Method and system used for data storage and used in distributed storage system
CN103631937B (en) Build method, the apparatus and system of row storage index
US11010401B2 (en) Efficient snapshot generation of data tables
CN103377336A (en) Method and system for controlling computer system user rights
CN103890709A (en) Cache based key-value store mapping and replication
US20170212930A1 (en) Hybrid architecture for processing graph-based queries
CN102760096A (en) Test data generation method, unit testing method and unit testing system
CN103186622A (en) Updating method of index information in full text retrieval system and device thereof
CN101320388A (en) Method and apparatus for filtering documents according to documents state
CN109885642A (en) Classification storage method and device towards full-text search
US11281704B2 (en) Merging search indexes of a search service
CN103049546B (en) The method and apparatus of a kind of management, access system daily record
CN105095392A (en) Method and device for data sharing among data marts
Choi et al. Improved performance optimization for massive small files in cloud computing environment
CN101261639B (en) Sharing of database objects
CN103809915B (en) The reading/writing method of a kind of disk file and device
CN107463638A (en) File sharing method and equipment between offline virtual machine
US9111114B1 (en) Method of transforming database system privileges to object privileges
US20230409235A1 (en) File system improvements for zoned storage device operations
CN103514185B (en) The database file access management method and device of the multiple update area of navigation map
CN110109866A (en) A kind of management method and equipment of file system directories

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20150513

RJ01 Rejection of invention patent application after publication