Zur Kurzanzeige

dc.rights.licenseAll rights reserveden_US
dc.contributor.advisorTorres Batista, Nelliud D.
dc.contributor.authorHidalgo Lorenzo, Simonely
dc.date.accessioned2022-01-25T12:55:48Z
dc.date.available2022-01-25T12:55:48Z
dc.date.issued2021
dc.identifier.citationHidalgo Lorenzo, S. (2021). Performance Evaluation in SQL Server [Unpublished manuscript]. Graduate School, Polytechnic University of Puerto Rico.en_US
dc.identifier.urihttp://hdl.handle.net/20.500.12475/1290
dc.descriptionDesign Project Article for the Graduate Programs at Polytechnic University of Puerto Ricoen_US
dc.description.abstractAdatabase table with millionsof rowscould take a long time to retrieve, insert, update,and delete data. The evaluationin thispaperconsists of create indexes, apply normalization process, and create surrogate key to improve the performance of retrieving data. Explain the differences between multiple types of indexes and which scenarios we can use for each of them. To evaluate the improvements, one table was created in SQL server with 45 million rows. The analysis describes the resourcesand I/O statisticsused by Microsoft SQL Server Management Studio.For non-indexed tables is categorized sequentially searched and indexed table that are compared as B-tree index. Finally,the analysis was performed for normalization and composite key.Key Terms¾Microsoft SQL Server Management Studio, optimization, performance, SQL statisticsen_US
dc.language.isoenen_US
dc.publisherPolytechnic University of Puerto Ricoen_US
dc.relation.ispartofComputer Science Program;
dc.relation.ispartofseriesFall-2021;
dc.relation.haspartSan Juanen_US
dc.subject.lcshPolytechnic University of Puerto Rico--Graduate students--Postersen_US
dc.subject.lcshPolytechnic University of Puerto Rico--Graduate students--Researchen_US
dc.subject.lcshSQL server
dc.subject.lcshDatabase management
dc.subject.lcshInformation storage and retrieval
dc.titlePerformance Evaluation in SQL Serveren_US
dc.typeArticleen_US
dc.rights.holderPolytechnic University of Puerto Rico, Graduate Schoolen_US


Dateien zu dieser Ressource

Thumbnail
Thumbnail

Das Dokument erscheint in:

Zur Kurzanzeige