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.

Diploma thesis deals with the contemporary object-relational mapping (ORM) technologies for Java. It briefly describes also competing technologies for persisting objects in files, object and object-relational databases. However main part of the thesis is the persistence of objects in relational databases using ORM frameworks. The work begins with studying general methods and issues, that these frameworks have to solve. Next, it chooses and deeply describes some ORM frameworks. They are later demonstrated on the demo application. In the following part there is a description of the problems I have been facing during the implementation of the persistence using these frameworks. Finally, there is an evaluation and a comparison of these frameworks.

The goal of this master's thesis is to acquaint with a problem of a knowledge discovery and objectrelational data classification. It summarizes problems which are connected with mining spatiotemporal data. There is described data mining kernel algorithm SVM. The second part solves classification method implementation. This method solves data mining in a Caretaker trajectory database. This thesis contains application's implementation for spatio-temporal data preprocessing, their organization in database and presentation too.

This work treats the representation of moving objects and operations over these objects. Intro­duces the support for spatio-temporal data in Oracle Database 10g and presents two designs of moving objects database structure. Upon these designs a database was implemented using the user-defined data types. Sample application provides a graphical output of stored spatial data and allows us to call an implemented spatio-temporal operations. Finally, an evaluation of achieved results is done and possible extensions of project are discussed.

This diploma thesis deals with object extensions of Oracle database 10g system and describes access from Java environment.

Parc marin du Saguenay - Saint-Laurent, Groupe de recherche et d'éducation sur les mammifères marins, GREMM, excursions aux baleines, bélugas, Tadoussac, règlementation, ArcCatalog, ArcMap. / L'important volume des excursions de bateaux touristiques liées aux activités d'observation en mer des mammifères marins (AOM) dans le Parc marin Saguenay-Saint-Laurent (PMSSL) pourrait avoir un impact négatif sur la santé des baleines qui fréquentent cette région de l’estuaire du fleuve Saint-Laurent. Cette situation a poussé les gestionnaires du Parc à désirer un outil d'information et de gestion pour mieux suivre l’évolution des AOM. Le présent mémoire décrit la conception de cet outil en proposant un modèle de l'excursion et des activités d'observation qui sert à l’élaboration d’une base de données. En s’appuyant sur le concept de la trajectoire spatiotemporelle, utilisée pour l'étude du comportement de déplacement basé sur l'activité, et sur le concept de l'objet mobile, développé en géomatique, notre modèle de données permet de reproduire graphiquement les trajectoires des excursions et l'enchaînement des activités qui ont lieu au cours de celles-ci. Le modèle est orienté objet et implanté dans une Geodatabase, une base de données relationnelle exploitable par le système d'information géographique (SIG) ArcGIS. Les objets de la base de données sont créés à partir des données de trois années de suivi des AOM réalisés par le Groupe de recherche et d'éducation sur les mammifères marins (GREMM). Nous montrons que le SIG peut exploiter la base de données de façon à répondre correctement aux besoins en information exprimés par les gestionnaires et que la représentation informatique des excursions sous la forme de trajectoires spatiotemporelles ouvre de nouvelles avenues de recherche sur les patrons d’activités et le comportement de déplacement des bateaux. / The considerable volume of commercial boat trips associated with whale-watching activities (WWAs) in the Saguenay-Saint-Laurent National Marine Park (PMSSL) may have negative impacts on the health of the whales visiting the Saint-Lawrence River estuary. This situation has led park officials to seek an appropriate information management system in order to better monitor WWAs. This paper contributes to the design of such a tool by modeling excursion patterns of WWAs, resulting in a database. Based on the space-time path concept used for the study of activity-based travel behavior as well as the mobile-object geomatical concept, our data-model enables us to plot the trajectories of the excursions and the sequence of activities taking place during those excursions. The model is object-oriented and built into a Geodatabase (an ArcGis-processable relational database). The objects in the database are based on data collected by the Marine Mammal Research and Education Group (GREMM) during a three-year WWA monitoring program. Finally, this report demonstrates that geographic information systems can be effectively used to process the database in a way that serves the needs of park officials, and that the representation of excursion data in a GIS opens up new avenues for research on the space-time pattern of observation activities and the travel behavior of boats.

Relational databases are the most popular databases used by enterprise applications to store persistent data to this day. It gives a lot of flexibility and efficiency. A process called database normalization helps make sure that the database is free from redundancies and update anomalies. In a Database-First approach to software development, the database is designed first, and then an Object-Relational Mapping (ORM) tool is used to generate the programming classes (data layer) to interact with the database. Finally, the business logic code is written to interact with the data layer to persist the business data to the database. However, in modern application development, a process called Code-First approach evolved where the domain classes and the business logic that interacts with the domain classes are written first. Then an Object Relational Mapping (ORM) tool is used to generate the database from the domain classes. In this approach, since database design is not a concern, software programmers may ignore the process of database normalization altogether. To help software programmers in this process, this thesis takes the theory behind the five database normal forms (1NF - 5NF) and proposes Five Class Normal Forms (1CNF - 5CNF) that software programmers may use to normalize their domain classes. This thesis demonstrates that when the Five Class Normal Forms are applied manually to a class by a programmer, the resulting database that is generated from the Code-First approach is also normalized according to the rules of relational theory.

