Change search
ReferencesLink to record
Permanent link

Direct link
Intelligent Data Layer:: An approach to generating data layer from normalized database model.
Linnaeus University, Faculty of Science and Engineering, School of Computer Science, Physics and Mathematics.
2012 (English)Independent thesis Advanced level (degree of Master (One Year)), 10 credits / 15 HE creditsStudent thesis
Abstract [en]

Model View Controller (MVC) software architecture is widely spread and commonly used in application’s development. Therefore generation of data layer for the database model is able to reduce cost and time. After research on current Object Relational Mapping (ORM) tools, it was discovered that there are generating tools like Data Access Object (DAO) and Hibernate, however their usage causes problems like inefficiency and slow performance due to many connections with database and set up time. Most of these tools are trying to solve specific problems rather than generating a data layer which is an important component and the bottom layer of database centred applications.

The proposed solution to the problem is an engineering approach where we have designed a tool named Generated Intelligent Data Layer (GIDL). GIDL tool generates small models which create the main data layer of the system according to the Database Model. The goal of this tool is to enable and allow software developers to work only with object without deep knowledge in SQL.

The problem of transaction and commit is solved by the tool. Also filter objects are constructed for filtering the database. GIDL tool reduced the number of connections and also have a cache where to store object lists and modify them. The tool is compared under the same environment with Hibernate and showed a better performance in terms of time evaluations for the same functions. GIDL tool is beneficial for software developers, because it generates the entire data layer.

Place, publisher, year, edition, pages
2012. , 57 p.
Keyword [en]
Object Relational Mapping (ORM), Generated Intelligent Data Layer (GIDL), Relational Database, Microsoft SQL Server, Object Oriented Design Pattern, Model, Model View Controller, High Query Language, Structured Query Language (SQL) and Data Layer.
National Category
Software Engineering Computer Science
URN: urn:nbn:se:lnu:diva-22170OAI: diva2:562206
Subject / course
Computer Science
Educational program
Software Technology Programme, Master Programme, 60 credits
2012-09-26, D1136, Linnaeus University Campus, Vaxjo, Sweden., Växjö, 15:15 (English)
Available from: 2012-10-24 Created: 2012-10-23 Last updated: 2012-10-24Bibliographically approved

Open Access in DiVA

Intelligent Data Layer-Amir Buzo(1818 kB)239 downloads
File information
File name FULLTEXT01.pdfFile size 1818 kBChecksum SHA-512
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Buzo, Amir
By organisation
School of Computer Science, Physics and Mathematics
Software EngineeringComputer Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 239 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: 304 hits
ReferencesLink to record
Permanent link

Direct link