CN100483421C - Functional component and data relating operation method and system - Google Patents

Functional component and data relating operation method and system Download PDF

Info

Publication number
CN100483421C
CN100483421C CNB2007101777722A CN200710177772A CN100483421C CN 100483421 C CN100483421 C CN 100483421C CN B2007101777722 A CNB2007101777722 A CN B2007101777722A CN 200710177772 A CN200710177772 A CN 200710177772A CN 100483421 C CN100483421 C CN 100483421C
Authority
CN
China
Prior art keywords
data
function
building blocks
date
request
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.)
Active
Application number
CNB2007101777722A
Other languages
Chinese (zh)
Other versions
CN101158968A (en
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.)
Industrial and Commercial Bank of China Ltd ICBC
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
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 Industrial and Commercial Bank of China Ltd ICBC filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CNB2007101777722A priority Critical patent/CN100483421C/en
Publication of CN101158968A publication Critical patent/CN101158968A/en
Application granted granted Critical
Publication of CN100483421C publication Critical patent/CN100483421C/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention relates to a method and a system of the associated operation of functional components and data. The method includes that receive a data service request containing a functional component identification, a request identification and a data date; according to the data date, find the corresponding version date of the functional component object in the second association table, and according to the functional component identification, acquire the corresponding functional component object; according to the data date and the acquired data component identification, acquire the corresponding data identification in the third association table; composite the acquired data table and the acquired functional component object to form an executable component according to the request identification; execute the executable component and return the requested service data.

Description

