Figure 1 - available via license: Creative Commons Attribution-NonCommercial 4.0 International
Content may be subject to copyright.
Source publication
p class="Text"> Number of active researchers and experts, are engaged to develop and implement new mechanism and features in time varying database management system (TVDBMS), to respond to the recommendation of modern business environment..Time-varying data management has been much taken into consideration with either the attribute or tuple time st...
Contexts in source publication
Context 1
... have selected the more commonly used for database design; it is composed of properties, class, association, etc. Different types of relationships between classes can be established: aggregation, composition, association, inheritance. Figure 1 presents the class diagram modeling data of employee Management System in a business company. This model will be used in the examples presented along this paper. ...
Context 2
... 1: Classes Employee and Department have 1: N association relationship (see Fig 1). This typical example is adapted to suit our valid time support at the attribute timestamping level. ...
Context 3
... these two tables, each valid time period is a closed-open interval [Vt-start, Vt-End). Example 2: Classes employee and project have N: N association relationship (see Fig 1). The references of one class together with the relationships will be mapped as a collection in another class ...
Context 4
... 3: Type Department is the aggregation of type location department (see Figure 1). The latter type can still exist outside type department, probably in another class. ...
Citations
... Soumiya et al [14] presented an approach for a comparative analysis of the migration to the relational database of the time object. The study attempts to create formalized steps, involved in the transformation from UML class diagrams into temporal Objectrelational database (TORDB) handling a valid time at attributes. ...
The primordial part of realizing a computer system is conceptual modelling, which has met with great success in relational database design using an ER model. Unfortunately, with the development of the computer field, relational databases confronted shortcomings in their applications and the object-relational model became used more and more. The tools of presenting conceptual modelling do not support all new concepts introduced by such models and the syntax of the SQL4 language. This paper aims to survey the previous works and various proposals on how to create rules for designing the object-relational (O-R) database to indicate their strengths and limitations. The paper provides a comprehensive explanation and evaluation of the existing approaches and the possibility of transferring all data semantics and relationships. This work demonstrates the importance and difficulty of these guidelines and discusses many previous works in this field. This paper confirms that modern technologies and new databases play an important role in the success of software design.
... UML class models typically represent database schemas, making the conversion between the two a crucial stage in development. The Unified Modeling Language class diagram (UML) has evolved into an industry standard for modeling time-varying data from the real world into objects (Soumiya and Mohamed, 2017), emphasizing the importance of converting UML class models into database schemas. However, manually translating UML class models into a database design can be time-consuming and error-prone, highlighting the need for efficient and reliable conversion methods. ...
This study aims to create a method for transforming a Unified Modeling Language (UML) class model into an open-source end-user database. The manual transformation of UML class models into a database can be time-consuming and prone to errors. By making a database schema from a UML class model in standard XMI format, our framework offers an automated alternative and makes the transformation more useful. The tool gets the tables, attributes, and connections that compose the schema from the class model's classes, properties, and relationships. The tool also has an abstract RESTful web service component to give the newly made database a web interface. Such a tool will make it easier for software engineers with less experience, especially students, to learn and use UML class models. We implemented the framework for a Baserow end-user database and evaluated it on a student internship use case. The accompanying code is available as an open-source GitHub repository.
... It is a diagram-based modelling language and is used to describe the interaction between user and object [21]. As for [22], class diagram of UML has becoming a standard of HTML5 and CSS are used to create and to style the user interface of this system. However, PHP is used to manage data transfer from the interface to the database of the system. ...
Document tracking which involves recording and monitoring the movement of documents has been a time-consuming task for staff. Dislocation and overlooking of the timeline have always been the problems in document control. An effective tool such as a web-based system is the easiest way to be implemented in the workplace. The Accreditation Document Tracking System (ADTS) is designed to monitor the movement and timeline of the document from a department to another department throughout the accreditation process efficiently. The main objective of this project is to develop a system that can track the location of a document and its status of submission at every stage. This advantageous system is developed through scrum approach, which is the most widespread agile methodology used in the industry. It offers flexibility and simplicity to the system developer in upgrading the system. Furthermore, the Unified Modelling Language (UML) is used to describe the interaction between user and proposed system. UML consists of three visual diagrams: (i) Use case diagram, (ii) activity diagram, and (iii) sequence diagram. By following each stage of the diagrams, the proposed system is able to be developed in order to achieve the objective of this project within within the university as well Malaysian Qualification Agency (MQA) and Ministry of Higher Education (MOHE).
... Scholars have used UML to construct models related to time and space. By expanding UML, the temporal data model based on UML is obtained [17] [18]. Christensen et al. discussed about the spatiotemporal characteristics and roles of geographic objects through the modeling of geographic data by the Danish National Survey and Cadastral Service (KMS) [19]. ...
With the wide application of spatiotemporal data, more and more data need to be modeled. Fuzziness is one of the important characteristics of spatiotemporal data, but most of the existing spatiotemporal data models are regarded as accurate data and most of the spatiotemporal data models are static. The purpose of this paper is to build a fuzzy spatiotemporal data model based on UML by expanding the standard modeling language UML. On this basis, the historical topological state, effective time and transaction time are added to make the model dynamic, that is, the states of multiple times are combined together to form a timeline to represent the development process of a fuzzy spatiotemporal entity. Considering the fuzziness of data and the dynamic development of objects, the model can describe the fuzzy spatiotemporal objects better, and make the model dynamic. At the same time, the operation of UML class diagram is added to make the model data exercisable and compared according to their own needs, which increases the practicability of the model. Finally, an example of land desertification in Alashan is given, to prove the practicability of the model constructed in this paper.
... The literature on temporal database offers three dimensions of time for temporal data support: transaction time, valid time and bitemporal data which support the both. Bitemporal data model our changing knowledge of the changing world, hence associate data values with facts and also specify when the facts are valid [4]. ...
The Conventional data warehouses (DWs) are information repositories specialized in supporting decision making. Since the decisional process requires an analyzing of historical data, DWs systems have been increasingly feeling the need to collect temporal data for accountability and traceability reasons. On the other hand, the temporal object relational Model has been successfully used to handle and maintain past, present and future information. In this paper, we propose a Novel conceptual design for temporal data warehouse (TDW) including bitemporal data. Our solution provides a transformation method into temporal star and snowflake schemas, which incorporate features of object relational data warehouse and integrate Bitemporal data, to meet the requirement of integrating heterogeneous types of data to support decision making with an efficient manner. We have focused on the creation of a conceptual model for designing a temporal object-relational data warehouse based on UML technology and EER (Enhanced entity-relationship) model. The proposed method comprises a Meta Model using UML mechanism to express the varying time data in data warehousing applications that allow easily realizing and transforming the conceptual model into a logical design schema.
... Waterfall SDLC was used because it was simple SDLC [10], systematic, and requirements of text pre-processing library had defined clearly, although today many software development methodology that develop, such as Agile methodology [29]. Then, for modeling the analysis and design, we used Unified Modeling Language (UML), because of UML was suitable for object oriented analysis and design that support modularity to reach flexibility also [30][31]. ...
This study aimed to achieve and measure flexibility as a software quality factor of text pre-processing libraries with Indonesian text from social media. Library was built based on a review of some text mining applications that did not yet have a special pre-process for Indonesian text. Text pre-processing libraries were designed and built using an object-oriented approach that was modular to achieve flexibility. Flexibility was measured by the Mc Call Cyclomatic Complexity (CC) metric. Flexibility of library was tested by implementing the library into text mining applications. The results of experiment showed that text pre-processing libraries could be flexible and easy to use without much configuration in text mining applications. It was proved by the value of CC of 2.51 which meant the library or software was not too complex, simple enough, and also flexible to use. © 2019 Institute of Advanced Engineering and Science. All rights reserved.
Sistem investasi dan literasi keuangan dalam hal pasar modal di Indonesia masih rendah. Hal ini dikarenakan masyarakat Indonesia belum begitu mengenal industri investasi, baik pasar modal dan lainnya dengan baik. Kecenderungan bahwa investasi harus mengeluarkan nominal yang besar berakibat pada terhambatnya literasi keuangan untuk investasi tersebut. Dengan Perkembangan teknologi informasi yang semakin meningkat secara exponensial di era revolusi industri 4.0, maka dibutuhkan sebuah layanan yang mencakup kemudahan akses, bersifat inklusi, dan otomatisasi untuk menjawab permasalahan tersebut. Atas dasar hal tersebut, saya memutuskan untuk melakukan penelitian yang dapat membantu melakukan literasi keuangan kepada masyarakat dengan cara merancang aplikasi perencanaan keuangan dengan instrumen investasi reksadana berbasis progressive web apps menggunakan metode exponential moving average sebagai cara untuk mendapatkan rekomendasi produk reksadana pada saat melakukan transaksi. Aplikasi yang telah dirancang mampu tampil sebagai aplikasi yang user friendly serta dapat memberikan informasi dan pemahaman yang baik tentang industri investasi, sejalan dengan tujuan awal yaitu membantu melakukan literasi keuangan kepada masyarakat.Kata Kunci: PWA, ASP, Scrum Modul, Exponential Moving Average
In delivering information related to lecture activities at the National University, the Information Systems Study Program has prepared a special website, namely http://si.ftki.unas.ac.id/. The website contains a lot of information about important activities or announcements, it's just that the need for other supporting information makes users have the need to ask further questions regarding the information contained on the website. Actually the Website http://si.ftki.unas.ac.id/ has provided the RoomChat feature for question and answer sessions between admin and users, but this feature is still ineffective, such as there is a time lag between questions and responses or unable to provide services for 24 jam. In this study, the authors wanted to design the chatbot feature using the waterfall method, which was carried out sequentially starting from the planning, analysis, design, implementation, testing to maintenance stages. While working on the application, this chatbot was created using the Codeigniter framework with the mysqli database. This chatbot feature will result in a more interactive question and answer session, so that two-way communication with users can run smoothly.
In software modeling, UML (Unified modeling language) receives increasing attention from designers of real-time systems in software development. The emergence of temporal database calls for new visual and efficient modeling techniques to facilitate the design of temporal objects. Even though UML is not currently equipped to manage this task, UML and extended extension offered limited means to express time-varying data and temporal constraints over the dynamic behavior of temporal objects. Therefore, the object constraint language (OCL) plays an important role in the elaboration of the correct conceptual schema that allows the definition of the restrictions and the constraints which contain the duplicate and complex expression. In this paper, we present a UML extension enriched by OCL features and Bitemporal dimension to improve the understandability of a UML/OCL model, and its ability to support the temporal attributes and their evolution. The proposed temporal UML/OCL based on Bitemporal data will be translating into their corresponding in a temporal object-Relational database for the purpose of tracking historical information with an efficient manner. An algorithm has been proposed to automate the transformation from the conceptual schema enriched by bitemporal features to temporal object relational database model by following different steps such as classifying and extracting information about classes, relationships and attributes.
