Database Administration Today In Evaluating Thesis

Length: 11 pages Sources: 15 Subject: Education - Computers Type: Thesis Paper: #95290228 Related Topics: Relational Database, Araby, Education Administration, Administration
Excerpt from Thesis :

Design criteria exist at the levels of the technical, system integration aspects of the database to other systems through XML. This integration is critically important to ensure that the applications created can be effectively used over time and not have any scalability issues. There is also the need for designing the databases at the presentation layer to provide for scalability and flexibility of being able to create applications relatively quickly at the portal level. This is especially important from a Business Process Management (BPM) standpoint as databases must be able to support the various process workflows as defined as part of business process re-engineering efforts over time. There is also the need from a design standpoint to have a continued development initiative going to capture user needs over time and include them into the next generation of database updates. The use of councils to create update plans and define the future direction of applications is critically important from a design perspective.

Database Performance

There are common measure of SPEC Marks is often used for benchmarking the performance of databases being offered by software vendors. The use of internally defined key performance indicators (KPIs) and metrics of performance that show the relative loads on a database application is critical for DBAs to understand the scalability factors of databases over time (Guynes, Pelley, 1993). This focus on performance needs to be evolutionary as well, seeking continual improvement over time (Zdonik, 2008). For the role of the DBA, the ability to quickly define KPIs, test them for their relevancy, and then include them in a broader set of metrics as part of a dashboard is essential to measuring the scalability of systems as well. The aspects of database performance also must be tied to the integration testing of applications, hardware platforms and the performance of APIs over time in terms of connection to databases with each other and continually testing their performance. The scalability of integration is also critically important, and the DBA, as the hand-built connectors and adapters must be tested to ensure they can manage the traffic generated from inter-database and intra-data transactions over time (Winkler, Seip, 2006).

Database Data Integrity and Availability

The use of approaches and methodologies to ensure a high level of data integrity and availability are based on both hardware and software-based technologies. From a hardware standpoint, the combining of Redundant Array of Inexpensive Disks (RAID) technologies, combining with software partitioning and the use of fall-back and redundancy algorithms to back up databases by the record, file or entire structure (Son, Choe, 1988). Data integrity is preserved through the use of Cyclic Redundancy Checking (CRC) and Error Correction (ECC), in addition to the concept of ACID compliance, which is explained in detail later in this paper. These approaches and methodologies also matter from a data availability perspective as well, as the logical structure of databases across multiple physical locations ensures data redundancy. For the DBA the choice of which approach to choose is critically important. The selection of a fail-safe RAID-based approach is costly yet preserves data entirely and can be configured to do selective backups over time. The combining of these systems with CRC and ECC based approaches to data integrity and availability is the essence of how databases systems at the enterprise level are made fault-tolerant.

Database Security

When many IT professionals consider the concept of database security, the overall perception is more about passwords usage and complexity than about the architectural elements so critical to keep any database secure. Beyond authentication processes and logic workflows at the presentation layer of database hierarchical models, the development of an architectural layer of security at the process management and integration layer of a database is critical (Jajodia, 1996). This translates into the ability to define role-based and information asset-based security through XML-based messaging protocols secured to 256 bits or higher (Iwaihara, Hayashi, Chatvichienchai, Anutariya, Wuwongse, 2007). Central to these process-based and asset-specific security controls is the ability to define more stringent Authentication and Access...


In conjunction with this approach to security there is also increasing focus, especially in DBMS systems from Microsoft, IBM and Oracle in the concept of each specific transaction within a database being ACID compliant. Additional areas of coverage in this analysis include database connection and security, the use of encryption and server security approaches and strategies.

Contrary to the common perception of authentication, there is much more to the securing of access to any database than the use of passwords or even biometrics. Databases need to take into account the concepts of cross-system and intersystem security to be as effective as possible and authentication cannot be relegated just to one single system (Bertino, Sandhu, 2005). Instead there needs to be more of a focus how at the interprocess integration and system integration levels, in some early adopters this would include SOA integration to the transaction level, can validate a given request from a given system to another in real-time. While all database management systems have Kerberos security, beginning with Microsoft, the lack of consistency of cross-system security beyond just using the ticket or alert-based authentication is critical to the stability of any network-based database (Ma, Orgun, 2008). What has been most significant about this aspect of database security is its rapid maturation from role-based authentication predominately only for military purposes first (Pangalos, 1994) top its uses throughout SOA platforms and architectures as well (Bertino, Sandhu, 2005).

Another aspect of enterprise-wide databases that has become increasingly prevalent is the requirement of having ACID compliance (Dolgicer, 1993) to the transaction level of a database. At its most fundamental, ACID compliance at it's most fundamental focuses on how to take each identifiable data element and isolate them, audit the activity performed on them, and be able to define an audit trial the values that have been written to the field, record, and table level. Global governments and militaries including ministries of defense use ACID compliance is to measure how often data has been accessed on specific supplies of munitions and armament for example.

