Database Comparison Paper

Better Essays

Open Document

Open Document

View Writing Issues

874 Words

Grammar

Grammar

Plagiarism

Plagiarism

Writing

Writing

Score

Score

Database Comparison Paper

Database Comparison Paper
Tania Hillard
Database Management / DBM 502
Pamela Hurd
June 19, 2006 Introduction This paper will compare and contrast four different types of database software. The database software that will discuss is the Microsoft Access, SQL, DB2, and Oracle. A database is the most vital system for a company as it stores mission critical information. The continual failure of a company's database system can only lead to the demise of the organization - companies cannot do business without a working system. A database management system , or DBMS, gives the user access to their data and helps them transform the raw data into information. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages of a computerized database system are speed, accuracy, and accessibility. A database is a structured collection of data. Data refers to the characteristics of people, things, and events.

Types of Database Software
Microsoft Access Microsoft Access is a database software program that runs on Windows applications. Database is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects or sales. Many small companies record customer, inventory, and sales information in a spreadsheet program such as Microsoft Excel. Some of the features of an Access database is that it provides a natural tabular layout as well as customized data entry screens, able to store any number of records up to two gigabytes, allows links between lists of information to reduce data redundancy, and able to create and save multiple report presentation of data. Access can be used to connect to Microsoft Visual Basic applications.

SQL The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through which data can be

Continue Reading

You May Also Find These Documents Helpful

Good Essays
Dbm 381 Week 1paper
- 885 Words
- 4 Pages
Dbm 381 Week 1paper

A database is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships between the entities (Pratt & Adamski, 2012, Chapter 1). How data is received, stored, processed, and made available to others has an effect on the success or failure of an organization. The use of different architecture is a most to fit the needs of the organization, however the value of the data still remains in been able to access and extract information from the database system, and the only way this can be reached is by organizing, storing, and analyzing it effectively. For many organizations these systems have become an essential part of their structural and operational success.…
- 885 Words
- 4 Pages
Good Essays

Read More
Satisfactory Essays
Week 2 Individual Database Design Paper
- 624 Words
- 3 Pages
Week 2 Individual Database Design Paper

“A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input (tech-faq.com)”. To ensure practical use over a long period of, databases ought to be built with high-level of data integrity and the capability to recover data in the event of hardware failure. Data that has been destroyed or corrupted is useless within a business’s data system structure.…
- 624 Words
- 3 Pages
Satisfactory Essays

Read More
Good Essays
Relational Database System Sql Analysis Paper
- 579 Words
- 3 Pages
Relational Database System Sql Analysis Paper

During this assignment I learned “SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. (Interactive Online SQL Training)” In the lessons I learned different things:…
- 579 Words
- 3 Pages
Good Essays

Read More
Powerful Essays
Basic Database Design Concepts
- 2594 Words
- 11 Pages
Basic Database Design Concepts

MS Access is one of the most commonly used applications because it ships with MS Office, which is used by almost everyone now. Access is not actually a database but a GUI (Graphic User Interface) for working on databases, and a (albeit quite basic) DBMS (DataBase Management System). Although Access can be used on any database system, it is usually used as a ‘Front End’ GUI to Access SQL Server ‘Back End’ databases. Recent versions of MS Access shipped complete with a cut down version of SQL Server already built in so can perform several more sophisticated tasks than previous Access versions (which shipped with the Jet Database Engine). Unless the user sets Access to connect to a different database, it will automatically build, and seamlessly connect to, the…
- 2594 Words
- 11 Pages
Powerful Essays

Read More
Good Essays
Microsoft Access and Excel:
- 788 Words
- 4 Pages
Microsoft Access and Excel:

Both Microsoft Access and Microsoft Excel are programs created by Microsoft Corporation as a part of Microsoft Office. Though these two programs are quite similar, they are different in some ways simply because each of them is more efficient at solving certain important tasks. In order for a decision to make the best decision in obtaining maximum efficiency, performance and accuracy when drawing a conclusion as to what software is best for his/her organization, it is necessary for him/her to determine as to which of Microsoft Access or Microsoft Excel best works with the data used in his organization or environment. By expressing their functions using hypothetical scenarios, I will analyze each software and explain their differences as well as which one is good for what company and tasks.…
- 788 Words
- 4 Pages
Good Essays

Read More
Good Essays
Sql Server
- 973 Words
- 4 Pages
Sql Server

The purpose of this paper is to provide a comprehensive review of the SQL Server 2005 Express Edition for Beginners tutorial. The SQL Server 2005 Express database tutorial helps users understand what a database is, it explains how to create tables within a database and how users can covert flat databases into relational databases. This tutorial was basically designed to give users the basic knowledge of creating data bases. Databases are nothing more than a collection of files that work together to store data in a structured way. Some databases are made up simple files and others may require that severs manages connections to files within in a database to authenticate users that’s accessing those files. One of the main focuses of databases is how well organizations manage their database and maintains the accuracy of their data. Companies may want to use databases instead of text files because they provides them with more efficient data integrity, they can store more data, they can retrieve data in multiple ways, databases also provides organizations with the ability to protect their data from unauthorized users and protects their data from being corrupt. Relational Database Management Systems makes managing data for companies easier and it takes care of the difficult tasks associate with integrating data into their applications. Relational databases are the most common type of databases that are used today. The eliminate data redundancy which could cause companies to enter inaccurate data into their databases. Before relational databases were created data was managed by mainframe computers and the storage capacity was limited and very expensive to maintain. Relational databases reduces the amount of space on reel-to-real tapes that each database record required and they also reduced the cost of storing data and provided data integrity. Data integrity refers to the accuracy of the data that organizations are storing. With relational databases…
- 973 Words
- 4 Pages
Good Essays

