Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Optimering av SQL-frågor för analys i QlikView
Karlstad University, Division for Information Technology.
Karlstad University, Division for Information Technology.
2006 (Swedish)Independent thesis Basic level (degree of Bachelor), 10 points / 15 hpStudent thesisAlternative title
Optimizing SQL-statements for analysis in QlikView (English)
Abstract [sv]

Huvudsyftet med detta examensarbete är att för vår uppdragsgivare ÅF:s räkning, analysera huruvida det är möjligt att, rent tidsmässigt, hämta lagrad information från en av företagets kunders databaser online samt presentera detta grafiskt, som statistisk information. Hänsyn måste tas till server- och nätverksbelastning. Vid analysen optimerade vi SQL-frågor, vilket resulterade i en minskning av den totala exekveringstiden på serversidan med 24 sekunder.

Den databasoberoende applikationen QlikView med sina inbyggda funktioner visade sig vara ett mycket användbart rapporteringsverktyg. Genom att utveckla ett grafiskt gränssnitt, tydliggjorde vi olika fråge- och svarsalternativ, vilka fungerar som underlag för sammanställning av produktionsdata.

Abstract [en]

The main purpose of this thesis is, on the behalf of ÅF, to examine how stored information can be gathered online in a timely fashion. Consideration must be taken to the server and network load. During our investigation we were able to optimize SQL queries that resulted in a reduction of the total execution time by 24 seconds at the server side. One analysis tool that was very useful during our assignment was QlikView, which turned out to be a database independent analysis and reporting tool. We have clarified some alternatives of the questions and answers by developing a graphical interface, which is the basis for putting together the information.

Place, publisher, year, edition, pages
2006. , p. 51
Keywords [sv]
databas, sql, optimering, qlikview
National Category
Computer Sciences
Identifiers
URN: urn:nbn:se:kau:diva-55OAI: oai:DiVA.org:kau-55DiVA, id: diva2:6227
Uppsok
samhälle/juridik
Supervisors
Examiners
Available from: 2006-02-21 Created: 2006-02-21 Last updated: 2018-01-11

Open Access in DiVA

fulltext(666 kB)3038 downloads
File information
File name FULLTEXT01.pdfFile size 666 kBChecksum SHA-1
60d1d2565be8cddb1f359a32f2562510e542d421ea00c5ce8356533686fb15a8c8736fc6
Type fulltextMimetype application/pdf

By organisation
Division for Information Technology
Computer Sciences

Search outside of DiVA

GoogleGoogle Scholar
Total: 3038 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 1267 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard1
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf