An Evaluation of Dynamic Electronic Catalog Models in 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.

Download Full-text

Graph Encoding and Recursion Computation

Encyclopedia of Information Science and Technology, First Edition ◽

10.4018/978-1-59140-553-5.ch231 ◽

2005 ◽

pp. 1309-1316

Author(s):

Yangjun Chen

Keyword(s):

Relational Database ◽

Relational Databases ◽

Database Systems ◽

Cad Cam ◽

Relational Systems ◽

Relational Database Systems ◽

Novel Applications ◽

General Opinion ◽

Office Systems ◽

Document Databases

It is a general opinion that relational database systems are inadequate for manipulating composite objects that arise in novel applications such as Web and document databases (Abiteboul, Cluet, Christophides, Milo, Moerkotte & Simon, 1997; Chen & Aberer, 1998, 1999; Mendelzon, Mihaila & Milo, 1997; Zhang, Naughton, Dewitt, Luo & Lohman, 2001), CAD/ CAM, CASE, office systems and software management. Especially, when recursive relationships are involved, it is cumbersome to handle them in relational databases, which sets current relational systems far behind the navigational ones (Kuno & Rundensteiner, 1998; Lee & Lee, 1998). To overcome this problem, a lot of interesting graph encoding methods have been developed to mitigate the difficulty to some extent. In this article, we give a brief description of some important methods, including analysis and comparison of their space and time complexities.

Download Full-text

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

International Journal of Technology Diffusion ◽

10.4018/ijtd.2015100101 ◽

2015 ◽

Vol 6 (4) ◽

pp. 1-19 ◽

Cited By ~ 4

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.

Download Full-text

Closing the Gap Between XML and Relational Database Technologies

Open and Novel Issues in XML Database Applications ◽

10.4018/978-1-60566-308-1.ch001 ◽

2010 ◽

pp. 1-27

Author(s):

Mary Ann Malloy ◽

Irena Mlynkova

Keyword(s):

Relational Database ◽

Relational Databases ◽

Database Systems ◽

Data Representation ◽

Xml Data ◽

Advantages And Disadvantages ◽

Closing The Gap ◽

Relational Database Systems ◽

Xml Technologies

As XML technologies have become a standard for data representation, it is inevitable to propose and implement efficient techniques for managing XML data. A natural alternative is to exploit tools and functions offered by relational database systems. Unfortunately, this approach has many detractors, especially due to inefficiency caused by structural differences between XML data and relations. But, on the other hand, relational databases represent a mature, verified and reliable technology for managing any kind of data including XML documents. In this chapter, the authors provide an overview and classification of existing approaches to XML data management in relational databases. They view the problem from both state-of-the-practice and state-of-the-art perspectives. The authors describe the current best known solutions, their advantages and disadvantages. Finally, they discuss some open issues and their possible solutions.

Download Full-text

Set Valued Attributes

Encyclopedia of Database Technologies and Applications ◽

10.4018/978-1-59140-560-3.ch104 ◽

2005 ◽

pp. 632-637 ◽

Cited By ~ 3

Author(s):

Karthikeyan Ramasamy ◽

Prasad M. Deshpande

Keyword(s):

Relational Database ◽

Data Model ◽

Relational Databases ◽

Database Systems ◽

Sql Server ◽

Relational Model ◽

Database Model ◽

Competitive Edge ◽

The Past ◽

Relational Database Systems

About three decades ago, when Codd (1970) invented the relational database model, it took the database world by storm. The enterprises that adapted it early won a large competitive edge. The past two decades have witnessed tremendous growth of relational database systems, and today the relational model is by far the dominant data model and is the foundation for leading DBMS products, including IBM DB2, Informix, Oracle, Sybase, and Microsoft SQL server. Relational databases have become a multibillion-dollar industry.

Download Full-text