If this business paper has from table, then under the main object of data model, select the subobject of each sublist corresponding data objects as data model.And related (the master meter identification field from table is related with the master meter sign) of appointment subobject and main object.

Specify major key field, the code field of main object and subobject respectively,, then need enable the classification option, specify corresponding rating information if data staging information is arranged.

Specify the association attributes of main object and subobject field respectively:

■ field base attribute is as field name, field label, field description, field type etc.

If field is an external key, then the type of specific field is " association ", and specifies " data model " of its association, and definition is closed

The relevant information of ■ connection.

■ can be field and specifies codomain to enumerate.

■ is that field is specified its purposes (card, tabulation, printing etc.).

In addition, can be main, subobject and specify various constraints (inspection of data deletion external key, uniqueness inspection etc.).

4.2 during operation

As shown in Figure 2, receive outside increasing, delete, change, make a thorough investigation of and ask by " data accessing engine " during operation, finish the mapping and the conversion of corresponding XML data and relation data.Can be divided into two classes to " data accessing engine " request, a class is that data are obtained, and promptly obtains relation data from relational database, and the result is converted to the XML data; The XML data are promptly imported in another kind of data input, are converted into relation data, will import synchronously (insert, upgrade) to database.

(1) data are obtained, " data model " sign according to input, the condition of inquiry, by " data accessing engine " description according to corresponding " data model ", " data object ", dynamically form the SQL of query relation database, obtain the data result collection,, be configured to the XML data and return then according to corresponding " data model " structure.

(2) data input, " data model " sign and XML according to input, dynamically be configured to the relation data result set by " data accessing engine ", and according to the description of corresponding " data model ", " data object ", dynamically form insertion, renewal, the deletion SQL of relational database, carry out SQL, finish request.When many of execution influenced the SQL of database positioning, " data accessing engine " can automatic log-on data storehouse affairs.

Like this, the parsing when modeling during by operation and operation is carried out, and has finished mapping and conversion between XML data and the relation data database data.

5, embodiment:

The present invention has successfully applied to tide GSP application development platform, and its framework as shown in Figure 3.The system designer describes the model of business datum by patterned data object, data model designer, and " data model " is applied to each module that platform need be done the relational database persistence.What these modules were used is the XML data, by to the calling of data access engine, finishes the accessing operation of XML data to relational database.

Mapping between XML formatted data and the relation data and switch technology, effectively encapsulated access visit to relational database, shielded underlying database because the exploitation complexity that differences such as the kind of database, version cause, a kind of standard XML data access and transformat are provided, make the developer need not write the function that any code can be realized the access visit of persistence layer, thus very effective development difficulty, the development risk that reduces software systems persistence layer.In addition, this method makes the structural adjustment of business datum become simply, when database structure and business paper structure generation adjustment, adjusts by patterned data object, data model designer, do not need to compile and the physics issue, can finish adjustment work.Effectively reduced that software systems are implemented and maintenance process in cost and risk and exploitation, the implementation cost of software vendor.Make the individual demand that software systems can the fast adaptation user, satisfy the constantly long-term objective of development and perfect information system of user.

Claims

1. the mapping conversion method between data access layer Xml formatted data and relation data, two stages when it is characterized in that setting up separately timing and operation, wherein:

Stage when design, carry out modeling at the data structure of relation data and the mapping and the conversion of object and relation data, be described as two kinds of metadata of data object and data model; Wherein:

Data object: be that relation data carries out modeling, come out the data structure of table in the database and view is abstract, describe its title, field attribute, wherein table or view are described its display Name, coding, table or view name or Database Identification, author, version, date created; Wherein in the field attribute, main information has: the field display Name, field name, Database Identification, field type, field length, whether must fill out, whether be key word; Field type in field attribute, need to consider compatible polytype database, the data type has been carried out abstract, defined between the neutral data type of a cover and concrete certain data of database type and set up mapping relations, thus shadow data storehouse difference;

Data model: be that Business Entity is organic form of the composition of data in the operation system, generally constitute by many tables of data, constitute master slave relation and incidence relation between many tables, data model is the data constituent relation that is used to describe Business Entity, on the basis of data object, the relation of Business Entity and Business Entity is carried out modeling, describe Business Entity data structure, the service data information of Business Entity, the relation between the Business Entity; Wherein:

