Understanding and managing change is a strategic objective for many organisations to successfully compete in a market place; as a result, organisations are leveraging their data asset and implementing data warehouses to gain business intelligence necessary to improve their businesses. Data warehouses are expensive initiatives, one-half to two-thirds of most data warehousing efforts end in failure. In the absence of well-formalised design methodology in the industry and in the context of the debate on data architecture in data warehousing, this thesis examines why multidimensional and relational data models define the data architecture landscape in the industry. The study develops a number of propositions from the literature and empirical data to understand the factors impacting the choice of logical data model in data warehousing. Using a comparative case study method as the mean of collecting empirical data from the case organisations, the research proposes a conceptual model for logical data model adoption. The model provides a framework that guides decision making for adopting a logical data model for a data warehouse. The research conceptual model identifies the characteristics of business requirements and decision pathways for multidimensional and relational data warehouses. The conceptual model adds value by identifying the business requirements which a multidimensional and relational logical data model is empirically applicable.

This diploma thesis focuses on problematics associated with design of relational database. It is divided into several parts where it deals with theoretical basis, analyses of current state and the design of own solution.

Mine safety is of paramount concern to the mining industry. The generation of a Geographic Information Systems (GIS) which can administrate relevant spatial data and metadata of underground mining safety efficiently is a very vital issue in this sense. In an effort to achieve a balance of safety and productivity, GIS can contribute to the creation of a safe working environment in underground (U/G) mining. Such a system should serve to a continuous risk analysis and be designed for applications in case of emergency. Concept for safety should require three fundamental components, namely (i) constructive safety / (ii) surveillance and maintenance / and (iii) emergency. The implementation has to be carried out in a Web-Based Geographic Information System. The process comprises first the safety concept as the application domain model and then a conceptual model was generated in terms of Entity- Relationship Diagrams. After the implementation of the logical model a user interface was developed and GIS was tested. Finally, one should deal with the question if it is possible to extend the method of resolution used to a national GIS infrastructure.

No description available.

<p>Paralelan i nezavisan rad vi&scaron;e projektanata na različitim modulima (podsistemima) nekog informacionog sistema, identifikovanim saglasno početnoj funkcionalnoj dekompoziciji realnog sistema, nužno dovodi do međusobno nekonzistentnih re&scaron;enja &scaron;ema modula baze podataka. Rad se bavi pitanjima identifikacije i razre&scaron;avanja problema, vezanih za automatsko otkrivanje kolizija, koje nastaju pri paralelnom projektovanju različitih &scaron;ema modula i problema vezanih za integraciju &scaron;ema modula u jedinstvenu &scaron;emu baze podataka informacionog sistema.</p><p>Identifikovani su mogući tipovi kolizija &scaron;ema modula, formulisan je i dokazan potreban i dovoljan uslov stroge i intenzionalne kompatibilnosti &scaron;ema modula, &scaron;to je omogućilo da se, u formi algoritama, prikažu postupci za ispitivanje&nbsp;stroge i intenzionalne kompatibilnosti &scaron;ema modula. Formalizovan je i postupak integracije kompatibilnih &scaron;ema u jedinstvenu (strogo pokrivajuću) &scaron;emu baze podataka. Dat je, takođe, prikaz metodologije primene algoritama za testiranje kompatibilnosti i integraciju &scaron;ema modula u jedinstvenu &scaron;emu baze podataka informacionog sistema.</p> / <p>Parallel and independent work of a number of designers on different information system modules (i.e. subsystems), identified by the initial real system functional decomposition, necessarily leads to mutually inconsistent database (db) module schemas. The thesis considers the problems concerning automatic detection of collisions, that can appear during the simultaneous design of different db module schemas, and integration of db module schemas into the unique information system db schema.</p><p>All possible types of db module schema collisions have been identified. Necessary and sufficient condition of strong and intensional db module schema compatibility has been formu-lated and proved. It has enabled to formalize the process of&nbsp;db module schema strong and intensional compatibility checking and to construct the appropriate algorithms. The integration process of the unique (strong covering) db schema, on the basis of compatible db module schemas, is formalized, as well. The methodology of applying the algorithms for compatibility checking and unique db schema integration is also presented.</p>

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.

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.

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.

This thesis summarizes the information retrieval theory, the relational model basic and focuses on the data indexing in relational database systems. The thesis focuses on multimedia data searching. It includes description of automatic multimedia data content extraction and multimedia data indexing. Practical part discusses design and solution implementation for improving query effectivity for multidimensional vector similarity which describes multimedia data. Thesis final part discusses experiments with this solution.