Read More
Better Essays
Sql Research Paper
- 1325 Words
- 6 Pages
Sql Research Paper

Although many varieties of sophisticated software are available for database construction, they impose very little restriction on their implemented form. Indeed, it would fly in the face of database philosophy to impose the form of implementation, for this would not encourage features like responsiveness to new requests (Bailey, Creel, Grossman, Gutti, and Sivakumar, 55-57). Thus each operational database is unique, even if the software used in constructing it is an industry standard. A piece of advice one gets from software manuals is to develop two mental pictures of one’s unique database. The first picture is of the contents of the database and the way it is organized; and the second picture is of what can be done with the contents.…
- 1325 Words
- 6 Pages
Better Essays

Read More
Powerful Essays
Benefit of DB and Info Gathering Techniques
- 920 Words
- 4 Pages
Benefit of DB and Info Gathering Techniques

I am being interviewed by ACME Global Consulting services as a potential new employee to its growing work force of world-class systems analysts and requirements engineering group. Through a tip, I found out that they will be asking several questions relating to planning for a new database for one of their national restaurant chains. I found out that one of the executives at the restaurant chain only believes in using Microsoft Excel for running reports. For this assignment I will be focusing on 3 main topics. First, I will describe the benefits of using a database management system and how it supports this restaurant chain. Second, I will propose how I would address the issues with flat file systems, such as Excel and Text files, for storing data. Lastly, I will list and describe three tools, techniques, or methodologies for eliciting and documenting requirements related to the development of a new database. So, as you see, you have your plenty of things to get ready for.…
- 920 Words
- 4 Pages
Powerful Essays

Read More
Better Essays
Dbms Report
- 3575 Words
- 15 Pages
Dbms Report

The name ‘database management system’ was chosen recognizing that different names are in use and different types of systems exist. Substantial generalization is assumed in any DBMS of interest without using ‘generalized.’ ‘Data is preferred over ‘information’ for the various reasons cited.…
- 3575 Words
- 15 Pages
Better Essays

Read More
Good Essays
why an excel is not a DBMS
- 549 Words
- 3 Pages
why an excel is not a DBMS

Access is a powerful desktop database management system and it is very suitable for desktop applications with a small number of users accessing it simultaneously. Microsoft Office Access is currently bundled with Microsoft Office Professional or you can buy a standalone version for US$ 139. It has 2 main components; a database engine and a rapid application development (RAD) tool that would generate a business application with minimum coding. Microsoft Office Access is definitely a very user friendly, powerful and flexible tool for small and medium business and its license cost is very reasonable.…
- 549 Words
- 3 Pages
Good Essays

Read More
Powerful Essays
Query Optimization Paper
- 1520 Words
- 7 Pages
Query Optimization Paper

The query optimizer is an important system component of a relational database management system (DBMS). It is the responsibility of this component to translate the user-submitted query - usually written in a non the database. The research literature describes a wide variety of optimization strategies for different quer y languages and implementation environments. However, very little is known about how to design and structure the query optimization component to implement these strategies. This paper proposes a first step towards the design of a modular query optimizer. We describe its operations by transformation rules which generate different QEPs from initial query specifications. As we distinguish different aspects of the query optimization process, our hope is that the approach taken in this paper will contribute to the more general goal of a modular query optimizer as part of an extensible database management system. -procedural language - into an efficient query evaluation plan (QEP) which is then executed against…
- 1520 Words
- 7 Pages
Powerful Essays

Read More
Good Essays
Database Management Systems
- 406 Words
- 2 Pages
Database Management Systems

Database management systems have undergone significant changes over the last thirty years. Starting with IBM’s IMS, a hierarchical database management system, in the early 1970s to the recent grid computing relational database management system – Oracle, the database technology has undergone a substantial technological change. During the last decade, relational management system or a derivative of it has become a de facto standard of the industry. ANSI SQL has become the standard query language to interact with any DBMS, though each vendor has its own extension to the standard SQL. (The Indian Express Limited)…
- 406 Words
- 2 Pages
Good Essays

Read More
Good Essays
Why Databases Are Important to Businesses
- 662 Words
- 3 Pages
Why Databases Are Important to Businesses

Databases are important to businesses for several reasons. To boost operations they use communications, web, and database technologies. Databases are key in all functions relating to information storage and retrieval, and assists with marketing, customers service, financials, and logistics. They are also essential in the creation and maintenance of records for continuous usage and to generate reports from this information. For example, a company could store all customer information and ordering data in Access to use for creating queries and tables to base reports on, supplying them an easy efficient way for entering, and storing data for reports such as invoices.…
- 662 Words
- 3 Pages
Good Essays

Read More
Better Essays
Databases in My Organization
- 986 Words
- 4 Pages
Databases in My Organization

Databases have been in use since the early days of computing programs. An Information Technology services company, such as Getronics, not only utilizes databases for information and record management, it earns revenue by providing database management services. Getronics uses Microsoft SQL Server 2000 as its database software. The clients that contract Getronics for Information Technology services rely and depend on the accuracy and currency of the database information that is stored. Databases will continue to exist and expand as more companies become more of aware of the importance of record and data management.…
- 986 Words
- 4 Pages
Better Essays

Read More
Good Essays
Role of It
- 795 Words
- 4 Pages
Role of It

A database is a collection of related files that are usually integrated, linked or cross-referenced to one another. The advantage of a database is that data and records contained in different files can be easily organized and retrieved using specialized database management software called a database management system (DBMS) or database manager.…
- 795 Words
- 4 Pages
Good Essays

Read More

Related Topics