scholarly journals Extending Uml for Multidimensional Modeling in Data Warehouse

2013 ◽  
pp. 144-149
Author(s):  
Bakul Dhawan ◽  
Anjana Gosain
Keyword(s):  
Unified Modeling Language ◽  
Conceptual Level ◽  
Unified Modeling ◽  
The Past ◽  
Dimensional Modeling ◽  
Multidimensional Databases ◽  
Multidimensional Modeling ◽  
On Line ◽  
Analytical Processing ◽  
The Many

Multidimensional modeling is the foundation of data warehouses, MD databases, and On-Line Analytical Processing (OLAP) applications. Nowadays Dimensional modeling and object-orientation are becoming growing interest areas. In the past few years; there have been many proposals, for representing the MD properties at the conceptual level. However, none of them has been accepted as a standard for conceptual MD modeling. In this paper, we present an extension of the Unified Modeling Language (UML) using a UML profile for multidimensional databases. This profile is composed of a set of stereotypes, constraints and tagged values. We have extended the uml for representing the main multidimensional properties at the conceptual level such as the many-to-many relationships between facts and dimensions, degenerate dimensions, multiple and alternative path classification hierarchies, and nonstrict and complete hierarchies and aggregate fact table.

Applying UML for Designing Multidimensional Databases and OLAP Applications

2011 ◽  
pp. 13-36 ◽  
Author(s):  
Juan Trujillo ◽  
Sergio Lujan-Mora ◽  
Il-Yeol Song
Keyword(s):  
Data Warehouse ◽  
Dynamic Properties ◽  
Unified Modeling Language ◽  
Modeling Language ◽  
Unified Modeling ◽  
Multidimensional Databases ◽  
On Line ◽  
Uml Class Diagram ◽  
Analytical Processing ◽  
Number Of Classes

Multidimensional (MD) modeling is the basis for Data warehouses (DW), multidimensional databases (MDB), and On-Line Analytical Processing (OLAP) applications. In this chapter, we present how the Unified Modeling Language (UML) can be successfully used to represent both structural and dynamic properties of these systems at the conceptual level. The structure of the system is specified by means of a UML class diagram that considers the main properties of MD modeling with minimal use of constraints and extensions of the UML. If the system to be modeled is too complex, thereby leading us to a considerable number of classes and relationships, we sketch out how to use the package grouping mechanism provided by the UML to simplify the final model. Furthermore, we provide a UML-compliant class notation (called cube class) to represent OLAP initial user requirements. We also describe how we can use the UML state and interaction diagrams to model the behavior of a data warehouse system. We believe that our innovative approach provides a theoretical foundation for simplifying the conceptual design of multidimensional systems, and our examples illustrate the use of our approach.

Design and Representation of Multidimensional Models with UML and XML Technologies

2005 ◽  
pp. 50-95
Author(s):  
Juan Trujillo ◽  
Sergio Lujan-Mora ◽  
Il-Yeol Song
Keyword(s):  
Unified Modeling Language ◽  
Xml Schema ◽  
Commercial Application ◽  
Conceptual Level ◽  
Unified Modeling ◽  
Extensible Markup ◽  
Uml Class Diagram ◽  
Analytical Processing ◽  
Multidimensional Models ◽  
Xml Technologies

Data warehouses (DW), multidimensional databases (MDB), and OnLine Analytical Processing (OLAP) applications are based on the Multidimensional (MD) modeling. Most of these applications provide their own MD models to represent main MD properties, thereby making the design totally dependent of the target commercial application. In this chapter, we present how the Unified Modeling Language (UML) can be successfully used to abstract the representation of MD properties at the conceptual level. Then, from this conceptual model, we generate its corresponding implementation into any market OLAP tool. In our approach, the structure of the system is specified by means of a UML class diagram that considers main properties of MD modeling. If the system to be modeled is too complex, we describe how to use the package grouping mechanism provided by the UML to simplify the final model. To facilitate the interchange of conceptual MD models, we provide an eXtensible Markup Language (XML) Schema which allows us to represent the same MD modeling properties that can be considered by using our approach. From this XML Schema, we can directly generate valid XML documents that represent MD models at the conceptual level. Finally, we provide different presentations of the MD models by means of eXtensible Stylesheet Language Transformations (XSLT).

scholarly journals Are we teaching UML according to what IT companies need? A survey on the São Carlos-SP region

2021 ◽  
Author(s):  
João Choma Neto ◽  
Luiz Henrique Ten Caten Bento ◽  
Edson OliveiraJr ◽  
Simone Do Rocio Senger Souza
Keyword(s):  
Unified Modeling Language ◽  
Use Case ◽  
Modeling Languages ◽  
Software Modeling ◽  
Unified Modeling ◽  
Agile Processes ◽  
Universal Language ◽  
Specific Subset ◽  
Development Processes ◽  
The Many

