Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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
Applikation för sökning i databaslogg samt design av databas
Örebro University, School of Science and Technology.
2012 (Swedish)Independent thesis Basic level (professional degree), 10 credits / 15 HE creditsStudent thesisAlternative title
Application for Searching a Database Log and Design for a Database (English)
Abstract [sv]

Den här rapporten behandlar ett system som använder en databas som lagringsplats för loggar. En bra metod för att hämta ut dessa loggar saknades och databasdesignen behövde förbättras för sökningar i loggarna. En applikation för att hämta och söka i loggposter från databasen skapades. En undersökning om hur databasdesignen kunde förbättras genomfördes också. Båda delarna gjordes i ett projekt för att de hörde ihop. Applikationen skulle använda databasen. Då jag inte kunde göra vilka ändringar jag ville i databasen gjordes relativt begränsade ändringar i den. Större ändringar utreddes teoretiskt. Applikationen gjordes mot den existerande databasdesignen, med ett undantag: en vy lades till.

Rapporten undersöker index och andra metoder att göra sökningar i en databas snabbare. En metod för att hämta data inom ett intervall i en databas utvecklades och den beskrivs i rapporten. Metoden söker efter all data som har värden på en kolumn som faller inom ett intervall och där databasen är ordnad, eller nästan ordnad, på den kolumnen. Metoden ger oexakta svar om databasen är nästan ordnad på den kolumnen. Den är snabbare än en motsvarande exakt sökning.

Abstract [en]

This report considers a system where a database is used as the back-end storage for logging. A suitable method for extracting information from the logs was missing and the database design needed an improvement for log searching. An application for extracting and filtering the logs was created. An evaluation of how the database could be improved was also performed. Both parts were done in one project since they were heavily connected. The application would use the database. Since I couldn’t make arbitrary changes to the database only relatively limited changes were made in practice. Larger changes were evaluated theoretically. The application was made against the existing database, with one exception: a view was added.

The report handles indexes and other methods for speeding up database searches. A method for fetching data inside an interval in a database was developed and is described in the report. The method searches for all data where the value of a column is inside an interval and the database is ordered, or almost ordered, on that column. The method gives inexact answers if the database is almost ordered on that column. It is faster than a corresponding exact search.

Place, publisher, year, edition, pages
2012. , 24 p.
Keyword [en]
database, optimization, C#, interval, range, inaccurate, search, SQL, design, logging, log, design, searching, WCF, LINQ
Keyword [sv]
databas, databasoptimering, optimering, C#, intervall, oexakt, sökning, SQL, design, logg, databasdesign, databaslogg, databassökning, WCF, LINQ
National Category
Software Engineering
Identifiers
URN: urn:nbn:se:oru:diva-23462OAI: oai:DiVA.org:oru-23462DiVA: diva2:534835
Presentation
2012-05-28, T207 i Teknikhuset, Örebro universitet, Fakultetsgatan 1, 702 81, Örebro, 14:45 (Swedish)
Uppsok
Technology
Supervisors
Examiners
Available from: 2012-06-20 Created: 2012-06-13 Last updated: 2017-10-17Bibliographically approved

Open Access in DiVA

fulltext(546 kB)339 downloads
File information
File name FULLTEXT01.pdfFile size 546 kBChecksum SHA-512
62c67ea7968087db375326770785d6c6a03c0f215b01cfa317ef380d4997a03fade60549b291a85df384e67e0b3e823d4c4626669b84274e511372387a057631
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Håkansson, Gunnar
By organisation
School of Science and Technology
Software Engineering

Search outside of DiVA

GoogleGoogle Scholar
Total: 339 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: 188 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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