A kind of building blocks of function and data relating operation method and system
Technical field
The present invention is about program version management and data life period administrative skill, particularly the technology about unifying operational management based on the functional module and the data environment thereof of data history and program version history is a kind of building blocks of function and data relating operation method and system concretely.
Background technology
In the prior art, the software architecture of the computer application system of large enterprise and function are very complicated, generally can have a plurality of upgraded versions through the process of a plurality of Continual Improvements.And data structure in the application system and data are complementary with certain particular version, along with the replacement and the upgrading of version, application system increasingly sophisticated, functional development and improve before, must research have application system and data environment thereof now, analyze of the influence of new function for the historical data environment.Further, more data structure changes and data are divided a word with a hyphen at the end of a line if edition upgrading involves, and must interrupt online service for a long time so, and this will seriously influence the service operation of company.
In addition, certain building blocks of function of the prior art often is applied in a plurality of different computer application systems.If this building blocks of function is relevant with specific data, when function is improved, bring the compatibility of building blocks of function and the problem of the passive upgrading of application system so thereupon.
In order to solve above-mentioned prior art problems, prior art has proposed the notion of data warehouse, that Data warehouse is meant is subject-oriented, integrated, with data acquisition time correlation, that can not revise.Data in the data warehouse need long-term accumulation, enter Data Warehouse and need keep stability.But should stability be difficult in the prior art reach.
In order to solve above-mentioned prior art problems, prior art has proposed a kind of application system method for building up towards building blocks of function.This building blocks of function is basic composition element and the basic building unit in the framework of component-oriented, also is the unit of specific implementation service logic.In above-mentioned member, " structure " is exactly that the assembling ability will be arranged, and gets final product assembleability; " part " is exactly to have a style of one's own, and possesses certain function.Traditional application system is made up of the plurality of sub system, and each independent particle system is made up of some business modules.And in the process based on the component-oriented exploitation, building blocks of function makes traditional subsystem be assembled by the building blocks of function of relatively independent autonomy one by one.The application and development of the application architecture of component-oriented is to be based upon to have on the basis of enriching the component base resource.
As seen, the framework of component-oriented provides a kind of means that function service existing and that will develop is in the future integrated organizationally, and data warehouse provides a kind of means with data resource unified management and use.But present two conceptions of species can not be compatible, and the framework that is embodied in component-oriented is not emphasized the integration utilization for historical data, and data warehouse then almost can't adapt to the data variation that renewal brought of application system.
Chinese patent application 200610052229.5 discloses the implementation method of a kind of embedded system based on building blocks of functionization, and the disclosed content of this patented claim is herein incorporated, with as prior art of the present invention.
Summary of the invention
The present invention proposes a kind of building blocks of function and data relating operation method and system and has solved above-mentioned technical matters.A kind of building blocks of function and data relating operation method and system are by the history of hold function member, and the automatic coupling of building blocks of function and data, thereby on stream, accomplish to combine, be not subjected to the constraint of time dimension, as required with data, obtain needed building blocks of function easily, no matter use the building blocks of function of which version, can both find its corresponding real data, thereby accomplish flexibly real and reliable.
The present invention proposes a kind of building blocks of function and data relating operation method, and described method comprises: the mapping relations between building blocks of function sign and the data members sign are stored in first contingency table; Building blocks of function sign, building blocks of function object and the mapping relations between the building blocks of function object version date are stored in second contingency table; Mapping relations between data members sign, Data Identification and the Data Date are stored in the 3rd contingency table; Mapping relations between Data Identification and the data name are stored in the 4th contingency table; Wherein, described method is carried out following steps: receive the data service request that comprises building blocks of function sign, request mark and Data Date; In second contingency table, find the corresponding building blocks of function object version date according to described Data Date, obtain corresponding building blocks of function object according to the building blocks of function sign again; Be identified at the data members sign of obtaining correspondence in first contingency table according to described building blocks of function; Be identified at the Data Identification that obtains correspondence in the 3rd contingency table according to described Data Date and the data members of obtaining; In the 4th contingency table, obtain corresponding data name according to the Data Identification that obtains, obtain corresponding tables of data according to data name again; The tables of data obtained is combined to form according to described request mark with the building blocks of function object that obtains carries out member; Carry out the described member of carrying out, return the requested service data.
The present invention proposes a kind of building blocks of function and data relating operation system, it is characterized in that, described system comprises: the contingency table storage unit, be used for the mapping relations between memory function component mark and the data members sign, building blocks of function sign, building blocks of function title, building blocks of function object and the mapping relations between the building blocks of function object version date, mapping relations between data members sign, data members title, Data Identification and the Data Date, the mapping relations between Data Identification and the data name; The request of data receiving element is used to receive the data service request that comprises building blocks of function sign, request mark and Data Date; Building blocks of function object acquisition unit is used for finding the corresponding building blocks of function object version date according to described Data Date in the contingency table storage unit, obtains corresponding building blocks of function object according to the sign of the building blocks of function in the data service request again; Data members sign acquiring unit is used for being identified at the contingency table storage unit according to described building blocks of function and obtains corresponding data members sign; The Data Identification acquiring unit is used for being identified at the contingency table storage unit according to described Data Date and the data members of obtaining and obtains corresponding Data Identification; The tables of data acquiring unit is used for obtaining corresponding data name according to the Data Identification that obtains in the contingency table storage unit, obtains corresponding tables of data according to data name again; Can carry out the member generation unit, be used for the tables of data that to obtain and the building blocks of function object that obtains and be combined to form according to described request mark and can carry out member; The service data output unit is used to carry out the described member of carrying out, and returns the requested service data.
The present invention is directed to the problem how general new function that runs into of present infosystem development adapts with old function, and the problem that how adapts with the function transition of the variation of historical data, it is long fundamentally to have broken through the construction cycle that runs in the existing application system development process, the problem that development and maintenance cost rises, provide a kind of with carry out between a plurality of feature releases and the historical data in the application system automatically, the operation architecture framework of efficient, unified management.
Description of drawings
Fig. 1 is a kind of building blocks of function of the present invention and data relating operation method process flow diagram;
Fig. 2 is a kind of building blocks of function of the present invention and data relating operation system construction drawing;
Fig. 3 is that system of the present invention forms structural drawing;
Fig. 4 is the composition structural drawing of member supporter;
Fig. 5 is the composition structural drawing of member operation unit;
Fig. 6 is the composition structural drawing of bus unit;
Fig. 7 is the course of work process flow diagram of method of the present invention;
Fig. 8-Figure 11 is a metadata table of the present invention;
Figure 12 shows that customer information table before changing;
Figure 13 shows that customer information table after changing;
Figure 14 is the building blocks of function metadata table of the embodiment of the invention;
Figure 15 is the data members metadata table of the embodiment of the invention;
Figure 16 is the data description metadata table of the embodiment of the invention;
Figure 17 is the performance data metadata table of the embodiment of the invention;
Figure 18 is the different request lists of the embodiment of the invention;
Figure 19 is the workflow diagram of the embodiment of the invention.
Embodiment
Below in conjunction with embodiment and accompanying drawing the present invention is described.
Fig. 1 is a kind of building blocks of function of the present invention and data relating operation method process flow diagram, and as shown in Figure 1, its method concrete steps are as follows:
Step 301 is stored in the mapping relations between building blocks of function sign and the data members sign in first contingency table;
Step 302 is stored in building blocks of function sign, building blocks of function object and the mapping relations between the building blocks of function object version date in second contingency table;
Step 303 is stored in the mapping relations between data members sign, Data Identification and the Data Date in the 3rd contingency table;
Step 304 is stored in the mapping relations between Data Identification and the data name in the 4th contingency table;
Step 305 receives the data service request that comprises building blocks of function sign, request mark and Data Date;
Step 306 finds the corresponding building blocks of function object version date according to described Data Date in second contingency table, obtain corresponding building blocks of function object according to the building blocks of function sign again;
Step 307 is identified at the data members sign of obtaining correspondence in first contingency table according to described building blocks of function;
Step 308 is identified at the Data Identification that obtains correspondence in the 3rd contingency table according to described Data Date and the data members of obtaining;
Step 309 is obtained corresponding data name according to the Data Identification that obtains in the 4th contingency table, obtain corresponding tables of data according to data name again;
Step 310 is combined to form with the building blocks of function object that obtains the tables of data obtained and can carries out member according to described request mark;
Step 311 is carried out the described member of carrying out, and returns the requested service data.
Fig. 2 is a kind of building blocks of function of the present invention and data relating operation system construction drawing, and as shown in Figure 2, system provided by the present invention comprises:
Contingency table storage unit 401, be used for the mapping relations between memory function component mark and the data members sign, building blocks of function sign, building blocks of function title, building blocks of function object and the mapping relations between the building blocks of function object version date, mapping relations between data members sign, data members title, Data Identification and the Data Date, the mapping relations between Data Identification and the data name;
Request of data receiving element 402 is used to receive the data service request that comprises building blocks of function sign, request mark and Data Date;
Building blocks of function object acquisition unit 403 is used for finding the corresponding building blocks of function object version date according to described Data Date in the contingency table storage unit, obtains corresponding building blocks of function object according to the building blocks of function sign again;
Data members sign acquiring unit 404 is used for being identified at the contingency table storage unit according to described building blocks of function and obtains corresponding data members sign;
Data Identification acquiring unit 405 is used for being identified at the contingency table storage unit according to described Data Date and the data members of obtaining and obtains corresponding Data Identification;
Tables of data acquiring unit 406 is used for obtaining corresponding data name according to the Data Identification that obtains in the contingency table storage unit, obtains corresponding tables of data according to data name again;
Can carry out member generation unit 407, be used for the tables of data that to obtain and the building blocks of function object that obtains and be combined to form according to described request mark and can carry out member;
Service data output unit 408 is used to carry out the described member of carrying out, and returns the requested service data.
Fig. 3 is that an embodiment of system of the present invention forms structural drawing, comprises member supporter 101, member operation unit 102 and bus unit 103.As shown in Figure 3, member supporter 101 transmits data with member operation unit 102 by bus unit 103.
External system is submitted services request to by bus unit 103, and bus unit 103 is transferred to member supporter 101 with described services request.
Member supporter 101 is after receiving the services request that bus unit 103 transmits, described services request includes services request ID and Data Date, find building blocks of function object, data members sign, Data Identification, the tables of data of its corresponding all functions member and each building blocks of function correspondence by described services request ID and Data Date, be transferred to member operation unit 102 by bus unit 103 then.
Member operation unit 102 receives all functions member, building blocks of function object and data members sign, Data Identification, the tables of data of described services request ID and Data Date correspondence by bus unit 103, according to operation flow they are assembled into executable instruction, and operation.At last, by bus unit 103 execution result is fed back to external system.
Bus unit 103 plays a part connecting elements operation unit 102 and member supporter 101, and described member operation unit 102 and member supporter 101 carry out the transmission of data, member and various control commands by bus unit 103.
Fig. 4 is the composition structural drawing of member supporter 101, and member supporter 101 further comprises building blocks of function engine unit 104, building blocks of function storage unit 105, data members engine unit 106, data members storage unit 107, Control Engine unit 108 and metadata storage unit 109 as shown in Figure 4.
Fig. 5 is the composition structural drawing of member operation unit 102, and member operation unit 102 further comprises member assembly unit 110, member performance element 111 and storage unit 112 as a result as shown in Figure 5.
Fig. 6 is the composition structural drawing of bus unit 103, and bus unit 103 further comprises member bus 113, control bus 114 and interface bus 115 as shown in Figure 6.
Control Engine unit 108 is equivalent to the request of data receiving element 402 among Fig. 2, it is responsible for services request and resolves, after receiving the services request that interface bus 115 transmits, from described services request, resolve and obtain services request ID, all functions member numbering and request msg date that described services request relates to, by building blocks of function engine unit 104 and data members engine unit 106 according to described services request ID, all functions member numbering that relates to and request msg date are searched all functions component mark and the corresponding building blocks of function object of each building blocks of function sign in metadata storage unit 109, the data members sign, Data Identification, tables of data is transferred to member operation unit 102 by member bus 113 then.And accept from the running state information of member performance element 111 by the described services request ID of control bus 114 feedbacks, if described services request running status is normal, then by interface bus 115 from obtaining operation result according to services request ID the storage unit 112 as a result, and by interface bus 115 operation result is fed back to external system according to services request ID.
Building blocks of function engine unit 104 is equivalent to the building blocks of function object acquisition unit 403 among Fig. 2, it is after receiving services request ID, request date and the building blocks of function sign of coming by control bus 114 transmission Control Engine unit 108, in building blocks of function storage unit 105,, and feed back to Control Engine unit 108 according to the building blocks of function object of request date and the marking matched respective version of building blocks of function.
Building blocks of function storage unit 105 is thesauruss of the concrete execution object of building blocks of function in the system, and building blocks of function engine unit 104 is located the execution object of searching respective version by request date and component mark.In order to write down the evolution process in the difference periods of history of same building blocks of function, the building blocks of function storage unit will be preserved the following key element of carrying out object: component mark, member title, execution object name, execution object storing path, effective from date, effective cut-off date.
Data members engine unit 106 is equivalent to data members sign acquiring unit 404, Data Identification acquiring unit 405 and the data name acquiring unit 406 among Fig. 2, it at first finds corresponding data members sign according to building blocks of function sign and request msg date in the performance data contingency table, be identified at according to data members again and search data members sign, Data Identification, tables of data in the data members storage unit 107, and feed back to Control Engine unit 108.
Data members storage unit 107 is thesauruss of the concrete executive routine of data members in the system.In order to write down same data members at the evolution process of different periods of history, the data members storage unit will be preserved following key element: component mark, member title, data-interface type, database concatenation character, storing process name, Data Identification, effectively from date, effective cut-off date.
Metadata storage unit 109 is equivalent to the contingency table storage unit 401 among Fig. 2, and it preserves a large amount of metadata informations in order to ensure the normal operation of supporting framework.For the evolution history information of record data member and building blocks of function, preserve the member metadata on the one hand; In order to drive the running of each module, some incidence relation metadata have been preserved on the one hand.First to fourth contingency table that the contingency table storage unit that provides as Fig. 8-Figure 11 401 is included, consider for the narration terseness, only keep the most essential information as example, but note the effective time period information of the essential reservation of metadata information, promptly preserve the change histories of metadata.
Member assembly unit 110 is equivalent to the member the carried out generation unit 407 among Fig. 2, all functions member, building blocks of function object and data members sign, Data Identification, tables of data with described services request ID and Data Date correspondence, be assembled into executable member instruction according to operation flow, and be transferred to member performance element 111.
Member performance element 111 is equivalent to the service data output unit 408 among Fig. 2, receive the executable member instruction that member assembly unit 110 transmits, move processing, operation result is saved in storage unit 112 as a result, and the running status of described services request ID (normal/failure) is fed back to Control Engine unit 108 by control bus 114, by interface bus 115 operation result of services request is fed back to external system or user.
Storage unit 112 is region of memorys of storage structure execution result as a result, is the buffer memory that is used for request results on the one hand, is the procedural information that is used to the request of preserving on the one hand.
Member bus 113 is used for carrying out the exchange of component information between member supporter 101 and member operation unit 102.
Control bus 114 is used for carrying out various steering orders and metadata information exchange between member supporter 101 and member operation unit 102.
Interface bus 115 is that data message is mutual between each module of internal system, and asks the inlet mutual with the result between native system and external system or the external user.
Fig. 7 is the course of work process flow diagram of a kind of building blocks of function and data relating operation method, and its concrete steps are as follows:
Step 201: external system or user submit services request to, and interface bus 115 is accepted after the described services request, transmit this services request and give Control Engine unit 108.
Step 202: Control Engine unit 108 is resolved from described services request and is obtained all functions member numbering and the request msg date that services request ID, described services request relate to after receiving the services request that interface bus 115 transmits.
Step 203: building blocks of function engine unit 104 is searched all functions component mark and the corresponding building blocks of function object of each building blocks of function sign according to all functions member numbering and request msg date that described services request ID relates in metadata storage unit 109, building blocks of function storage unit 105, and feeds back to Control Engine unit 108.
Step 204: data members engine unit 106 is searched data members sign, Data Identification, the tables of data of all functions component mark correspondence according to all functions component mark and request msg date that described services request ID relates in metadata storage unit 109, data members storage unit 107, and feeds back to Control Engine unit 108.
Step 205: Control Engine unit 108 is transferred to member operation unit 102 with all functions component mark and corresponding building blocks of function object, data members sign, Data Identification and the tables of data of each building blocks of function sign that described services request ID relates to by member bus 113.
Step 206: the described services request ID that member assembly unit 110 will receive and all functions member of Data Date correspondence, building blocks of function object and data members sign, Data Identification and tables of data, be assembled into executable member instruction according to operation flow, and be transferred to member performance element 111.
Step 207: member performance element 111 receives the executable member instruction that member assembly unit 110 transmits, move processing, operation result is saved in storage unit 112 as a result, and the running status of described services request ID (normal/failure) is fed back to Control Engine unit 108 by control bus 114, by interface bus 115 operation result of services request is fed back to external system or user.
According to a customer information maintenance application system use of the present invention is described below, in embodiments of the invention 1-7, quotes to provide customer information increased, deletes, changes, looks into four kinds of functions.This uses the demand along with business development, and the customer information table changes, this key element of increase " whether VIP (IsVIP) " is made amendment to the query function member again subsequently, has increased the function of demonstration " whether VIP (IsVIP) " key element.Customer information table 1 shown in Figure 12 is a customer information storage organization before changing.Customer information table 2 shown in Figure 13 is after changing, has increased the customer information storage organization of " whether VIP (IsVIP) ".Concrete example is as follows.
Provided present embodiment as Figure 14-Figure 17 and used the information of moving each required contingency table, considered, some information of list structure have been simplified from describing terseness.Provided the metadata information of 4 building blocks of functions in the building blocks of function metadata table shown in Figure 14.Wherein the building blocks of function object is reduced to object name herein, in the system of reality, should be class name (being classpath) shape such as com.icbc.custinfo.Query.class, com.icbc.custinfo.NewQuery.class.Data members metadata table shown in Figure 15 has provided the metadata information of data members.Provided the metadata information of 2 data signs in the data description metadata table shown in Figure 16.At present embodiment, we have simplified the data description metadata table, are that the situation of database table describes at data type only, in the system of reality, data type can be various, as view, temporary table, or even the operation result of one section storing process.Performance data metadata table shown in Figure 17 has provided the related information of building blocks of function and data members.
Four building blocks of functions during present embodiment is used provide four kinds of user's request of operating, consider the data change situation, and the data of promptly operating different times can specifically be divided into 7 kinds of situations, as shown in figure 18.
In order to illustrate in this programme, data and function are after change, and how system adapts to change, specifically how to move, and below analyze at the implementation status of four kinds of requests, and the present invention is described.Because how the key of present embodiment is after data and function change, still can find the content of respective version according to metadata information, so in following declarative procedure, process for the purpose of simplifying the description, we only are illustrated at the parsing process and the result of each services request, and some intermediate results are wherein no longer narrated.
Embodiment 1
User's services request R1 increases client requests, promptly increases user logging in the customer information table.The operation that increases user logging can only be to carry out on the data members of latest edition and building blocks of function, just the operation after change.In the present embodiment, as shown in figure 19, R1 Request Processing process is as follows:
1001. the user sends services request to system.Request content is as follows;
Component mark Request ID Data Date
F2 R1 2007-03-25
1002. interface bus 115 receives user's services request, and request is forwarded to Control Engine unit 108;
1003. after the 108 analysis service requests of Control Engine unit, according to the sign of the building blocks of function in the services request and request msg date locating function member and data members in metadata storage unit 109;
1) building blocks of function that in the building blocks of function metadata table of metadata storage unit 109, finds the version of corresponding time period according to the building blocks of function sign (F2) in the request and request msg date (2007-03-25).If the request msg date does not provide, then be defaulted as the current data date;
Component mark The member title The building blocks of function object Current effective marker Effective from date Effective Close Date
F2 Increase Add The 1st, 2004-01-01 9999-12-31
2) Control Engine unit 108 is identified at according to the building blocks of function in the request and finds corresponding data members sign in the performance data contingency table of metadata storage unit 109;
The building blocks of function sign The data members sign Effective from date Effective Close Date
F2 C1 2004-01-01 9999-12-31
1004. Control Engine unit 108 passes to building blocks of function engine unit 104 with the building blocks of function sign that finds, the building blocks of function engine identifies the building blocks of function of finding out respective version from building blocks of function storage unit 105, i.e. building blocks of function object (Add) according to building blocks of function;
1005. building blocks of function engine unit 104 passes through member bus 113 transmission member assembly units 110 with the building blocks of function that finds.Be following form in the present embodiment;
Request The building blocks of function object The data members sign Data Date
R1 Add C1 2007-03-25
1006. Control Engine unit 108 passes to data members engine unit 106 with the data members sign that finds, data members engine unit 106 is identified at the data members that finds the version of corresponding time period in the data members metadata table of metadata storage unit 109 according to data members, and Data Identification;
Component mark The member title Connection string Data Identification Current effective marker Effective from date Effective Close Date
C1 Customer information Oracle D2 1 2005-01-01 9999-12-31
1007. data members engine unit 106 finds corresponding tables of data according to Data Identification in the data description metadata table of metadata storage unit 109.And together with the information combination of the information and date member of tables of data.The contents are as follows in the present embodiment;
Data members Data Identification Tables of data Data Date
C1 D2 T_CUST_INFO_2 2007-03-25
1008. data members engine unit 106 passes through member bus 113 transmission member assembly units 110 with the data members that finds.The contents are as follows in the present embodiment;
Request Data members Data Identification Tables of data Data Date
R1 C1 D2 T_CUST_INFO_2 2007-03-25
1009. member assembly unit 110 is assembled together the building blocks of function that receives and data members and forms executable member according to request mark.Be following form in the present embodiment;
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R1 Add C1 D2 T_CUST_INFO_2 2007-03-25
1010. member assembly unit 110 sends the member that assembles to member performance element 111;
1011. Control Engine unit 108 is by control bus 114, the request command that member is carried out sends to member performance element 111;
After 1012. member performance element 111 receives order, according to the request mark in the order, the building blocks of function object that provides in the component invoking, and tables of data and Data Date parameter passed to the building blocks of function object, call the execution member;
Finish 1013. member performance element 111 is carried out the building blocks of function objects, leave execution result in storage unit 112 as a result, interface bus 115 is obtained the result from storage unit as a result 112 according to request mark, returns the user.In the present embodiment, R1 asks after treatment, promptly inserts a customer information record in table T_CUST_INFO_2.
In another embodiment of the present invention, user's services request R6, R7 are query requests, promptly inquire about user logging according to given customer ID in the customer information table.Consider for terseness, omitted necessary customer ID parameter herein, but supposition R6, R7 request two customer informations of being inquired about are respectively 2004-03-01 day and enter database 2007-01-01 day, promptly respectively in T_CUST_INFO_1 and T_CUST_INFO_2.
Embodiment 2
In the present embodiment, the customer information that query requests R6 inquired about promptly is recorded among the T_CUST_INFO_1 for entering database 2004-03-01 day, and its processing procedure is as follows:
1. the user sends services request to system.Request content is as follows;
Component mark Request ID Data Date
F1 R6 2004-03-01
2. interface bus 115 receives user's services request, and request is forwarded to Control Engine unit 108;
3. after the 108 analysis service requests of Control Engine unit, according to the sign of the building blocks of function in the services request and request msg date locating function member and data members in metadata storage unit 109;
1) building blocks of function that in the building blocks of function metadata table of metadata storage unit 109, finds the version of corresponding time period according to the building blocks of function sign (F1) in the request and request msg date (2004-03-01).If the request msg date does not provide, then be defaulted as the current data date;
Component mark The member title The building blocks of function object Current effective marker Effective from date Effective Close Date
F1 Inquiry Query 0 is not 2004-01-01 2005-12-31
2) Control Engine unit 108 is identified at according to the building blocks of function in the request and finds corresponding data members sign in the performance data contingency table of metadata storage unit 109;
The building blocks of function sign The data members sign Effective from date Effective Close Date
F1 C1 2004-01-01 9999-12-31
4. Control Engine unit 108 passes to building blocks of function engine unit 104 with the building blocks of function sign that finds, the building blocks of function engine identifies the building blocks of function of finding out respective version from building blocks of function storage unit 105, i.e. building blocks of function object (Query) according to building blocks of function;
5. building blocks of function engine unit 104 passes through member bus 113 transmission member assembly units 110 with the building blocks of function that finds.Be following form in the present embodiment;
Request The building blocks of function object The data members sign Data Date
R6 Query C1 2004-03-01
6. Control Engine unit 108 passes to data members engine unit 106 with the data members sign that finds, data members engine unit 106 is identified at the data members that finds the version of corresponding time period in the data members metadata table of metadata storage unit 109 according to data members, and Data Identification;
Component mark The member title Connection string Data Identification Current effective marker Effective from date Effective Close Date
C1 Customer information Oracle D1 0 2004-01-01 2004-12-31
7. data members engine unit 106 finds corresponding tables of data according to Data Identification in the data description metadata table of metadata storage unit 109.And together with the information combination of the information and date member of tables of data.The contents are as follows in the present embodiment;
Data members Data Identification Tables of data Data Date
C1 D1 T_CUST_INFO_1 2004-03-01
8. data members engine unit 106 passes through member bus 113 transmission member assembly units 110 with the data members that finds.The contents are as follows in the present embodiment;
Request Data members Data Identification Tables of data Data Date
R6 C1 D1 T_CUST_INFO_1 2004-03-01
9. member assembly unit 110 is assembled together the building blocks of function that receives and data members and forms executable member according to request mark.Be following form in the present embodiment;
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R6 Query C1 D1 T_CUST_INFO_1 2004-03-01
10. member assembly unit 110 sends the member that assembles to member performance element 111;
11. Control Engine unit 108 is by control bus 114, the request command that member is carried out sends to member performance element 111;
After 12. member performance element 111 receives order, according to the request mark in the order, the building blocks of function object that provides in the component invoking, and tables of data and Data Date parameter passed to the building blocks of function object, call the execution member;
Finish 13. member performance element 111 is carried out the building blocks of function objects, leave execution result in storage unit 112 as a result, interface bus 115 is obtained the result from storage unit as a result 112 according to request mark, returns the user.In the present embodiment, R6 asks after treatment, promptly inquires the customer information record of respective client sign from table T_CUST_INFO_1.
Embodiment 3
In the present embodiment, the customer information that query requests R7 inquired about promptly is recorded among the T_CUST_INFO_2 for entering database 2007-01-01 day, and its processing procedure is as follows:
1. the user sends services request to system.Request content is as follows;
Component mark Request ID Data Date
F1 R7 2007-01-01
2. interface bus 115 receives user's services request, and request is forwarded to Control Engine unit 108;
3. after the 108 analysis service requests of Control Engine unit, according to the sign of the building blocks of function in the services request and request msg date locating function member and data members in metadata storage unit 109;
1) building blocks of function that in the building blocks of function metadata table of metadata storage unit 109, finds the version of corresponding time period according to the building blocks of function sign (F1) in the request and request msg date (2007-01-01).If the request msg date does not provide, then be defaulted as the current data date;
Component mark The member title The building blocks of function object Current effective marker Effective from date Effective Close Date
F1 Inquiry NewQuery The 1st, 2006-01-01 9999-12-31
2) Control Engine unit 108 is identified at according to the building blocks of function in the request and finds corresponding data members sign in the performance data contingency table of metadata storage unit 109;
The building blocks of function sign The data members sign Effective from date Effective Close Date
F1 C1 2004-01-01 9999-12-31
4. Control Engine unit 108 passes to building blocks of function engine unit 104 with the building blocks of function sign that finds, the building blocks of function engine identifies the building blocks of function of finding out respective version from building blocks of function storage unit 105, i.e. building blocks of function object (NewQuery) according to building blocks of function;
5. building blocks of function engine unit 104 passes through member bus 113 transmission member assembly units 110 with the building blocks of function that finds.Be following form in the present embodiment;
Request The building blocks of function object The data members sign Data Date
R7 NewQuery C1 2007-01-01
6. Control Engine unit 108 passes to data members engine unit 106 with the data members sign that finds, data members engine unit 106 is identified at the data members that finds the version of corresponding time period in the data members metadata table of metadata storage unit 109 according to data members, and Data Identification;
Component mark The member title Connection string Data Identification Current effective marker Effective from date Effective Close Date
C1 Customer information Oracle D2 1 2005-01-01 9999-12-31
7. data members engine unit 106 finds corresponding tables of data according to Data Identification in the data description metadata table of metadata storage unit 109.And together with the information combination of the information and date member of tables of data.The contents are as follows in the present embodiment;
Data members Data Identification Tables of data Data Date
C1 D2 T_CUST_INFO_2 2007-01-01
8. data members engine unit 106 passes through member bus 113 transmission member assembly units 110 with the data members that finds.The contents are as follows in the present embodiment;
Request Data members Data Identification Tables of data Data Date
R7 C1 D2 T_CUST_INFO_2 2007-01-01
9. member assembly unit 110 is assembled together the building blocks of function that receives and data members and forms executable member according to request mark.Be following form in the present embodiment;
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R7 NewQuery C1 D2 T_CUST_INFO_2 2007-01-01
10. member assembly unit 110 sends the member that assembles to member performance element 111;
11. Control Engine unit 108 is by control bus 114, the request command that member is carried out sends to member performance element 111;
After 12. member performance element 111 receives order, according to the request mark in the order, the building blocks of function object that provides in the component invoking, and tables of data and Data Date parameter passed to the building blocks of function object, call the execution member;
Finish 13. member performance element 111 is carried out the building blocks of function objects, leave execution result in storage unit 112 as a result, interface bus 115 is obtained the result from storage unit as a result 112 according to request mark, returns the user.In the present embodiment, R7 asks after treatment, promptly inquires the customer information record of respective client sign from table T_CUST_INFO_2.
In another embodiment of the present invention, need to prove that if do not provide Data Date, R6, R7 query requests can find building blocks of function corresponding to two customer information tables so, promptly obtain following result in resolving:
Request The building blocks of function object Data members Data Identification Tables of data
R6 Query C1 D1 T_CUST_INFO_1
R6 Query C1 D2 T_CUST_INFO_2
R7 NewQuery C1 D1 T_CUST_INFO_1
R7 NewQuery C1 D2 T_CUST_INFO_2
But after the concrete execution of corresponding query requests, obtain following result:
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R6 Query C1 D1 T_CUST_INFO_1 2004-03-01
R7 NewQuery C1 D2 T_CUST_INFO_2 2007-01-01
Request is the customer information record that has found given customer ID in T_CUST_INFO_1 for R6; And the R7 request is the customer information record that has found given customer ID in T_CUST_INFO_2, and is the function presenting information according to NewQuery, is the IsVIP information that the user represents the client that inquires about.
It should be noted that according to above-mentioned operation each location client information will be retrieved many tables, if the customer information table carried out repeatedly change, and data more for a long time, will inevitably bring the recall precision problem.For this reason, in the application of reality, we can create a concordance list, the corresponding relation of storage customer ID and Data Identification, by retrieving this table, can directly in the table of corresponding data sign, retrieve concrete customer information record, thereby improve recall precision according to customer ID.
We can see from top implementation, and the change of data structure does not have any impact to the function of using in the present embodiment, and the expansion of application function also need not to carry out the data operation of dividing a word with a hyphen at the end of a line.Can find point any time very easily by metadata, building blocks of function and the data members that should use, and the corresponding relation between the two.
In another embodiment of the present invention, R2, R3 removal request are promptly according to the user logging in the given customer ID deletion customer information table.Consider for terseness, omitted the necessary customer ID parameter of deletion action herein.Removal request is combining of inquiry positioning action and deletion action in fact, promptly finds earlier corresponding record in database table, deletes then.In the present embodiment also supposition two customer informations to be deleted be respectively 2004-03-01 day and enter database 2007-01-01 day, promptly respectively in T_CUST_INFO_1 and T_CUST_INFO_2.
Embodiment 4
In the present embodiment, the request R2 customer information that will delete promptly is recorded among the T_CUST_INFO_1 for entering database 2004-03-01 day, and its processing procedure is as follows:
1. the user sends services request to system.Request content is as follows;
Component mark Request ID Data Date
F3 R2 2004-03-01
2. interface bus 115 receives user's services request, and request is forwarded to Control Engine unit 108;
3. after the 108 analysis service requests of Control Engine unit, according to the sign of the building blocks of function in the services request and request msg date locating function member and data members in metadata storage unit 109;
1) building blocks of function that in the building blocks of function metadata table of metadata storage unit 109, finds the version of corresponding time period according to the building blocks of function sign (F3) in the request and request msg date (2004-03-01).If the request msg date does not provide, then be defaulted as the current data date;
Component mark The member title The building blocks of function object Current effective marker Effective from date Effective Close Date
F3 Deletion Delete The 1st, 2004-01-01 9999-12-31
2) Control Engine unit 108 is identified at according to the building blocks of function in the request and finds corresponding data members sign in the performance data contingency table of metadata storage unit 109;
The building blocks of function sign The data members sign Effective from date Effective Close Date
F3 C1 2004-01-01 9999-12-31
4. Control Engine unit 108 passes to building blocks of function engine unit 104 with the building blocks of function sign that finds, the building blocks of function engine identifies the building blocks of function of finding out respective version from building blocks of function storage unit 105, i.e. building blocks of function object (Delete) according to building blocks of function;
5. building blocks of function engine unit 104 passes through member bus 113 transmission member assembly units 110 with the building blocks of function that finds.Be following form in the present embodiment;
Request The building blocks of function object The data members sign Data Date
R2 Delete C1 2004-03-01
6. Control Engine unit 108 passes to data members engine unit 106 with the data members sign that finds, data members engine unit 106 is identified at the data members that finds the version of corresponding time period in the data members metadata table of metadata storage unit 109 according to data members, and Data Identification;
Component mark The member title Connection string Data Identification Current effective marker Effective from date Effective Close Date
C1 Customer information Oracle D1 0 2004-01-01 2004-12-31
7. data members engine unit 106 finds corresponding tables of data according to Data Identification in the data description metadata table of metadata storage unit 109.And together with the information combination of the information and date member of tables of data.The contents are as follows in the present embodiment;
Data members Data Identification Tables of data Data Date
C1 D1 T_CUST_INFO_1 2004-03-01
8. data members engine unit 106 passes through member bus 113 transmission member assembly units 110 with the data members that finds.The contents are as follows in the present embodiment;
Request Data members Data Identification Tables of data Data Date
R2 C1 D1 T_CUST_INFO_1 2004-03-01
9. member assembly unit 110 is assembled together the building blocks of function that receives and data members and forms executable member according to request mark.Be following form in the present embodiment;
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R2 Delete C1 D1 T_CUST_INFO_1 2004-03-01
10. member assembly unit 110 sends the member that assembles to member performance element 111;
11. Control Engine unit 108 is by control bus 114, the request command that member is carried out sends to member performance element 111;
After 12. member performance element 111 receives order, according to the request mark in the order, the building blocks of function object that provides in the component invoking, and tables of data and Data Date parameter passed to the building blocks of function object, call the execution member;
Finish 13. member performance element 111 is carried out the building blocks of function objects, leave execution result in storage unit 112 as a result, interface bus 115 is obtained the result from storage unit as a result 112 according to request mark, returns the user.In the present embodiment, R2 asks after treatment, i.e. the customer information record of the given customer ID on deletion corresponding 2004-03-01 date from table T_CUST_INFO_1.
Embodiment 5
In the present embodiment, the request R3 customer information that will delete promptly is recorded among the T_CUST_INFO_2 for entering database 2007-01-01 day, and its processing procedure is as follows:
1. the user sends services request to system.Request content is as follows;
Component mark Request ID Data Date
F3 R3 2007-01-01
2. interface bus 115 receives user's services request, and request is forwarded to Control Engine unit 108;
3. after the 108 analysis service requests of Control Engine unit, according to the sign of the building blocks of function in the services request and request msg date locating function member and data members in metadata storage unit 109;
1) building blocks of function that in the building blocks of function metadata table of metadata storage unit 109, finds the version of corresponding time period according to the building blocks of function sign (F3) in the request and request msg date (2007-01-01).If the request msg date does not provide, then be defaulted as the current data date;
Component mark The member title The building blocks of function object Current effective marker Effective from date Effective Close Date
F3 Deletion Delete The 1st, 2006-01-01 9999-12-31
2) Control Engine unit 108 is identified at according to the building blocks of function in the request and finds corresponding data members sign in the performance data contingency table of metadata storage unit 109;
The building blocks of function sign The data members sign Effective from date Effective Close Date
F3 C1 2004-01-01 9999-12-31
4. Control Engine unit 108 passes to building blocks of function engine unit 104 with the building blocks of function sign that finds, the building blocks of function engine identifies the building blocks of function of finding out respective version from building blocks of function storage unit 105, i.e. building blocks of function object (Delete) according to building blocks of function;
5. building blocks of function engine unit 104 passes through member bus 113 transmission member assembly units 110 with the building blocks of function that finds.Be following form in the present embodiment;
Request The building blocks of function object The data members sign Data Date
R3 Delete C1 2007-01-01
6. Control Engine unit 108 passes to data members engine unit 106 with the data members sign that finds, data members engine unit 106 is identified at the data members that finds the version of corresponding time period in the data members metadata table of metadata storage unit 109 according to data members, and Data Identification;
Component mark The member title Connection string Data Identification Current effective marker Effective from date Effective Close Date
C1 Customer information Oracle D2 1 2005-01-01 9999-12-31
7. data members engine unit 106 finds corresponding tables of data according to Data Identification in the data description metadata table of metadata storage unit 109.And together with the information combination of the information and date member of tables of data.The contents are as follows in the present embodiment;
Data members Data Identification Tables of data Data Date
C1 D2 T_CUST_INFO_2 2007-01-01
8. data members engine unit 106 passes through member bus 113 transmission member assembly units 110 with the data members that finds.The contents are as follows in the present embodiment;
Request Data members Data Identification Tables of data Data Date
R3 C1 D2 T_CUST_INFO_2 2007-01-01
9. member assembly unit 110 is assembled together the building blocks of function that receives and data members and forms executable member according to request mark.Be following form in the present embodiment;
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R3 Delete C1 D2 T_CUST_INFO_2 2007-01-01
10. member assembly unit 110 sends the member that assembles to member performance element 111;
11. Control Engine unit 108 is by control bus 114, the request command that member is carried out sends to member performance element 111;
After 12. member performance element 111 receives order, according to the request mark in the order, the building blocks of function object that provides in the component invoking, and tables of data and Data Date parameter passed to the building blocks of function object, call the execution member;
Finish 13. member performance element 111 is carried out the building blocks of function objects, leave execution result in storage unit 112 as a result, interface bus 115 is obtained the result from storage unit as a result 112 according to request mark, returns the user.In the present embodiment, R3 asks after treatment, i.e. the customer information record of the given customer ID on deletion corresponding 2004-03-01 date from table T_CUST_INFO_2.
In another embodiment of the present invention, R4, R5 revise request promptly according to the user logging in the given customer ID modification customer information table.Consider that for terseness this places oneself to have omited and revises the necessary customer ID parameter of action.The request revised is the inquiry positioning action and the combining of retouching operation in fact, promptly finds earlier corresponding record in database table, modification then, and amended record write back.We suppose that also two customer informations to be revised are respectively 2004-03-01 day and enter database 2007-01-01 day in the present embodiment, promptly respectively in T_CUST_INFO_1 and T_CUST_INFO_2.
Need to prove that the retouching operation of customer information is from normally this client's information change of business demand.Therefore, if the user is when revising the customer information record of 2004-03-01 warehouse-in, might require to import " whether VIP " element information of this client, so in this programme, building blocks of function Modify can be by the function of dividing a word with a hyphen at the end of a line in real time of data, corresponding customer information is recorded as failure state among the real-time modification T_CUST_INFO_1, and amended customer information record is newly-increased to T_CUST_INFO_2, also just transfers in the new table for the operation of this customer information record from now on.This real-time dividing a word with a hyphen at the end of a line avoided batch data to divide a word with a hyphen at the end of a line being brought stops extensive works such as service, coding.
Embodiment 6
In the present embodiment, the request R4 customer information that will delete promptly is recorded among the T_CUST_INFO_1 for entering database 2004-03-01 day, and its processing procedure is as follows:
1. the user sends services request to system.Request content is as follows;
Component mark Request ID Data Date
F4 R4 2004-03-01
2. interface bus 115 receives user's services request, and request is forwarded to Control Engine unit 108;
3. after the 108 analysis service requests of Control Engine unit, according to the sign of the building blocks of function in the services request and request msg date locating function member and data members in metadata storage unit 109;
1) building blocks of function that in the building blocks of function metadata table of metadata storage unit 109, finds the version of corresponding time period according to the building blocks of function sign (F4) in the request and request msg date (2004-03-01).If the request msg date does not provide, then be defaulted as the current data date;
Component mark The member title The building blocks of function object Current effective marker Effective from date Effective Close Date
F4 Revise Modify The 1st, 2004-01-01 9999-12-31
2) Control Engine unit 108 is identified at according to the building blocks of function in the request and finds corresponding data members sign in the performance data contingency table of metadata storage unit 109;
The building blocks of function sign The data members sign Effective from date Effective Close Date
F4 C1 2004-01-01 9999-12-31
4. Control Engine unit 108 passes to building blocks of function engine unit 104 with the building blocks of function sign that finds, the building blocks of function engine identifies the building blocks of function of finding out respective version from building blocks of function storage unit 105, i.e. building blocks of function object (Modify) according to building blocks of function;
5. building blocks of function engine unit 104 passes through member bus 113 transmission member assembly units 110 with the building blocks of function that finds.Be following form in the present embodiment;
Request The building blocks of function object The data members sign Data Date
R4 Modify C1 2004-03-01
6. Control Engine unit 108 passes to data members engine unit 106 with the data members sign that finds, data members engine unit 106 is identified at the data members that finds the version of corresponding time period in the data members metadata table of metadata storage unit 109 according to data members, and Data Identification;
Component mark The member title Connection string Data Identification Current effective marker Effective from date Effective Close Date
C1 Customer information Oracle D1 0 2004-01-01 2004-12-31
7. data members engine unit 106 finds corresponding tables of data according to Data Identification in the data description metadata table of metadata storage unit 109.And together with the information combination of the information and date member of tables of data.The contents are as follows in the present embodiment;
Data members Data Identification Tables of data Data Date
C1 D1 T_CUST_INFO_1 2004-03-01
8. data members engine unit 106 passes through member bus 113 transmission member assembly units 110 with the data members that finds.The contents are as follows in the present embodiment;
Request Data members Data Identification Tables of data Data Date
R4 C1 D1 T_CUST_INFO_1 2004-03-01
9. member assembly unit 110 is assembled together the building blocks of function that receives and data members and forms executable member according to request mark.Be following form in the present embodiment;
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R4 Modify C1 D1 T_CUST_INFO_1 2004-03-01
10. member assembly unit 110 sends the member that assembles to member performance element 111;
11. Control Engine unit 108 is by control bus 114, the request command that member is carried out sends to member performance element 111;
After 12. member performance element 111 receives order, according to the request mark in the order, the building blocks of function object that provides in the component invoking, and tables of data and Data Date parameter passed to the building blocks of function object, call the execution member;
Finish 13. member performance element 111 is carried out the building blocks of function objects, leave execution result in storage unit 112 as a result, interface bus 115 is obtained the result from storage unit as a result 112 according to request mark, returns the user.In the present embodiment, R4 asks after treatment, will show a user logging on the 2004-03-01 date in the T_CUST_INFO_1 table, and provides the user to make amendment;
14. after user's modification finishes, submit to and revise.After system's component part 115 interface buss receive request, be transmitted to above-mentioned member, user logging is modified to the T_CUST_INFO_1 table;
15. if the user is when revising the customer information record of 2004-03-01 warehouse-in, might require to import " whether VIP " element information of this client, so in this programme, building blocks of function Modify can find the up-to-date tables of data T_CUST_INFO_2 of this data members correspondence according to the mapping relations of data dictionary and field, amended customer information record is newly-increased to T_CUST_INFO_2, and revise that corresponding customer information is recorded as failure state among the T_CUST_INFO_1, and the finish correlation table synchronously Data Update work of (as the mapping table of customer ID and Data Identification).And the return result gives system's component part 115 interface buss;
16. system's component part 115 interface buss return to the user with operating result.
Embodiment 7
In the present embodiment, the request R5 customer information that will delete promptly is recorded among the T_CUST_INFO_2 for entering database 2007-01-01 day, and its processing procedure is as follows:
1. the user sends services request to system.Request content is as follows;
Component mark Request ID Data Date
F4 R5 2007-01-01
2. interface bus 115 receives user's services request, and request is forwarded to Control Engine unit 108;
3. after the 108 analysis service requests of Control Engine unit, according to the sign of the building blocks of function in the services request and request msg date locating function member and data members in metadata storage unit 109;
1) building blocks of function that in the building blocks of function metadata table of metadata storage unit 109, finds the version of corresponding time period according to the building blocks of function sign (F4) in the request and request msg date (2007-01-01).If the request msg date does not provide, then be defaulted as the current data date;
Component mark The member title The building blocks of function object Current effective marker Effective from date Effective Close Date
F4 Revise Modify The 1st, 2006-01-01 9999-12-31
2) Control Engine unit 108 is identified at according to the building blocks of function in the request and finds corresponding data members sign in the performance data contingency table of metadata storage unit 109;
The building blocks of function sign The data members sign Effective from date Effective Close Date
F4 C1 2004-01-01 9999-12-31
4. Control Engine unit 108 passes to building blocks of function engine unit 104 with the building blocks of function sign that finds, the building blocks of function engine identifies the building blocks of function of finding out respective version from building blocks of function storage unit 105, i.e. building blocks of function object (Modify) according to building blocks of function;
5. building blocks of function engine unit 104 passes through member bus 113 transmission member assembly units 110 with the building blocks of function that finds.Be following form in the present embodiment;
Request The building blocks of function object The data members sign Data Date
R5 Modify C1 2007-01-01
6. Control Engine unit 108 passes to data members engine unit 106 with the data members sign that finds, data members engine unit 106 is identified at the data members that finds the version of corresponding time period in the data members metadata table of metadata storage unit 109 according to data members, and Data Identification;
Component mark The member title Connection string Data Identification Current effective marker Effective from date Effective Close Date
C1 Customer information Oracle D2 1 2005-01-01 9999-12-31
7. data members engine unit 106 finds corresponding tables of data according to Data Identification in the data description metadata table of metadata storage unit 109.And together with the information combination of the information and date member of tables of data.The contents are as follows in the present embodiment;
Data members Data Identification Tables of data Data Date
C1 D2 T_CUST_INFO_2 2007-01-01
8. data members engine unit 106 passes through member bus 113 transmission member assembly units 110 with the data members that finds.The contents are as follows in the present embodiment;
Request Data members Data Identification Tables of data Data Date
R5 C1 D2 T_CUST_INFO_2 2007-01-01
9. member assembly unit 110 is assembled together the building blocks of function that receives and data members and forms executable member according to request mark.Be following form in the present embodiment;
Request The building blocks of function object Data members Data Identification Tables of data Data Date
R5 Modify C1 D2 T_CUST_INFO_2 2007-01-01
10. member assembly unit 110 sends the member that assembles to member performance element 111;
11. Control Engine unit 108 is by control bus 114, the request command that member is carried out sends to member performance element 111;
After 12. member performance element 111 receives order, according to the request mark in the order, the building blocks of function object that provides in the component invoking, and tables of data and Data Date parameter passed to the building blocks of function object, call the execution member;
Finish 13. member performance element 111 is carried out the building blocks of function objects, leave execution result in storage unit 112 as a result, interface bus 115 is obtained the result from storage unit as a result 112 according to request mark, returns the user.In the present embodiment, request R5 will show a user logging on the 2007-01-01 date in the T_CUST_INFO_2 table, and provides the user to make amendment after treatment.
14. after user's modification finishes, submit to and revise.After system's component part 115 interface buss receive request, be transmitted to above-mentioned member, user logging is modified to the T_CUST_INFO_2 table, return result gives system's component part 115 interface buss;
System's component part 115 interface buss return to the user with operating result.
Above embodiments of the invention 1-7 has itemized the embodiment of a customer information maintenance application, it should be explicitly made clear at this point, present embodiment is for the present invention is described, and be not in order to limit the present invention, any this area has the present invention can being applied in other management systems per capita of general knowledge and goes, as financial management system, commodity management system, Human Resources Management System or the like.
Compared with prior art, advantage of the present invention is:
1) the present invention's innovation does the function services of application and the historical data of enterprise as a whole, carrying out association with time dimension integrates, by function services and the relation between the data environment used are effectively managed, are controlled, in unified operation supporting framework, preserve the whole evolution history of service function member and data members, realized the function of the Auto-matching of function services and data environment, thus the problem how variation that has solved historical data adapts with the application function transition. Really accomplish the application system of enterprise, be not subjected to the constraint of time, version, according to service needed, be convenient to use, really realized flexible and reliable professional agility;
2) system is by the Auto-matching of data and member version, easy, effectively realized data and the unified management of member version, and then solved new application function and how adapt and the problem of coordinating with old application function, reduced the time of test, reduced testing cost. System need not to be engaged in upgrading application by shutting down, withdrawing again, the data of dividing a word with a hyphen at the end of a line, and has effectively improved the availability of system, has reduced test and operation maintenance cycle and the cost of enterprise;
3) the present invention adopts the componentization mode, and member is carried out application reconstruct, component reusage with concrete no longer direct correlation of running environment, the system of being convenient to, and has improved the planning efficiency of system. So that enterprise can tackle the new business demand fast, in time carry out business innovation;
4) degree of coupling of attenuating data and building blocks of function, desalinated the design of what's new to the original function compatibility, reduced the complexity of system, so that the designer can be absorbed in modelling and the realization of current appellative function, thereby simplified the design work amount, improved design work efficient;
5) making enterprise's historical data conveniently to use becomes possibility, has improved the service efficiency of data, has effectively protected the investment of enterprise.

