Partial rollback mechanism has been widely supported by many database management systems (DBMSs). It allows a transaction to be rolled back partially, that is, only back to a certain savepoint set by the user. A partial rollback, however, makes the DBMS buffer management complicated because it requires the DBMS to restore the state of not only the database but also the buffers. There are severa...

Modern enterprise, web, and multimedia applications are generating unstructured content at unforeseen volumes in the form of documents, texts, and media files. Such content is generally associated with relational data such as user names, location tags, and timestamps. Storage of unstructured content in a relational database would guarantee the same robustness, transactional consistency, data in...

The accurate maintainability prediction of relational database-driven software applications can improve the management of projects relating to these applications, thus benefitting software organisations. This paper gives an up-to-date account of the state of practice in maintainability prediction for relational database-driven software applications and provides a baseline for conducting further...

Aggregation is an important concept in database design where composite objects can be modelled during the design of database applications. Therefore, preserving the aggregation concept in database implementation is essential. In this paper, we propose models for implementation of aggregation in an Object-Relational Database Management System (ORDBMS) through the use of index clusters and nested...

XML has become an important medium for data exchange, and is also used as an interface to – i.e. a view of – a relational database. While previous work has considered XML views for the purpose of querying relational databases (e.g. Silkroute), in this paper we consider the problem of updating a relational database through an XML view. Using the nested relational algebra as the formalism for an ...

The purpose of the proposed paper is that analysis of uncertainty and impression handling in fuzzy Relational Data Base by defining the fuzzy relationships between the existing database model to Fuzzy Vague Relational Database Model (FRDBMS) with the help of fuzzy membership function for analysis of the degree of uncertain information of existing data base. Some theoretical properties of the mo...

Object-oriented applications often achieve persistence by using relational database systems. In such setup, objectrelational mapping is used to link objects to tables. Due to fundamental differences between object-orientation and relational algebra, the definition of a mapping is a considerably difficult task. Today, there are only informal guidelines that support engineers in choosing the best...

Entity Class Method Attribute Package Figure 4.1: A simplified meta-model for object-oriented systems. from existing methods. In Figure 4.1 we show a simplified depiction of the meta-model for representing entities from object-oriented systems. The use of an objectoriented language for implementation allows us to hide the fields that describe the entity and define operations by which an entity ...

The relationship between relational databases and formal concept analysis (FCA) has been the topic of several papers in the past. This paper intends to extend some of the ideas presented in the previous papers by analysing the relationship between FCA and two central notions of relational databases: database schemata and normalforms. An object-relational algebra is suggested in this paper as a ...

In the 1970’s, the relational data model was the focus of much of the research in the database area. At this point, relational database technology is well-understood, a number of relational systems are commercially available, and they support the majority of business applications relatively well. One of the foremost database problems of the 1980’s is how to support classes of applications that ...