The methodology of database design in organization management systems

The paper describes the unified methodology of database design for management information systems. Designing the conceptual information model for the domain area is the most important and labor-intensive stage in database design. Basing on the proposed integrated approach to design, the conceptual information model, the main principles of developing the relation databases are provided and user's information needs are considered. According to the methodology, the process of designing the conceptual information model includes three basic stages, which are defined in detail. Finally, the article describes the process of performing the results of analyzing user's information needs and the rationale for use of classifiers

DATABASE APPROACH FOR MULTIPLE-CRITERIA DECISION SUPPORT SYSTEMS

This paper focuses on data management aspects of computerized decision support systems which use interactive multiple criteria decision methods. In this context, we point out the technical requirements for such systems and the importance of the data management tool to MCDSS. After a discussion of candidate data models (i.e. relational, hierarchical, and network), we examine the criteria to use in choosing the data model for MCDSS. In the last part of this paper, we review some database management services which support data definition, data manipulation, and data integrity within the multiple-criteria decision making framework. These services guide us when designing the appropriate architecture for the MCDSSâs data component.Information Systems Working Papers Serie

Building Data Warehouses Using The Enterprise Modeling Framework

Tlds paper proposes an enterprise modeling framework for the deployment of data warehouses. The framework provides the information roadmap coordinating source data and different data warehouses across the business enterprise. The paper introduces a solution to address data warehousing issues at the enterprise level while avoiding the pitfalls of creating enterprise data warehouses and universal data marts. It further proposes a change of paradigm from point solutions focus to a methodology driven by enterprise requirements to meet the challenges of the new economy. The proposed framework emphasizes the separation of the conceptual construct from the physical and operational constructs of an enterprise. It points out the differences and dependencies of analytic and operational processes and how data warehouses and operational data stores respectively support their information requirements. This paper will demonstrate how the enterprise modeling framework for data warehousing can produce business benefits

Multilayered paper prototyping for user concept modeling:Supporting the development of application profiles

This paper describes an investigation of user-centered design methodologies intended to apply to metadata or information architecture evaluation and deployment. The primary focus of this work is investigation of user conceptual models and comparison with formally architected models. We describe related work, primarily from the domain of information architecture, such as free-listing, contextual enquiry, card-sorting and evaluation, and then describes the design, initial evaluation and practical use of a multi-stage prototyping method designed for elicitation of user knowledge and concepts of a domain, common conceptual models in that domain and the objects, collections and relations between objects considered relevant by users. A simple approach to the analysis of results is described

HISTORICAL DATABASES - IT'S ABOUT TIME!

Much recent research in the database community focuses on ways to expand the modelling capabilities of database management systems. The driving force behind this research is the growing size and sophistication of the user community, whose needs and applications seem to always be several steps ahead of the technology. One of the areas where considerable progress has been made in this regard is in the extension of existing data models to represent and manage the temporal dimension of data. In this paper we examine how these enhanced modelling capabilities will increase the functionality of the database management systems of tomorrow. We also introduce the notion of Temporal Representation Transparency as the appropriate abstraction mechanism for providing this increased functionality with minimum burden to the user.Information Systems Working Papers Serie

ЛЕКЦИЯ 4-5. ЧТО ТАКОЕ ОНТОЛОГИИ. ИНЖЕНЕРИЯ ОНТОЛОГИЙ

Базовые понятия. Способы придания смысла понятиям:\ud управляемые словари, таксономии, тезаурусы, онтологии.\ud Онтологии:\ud концептуализация,\ud спецификация,\ud формализация.\ud Инженерия онтологий:\ud жизненный цикл,\ud операции над онтологиями,\ud выводы в онтологии,\ud языки онтологий

Disjunctively incomplete information in relational databases: modeling and related issues

In this dissertation, the issues related to the information incompleteness in relational databases are explored. In general, this dissertation can be divided into two parts. The first part extends the relational natural join operator and the update operations of insertion and deletion to I-tables, an extended relational model representing inclusively indefinite and maybe information, in a semantically correct manner. Rudimentary or naive algorithms for computing natural joins on I-tables require an exponential number of pair-up operations and block accesses proportional to the size of I-tables due to the combinatorial nature of natural joins on I-tables. Thus, the problem becomes intractable for large I-tables. An algorithm for computing natural joins under the extended model which reduces the number of pair-up operations to a linear order of complexity in general and in the worst case to a polynomial order of complexity with respect to the size of I-tables is proposed in this dissertation. In addition, this algorithm also reduces the number of block accesses to a linear order of complexity with respect to the size of I-tables;The second part is related to the modeling aspect of incomplete databases. An extended relational model, called E-table, is proposed. E-table is capable of representing exclusively disjunctive information. That is, disjunctions of the form P[subscript]1\mid P[subscript]2\mid·s\mid P[subscript]n, where ǁ denotes a generalized logical exclusive or indicating that exactly one of the P[subscript]i\u27s can be true. The information content of an E-table is precisely defined and relational operators of selection, projection, difference, union, intersection, and cartisian product are extended to E-tables in a semantically correct manner. Conditions under which redundancies could arise due to the presence of exclusively disjunctive information are characterized and the procedure for resolving redundancies is presented;Finally, this dissertation is concluded with discussions on the directions for further research in the area of incomplete information modeling. In particular, a sketch of a relational model, IE-table (Inclusive and Exclusive table), for representing both inclusively and exclusively disjunctive information is provided