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
Modelldriven arkitektur förbättrar hanteringen av problemet med import av data till ER-modeller
KTH, School of Technology and Health (STH), Medical Engineering, Computer and Electronic Engineering.
2015 (Swedish)Independent thesis Basic level (university diploma), 10 credits / 15 HE creditsStudent thesisAlternative title
Model Driven Architecture improves managing the problem of migrating data to ER models (English)
Abstract [sv]

I många sammanhang är det önskvärt att importera data från textfiler, excelfiler och liknande till en databas. För detta krävs att data i något skede översätts till en ER-modell (Entity Relationship), en modell som beskriver relevanta delar i ett databasschema. Modellen för hur denna översättning ser ut varierar från fall till fall.

I det här examensarbetet har en applikation tagits fram för import av data till en ER-modell ur ett modellperspektiv i linje med Model Driven Architecture (MDA) ™. Vinsten ligger i att använda en metamodell som beskriver hur olika modeller för transformering från tabelldata till en ER-modell får se ut. Modellerna i sin tur beskriver hur transformeringen ska se ut. På så sätt kan flera olika modeller användas utan att ändringar i källkoden behöver göras.

Metamodellen som beskriver transformeringen har visualiserats i ett klassdiagram. Klassdiagrammet beskriver schematiskt sambanden mellan tabeller som data ska importeras ifrån och den ER-modell som data ska överföras till. Metamodellen har transformerats till ett XML-schema.  Modellerna som ska användas har skrivits i en XML-fil som följer den transformerade metamodellen.

Abstract [en]

In many situations it is desirable to import data from text files, excel files and similar to a database. To do so the data needs to be translated at some stage to an ER model (Entity Relationship), i.e. a model describing relevant parts of a database schema. The approach for this translation varies from case to case.

During this thesis an application has been developed to import data to an ER model from a modeling perspective, in line with the Model Driven Architecture (MDA) ™. The gain lies in using a metamodel that describes how different models for transformation from grid tables to an ER mode may look like. The models in turn describe how the transformation will look, thus allowing the usage of several different models without any need of changes to the source code.

The metamodel describing the transformation of data can be visualized in a class diagram. The class diagram schematically describes the relationships between tables of data to be imported from and the ER model the data will be transferred to. Preferable is to write a model in an XML that conforms to the metamodel. Therefore the class diagram should be transformed into an XML schema that enables validation of the model in the XML file.

Place, publisher, year, edition, pages
2015. , 39 p.
Series
TRITA-STH, 2014:27
Keyword [en]
MDA, import of data, ER models, metamodel, model, XML schema
Keyword [sv]
MDA, import av data, ER-modeller, metamodell, modell, XML-schema
National Category
Computer Science
Identifiers
URN: urn:nbn:se:kth:diva-169048OAI: oai:DiVA.org:kth-169048DiVA: diva2:819357
External cooperation
Octapharma AB
Subject / course
Computer Technology, Program- and System Development
Educational program
Bachelor of Science in Engineering - Computer Engineering
Supervisors
Examiners
Available from: 2015-06-11 Created: 2015-06-10 Last updated: 2015-06-11Bibliographically approved

Open Access in DiVA

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

By organisation
Computer and Electronic Engineering
Computer Science

Search outside of DiVA

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