Unit 5: Discussion 5 5 unread replies. 5 5 replies. Questions This is a continua
ID: 3666826 • Letter: U
Question
Unit 5: Discussion 5 5 unread replies. 5 5 replies. Questions This is a continuation of the discussion question from Unit 4 (we all know that databases supply the fuel for the productivity engine in the information age, but at what cost). In this unit we will focus on what effort is required to maintain the data by DBA(s) or functions performed by DBA(s) in a database in your corporate (where you work now or have worked in the past) and personal databases (resources – dollars or people hours and other input (such as the cost of updating licenses for the DBMS); getting this quantitative information may be difficult, but I want you to provide at least an estimate if historical records are not available)? Provide this information for either one example of a personal database, or one example of a corporate database that you are familiar with. Even if you are not experienced with databases yourself, the idea is to go find out about the effort needed to maintain the database and upgrade the DBMS software periodically, and make sure you provide appropriate releasable citations for your references. This question in not concerned with the effort to initially build/develop and populate a database (we answered that question in the Unit 4 discussion), but instead the ongoing/long term effort to keep the data and DBMS functioning by DBAs. As always, for those of you in the military, if you use one of your database systems, make sure the information is releasable. And for those who will interview someone to get the information to answer this question, make sure you provide a personal reference for that person (see the course FAQs for examples [include name, position, organization, etc.).
Explanation / Answer
In order to sustain the use of the database, there is the need for a long-term commitment to support the data management application. Adequate personnel should be available not only for routine operation, but also to modify the system as the need arises. Failure to provide such support is very likely to result in a gradual loss of system capabilities and ultimately may contribute to a collapse of the system.
The express edition of an SQL server is usually free and most of the common projects can be saved in it. Whereas the The combination of Sql Server pricing and Amazon Web Services Core Specifications confuses the hell out of me. Sql Server is currently licensed per core and I have found 2 core packs priced for around $13k.
DBA Responsibilities
The job of the DBA seems to be everything that everyone else either doesn't want to do, or doesn't have the ability to do. DBAs get the enviable task of figuring out all of the things no one else can figure out. More seriously though, here is a list of typical DBA responsibilities:
Upgrading to Oracle Database 12c provides the latest in efficient, reliable, secure data management for mission-critical on-line transaction processing applications, query-intensive data warehouses, and cloud applications. The right planning, preparation, and upgrade steps will make the upgrade process simpler, faster, and more predictable from start to finish.
The license expires after a certain time and you need to renew it.it depends on the project and the client which version they need to use.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.