Claims (11)

1. building blocks of function and data relating operation method, described method comprises:
Mapping relations between building blocks of function sign and the data members sign are stored in first contingency table;
Building blocks of function sign, building blocks of function object and the mapping relations between the building blocks of function object version date are stored in second contingency table;
Mapping relations between data members sign, Data Identification and the Data Date are stored in the 3rd contingency table;
Mapping relations between Data Identification and the data name are stored in the 4th contingency table;
Wherein, described method is carried out following steps:
Reception comprises the data service request of building blocks of function sign, request mark and Data Date;
In second contingency table, find the corresponding building blocks of function object version date according to described Data Date, obtain corresponding building blocks of function object according to the building blocks of function sign again;
Be identified at the data members sign of obtaining correspondence in first contingency table according to described building blocks of function;
Be identified at the Data Identification that obtains correspondence in the 3rd contingency table according to described Data Date and the data members of obtaining;
In the 4th contingency table, obtain corresponding data name according to the Data Identification that obtains, obtain corresponding tables of data according to data name again;
The tables of data obtained is combined to form according to described request mark with the building blocks of function object that obtains carries out member;
Carry out the described member of carrying out, return the requested service data.
2. building blocks of function according to claim 1 and data relating operation method is characterized in that, receive the data service request that comprises building blocks of function sign, request mark and Data Date that external user transmits by data bus.
3. building blocks of function according to claim 1 and data relating operation method is characterized in that, with described data table stores in the operation data warehouse of outside, and with described building blocks of function object storage in the building blocks of function storage unit.
4. building blocks of function according to claim 1 and data relating operation method is characterized in that, described building blocks of function object comprises: add building blocks of function, modify feature member, delete function member and query function member.
5. building blocks of function according to claim 1 and data relating operation method is characterized in that, the described requested service data of returning comprise:
The execution result that can carry out member is stored in the outcome pool, and by data bus described execution result is fed back to external user.
6. building blocks of function and data relating operation system is characterized in that described system comprises:
The contingency table storage unit, be used for the mapping relations between memory function component mark and the data members sign, building blocks of function sign, building blocks of function title, building blocks of function object and the mapping relations between the building blocks of function object version date, mapping relations between data members sign, data members title, Data Identification and the Data Date, the mapping relations between Data Identification and the data name;
The request of data receiving element is used to receive the data service request that comprises building blocks of function sign, request mark and Data Date;
Building blocks of function object acquisition unit is used for finding the corresponding building blocks of function object version date according to described Data Date in the contingency table storage unit, obtains corresponding building blocks of function object according to the sign of the building blocks of function in the data service request again;
Data members sign acquiring unit is used for being identified at the contingency table storage unit according to described building blocks of function and obtains corresponding data members sign;
The Data Identification acquiring unit is used for being identified at the contingency table storage unit according to described Data Date and the data members of obtaining and obtains corresponding Data Identification;
The tables of data acquiring unit is used for obtaining corresponding data name according to the Data Identification that obtains in the contingency table storage unit, obtains corresponding tables of data according to data name again;
Can carry out the member generation unit, be used for the tables of data that to obtain and the building blocks of function object that obtains and be combined to form according to described request mark and can carry out member;
The service data output unit is used to carry out the described member of carrying out, and returns the requested service data.
7. building blocks of function according to claim 6 and data relating operation system is characterized in that, described contingency table storage unit comprises:
First contingency table is used for the mapping relations between memory function component mark and the data members sign;
Second contingency table is used for memory function component mark, building blocks of function title, building blocks of function object and the mapping relations between the building blocks of function object version date;
The 3rd contingency table is used to store the mapping relations between data members sign, data members title, Data Identification and the Data Date;
The 4th contingency table is used to store the mapping relations between Data Identification and the data name.
8. building blocks of function according to claim 6 and data relating operation system, it is characterized in that, described system also comprises: the external user terminal, this external user terminal is accepted the unit by data bus and described request of data and is carried out communication, is used to import the data service request that comprises building blocks of function sign, request mark and Data Date.
9. building blocks of function according to claim 6 and data relating operation system is characterized in that, described system also comprises:
The operation data warehouse is used to store described tables of data;
The building blocks of function storage unit is used for the memory function component object.
10. building blocks of function according to claim 6 and data relating operation system is characterized in that, described building blocks of function object comprises: add building blocks of function, modify feature member, delete function member and query function member.
11. building blocks of function according to claim 8 and data relating operation system is characterized in that, described system also comprises: the execution result storage unit is used to store the described execution result of carrying out member; Wherein,
Described service data output unit obtains described execution result from described execution result storage unit, and described execution result is fed back to described external user terminal by data bus.
CNB2007101777722A 2007-11-21 2007-11-21 Functional component and data relating operation method and system Active CN100483421C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNB2007101777722A CN100483421C (en) 2007-11-21 2007-11-21 Functional component and data relating operation method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNB2007101777722A CN100483421C (en) 2007-11-21 2007-11-21 Functional component and data relating operation method and system

