LiteratureReviewandProposal on SQL DBA
Sandeep Guptha Uppala
Wilmington University
IST 8101
Table of Contents
What is a database? 3
DBA-types 3
Application DBA 3
System DBA 4
Maintenance DBA 5
SQL DBA 5
Proposal 7
Iteration1 7
Iteration2 7
Iteration3 7
Iteration4 8
Visual Representation................................................................................................................................9
References 10
Literature Review On SQL DBA
What is a database?
Connolly and Carolyn (2004) define a database as a structureordesign that consists of theclient’s data as well as metadata. It is also a persistent, logicallycoherentrepository of inherentlymeaningful data that is relevant to someaspects of therealworld. The database consists of data organized in a systematicway, anditallowseasy retrieval of information, analysis, updating andoutput of data. Thatdata can be in theform of graphics, scripts, reports, text, tables, andsoon. Most of thecomputerapplications are databases at their core. Manycompaniesusuallyhave a lot of data, andsotheyhavebig databases that can handlethatlargeamount of data. It is wherenothe database administratorcomes into playtopensurepropermanagement of the database sothatthe organizational data is safe from anyintrudersor data corruption (Jones, 2014). The database is whatcontrolsthedata of theentireorganization, andany tampering of the databases can culminate to the stoppage of businessoperations.
DBA-types
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 collection of programs that manages the database structure and controls access to the data stored in the database.
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.
Databases are normally used by businesses and schools to store their data. These databases are kept secure, and users can only access the information stored on the database they have been granted access to. Now data is added to, accessed, or remove from a database using languages such as SQL (Structured Query Language), MYSQL (My Sequel), etc.
This database is the basis for all actions in the system and can be trivially updated and used to aid in all of the system’s processes, meaning all of the required information is stored in one central location and thus is easily accessible. This is a far more reasonable storage method than a paper-based file system, where the time of traveling to and physically searching the records for the required information could be a burden. Human error could also be a factor in that mistakes could be made in the filing process which would not occur in a well written database system and mistakes or changes on physical records can be messy to
Database refers to a collection of data that is specially organized for rapid search as well as retrieval by a computer (Strou, 2014). They are structured to facilitate storage, retrieval, and modification of data in conjunction with some data processing operations. Database management systems therefore assist in retrieving data or information from the database in response to queries made by the customers or
This paper will discuss databases, forms and reports. Why has the use of databases increased dramatically? What factors should be considered when designing a database and why? How would you go about designing forms and reports from scratch? In conclusion, a summation will be given along with closing thoughts.
As databases and technology have evolved, Elmasri and Navathe point out that increasingly complex data structures for modeling to meet the needs of the more advanced and larger databases that were also beginning to include newer data types (2016). As stated before, with more complex databases, there are more vulnerabilities in security that need to be planned for and mitigated wherever possible. A DBMS is responsible for designing the methods in which data recovery and security is handled, while tools are used within database modeling that facilitate modeling, system design, and improve performance (Elmasri & Navathe, 2016). When applying these tools to database creation, security should always be considered in each step of modeling and creating the database. The DBMS provides a security and authorization subsystem to the DBA so that they can use it to create accounts and specify account restrictions (Elmasri & Navathe, 2016).
Improved data security – Whenever in an organization the number of users accessing the data increases, risk of data security increase simultaneously. (Ramakrishnan, Gehrke 2003) DBMS provide effective framework with high standard data privacy and security. Let’s take an example of banking: it is such business in which employees at the bank at different levels are given access to different types of data in the database. Not everyone has access to the same information. A clerk is given the access only to the list of the customers, whereas an investment banker or wealth management agent is given access to all the bank account details which may also have even the social security listed.
However, databases have to meet some challenges. Nowadays, the purpose of databases is to serve the demands of large scale companies. These
Due to the rapid increase in technology development, most organizations use databases as a way of recording and keeping their information. In the past, managers would record and enter data manually to the systems. However, there are some organizations that still rely in gathering information and feeding them manually to the systems while maintaining some soft copies and files that are stored according to each department.
A database is a collection of data that is related that can be produced to information that is relevant to the user. A database is large since it has to store a lot of information ranging from figure to word. Beaumont(2000) argues that data represents facts that are recorded and can be processed to produce information that is based on the facts that are stored in the database. These data is maintained as a collection of
A DBMS can also provide many perspectives of a single database schema. A perspective characterizes what information the client sees and how that client sees the information. The DBMS gives a level of reflection between the reasonable diagram which characterizes the legitimate structure of the database and the physical construction that portrays the records, files and other physical instruments utilized by the database. At the point when a DBMS is utilized, frameworks can be adjusted all the more effectively when business prerequisites changes. New classifications of information can be added to the database without aggravating the current framework and applications can be protected from how data is organized and put away.
This paper is based on the database systems. And will result in providing the whole new information about that. Basically, database systems are the computer applications which interacts with the user and help in maintaining the work by making them in synchronization and in a relative format sometimes. Database systems are also help in keeping the records of utilities and securing them for ages. This paper will tell you whole new achievements which can be done with the help of using the database with its correct efficiencies.
3. End users: - End Users are the persons, whose jobs require access to the database for quering, updating, and generating reports. 4. System Analysts and Application Programmers: - Systems analysts determine the requirements of end users, and develop specifications for canned transactions that meet these requirements. DATA MODELS: - The structure of a database is the concept of a data model, a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. 1. Network data Model 2. Hierarchical data model 3. Relation data model Network data model: - data in the network model are represented by collection of records and relationships among data are represented ny links. The links can be