Modeling of Business Rules for Active Database Application Specification

Author(s):  
Youssef Amghar ◽  
Madjid Meziane ◽  
Andre Flory

Active database applications require the classic cycle of analysis, design, prototyping and implementation. During analysis and design steps of the information system engineering process, modeling behavior is an important task. This task is both essential and crucial when information system is centered on active databases, which allow the replacement of parts of application programs with active rules. For that reason, the specification of business rules during analysis and design steps becomes an actual requirement. Business rules ensure the well-functioning of information system. They are descriptive (integrity constraints) or functional (derivation rules and active rules). To relieve programmers from using either traditional or ad hoc techniques to design active databases, it is necessary to develop new techniques to model business rules. These techniques have to enhance the specification of dynamic aspect through a high-level description language able to express precisely and completely rule semantic. In this chapter, we propose a uniform approach to model business rules (active rules, integrity constraints, etc.). To improve the behavior specification we extend the state diagrams that are widely used for dynamic modeling. This extension is a transformation of state transitions according to rule semantics. In addition, we outline new functionalities of Computer-Aided System Engineering (CASE) to take into consideration the active database specificities. In this way, the designer can be assisted to control, maintain and reuse a set of rules.

Author(s):  
Youssef Amghar ◽  
Madjid Meziane ◽  
Andre Flory

Modeling behavior is an important task of the information system engineering process. This task is especially important when information systems are centered on active databases, which allow the replacement of parts of application programs with active rules. To relieve programmers from using either traditional or ad hoc techniques to design active databases, it is necessary to develop new techniques to model business rules. For that reason, inclusion of rules during analysis and design stages becomes an actual requirement. In this paper, we propose a uniform approach to modeling business rules (active rules, integrity constraints, etc. ). To improve the behavior specification, we extend the state diagrams that are widely used for dynamic modeling. This extension is a transformation of state transitions according to rule semantics. In addition, we outline new functionalities of Computer Aided System Engineering (CASE) to take into consideration the active database specificities. In this way, the designer can be assisted to control, maintain, and reuse a set of rules.


2002 ◽  
pp. 113-143
Author(s):  
Juan M. Ale ◽  
Mauricio Minuto Espil

This chapter surveys the interaction between active rules and integrity constraints. First, we analyze the static case following the SQL-1999 Standard Committee point of view which, up to date, represents the state of the art. Then, we consider the case of dynamic constraints for which we use a temporal logic formalism. Finally, we discuss the applicability, limitations and partial solutions found when attempting to ensure the satisfaction of dynamic constraints.


2014 ◽  
Vol 5 (1) ◽  
pp. 12-19
Author(s):  
Yohannes Kurniawan ◽  
Janastasha Christie Parapaga

The research goal is to identify and analyze the need of accounting information system related to the revenue cycle at PT XYZ. This paper designing the useful of accounting information systems to support the current business processes, especially on the revenue cycle process. The design method is an Object Oriented Analysis and Design (OOAD) which refers to the modeling and design requirements discipline. And the result achieved by analysis and design of accounting information systems can support current activities of the revenue cycle, especially for the documentation and store of transaction data, and generate reports in accordance with company requirements. Conclusions derived from the analysis and design is the implementation of a webbased application that can help PT XYZ to do the work in different places, such as marketing office, head office and especially at the exhibition. Index Terms - Accounting Information System, revenue cycle, OOAD 


2014 ◽  
Vol 17 (3) ◽  
Author(s):  
Emiliano Reynares ◽  
María Laura Caliusco ◽  
Maria Rosa Galli

The wide applicability of mapping business rules expressions to ontology statements have been recently recognized. Some of the most important applications are: (1) using of on- tology reasoners to prove the consistency of business domain information, (2) generation of an ontology intended to be used in the analysis stage of a software development process, and (3) the possibility of encapsulate the declarative specification of business knowledge into information software systems by means of an implemented ontology. The Semantics of Business Vocabulary and Business Rules (SBVR) supports that approach by provid- ing business people with a linguistic way to semantically describe business concepts and specify business rules in an independent way of any information system design. Although previous work have presented some proposals, an exhaustive and automatable approach for them is still lacking. This work presents a broad and detailed set of transformations that allows the automatable generation of an ontology implemented in OWL 2 from the SBVR specifications of a business domain. Such transformations are rooted on the struc- tural specification of both standards and are depicted through a case study. A real case validation example was performed, approaching the feasibility of the mappings by the quality assessment of the developed ontology.


