Security challenges in Distributed Databases
Koushik Kashojjula
Graduate Student
College of Computing and Informatics
University of North Carolina at Charlotte
Email: kkashojj@uncc.edu
Abstract - The rapid growth of information processing industries led to the development of distributed database systems. In such systems data is stored in several locations which are interconnected. The data on several computers can be accessed and modified simultaneously using a network. Local DBMS controls every database server in the distributed database and helps to maintain consistency of the global database. In distributed database, a lot of data communication takes place owing to the diversified location of data, users, and transactions. Data may
…show more content…
The concept is called Distributed Databases.
As per various experts Distributed database management system is majors build on two concepts:
Fragmentation: It is the process of dividing the data into multiple fragments and storing in it different locations based on the usage of data. The fragmentation should be done in a such a way that the reconstruction of original database is possible.
Replication: It is process of maintaining two congruent databases such that even one crashes the other node can be used as a backup. As these databases are stored in different geographic locations there will be a significant reduction of network load.
There are two types of Distributed Database management systems. They are Homogeneous and Heterogeneous database management systems.
1.1. AIMS AND OBJECTIVES
This study report aims at identifying the possible security challenges for Distributed database systems and suggests some of the possible solutions for the challenges identified.
2. FACTORS LEADING TO USE OF DISTRIBUTED DATABASES
- Economic reasons
- Connecting databases that already exists
- Reducing data transfer over network
- Reliability
- Greater control
- Considering heavy data growth
2.1. TYPES OF DISTRIBUTED DATABASE MANAGEMENT SYSTEMS
Homogeneous Database management systems is a system in which every system has exactly similar software and infrastructure and they are aware of the mutual interaction for processing
A database administration framework (DBMS) is a PC programming application that connects with the client, different applications, and the database itself to catch and dissect information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.
A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.
atabase is a collection of data which describes the activities of one or more organizations in a well-defined structure and the structure of a database is specific and it has a purpose. Database Management System (DBMS) is used to control or organize the data in a database. Database Management System (DBMS) is also used for maintaining large collections of data. Distributed database can be defined as a collection of various databases which can be stored at different computer network locations. In this paper we discuss about Distributed Databases, their advantages and disadvantages.
This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.
A database is a system that is specialized to manage data in a computer application system. Data has many forms, such as text, digital, symbols, graphics, images and sound. The database systems are integral components of current and future command, communication, control and intelligence information systems. (Lunt, 1992, p. 253)
Database System is one of the most important concern in the field of Informational technology. It contains the most reliable
Database security is a critical Domain of Computer and Information Security that deals with protection of an individual database or group of database from illegal access, injections or possible destruction. Data can be a customer's information, intellectual property, financial asset or any number of other records that can be maintained and managed on a system. Without Database security people are at risk of identity fraud, theft, destruction of property and much worse. The global costs of such security breaches runs from over a billions of dollars yearly, and the cost to individual companies can be extreme, sometimes disastrous.
2. Local control – The data is dispersed in a way that every part of it is local to some sites (servers). The site in which the part of data is stored is the owner of the data.
Distributed database technologies are an emerging market and bound to have a significant impact on data processing in the upcoming years. Research states that the introduction of commercial products there is more expectation that distributes database management system will take over a centralized database within the near future. Even though DDBMS is changing technologies, there are still issues. This paper is about the lack of security in a distributed database and how we can improve it in many ways. The distributed database is a collection of database, stored at various sites of the network; therefore, security is an important issue.
This paper explores the different aspects of security as it pertains to database systems. It will provide an overview of security concerns such as access control, user authentication, reliability and data integrity, as well as how IT professionals might mitigate the risk associated with each. By examining the methodology by which attacks on database systems occur, we are able to take a comprehensive approach to prevent or limit the extent of such attacks and the impact they may have on a DBMS environment. Finally, we will review industry best-practices of the implementation of security countermeasures.
In a distributed database system (DDS), multiple Database Management Systems run on multiple servers (sites or nodes)
With advances in technology constantly happening, it can be hard to keep up with all of the latest trends. If organizations cannot keep up with the latest trends, it can lead to flaws in their security. Any flaws in security can have a detrimental effect on an organization’s database. Almost every organization has some sort of database, whether it is for maintaining customers, inventory, or vital information.
We share many of the servers and allows a large amount of transactions in the database, the implementation of a distributed database architecture.
Databases introduce a number of unique security requirements for their users and administrators. On one hand, databases are designed to promote open and flexible access to data. But on the other side, it’s this same open access that makes your database vulnerable to many kinds of wicked activity. As the use of the Web grows on both Intranets and the public Internet, information security is becoming crucial to organizations. Now that it is extremely easy to distribute information, it is equally important to ensure that the information is only accessible to those who have the rights to use it. With many systems implementing dynamic creation of Web pages from a database, corporate information security is even more vital. Previously, strict
Before we talk about Fundamentals of database management system, we need to know what is a ‘Data’. Data is a something which has an implicit meaning and that can be deduced to new facts which can be recorded too.