Thoughts on data definition in Oracle 11g

I have never paid attention to the data storage methods in Oracle, because most of them use metadata stored in Oracle relational databases. Today, I happened to see a description about Oracle 11g data definition, which is collected as follows:

1. Oracle Data Division

Oracle considers that data can be divided into three types:

1) Structured Data: This type of data refers to data that can be stored and managed using relational database tables;

2) unstructured data: This type of data refers to various documents: PDF, word, GIF, etc. In Oracle, the large object field type (LOB) is used to store this type of data, but lob has efficiency problems. Therefore, in 11 GB, securefile is used to store this type of unstructured data. (Securefile provides compression, encryption, and other functions, and improves efficiency)

3) Document/content-centric data (document-centric/content-centric): This type of data represents XML documents. Oracle provides an XML database to manage such documents.

2,Oracle11g securefile

The securefile function is a completely re-designed implementation of the large object (LOB) storage format in Oracle 11g. The original lob storage format is now called basixfile, and it is still the default storage method, however, the securfile keyword enables a new storage method, which allows encryption, space saving by compression, and data duplication elimination.

The data in the securefile organization file is more than 10 times faster than the old lob format field (according to the Oracle official file). The securefile is used to make the non-formatted file part of the database table, in this way, the application does not need to process multiple interfaces of the relational database and file system. You can use the features of the database.

3. Oracle XML DB

1. Oracle xml db supports document-centric or content-centric XML files. XML documents are hierarchical data. Therefore, Oracle xml db provides hierarchical indexes and XML storage warehouses based on the characteristics of XML files.

2. The Oracle xml db architecture has two main features:

1) xmltype tables and views Storage

2) Oracle xml db Repository

 Suddenly I felt like I wanted to include all the structured data, XML documents, and unstructured data in the non-Oracle 11 GB ??