Database Design Term Paper

Pages: 5 (1421 words)  ·  Bibliography Sources: 5  ·  File: .docx  ·  Level: College Senior  ·  Topic: Education - Computers

Database

What is a database? Is a database the same as a database management system (DBMS)? Why or why not?

A database by definition is a collection of data records organized in a relational data structure which makes them capable of being replicated, retrieved and analyzed in a myriad of applications or use cases. The majority of databases in use today are based on relational technology, with the minority relying on object-oriented schema (Velicanu, Litan, Virgolici, 2010). Object-oriented databases, due to their data structures, are more attuned to the specific needs of the engineering and scientific community (Jadhao, Bamnote, 2012). Databases has progressed rapidly in the last decade, including advanced Structural Query Language (SQL) support, great Business Intelligence (BI), analytics and support for Big Data initiatives (Velicanu, Litan, Virgolici, 2010).

Download full Download Microsoft Word File
paper NOW!
A Database Management systems (DBMS) differs from a database in that the latter is a single enterprise application typically and a DBMS is a collection or set of programs that are combined to capture, analyze, modify and report data (Ahlswede, Aydinian, 2011). Database management systems are often designed for a highly specific purpose in a business or organization. While there are many different structures inherent in the definition, implementation and use of a DBMS, the most common structures are flat, hierarchical, relational and network-based (Velicanu, Litan, Virgolici, 2010). These network architectures are deliberately designed to ensure the analysis, data and results achieved with these systems are directly applicable to specific business strategies, objectives, needs of the business and its many stakeholders (Ulusoy, 1998). DBMS systems are also designed to support more advanced (Kinsley, Hughes, 1988).

Identify at least three popular DBMS's in use today and note some of their common features.

TOPIC: Term Paper on Database Design Assignment

Three of the more popular databases actively in use today include IBM DB2 Version 10.1, Microsoft SQL Server 2012 and Oracle 11g Release 2. All three of these databases share a common foundation of Structured Query Language (SQL) support, shell scripting using PERL and advanced programming languages for shell script and automated workflow support. In addition, all three databases have the ability to manage auto-completion of tables, tasks and records, in addition to support for multi-server support as well. All have extensive support for data import, export and reporting, in addition to support for exporting data in a variety of formats and data structures as well. Each of these databases also supports the four foundational elements of data atomicity, consistency, isolation of data elements and structures and durability (ACID) compliance (Ahlswede, Aydinian, 2011). ACID compliance is what gives these databases the ability to scale reliably and manage many millions of transactions on a daily basis, while also managing parallel functions including reporting, data analysis, and advanced data structure development.

How are DBMS's used today? Describe the benefits of DBMS.

Databases are the foundation of enterprise applications today, supporting the performance of entire enterprises, across a very broad scope of applications. Databases are powering the accounting and finance, Customer Relationship Management (CRM), Human Resource Management (HRM), Enterprise Resource Planning (ERP), Supply Chain Management (SCM), Project and Proposal Management (PPM) and a wide spectrum of service systems as well. (Velicanu, Litan, Virgolici, 2010). What the use of databases have in common across this broad base of applications is the functioning as a system of record and foundation for analyzing the performance of each system relative to the other (Kinsley, Hughes, 1988). Databases are also used extensively for managing the most complex aspects of an enterprise, including distributed order management, service lifecycle management and warranty management (Ulusoy, 1998).

The benefits of databases include the ability to complete very rapid, complex inquiries of data, support several thousand users concurrently, in addition to data portability and greater flexibility in simplifying complex processes. There are also many benefits that are based on the ACID compliance of databases, including their scalability and support for highly synchronized, complex transactions. Databases often have a low Total Cost of Ownership (TCO) over time due to their ability to manage multiple data tasks and roles concurrently throughout an organization (Suciu, 2012). Databases also deliver exceptional value for managing multiple customer groups or audiences, providing insights into how best to complete integrated marketing communications (IMC) strategies in the process. All of these factors of databases are unified by their reliance on… [END OF PREVIEW] . . . READ MORE

Two Ordering Options:

?
Which Option Should I Choose?
1.  Download full paper (5 pages)Download Microsoft Word File

Download the perfectly formatted MS Word file!

- or -

2.  Write a NEW paper for me!✍🏻

We'll follow your exact instructions!
Chat with the writer 24/7.

Database Technology and Database Administration Essay


Database Design Describe Factors That Affect Essay


Health Care Database Design and Management Term Paper


Database Administration Thesis


Databases Access SQL MS SQL Server 2000 Oracle DB2 and Mysql Term Paper


View 200+ other related papers  >>

How to Cite "Database Design" Term Paper in a Bibliography:

APA Style

Database Design.  (2012, November 2).  Retrieved October 24, 2021, from https://www.essaytown.com/subjects/paper/database-design/1620397

MLA Format

"Database Design."  2 November 2012.  Web.  24 October 2021. <https://www.essaytown.com/subjects/paper/database-design/1620397>.

Chicago Style

"Database Design."  Essaytown.com.  November 2, 2012.  Accessed October 24, 2021.
https://www.essaytown.com/subjects/paper/database-design/1620397.