March 15, 2017

Question description

Need one response per post (2). Unique responses with one relatable reference at least. 150 words per response. Apa format. And word doc file is okay. Just need responses no outlinesuch.

Forum question: DBMS has many functions. What three functions are the most important and why are they most important?

What one benefit of a DBMS would you be willing to give up and why?

1st Post to respond to: A database management system has nine functions: having the ability to update and retrieve data, provide catalog services, support concurrent updates, recover data, provide security services, provide data integrity features, support data independence, support data replication, and finally provide utility services (Pratt, 2012). The three functions that I believe are the most important are security services, data integrity features, and having the ability to update and retrieve data. A system can’t have enough security, in the proper configuration of course, don’t want to hinder operations. Having security at multiple levels within a network or database is paramount toward data privacy and the systems health. Data integrity is one of my top functions because with multiple users to information at the same time it’s important to follow the same rules and conform information consistently in the same manner, otherwise it would be difficult to consolidate work and share information in different formats. If users couldn’t update and retrieve data, then what would be the point of a DBMS? Without it would be another basic file system, and based on permissions, would have to send information to and from to share. Depending on a workforce’s footprint the one function I can go without is the ability to support data replication. Instead of managing multiple copies of the same data at different locations there could be a checkout option to safeguard information from edits until updates are complete (Pratt, 2012). In addition, the request for information won’t be as high and then this ability would be unnecessary. Thanks for reading.

-Mark

References:

Pratt, P. (2012) Concepts of Database Management. 7th ed. Retrieved from https://bookshelf.vitalsource.com/#/books/9781285501154/cfi/4!/4/2/16/8/2/4/2@0:100

2nd to respond to:) This week we have been given instructions to discuss the three most important functions of DBMS. Based off of the book the three most important functions out of the nine: Security services provided by the software, data recovery and lastly, data integrity of course. DBMS is something we have learned in the past, but a refresher is important. DBMS analyzes and captures data within a database by interacting with the system or user. Based off that description of DBMS it is safe assumption that the number one function out of the main three that I have chosen is data integrity because every good database needs data integrity that is what provides accurate and up to date information, without it the database would be useless. The second important function that I picked was security utilized for DBMS. Security services are very essential when it comes to databases, it allows the encryption of data which converts data into a different style which doesn’t allow programs not authorized by the database to view them. This is what makes it so essential to any valuable database. The last function I had picked was data recovery, which is important in every single type of system not only databases. This comes into play when data within the database has been corrupted or some unexpected catastrophe occurred while working on your database. It allows you to retrieve data based on the users saving It or backing it up, which is a great practice for any professional. Out of all the functions, picking one to get rid of is extremely hard to decide because I believe they are all important, but I believe I would chose data replication because it would not be important in my situation because I do not need to have data on multiple databases, which allows users to access it across those platforms.

 

Tazz

 

Pratt, P. J. (2012). Concepts of Database Management, 7th Edition. [Bookshelf Online]. Retrieved from https://bookshelf.vitalsource.com/#/books/9781285501154/

http://www.myreadingroom.co.in/notes-and-studymaterial/65-dbms/465-functions-of-dbms.html

WE ACCEPT