Method and apparatus for importing contents of XML file into database

Abstract

The present invention discloses a method and an apparatus for importing contents of an extensible markup language (XML) file into a database. The method comprises: loading XML data in the XML file into a memory in a stream mode; acquiring data from the XML data in the memory and storing the acquired data into a designated data table, wherein a data storage structure of the designated data table is the same as that of a designated database; and importing the data in the designated data table into the designated database. According to the technical scheme, not only is the speed of the XML file in the reading process promoted and the method and the apparatus have the beneficial effects of stability for reading and difficulty in breakdown, but also when the data acquired from the XML file is imported into the database, the data is firstly stored into the designated data table with the same storage structure with the designated database, so that data can be submitted into the database in batch, the operation time of the database is greatly reduced, and the data importing efficiency is improved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and a device for importing the content of an extensible markup language XML file into a database. Background technique [0002] XML (ExtensibleMarkupLanguage, Extensible Markup Language), is a cross-platform, content-dependent technology in the Internet environment, and is a powerful tool for processing structured document information. Extensible Markup Language XML is the most commonly used simple data storage language today, and it can use a series of simple custom tags to describe data. [0003] In many scenarios, it is necessary to import the content of the XML file into the database. For example, in the field of electronic bidding, it is necessary to import the data stored in the bill of quantities in XML format in the electronic bidding document into the database of the electronic bid opening and evaluation system. Existing technologies usually execute SQL on th...

AI Technical Summary

Problems solved by technology

Existing technologies usually execute SQL on the data stored in XML one by one, or use DataAdapter to insert them together, which is not only slow, but also causes rapid decline in system performance, system instability, and even memory overflow when the XML file is large

For example, in the field of electronic bidding, the XML file of the bill of quantities is too large, which results in a long time-consuming import of the bid documents during on-site bid opening, which cannot achieve the desired effect and meet the high-performance requirements.

Images