Home >Database >Mysql Tutorial >Introductory tutorial on indexing technology: 8 recommended indexing technology tutorials

Introductory tutorial on indexing technology: 8 recommended indexing technology tutorials

零下一度
零下一度Original
2017-06-13 11:46:501344browse

XML (Extensible Markup Language) has become the standard for data representation and data exchange in Web applications. With the rapid development of the Internet, especially the widespread use of e-commerce, Web services and other applications, XML type data has become the current mainstream. data form. Therefore, XML data management technology, especially XML data query technology, has become a current research hotspot. Compared with relational data, XML has various advantages, but its biggest drawback is its efficiency. Because in relational data files, data field names only need to appear once, while in XML data files, element names will appear repeatedly, which will certainly affect the efficiency of the query. In order to improve the query efficiency of XML as much as possible, it is necessary to provide indexing function for XML type. The World Wide Web Consortium identified XPath 2.0 and XQuery 1.0 as recommended standards on January 23, 2007, ending the previous situation in which various query languages ​​competed for dominance. Based on this standard, in addition to traditional manufacturers, various scientific research institutions have proposed implementations of XPath and XQuery (there are more than a dozen mentioned in the literature), with different storage models, different query algorithms, and optimization methods. , behind this

1. "XML" index technology based on relational database engine

Introductory tutorial on indexing technology: 8 recommended indexing technology tutorials

##Introduction: XML (Extensible Markup Language) has become the standard for data representation and data exchange in Web applications. With the rapid development of the Internet, especially the widespread use of e-commerce, Web services and other applications Using, XML type data has become the current mainstream data form

2. How to establish the best index using Oracle index technology

Introduction: 1. Create index explicitly create index index_name on table_name(field_name) tablespace tablespace_name pctfree 5 initrans 2 maxtrans 255

##3.

Index technology of relational database

Introduction: , American space, American server, virtual host

4.

Create ASM instance and ASM database

Introduction: File AUs (allocation units) are balanced among all disks in the disk group. ASM uses index technology to track the location of each AUs and supports RAC cluster technology. Each

5 .

Comparison of B-Tree and Bitmap indexes in Oracle index

Introduction: B-tree index is a technology used by all large relational databases and is also the default index of Oracle database technology. Cardinality: refers to the number of different key values ​​contained in the column you want to create an index

6.

The difference between Hermes and open source Solr and ElasticSearch

Introduction: The difference between Hermes and the open source Solr and ElasticSearch. When talking about Hermes’ indexing technology, I believe many students will think of Solr and ElasticSearch. Solr and ElasticSearch are really famous in China. They are two top projects. Recently, some students often ask me why I still use Hermes when there are Solr and ElasticSearch in the open source world? In answer to this

7 .

Talk about database query index establishment and query condition writing from index technology

Introduction: The advantage of indexing is of course to increase the retrieval speed, but it does not mean that the database has established an index. It will really improve the retrieval speed. Why? We know that the index itself is ordered, and the index search is usually a multi-point search. (Of course, the index implemented with an array in the memory can perform a random search, but the database is generally very Few organizations are organized in this way, usually using B-trees),

8.

Database index technology

Introduction: 1. The concept of index technology Index technology is a fast file access technology that associates the retrieval of each record of a file in one or certain fields (or attributes) with the physical address of the record Together, it provides a mechanism for quickly accessing file records based on record fields. 2. Classification of indexing technology 2.1. Ordered indexing Ordered indexing technology uses index files to achieve

The above is the detailed content of Introductory tutorial on indexing technology: 8 recommended indexing technology tutorials. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn