Homogeneous DDBMS – to define this, it will be necessary to know what a DDBMS. A DDBMS, full for Distributed Database management system is a software system that allows management of distributed databases and allows this management to be transparent to the users. A homogeneous DDBMS is an implementation where all sites make use of one product of database management system. One advantage of this is that it is easy to implement and allows incremental growth where new sites can be added to the sites with much ease. Heterogeneous DDBMS – in this setup, the database management system products are different in the various sites and their underlying data models are different too. In this setup, it is common to find underlying system to be composed of RDBMS, ORDBMS, and OODBMS.
Online transaction processing (OLTP) – this a class of a program that enables and manages applications which are transaction-oriented and are normally used in data entry and retrieval transactions in various industries like banking, supermarkets and airlines. An example of an OLTP is Customer Information Control System, which is from IBM.On-line analytical processing (OLAP) - this is a solution for giving businesses superior techniques for visualizing business metrics from different points of view. Generally, OLAP is a term that used to infer software and applications that permit users to store and access data in OLAP cubes, also known as multidimensional cubes or hypercube and are made of measures, which are numeric facts and dimensions, which are text values.
1. How can you measure or evaluate distributed database systems?
Distributed database systems are measured basing on the total number of transactions that executed successfully out of the total number of transactions that has been submitted to the system given a certain time. Various variables that are found here include measures of reliability, data distribution, and control of concurrency.
2. What are the advantages and disadvantages of a DDBMS?
The advantages of DDBMS include the ability to easily share and provide local autonomy, better performance, improved reliability and availability; there is a modular growth and reduced danger on single-point failure. The disadvantages include complexity, difficulty encountered in managing integrity, slow response speed, and lack of standards.
3. Provide an example of a DDBMS?
An example of a DDBMS would be that of a database parts which are located on a computer network consisting of IBM mainframe, which is under MVS, a VAX system, which is under VMS, and an IBM machine, which is under DOS. These three systems use different LDBMS, which are DB2, Ingress and Dbase3. In this setup, a user can create a part of a data from anywhere without any form of restrictions or complications.
4. What is data transparency?
Data transparency is the ability to work on and access data regardless of the application that was used to create them or where they are located. It is also the assurance that the data that is being received and used is accurate are from where they are supposed to be coming from.
5. What is cloud computing?
Cloud computing is a technology where data and different applications are stored on storage networks and servers which are located in a remote place and accessed by the users via the Internet. This technology of cloud computing allows businesses and consumers to get access to applications without the need of installing them on their own on-site servers. The applications are installed on remote servers.
Bibliography
Coronel, C., Morris, S., & Rob, P. (2009). Database systems: Design, implementation, and management. New York: Cengage Learning.
