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

CN103778118A - SQL (Structured Query Language)-based method of converting XML (X Exrensible Markup Language) to relational data bases - Google Patents

SQL (Structured Query Language)-based method of converting XML (X Exrensible Markup Language) to relational data bases Download PDF

Info

Publication number
CN103778118A
CN103778118A CN201210395038.4A CN201210395038A CN103778118A CN 103778118 A CN103778118 A CN 103778118A CN 201210395038 A CN201210395038 A CN 201210395038A CN 103778118 A CN103778118 A CN 103778118A
Authority
CN
China
Prior art keywords
xml
sql
data bases
based method
language
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201210395038.4A
Other languages
Chinese (zh)
Inventor
吴官玉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZHENJIANG HUAYANG INFORMATION TECHNOLOGY CO LTD
Original Assignee
ZHENJIANG HUAYANG INFORMATION TECHNOLOGY CO LTD
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by ZHENJIANG HUAYANG INFORMATION TECHNOLOGY CO LTD filed Critical ZHENJIANG HUAYANG INFORMATION TECHNOLOGY CO LTD
Priority to CN201210395038.4A priority Critical patent/CN103778118A/en
Publication of CN103778118A publication Critical patent/CN103778118A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

A SQL (Structured Query Language)-based method of converting an XML (X Exrensible Markup Language) to relational data bases mainly enables relationships between XML data characters and the data base to be close increasingly. According to the SQL-based method of converting the XML to the relational data bases, the XML which is used for describing database abstract structures is converted to the SQL which is supported through the data bases through XSL (Extensible Stylesheet Language) and accordingly a specific physical table structure is generated.

Description

A kind of XML based on SQL is to the conversion method of relational database
Technical field
Along with the growth of the development of internet and the computer application system based on database, the opening of data among heterogeneous databases and share and just become and become more and more important, the GDI that utilizes various API to realize is widely used.
Background technology
Can improve the data exchange capability between heterogeneous database for a large amount of data miscellaneous provide certain unified method for expressing, the appearance of XML has caused people's concern.As a majorized subset of SGML, the extensibility that XML has and self descriptiveness make it aspect exchanges data and information sharing, have natural advantage.At present, the XML that each database provides supports to be mainly used to facilitate the storage of XML document in database, and extracted data forms XML document from database.
Summary of the invention
We are retrieved and be there is no to find the data about this system aspects by national patent.
The status that a kind of XML based on SQL is mainly XML and database to its method of conversion method of relational database is reciprocity, and in the conversion based on SQL, data in XML document are used for data of description library structure, these data finally can be as table record storage in database, XML is only here an instrument, and the implication of its form and each mark is fixed in advance.In the time of group leader's unit definition tables of data, adopt the mode of XML, then use XSL that XML is converted to the SQL statement that group leader's unit data storehouse is supported, and then generate physics table.

Claims (2)

1. the XML based on SQL is characterized in that using XML to describe a structure for relational database to the conversion method of relational database, and XML document is converted to one group of SQL statement.
2. according to claim 1xML document is converted to one group of SQL statement, is mainly according to setting specific Sentence format, specifically changing according to its corresponding script.
CN201210395038.4A 2012-10-18 2012-10-18 SQL (Structured Query Language)-based method of converting XML (X Exrensible Markup Language) to relational data bases Pending CN103778118A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210395038.4A CN103778118A (en) 2012-10-18 2012-10-18 SQL (Structured Query Language)-based method of converting XML (X Exrensible Markup Language) to relational data bases

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210395038.4A CN103778118A (en) 2012-10-18 2012-10-18 SQL (Structured Query Language)-based method of converting XML (X Exrensible Markup Language) to relational data bases

Publications (1)

Publication Number Publication Date
CN103778118A true CN103778118A (en) 2014-05-07

Family

ID=50570363

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210395038.4A Pending CN103778118A (en) 2012-10-18 2012-10-18 SQL (Structured Query Language)-based method of converting XML (X Exrensible Markup Language) to relational data bases

Country Status (1)

Country Link
CN (1) CN103778118A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104572696A (en) * 2013-10-18 2015-04-29 镇江鼎拓科技信息有限公司 Script-language-based method for conversion from XML (extensive makeup language) to relational database
CN106874364A (en) * 2016-12-30 2017-06-20 厦门南讯软件科技有限公司 Mobilism SQL query method based on XML configurations

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104572696A (en) * 2013-10-18 2015-04-29 镇江鼎拓科技信息有限公司 Script-language-based method for conversion from XML (extensive makeup language) to relational database
CN106874364A (en) * 2016-12-30 2017-06-20 厦门南讯软件科技有限公司 Mobilism SQL query method based on XML configurations

Similar Documents

Publication Publication Date Title
WO2011146220A3 (en) Mapping documents to a relational database table with a document position column
CN103500196B (en) EXCEL data export method and let-off gear(stand) thereof under many concurrent big data quantity environment
BR0209092A (en) Method and system for reporting previously computed context-based xml data and a document object model
WO2011127158A8 (en) Data storage and/or retrieval based on a database model-agnostic, schema-agnostic and workload-agnostic data storage and access models
WO2005046103A3 (en) System and method for storing and retrieving xml data encapsulated as an object in a database store
WO2014035879A3 (en) Operating a distributed database with foreign tables
CN103019689A (en) Universal object serialization realizing method
CN103020112A (en) Heterogeneous database synchronizing system and heterogeneous database synchronizing method
US8762398B2 (en) Method of integrating data of XML document with database on web
CN103778118A (en) SQL (Structured Query Language)-based method of converting XML (X Exrensible Markup Language) to relational data bases
CN104598454A (en) XML (Extensive Markup Language)-based information search method
CN104572696A (en) Script-language-based method for conversion from XML (extensive makeup language) to relational database
Bojicić et al. A comparative analysis of data warehouse data models
CN109145038A (en) A kind of relational database conversion method in cloud computing
CN103092591A (en) XML (Extensive Makeup Language) and Web Service based data integration middleware method
CN104462463A (en) JavaScript data access method based on SQL template
Vasilenko et al. Efficient processing of xml documents in hadoop map reduce
Zhu et al. A Complex XML Schema to Map the XML Documents of Distance Education Technical Specifications into Relational Database
CN104933487A (en) Medicine retrospective application oriented medicine inquiry optimization method
Shengqi et al. A dynamic data storage architecture for saas
Wang et al. GML data management: framework and prototype
Sauer et al. BrackitMR: flexible XQuery processing in mapreduce
CN103778106A (en) Report definition formwork operation method
Jeong Implementation of Ontology Learning and Population System from Structured Data Sources: Standard-based Approach
Ye et al. The framework of chinese intangible cultural heritages metadata standards

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20140507