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

Direct link
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
IT, 13 087
National Category
Engineering and Technology
URN: urn:nbn:se:uu:diva-220691OAI: oai:DiVA.org:uu-220691DiVA: diva2:706189
Educational program
Bachelor Programme in Computer Science
Available from: 2014-03-19 Created: 2014-03-19 Last updated: 2014-03-19Bibliographically approved

Open Access in DiVA

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

By organisation
Department of Information Technology
Engineering and Technology

Search outside of DiVA

GoogleGoogle Scholar
Total: 654 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

Total: 1014 hits
ReferencesLink to record
Permanent link

Direct link