The topic of the thesis is putting up the application architecture of the organization based othe the actual state, identified requirements, the operational model. The thesis contains description of the business architecture domain, requirements metodology and creation of the operational model of the organization. For the main solution is used the conceptual data model. Application architecture design is presented by the aplication landscape model with the desctiption of the architecture layers and the integration concept including a master data managment concept.

Data are the lifeblood of an organisation, being employed by virtually all business functions within a firm. Data management, therefore, is a critical process in prolonging the life of a company and determining the success of each of an organisation’s business functions. The last decade and a half has seen data warehousing rising in priority within corporate data management as it provides an effective supporting platform for decision support tools. A cross-sectional survey conducted by this research showed that data warehousing is starting to be used within organisations for their engineering asset management, however the industry uptake is slow and has much room for development and improvement. This conclusion is also evidenced by the lack of systematic scholarly research within asset management data warehousing as compared to data warehousing for other business areas. This research is motivated by the lack of dedicated research into asset management data warehousing and attempts to provide original contributions to the area, focussing on data modelling. Integration is a fundamental characteristic of a data warehouse and facilitates the analysis of data from multiple sources. While several integration models exist for asset management, these only cover select areas of asset management. This research presents a novel conceptual data warehousing data model that integrates the numerous asset management data areas. The comprehensive ethnographic modelling methodology involved a diverse set of inputs (including data model patterns, standards, information system data models, and business process models) that described asset management data. Used as an integrated data source, the conceptual data model was verified by more than 20 experts in asset management and validated against four case studies. A large section of asset management data are stored in a relational format due to the maturity and pervasiveness of relational database management systems. Data warehousing offers the alternative approach of structuring data in a dimensional format, which suggests increased data retrieval speeds in addition to reducing analysis complexity for end users. To investigate the benefits of moving asset management data from a relational to multidimensional format, this research presents an innovative relational vs. multidimensional model evaluation procedure. To undertake an equitable comparison, the compared multidimensional are derived from an asset management relational model and as such, this research presents an original multidimensional modelling derivation methodology for asset management relational models. Multidimensional models were derived from the relational models in the asset management data exchange standard, MIMOSA OSA-EAI. The multidimensional and relational models were compared through a series of queries. It was discovered that multidimensional schemas reduced the data size and subsequently data insertion time, decreased the complexity of query conceptualisation, and improved the query execution performance across a range of query types. To facilitate the quicker uptake of these data warehouse multidimensional models within organisations, an alternate modelling methodology was investigated. This research presents an innovative approach of using a case-based reasoning methodology for data warehouse schema design. Using unique case representation and indexing techniques, the system also uses a business vocabulary repository to augment case searching and adaptation. The system was validated through a case-study where multidimensional schema design speed and accuracy was measured. It was found that the case-based reasoning system provided a marginal benefit, with a greater benefits gained when confronted with more difficult scenarios.

Video database applications call for flexible and powerful modeling and querying facilities, which require an integration or interaction between database and knowledge base technologies. It is also necessary for many real life video database applications to incorporate uncertainty, which naturally occurs due to the complex and subjective semantic content of video data. In this thesis study, firstly, a fuzzy conceptual data model is introduced to represent the semantic content of video data. UML (Unified Modeling Language) is utilized and extended to represent uncertain information along with video specific properties at the conceptual level. Secondly, an intelligent fuzzy object-oriented database framework is presented for video database applications. The introduced fuzzy conceptual model is mapped to the presented framework, which is an adaptation of the previously proposed IFOOD architecture. The framework provides modeling and querying of complex and rich semantic content and knowledge of video data including uncertainty. Moreover, it allows (fuzzy) semantic, temporal, (fuzzy) spatial, hierarchical, regional and trajectory queries, based on the video data model. We think that the presented conceptual data model and framework can be adapted to any application domain related to video databases.

Le BIM est actuellement en pleine explosion. Il s'appuie sur la progression des outils informatiques. Toutefois, la gestion de l'information au sein d'un projet d'infrastructure nécessite également l'utilisation de méthodologies et de concepts spécifiques comme les notions de « niveau de détail », de « niveau de développement » ou de « niveau d'abstraction ». Ils servent à décrire l'information pertinente à échanger entre acteurs, selon des objectifs de modélisation, en vue de répondre à des exigences identifiées. Dans le contexte spécifique des projets d'infrastructures, ces outils ne sont mal définis, insuffisants et amènent parfois à des modélisations contradictoires.Dans une optique de progression vers une conception en ingénierie concourante, notre travail de recherche apporte une contribution en deux parties. En se basant sur les principes de l'ingénierie système, la première partie consiste en une méthodologie d'identification des exigences à satisfaire et de l'information pertinente pour y répondre et contrôler cette réponse. La seconde partie décrit le modèle conceptuel de données. Il traite de la structuration des objets qui modélisent le projet en lien avec la structuration des exigences. Cette proposition s'accompagne d'une redéfinition de plusieurs types de niveaux existants (de détail, de développement, d'information, d'abstraction, etc.). Ces éléments sont éprouvés sur un projet d'autoroute en milieu urbain.Les échanges d'informations sont au cœur du BIM. Leur précision ainsi que la qualité des informations échangées participent à la réussite tant technique que managériale du projet.Notre proposition méthodologique permet de faire évoluer les pratiques et le regard que le secteur de la construction porte sur l'information qu'il crée. Elle participe également à la numérisation du secteur de la construction / However, the information management within an infrastructure project (road, rail, airport and other civil engineering works) also requires the use of specific methodologies and concepts like the concepts of ”level of detail” , ”level of development” or ”level of abstraction”. They are used to describe the relevant information that have to be exchanged between stakeholders, according to the modeling objectives in order to meet the project requirements. In the specific context of infrastructure projects, these tools are poorly defined, insufficient and sometimes bring to contradictory models.With a view to progress towards concurrent engineering design, our research is a contribution in two parts. Based on the principles of systems engineering, the first part is about to provide a methodology for requirements and relevant information identification to respond and control this response. The second part describes the project conceptual data model : it deals with the structure of the objects that model in connection with the requirements identification. This proposal is accompanied by a redefinition of several types of existing levels (detail, development, information, abstraction, etc.). These inputs are tested on a project of urban freeway in an industrial context.The exchange of information is at the center of BIM. The accuracy and quality of exchanged information participate in both technical and managerial project success. Our proposed methodology allows to change practices and the vision that the construction sector looks forward to the information it creates. It also participates in the digitalization of the construction sector