Samodejna analiza dnevnika transakcij za identifikacijo možnosti optimizacije relacijskega podatkovnega modela

magistrsko delo

Adel Kovačevič (Author), Muhamed Turkanović (Mentor), Aida Kamišalić (Co-mentor)

Abstract

Magistrska naloga predstavlja zasnovo in implementacijo orodja Revertium, ki uporabniku pomaga pri identifikaciji možnosti optimizacije relacijskega podatkovnega modela na podlagi analize dnevnika transakcij obstoječe relacijske podatkovne baze. Raziskali smo relacijski podatkovni model in določene slabosti relacijskih podatkovnih baz ter na podlagi pridobljenega znanja definirali možnosti optimizacije le-teh. Za namen doseganja prej omenjenega smo raziskali povratni inženiring relacijskih podatkovnih baz in določene optimizacijske tehnike, kot sta indeksiranje in denormalizacija. Na podlagi ugotovljenega smo združili vso znanje v celoto – orodje Revertium, ki je rezultat magistrskega dela.

Keywords

relacijski podatkovni model;povratni inženiring;dnevnik transakcij;optimizacija;indeksiranje;denormalizacija;magistrske naloge;

Data

Language:	Slovenian
Year of publishing:	2019
Typology:	2.09 - Master's Thesis
Organization:	UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher:	[A. Kovačević]
UDC:	004.415.2.043:004.6.056(043.2)
COBISS:	22829078
Views:	649
Downloads:	107
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	Automatic analysis of transactions for the identification of relational data model optimization options
Secondary abstract:	The thesis represents the design and implementation of the tool Revertium, which helps the user identify the possibilities of optimizing the relational data model based on the analysis of database transaction logs. We have researched the relational data model and its weaknesses to define the optimization options based on acquired knowledge. For the purpose of achieving the latter, we researched reverse engineering of relational databases and some optimization techniques like indexing and denormalization. Based on all acquired knowledge, we created a proposed result of the thesis – a tool named Revertium.
Secondary keywords:	relational data model;reverse engineering;transaction log;optimization;indexing;denormalization;
Type (COBISS):	Master's thesis/paper
Thesis comment:	Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko, Informatika in tehnologije komuniciranja
Pages:	VII, 60 f.
ID:	11226191