Priporočila za pisanje povpraševanj SQL

diplomsko delo

Petra Janc (Author), Tatjana Welzer-Družovec (Mentor), Marko Hölbl (Co-mentor)

Abstract

Diplomsko delo opisuje SQL povpraševanja, oziroma napotke, kako ta povpraševanja približati optimizaciji. Bralca vodi od začetka pisanja in predstavitve posameznih SQL stavkov vse do pisanja optimiziranih SQL povpraševanj. Ob tem bralcu predstavi priporočila in metode za dosego le-teh, poleg tega pa mu predstavi še proces same optimizacije. Prav tako mu prikaže posamezne korake optimizacije povpraševanj, tako da jih bralec lahko tudi sam zapiše. Z diplomskim delom želimo ugotoviti, kaj je bistveno pri pisanju SQL povpraševanj za dosego hitro se izvajajočega povpraševanja, ki porabi čim manj vira podatkov.

Keywords

SQL povpraševanje;optimizacija SQL;SQL stavki;

Data

Language:	Slovenian
Year of publishing:	2012
Source:	Maribor
Typology:	2.11 - Undergraduate Thesis
Organization:	UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher:	[P. Janc]
UDC:	004.65(043.2)
COBISS:	16379926
Views:	2274
Downloads:	209
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	Recommendations for writing SQL queries
Secondary abstract:	This thesis describes SQL Queries and advices how to optimized them. The reader is guided through from the beginning of writing SQL clauses to writing optimized SQL queries. By this the reader learn the recommendations and methods to make them optimized. He is also introduced into the steps of SQL query optimization and he can try to write them by himself. The objective of this thesis is to learn what is important to make SQL queries execute faster and use as few data as possible.
Secondary keywords:	SQL Query optimization;SQL clauses;
URN:	URN:SI:UM:
Type (COBISS):	Bachelor thesis/paper
Thesis comment:	Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko
Pages:	VIII, 52 f.
Keywords (UDC):	science and knowledge;organization;computer science;information;documentation;librarianship;institutions;publications;znanost in znanje;organizacije;informacije;dokumentacija;bibliotekarstvo;institucije;publikacije;prolegomena;fundamentals of knowledge and culture;propaedeutics;prolegomena;splošne osnove znanosti in kulture;computer science and technology;computing;data processing;računalniška znanost in tehnologija;računalništvo;obdelava podatkov;data;podatki;databases and their structures;podatkovne zbirke in njihove zgradbe;
ID:	994893