New Directions in Database-Systems Research and Development

In this paper we survey, consolidate, and present the state of the art in database system and we try to specify the most important research possibilities in the data bases. The heart of our analysis is a survey on basic to advanced concepts and their relativity which will give a conclusion of how better performance is expected by integrating those aspects. In addition we described the advantages of parallelism and distribution including the data ware housing approach. This paper reviews all the above mentioned things in a better possible way.The main motto of the paper is how the basic aspects of the data base systems are helpful to lead the systems to advanced mechanism such as parallelism, distribution and handling of the metadata base architectures.

Database Management Systems (DBMSs) are a ubiquitous and critical component of modern computing, and the result of decades of research and development in both academia and industry. Historically, DBMSs were among the earliest multiuser server systems to be developed, and thus pioneered many systems design techniques for scalability and reliability now in use in many other contexts. While many of the algorithms and abstractions used by a DBMS are textbook material, there has been relatively sparse coverage in the literature of the systems design issues that make a DBMS work. This paper presents an architectural discussion of DBMS design principles, including process models, parallel architecture, storage system design, transaction system implementation , query processor and optimizer architectures, and typical shared components and utilities. Successful commercial and open-source systems are used as points of reference, particularly when multiple alternative designs have been adopted by different groups.

Object-oriented …, 1995

The distributed database has undergone and is still going strong significant changes which could be traced due to several trends of influence which may include but not limited to the increasing demand for multimedia services, the view of distributed systems as utility, the emergency of pervasive networking technology, and the emergency of global computing coupled with the desire to support user mobility in distributed systems. Each database in a distributed database system is distinct from all other databases in the system and has its global database name. For large databases, especially for data warehousing, it often becomes impractical to store and/or process data on a single physical computer. The problem is scalability, of which there are two kinds: vertical scalability and horizontal scalability. Distributed Database started its journey with parallel computing after it advanced further to grid computing. And in present development, it creates a new world which is pronounced as Cloud Computing. All these three terminologies have diverse significances on distributed databases. In this term paper, I will discuss the current trends in distributed database systems and the length it has gone to improve from parallel computing to cloud computing with the contemporary role.

2012

The globally integrated contemporary business environment has prompted new challenges to database architectures in order to enable organizations to improve database applications performance, scalability, reliability and data privacy in adapting to the evolving nature of business. Although a number of distributed database architectures are available for choice, there is a lack of an in-depth understanding of the performance characteristics of these database architectures in a comparison way. In this paper, we report a performance study of three typical (centralized, partitioned and replicated) database architectures. We used the TPC-C as the evaluation benchmark to simulate a contemporary business environment, and a commercially available database management system that supports the three architectures. We compared the performance of the partitioned and replicated architectures against the centralized database, which results in some interesting observations and practical experience. The findings and the practice presented in this paper provide useful information and experience for the enterprise architects and database administrators in determining the appropriate database architecture in moving from centralized to distributed environments.

Proceedings 2001 International Database Engineering and Applications Symposium, 2001

Our vision is that hyperdatabases become available that extend and evolve from database technology. Hyperdatabases move up to a higher level, closer to the applications. A hyperdatabase manages distributed objects and software components as well as workjlows, in analogy to a database system that manages data and transactions. In short, hyperdatabases will provide "higher order data independence", e.g., immunity of applications against changes in the implementation of components and workload transparency. Such an evolution of database technology should keep its pivotal role as infrastructure for application development for data-intensive, central and distributed application. The hyperdatabase concept abstracts from the host of current infrastructures and middleware technology.

Parallel and Distributed Information …, 1994

This paper defines a formal classification of multidatabase languages into five levels of database integration with increasing degree of global control and decreasing degree of local autonomy. First, the fundamental interoperability mechanisms are identified for each of these levels. Their consequences on local autonomy as well as implementation draw-backs are discussed. Second, various multi-database languages are classified into these categories. In addition to our own language COOL ~, other proposals are analyzed, including SQL *Net, Multibase, Superviews, VODAK, Pegasus, and O*SQL. 195 0-8186-6400-2/94 $4.00

1992

ABSTRACT Distributed database technology is expected to have a significant impact on data processing in the upcoming years. With the introduction of commercial products, expectations are that distributed database management systems will by and large replace centralized ones within the next decade. In this paper, we reflect on the promises of distributed database technology, take stock of where we are, and discuss the issues that remain to be solved.

2012

The paper is devoted to the issues concerning with modeling and simulating of hierarchical database multiprocessor systems. The requirements for a model of parallel database systems are defined. A new computational model of the hierarchical database multiprocessor architecture is described. This model is called DMM (Database Multiprocessor Model) and designed for OLTP workload. It allows us to simulate and analyze an arbitrary multiprocessors configuration for database application. The practical experience of exploiting the DMM model is discussed.