Databases are important for storing and managing any types of data for any organizations. Databases are administered by Database Administrators. They are specialized in database management.
In the next sections of this report, there will be brief discussion on database administrations, roles and types of DBAs, and a tool used by application administrator DBAs for managing applications of some database. BR*Tools Studio for Oracle has been selected as a tool for application database. After giving description of the tool there will be discussion on how the tool will be used on different operating system platforms and how that is beneficial for a DBA. (Aiken, Gillenson, Zhang, & Rafner, 2011)
Database administration is a collection of functions that helps in maintaining and managing a database management system. Three are different types of database management software like IBMDB2, Oracle, and Microsoft SQL Server. Personnel who take care of the DBMS and has some IT specialization are called Database Administrators or DBAs. (Mullins, 2012)
DBAs perform different kinds of tasks related to database management. Some of those roles and responsibilities are,
Installing, configuring, maintaining and updating database management software, server and other related systems and products.
There are 3 categories of database administration. Those are,
System database administration is also known as operation database administration or physical database administration or production support database administration. As the names suggests, system database administrations are related to responsibilities of maintaining and management of physical database like, installing, configuring, patching, keeping backups, restoring, upgrading, performance optimizing and disaster recovery. (Faircloth, 2013)
Developmental database administration covers logical and developmental aspects of database administration. The roles and responsibilities may range from designing data model, maintenance of data model, generation of DDL bases coding, writing SQL scripts for query or tuning database performance, coding stored procedures, collaboration with developers etc. The basic goal is to add and manage suitable function or feature on the top of a physical database. (Faircloth, 2013)
Application database administration is relevant to the organizations that purchase different kind of application software like Enterprise Resource Planning, Customer relationship management, supplier management etc. from third party vendors and then need to manage databases with those applications. Some examples in such cases software like Oracle Application PeopleSoft, Siebel, SAP etc. are used for database management
The distinction between database management system and the application software is made clear by the DBA of the database management system. The application components of the whole infrastructure is managed by the DBA. They work on the database to catty out various tasks like installation, patching of applications, upgrading applications, cloning of database, creating and running different cleanup process or routines on databases, data load process management and other management activities. (Burleson, 1999)
There is a clear difference between application DBA and system DBA. Application DBA is more focused on design of database and the routing activities, administration of database through the use of some particular applications or a subset of applications. Unlike system database administration, application database administration is not very focused on physic database environment or implementation. However, sometimes, in organization there is no explicit existence of application DBAs.
However, application DBAs are important as they focus on specific applications rather than the database, thus there is chances of optimizing performance of the application. It can help in building more values in business process. (Coronel & Morris, 2014)
In this section, there will be a discussion on BR*Tools Studio for Oracle DBA. This application is developed and distributed by SAP. There are Windows and UNIX based versions for BR*Tools Studio. It is a useful web based interface that can be used to do all kind of administration tasks on Oracle Databases.
There is a three tier architecture in the BR*Tools. Users do not need to control jobs. They just need to develop job packages. On behalf of them their client systems pass those job packages to the BR*Tools Studio Server. At the server end, the jobs are executed individually on an instance of the targeted database. There are additional supports like role based control, quick start, selection of favorite tasks etc. There is an in-built search engine in the BR*Tools Studio. It helps in keep tracking and executing the functions. (SAP, 2015)
SAP has designed the BR* Tools Studio architecture in the following way,
BR*Tools Studio works on web browsers. It has three tier architecture that works on internet browsers and GUI platform. There is no need to install the software on the client side. A client can access it from a typical web browser. Thus, the client is not platform dependent and can be run from any device that supports web browsers. Additionally, the software does not need to be installed several times for different database instances. It is needed to be installed once. All instances of targeted database can be handled through the use of a single instance of BR*Tools Studio Server. (Gill, 2008)
In the following picture the architecture and integration with client and servers have been illustrated.
Architecture of BR*Tools Studio Source: (SAP, 2015)
As, it can be seen from the illustration that the whole architecture is structured in a star like shape. More than one client can log on to the single instance of the BR*Tools Studio server that is centrally located in the architecture. On the other end, there are multiple instances of the database. These instances are also collected to the same BR*Tools Studio server instance.
In the BR*Tools Studio Server a user can log in as a client. BR*Tools Studio allows multiple users to log in simultaneously. Additionally it supports multiple client sessions to the studio server at the same time. A change made in one client session will be instantly visible to other sessions. (SAP, 2015)
The architecture is deployed based on full multi-user support. Each of the instance of database that is administered with BR*Tools Studio, can create more than one password protected user accounts through BR*Tools Studio. These user accounts can be personalized and set for different roles and administration privileges. This feature of administering multiple roles in BR*Tools Studio support full auditing.
BR*Tools Studio server is an integral part of the software. All incoming job requests are executed and administered through the studio server. When the server is down, the jobs are scheduled during the downtime without any failure. During the downtime of the server, no client can log in to it.
When client sends a job package or a single job, it goes directly to the BR*Tools Studio Server. The server autonomously handles the job then. The job can be both scheduled immediately and executed or the job will be scheduled for later execution. Then the job will go to the job queue and will be automatically executed once it gets it turn.
The server can be instructed to execute same job repeatedly for some recurrence interval specified by the client. This is supported by the recurrence job execution option in the BR*Tools Studio option.
BR*Tools Server keeps track of all jobs executed by it. This records serves as history of job execution at the server. (SAP, 2015)
BR*Studio console provides a special status display to inform user about the current state of an instance of the database at any point of time. There is no need to refresh the display manually as it is automatic status update display.
Any pre-configured tasks can be saved for frequent use or later use. This task will be saved on the favorite task toolbar on the BR*Tools Studio.
The connection to BR*Tools Studio are created by using secure connection protocols like HTTPS, SSL etc. this is valid for the connections among the clients and the server also.
When a client request some operation from the BR*Tools Studio Server, then the server accepts the requests and executes it autonomously. Thus, there is no need for the client to wait for the job to be done. The client can log off. Later on the client can log in from some other device or location to check the result of the request or the status of the operation requested previously.
The function and features of BR*Tools Studio are categorized into the following categories.
Console is the collection of the interfaces that helps in doing the tasks, viewing the jobs etc. it provides following information,
It shows the latest instance of the database. The status may show that there is a SAP system connected to the database or in archived. As, the status displays are always updated automatically, so user will get information about the status updates of the instance of database after some specific interval of time.
This section on the console shows a list of the favorite tasks set by the user. These tasks can be requested for execution by a single click from this section (SAP, 2015)
This section on the console helps to quick understanding of the status.
Administration section helps in administering all items belonging to the BR*Studio instance where the client is currently logged in. The roles set in the BR*Tools Studio will restrict the further actions by a client.
Further subsections are, (Nüßer, Stein, Hass, Kugelberg, & Kley, 2009)
There is an individual, password protected user accounts for each user in BR*Tools Studio. Each of these user profiles has default database user settings and initializations for the attributes of their profiles. Additionally, a user can set up job package and favorite tasks.
The profiles can be modified. If there is sufficient authorization for user profile of a client then they can view or edit profiles of other users, create new user, remove existing user.
Roles are assigned to individual user profiles. A role describes some operations allowed for the user. In this case, the roles required for performing database administration operations will be set for administrator profile.
Jobs that are already requested to the server are stored in the job section of the client profile. If a job is listed for immediate execution at the server end, then that will be executed immediately. Otherwise, jobs can be schedules or later execution or recurrence execution.
The status of the jobs that are already executed, also shown here.
A task that is already executed, can be set up as favorite task and can be used later on or can be used frequently. A task can be added or removed from favorite task list. But it may need more authorization.
Wizard tab represents the interface of BR*Tools and BR*Tools Studio. The menu structure is a bit different. A wide range of operation can be performed on the database using wizard. (SAP, 2015)
Level of authorization may restricts the access to features of wizards as described,
A database instance can be started up or shut down. Also there may be several operations specific to an instance. A detailed status report of the database instances can also be viewed from this section.
In this section a detailed view of the database architecture is available. A database architecture contains tables, table space, indexes etc., the file structure from the operating systems, like control files, data files, log files etc. owners of SAP objects.
Major database administration operations like re-organization, administration, maintenance of statistics, importing or exporting different types of database objects are kept under this section.
This section offers functions to ensure availability of data and contains recovery options, copying databases, restore, recovery, backups etc.
There is a command line tool available on the BR*Tools Studio platform. It helps in performing advanced levels of functions on the database instances.
In this category, the server landscape is maintained through the BR*Tools Studio environment. An administrator can log into to the studio server for a database instance. This special type of user account is marked as administrator account and is password protected.
The features of this category are,
The server can be shut down to change the password for the server administrator. Until all jobs are done, the server cannot be suspended or shut down.
All clients are needed to logged in the BR*Tools Server.
All required administrative profiles and instances are listed here.
BR*Tools Studio is available to be implemented on UNIX, Linux and windows based systems. For Windows based systems, the installation is pretty straight forward. SAP provides the installation files, user just need to download it and install it. (Höding, 2008)
On the other hand, on the UNIX and Linux systems the software mainly works on command interfaces. There is very little scope of graphical user interface.
On the contrary, on the Windows server systems, BR*Tools Studio works on GUI mode. Thus it gives more user friendly interface than the same in the UNIX or Linux systems. Hoever, command interface is also available for Windows server systems also.
A typical example on Windows server system is,
Screenshot for adding new data file through BR*Tools on Windows
Otherwise, in both cases, the software works in the same way.
A database administrators can have several benefits from BR*Tools. It gives them ease of database administration tasks from a single place. All clients and database instances are connected to the same studio server. Thus this is a single point of management. A DBA can add new users, remove user, and manage roles of the users. (Kreines & Laskey, 2006)
In this report, the details and roles of different types of database administrations, roles of DBAs have been discussed. Then the discussion has become focused on application database administration. An example, BR*Tools Studio from SAP for managing Oracle Databases on different Operating system has been discussed. The BR*Tool with details on its architecture and functions have been discussed first, then, there is a discussion on how it is implemented on different operating systems like Windows, UNIX, LINUX etc.
Aiken, P., Gillenson, M., Zhang, X., & Rafner, D. (2011). Data management and data administration: Assessing 25 Years of practice. Journal of Database Management (JDM) , 24-45.
Alapati, S. (2003). Expert Oracle9i Database Administration. Apress.
Ault, M. R. (2002). Oracle Administration and Management . John Wiley & Sons.
Burleson, D. K. (1999). Oracle SAP Administration. O'Reilly.
Coronel, C., & Morris, S. (2014). Database Systems: Design, Implementation, & Management. Cengage Learning.
Elmasri, R., & Navathe, S. B. (2013). Fundamentals of Database Systems. Pearson .
Faircloth, J. (2013). Enterprise Applications Administration. Newnes.
Gill. (2008). Database Management Systems. I. K. International Pvt Ltd,.
Gillenson, M. L. (2008). Fundamentals of Database Management Systems. John Wiley & Sons.
Hernande, J., F. M., & Keogh, J. (2005). SAP R/3 Handbook. McGraw Hill Professional.
Höding, M. (2008). SAP Database Administration with Oracle. Galileo Press.
Kreines, D., & Laskey, B. (2006). Oracle Database Administration. O'Reilly Media, Incorporated.
Mannino, M. V. (2007). Database design, application development, and administration. McGraw-Hill .
McFadden, F. R. (1991). Database management. Benjamin/Cummings Pub. Co.
Mullins, C. (2002). Database administration: the complete guide to practices and procedures. Addison-Wesley Professional.
Mullins, C. S. (2012). Database Administration. Addison-Wesley.
Nüßer, W., Stein, M., Hass, A., Kugelberg, T., & Kley, F. (2009). SAP® on Linux:. Springer.
Oliveira, F., Nagaraja, K., Bachwani, R., Bianchini, R., Martin, R. P., & Nguyen, T. D. (2006). Understanding and Validating Database System Administration. USENIX Annual Technical Conference, General Track, 213-228.
Özsu, M. T., & Valduriez, P. (2011). Principles of Distributed Database Systems. Springer.
Rahimi, S. K., & Haug, F. S. (2010). Distributed Database Management Systems. John Wiley & Sons.
Rob, P., & Crockett, C. C. (2008). Database systems. Cengage Learning EMEA.
SAP. (2015). BR*Tools Studio for Oracle DBA. Retrieved from Help.SAP: https://help.sap.de/saphelp_crm700_ehp02/helpdata/de/bb/abadacc38a40a383f5c3cf9f21cf57/content.htm?frameset=/de/47/1d9aac8ffb2c7be10000000a114a6b/frameset.htm¤t_toc=/de/0b/5daf09b03344ad97338f838e09b9ee/plain.htm&node_id=119&show_children=false
Schneider, T. (2010). SAP Performance Optimization Guide. Galileo Press.
Schreckenbach, S. (2011). SAP Administration. Galileo Press.
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2011). Database System Concepts (6th ed.). McGraw-Hill.
Vorholt, M., Mitchell, D., & Bourne, B. (2001). Architecture and method for deploying remote database administration.
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2016). Roles And Types Of Database Administrators. Retrieved from https://myassignmenthelp.com/free-samples/roles-and-types-of-database-administrators.
"Roles And Types Of Database Administrators." My Assignment Help, 2016, https://myassignmenthelp.com/free-samples/roles-and-types-of-database-administrators.
My Assignment Help (2016) Roles And Types Of Database Administrators [Online]. Available from: https://myassignmenthelp.com/free-samples/roles-and-types-of-database-administrators
[Accessed 20 February 2020].
My Assignment Help. 'Roles And Types Of Database Administrators' (My Assignment Help, 2016) <https://myassignmenthelp.com/free-samples/roles-and-types-of-database-administrators> accessed 20 February 2020.
My Assignment Help. Roles And Types Of Database Administrators [Internet]. My Assignment Help. 2016 [cited 20 February 2020]. Available from: https://myassignmenthelp.com/free-samples/roles-and-types-of-database-administrators.
End your doubt 'should I pay someone to do my dissertation by availing dissertation writing services from MyAssignmenthelp.com. We are the leading dissertation help company in Australia that holds the record of providing high-quality dissertation papers at an affordable rate. Students, who search 'need help with my dissertation', should hire our professional dissertation experts for successful completion of the task.
Answer Essay Plan Introduction Background: This essay debates on the current and the historical state of bilingual languages on the whole but particularly talks about the aboriginal languages which are becoming extinct in Australia now days. Purpose and thesis statement: The purpose of this essay is to know about these languages, the state of the languages in Australia and the ways to retain them for the upcoming generations. Main Body...Read More
Answer: Literature review Yes, the use of different source articles are utilized in order to gather information regarding the NZ context concerning the baby food products. The evaluation of the depth market research helps in understanding the desired requirements of the customer regarding the products. According to Gioia, Sobell, Sobell, & Agrawal, (2016), Understanding of the effective target market is crucial as it helps in evalua...Read More
Answer: The indigenous or the aboriginal people in Australia are the original inhabitants of the land who have faced oppression, discrimination and humiliation for decades by the colonists. Before the year 1788, approximately 700 languages were spoken throughout Australia which hosted only the indigenous people with a population of 7,50,000. The country used to be a land of diverse cultures. The aboriginal Australians constitute to 3% of the t...Read More
Answer: Introduction In general, the concepts associated to the conceptual framework is identified with several factors which are used by the businesses for financial reporting. The main aspects of the conceptual framework used by the business relates to the presentation of annual reports of an organization. The information provided in the conceptual framework is identified to be conducive for solving number of business problems which may be ...Read More
Answer: 2. Estimation of the passenger demand and the sizing-check against the specification. Office floor area = (266.16m2)/12 = 22.18m2 = 23 people per floor 23× 10 = 230 total population = 230 × 8 =184 80% of the total population Sizing= 300/ 30 (number of trips in I minute) = 10 trips Number of people per trip = 23/10 2.3 2.3 people per trip Required cost = 2.3 Required cost = 2.875 Question 2 b Handling ...Read More
Just share your requirements and get customized solutions on time.
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
The writer followed directions well. Gave great detail. Work was delivered within the given time.
Work was delivered within the time frame given. Work was just as I expected. Well written.
Great quality paper, very impressive! Very happy about the writer! .....................................................................................................................
great work! delivered on time, the questions are sloved in details and clearly explained