Object-Relational Modeling

2009 ◽  
pp. 162-170
Author(s):  
Jaroslav Zendulka
Keyword(s):  
Relational Database ◽  
Relational Databases ◽  
Conceptual Modeling ◽  
Object Oriented ◽  
Database Systems ◽  
Object Relational ◽  
The Difference ◽  
Object Oriented Approach ◽  
Entity Relationship ◽  
Oriented Approach

Modeling techniques play an important role in the development of database applications. Well-known entity-relationship modeling and its extensions have become a widely-accepted approach for relational database conceptual design. An object-oriented approach has brought a new view of conceptual modeling. A class as a fundamental concept of the object-oriented approach encapsulates both data and behavior, whereas traditional relational databases are able to store only data. In the early 1990s, the difference between the relational and object-oriented (OO) technologies, which were, and are still used together to build complex software systems, was labeled the object-relational impedance mismatch (Ambler, 2003). The object-oriented approach and the need of new application areas to store complex data have greatly influenced database technology since that time. Besides appearance of object-oriented database systems, which fully implement objectoriented paradigm in a database environment (Catell et al., 2003), traditional relational database management systems become object-relational (Stonebraker & Brown, 1999). The most recent versions of the SQL standard, SQL: 1999 (Melton & Simon (2001) and SQL: 2003 (Eisenberg et al., 2004), introduced object-relational features to the standard and leading database producers have already released packages which incorporate them.

scholarly journals The GSC-I and GSC-II Databases: An Object-Oriented Approach

1998 ◽  
Vol 179 ◽  
pp. 474-477 ◽  
Author(s):  
G. Greene ◽  
B. McLean ◽  
B. Lasker ◽  
D. Wolfe ◽  
R. Morbidelli ◽  
...  
Keyword(s):  
Relational Databases ◽  
Large Scale ◽  
Object Oriented ◽  
Joint Effort ◽  
Current Generation ◽  
Object Oriented Approach ◽  
Guide Star ◽  
Space Telescope Science Institute ◽  
Object Oriented Database ◽  
Oriented Approach

The original GSC-I (Jenkner et al. 1990) which contains 25 million entries and requires approximately 1GB of storage was at the edge of technological capability at the time catalogue construction began in 1984. At that time, a custom coded database was built since the relational databases of the era were unsuited to the HST-specific access requirements. A second generation GSC is now being constructed (Lasker et al. 1995), with an estimated 10 billion entries and a size of 2 Terabytes. The current generation of object-oriented database (OODB) systems are more suited to the needs of large astronomical catalogues and are being adopted by many large-scale projects. In a joint effort between the Space Telescope Science Institute and Osservatorio Astronomico di Torino, we are currently designing such an OODB for the Guide Star Catalogues and are implementing a prototype using the GSC-I data.

scholarly journals The Development and Usage of a Relational Database Design Tool for Educational Purposes

10.28945/3199 ◽  
2008 ◽  
Author(s):  
Milos Bogdanovic ◽  
Aleksandar Stanimirovic ◽  
Nikola Davidovic ◽  
Leonid Stoimenov
Keyword(s):  
Relational Database ◽  
Design Patterns ◽  
Relational Databases ◽  
Conceptual Modeling ◽  
Database Design ◽  
Design Tool ◽  
Relational Model ◽  
Modular Architecture ◽  
Data Definition ◽  
Entity Relationship

Most universities where students study informational technologies and computer science have an introductory course dealing with the development and design of databases. These courses often include usage of database design tools. In this paper, the #EER tool is presented, the task of which is to make the process of relational databases design easier for the students and partially automatize it. The tool evolved due to the experience in using similar tools for educational purposes. It enables fast and efficient development of the relational database conceptual model and its automatized compilation into a relational model and further to data definition language (DDL) commands. #EER tool is based on the extended entity-relationship (EER) model for conceptual modeling of relational databases. Modular architecture of the tool, the development of which is based on the usage of the design patterns, along with the benefits that its usage brings, is also presented.

Towards the Maturity of Object-Relational Database Technology: Promises and Reality

2015 ◽  
Vol 6 (4) ◽  
pp. 1-19 ◽  
Author(s):  
Negin Keivani ◽  
Abdelsalam M. Maatuk ◽  
Shadi Aljawarneh ◽  
Muhammad Akhtar Ali
Keyword(s):  
Relational Database ◽  
Relational Databases ◽  
Database Systems ◽  
Database System ◽  
Relational Database System ◽  
Key Factor ◽  
Object Relational ◽  
Database Technology ◽  
Relational Database Systems ◽  
Additional Object

Object-relational technology provides a significant increase in scalability and flexibility over the traditional relational databases. The additional object-relational features are particularly satisfying for advanced database applications that relational database systems have experienced difficulties. The key factor to the success of object-relational database systems is their performance. This paper aims to review the promises of Object-Relational database systems, examine the reality, and how their promises may be fulfilled through unification with the relational technology. To investigate the performance implications of using object-relational relative to relational technology, the query-oriented BUCKY benchmark has been previously applied to an early object-relational database system, i.e., Illustra 97. This paper presents the results obtained from implementing and running the BUCKY benchmark on Oracle 10g. The results acquired from the work described in this paper are compared with the results obtained in BUCKY benchmark. This study throws light on the functionality of object-relational databases, where object-relational technology has made improvements but some limitations are identified as well. In general, the performance of relational supersedes that of object-relational database system.

An Object-Oriented Approach to Conceptual Hypermedia Modeling

2011 ◽  
pp. 41-54
Author(s):  
Wilfried Lemahieu
Keyword(s):  
Data Model ◽  
Object Oriented ◽  
Implementation Framework ◽  
Object Oriented Approach ◽  
Entity Relationship ◽  
Oriented Approach

This chapter introduces the MESH approach to hypermedia modeling and navigation, which aims at relieving the typical drawbacks of poor maintainability and user disorientation. The main focus is upon the data model, which combines established entity-relationship and object-oriented abstractions with proprietary concepts into a formal hypermedia data model. Uniform layout and link typing specifications can be attributed and inherited in a static node typing hierarchy, whereas both nodes and links can be submitted dynamically to multiple complementary classifications. In addition, the data model’s support for a context-based navigation paradigm, as well as a platform-independent implementation framework, are briefly discussed.

scholarly journals Model Object Relational Database pada Aplikasi Notifikasi Sms

2013 ◽  
Vol 4 (1) ◽  
pp. 302
Author(s):  
Indrajani Indrajani
Keyword(s):  
Programming Languages ◽  
Relational Database ◽  
Object Oriented ◽  
Analysis And Design ◽  
Model Object ◽  
Database Structure ◽  
Object Relational ◽  
Object Oriented Approach ◽  
Application Developers ◽  
Sms Notification

The purpose of this research is to analyse the database using object oriented approach. In addition, this research develops and designs an object relational database structure to make easier the process of searching for the required information. The benefit of this research is to provide a data structure that can be reused for SMS notification application developer team, so that the developers can use existing objects for future use if there are changes in the current business process. The methods used are data collection, analysis, and design. The result obtained from this research is a database structure of sms notification application, which can be used in various programming languages for using object relational database approach. For conclusion, by using the object relational database structure, application developers will be made easier in developing the current database structure. Programmer can add a new data type simply by creating a new object. Data is accessed or processed as object-oriented.

Object-oriented approach

IEE Review ◽  
1990 ◽  
Vol 36 (9) ◽  
pp. 338
Author(s):  
Stephen Wilson
Keyword(s):  
Object Oriented ◽  
Object Oriented Approach ◽  
Oriented Approach
Sign in / Sign up

Export Citation Format

Share Document