DBAs are increasingly focused on how to ensure cross-platform and cross-database integration security, to the transaction level as well. The HTTP protocols that serve as the primary means of connecting to servers for queries, in conjunction with XML are considered essential skill sets for any DBA in the workforce today or just entering it. Skill with HTTP and XML is critically important to secure enterprise-wide networks of databases, in addition to assisting with the development and continued testing of applications as well. Many DBAs are expected to be able to create secured XML gateways by which in-house developed applications can be tested and evaluated prior to being used. In this context a DBA actually fulfills the role of a member of the development team. DBAs are also finding that this skill set is invaluable in troubleshooting Virtual Private Network (VPN) connection time-outs, errors and safeguarding VPN connections directly over the Web. The combination of HTTP and XML is critically important to creating roles-based and process-based authentication and validation processes as well, which are critical for installing and using distributed applications including analytics. DBAs are finding that with the rapid sophistication of analytics applications that often rely on highly sensitive financial data that understanding the use of secured HTTP protocols and XML is critically important for being able to get users the data they need to complete the analyses required.

Much as been written about the concept of server-based security from the context of roles-based authentication (Bertino, Sandhu, 2005) yet for this to be effective an organization must concentrate on the broader business objectives and seek to align their security strategies to the broader SOA directions, plans and strategic initiatives (Erickson, Siau, 2008). This process-based orientation to managing security from an SOA standpoint is vitally important to consider as the future growth of enterprises will certainly have more Web Services and SOA-based platforms as well.

Database Backup

From the use of streaming tape and drum-based magnetic mass storage of previous generations of computing to the use of CR-R drives that can in seconds store over 600MB of data on them, database backup technologies have over time been augmented by exceptional gains in the performance of software for storage and recovery as well. Database backup is an essential task of any DBA and in previous generations the use of tapes and removable disks were commonplace. Today however there is a definite focus on how to use the Web for backups through sites including, iDrive, and a service run by EMC Corporation to back up data in the MB range within minutes. For the DBA then the question of which backup technology best fits with the strategic direction of the company, including support for accessibility vs. archivability. The need for creating backups of entire systems and databases can now be automated with these tools, and is often used by DBAs to manage the task.

Database Recovery


Sources Used in Documents:

references and real-time workload in information services. Information Systems Research, 11(2), 177-196.

Pangalos, George (1994). A tutorial on secure database systems. Information and Software Technology, 36(12), 717.

Gerald Post & Albert Kagan (2001). Database management systems: Design considerations and attribute facilities. The Journal of Systems and Software, 56(2), 183-193.

Ji Ma, Mehmet A Orgun. (2008). Formalising theories of trust for authentication protocols. Information Systems Frontiers, 10(1), 19-32.

Reagan, J., & Rowlands, I.. (2007, January). Key Technologies Enabling a Seismic Shift in Enterprise Data Management. Business Intelligence Journal, 12(1), 17-25.

Cite this Document:

"Database Administration Today In Evaluating" (2009, July 22) Retrieved October 24, 2021, from

"Database Administration Today In Evaluating" 22 July 2009. Web.24 October. 2021. <>

"Database Administration Today In Evaluating", 22 July 2009, Accessed.24 October. 2021,

Related Documents
Database Administrator Manager of It and the Value of a College Education...
Words: 1972 Length: 6 Pages Topic: Education - Computers Paper #: 20408313

Database Administrator, Manager of IT, and the value of a college education As a result of swift distribution of computers and information technology, a necessity for well trained workers to design and promote new hardware and software systems and to integrate new technologies. These workers comprises of computer systems analysts, database administrators, and computer scientists. Based on the choices and procedures of employers and on development of new areas of specialization

Gun Laws: Public Administration
Words: 1785 Length: 5 Pages Topic: Law - Constitutional Law Paper #: 24701190

Public Administration: Gun Laws The disturbing images of distraught children and staff members at the Sandy Hook Elementary School scampering for safety as a gunman who had calmly made his way into the school compound shot indiscriminately, killing 26 innocent persons, among them 20 children are still vivid, almost three years after the incident. This was not even the first incident of mass gun violence in the country -- approximately 36

What It Means to Be a Pharmacist Today
Words: 3549 Length: 12 Pages Topic: Health Paper #: 45638350

Pharmacy Practice in the United States From its very beginnings, pharmacy was considered the art of making medicines. Like most arts that originated in earlier times, it came eventually to be regarded as a science in the modern age (Wutoh 2). Throughout history, various cultures have practiced pharmacy by creating drugs "to treat illness, relieve pain, create euphoria and promote health" (Wutoh 3). All of the medicinal creations around the globe

SAP's Internet Marketing Strategy Evaluating
Words: 4815 Length: 10 Pages Topic: Business Paper #: 46570711

Columbus (3) found that within the customer service arena, one CRM capability in particular demonstrated the greatest impact on profit improvement -- customer service execution. Integration into Overall Marketing Strategy SAP seeks to improve global campaigns' effectiveness at generating qualified sales leads, and to do so at lower cost per lead and greater speed over the Internet. To accomplish this SAP conducts an internal evaluation of its Marketing practices and uncovers the

Management Systems Appendix a Project
Words: 3329 Length: 12 Pages Topic: Education - Computers Paper #: 47337090

Another factor in open source database vendors leading this area is the focus on multiple models for scalability as can be seen in Table 1: DBMS Features Analysis. The support of multiple models of scalability also concentrates on OLTP transaction integration specifically within roles as defined in the security model (Pereira, Muppavarapu, Chung, 2006). Security will be discussed later in this analysis. The second factor used to evaluate closed source

Data Warehouse a Strategic Weapon of an Organization
Words: 10375 Length: 38 Pages Topic: Business Paper #: 99774450

Data Warehousing: A Strategic Weapon of an Organization. Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation. The aims of the study are to