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.

The Research of Workflow Engine States

2013 ◽  
Vol 347-350 ◽  
pp. 2236-2240
Author(s):  
Yan Rong Shi ◽  
Tao Hou
Keyword(s):  
Information System ◽  
Full Advantage ◽  
Relational Database ◽  
Database Systems ◽  
Database System ◽  
Workflow Engine ◽  
Relational Database System ◽  
Logical Design ◽  
Relational Database Systems ◽  
The Cost

Based on the analysis of the workflow patterns, this paper designs the active state of the workflow, and puts forward the idea of the logical design of the engine driven. It can conveniently define the information model of the workflow based on relational database systems, it can effectively reduce the difficulty on the technical development of the workflow engine and take full advantage of existing relational database system to realize the information system that has the nature of the workflow and reduce the cost of the implementation.

PORLES: A parallel object-relational database system

2001 ◽  
Vol 6 (1-2) ◽  
pp. 100-109
Author(s):  
Sun Yong-qiang ◽  
Xu Shu-ting ◽  
Zhu Feng-hua ◽  
Lai Shu-hua
Keyword(s):  
Relational Database ◽  
Database System ◽  
Relational Database System ◽  
Object Relational

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.

An Evaluation of Dynamic Electronic Catalog Models in Relational Database Systems

2011 ◽  
pp. 73-90 ◽  
Author(s):  
Kiryoong Kim ◽  
Dongkyu Kim ◽  
Jeuk Kim ◽  
Sang-uk Park ◽  
Ighoon Lee ◽  
...  
Keyword(s):  
Electronic Commerce ◽  
Relational Database ◽  
Relational Databases ◽  
Database Systems ◽  
Relational Schemas ◽  
Electronic Catalogs ◽  
Electronic Catalog ◽  
Software Product ◽  
New Models ◽  
Relational Database Systems

Electronic catalogs are electronic representations about products and services in the electronic commerce environment and require diverse and flexible schemas. Although relational database systems seem to be an obvious choice for their storage, traditional designs of relational schemas do not support electronic catalogs in the most effective ways. Therefore, new models for managing diverse and flexible schemas in relational databases are required for such systems. Proposed in this paper are several models for electronic catalogs using relational tables, and an experimental evaluation of their efficiency. The results of this study can be put to practical use and are, in fact, being applied in the design of a commercial software product.

Object-relational database systems (tutorial)

1997 ◽  
Vol 26 (2) ◽  
pp. 502 ◽  
Author(s):  
Michael J. Carey ◽  
Nelson M. Mattos ◽  
Anil K. Nori
Keyword(s):  
Relational Database ◽  
Database Systems ◽  
Object Relational ◽  
Relational Database Systems

Audio Retrieval Based on Chinese Keyword Search in Relational Databases

2013 ◽  
Vol 756-759 ◽  
pp. 3236-3240
Author(s):  
Bo Yan Zhu ◽  
Guang Liu ◽  
Liang Zhu
Keyword(s):  
Relational Database ◽  
Relational Databases ◽  
Keyword Search ◽  
Database System ◽  
Experimental Results ◽  
Chinese Characters ◽  
Relational Database System ◽  
Audio Retrieval ◽  
Ranking Strategy ◽  
Audio Files

In this paper, we propose a new method based on Chinese keyword search to select the WAV or MP3 files in audio post-production. First, we listen to each file and label it with Chinese characters, and then classify and store the files in a relational database system. Then, we use the techniques of Chinese keyword search to match query characters and the tuple characters quickly, and to compute similarities between the query and candidate tuples. For the characteristics of Chinese keyword search, we present a ranking strategy and an algorithm to refine the candidate tuples resulting from the first round matching, and finally get top-Nresults of audio files. The experimental results show that our method is efficient and effective.

Sign in / Sign up

Export Citation Format

Share Document