1) the formation structure of data model is: a master meter, and a plurality of from table, constitute master slave relation, from showing down to articulate again from table, the master slave relation of nesting, the incidence relation of a model definition and other models;

2) relation of data model and data object is: the table in the data model, quote from data object, field in the field corresponding data object of showing in the data model, this corresponding relation can be complete correspondence, also can be the part correspondence, i.e. part field in the corresponding data object of the table of data model selection; After correspondence is come, automatically according to descriptive information of data object, form the descriptor of data model, the coding of the table of data model, title are directly taken from the coding and the title of data object; The field description information of showing in the data model, part is taken from the information of the field description of data object: data type, whether must fill out, major key etc., especially, the data type that defines on the data model is different from the data type that defines on the data object, the data type that defines on the data model is the data type towards the exploitation programming language, and the data type on the data object then is abstract in the data of database type; Such as, " VARCHAR (n) " this data type of data object definition, corresponding " string " this data type in data model;

3) the Table Properties information of data model is: numbering, title, major key field appointment, major key create-rule, whether enable code field, code field appointment, code field create-rule, data staging definition, ordering definition etc.:

4) the field attribute information of data model is: the display Name of field, numbering, label or refer to name, field data purposes, field type, the definition of field object type, whether as row right assignment, data permission definition, whether must, whether when inserting, use, whether when upgrading, use; Part field attribute definition is explained as follows:

Wherein the field data purposes is: tabulation, card, printing, reference and querying condition are multiselects;

Wherein the definition of field object type is used to specify the incidence relation of field or the enumerated value definition of use: the incidence relation definition is used for the incidence relation between the definition of data model, enumerated value definition is used for simple typing and helps, such as "Yes", "No" or " man ", " woman " etc.; Wherein row authority, data permission define the related definition that is used for permission system;

5) master slave relation of the table of data model definition: specify master meter and, specify from one or more fields of table related as corresponding one or more fields of external key and master meter from the incidence relation between the table;

6) incidence relation between the data model: the incidence relation between the data model is made of a field in related another data model of a field of data model, a field object type definition is arranged in field attribute, when being chosen as incidence relation, can be defined in the association of another model, in association, specify field related with it in the correlation model, related subsidiary condition, and specify in the model field of the related relevant correlation model of inquiry, such as a customer data model, a regional field is wherein arranged, related area data model, specified associations is taken the area code of area data model out of in association, the information of title;

Data object that defines during design and data model are described with a self-defining cover XML tag, and it preserves form originally as the XML document form, manages as the data resource of metadata or data of description;

Stage when operation, by data accessing engine, the metadata information of definition during according to design, data message in conjunction with input, the SQL statement of dynamic constructs database access visit, accessing database is finished the function that additions and deletions change the data access layer of looking into automatically, in order to raise the efficiency, the result of dynamic construction process is carried out an amount of buffer memory;

Be compatible data storehouse difference, when data accessing engine constructing SQL and accessing database, relevant information according to metadata, type of database and version according to current accessed, difference at dialect between type of database and the version, the usage policy pattern is adjusted SQL statement dynamically to adapt to different type of database and version;

For numbering create-rule in the operation system, the integrated grade of authority provides the expansion interface definition, to use different application scenarioss; In exploitation and implementation process, according to the needs of different business scene, self-defined realization expansion interface also is registered in the data accessing engine, to realize the function of expansion; Integrated numbering create-rule and the integrated realization of authority commonly used in the data accessing engine of acquiescence;

At object type definition and safeguard loaded down with trivial details, data accessing engine data exchange standard be XML, when returning XML, the function of the XML Schema that returns XML is provided, data accessing engine provides the Xml access object of acquiescence, or the XML access object that the system-based class libraries that utilizes other provides conducts interviews, and provides good support for interaction data between heterogeneous system and data standard; From external call interface aspect, having defined this locality calls and two kinds of clients of We LANG CHAO GENERASOFT Co Ltd service call, be convenient to calling of different application and development patterns, so just finish mapping and conversion XML-RelationData Mapping between data access layer Xml formatted data and relation data, abbreviated XR-Mapping as.