<p>Denna rapport presenterar en undersökning av sex olika objekt-relationsmappningsramverk, nämligen Entity Framework, LINQ to SQL, NHibernate, Castle ActiveRecord, MyGeneration Doodads och Subsonic. Undersökningen redogör för styrkor och svagheter hos de olika ramverken samt diskuterar när respektive ramverk är lämpligt att använda.</p><p>De ramverk som bedömdes vara mest intressanta var NHibernate och Entity Framework, då de erbjuder flexibel mappning mellan domänmodellen och det underliggande databasschemat samt god tillgång till dokumentation och litteratur.</p><p>Undersökningen användes som grund för att besluta vilket av de aktuella ramverken som skulle användas vid en omskrivning av en existerande applikation för IT-konsultföretaget Sogeti. Det ramverk som ansågs mest lämpligt för applikationen var NHibernate.</p> / <p>This report presents a study of six different object-relational mapping frameworks, namely Entity Framework, LINQ to SQL, NHibernate, Castle ActiveRecord, MyGeneration Doodads and Subsonic. The study describes the strengths and weaknesses of the various frameworks and discusses when each framework is appropriate to use.</p><p>The frameworks that were judged to be the most interesting were NHibernate and Entity Framework, since they provide flexible mapping between the domain model and the underlying database schema as well as good availability of documentation and literature.</p><p>The study was used as a basis for deciding which of the frameworks that should be used in a rewrite of an existing application for the IT consulting company Sogeti. The framework that was considered the most appropriate for the application was NHibernate.</p>

L'important volume des excursions de bateaux touristiques liées aux activités d'observation en mer des mammifères marins (AOM) dans le Parc marin Saguenay-Saint-Laurent (PMSSL) pourrait avoir un impact négatif sur la santé des baleines qui fréquentent cette région de l’estuaire du fleuve Saint-Laurent. Cette situation a poussé les gestionnaires du Parc à désirer un outil d'information et de gestion pour mieux suivre l’évolution des AOM. Le présent mémoire décrit la conception de cet outil en proposant un modèle de l'excursion et des activités d'observation qui sert à l’élaboration d’une base de données. En s’appuyant sur le concept de la trajectoire spatiotemporelle, utilisée pour l'étude du comportement de déplacement basé sur l'activité, et sur le concept de l'objet mobile, développé en géomatique, notre modèle de données permet de reproduire graphiquement les trajectoires des excursions et l'enchaînement des activités qui ont lieu au cours de celles-ci. Le modèle est orienté objet et implanté dans une Geodatabase, une base de données relationnelle exploitable par le système d'information géographique (SIG) ArcGIS. Les objets de la base de données sont créés à partir des données de trois années de suivi des AOM réalisés par le Groupe de recherche et d'éducation sur les mammifères marins (GREMM). Nous montrons que le SIG peut exploiter la base de données de façon à répondre correctement aux besoins en information exprimés par les gestionnaires et que la représentation informatique des excursions sous la forme de trajectoires spatiotemporelles ouvre de nouvelles avenues de recherche sur les patrons d’activités et le comportement de déplacement des bateaux. / The considerable volume of commercial boat trips associated with whale-watching activities (WWAs) in the Saguenay-Saint-Laurent National Marine Park (PMSSL) may have negative impacts on the health of the whales visiting the Saint-Lawrence River estuary. This situation has led park officials to seek an appropriate information management system in order to better monitor WWAs. This paper contributes to the design of such a tool by modeling excursion patterns of WWAs, resulting in a database. Based on the space-time path concept used for the study of activity-based travel behavior as well as the mobile-object geomatical concept, our data-model enables us to plot the trajectories of the excursions and the sequence of activities taking place during those excursions. The model is object-oriented and built into a Geodatabase (an ArcGis-processable relational database). The objects in the database are based on data collected by the Marine Mammal Research and Education Group (GREMM) during a three-year WWA monitoring program. Finally, this report demonstrates that geographic information systems can be effectively used to process the database in a way that serves the needs of park officials, and that the representation of excursion data in a GIS opens up new avenues for research on the space-time pattern of observation activities and the travel behavior of boats. / Parc marin du Saguenay - Saint-Laurent, Groupe de recherche et d'éducation sur les mammifères marins, GREMM, excursions aux baleines, bélugas, Tadoussac, règlementation, ArcCatalog, ArcMap.

Denna rapport presenterar en undersökning av sex olika objekt-relationsmappningsramverk, nämligen Entity Framework, LINQ to SQL, NHibernate, Castle ActiveRecord, MyGeneration Doodads och Subsonic. Undersökningen redogör för styrkor och svagheter hos de olika ramverken samt diskuterar när respektive ramverk är lämpligt att använda. De ramverk som bedömdes vara mest intressanta var NHibernate och Entity Framework, då de erbjuder flexibel mappning mellan domänmodellen och det underliggande databasschemat samt god tillgång till dokumentation och litteratur. Undersökningen användes som grund för att besluta vilket av de aktuella ramverken som skulle användas vid en omskrivning av en existerande applikation för IT-konsultföretaget Sogeti. Det ramverk som ansågs mest lämpligt för applikationen var NHibernate. / This report presents a study of six different object-relational mapping frameworks, namely Entity Framework, LINQ to SQL, NHibernate, Castle ActiveRecord, MyGeneration Doodads and Subsonic. The study describes the strengths and weaknesses of the various frameworks and discusses when each framework is appropriate to use. The frameworks that were judged to be the most interesting were NHibernate and Entity Framework, since they provide flexible mapping between the domain model and the underlying database schema as well as good availability of documentation and literature. The study was used as a basis for deciding which of the frameworks that should be used in a rewrite of an existing application for the IT consulting company Sogeti. The framework that was considered the most appropriate for the application was NHibernate.