[go: up one dir, main page]
More Web Proxy on the site http://driver.im/

CN100458793C - Mapping conversion method between data access level Xml format data and relational data - Google Patents

Mapping conversion method between data access level Xml format data and relational data Download PDF

Info

Publication number
CN100458793C
CN100458793C CNB2007100157262A CN200710015726A CN100458793C CN 100458793 C CN100458793 C CN 100458793C CN B2007100157262 A CNB2007100157262 A CN B2007100157262A CN 200710015726 A CN200710015726 A CN 200710015726A CN 100458793 C CN100458793 C CN 100458793C
Authority
CN
China
Prior art keywords
data
field
model
relation
definition
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.)
Expired - Fee Related
Application number
CNB2007100157262A
Other languages
Chinese (zh)
Other versions
CN101067814A (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.)
Inspur Group Shandong General Software Co Ltd
Original Assignee
Inspur Group Shandong General Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Inspur Group Shandong General Software Co Ltd filed Critical Inspur Group Shandong General Software Co Ltd
Priority to CNB2007100157262A priority Critical patent/CN100458793C/en
Publication of CN101067814A publication Critical patent/CN101067814A/en
Application granted granted Critical
Publication of CN100458793C publication Critical patent/CN100458793C/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

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

Abstract

This invention provides a mapping converting method for format data and relation data of a data access layer Xml including two periods of designing time and operation time, in which, at the designing time period, a model is set up based on the data structure of the relation data and mapping and conversion of the object and the relation data to be described as a data object and data model, and the data object means that the relation data sets up a model and abstracts the data structure of the list and view in the database to describe its name and field attribute, at the operation period, the data access an engine to structure SQL sentences dynamically for accessing database according to the element data information defined in designing and input data information to finish function of data access layer of increasing, deleting, correcting and checking automatically.

Description

