Clustered and Nonclustered Indexes in Databases and Educational Tasks on Development the Structure of Databases
Clustered and Nonclustered Indexes in Databases and Educational Tasks on Development the Structure of Databases

Summary/Abstract: Nowadays, the technology of clustered and nonclustered indexes in databases is used in practically all relational databases. Indexes tell the Database management system (DBMS) how to store the information in the file system of the computer. Clustered and nonclustered ones are the most widespread, because they can increase the speed of selecting from a table many times. The article is about applying a new practical method of teaching undergraduate students in the field of effective development the structure of databases. The introduction of a new method of learning the development of the stricter of databases using clustered and nonclustered indexes, that is required for effective development and further usage of databases in production with big amounts of data. That will allow students to understand, which indexes they should use to increase the speed of selecting, inserting and updating the data in tables of a database. Database design consist of two stages - logical and physical. The logical stage - selection of entities, tables planning, fields, definition of data types for each field, keys, and integrity constraints. The physical stage - planning and index adjustments, file groups, program modules. Indexes are the most basic part of the physical stage. There are many different types of indexes, which used for different purposes. For example, column store index can provide you with a great speed of executing of the aggregation functions. If it is necessary to increase the speed of selection the data from the table, clustered and nonclustered indexes are required. They will be discussed in this article.

• Details
• Contents