Term Paper on "Database Design"
Term Paper 5 pages (1421 words) Sources: 5
[EXCERPT] . . . .
DatabaseWhat 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).
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
download full paper ⤓
Identify at least three popular DBMS's in use today and note some of their common features.
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… READ MORE
Quoted Instructions for "Database Design" Assignment:
“Project Overview
In this assignment, you will research and discuss the following questions regarding databases and SQL:
*****¢What is a database? Is a database the same as a database management system (DBMS)? Why or why not?
*****¢Identify at least three popular DBMS*****s in use today and note some of their common features.
*****¢How are DBMS*****s used today? Describe the benefits of DBMS.
*****¢Describe the features, tools, and utilities of Structured Query Language (SQL).
*****¢How can tasks be automated with SQL?
*****¢How is security implemented in a relational database?
Summarize your findings by giving an opinion on the value of database management systems.
How to Reference "Database Design" Term Paper in a Bibliography
“Database Design.” A1-TermPaper.com, 2012, https://www.a1-termpaper.com/topics/essay/database/1620397. Accessed 4 Oct 2024.
Related Term Papers:
Database Technology and Database Administration Essay
Database Technology Administration
Database Technology and Database Administration
Scenario
The local community library intends to develop a database system to track customers and books that customers will like to checkout.… read more
Essay 15 pages (4402 words) Sources: 15 Style: APA Topic: Computers / IT / Internet
Database Design Describe Factors That Affect Essay
Database Design
Describe factors
Factors that affect the performance of a database:
Design, development, and data entry processes
Factors that affect the performance of a database:
Design, development, and data… read more
Essay 2 pages (779 words) Sources: 3 Topic: Computers / IT / Internet
Health Care Database Design and Management Term Paper
Health Care Database Design and Management
This report is an analysis of how the healthcare and insurance industries have adopted relational database and other related applications software technology to manage… read more
Term Paper 3 pages (1419 words) Sources: 1+ Topic: Healthcare / Health / Obamacare
Database Administration Thesis
Database Administration Today
In evaluating the current field of database administration, the areas of Database Management Systems (DBMS), Database Administrator (DBA) roles and responsibilities, the concepts of database designs, performance… read more
Thesis 11 pages (3489 words) Sources: 15 Style: APA Topic: Computers / IT / Internet
Databases Access SQL MS SQL Server 2000 Oracle DB2 and Mysql Term Paper
Databases: Access, SQL, MS SQL Server 2000, Oracle, DB2, and MySQL
Microsoft Office Access is a multi-user relational database management system. It is designed to allow user to quickly assemble,… read more
Term Paper 4 pages (1213 words) Sources: 1+ Topic: Computers / IT / Internet
Fri, Oct 4, 2024
If you don't see the paper you need, we will write it for you!
We can write a new, 100% unique paper!