mysql存储xml文件

There have been several approaches that have been proposed to organize the contents of the XML document basically to facilitate the subsequent querying and retrieval have been proposed.

已经提出了几种方法来基本上组织XML文档的内容，以方便随后的查询和检索。

The following are the most common approaches to store the XML document:

以下是存储XML文档的最常用方法 ：

1) Using a DBMS to store the document as text

1)使用DBMS将文档存储为文本

• An RDBMS can be used to the store the complete XML document as text field within the DBMS records or objects.

  RDBMS可用于将完整的XML文档存储为DBMS记录或对象中的文本字段。

• This approach is basically when DBMS has a special module for processing the XML document, and it can work for storing document-centric XML documents.

  基本上，这种方法是在DBMS具有用于处理XML文档的特殊模块时，并且可以用于存储以文档为中心的XML文档。

• The keyword indexing function of the document processing can be used to speed up search and retrieval of the documents.

  文档处理的关键字索引功能可用于加速文档的搜索和检索。

2) Using a DBMS to store the document as data elements

2)使用DBMS将文档存储为数据元素

• This approach will work when we want to store the document that follows a specific XML, DTD schema.

  当我们要存储遵循特定XML DTD模式的文档时，此方法将起作用。

• Because in such schema all will have the same structure so that one can easily design a relational database to store the leaf-level data elements within the XML documents.

  因为在这种模式下，所有文件都将具有相同的结构，所以可以轻松地设计一个关系数据库来在XML文档中存储叶级数据元素。

• This approach basically requires a mapping algorithm to design a database schema that can work comfortably with the XML document structure which is specified in XML schema.

  该方法基本上需要一种映射算法来设计数据库模式，该数据库模式可以与XML模式中指定的XML文档结构轻松地协同工作。

• These algorithms can be implemented either as an internal DBMS module or as a separate middleware that is not the part of DBMS.

  这些算法既可以实现为内部DBMS模块，也可以实现为单独的中间件，而不是DBMS的一部分。

3) Designing a specialized system for storing native XML document

3)设计一个用于存储本机XML文档的专用系统

• Basically, we can design and implement a new database model based on the Hierarchical model such systems are basically known as NATIVE XML DBMS.

  基本上，我们可以基于Hierarchical模型设计和实现一个新的数据库模型，这样的系统基本上被称为NATIVE XML DBMS。

• This system basically includes a data compression technique which will reduce the size of documents while storing it.

  该系统基本上包括一种数据压缩技术，该技术将在存储文档时减小文档的大小。

• Dynamic Application Platform of eXcleon provides such facilities.

  eXcleon的动态应用程序平台提供了这样的功能。

4) Creating or publishing customized XML documents from preexisting relational database

4)从现有的关系数据库创建或发布自定义XML文档

We know that there are the enormous amount of data that are already stored in relational databases and some of this data we need to be formatted as documents for exchanging or displaying over the web.

我们知道，关系数据库中已经存储了大量数据，我们需要将其中一些数据格式化为文档，以便在Web上交换或显示。

In this approach, we basically use a separate middleware software layer to handle the conversion needed between the XML documents and relational databases.

在这种方法中，我们基本上使用单独的中间件软件层来处理XML文档和关系数据库之间所需的转换。

翻译自:

mysql存储xml文件