Mapping conversion method between data access layer Xml formatted data and relation data
1, technical field
The present invention designs a kind of Computer Applied Technology, is specifically related to the mapping conversion method between a kind of data access layer Xml formatted data and relation data.
2, background technology
Usually can be divided into three layers on the architectural framework of software: interface presentation layer, Business Logic, data access layer.Usually in the enterprise-level application development environment, OO development approach has become main stream approach.Object only is present in the internal memory, if permanent conservation object data, need carry out the persistence of object, is about to object storage in database.Otherwise, data need be loaded from database, be configured to the object of internal memory.At present, relevant database remains database main flow, most popular, the form right and wrong of its storage data are OO.Therefore, object is carried out access visit with relational database, need shine upon and change, Here it is, and our usually said data access layer is developed.The mapping of hand-coding and service data access layer and transcode are owing to exist difference between compatible data storehouse type (Oracle, Sq1 Server, DB2, Sybase etc.) and the version or the like, this work loaded down with trivial details, consuming time beyond doubt.
In addition, data in the business application system, because reason such as efficient, space, a kind of data often need define a plurality of entity object types, the definition of these object types, conversion, deployment and maintenance are also comparatively loaded down with trivial details, consider the demand of communicating by letter between the heterogeneous system simultaneously, therefore need a kind of universal and uniform data layout and object form that data are encapsulated.
3, summary of the invention
The purpose of this invention is to provide mapping and conversion method between a kind of data access layer Xml formatted data and the relation data, two stages when this method mainly comprises when design and operation, wherein:
Stage when design, as shown in Figure 1, 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, data object is 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 etc.
Wherein table or view are described its display Name, coding, table or view name (Database Identification), author, version, date created etc.
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 etc.
Field type in field attribute, consider to need compatible polytype database, the data type has been carried out abstract, defined the neutral data type of a cover, and set up mapping relations between certain concrete data of database type, thereby shadow data storehouse difference.On this basis, other has defined some traffic data type of using always in the operation system, such as data types such as numbering, title, remarks, the amount of money, its effect has two: the one, make things convenient for typing, the 2nd, traffic data type is stipulated and unified, avoid because manual the program error that error causes is set.For traffic data type, expanded definition is provided, the user can expand when exploitation is used voluntarily.In addition for typing safeguard convenient, provide and database design instrument PD (Power Designer) document format between translation function.The user can carry out database design in PD, save as the PD document, directly imports to generate data object.
Data model
Business Entity is organic form of the composition of data in the operation system, generally is made of many tables of data, constitutes 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.
1) the formation structure of data model is: a master meter, and a plurality of from table, constitute master slave relation, can articulate again from showing the master slave relation of nesting from showing down.A model can be defined in the incidence relation of other models.
2) relation of data model and data object.Table in the data model is quoted from data object, the field in the field corresponding data object of showing in the data model, and this corresponding relation can be complete correspondence, also can be the part correspondence.It is the part field in the corresponding data object that can select of the table of data model.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: 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.The display Name of field, numbering, label (referring 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 etc.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.The 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.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 can specify in the field of inquiring about related relevant correlation model in the model, such as a customer data model, a regional field is wherein arranged, related area data model, specified associations is taken the information such as area code, title of area data model out of in association.
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 metadata (data of data of description) resource.
Stage during operation
Shown in Fig. 2-3, the stage when operation is by data accessing engine, the metadata information of definition during according to design, in conjunction with the data message of 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.Especially, 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.
In addition, 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, can self-defined realization expansion interface and be registered in the data accessing engine, with the function that realizes expanding.Acquiescence, integrated numbering create-rule and the integrated realization of authority commonly used in the data accessing engine.
At object type definition and safeguard loaded down with trivial details, data accessing engine data exchange standard be XML.When returning XML, provide the function of the XML Schema that returns XML.Data accessing engine provides the Xml access object of acquiescence, and the XML access object that also can utilize other system-based class libraries to provide conducts interviews.And for interaction data between heterogeneous system and data standard provide good support.
From external call interface aspect, defined this locality and called 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-RelationDataMapping between data access layer Xml formatted data and relation data, abbreviated XR-Mapping as.
The invention has the beneficial effects as follows: mapping between XML formatted data and the relation data and switch technology can effectively encapsulate
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.
Description of drawings
The data modeling synoptic diagram in stage when Fig. 1 is design;
Mapping during Fig. 2 between the data and conversion synoptic diagram;
Fig. 3 is the design drawing of data accessing engine high level.
4, embodiment:
Two stages when embodiment also is divided into when design (data modeling) and moves (data access, conversion).When design,, the static structure of business datum is carried out hierarchical description (data object data of description library structure, data model is described operational data structure) by data modeling; When operation, describe during according to design, dynamically resolve, finish mapping and conversion between XML data and the database relation data.
4.1 during design
As shown in Figure 1, when design:
(1) data structure that takes out according to business demand, set up data object (description of list structure in the database), the database name of description list, the affiliated row of table and the relevant field information of row (field name, type, length, precision, whether unique, whether can be null value etc.).
(2) business paper that takes out according to business demand is set up data model, describes the formation (a general business paper is to be made of from table a master meter and many) of business paper.Concrete:
Select the main object of a business paper master meter corresponding data objects as data model.
Figure C20071001572600072
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.
Figure C20071001572600073
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.
Figure C20071001572600074
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.).
Figure C20071001572600081
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)

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 model: be to be used for relation data is carried 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 consider to need compatible polytype database, the data type has been carried out abstract, and data type that definition one cover is neutral and concrete asking of certain data of database type are set up mapping relations, thus shadow data storehouse difference;
Data model: be the data constituent relation that is used to describe Business Entity, 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, on the basis of data object, be used for the relation of Business Entity and Business Entity is carried out data structure, the service data information of Business Entity and the relation of asking of Business Entity of modeling and description 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 is corresponding fully or 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: whether data type must fill out, major key, 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, " this data type of VARCHAR (n), corresponding " string " this data type in data model of data object definition;
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:
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;
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, the enumerated value definition is used for simple typing and helps, and 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 showing related as corresponding one or more fields of external key and master meter from the incidence relation of asking of 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, the model that defines this field place is related with 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, 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 the XML document form of form own, 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;
Difference because of the compatible data storehouse, when data accessing engine constructing SQL and accessing database according to the relevant information of data, 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 the XQL statement dynamically to adapt to different type of database and version;
For number create-rule in the operation system, authority is integrated, provides expansion interface definition, to use different application scenarioss; In the sharp implementation process of exploitation, 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 visit that the system-based class libraries that utilizes other provides conducts interviews to edge, and provides 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.
CNB2007100157262A 2007-05-10 2007-05-10 Mapping conversion method between data access level Xml format data and relational data Expired - Fee Related CN100458793C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNB2007100157262A CN100458793C (en) 2007-05-10 2007-05-10 Mapping conversion method between data access level Xml format data and relational data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNB2007100157262A CN100458793C (en) 2007-05-10 2007-05-10 Mapping conversion method between data access level Xml format data and relational data