The Unified Modeling Language (UML) arisen intending to unify the many modeling languages and become the universal language for software modeling. Since its creation, more than 25 years have passed. With the growing success of agile methodologies for software development, supported by less modeling and documentation manifest, the use of UML-driven software processes has decreased, thus a specific subset of diagrams has been adopted, such as use case, class, and sequence. On the other hand, in academia, UML is still being taught in Computing courses, most of the time without knowing whether what is taught is what the industry needs for practical use. This paper presents an overview of the UML adoption in IT companies of the region. We analyzed quantitative and qualitative data to support academia at focusing on the most used UML diagrams by practitioners. We constructed a survey composed of 21 questions, distributed to 10 region companies, and we received 24 answers. The results of our study show high usage of UML, including companies adopting agile methods. Certain diagrams are more intensively used, for instance, use case diagrams. The results provide directions to improve UML teaching, focusing on diagrams that best adhere to the development processes employed, in particular, agile processes.

Object-Role Modeling

2010 ◽  
Vol 1 (1) ◽  
pp. 33-57 ◽  
Author(s):  
Terry Halpin
Keyword(s):  
Unified Modeling Language ◽  
Role Modeling ◽  
Modeling Language ◽  
Conceptual Level ◽  
Graphical Notation ◽  
Unified Modeling ◽  
Class Diagrams ◽  
Entity Relationship ◽  
Object Role Modeling ◽  
Business Requirements

Object-Role Modeling (ORM) is an approach for modeling and querying information at the conceptual level, and for transforming ORM models and queries to or from other representations. Unlike attribute-based approaches such as Entity-Relationship (ER) modeling and class modeling within the Unified Modeling Language (UML), ORM is fact-oriented, where all facts and rules are modeled in terms of natural sentences easily understood and validated by nontechnical business users. ORM’s modeling procedure facilitates validation by verbalization and population with concrete examples. ORM’s graphical notation is far more expressive than that of ER diagrams or UML class diagrams, and its attribute-free nature makes it more stable and adaptable to changing business requirements. This article explains the fundamentals of ORM, illustrates some of its advantages as a data modeling approach, and outlines some recent research to extend ORM, with special attention to mappings to deductive databases.

scholarly journals Rancang Bangun Aplikasi Booking Kapal untuk Berwisata & Memancing Berbasis Android

2019 ◽  
Vol 1 (3) ◽  
pp. 213-220
Author(s):  
Fatmawati ◽  
Ahmad Mutedi
Keyword(s):  
Information Needs ◽  
System Development ◽  
Unified Modeling Language ◽  
Application Development ◽  
Literature Study ◽  
Tourist Attractions ◽  
Unified Modeling ◽  
Existing Problems ◽  
Development Life Cycle ◽  
The Many

The development of information technology is increasingly developing, so that makes the human mindset of the desired information needs can be accessed easily, quickly, and accurately. This boat booking is a type of booking that is rarely known by many people and almost everyone only knows about booking hotels, along with the many tourist attractions such as the islands that require tourists to go using the boat to the tourist site, an application is needed to make it easy for tourists to book a ship, from the existing problems for booking and chartering the ship is still done manually by contacting the shipowner directly and for the payment process that is done is still using a manual system that is done after completing using the ship which is feared the charterer can cancel the charter . In this study, the authors used a methodology with data collection techniques namely observation, interviews and literature study while application development uses SDLC (System Development Life Cycle) with a waterfall approach and in this study, the authors used the Fisher-Yates Shuffle algorithm while for modeling using UML (Unified Modeling Language). With the Android-based ship booking application, it can facilitate the tourists in getting information in booking a boat that can be done online.

scholarly journals Modeling Accounting Processes Using UML: The Drifters Example

2001 ◽  
Vol 5 (2) ◽  
pp. 1-12
Author(s):  
David H. Olsen ◽  
Robert J. Mills
Keyword(s):  
Programming Languages ◽  
Business Processes ◽  
Unified Modeling Language ◽  
Object Oriented ◽  
Unified Modeling ◽  
The Past ◽  
Business System ◽  
Database Technology ◽  
Entity Relationship ◽  
Compare And Contrast

This paper includes a comprehensive case that details a simplified business system for the Drifters Snowboard Company. We include a description of the business processes of Drifters relative to the data needs which includes an entity-relationship (ER) dia-gram and a unified modeling language (UML) diagram. Both diagrams are con-structed to compare and contrast each method and to give those that perform modeling tasks a sense of some of the real world issues that are involved.In the past ten years, object-orientation has become viable and important in both the modeling and implementation arenas. Programming languages such as C++ and Java incorporate object-oriented (O-O) features and database management systems (DBMS) such as O2, ObjectStore, Poet, etc. and are advertised as "pure" O-O DBMS. Conversely, some systems such as Oracle, DB2, Sybase, SQL Serve,r etc. have incorporated some O-O features into essentially relational database technology in order to remain competitive.On the modeling dimension, the entity-relationship (E/R) diagramming method with its notable variants has been dominant for more than 20 years. This is probably due to its simplicity and its power to accurately represent the data needs of nearly all applica-tions. In the last 10 years however, O-O modeling has become increasingly popular because it correlates nicely to O-O implementations and because its modeling power is requisite for the greater complexity inherit in contemporary information systems. Re-cently, UML has become the de facto O-O modeling variant, so hence, we illustrate UML in the same case we use ER diagramming. The comparison and contrast is useful to those who are migrating to UML data modeling.