2020 ◽  
Vol 4 (3) ◽  
pp. 683
Author(s):  
Muhamad Ridho Dwi Cahyo ◽  
Candiwan Candiwan

Yoga Farm is a Micro, Small, and Medium Enterprises (MSME) that focuses on catfish breeding that is still doing business processes manually. With this process, information received by related parties is very difficult to obtain quickly. Therefore, the product is still not widely known, and customers are still few because the system used in sales and promotions still uses a manual system. The research method used is qualitative. This study aims to create a sales information system recommended at Yoga Farm and design using Unified modeling language (UML) for the recommended business processes. Customers will get product information in real-time, products can be widely recognized, and the number of Yoga Farm customers can increase. Based on the results of this study, adoption of a web-based sales information system can certainly make it easier to get the latest information quickly, can expand the market and can also facilitate customers in the transaction. For future research, this research can be used as a reference for conducting similar studies at other MSMEs to increase sales


Author(s):  
Mohammad Subekti ◽  
Raden Bagus Rhesa Dharma Widjaya ◽  
Eileen Heriyanni ◽  
Giovani Dewi

Executive information system (EIS) has been widely used in enterprises and institutions to help the executives make decisions quickly and accurately for the organization's business needs. A research is conducted to create a marketing executive information system that can produce analytic reports and comparison reports for the executive of Benza Prima. For information search the fact finding techniques is utilized by conducting surveys directly to the company to study the company needs and the running procedures. The executive information system design uses Object Oriented Analysis and Design (OOAD) methodology. The research results in an executive information system that produces report in forms of pivot tables and charts to help the Benza Prima executives make decisions. The marketing executive information system design is expected to provide analytic information that can be used by the Benza Prima executive as an analytic tool in planning marketing strategies. 


JURTEKSI ◽  
2019 ◽  
Vol 5 (2) ◽  
pp. 139-146
Author(s):  
Yonky Pernando ◽  
Eka Lia Febrianti ◽  
Andhika Andhika

Abstract: In the era of globalization, information systems are now increasingly developing and are very important and main things in helping the process of corporate performance, in the near future that will make competition in the performance process will be more updated and faster. Because of that the use of information technology and the design of making application programs using Visual Basic 6.0 as programing and MySQL as its database, regarding the analysis and design of information systems for inpatients in anal azimar maternity homes. Problems - problems faced by this company, namely the problem of data redundancy in inputting data, and not presented properly and lead to difficulties when manipulating, changing, and deleting data. In the end the author hopes that with the creation of a new information system, it can help the input process more easily, and quickly. Keywords: Technology, Information, PHP Programming Language , MySQL and Patient   Abstrak: Di era globalisasi sekarang semakin berkembang nya sistem informasi serta merupakan hal yang sangat penting dan utama dalam  membantu proses kinerja perusahaan, dalam waktu dekat yang akan membuat persaingan dalam proses kinerja akan semakin update dan cepat . Karena itu pemakaian teknologi informasi dan rancangan pembuatan program aplikasi dengan menggunakan  Visual Basic 6.0 sebagai programing  dan MySQL  sebagai Databasenya, mengenai analisa dan perancangan sistem informasi pasien rawat inap di rumah bersalin azimar anas. Masalah – masalah yang dihadapi perusahaan ini yaitu masalah redundansi data dalam menginput data,dan tidak tersaji secara baik dan  mengakibatkan kesulitan saat memanipulasi, mengubah, dan menghapus data. Pada akhirnya penulis berharap dengan dibuatnya sistem informasi yang baru, dapat membantu proses input dengan lebih mudah, dan cepat. Kata kunci : Teknologi, Informasi, Bahasa Pemograman Visual Basic 6.0 , MySQL dan Pasien 


Author(s):  
Lusiana Citra Dewi

This study aims to create a system that can simplify common operational activities of pharmacy such as purchasing, inventory, and sales. The system is expected to improve manual processes of purchasing, inventory, and sales into a computerized ones. In addition, this system also provides convenience, accuracy, and speed for owner or management to access reports of purchase, inventory, and sales in real-time. The research methods used are literature studies, field studies, and the methods of analysis and design of object-oriented information system design language UML (Unified Modeling Language). Tthe result of this research is an information system of purchasing, inventory, and sales of medicines that may help pharmacies to get information quickly and accurately, and to help pharmacy operations to run more effectively and efficiently.


Sign in / Sign up

Export Citation Format

Share Document