Publications (2)

Publication Number Publication Date
CN101067814A CN101067814A (en) 2007-11-07
CN100458793C true CN100458793C (en) 2009-02-04

Family

ID=38880376

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2007100157262A Expired - Fee Related CN100458793C (en) 2007-05-10 2007-05-10 Mapping conversion method between data access level Xml format data and relational data

Country Status (1)

Country Link
CN (1) CN100458793C (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101901265A (en) * 2010-07-29 2010-12-01 中国运载火箭技术研究院 Objectification management system of virtual test data
CN101930464A (en) * 2010-08-25 2010-12-29 华南理工大学 RFID logistics application-orientated loose heterogeneous data exchange system and method
CN107577467A (en) * 2017-10-20 2018-01-12 郑州云海信息技术有限公司 A kind of java implementation methods of TOSCA specifications
CN108463781A (en) * 2016-01-13 2018-08-28 罗伯特·博世有限公司 Method and system for information transmission

Families Citing this family (105)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101436185B (en) * 2007-11-12 2012-02-01 北大方正集团有限公司 Method for implementing multiple-file compatibility by XML memory tree
CN101464864B (en) * 2007-12-18 2012-05-23 新奥特(北京)视频技术有限公司 Method for indexing and querying media material by using relational database
CN101634942A (en) * 2008-07-24 2010-01-27 北大方正集团有限公司 Method and system for dynamically creating data tables
EP2161667A1 (en) * 2008-09-08 2010-03-10 Thomson Licensing, Inc. Method and device for encoding elements
CN101458851B (en) * 2008-12-23 2010-06-23 浪潮齐鲁软件产业有限公司 Customizing method for wide invoice simulation template in tax control system
CN101963963A (en) * 2009-07-23 2011-02-02 北京数码大方科技有限公司 Method for constructing database meta-model
CN101739436B (en) * 2009-09-28 2012-12-19 浙江工商大学 XML-based flexible data migration method
CN102081630A (en) * 2009-12-01 2011-06-01 富志杰 Method for classifying, storing and inquiring data
JP5451411B2 (en) * 2010-01-14 2014-03-26 キヤノン株式会社 Information processing apparatus, control method for information processing apparatus, and program
CN101840430B (en) * 2010-04-28 2012-02-29 北京握奇数据系统有限公司 Intelligent card database multi-list operation method and device
CN101887452A (en) * 2010-06-30 2010-11-17 山东中创软件工程股份有限公司 Data dictionary maintenance method and device thereof
CN102456051A (en) * 2010-10-27 2012-05-16 北京大学 Method and device for importing/exporting data of database
US8516011B2 (en) * 2010-10-28 2013-08-20 Microsoft Corporation Generating data models
CN101980213B (en) * 2010-11-23 2012-09-19 中国科学院软件研究所 J2EE-based data persistence method and system
CN102053841B (en) * 2011-01-06 2013-07-31 国电南京自动化股份有限公司 Embedded active memory object database design method
CN102081656A (en) * 2011-01-12 2011-06-01 江苏梦兰神彩科技发展有限公司 Data acquisition and distribution system of cross-platform heterogeneous database
CN102081661A (en) * 2011-01-19 2011-06-01 吉林大学 Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language)
US9069830B2 (en) 2011-03-29 2015-06-30 International Business Machines Corporation Retrieving data objects
CN102867001B (en) * 2011-07-05 2019-12-24 腾讯科技(北京)有限公司 Method and device for acquiring information
CN102254022B (en) * 2011-07-27 2013-03-06 河海大学 Method for sharing metadata of information resources of various data types
CN102411598B (en) * 2011-07-29 2013-07-31 株洲南车时代电气股份有限公司 Method and system for realizing data consistency
CN102982010B (en) * 2011-09-02 2016-06-22 北大方正集团有限公司 The method and apparatus extracting file structure
CN102346774B (en) * 2011-09-26 2013-09-18 深圳市信游天下网络科技有限公司 Database operation method
CN103092874A (en) * 2011-11-01 2013-05-08 镇江华扬信息科技有限公司 XML (Extensive Makeup Language) based isomerous data exchange method
CN102567508B (en) * 2011-12-20 2014-05-14 南京大学 Mass raster data format conversion parallel method based on abstract data model
CN103246649A (en) * 2012-02-02 2013-08-14 中国航空工业集团公司沈阳飞机设计研究所 Dynamic database building method
CN102622436A (en) * 2012-02-29 2012-08-01 浙江吉利汽车研究院有限公司 Data table establishing method of human resource management system
CN102662997B (en) * 2012-03-15 2015-09-16 播思通讯技术(北京)有限公司 A kind of storing X ML data are to the method for relational database
CN102750358B (en) * 2012-06-12 2014-03-12 中国电力科学研究院 Mapping method and system of system data model to common information model (CIM)
CN102819609B (en) * 2012-08-23 2016-06-08 国电南京自动化股份有限公司 A kind of perdurable data model modelling approach
US9053161B2 (en) 2012-08-30 2015-06-09 International Business Machines Corporation Database table format conversion based on user data access patterns in a networked computing environment
CN103714068B (en) * 2012-09-29 2017-11-17 金蝶软件(中国)有限公司 The method and device of instant data renewal
CN102929664A (en) * 2012-10-16 2013-02-13 南京通达海信息技术有限公司 Conventional data exchange method based on XSD structure
CN103020115A (en) * 2012-11-13 2013-04-03 深圳市同洲电子股份有限公司 Data caching method, cache server and system
CN103853714B (en) * 2012-11-28 2017-06-20 中国移动通信集团河南有限公司 A kind of data processing method and device
CN103279509B (en) * 2013-05-17 2016-05-25 北京首钢自动化信息技术有限公司 A kind of method for quickly querying that adopts dynamic queries language
CN103246753A (en) * 2013-05-30 2013-08-14 安徽皖通科技股份有限公司 Method for generating entity metadata model according to database structure
CN103425779A (en) * 2013-08-19 2013-12-04 曙光信息产业股份有限公司 Data processing method and data processing device
CN103488534A (en) * 2013-09-23 2014-01-01 浪潮集团山东通用软件有限公司 Method for enabling business logic layer to feed back control information to presentation layer
CN103593457B (en) * 2013-11-22 2017-02-08 北大医疗信息技术有限公司 Method for converting document format
CN103810281A (en) * 2014-02-20 2014-05-21 浪潮集团有限公司 Method for achieving data synchronization through timing task based on cloud computing
CN104932870B (en) * 2014-03-18 2019-05-24 腾讯科技(深圳)有限公司 A kind of data processing method and device to illusory script
CN104050264A (en) * 2014-06-19 2014-09-17 华为技术有限公司 Method and device for generating SQL statement
CN104133890B (en) * 2014-07-30 2016-02-10 四川中亚联邦科技有限公司 A kind of large data processing method in high in the clouds and system
CN104166705A (en) * 2014-08-06 2014-11-26 广州华多网络科技有限公司 Access method and device of database
CN104317916A (en) * 2014-10-28 2015-01-28 用友优普信息技术有限公司 Device and method for expanding business receipts of data association unit
CN104376103B (en) * 2014-11-26 2017-10-03 浪潮电子信息产业股份有限公司 A kind of multiple HBase table correlating methods based on snowflake model
CN104598592A (en) * 2015-01-20 2015-05-06 北京仿真中心 XML (Extensive Markup Language)-based database custom method and system
CN104679909B (en) * 2015-03-25 2018-07-17 郑州悉知信息科技股份有限公司 A kind of method and device of setting website TDK
CN104881747A (en) * 2015-06-01 2015-09-02 北京圆通慧达管理软件开发有限公司 Data collaboration method and data collaboration system
CN105159920A (en) * 2015-07-28 2015-12-16 卡斯柯信号有限公司 Attribute tag based database access method
CN105045912A (en) * 2015-08-13 2015-11-11 浪潮通用软件有限公司 Relational database data distribution method
EP3365832B1 (en) * 2015-10-23 2021-11-03 Oracle International Corporation Self describing configuration with support for sharing data tables
CN106708891A (en) * 2015-11-17 2017-05-24 中兴通讯股份有限公司 Network management data synchronizing method and device
CN105488117A (en) * 2015-11-23 2016-04-13 浪潮集团有限公司 User-defined object processing method and apparatus
CN106919615A (en) * 2015-12-28 2017-07-04 航天信息股份有限公司 Data access method and system
CN105843605B (en) * 2016-03-17 2019-03-08 中国银行股份有限公司 A kind of data mapping method and device
CN105913198A (en) * 2016-05-11 2016-08-31 邓意麒 Physical entity class model construction module used for intelligent port, intelligent port and intelligent network
CN106022944B (en) * 2016-05-27 2020-03-10 中国石油天然气股份有限公司 Data volume conversion method and device for conventional and streamline models in numerical reservoir simulation
CN110222236B (en) * 2016-06-06 2021-05-04 福建榕基软件股份有限公司 Method and system for generating and updating XML message template
CN106570095B (en) * 2016-10-31 2020-01-07 凯美瑞德(苏州)信息科技股份有限公司 XML data operation method and equipment
CN108121739B (en) * 2016-11-30 2022-07-19 株式会社日立制作所 Data collection method and data collection system
CN106844323A (en) * 2017-02-20 2017-06-13 济南浪潮高新科技投资发展有限公司 A kind of entity construction method and device
CN106886592A (en) * 2017-02-21 2017-06-23 北京航空航天大学 A kind of city space-time data collecting system and method based on data source service
CN106909689A (en) * 2017-03-07 2017-06-30 山东浪潮云服务信息科技有限公司 A kind of data fusion method and device
CN107092587A (en) * 2017-05-02 2017-08-25 山东浪潮通软信息科技有限公司 A kind of business voucher generation method and device
CN108804480A (en) * 2017-05-05 2018-11-13 天津中铁电气化设计研究院有限公司 A kind of analyzing platform and design method of novel dynamic generation data operation commands
CN107908640A (en) * 2017-09-27 2018-04-13 国网浙江省电力公司杭州供电公司 A kind of Business Entity relation Intelligent exploration engine implementing method
CN107657036A (en) * 2017-09-29 2018-02-02 北京酷我科技有限公司 A kind of production method of database object placement model
CN107657038B (en) * 2017-09-29 2021-06-08 北京酷我科技有限公司 Database quick reading method
CN107577812A (en) * 2017-09-29 2018-01-12 北京酷我科技有限公司 A kind of method for quickly reading of entity data bak
CN107832395A (en) * 2017-10-30 2018-03-23 山东浪潮通软信息科技有限公司 A kind of data processing method, device, computer-readable recording medium and storage control
CN107992292A (en) * 2017-11-29 2018-05-04 商派软件有限公司 A kind of method defined by schema forms progress database
CN110019969B (en) * 2017-12-05 2021-06-29 北京京东尚科信息技术有限公司 Method and system for processing semi-structured data
CN108038222B (en) * 2017-12-22 2022-01-11 冶金自动化研究设计院 System of entity-attribute framework for information system modeling and data access
CN108170759B (en) * 2017-12-22 2020-10-23 平安养老保险股份有限公司 Complaint case processing method and device, computer equipment and storage medium
CN110019555B (en) * 2017-12-26 2023-08-25 中国科学院沈阳自动化研究所 Relation data semantical modeling method
CN108874944B (en) * 2018-06-04 2022-06-03 刘洋 XSL language transformation-based heterogeneous data mapping system and method
CN108875038A (en) * 2018-06-27 2018-11-23 南京南瑞继保电气有限公司 The method and system of hierarchical structure real-time data base are attached under relational database data
CN108984712B (en) * 2018-07-06 2022-04-26 深圳前海微众银行股份有限公司 Service scene-based number making method and device and readable storage medium
CN108897897B (en) * 2018-07-24 2021-01-05 艾普阳科技(深圳)有限公司 Data processing method and device
CN109471957B (en) * 2018-09-19 2020-08-04 北京悦图数据科技发展有限公司 Metadata conversion method and device based on uniform tags
CN109377159A (en) * 2018-09-19 2019-02-22 成都信息工程大学 A kind of software modeling procedure incarnation evolution system and method, processor, terminal
CN109446380A (en) * 2018-11-02 2019-03-08 鲁班(北京)电子商务科技有限公司 A method of two tables of data relationships are described based on XML
CN111209319B (en) * 2018-11-21 2022-03-29 华为云计算技术有限公司 Data service method and device
CN109582647B (en) * 2018-11-21 2022-09-30 珠海市新德汇信息技术有限公司 Unstructured evidence file oriented analysis method and system
CN109660638A (en) * 2018-12-10 2019-04-19 中共中央办公厅电子科技学院 A kind of data store organisation and DNS data storage system
CN109684329B (en) * 2018-12-13 2021-04-23 高新兴科技集团股份有限公司 Resource management method based on data center equipment
CN109656928B (en) * 2018-12-24 2020-09-01 成都四方伟业软件股份有限公司 Method and device for obtaining relationships between tables
CN109815242B (en) * 2019-02-02 2021-04-02 中国农业银行股份有限公司 Data processing method and system
CN109918084B (en) * 2019-03-12 2022-03-15 浪潮通用软件有限公司 Data mapping method of service management system
CN110399419B (en) * 2019-07-30 2023-03-24 上海金融期货信息技术有限公司 Relational template memory database system
CN110737642B (en) * 2019-09-05 2022-09-02 平安科技(深圳)有限公司 Database information analysis method, database information analysis device, computer device and storage medium
CN112749157A (en) * 2019-10-30 2021-05-04 北京国双科技有限公司 Data table processing method and device, storage medium and equipment
CN111143449B (en) * 2019-12-12 2023-05-30 北京中电普华信息技术有限公司 Data service method and device based on unified data model
CN111443970B (en) * 2020-03-24 2023-11-03 浪潮通用软件有限公司 Method, device, equipment and readable medium for assembling multi-source data
CN111427867B (en) * 2020-03-30 2023-10-20 杭州华望系统科技有限公司 Model persistence method based on hybrid storage
CN112732833B (en) * 2021-01-08 2024-07-02 西安交通大学 Universal data bridge architecture for acquiring blockchain information and design method
CN112860899B (en) * 2021-03-16 2021-11-16 中化现代农业有限公司 Label generation method and device, computer equipment and computer readable storage medium
CN113051650B (en) * 2021-04-01 2021-10-15 中铁成都科学技术研究院有限公司 Real-time acquisition method and device for building information model component data
CN113377871B (en) * 2021-06-22 2024-03-22 特赞(上海)信息科技有限公司 Data synchronization method, device and storage medium
CN113535844B (en) * 2021-09-15 2021-12-07 山东耕元数据科技有限公司 Data aggregation method and system
CN114297330B (en) * 2021-12-28 2024-07-30 北京达美盛软件股份有限公司 Data map generation method and device
CN114416858A (en) * 2021-12-28 2022-04-29 北京达美盛软件股份有限公司 Data map generation device and track recording method thereof
CN114792145B (en) * 2022-05-27 2023-04-18 中国标准化研究院 Standard digital management maintenance system and method based on knowledge graph

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2003030031A2 (en) * 2001-09-28 2003-04-10 Oracle International Corporation Mechanism for mapping xml schemas to object-relational database systems
US6732095B1 (en) * 2001-04-13 2004-05-04 Siebel Systems, Inc. Method and apparatus for mapping between XML and relational representations
CN1760871A (en) * 2004-10-15 2006-04-19 微软公司 Mapping of schema data into data structures
CN1815468A (en) * 2005-01-31 2006-08-09 微软公司 Integration of a non-relational query language with a relational data store
CN1825306A (en) * 2005-10-31 2006-08-30 北京神舟航天软件技术有限公司 XML data storage and access method based on relational database

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6732095B1 (en) * 2001-04-13 2004-05-04 Siebel Systems, Inc. Method and apparatus for mapping between XML and relational representations
WO2003030031A2 (en) * 2001-09-28 2003-04-10 Oracle International Corporation Mechanism for mapping xml schemas to object-relational database systems
CN1760871A (en) * 2004-10-15 2006-04-19 微软公司 Mapping of schema data into data structures
CN1815468A (en) * 2005-01-31 2006-08-09 微软公司 Integration of a non-relational query language with a relational data store
CN1825306A (en) * 2005-10-31 2006-08-30 北京神舟航天软件技术有限公司 XML data storage and access method based on relational database

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101901265A (en) * 2010-07-29 2010-12-01 中国运载火箭技术研究院 Objectification management system of virtual test data
CN101901265B (en) * 2010-07-29 2012-06-13 中国运载火箭技术研究院 Objectification management system of virtual test data
CN101930464A (en) * 2010-08-25 2010-12-29 华南理工大学 RFID logistics application-orientated loose heterogeneous data exchange system and method
CN101930464B (en) * 2010-08-25 2012-08-08 华南理工大学 RFID logistics application-orientated loose heterogeneous data exchange system and method
CN108463781A (en) * 2016-01-13 2018-08-28 罗伯特·博世有限公司 Method and system for information transmission
CN107577467A (en) * 2017-10-20 2018-01-12 郑州云海信息技术有限公司 A kind of java implementation methods of TOSCA specifications

