IBM DB2 vs Oracle Essay

Question 1: Describe two effects of database tools and  technologies on business performance and decision making.

A database administration framework (DBMS) is a PC programming application that connects with the client, different applications, and the database itself to catch and dissect information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.

Which database management system platform should I use? This is a very common question that developers ask themselves when they work on a project that requires storing and querying data. There are 4 well-known platforms that people may consider; they are: Oracle, Microsoft SQL, Teradata and DB2. This essay will compare and contrast the differences and similarities between these fours platforms.

This must be in your own words and not copied and pasted from the original source. Include the purpose of the database and the subject matter it covers. This may be four or five sentences; and

The first step that you need to take is knowing the product that you will be implementing throughout the project and understand the expected outcome for this implementation. Oracle is a hardware, software, and service company that works to simplify IT solutions of a firm. The use of Oracle package, often known as Enterprise Resource Planning (ERP), in the company will assure productivity increase and improvement controls while lowering costs.

able to answer this lab. Please submit queries as download the results in a CSV file

A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.

New applications will utilize off-the-shelf software components that have been customized per Riordan’s specifications and further messaged to ensure that each application will integrate smoothly with all the others in order to create a single cohesive whole. Great effort will be made to ensure that the data structures used in each are consistent in order to simplify the creation of the enterprise’s database. To help facilitate this, we will create an umbrella application that will integrate each other system as a module. This umbrella application will be extendable as needed and will act as a single-launch point for the various systems utilized by Riordan. We will also be working closely with Riordan’s IT department to develop a bridge that will enable them to easily port their existing databases into the new one automatically.

The company built the first commercial relational database system, and marketed the first products employing SQL (structured query language), now the industry standard (Table 1). Oracle also saw the value of low-cost, client/server systems instead of mainframes, pioneered portable software that today runs on practically all hardware in most computers. In recent years, the company has supported parallel software as the breakthrough that will drive very large database applications. Table 1 illustrates some of the major milestones for the company preceding and during the time of this case.The company 's technology innovations have helped drive the computer industry to where it is today, and has enabled computer users to be more productive and more competitive with systems that cost less but do more. Oracle radically increased it 's sales every year from 1980 to 1989 (Exhibit 1). This focus on software innovation and expansion explains why Oracle 's information management software has been such a leader guiding the world into the Information Age.Table 1. Major milestones for the Oracle Corporation preceding and during the time of this case.

Coronel, C. (2013). Database Systems: Design, Implementation, and Management, Tenth Edition. Mason, Ohio, United States: Cengage Learning.

One advantage to using relational databases include ease of use due to query languages, and the ease of altering the structure due to data independence. In addition, there are no predefined set of relationships between data records in the relational

This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.

In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central

RDBMSs are a common choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data, and other applications since the 1980s. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use. However, relational databases have received unsuccessful challenge attempts

Oracle is one of the premier database and application providers in the Industry. With the support of developers world wide, Oracle offers cutting edge technology in both the public and private sectors. Oracle has taken on many of its partners and today competes with some of the biggest names in the industry, such as: