uu.seUppsala University Publications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association
  • 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
A Bird-watching Database System
Uppsala University, Disciplinary Domain of Science and Technology, Mathematics and Computer Science, Department of Information Technology.
2013 (English)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

This report  describes in detail the working process of constructing a normalized relational database with an associated graphical user interface, based on raw data data sets in CSV-format acquired from the Avian Knowledge Network. The data files contained the bird sightings from the year 2009 in North America. An entity-relationship model of the database was designed, including a table representing the raw data as well as tables representing the corresponding normalized relational data. As a first step the bulk loading facility of the DBMS is used for loading a CSV file into the raw data table. Then a SQL stored procedure  is used for populating the final relational tables by transforming and cleaning the rows of the raw data table. Performance measurements were made about the data transformation as well as a comparison between querying the raw data table versus the final normalized tables. In addition a graphical user interface (GUI) was developed that allows a user to query the database in a flexible way. The performance measurements indicated that querying the normalized tables was more efficient than querying the raw data table.

Place, publisher, year, edition, pages
2013.
Series
IT, 13 087
National Category
Engineering and Technology
Identifiers
URN: urn:nbn:se:uu:diva-220691OAI: oai:DiVA.org:uu-220691DiVA: diva2:706189
Educational program
Bachelor Programme in Computer Science
Supervisors
Examiners
Available from: 2014-03-19 Created: 2014-03-19 Last updated: 2014-03-19Bibliographically approved

Open Access in DiVA

fulltext(1404 kB)978 downloads
File information
File name FULLTEXT01.pdfFile size 1404 kBChecksum SHA-512
62c8b815f7e80c05b5c9234f5c613b0d71e2b37a78693773e132e1161cc440927ab7dff445583fbc74fdd166d2c26bfcf2dd54c46e3f3fed383d508c6f56369d
Type fulltextMimetype application/pdf

By organisation
Department of Information Technology
Engineering and Technology

Search outside of DiVA

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

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association
  • 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