hig.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • harvard-cite-them-right
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • sv-SE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • de-DE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Visualisering av en relationsdatabas: En fallstudie
University of Gävle, Faculty of Engineering and Sustainable Development, Department of Industrial Development, IT and Land Management, Computer science.
University of Gävle, Faculty of Engineering and Sustainable Development, Department of Industrial Development, IT and Land Management, Computer science.
2018 (Swedish)Independent thesis Basic level (university diploma), 10 credits / 15 HE creditsStudent thesis
Sustainable development
Sustainable development according to the University's criteria is not relevant for the essay/thesis
Abstract [en]

This thesis aims to explore what advantages could be found in using a three-dimensional visualization of a relation-database, rather than a more conventional means of visualization. This comparison needed two visualization-environments with interactivity capabilities, designed to ease handling customer and system relations for the Forestry Solutions department of CGI Gävle.

First, a database was created, using a database-model that CGI provided, which included the structure of the internal relations between customers and systems in the database. This database was then filled with fictive data with corresponding structure, but not including potentially sensitive information. Then methods for gathering and inserting data into the database were created, for use by both solutions. This was crucial for the separation of the graphical interface and the underlying structure, which would keep the possibility to exchange the graphical portion of the system without affecting what lies underneath.

The two visualization systems were then constructed in parallel, the 3D-system was mainly constructed in Unity, while the conventional system was constructed only using Visual Studio, for a Windows Forms application.

The two systems were then tested by a few CGI employees with different internal roles, where they received a few tasks to complete, while being timed. This was then followed by an interview, where the test subjects had the opportunity to provide us with feedback to both systems design, implementation and which system they preferred using. They were also asked if they had any constructive feedback for further development, which led to us having a deeper understanding of what was necessary for a system of this purpose.

This work concluded, based on tests, interview and studies that a three-dimensional visualization, if done correctly, would have great potential. We also concluded based on user feedback that combining both systems into one would have a positive impact on usability.

Abstract [sv]

Detta arbete utfördes med avsikten att utforska vilka fördelar en tredimensionell visualisering av en relationsdatabas har jämfört med ett mer traditionellt gränssnitt. Jämförelsen behövde två visualiseringsmiljöer med interaktionsmöjligheter, anpassade för att underlätta hanteringen av kunder och systemberoenden på avdelningen CGI Forestry Solutions i Gävle.

Inledningsvis skapades en databas utefter en databasmodell, innehållande den information och de relationer databasen tänktes innehålla. Denna fylldes sedan med fiktiva data, med rätt struktur, därefter skapades metoder för att hämta information från databasen, följt av metoder för insättning. Detta steg medförde en tydlig separation av databasmetoderna och de kommande visualiseringsalternativen, för att möjliggöra utbyte av gränssnittet utan att behöva ändra dessa metoder.

De två systemen konstruerades sedan parallellt för att visualisera denna data: Den tredimensionella lösningen konstruerades i huvudsak i Unity, den andra enbart i Visual Studio i en Windows Forms applikation.

Dessa system testades sedan av ett antal anställda på företaget med olika roller, där de fick ett antal uppgifter att utföra under tidtagning i de båda systemen. Testerna efterföljdes av en intervju där testpersonen fick utvärdera användbarheten hos de båda systemen, i den utsträckning att svara vilket system de föredrog, samt komma med konkreta förbättringar systemen hade dragit nytta av. Intervjuerna ledde i sin tur till en djupare förståelse för önskat beteende hos systemen.

Arbetet mynnade ut i att en tredimensionell visualiseringsmodell av en relationsdatabas har potential, förutsatt en mer komplett implementation. Det hade varit till fördel att slå samman de båda systemen till ett för att bibehålla de positiva delarna av dem båda, för att samtidigt eliminera några svagheter.

Place, publisher, year, edition, pages
2018. , p. 25
National Category
Human Computer Interaction
Identifiers
URN: urn:nbn:se:hig:diva-27071OAI: oai:DiVA.org:hig-27071DiVA, id: diva2:1219465
External cooperation
CGI Forestry Solutions
Subject / course
Computer science
Educational program
Högskoleingenjör
Presentation
2018-05-31, Lilla Jadwigasalen, Kungsbäcksvägen 47, Gävle, 09:00 (Swedish)
Supervisors
Examiners
Available from: 2018-06-26 Created: 2018-06-15 Last updated: 2018-06-26Bibliographically approved

Open Access in DiVA

fulltext(930 kB)2 downloads
File information
File name FULLTEXT01.pdfFile size 930 kBChecksum SHA-512
97dbdbaaebae7bb312c5196538537f83d867b3b1f7a40a2f838559cb33a8911dc36d6cc9b2a7d29202ff942d6cc115209b6cde020a6b0af05628ab9a8cd91e7b
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Haglund, JohannesTåneland, Fredrik
By organisation
Computer science
Human Computer Interaction

Search outside of DiVA

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

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