Geek Answers Handbook

What are multidimensional index structures in relational databases?

I am currently taking a database class. I watched several videos in relational databases, and when I did some research, I happened to meet this multidimensional indexing topic. Out of curiosity, I tried to read a little in it, and I do not quite understand what he was talking about, since this seems to be a rather advanced topic. So I wondered if I could push you a little in the right direction, with some answers to the following questions. I would like some examples (since most of the information I find is research work), if at all possible. This is not part of my class, but I'm a little intrigued and I would like to know more to find out if this can be useful to me.

  • What is multidimensional indexing?
  • How does this relate to relational databases?
  • When and how is it used?
  • Are there any examples?

Many thanks for your help!

+4
source share
2 answers

It may be overly simplistic, but I'm trying to make it clear.

An index is a sequential list of column data. An index can be used for any column. Indexes are usually placed on the primary key of the table. The index increases query performance. Similarly, if the primary key has more than one column, we have a multidimensional index.

Typically, there are two ways to implement a multidimensional index:

  • Concatenated Multiple Index An excellent explanation is provided here .

. , employeeId . , sunsidiaryId . , .

F1 F2 , , # , , F1 = 'abcd' F2 = 123 'ABCD # 123

, .

, ( ), . , OLAP .

+3

.

, . GIS, OLAP , .

0

More articles:


All Articles