country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Roles And Types Of Database Administrators

tag 358 Downloads12 Pages 2,876 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

Comparison between different application based on platform (Operating Systems) and How it will give benefits to the Database administrator?

 

 

Answer:

1. Introduction

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)

2. Database Administration

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.

  • Evaluating different features of databases and related software.

  • Establishing and maintaining sound backup and recovery procedure and policies.

  • Taking care of design and implementation of database.

  • Tuning database and related application for performance booting and monitoring.

  • Implementing and maintaining overall security and recovery of database.

  • Setting up documentation and standards for maintain databases.

  • Providing support for any issues related to database. In some cases, providing general or advanced solutions.

There are 3 categories of database administration. Those are,

2.1 System Database Administration

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)

2.2 Developmental Database Administration

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)

2.3 Application Database Administration

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)

 

3. BR*Tools Studio: Oracle DBA

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)

4. Architecture Details

SAP has designed the BR* Tools Studio architecture in the following way,

4.1 Multiple instance of Database and Three Tier Architecture

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.

 

1.1 Client

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)

1.2 Concept of Role Based Multi User

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.

1.3 Server

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.

1.4 History, Job Queue and Scheduling

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)

1.5 Status Display and Auto Update

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.

1.6 Favorite Task

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.

1.7 Secure Connection

 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.

 

1.8 Reconnect

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.

2. Features of BR*Tools Studio

The function and features of BR*Tools Studio are categorized into the following categories.

1. Console

2. Administration

3. Wizard

4. Landscape

2.1 Console

Console is the collection of the interfaces that helps in doing the tasks, viewing the jobs etc. it provides following information,

2.1.1 Instance Status

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.

2.1.2 My Favorite Tasks

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)

2.1.3 Job in Process

This section on the console helps to quick understanding of the status.

2.2 Administration

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)

2.2.1 Users

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.

 

2.2.2 Roles

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.

2.2.3 Jobs

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.

2.2.4 Favorite tasks

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.

2.3 Wizard

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,

2.3.1 Instance

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.

2.3.2 Database

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.

2.3.3 Maintenance

Major database administration operations like re-organization, administration, maintenance of statistics, importing or exporting different types of database objects are kept under this section.

2.3.4 Availability

This section offers functions to ensure availability of data and contains recovery options, copying databases, restore, recovery, backups etc.

2.3.5 Advanced

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.

2.4 Landscape

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,

2.4.1 Server

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.

2.4.2 Clients

All clients are needed to logged in the BR*Tools Server.

2.4.3 Instances

All required administrative profiles and instances are listed here.

3 Implementation on Different Operating System Platforms

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

(Source: https://www.fatihacar.com/blog/resimler/brtools_2.jpg

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)

Conclusion

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.

 

References

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&current_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.

OR

Cite This Work

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.

Latest Management Samples

EST202-Introduction To Science Technology And Society Studies

Download : 0 | Pages : 9
  • Course Code: EST202
  • University: Stony Brook University
  • Country: United States

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 arrow

BUS8404 Consumer Behavior For Depth Market Research

Download : 0 | Pages : 6

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 arrow

IKC101-Indigenous Australian Culture And Histories

Download : 0 | Pages : 8
  • Course Code: IKC101
  • University: Charles Sturt University
  • Country: Australia

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 arrow

ACC303 Contemporary Issues In Accounting For Conceptual Framework

Download : 0 | Pages : 8
  • Course Code: ACC303
  • University: Kings Own Institute
  • Country: Australia

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 arrow

300725 Construction Technology For Directly Proportional To The Quality

Download : 0 | Pages : 3

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 arrow
Next
watch

Save Time & improve Grades

Just share your requirements and get customized solutions on time.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,201,731

Orders

4.9/5

Overall Rating

5,061

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1896 Order Completed

95% Response Time

Herman Berens

MSc in Psychology

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1758 Order Completed

99% Response Time

William Martinez

MS in Biology

Washington, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

647 Order Completed

98% Response Time

Adlina Han

Masters in Marketing with Specialization in Branding

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

93 Order Completed

100% Response Time

Jackson Mitchell

MiM (Masters in Management) in Supply Chain Management

New Jersey, United States

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

The writer followed directions well. Gave great detail. Work was delivered within the given time.

flag

User Id: 239259 - 19 Feb 2020

Australia

student rating student rating student rating student rating student rating

Work was delivered within the time frame given. Work was just as I expected. Well written.

flag

User Id: 239259 - 19 Feb 2020

Australia

student rating student rating student rating student rating student rating

Great quality paper, very impressive! Very happy about the writer! .....................................................................................................................

flag

User Id: 363978 - 19 Feb 2020

Australia

student rating student rating student rating student rating student rating

great work! delivered on time, the questions are sloved in details and clearly explained

flag

User Id: 374436 - 19 Feb 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?