lnu.sePublications
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
Building a database abstraction framework in PHP 5.3: Evaluating the implications on performance and benefits on workflow
Linnaeus University, Faculty of Science and Engineering, School of Computer Science, Physics and Mathematics.
Linnaeus University, Faculty of Science and Engineering, School of Computer Science, Physics and Mathematics.
Linnaeus University, Faculty of Science and Engineering, School of Computer Science, Physics and Mathematics.
Linnaeus University, Faculty of Science and Engineering, School of Computer Science, Physics and Mathematics.
2012 (English)Independent thesis Basic level (university diploma), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

This study analyzes the possibilities of creating a general-purpose PHP framework, that can handle the abstraction and mapping to both RDBMS and NoSQL databases. Although there are some different Object-Relational Mappers (ORM) out there, there’s a lack of implementations supporting different types of databases and that’s what the framework, called Squid, aims to cure.

To understand the difficulties involved in building a framework like Squid the study takes a closer look at Database Abstraction Layers, some architectural patterns, Object- Relational Mapping and Object Document Mapping as well as RDBMS and NoSQL databases.

To establish the quality of the framework, tests were carried out to examine how much development time as well as lines of code that could be saved by using Squid instead of writing native queries. Additionally, performance tests were executed as speed in ORM's, or lack thereof, is a common issue.

Even though separate Database Abstraction Layers had to be created for the RDBMS and the NoSQL database, the results clearly demonstrate the benefits of the framework; shorter development time and less code. Performance wise the framework failed though.

Nevertheless, with the right commitment and resources, further development could make the Squid framework a useful asset. 

Place, publisher, year, edition, pages
2012. , 36 p.
National Category
Computer Science
Identifiers
URN: urn:nbn:se:lnu:diva-20608OAI: oai:DiVA.org:lnu-20608DiVA: diva2:538537
Subject / course
Computer Science
Educational program
Web Development Programme, 120 credits
Uppsok
Technology
Supervisors
Examiners
Available from: 2012-08-15 Created: 2012-06-29 Last updated: 2012-08-15Bibliographically approved

Open Access in DiVA

No full text

Search in DiVA

By author/editor
Millgårdh, CarolineForsmo, FredrikKuoppa, MartinJohansson, Joakim
By organisation
School of Computer Science, Physics and Mathematics
Computer Science

Search outside of DiVA

GoogleGoogle Scholar

urn-nbn

Altmetric score

urn-nbn
Total: 133 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