Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.



Lecture on Oracle

neil archie menorca

on 25 September 2012

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of ORACLE

Neil Archie T. Menorca ORACLE Oracle Database The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.
Larry Ellison and his friends, former co-workers Bob Miner and Ed Oates, started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex. Object-Relational Database (ORD) An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, just as with proper relational systems, it supports extension of the data model with custom data-types and methods.
An object-relational database can be said to provide a middle ground between relational databases and object-oriented databases (OODBMS). In object-relational databases, the approach is essentially that of relational databases: the data resides in the database and is manipulated collectively with queries in a query language; at the other extreme are OODBMSes in which the database is essentially a persistent object store for software written in an object-oriented programming language, with a programming API for storing and retrieving objects, and little or no specific support for querying. Relational Database Database ORACLE vs. SAP ERP - Enterprise Resource Planning ERP is short for enterprise resource planning.
Enterprise resource planning (ERP) is business management software that allows an organization to use a system of integrated applications to manage the business. ERP software integrates all facets of an operation, including development, manufacturing, sales and marketing. Ampex is an American electronics company founded in 1944 by Alexander M. Poniatoff. The name AMPEX is an acronym, created by its founder, which stands for Alexander M.Poniatoff Excellence Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing computer hardware systems and enterprise software products – particularly database management systems. Oracle is the third-largest software maker by revenue, after Microsoft and IBM. A database is an organized collection of data. The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).
The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS). The database data collection with DBMS is called a database system.
The term database system implies that the data is managed to some level of quality (measured in terms of accuracy, availability, usability, and resilience) and this in turn often implies the use of a general-purpose database management system (DBMS). A general-purpose DBMS is typically a complex software system that meets many usage requirements to properly maintain its databases which are often large and complex. The utilization of databases is now so widespread that virtually every technology and product relies on databases and DBMSs for its development and commercialization, or even may have DBMS software embedded in it. Also, organizations and companies, from small to large, depend heavily on databases for their operations. Data in computing (or data processing) are often represented by a combination of items organized in rows and multiple variables organized in columns. Data are typically the results of measurements and can be visualised using graphs or images. A database management system (DBMS) is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. SAP vs ORACLE
The acronym SAP stands for Systems, Applications and Products in Data Processing. SAP is an Enterprise Resource Planning (ERP) software that integrates several business applications, which are designed for specific business areas. Today, many large corporations such as IBM and Microsoft use SAP products for running their businesses. Oracle database (simply referred to as Oracle) is an Object Relational Database Management System (ORDBMS) that supports a large range of platforms. Oracle DBMS is available in different versions ranging from versions for personal use and enterprise class versions.

What is SAP?
SAP, which stands for Systems, Applications and Products in Data Processing, is an ERP software that integrates several business applications. SAP allows real time management and tracking of sales, productions, finance, accounting and human resources in an enterprise. Traditionally, information systems used in businesses maintained separate systems for managing different business processes like production, sales and accounting. Each of the systems maintained their own databases and interactions between the systems were done in a scheduled manner. In contrast, SAP maintains a single information system for the enterprise and all the applications access common data. Applications interact with each other when real business events occur. For example, when events in sales and productions occur, accounting is done automatically. Sales can see when the production can be delivered, etc., thus the whole SAP system is designed to work in real time. SAP is a very complicated system and it runs on a fourth generation programming language called Advanced Business Application Programming (ABAP). What is ORACLE?
Oracle is an ORDBMS produced by the Oracle Corporation. It can be used in large enterprise environments as well as for personal use. Oracle DBMS is made up of the storage and at least one instance of the application. An instance is made up of processes of the operating system and memory structure that work with the storage. In Oracle DBMS, data is accessed using SQL (Structured Query Language). These SQL commands can be embedded in other languages or could be executed directly as scripts. Furthermore, it can execute stored procedures and functions by invoking them using PL/SQL (procedural extension to SQL developed by Oracle Corporation) or other object oriented languages such as Java. Oracle uses a two level mechanism for its storage. First level is a logical storage organized as tablespaces. Tablespaces are made up of memory segments which in turn are made up of more extents. Second level is the Physical storage made up of data files.
SAP is a complex ERP software that integrates several business applications, while Oracle is a ORDBMS that could be used in enterprise environments. SAP allows real time management and tracking of sales, productions, finance, accounting and human resources in an enterprise, while Oracle DBMS can be used to manage data in the enterprise. SAP is developed to be used with many database systems and it includes interfaces for Oracle as well. During the initial SAP installation, Oracle can be defined as the database that is going to be used and then the SAP system will issue SQL commands that are compatible with the Oracle DBMS.
What is the difference between SAP and ORACLE?
What the FACT!!!??? Clients often ask us which is the "best" ERP system on the market. The most common interest, especially among mid-size to large organizations, is in SAP and Oracle. Of course, as consultants, we don't jump to conclusions and determine the best fit for our clients based on their unique business requirements.
However, our recent benchmark study reveals some interesting insights as to how companies have fared with both SAP and Oracle. The study, which covers over 1,300 implementations across the globe, found that on average, Oracle is implemented in less time and at a lower cost than SAP. Even when adjusted for variances in company size and scope, Oracle is implemented at a lower cost and in less time.

On the other hand, SAP customers are more satisfied than Oracle's. When we look at two metrics - executive satisfaction and employee satisfaction - SAP scored higher than Oracle. In fact, SAP had the highest satisfaction rating of all the ERP vendors included in the study (and there were dozens of them). ERP software consists of many enterprise software modules that are individually purchased, based on what best meets the specific needs and technical capabilities of the organization. Each ERP module is focused on one area of business processes, such as product development or marketing. Some of the more common ERP modules include those for product planning, material purchasing, inventory control, distribution, accounting, marketing, finance and HR.
As the ERP methodology has become more popular, software applications have emerged to help business managers implement ERP in other business activities and may also incorporate modules for CRM and business intelligence -- and present them as a single unified package.
The basic goal is to provide one central repository for all information that is shared by all the various ERP facets in order to smooth the flow of data across the organization.
Full transcript