scholarly journals SISTEM PENGAMBLAN KEPUTUSAN PEMILIHAN BIBIT JAGUNG DENGAN METODE ANALYTICAL HIERARCHY PROCESS (AHP) PADA TOKO ABADI JAYA LAMPUNG TIMUR

2018 ◽  
Vol 6 (2) ◽  
pp. 73-80
Author(s):  
Ferly Ardhy
Keyword(s):  
System Development ◽  
Unified Modeling Language ◽  
Activity Diagram ◽  
Corn Seed ◽  
Unified Modeling ◽  
Optimal Decisions ◽  
Development Tool ◽  
The Many ◽  
Development Methods ◽  
Hierarchy Process

AbstracCorn Seed is a very popular commodity crop planted by farmers especially Indonesia because many who use this plant besides many benefits it is also a panga plant. Users usually have difficulty choosing corn seeds that they want to buy because of the many types of corn seeds, soil construction, and prices. So that a decision support system is needed that can help users determine Corn Seed according to the alternatives and desired criteriaIn this study, the method used is the Analitycal Hierarchy Process (AHP), System development methods are made using the Prototyping method using a Unified Modeling Language (UML) system development tool consisting of Use Case, Activity Diagram, Sequence Diagram, and Class Diagram and using the PHP programming language and using the MySql database.This method is used because it is able to choose the best alternative so as to produce optimal decisions in accordance with the specifications and funds owned by the user.

The Past, Present, and Future of UML

2018 ◽  
pp. 7481-7487
Author(s):  
Rebecca Platt ◽  
Nik Thompson
Keyword(s):  
Software Engineering ◽  
Unified Modeling Language ◽  
International Organization ◽  
Modeling Language ◽  
Unified Modeling ◽  
The Past ◽  
International Organization For Standardization ◽  
Industry Standard ◽  
The Future

Since its inception, the Unified Modeling Language (UML) has risen to relative ubiquity in the IT community. However, despite its status as an ISO industry standard (International Organization for Standardization, 2005), the UML is still evolving to accommodate the changing needs of industry. This development aims to ensure that UML remains effective and relevant to the most current developments in software engineering techniques. This article charts the progress of this arguably indispensable standard and discusses the ongoing evolution in three sections: The Past, The Present, and The Future.

scholarly journals QUERYING FUZZY MULTIDIMENSIONAL DATABASES: UNARY OPERATORS AND THEIR PROPERTIES

2003 ◽  
Vol 11 (supp01) ◽  
pp. 31-45 ◽  
Author(s):  
ANNE LAURENT
Keyword(s):  
Query Optimization ◽  
Query Rewriting ◽  
Fuzzy Data ◽  
Multidimensional Databases ◽  
Flexible Queries ◽  
On Line ◽  
Analytical Processing ◽  
On Line Analytical Processing ◽  
Definition Of ◽  
Processing Framework

In this paper, we study the properties of flexible queries in the OLAP (On-Line Analytical Processing) framework, focusing on unary operators. For this purpose, we consider the model we have defined for fuzzy multidimensional databases. This model provides means to handle fuzzy data and flexible queries. The operators defined in this model are closed on the set of fuzzy hypercubes (hereafter cubes), which means that the result of each operator on a fuzzy cube is a cube. Thus, these operators can be nested into expressions. In this paper, the combination of several queries is investigated in order to study the possibility for the definition of an algebra to manipulate fuzzy cubes. This would provide a framework for query rewriting and, as a result, for query optimization.

The Past, Present, and Future of UML

2019 ◽  
pp. 1452-1460
Author(s):  
Rebecca Platt ◽  
Nik Thompson
Keyword(s):  
Software Engineering ◽  
Unified Modeling Language ◽  
Modeling Language ◽  
Unified Modeling ◽  
The Past ◽  
Industry Standard ◽  
The Future

Since its inception, the unified modeling language (UML) has risen to relative ubiquity in the IT community. However, despite its status as an ISO industry standard, the UML is still evolving to accommodate the changing needs of industry. This development aims to ensure that UML remains effective and relevant to the most current developments in software engineering techniques. This chapter charts the progress of this arguably indispensable standard and discusses the ongoing evolution in three sections: the past, the present, and the future.

Sign in / Sign up

Export Citation Format

Share Document