Premium Essay

Object-Relational Database Modeling Using Uml

In: Computers and Technology

Submitted By anandak
Words 3708
Pages 15
Running Head: OBJECT-RELATIONAL DATABASE MODELING USING UML

Table of Contents
Introduction……………………………………………………………………………………..4
Overview of ER Modeling and UML…………………………………………………………...4
UML Meta-model……………………………………………………………………………… 6
UML Components………………………………………………………………………………7
UML Data Profile……………………………………………………………………………….9
UML Diagrams……………………………………………………………………………….....10
UML Diagram Classification – Static, Dynamic, and Implementation…....................................12
4+1 View of UML Diagrams……………………………………………………………………13
Object-oriented Class Model and Relational Database Model..............................................…...14
Use of UML to develop Ontologies…………………………………………………………..…17
References……………………………………………………………………………………….19

Abstract
The Unified Modeling Language (UML) is being used as the de-facto standard in the software industry. With the adoption of UML 2.0, the new enhancements allow this version to describe many of the elements found in today's software technology as well as Model Driven Architecture and Service-Oriented Architecture. Many existing software applications involve complex application layer implemented in object-oriented programming languages and at the same time use relational database systems as the back-end data store. Modeling the whole system in a consistent manner will help developers and end users better understand the application.
The Unified Modeling Language (UML) is a standard language for modeling software and database systems. Data model of object-relational databases (ORDBs) is a great challenge to many database applications due to its complexity. UML offers tremendous flexibility and rich expressivity for modeled ORDB system.
This paper shows how to model relational database using UML, how to extend the UML meta-model with elements for modeling relational dependencies, and also presents techniques

Similar Documents

Premium Essay

Information Processing

