8-10 January 2020
Universidad Nacional de Trujillo
America/Lima timezone
Comparta nuestro evento: https://indico.uni.edu.pe/e/JP3I-2020

Database Optimization Techniques using Microsoft SQL Server

Not scheduled
10m
Universidad Nacional de Trujillo

Universidad Nacional de Trujillo

Av. Juan Pablo II, Trujillo. Perú
Ingeniería Informática y Ciencias de la computación Presentaciones Orales

Speakers

Ms Gisella Luisa Elena Maquen Niño (Universidad nacional Pèdro Ruiz Gallo)Mr Franklim Edinson Teran Santa Cruz (Universidad Nacional Pedro Ruiz Gallo)

Description

The main problem when accessing a database is the response time. The research was applied, used two databases, one control and one experimental. Three computers have been used for the execution of ten queries to the two databases, running 4 consecutive times and obtaining an average execution time. The results found were that there are database optimization techniques that negatively affect the response time of the queries such as: the creation of nonclustered indexes in primary keys. It is concluded that the creation of the database must involve not only the satisfaction of functional requirements but the use of techniques to optimize the database, being the most efficient: the creation of clustered indexes in frequent tables, nonclustered indexes in keys foreign, the use of calculated columns, of appropriate operators and list of columns in the queries and the least efficient ones, such as the creation of nonclustered indexes in primary keys

Primary authors

Ms Gisella Luisa Elena Maquen Niño (Universidad nacional Pèdro Ruiz Gallo) Mr Franklim Edinson Teran Santa Cruz (Universidad Nacional Pedro Ruiz Gallo)

Presentation Materials

There are no materials yet.
Your browser is out of date!

Update your browser to view this website correctly. Update my browser now

×