Home >Database >Mysql Tutorial >Introductory tutorial on indexing technology: 8 recommended indexing technology tutorials
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
##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 host4.
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. Each5 .
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 index6.
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 this7 .
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. 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!