...DATABASE MODELING AND DESIGN The Morgan Kaufmann Series in Data Management Systems (Selected Titles) Joe Celko’s Data, Measurements and Standards in SQL Joe Celko Information Modeling and Relational Databases, 2nd Edition Terry Halpin, Tony Morgan Joe Celko’s Thinking in Sets Joe Celko Business Metadata Bill Inmon, Bonnie O’Neil, Lowell Fryman Unleashing Web 2.0 Gottfried Vossen, Stephan Hagemann Enterprise Knowledge Management David Loshin Business Process Change, 2nd Edition Paul Harmon IT Manager’s Handbook, 2nd Edition Bill Holtsnider & Brian Jaffe Joe Celko’s Puzzles and Answers, 2 Joe Celko nd Location-Based Services ` Jochen Schiller and Agnes Voisard Managing Time in Relational Databases: How to Design, Update and Query Temporal Data Tom Johnston and Randall Weis Database Modeling with MicrosoftW Visio for Enterprise Architects Terry Halpin, Ken Evans, Patrick Hallock, Bill Maclean Designing Data-Intensive Web Applications Stephano Ceri, Piero Fraternali, Aldo Bongio, Marco Brambilla, Sara Comai, Maristella Matera Mining the Web: Discovering Knowledge from Hypertext Data Soumen Chakrabarti Advanced SQL: 1999—Understanding Object-Relational and Other Advanced Features Jim Melton Database Tuning: Principles, Experiments, and Troubleshooting Techniques Dennis Shasha, Philippe Bonnet SQL: 1999—Understanding Relational Language Components Jim Melton, Alan R. Simon Information Visualization in Data Mining and Knowledge Discovery Edited by Usama Fayyad, Georges G. Grinstein...

Words: 89336 - Pages: 358

Free Essay

Bpmn

...bpmnBPMN and Business Process Management Introduction to the New Business Process Modeling Standard By Martin Owen and Jog Raj, Popkin Software BPMN and Business Process Management Executive Summary ....................................................................................... 3 Introducing BPMN .......................................................................................... 4 BPMN Enables Business Process Management (BPM)......................................... 4 BPMI.ORG Created to Establish BPM Standards ............................................. 4 Rigor of the BPMI.ORG Standards ............................................................... 5 BPMN Enables Modeling of B2B and B2C ......................................................... 5 BPMN Maps to Business Execution Languages.................................................. 5 BPMI.ORG Works with OASIS for e-Business Standards.................................. 5 BPMN Models Web Services .......................................................................... 6 A First Look at BPMN ...................................................................................... 7 Modeling Business Events ............................................................................. 8 More Complex Events -- Specifying Trigger Types ......................................... 8 Business Processes, Sub-Processes, and Tasks ...............................................10 Decomposing Your Processes Into...

Words: 6646 - Pages: 27

Premium Essay

Databases

...Why Normalization Failed to Become the Ultimate Guide for Database Designers? Marin Fotache Alexandru Ioan Cuza University of Iasi, Romania Faculty of Economics and Business Administration Dept. of Business Information Systems Blvd. Carol I, nr. 22, Iasi, 700505, Romania Tel: + 40 744 497 654, Fax: + 40 232 217 000 fotache@uaic.ro ABSTRACT With an impressive theoretical foundation, normalization was supposed to bring rigor and relevance into such a slippery domain as database design is. Almost every database textbook treats normalization in a certain extent, usually suggesting that the topic is so clear and consolidated that it does not deserve deeper discussions. But the reality is completely different. After more than three decades, normalization not only has lost much of its interest in the research papers, but also is still looking for practitioners to apply it effectively. Despite the vast amount of database literature, comprehensive books illustrating the application of normalization to effective real-world applications are still waited. This paper reflects the point of 1 view of an Information Systems academic who incidentally has been for almost twenty years a practitioner in developing database applications. It outlines the main weaknesses of normalization and offers some explanations about the failure of a generous framework in becoming the so much needed universal guide for database designers. Practitioners might be interested in finding out (or confirming)...

Words: 12110 - Pages: 49

Premium Essay

Testing

...Good Data Definitions.” Database Programming & Design 2 (8) (1989): 36–39. Booch, G. Object-Oriented Analysis and Design with Applications. 2d ed. Redwood City, CA: Benjamin Cummings, 1994. Bruce, T. A. Designing Quality Databases with IDEF1X Information Models. New York: Dorset House, 1992. Chen, P. P-S. “The Entity-Relationship Model—Toward a Unified View of Data.” ACM Transactions on Database Systems 1 (March 1976): 9–36. Codd, E. F. “A Relational Model of Data for Large Relational Databases.” Communications of the ACM 13 (6) (1970): 77–87. Dutka, A. F., and H. H. Hanson. Fundamentals of Data Normalization. Reading, MA: Addison-Wesley, 1989. Finkelstein, R. “Breaking the Rules Has a Price.” Database Programming & Design 1 (June 1988): 11–14. Fleming, C. C., and B. von Halle. “An Overview of Logical Data Modeling.” Data Resource Management 1 (1) (1990): 5–15. Fowler, M. UML Distilled: A Brief Guide to the Object Modeling Language. 2d ed. Reading, MA: Addison-Wesley, 2000. Gibson, M., C. Hughes, and W. Remington. “Tracking the Trade-Offs with Inverted Lists.” Database Programming & Design 2 (January 1989): 28–34. Gottesdiener, E. “Turning Rules into Requirements.” Application Development Trends 6 (7) (1999): 37–50. Hay, D. Data Model Patterns: Conventions of Thought. New York: Dorset House, 1996. Hoffer, J. A., V. Ramesh, and H. Topi. Modern Database Management. 10th ed. Upper Saddle River, NJ: Prentice Hall, 2011. Inmon, W. H. “Using the Generic Data Model...

Words: 356 - Pages: 2

Premium Essay

Using Uml to Model System

...I. INTRODUCTION This IDoc describes use of the Unified Modeling Language (UML) to model and document Accounting Information Systems (AIS). The objective of modeling AIS is multifaceted and can be to: visualize, understand, summarize, detail, analyze, design, develop, implement, operate, secure, control, or audit the AIS. UML is a powerful modeling language and technique for all of these modeling tasks and is more robust and semantically superior to the commonly used Structured Analysis (SA) modeling tools of flowcharts (FC), data flow diagrams (DFD), and entity-relationship diagrams (ERD). Dr. White suggests that using UML diagrams as a tool to document AIS is a viable alternative to the Structured Analysis’s diagrams of FC, DFD, and ERD. What follows in Section II is a brief comparison of the two alternative approaches to systems documentation: Structured Analysis (SA) and Object Orientation (OO). Section III presents the definition and description of the major structural and behavioral elements used in UML including classifiers, instances, relationships, collaborations, activities, interactions, and states. Section IV discusses the organization and presentation of UML documentation of AIS as a collection of diagrams and packages. Section V contains various UML diagrams of the business revenue cycle (system) as examples of how to use UML to document a business system. Section VI contains examples of UML models of two special systems of great importance to accountants:...

Words: 9812 - Pages: 40

Free Essay

Digital Marketing

...web-based application Software Developed in IMB WEBSPHERE using JSP as front end on Pentium machine. The main aim of Online Shopping is to improve the services of Customers and vendors. It maintains the details of customer payments, product receipts, addition of new customers, products and also updating, deletion for the same. It also stores the details of invoices generated by customer and payments made by them with all Payments details like credit card. The primary features of online shopping are high accuracy, design flexibility and easy availability. It uses database tables representing entities and relationships between entities. 1.2 OBJECTIVE OF ONLINE SHOPPING The system is capable of maintaining details of various customers, vendors, Products and storing all the day to day transactions such as generation of shipment address bills, handling customers and product receipts, updating of stores The central concept of the application is to allow the customer to shop virtually using the Internet and allow customers to buy the items and articles of their desire from the store. The information pertaining to the products are stores on an RDBMS at the server side (store). The Server process the customers and the items are shipped to the address submitted by them. 1 The application was designed into two modules 1. Buy module 2. Database module The Buy module is used for the customers who wish to buy the articles. The database module is for the storekeepers who maintains and updates...

Words: 4558 - Pages: 19

Free Essay

Web Based Hotel Management System

...Information A hotel is an establishment that provides lodging paid on a short-term basis. The provision of basic accommodation, in times past, consisting only of a room with a bed, a cupboard, a small table and a washstand has largely been replaced by rooms with modern facilities For the purpose of this work a guest house is (also guesthouse) is a kind of lodging. In some parts of the world a guest house is similar to a hostel, bed and breakfast, or inn whereas in other parts of the world (such as for example the Caribbean), guest houses are a type of inexpensive hotel-like lodging and a hotel is a commercial establishment providing lodging, meals, and other guest services, both of which can be used interchangeably For this Project I would be using The Covenant University Guest House as my case study The Covenant University Guest house has 80 rooms which are divided into three categories; Executive deluxe rooms, mini suits and standard rooms. All rooms have intercoms, internet services and satellite television, it has a standard restaurant serving continental and national dishes,24hours room service, a mini mart, a gymnasium, laundry service with modern dry cleaning equipment, 3 large halls for exhibitions and conferences and a large secure cark park The Covenant University Guest house has 5 departments namely: 1. Housekeeping department 2. Laundry department 3. F&B(Food and Beverage) department 4. Accounting department 5. Front office department Front office...

Words: 5965 - Pages: 24

Free Essay

United Irlines

...chetanp201@gmail.com (562)-277-5833 • PROFESSIONAL SUMMARY: • Over 7+ years of experience in analysis, design, development and maintenance of detailed software modules and Web-based applications using expertise in Java, JSP, Servlets, Struts 2.0, spring and Hibernate. • Expertise in design and development of various web- and enterprise-level applications using Java and J2EE technologies like spring, Hibernate, JSP, Servlets, JDBC, HTML, Struts, JavaScript, Servlets, JavaBeans, CSS, Oracle. • Experience in J2EE design patterns such as Business Delegate, Service Locator, Data Transfer Object, Data Access Object, Session Facade, Factory method, Singleton pattern, Front Controller, View Helper, Composite view, MVC, DAO, DTO and Service Locator. • Good experience in working on XML, XSLT, XSL, JAXB, XML Beans and Castor. • Well Versed with SDLC, Waterfall, Agile Methodologies, Rally and JIRA tools. • Strong knowledge in Object Oriented Concepts, Object Oriented Design (OOD), Object Oriented Analysis (OOA), Programming and its implementation. • Experience in using Java IDE tools like Net beans and familiarity with other IDEs such as Eclipse. • Experience in using MySQL databases to write complex SQL queries, and familiarity with databases like SQL. • Proficient in developing and deploying applications on Servers Weblogic, JBoss, and Tomcat. • Extensively used JUnit, TestNG for unit testing and Log4J, SLF4J for logging.
 • Experience...

Words: 1168 - Pages: 5

Free Essay

Virtual Reality

... Conceptual Modeling for Virtual Reality Olga De Troyer, Frederic Kleinermann, Bram Pellens, and Wesley Bille WISE Research Lab Vrije Universiteit Brussel Pleinlaan 2, B-1050 Brussel, Belgium {olga.detroyer,frederic.kleinermann,bram.pellens, Wesley.Bille}@vub.ac.be Abstract This paper explores the opportunities and challenges for Conceptual Modeling in the domain of Virtual Reality (VR). VR applications are becoming more feasible due to better and faster hardware, and due to new technology and faster network connections they also start to appear on the Internet. However, the development of such applications is still a specialized, time-consuming and expensive process. By introducing a Conceptual Modeling phase into the development process of VR applications, a number of the obstacles preventing a quick spread of this type of applications can be removed. However, existing Conceptual Modeling techniques are too limited for modeling a VR application in an appropriate way. The paper will show how Conceptual Modeling can be done for VR and how this may make VR more accessible to non VR-specialists. Furthermore, the paper will explain how Conceptual Modeling embedded in a semantic framework can provide the basis for semantically rich VR application, which may be essential for its success in the future and its use in the context of the Semantic Web. The paper will also point to some open research problems.. Keywords: Semantics. Virtual Reality, Conceptual Modeling, that the...

Words: 13392 - Pages: 54

Premium Essay

Thesis

...FACULTY OF MATHEMATICS AND NATURAL SCIENCE. 4. PROPOSED DEGREE: M. Sc. (INFORMATIC SCIENCE) 5. TITLE: Object-Oriented Systems Analysis and Design: a case of District Health Information System, Mozambique. TABLE OF CONTENTS ABSTRACT i INTRODUCTION 1 RELEVANT FINDINGS (LITERATURE REVIEW) 2 OBJECT-ORIENTED SYSTEMS ANALYSIS AND DESIGN 2 THE RESEARCH PROBLEM AND WHY THIS PROBLEM AREA 5 THE RESEARCH QUESTIONS 5 RESEARCH OBJECTIVES 6 TARGET GROUP 7 PERSONAL MOTIVATION 7 METHODOLOGY 7 BIBLIOGRAPHY: 13 ABSTRACT Many organisations are relying on software systems. Thus these organisations spend a lot of money on software systems and, to get a return on that investment, the software must be usable for a number of years. For many organisations, introducing new software implementation from scratch is a risk. This is because their requirements are not well defined or they don’t have enough expertise to understand and identifies software that can fit their problems. So, many organisations adopt software. That means they take analogy software (software developed for another organisation with the some similarities) and adopt it to fit their needs. In my research, I want to address the problems of adopting systems developed in the functional-oriented methodology and propose object-oriented systems analysis and design methodology. Mainly I would like to assess the flexibility of the structure of software...

Words: 3840 - Pages: 16

Premium Essay

Ssssssss.Docx

...DEPARTMENT OF INFORMATICS – FACULTY OF MATHEMATICS AND NATURAL SCIENCE. 4. PROPOSED DEGREE: M. Sc. (INFORMATIC SCIENCE) 5. TITLE: Object-Oriented Systems Analysis and Design: a case of District Health Information System, Mozambique. TABLE OF CONTENTS ABSTRACT i INTRODUCTION 1 RELEVANT FINDINGS (LITERATURE REVIEW) 2 OBJECT-ORIENTED SYSTEMS ANALYSIS AND DESIGN 2 THE RESEARCH PROBLEM AND WHY THIS PROBLEM AREA 5 THE RESEARCH QUESTIONS 5 RESEARCH OBJECTIVES 6 TARGET GROUP 7 PERSONAL MOTIVATION 7 METHODOLOGY 7 BIBLIOGRAPHY: 13 ABSTRACT Many organisations are relying on software systems. Thus these organisations spend a lot of money on software systems and, to get a return on that investment, the software must be usable for a number of years. For many organisations, introducing new software implementation from scratch is a risk. This is because their requirements are not well defined or they don’t have enough expertise to understand and identifies software that can fit their problems. So, many organisations adopt software. That means they take analogy software (software developed for another organisation with the some similarities) and adopt it to fit their needs. In my research, I want to address the problems of adopting systems developed in the functional-oriented methodology and propose object-oriented systems analysis and design methodology. Mainly I would like to assess the flexibility of the structure of software and the development...

Words: 3842 - Pages: 16

Premium Essay

Lecture

...Database Modeling and Design: Logical Design 4th Edition Toby Teorey, Sam Lightstone, Tom Nadeau Lecture Notes Contents I. Introduction ................................................................………...……2 Relational database life cycle 3 Characteristics of a good database design process 6 II. The Entity-Relationship (ER) Model …………...……………….7 Basic ER concepts 7 Ternary relationships 11 III. The Unified Modeling Language (UML)………...…………….13 Class diagrams 13 Activity diagrams 19 Rules of thumb for UML 21 IV. Requirements Analysis and Conceptual Data Modeling….…..22 Requirements analysis 22 Conceptual data modeling 24 View integration methods 25 Entity Clustering 30 V. Transforming the Conceptual Model to SQL…………...………32 VI. Normalization and normal forms ………………………………38 First normal form to third normal form (3NF) and BCNF 38 3NF synthesis algorithm (Bernstein) 43 VII. An Example of Logical Database Design………………………48 VIII. Business Intelligence………………………………..……….....52 Data warehousing 52 On-line analytical processing (OLAP) 58 IX. CASE Tools for Logical Database Design……………………….60 I. Introduction Introductory Concepts data—a fact, something upon which an inference is based (information or knowledge has value, data has cost) data item—smallest named unit of data that has meaning in the real world (examples: last name, address, ssn, political...

Words: 8116 - Pages: 33

Premium Essay

Pt2520

...14. 15. 16. 17. data entry forms The _____ data model is a tool for constructing data models. entityrelationship A _____ is a self-describing collection of integrated records. database 21. _____ is an example of a personal DBMS. access 22. _____ is the process of converting a data model into tables, relationships, and data constraints. database design 23. The _____ problem is unique to a multiuser database environment. lost-update _____ show data in a structured context. reports A ______ is a collection of forms, reports, queries, and programs that process a database. database application ______ is a popular enterprise DBMS. DB2 ______ is the most popular diagramming tool for database applications. E-R 27. ______ is the process of converting a poorly structured table into two or more well-structured tables. normalization 28. ______ process logic that is specific to a given business record. application programs ______ softwares assist in creating, maintaining, and manipulating databases. DBMS A(n) _____ DBMS is designed to process large organizational and workgroup databases. enterprise A(n) _____ is a column or group of columns that identifies a unique row in a table. key All the following steps involved in transforming a data model into a relational database design except _____. each attribute of the entity becomes a row of the table Applications use DBMS for all of the following operations except _____ data. exchange 20. 24. 25. 26...

Words: 1054 - Pages: 5

Premium Essay

Database Design

...CIS 510 DATABASE DESIGN (WEEK 2) Submitted by: ShaileshwarParimala Arshad Ahmed Mohammed Mohammed WajahathHussain SajjadHussain Syed Uma Devi Singam Types of Database Management Systems A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. [pic] Advantages of DBMS: • Data abstraction and independence • Data security • A locking mechanism for concurrent access • An efficient handler to balance the needs of multiple applications using the same data • The ability to swiftly recover from crashes and errors, including restartability and recoverability • Robust data integrity capabilities • Logging and auditing of activity • Simple access using a standard application programming interface (API) • Uniform administration procedures for data Another advantage of a DBMS is that it can be used to impose a logical, structured organization on the data. A DBMS delivers economy of scale for processing large amounts of data because it is optimized for such operations. A DBMS can also provide many views of a single database schema. A view defines what data the user sees and how that user sees the data. The DBMS provides a level of abstraction between the conceptual schema that defines the logical structure of the database and the physical schema that describes the...

Words: 2693 - Pages: 11

Premium Essay

Database Management System

...DATABASE S YSTEMS DESIGN, IMPLEMENTATION, AND MANAGEMENT CARLOS CORONEL • STEVEN MORRIS • PETER ROB Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Database Systems: Design, Implementation, and Management, Ninth Edition Carlos Coronel, Steven Morris, and Peter Rob Vice President of Editorial, Business: Jack W. Calhoun Publisher: Joe Sabatino Senior Acquisitions Editor: Charles McCormick, Jr. Senior Product Manager: Kate Mason Development Editor: Deb Kaufmann Editorial Assistant: Nora Heink Senior Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Product Manager: Matthew Hutchinson Senior Art Director: Stacy Jenkins Shirley Cover Designer: Itzhack Shelomi Cover Image: iStock Images Media Editor: Chris Valentine Manufacturing Coordinator: Julio Esperas Copyeditor: Andrea Schein Proofreader: Foxxe Editorial Indexer: Elizabeth Cunningham Composition: GEX Publishing Services © 2011 Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted...

Words: 189848 - Pages: 760