1 / 16

Brian Saltzmann Chris Bennett IST 210 Professor Charlotte McConn

Brian Saltzmann Chris Bennett IST 210 Professor Charlotte McConn. History of Oracle. Larry Ellison creates the “Software Development Laboratories (SDL)” in 1977 1979 - Changes name to “Relationonal Software, Inc. (RSI)” and introduces ORACLE V2

becka
Download Presentation

Brian Saltzmann Chris Bennett IST 210 Professor Charlotte McConn

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Brian Saltzmann Chris Bennett IST 210 Professor Charlotte McConn

  2. History of Oracle • Larry Ellison creates the “Software Development Laboratories (SDL)” in 1977 • 1979 - Changes name to “Relationonal Software, Inc. (RSI)” and introduces ORACLE V2 • Did not support transactions, but contained some SQL functions • 1983 – new name: “Oracle Corporation” and newer versions follow • 2007 – Oracle v. 10.2.0.1

  3. System Specs • Prior to Oracle 9, Oracle was ported to many platforms. Recently, however, constrained to a smaller range of OS platforms • As of 2006 Oracle was supported by: • Apple Mac OS X • Linux • Windows • Sun Solaris • HP OpenVMS • IBM z/OS

  4. Oracle VS. DB2 VS. MS SQL Server • Oracle and IBM battle for mid-range market (i.e. UNIX and Linux Platforms) • Microsoft more low-end market (i.e. Windows)

  5. Pricing • As of March 2006: • Enterprise Edition: $40,000 per machine processor • Standard Edition: $15,000 per machine processor • Standard Edition can run up to 4 processors but has less features than Enterprise Edition

  6. Benefits to Oracle • Design and manage corporate Metadata • Migrate data from legacy (or existing computer system or application) systems • Consolidate Data from Different Data sources • Clean up raw data

  7. Flash Back Technology • Flashback Database • Flashback Table • Flashback Drop • Flashback Quarry • Flashback Transaction Query • Flashback technology allows the end user to move back and forth through a time window so they may fix or change any sort of corruption or human error that may have occurred in the past.

  8. Oracle Database Security Transparent Data Encryption • This helps protect sensitive data such as credit card numbers in the event of media theft. Media theft can occur due to poor physical security, operating system configuration or backup processes. • Secures data in 5 steps

  9. Oracle SQL Developer • Browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own

  10. Uses XML technology • Extensible Markup Language (XML) • It is a simplified version of SGML which allows everyday people to use it (More end-user friendly) • Considered the sister of HTML The Oracle XML DB feature was first delivered with Oracle9i providing groundbreaking features for storing, retrieving, and manipulating XML data in the database.

  11. Oracle Locator • Oracle Locator provides the features and mapping data needed to locate and enable business applications.

  12. Why Oracle • Other database systems will get the job done for you and is beginning used by thousands of people in the business world • The benefits of using oracle is that it allows you to have more freedom in the program and give you more options and security

  13. Oracle DB 10G • Newest addition of oracle and can be downloaded for free as a trial from www.oracle.com/database

More Related