Publications (2)

Publication Number Publication Date
CN101158968A CN101158968A (en) 2008-04-09
CN100483421C true CN100483421C (en) 2009-04-29

Family

ID=39307070

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2007101777722A Active CN100483421C (en) 2007-11-21 2007-11-21 Functional component and data relating operation method and system

Country Status (1)

Country Link
CN (1) CN100483421C (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103226514B (en) * 2013-04-28 2016-05-18 中国工商银行股份有限公司 A kind of method for testing software of quick change case and device
CN103713899A (en) * 2013-12-19 2014-04-09 珠海世纪鼎利通信科技股份有限公司 Object-oriented object relation achieving method and system based on messages

Also Published As

Publication number Publication date
CN101158968A (en) 2008-04-09

Similar Documents

Publication Publication Date Title
CN110337642A (en) The method and apparatus of test are executed by using test case
US20090210857A1 (en) Automated merging in a software development environment
CN102841889A (en) Method and device for achieving efficient database access based on ORM (object relational mapping) architecture
US8626703B2 (en) Enterprise resource planning (ERP) system change data capture
US20050165817A1 (en) Data migration and analysis
KR20060045622A (en) Extraction, transformation and loading designer module of a computerized financial system
CN103460208A (en) Methods and systems for loading data into a temporal data warehouse
CN104133772A (en) Automatic test data generation method
EP2110781A1 (en) Method and system for automatic tracing of a computerized process using a relationship model
CN103593174A (en) Adaptable business object
WO2016118940A1 (en) Systems and methods for automatically generating application software
WO2006026659A2 (en) Services oriented architecture for data integration services
US7865461B1 (en) System and method for cleansing enterprise data
CN105224527A (en) Be applicable to the general ETL method of multiple object table update mode
CN104517181A (en) Enterprise content management system and enterprise content management method for nuclear power plants
CN114281342A (en) Automatic code generation method
KR20220127443A (en) Data architecture management system
CN100483421C (en) Functional component and data relating operation method and system
CN105550351B (en) The extemporaneous inquiry system of passenger's run-length data and method
EP2343658A1 (en) Federation as a process
CN101339506A (en) Device for implementing software products resource and version management
Alonso et al. Towards a platform for distributed application development
CN115713309A (en) Internal auditing system
González et al. Message Structures: a Modelling Technique for Information Systems Analysis and Design.
CN101419611A (en) Method for performing an operation on an XML database

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