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
Are ORMs the end of stored procedures?
Linnaeus University, Faculty of Technology, Department of Computer Science.
2017 (English)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

Stored procedures are used as the current database logic for SAAB’s data model of the fighter aircraft JAS-39 Gripen electrical schemas. Since the database model was developed in 2000, a research and tests needed to be carried out to decide on whether updating the database to today's technology is applicable. Therefore, Object-Relational Mapping (ORM) is to be researched, tested and compared to stored procedures using test-driven development (TDD)concerning an important factor, that Stored procedures are well-known for, which is querying performance of the database. Moreover, how maintainability and flexibility [1] can affect decision between Stored procedures or migrating to ORM based on our subjective experience. NHibernate and Entity Framework are the two ORM solutions considered sinceSAAB uses C# in this project. The process of this project is run using scrum of the agile software development to maintain an iterative progress throughout the project timeline. In this paper, the process and methodology are covered in details and also the comparison with the test results. These results eventually lead us to the answer that ORM is not a suitable technology, and stored procedures still dominate the querying performance for SAAB’scurrent database.

Place, publisher, year, edition, pages
2017. , p. 30
Keyword [en]
ORM, RDBMS, NHibernate, Entity Framework, Querying Performance, Microsoft SQL Server
National Category
Computer Sciences
Identifiers
URN: urn:nbn:se:lnu:diva-69426OAI: oai:DiVA.org:lnu-69426DiVA, id: diva2:1168555
External cooperation
SAAB
Subject / course
Computer Science
Educational program
Software Technology Programme, 180 credits
Presentation
2017-11-15, P G Vejdes väg 29, 352 52, Växjö, 13:00 (English)
Supervisors
Available from: 2017-12-21 Created: 2017-12-21 Last updated: 2018-01-13Bibliographically approved

Open Access in DiVA

fulltext(813 kB)89 downloads
File information
File name FULLTEXT01.pdfFile size 813 kBChecksum SHA-512
2292f540118f3f20849bdfb7132b1e5ab051277afdba00dda1d636e6d87605f65764c6fbb74860973a018ff5ade8c8af2e7041293b1d5b87016bf3c2b480831f
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Houssein, Hatem
By organisation
Department of Computer Science
Computer Sciences

Search outside of DiVA

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