Loading...
4 results
Search Results
Now showing 1 - 4 of 4
- Improving information system design: using UML and axiomatic designPublication . Cavique, Luís; Cavique, Mariana; Mendes, Armando; Cavique, MiguelA unified view of the Information System (IS) design is essential for dealing with complexity. However, the literature proposes many denominations, depending on the layer, methodology, framework, or tool. This multitude of approaches does not allow a holistic view of the system. Besides, in Information Systems, the search for good practices in design is still a relevant issue. A subset of essential Unified Modeling Language (UML) diagrams is chosen to create a broad view of the IS. CRUD matrix is one of the preferred approaches to articulate the sub-systems of applications and data. Axiomatic Design (AD) provides rules for the im provement of the IS design. This work presents a method to create object-oriented elements based on the CRUD matrix aligned with the business strategy. An integrated student-based case study on logistics is provided. In the discussion, a new IS architect role is proposed supported by the CRUD/AD method.
- Supply-demand matrix: a process-oriented approach for data warehouses with constellation schemasPublication . Cavique, Luís; Cavique, Mariana; Santos, Jorge M. A.Star schema in data warehouses is a very well-established model. However, the increasing number of star schemas creating large constellations schemas add new challenges in the organizations. In this document, we intend to make a contribution in the technical architecture of data warehouses with constellation schemas using an extension of the bus matrix. The proposed supply-demand matrix details the raw data from the original databases, describes the constellation schemas with different dimensions and establishes the information demand requirements.
- Integration of UML diagrams from the perspective of enterprise architecturePublication . Cavique, Luís; Cavique, Mariana; Mendes, Armando B.An integrated view of the information system has been an objective to deal with complexity. However, bibliography proposes many solutions with many synonyms depending on the layer, methodology, framework or tool used, that does not allow a broad view of the system. In this work we chose three basic elements of the information systems and we demonstrate how they are enough to integrate a set of essential UML diagrams. The proposed model firstly defines a set of UML diagrams for each layer of the Enterprise Architecture, and then heuristic rules are detailed in order to ensure vertical and horizontal alignment.
- Extraction of fact tables from a relational database: an effort to establish rules in denormalizationPublication . Cavique, Luís; Cavique, Mariana; Gonçalves, AntónioRelational databases are supported by very well established models. However, some neglected problems can occur with the join operator: semantic mistakes caused by the multiple access path problem and faults when connection traps arise. In this paper we intend to identify and overcome those problems and to establish rules for relational data denormalization. Two denormalization forms are proposed and a case study is presented.