When creating a distributed database, there are a number of security concerns wh

Question

When creating a distributed database, there are a number of security concerns which must be addressed. There are many factors to be considered according to the choice between relational or the object-oriented model. These factors include protection against inference, single level and multilevel access controls, and maintenance of integrity. Other factors to be considered to decide which model will be more secure for a given application are the efficacy and efficiency of the delivery of these features. (Coy, 2008) presented a good discussion about the strengths and weaknesses of the security factors of both database models? Do you agree with Coy’s view (weakness and strenghts)? Why? References Coy, S.P., 2008. Security implications of the choice of distributed database management system model: Relational vs. object-oriented. In NISSC (Vol. 96, pp. 428-437).

Explanation / Answer

"A distributed database is a collection of databases which are distributed and then stored on multiple computers within a network". A distributed database is also a set of databases stored on multiple computers that typically appears to applications as a single database. "Consequently an application can simultaneously access and modify the data in several databases in a network ". A database link connection allows local users to access data on a remote database ". For this connection to occur, each database in the distributed system must have a unique global database name in the network domain. The global database name uniquely identifies a database server in a distributed system. Distributed database is a database implemented on a network. The component partitions are distributed over various nodes (stations) of the network. Depending on the specific update and retrieval traffic, distributing the database can significantly enhance overall performance. See also partition. Distributed database management system is a database management system capable of managing a distributed database A distributed database management system ('DDBMS') is a software system that permits the management of a distributed database and makes the distribution transparent to the users. A distributed database is a collection of multiple, logically interrelated databases distributed over a computer network. Sometimes "distributed database system" is used to refer jointly to the distributed database and the distributed DBMS. A distributed database system consists of loosely coupled sites that share no physical component. Database systems that run on each site are independent of each other. The main difference between centralized & distributed databases is that the distributed databases are typically geographically separated, are separately administered, have slower interconnection. Also in distributed databases I differentiate between local & global transactions. A local transaction is one that accesses data only from sites where the transaction originated. A global transaction, on the other hand, is one that either accesses data in a site different from the one at which the transaction was initiated, or accessed data in several different sites.

Database management system is a software interface between the database and the user. A database management system handles user requests for database actions and allows for control of security and data integrity requirements. A Database Management System (DBMS) is a set of programs that enables you to store, modify, and extract information from a database, it also provides users with tools to add, delete, access, modify, and analyze data stored in one location. A group can access the data by using query and reporting tools that are part of the DBMS or by using application programs specifically written to access the data. DBMS’s also provide the method for maintaining the integrity of stored data, running security and user’s access, and recovering information if the system fails. The information from a database can be presented in a variety of formats. Most DBMSs include a report writer program that enables you to output data in the form of a report. Many DBMSs also include a graphics component that enables you to output information in the form of graphs and charts. Database and database management system are essential to all areas of business, they must be carefully managed. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications: computerized library systems, flight reservation systems, and computerized parts inventory systems

MAIN FUNCTIONS OF THE DATABASE MANAGEMENT SYSTEM 1. Indexing 2. Views 3. Security 4. Integrity 5. Concurrency 6. Backup/Recovery 7. Design 8. Documentation 9. Update/Query

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.