CN1687927A - Method for implementing automatic exchange of information system data - Google Patents
Method for implementing automatic exchange of information system data Download PDFInfo
- Publication number
- CN1687927A CN1687927A CN 200510049748 CN200510049748A CN1687927A CN 1687927 A CN1687927 A CN 1687927A CN 200510049748 CN200510049748 CN 200510049748 CN 200510049748 A CN200510049748 A CN 200510049748A CN 1687927 A CN1687927 A CN 1687927A
- Authority
- CN
- China
- Prior art keywords
- data
- function
- character string
- character
- xml
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Abstract
The invention provides a method for implementing the automatic data exchange of an information system, on the basis of analyzing relation data model and XML model, building their mapping model, defining basic mapping functions, and building a library of mapping functions; on the basis of analyzing relation database schema and data exchange demand, according to the XML model, defining XML schema, and according to the mapping model, determining the mapping relation between relation data schema and XML schema, selecting the basic mapping function from the library of mapping functions to build mapping schemata. As some event occurs or a certain time arrives, a flip-flop triggers a data exchange engine, which firstly reads the tasks and attribute of the flip-flop, then according to them, reads the corresponding mapping schema and finally executes specific data exchange to convert source data to target data so as to implement data exchange.
Description
Technical field
The present invention relates to a kind of data of information system method of exchange automatically that realizes, adopt the intermediary of XML as message exchange, internet/intranet realizes the integrated of infosystem as the information channel of exchanges data.
Background technology
Existing Data Interchange Technology mainly is the exchange at the signal data of communication aspects, and at the exchanges data between the database of infosystem seldom, and it need realize swap data between the infosystem by hardware units such as interface circuit, interface buss mostly.Different infosystems is towards different business demands, so the pattern of the relational database that infosystem had is also different, causes the versatility of exchanges data between the infosystem to be difficult to guarantee like this.People's invention DEU data exchange unit was once arranged, built-in with the station in the two-way interface that is connected of database, with the two-way interface bus that is connected of this interface, the two-way line control circuit that is connected of also built-in and remote link, formation control circuit, the formation bus that have.This kind method has been used hardware unit, and is therefore with high costs, and needs safeguarding of personnel, the waste labour.The somebody adopts the mode of webpage, Information Monitoring from the page, convert extend markup language (XML) document to, and set up linking relationship one to one between the implicit data, this kind mode is that browsing of business datum shared and to be provided convenience, but the data of gathering are not converted to the data of the relational data model of infosystem, can not directly be utilized by infosystem and handle, can't satisfy the needs of management service, and need manually-operated, can't control automatically.
Summary of the invention
The purpose of this invention is to provide a kind of data of information system method of exchange automatically that realizes,, and adopt software mode with low cost, easy to use, realize the integrated of infosystem not by interface circuit and interface bus.
The technical scheme that the present invention solves its technical matters employing is:
1) according to relational data model and XML model, create the mapping mechanism between relational data model and the XML model, the mapping model between opening relationships data model and the XML model, this mapping model comprise the mapping function storehouse of realizing mapping relations between the data;
2) according to relational data model and XML model, set up the XML pattern, i.e. XML Schema;
3) according to relational data base schema and XML pattern, from the mapping function storehouse of mapping model, choose basic mapping function, be combined into the mapping function vector F (X) that adapts to the exchange of specifying information system data, the mapped mode between opening relationships data pattern and the XML pattern;
4) set up and being connected of relational database;
5) trigger trigger data switching engine carries out exchanges data, if adopt automatic control mode, then need set in advance trigger mechanism and the task and the attribute of trigger; Automatically the workflow of control data exchange is: 1. when a certain incident or a certain moment arrival, trigger trigger data switching engine, 2. the exchanges data engine reads triggering task and attribute, and read corresponding mapped mode according to this, 3. the exchanges data engine is carried out exchanges data work, and this step work is carried out different workflows according to the difference of task type; The exchanges data task is divided into two types: receive and issue; When task when receiving data, it is carried out flow process and is: 1. linking objective database, read in the XML file of shared region), 2. the data with the XML file convert target data model to according to mapped mode, 3. data are write target database; When work is distributing data, its workflow is: 1. according to task and attribute, connect source database, read in the data filter condition, data are carried out query filter, read the data that to issue, 2. according to mapped mode, data-switching is become the data mode of XML mode-definition, 3. data are published to shared region with the form of XML file, 4. revise the data filter condition.
The data of XML pattern are as the intermediary of exchanges data, and internet/intranet is as the passage of exchanges data.
Described mapping function storehouse comprises: mathematical function, character string function, transfer function, database functions, and its effect is that source data is converted into target data; Mathematical function realizes that character string function is realized character string is operated to the operation that performs mathematical calculations of data element, and transfer function is realized the conversion between the different types of data, and the database functions realization is operated the data database data; Wherein:
(1) mathematical function:
Arithmetic operator have add+, subtract-, take advantage of *, remove ÷;
MOD (A, B), calculate with the A operand divided by the B operand after the remainder of gained;
ABS (A), ABS function returns the absolute value of the numerical value of appointment;
SIGN (A), when A returns-1 less than 0 the time, A returned 0 at 0 o'clock, and A returned 1 greater than 0 o'clock;
(2) character string function:
CHR (A) function declaration: the numerical value of CHR function return character equals the character of A, the numerical value of A for setting;
(A, B) function declaration: the CONCAT function couples together A and two character strings of B to CONCAT, and A, B represent 2 character strings;
LPAD (A, B, C) function declaration: fill character in the character string left side, and A is operated character string, and B is total number of the character that will fill, and C is that optionally it is the character that will fill;
RPAD (A, B, C) function declaration: fill character in character string the right, A is operated character string, and B is total number of the character that will fill, and C is that optionally it is the character that will fill;
(A, B) function declaration: relevant character is clipped on the character string left side to LTRIM, and A is operated character string, and B is both can be character, also can be character string or default;
(A, B) function declaration: relevant character is clipped on character string the right to RTRIM, and A is operated character string, and B is both can be character, also can be character string or default;
SUBSTR (A, B, C) function declaration: taking out a substring .A from target string is target string, and B is the position of first character in target strings of the substring that is output, and C is the number of characters of the substring that is output;
REPLACE (A, B, C) function declaration: the character string that A is searched in the replacement function, B is the key for searching in the character string, C is optionally, is the substitute character string;
(3) transfer function:
TO_CHAR (A) function declaration: the TO_CHAR function converts data of different types to character string type, and A is for being converted any type of data;
TO_NUMBER (A) function declaration: the TO_NUMBER function converts character string to a numerical value, and A is the character string that is converted;
TO_DATE (A) function declaration: the TO_DATE function changes into the date type with character string, and A is the character string that is converted;
ADD_FIELD (A, B) function declaration: according to the rule of fields default, replenish data element, the data element of A for replenishing, B is selectable rule;
(4) database functions:
CREATE_VIEW function declaration: be stored in situation in the different pieces of information table for data element,, be combined into view, choose required data element according to incidence relation;
SUM (A) function declaration: the SUM function returns all numerical value sums in the row, and A is the title of row;
AVG (A) function declaration: the mean value of AVG function calculation one row, A is the title of row;
SYSDATE function declaration: the time on date of retrieval system;
Described trigger, adopt Event triggered and two kinds of trigger mechanisms of Time Triggered, event trigger trigger data switching engine is according to triggering task and attribute order execution work flow process, Time Triggered device trigger data switching engine, every through after the period of time T of setting, restart the exchanges data engine, workflow enters next circulation, the data that periodic exchange of newly-added adds.
The useful effect that the present invention has is: guarantee the data consistency between the different information systems, information is in time shared and feedback, avoid information to repeat input, with the generation mass of redundancy data, automatically control data exchange, reduce the labour, realized the integrated of infosystem, helped the integrated of business event management.
Description of drawings
Fig. 1 is the schematic diagram of exchanges data;
Fig. 2 is the structural framing figure of exchanges data;
Fig. 3 is complete exchanges data automatic control flow chart figure;
Fig. 4 is the derivation mapping graph of distributing data;
Fig. 5 is for receiving the importing mapping graph of data;
Fig. 6 is the merging and partition synoptic diagram in the mapping model;
Fig. 7 is complete system works flow process figure.
Embodiment
The invention will be further described below in conjunction with drawings and Examples.
As shown in Figure 1, a kind of method that realizes that data of information system exchanges automatically may further comprise the steps:
1) according to relational data model 100 and XML model 105, create the mapping mechanism between relational data model 100 and the XML model 105, mapping model 115 between opening relationships data model 100 and the XML model 105, this mapping model 115 comprise the mapping function storehouse of realizing mapping relations between the data: mathematical function, character string function, transfer function, database functions;
Mathematical function realizes that character string function is realized character string is operated to the operation that performs mathematical calculations of data element, and transfer function is realized the conversion between the different types of data, and the database functions realization is operated the data database data;
(1) mathematical function:
Arithmetic operator have add+, subtract-, take advantage of *, remove ÷;
MOD (A, B), calculate with the A operand divided by the B operand after the remainder of gained;
ABS (A), ABS function returns the absolute value of the numerical value of appointment;
SIGN (A), when A returns-1 less than 0 the time, A returned 0 at 0 o'clock, and A returned 1 greater than 0 o'clock;
(2) character string function:
CHR (A) function declaration: the numerical value of CHR function return character equals the character of A, the numerical value of A for setting;
(A, B) function declaration: the CONCAT function couples together A and two character strings of B to CONCAT, and A, B represent 2 character strings;
LPAD (A, B, C) function declaration: fill character in the character string left side, and A is operated character string, and B is total number of the character that will fill, and C is that optionally it is the character that will fill;
RPAD (A, B, C) function declaration: fill character in character string the right, A is operated character string, and B is total number of the character that will fill, and C is that optionally it is the character that will fill;
(A, B) function declaration: relevant character is clipped on the character string left side to LTRIM, and A is operated character string, and B is both can be character, also can be character string or default;
(A, B) function declaration: relevant character is clipped on character string the right to RTRIM, and A is operated character string, and B is both can be character, also can be character string or default;
SUBSTR (A, B, C) function declaration: taking out a substring .A from target string is target string, and B is the position of first character in target strings of the substring that is output, and C is the number of characters of the substring that is output;
REPLACE (A, B, C) function declaration: the character string that A is searched in the replacement function, B is the key for searching in the character string, C is optionally, is the substitute character string;
(3) transfer function:
TO_CHAR (A) function declaration: the TO_CHAR function converts data of different types to character string type, and A is for being converted any type of data;
TO_NUMBER (A) function declaration: the TO_NUMBER function converts character string to a numerical value, and A is the character string that is converted;
TO_DATE (A) function declaration: the TO_DATE function changes into the date type with character string, and A is the character string that is converted;
ADD_FIELD (A, B) function declaration: according to the rule of fields default, replenish data element, the data element of A for replenishing, B is selectable rule;
(4) database functions:
CREATE_VIEW () function declaration: be stored in situation in the different pieces of information table for data element,, be combined into view, choose required data element according to incidence relation;
SUM (A) function declaration: the SUM function returns all numerical value sums in the row, and A is the title of row;
AVG (A) function declaration: the mean value of AVG function calculation one row, A is the title of row;
SYSDATE () function declaration: the time on date of retrieval system;
2) according to relational data model 110 and XML model 105, set up XML pattern 120, i.e. XMLSchema;
3) according to relational data base schema 110 and XML pattern 120, from the mapping function storehouse of mapping model 115, choose basic mapping function, be combined into the mapping function vector F (X) that adapts to the exchange of specifying information system data, the mapped mode 140 between opening relationships data pattern 110 and the XML pattern 120;
4) set up and being connected of relational database 125;
5) trigger 145 trigger data switching engines 130 carry out exchanges data, if adopt automatic control mode, then need set in advance trigger mechanism and the task and the attribute of trigger 145; Automatically the workflow of control data exchange is: 1. when a certain incident or a certain moment arrival, trigger 145 trigger data switching engines 130,2. exchanges data engine 130 reads triggering task and attribute, and read corresponding mapped mode 140 according to this, 3. exchanges data engine 130 is carried out exchanges data work, and this step work is carried out different workflows according to the difference of task type; The exchanges data task is divided into two types: receive and issue; When task when receiving data, it is carried out flow process and is: 1. linking objective database, read in the XML file of shared region, 2. the data with XML file 135 convert target data model to according to mapped mode 140,3. data are write target database; When work is distributing data, its workflow is: 1. according to task attribute, connect source database, read in the data filter condition, data are carried out query filter, read the data that to issue, 2. according to mapped mode 140, data-switching is become the data mode of XML pattern 120 definition, 3. data are published to shared region with the form of XML file 135,4. revise the data filter condition.
The concrete implication of each module shown in Fig. 1 is as follows:
100: relational data model, i.e. R={r1, r2 ..., r3}, the data model that infosystem generally adopts;
105:XML model, i.e. the international standard standard of XML;
115: mapping model, the mapping relations of expression between 110 and 105, as one to one, one-to-many, many-one etc., and comprise basic mapping function;
110: relational data model, promptly 110 example comprises the pattern of the source database that need carry out exchanges data and the pattern of target database;
The 120:XML pattern, i.e. 105 example comprises title, structure, element, data type, the attribute of XML;
140: mapped mode, i.e. 115 example comprises the detailed corresponding relation of table, view and the XML Schema that need carry out the relational database of exchanges data;
125: relational database comprises table, the view that need carry out relational database;
The 135:XML file, the data file of the pattern of storing X ML Schema definition;
130: the exchanges data engine, be responsible for the execution of exchanges data work;
145: trigger, be divided into event trigger and Time Triggered device, when a certain incident takes place or a certain moment when arriving, trigger 130 startup;
Relational model of database 100 among Fig. 1 is the general data model of infosystem, the international standard of the online swap data that XML model 105 is organized to set up for W3C, relational data base schema 110 is for carrying out the concrete relational model of database of exchanges data, more than 3 modules exist, have only to its analyze clear after, could create general mapping model 115, and according to relational data model 110 and XML pattern 120, from mapping model, choose basic mapping function, make up mapped mode 140.XML pattern 120 is for being the concrete XML model 105 of XML data with the relational database data conversion, be used for describing and retraining the XML file of storage data, adopt XML Schema definition XML pattern 120,, create XML Schema according to the pattern of relational database 125 and the data of needs exchange.Relational database is table or the view that needs swap data.The exchanges data engine is carried out the data switching task, comprises that the data with relational database 125 are converted to XML data and the data that the XML data are converted to relational database 125.Data trigger adopts Event triggered and two kinds of trigger mechanisms of Time Triggered, and the control data switching engine automatically performs the exchanges data workflow.
Structural framing figure such as Fig. 2 of exchanges data, it remarks additionally to schematic diagram Fig. 1: the database i among Fig. 2 (i from 1 to n) is 125 Fig. 1, the infosystem that database is respectively separately owns, each relational database both can be used as the source database distributing data, also can be used as target database and received data; XML file among Fig. 2 is 135 among Fig. 1, and it is kept at the shared region of setting; Exchanges data engine among Fig. 2, XML Schema, trigger are respectively 130 among Fig. 1,120,145; Internet/intranet is as the passage of exchanges data, and the XML file in exchanges data engine and database, the shared region is coupled together, and issues and accept data; Exchanges data engine among Fig. 2 carries out query filter by the reading of data filtercondition to the data in the source database, the data derivation of needs exchange is issued, and the data filtercondition is on-the-fly modified.Because the data of infosystem in continuous increase, so need periodically carry out exchanges data, are issued the data that increase newly and receive.Therefore, derive distributing data at every turn after, the data filter condition need be made amendment, the data filter that has exchanged can be fallen when guaranteeing to carry out query filter before the next derived data.Trigger trigger data switching engine is carried out the data filter condition of revising.The exchanges data engine connects source database by internet/intranet, and derived data is published to shared region.The pattern of XMLSchema definition XML is described and retrains the structure of XML document, element (mark), data type, attribute etc.The data that derive by the exchanges data engine generate the XML data of XML pattern, and are published to shared region.By the exchanges data engine,, read in the XML data of shared region again, import to target database by the information channel of internet/intranet exchanges data.Defined the basic triggering function of Time Triggered and two kinds of trigger mechanisms of Event triggered in the trigger, the exchanges data engine calling triggers function, and it is according to triggering task that configures and attribute fill order.Automatically the workflow of control data exchange is: 1. when a certain incident or a certain moment arrival, trigger trigger data switching engine, 2. exchanges data causes and reads triggering task and attribute, and read corresponding mapped mode according to this, 3. the exchanges data engine is carried out its task of triggering, and this step work is carried out different workflows according to the difference of task type; Data translation tasks is divided into two types: receive and issue.When task when receiving data, it is carried out flow process and is: 1. linking objective database, read in the XML data of shared region, 2. convert the XML data to target data model according to mapped mode 140,3. data are write target database; When work is distributing data, its workflow is: 1. according to task attribute, connect source database, read in the data filter condition, data are carried out query filter, read the data that to issue, 2. according to mapped mode, data-switching is become the data of XML pattern, 3. data are published to shared region with the form of XML file, 4. revise the data filter condition.The automatic sequence of respectively moving in the event trigger trigger data exchange process is carried out, and after last psychomotor task is finished, starts back one psychomotor task.For fear of the data that exchange repeats, the periodic trigger data switching engine work of Time Triggered device, and change the data filter condition, as the query filter condition of next round-robin exchanges data.The dynamic change of data filter condition, its Changing Pattern is controlled by trigger.
As Fig. 3 is complete exchanges data automatic control flow chart figure, and the data issue is combined into a complete data exchange process with two kinds of task types of Data Receiving, carries out periodic exchanges data automatically, by trigger control implementation.At first by the internet/intranet information channel, connect source database, the reading of data filtercondition, data are carried out query filter, filtered data is gathered, pattern according to XML Schema definition, generate the XML file, preserve and be published to shared region, again the data filtercondition is made amendment, guarantee that the data filter of inciting somebody to action exchange when following one-period is carried out the data query filtration falls, and disconnects this connection then, by internet/intranet linking objective database, from shared region, read in the XML file at last, receive the data of XML pattern, through the mapping function of mapped mode, be translated into the data of relational data model, import to target database.Above-mentioned workflow adopts the Event triggered mode, after last incident is finished, triggers next action.Trigger trigger data switching engine changes the data filter condition, and New Terms is as the query filter condition of next round-robin exchanges data, the dynamic change of data filter condition.The Time Triggered device is according to the cycle of setting, and is every through period T, Time Triggered device trigger data switching engine, and the execution work flow process of restarting to circulate is with the data importing target database that increases newly.
Because source database structurally may be different with target database, therefore in the mapping model at the various problems that may exist, defined general basic mapping function, solved exchangeing problem between the data of the identical relational data model different of structure with structure.When practical application, the pattern that needs first analyze relationship database, according to relational data base schema and XML model creation XML pattern (XML Schema), according to relational data model and XML Schema, from mapping model, choose basic mapping function, be combined into the mapped mode of the requirement of the data that satisfy the exchange of exchange needs.Mapped mode is divided into derives mapped mode and imports mapped mode.
Fig. 4 is illustrated deriving mapped mode for deriving mapping graph.According to the demand of target database to the data element, from source database, choose tables of data and field thereof, set up mapping relations with XML Schema.For the data element that is distributed in the different table, can set up the mapping function vector F (x) of database table and XML Schema by calling the mapping function in the mapping function storehouse.For example, need the situation that merges, break for data recording (OK), select database functions AVG (A), SUM (A) to be combined into new function, the multirow data recording is merged into the data line record, to the data element that should average, with average function AVG (A),, numerical value is added up with SUM (A) function to the data element that should sue for peace.
Fig. 5 is illustrated importing mapped mode for importing mapping graph.Because structure difference between the infosystem, not only there is man-to-man direct mapping in data element, may have one-to-many, and many-to-one phenomenon also might need to replace, transform, replenish situations such as data.Therefore, need from the mapping function storehouse of mapping model, choose basic mapping function, be combined into the vectorial F ' of the mapping function that satisfies the target database demand (x).For example, arithmetic operator in the mathematical function adds+, character string function REPLACE (A, B, C), TO_DATE (A) combines, respectively with data element (field) addition of setting, the data element that needs are replaced replaces, and the data element that needs is converted into character string type is converted into date type data.
Fig. 6 comprises the partition and the merging of partition, merging and the data element (row) of data recording (OK) for partition and merging synoptic diagram, and Fig. 4 is derived mapping graph, and Fig. 5 imports mapping graph, remarks additionally.For data element (field) one-to-many, many-to-one situation is called mapping function in the mapping function storehouse, realizes the data element is listed as partition, row merging.Need to merge or the situation of partition for data recording (OK), call mapping function in the mapping function storehouse, be combined into the mapping function vector, realize row partition, the row of data record are merged.
Fig. 7 is complete system works flow process figure, and operating process is remarked additionally.Behind the logon data switching plane, relational data base schema and XML model according to the infosystem of analyzing, the pattern (XML Schema) of establishment XML is described and constraint XML, information such as the structure of definition and the corresponding XML document of relational database, element (mark), data type, attribute.Then set up table in XML Schema element and source database, the target database or the mapping relations between the view respectively.Carry out multinomial setting then: the connection parameter that source database, target database are set; The title and the storing path (shared region) of XML file are set; Initial data query filtercondition is set; From the data map model, choose basic mapping function, be combined into the data map functional vector that satisfies the demands; The triggering task and the attribute of trigger are set.After setting is finished, click control start button automatically, the exchanges data engine is carried out exchanges data according to workflow shown in Figure 3, and every cycle period T that crosses restarts the exchanges data engine, carries out the circulation of data exchanging workflows journey, the data that exchange of newly-added adds.
Claims (4)
1. realize the data of information system method of exchange automatically for one kind, it is characterized in that this method step is as follows:
1) according to relational data model (100) and XML model (105), create the mapping mechanism between relational data model (100) and the XML model (105), mapping model (115) between opening relationships data model (100) and the XML model (105), this mapping model (115) comprise the mapping function storehouse of realizing mapping relations between the data;
2) according to relational data model (110) and XML model (105), set up XML pattern (120), i.e. XML Schema;
3) according to relational data base schema (110) and XML pattern (120), from the mapping function storehouse of mapping model (115), choose basic mapping function, be combined into the mapping function vector F (X) that adapts to the exchange of specifying information system data, the mapped mode (140) between opening relationships data pattern (110) and the XML pattern (120);
4) set up and being connected of relational database (125);
5) trigger (145) trigger data switching engine (130) carries out exchanges data, if adopt automatic control mode, then need set in advance trigger mechanism and the task and the attribute of trigger (145); Automatically the workflow of control data exchange is: 1. when a certain incident or a certain moment arrival, trigger trigger data switching engine, 2. the exchanges data engine reads triggering task and attribute, and read corresponding mapped mode (140) according to this, 3. the exchanges data engine is carried out exchanges data work, and this step work is carried out different workflows according to the difference of task type; The exchanges data task is divided into two types: receive and issue; When task is when receiving data, it carries out flow process: 1. linking objective database, read in the XML file (135) of shared region, 2. the data with XML file (135) convert target data model to according to mapped mode (140), 3. data are write target database; When work is distributing data, its workflow is: 1. according to task and attribute, connect source database, read in the data filter condition, data are carried out query filter, read the data that to issue, 2. according to mapped mode (140), data-switching is become the data mode of XML pattern (120) definition, 3. data are published to shared region with the form of XML file (135), 4. revise the data filter condition.
2. a kind of data of information system method of exchange automatically that realizes according to claim 1, it is characterized in that: the data of XML pattern are as the intermediary of exchanges data, and internet/intranet is as the passage of exchanges data.
3. a kind of data of information system method of exchange automatically that realizes according to claim 1, it is characterized in that: described mapping function storehouse comprises: mathematical function, character string function, transfer function, database functions, and its effect is that source data is converted into target data; Mathematical function realizes that character string function is realized character string is operated to the operation that performs mathematical calculations of data element, and transfer function is realized the conversion between the different types of data, and the database functions realization is operated the data database data; Wherein:
(1) mathematical function:
Arithmetic operator have add+, subtract-, take advantage of *, remove ÷;
MOD (A, B), calculate with the A operand divided by the B operand after the remainder of gained;
ABS (A), ABS function returns the absolute value of the numerical value of appointment;
SIGN (A), when A returns-1 less than 0 the time, A returned 0 at 0 o'clock, and A returned 1 greater than 0 o'clock;
(2) character string function:
CHR (A) function declaration: the numerical value of CHR function return character equals the character of A, the numerical value of A for setting;
(A, B) function declaration: the CONCAT function couples together A and two character strings of B to CONCAT, and A, B represent 2 character strings;
LPAD (A, B, C) function declaration: fill character in the character string left side, and A is operated character string, and B is total number of the character that will fill, and C is that optionally it is the character that will fill;
RPAD (A, B, C) function declaration: fill character in character string the right, A is operated character string, and B is total number of the character that will fill, and C is that optionally it is the character that will fill;
(A, B) function declaration: relevant character is clipped on the character string left side to LTRIM, and A is operated character string, and B is both can be character, also can be character string or default;
(A, B) function declaration: relevant character is clipped on character string the right to RTRIM, and A is operated character string, and B is both can be character, also can be character string or default;
SUBSTR (A, B, C) function declaration: taking out a substring .A from target string is target string, and B is the position of first character in target strings of the substring that is output, and C is the number of characters of the substring that is output;
REPLACE (A, B, C) function declaration: the character string that A is searched in the replacement function, B is the key for searching in the character string, C is optionally, is the substitute character string;
(3) transfer function:
TO_CHAR (A) function declaration: the TO_CHAR function converts data of different types to character string type, and A is for being converted any type of data;
TO_NUMBER (A) function declaration: the TO_NUMBER function converts character string to a numerical value, and A is the character string that is converted;
TO_DATE (A) function declaration: the TO_DATE function changes into the date type with character string, and A is the character string that is converted;
ADD_FIELD (A, B) function declaration: according to the rule of fields default, replenish data element, the data element of A for replenishing, B is selectable rule;
(4) database functions:
CREATE_VIEW function declaration: be stored in situation in the different pieces of information table for data element,, be combined into view, choose required data element according to incidence relation;
SUM (A) function declaration: the SUM function returns all numerical value sums in the row, and A is the title of row;
AVG (A) function declaration: the mean value of AVG function calculation one row, A is the title of row;
SYSDATE function declaration: the time on date of retrieval system.
4. a kind of data of information system method of exchange automatically that realizes according to claim 1, it is characterized in that: described trigger (145), adopt Event triggered and two kinds of trigger mechanisms of Time Triggered, event trigger trigger data switching engine is according to triggering task and attribute order execution work flow process, Time Triggered device trigger data switching engine, every through after the period of time T of setting, restart the exchanges data engine, workflow enters next circulation, the data that periodic exchange of newly-added adds.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100497481A CN100476810C (en) | 2005-05-08 | 2005-05-08 | Method for implementing automatic exchange of information system data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2005100497481A CN100476810C (en) | 2005-05-08 | 2005-05-08 | Method for implementing automatic exchange of information system data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1687927A true CN1687927A (en) | 2005-10-26 |
| CN100476810C CN100476810C (en) | 2009-04-08 |
Family
ID=35305968
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2005100497481A Expired - Fee Related CN100476810C (en) | 2005-05-08 | 2005-05-08 | Method for implementing automatic exchange of information system data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100476810C (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102236653A (en) * | 2010-04-26 | 2011-11-09 | 北京开普互联科技有限公司 | Method for realizing interaction between layout file and relational database |
| CN102308297A (en) * | 2011-07-13 | 2012-01-04 | 华为技术有限公司 | Data migration method, data migration device and data migration system |
| CN102317942A (en) * | 2011-07-25 | 2012-01-11 | 华为技术有限公司 | Methods and devices for generating theme's properties |
| CN102567756A (en) * | 2011-12-13 | 2012-07-11 | 浙江大学 | Method for acquiring quality information of discrete workshop on line based on radio frequency identification (RFID) technology |
| CN102760164A (en) * | 2012-06-12 | 2012-10-31 | 上海方正数字出版技术有限公司 | Method for exchanging data between relation database management system and XML (Extensive Makeup Language) database management system |
| CN102929664A (en) * | 2012-10-16 | 2013-02-13 | 南京通达海信息技术有限公司 | Conventional data exchange method based on XSD structure |
| WO2013135055A1 (en) * | 2012-03-15 | 2013-09-19 | 北京播思无线技术有限公司 | Method for storing xml data into relational database |
| CN103513934A (en) * | 2012-06-19 | 2014-01-15 | 索尼公司 | Memory control apparatus, memory apparatus, information processing system, and processing method |
| CN103530327A (en) * | 2013-09-25 | 2014-01-22 | 清华大学深圳研究生院 | Method for migrating data from non-relational database to relational database |
| CN108470087A (en) * | 2015-09-29 | 2018-08-31 | 北京动力机械研究所 | Punching engine design and simulation platform data bus |
| CN110222117A (en) * | 2019-05-23 | 2019-09-10 | 武汉达梦数据库有限公司 | A kind of data conversion synchronous method, equipment and the storage medium of heterogeneous database |
| WO2022222577A1 (en) * | 2021-04-20 | 2022-10-27 | 华为技术有限公司 | Data format conversion method and apparatus, device, and computer-readable storage medium |
-
2005
- 2005-05-08 CN CNB2005100497481A patent/CN100476810C/en not_active Expired - Fee Related
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102236653A (en) * | 2010-04-26 | 2011-11-09 | 北京开普互联科技有限公司 | Method for realizing interaction between layout file and relational database |
| CN102308297A (en) * | 2011-07-13 | 2012-01-04 | 华为技术有限公司 | Data migration method, data migration device and data migration system |
| WO2012083679A1 (en) * | 2011-07-13 | 2012-06-28 | 华为技术有限公司 | Data migration method, data migration device and data migration system |
| CN102317942A (en) * | 2011-07-25 | 2012-01-11 | 华为技术有限公司 | Methods and devices for generating theme's properties |
| WO2012106922A1 (en) * | 2011-07-25 | 2012-08-16 | 华为技术有限公司 | Method and device for generating topic attribute information |
| CN102317942B (en) * | 2011-07-25 | 2013-10-09 | 华为技术有限公司 | Methods and devices for generating theme's properties |
| CN102567756A (en) * | 2011-12-13 | 2012-07-11 | 浙江大学 | Method for acquiring quality information of discrete workshop on line based on radio frequency identification (RFID) technology |
| WO2013135055A1 (en) * | 2012-03-15 | 2013-09-19 | 北京播思无线技术有限公司 | Method for storing xml data into relational database |
| US9928289B2 (en) | 2012-03-15 | 2018-03-27 | Borqs Wireless Ltd. | Method for storing XML data into relational database |
| CN102760164A (en) * | 2012-06-12 | 2012-10-31 | 上海方正数字出版技术有限公司 | Method for exchanging data between relation database management system and XML (Extensive Makeup Language) database management system |
| CN103513934A (en) * | 2012-06-19 | 2014-01-15 | 索尼公司 | Memory control apparatus, memory apparatus, information processing system, and processing method |
| CN103513934B (en) * | 2012-06-19 | 2017-06-09 | 索尼公司 | Memory control apparatus, memory devices, information processing system and processing method |
| CN102929664A (en) * | 2012-10-16 | 2013-02-13 | 南京通达海信息技术有限公司 | Conventional data exchange method based on XSD structure |
| CN103530327A (en) * | 2013-09-25 | 2014-01-22 | 清华大学深圳研究生院 | Method for migrating data from non-relational database to relational database |
| CN103530327B (en) * | 2013-09-25 | 2016-08-17 | 清华大学深圳研究生院 | A kind of data migration method from non-relational database to relevant database |
| CN108470087A (en) * | 2015-09-29 | 2018-08-31 | 北京动力机械研究所 | Punching engine design and simulation platform data bus |
| CN110222117A (en) * | 2019-05-23 | 2019-09-10 | 武汉达梦数据库有限公司 | A kind of data conversion synchronous method, equipment and the storage medium of heterogeneous database |
| WO2022222577A1 (en) * | 2021-04-20 | 2022-10-27 | 华为技术有限公司 | Data format conversion method and apparatus, device, and computer-readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100476810C (en) | 2009-04-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1687927A (en) | Method for implementing automatic exchange of information system data | |
| CN103631870B (en) | System and method used for large-scale distributed data processing | |
| CN101819596B (en) | Memory-based XML script buffer | |
| CN103430144A (en) | Data source analytics | |
| CN1885325A (en) | Work breakdown structure design manager, design tool and method thereof | |
| CN101046811A (en) | Data integral service system and method | |
| CN1609854A (en) | Sharing computer object with association | |
| CN1670708A (en) | Management method for computer log | |
| CN101043379A (en) | Network management apparatus and network management method | |
| CN104239320B (en) | A kind of data merging method and system | |
| CN1877563A (en) | Report form defining method and system | |
| Catania et al. | XML document indexes: a classification | |
| CN103677759A (en) | Objectification parallel computing method and system for information system performance improvement | |
| CN114661832A (en) | Multi-mode heterogeneous data storage method and system based on data quality | |
| US11514236B1 (en) | Indexing in a spreadsheet based data store using hybrid datatypes | |
| US11429629B1 (en) | Data driven indexing in a spreadsheet based data store | |
| CN1889557A (en) | Long-distance XML data updating method and system | |
| Yuan et al. | VDB-MR: MapReduce-based distributed data integration using virtual database | |
| CN101853178B (en) | Description method of reconfigurable hardware resource in scheduling | |
| CN103699627A (en) | Dummy file parallel data block positioning method based on Hadoop cluster | |
| CN1877573A (en) | Multilayer database system structure | |
| CN103399963A (en) | Hive-based optimizer optimization method | |
| CN1052316C (en) | Computer managing and designing system and method thereof | |
| CN113468166B (en) | Metadata processing method, device, storage medium and server | |
| US11500839B1 (en) | Multi-table indexing in a spreadsheet based data store |
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 | ||
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20090408 Termination date: 20110508 |