Also Published As

Publication number Publication date
CN101067814A (en) 2007-11-07

Similar Documents

Publication Publication Date Title
CN100458793C (en) Mapping conversion method between data access level Xml format data and relational data
CN100468396C (en) Mapping architecture for arbitrary data models
US8954480B2 (en) End-to-end interoperability and workflows from building architecture design to one or more simulations
CN100557609C (en) A kind of persistent layer generation method and device
CN101727320B (en) Methods and tools for identifying impact of database changes on an application
US7275087B2 (en) System and method providing API interface between XML and SQL while interacting with a managed object environment
CN101799826B (en) Networking data sharing system and method based on virtual view
US20110023022A1 (en) Method for application authoring employing an application template stored in a database
KR20060045622A (en) Extraction, transformation and loading designer module of a computerized financial system
CN1968154A (en) System and method for service expansion using plug
CN101183363B (en) Method for unitedly configuring management EMS memory data-base by system table structure
CN103049251B (en) A kind of data base persistence layer device and database operation method
CN102566990B (en) Method and device for performing data manipulation in Java application
CN101714078A (en) Code generation method and device
CN102214243A (en) Version management system for x extensible business reporting language (XBRL) classification standard
CN103246704A (en) Mapping method for describing entity and relational data based on conventional data structure
CN105468793A (en) Automated management method for simulation model data
CN103927402A (en) Control logic diagram modular design management system implementation method
Jennings Professional ADO. NET 3.5 with LINQ and the Entity Framework
US7877417B2 (en) Method and apparatus for exchanging data with a database
CN101241503B (en) Database personalized method
US20070299676A1 (en) System and method of member unique names
Zhang et al. Clock: Synchronizing internal relational storage with external xml documents
CN101055521B (en) Mapping rule visualized generation method and system
CN103020162B (en) CC2000 model conversion imports the method for D5000 system

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
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20090204

Termination date: 20160510

CF01 Termination of patent right due to non-payment of annual fee