Oracle8i: A Beginner's Guide

Overview

Learn to use all the features of Oracle8i using this best-selling introduction to Oracle8i.

The best-selling introduction to Oracle8i officially authorized by Oracle Corporation.

Learn to use all the features of Oracle8i—the most complete and comprehensive platform for building and deploying Internet and enterprise applications. Oracle8i A Beginner's Guide explains the core concepts and new tools included in this fully Web-enabled release of ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (30) from $1.99   
  • New (4) from $8.5   
  • Used (26) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$8.50
Seller since Sat Jan 01 01:01:01 EST 2005

Feedback rating:

(1623)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
New

Ships from: Fort Worth, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$24.47
Seller since Tue Jan 01 01:01:01 EST 2008

Feedback rating:

(171)

Condition: New
0072122048 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$45.00
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$45.00
Seller since Tue Oct 07 09:37:03 EDT 2014

Feedback rating:

(184)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Learn to use all the features of Oracle8i using this best-selling introduction to Oracle8i.

The best-selling introduction to Oracle8i officially authorized by Oracle Corporation.

Learn to use all the features of Oracle8i—the most complete and comprehensive platform for building and deploying Internet and enterprise applications. Oracle8i A Beginner's Guide explains the core concepts and new tools included in this fully Web-enabled release of the most powerful database management system available. Inside,you'll learn to set up,query,manage,and tune your Oracle8i database.

Written by Oracle experts and fully authorized by Oracle Corporation,this official guide shows you how to:

  • Understand Oracle8i architecture,including the hierarchy of objects—from tables and views to roles and grants

  • Install Oracle8i using the new Universal Installer

  • Create tables,query,generate reports,and develop applications with SQL and PL/SQL

  • Tune your database for optimal performance with the Oracle Enterprise Manager (OEM) 2. 0

  • Handle data warehousing and backup and recovery

  • Build,deploy,and manage Web database applications and content-driven Web sites with WebDB

  • Use the industry standard structured query language (SQL)

  • Develop and deploy enterprise Java applications with JDeveloper

Packed with expert information on the Oracle8i Server and all its components,Oracle8i A Beginner's Guide is the only book you'll need to get up and running on the database for Internet computing.


The Beginner's Guide will fully cover the new features in Oracle8i including e-commerce features, supporting mobile workers, advanced queuing, improved data warehousing, and enhanced security to name a few. The book will be organized in the following easy manner for beginners:

  • How new Java components fit into Internet strategy & e-commerce
  • Installation
  • Web developer's suite--WebDB
  • Oracle enterprise manager

Read More Show Less

Product Details

  • ISBN-13: 9780072122046
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 9/1/2003
  • Series: Oracle Press Series
  • Edition description: First
  • Edition number: 1
  • Pages: 765
  • Product dimensions: 7.40 (w) x 9.10 (h) x 1.41 (d)

Meet the Author


MICHAEL ABBEY, has been living and breathing the Oracle Server technology since 1986, having first seen version 3. Michael is a popular presenter at many Oracle user group events in North American and Europe, and has accumulated an avid following. Michael's other passions, Fender Precision bass guitars and grinding rock music, work well alongside his technical skills-frequent and heavy. He can be reached via e-mail at masii@ottawa.com. Michael entertains engagements mainly in the National Capital region around Ottawa, but supports an increasing number of Internet-based clients all over the U.S.A. and Canada remotely.

IAN ABRAMSON, the principal at [AS Inc., in Toronto, Canada, has gained his experience in the Oracle arena in a number of areas over the past fourteen years. His experience designing and delivering Oracle-based applications to numerous clients around the globe has helped him to learn how to get the most from Oracle. Ian currently is the Director of Education Programming for the International Oracle User Group of Americas. While Ian is busy during the day building Oracle applications and Data Warehouses, by night he continues to pursue his dream of being a professional hockey goalie. He can be reached via e-mail at ias@magi.com for Oracle or goaltending services.

MICHAEL COREY co-owner of Database Technologies, Inc., in Newton, MA, has collected quite a following in the Oracle community. He has dedicated numerous hours, months, and years to helping ensure the user community has the active ear of Oracle Corporation. Mike possesses a well-rounded knowledge of Oracle the company and Oracle the software. He offers over 11 years of experience tothe Corey/Abbey team. Mike can be reached via e-mail at mcorey@dbtink.com.

Read More Show Less

Read an Excerpt


Chapter 3: Oracle8i and Object Relational Technology

What Is an Object-Oriented Database?

As we have all heard many times before, Oracle 8.0 was Oracle's first version of the database to incorporate object-oriented technology, and thus Oracle 8.0 was the corporation's first object-relational database. Notice we used the term object-relational database because this implementation is not a pure object-oriented database, nor is it just a relational database. It now represents a hybrid of the two, so let's call it an obiect-relational database.

Today, Oracle has won over the enterprise. People already see Oracle as a mission-critical database able to get them the results they need. People are very comfortable with the technology they bring to the corporate world. Their preference will be to go with the Oracle implementation of the relational database as long as they can bring the key features of object-oriented technologies. Well, Oracle8i represents just that. At this point, we feel they have won the battle and the war. It's also interesting to note that many industry leaders would now concur with this.

To help you appreciate and understand what Oracle8i means to the industry and why object- relational databases will become the standard, we will first discuss object-oriented technologies and then provide an overview of Oracle8i and its key changes.

Unlike the relational database approach-which deals with data at the lowest possible level, a series of columns and rows-the object-oriented approach deals with data at a much higher level; it deals with the objects surrounding the data. In an object-oriented database, when dealing with the customer, you deal with an object called "customer." When dealing with an order, you reference an object called "order." Since an object database understands the object customer and all its relationships, it can easily deal with the object customer and all that is needed to work with it.

in the relational model, order is really a combination of many different tables, with intersection tables holding all the attributes needed to support and maintain an order. In the object model, the database has intelligence about the interrelationships. This is not the case in the relational model. When a change is made to the relational model, it usually translates into a whole new series of tables that must be developed if the model is to continue to work. These relationships must be recrafted by a database designer.

Let's take a closer look at when a customer places an order in a relational database. A number of tables are needed to support that activity. There may be a customer table, an inventory table, a price table, an inventory-price table, a line_item_table, a customer-history table, and so on. in order to manipulate these tables, the programmer must craft the needed code with the required links between tables.

As you can see, the simple act of placing an order requires a number of tables. Rows and columns in tables contain information required for the assembly of the order. A single change to the order process can have a major impact on the underlying tables that support it, requiring a database designer to come in to craft the new relationships and their associated tables to represent those relationships. In the object-oriented model, this is not the case. In fact, it assumes that these relationships will change, and that change is just a natural occurrence and progression.

What Is an Object?

Objects are software representations of real-world entities. To capture the features and capabilities of the real world, objects consist of both attributes and operational information. Remember, in an object-oriented database, the data dictionary not only stores (and allows you to understand) the relationship of one object to another, but also understands the behaviors of the object.

What Is a Class?

When objects are similar to one another in behaviors and other attributes, they can be put together into a class. This concept of classes, parent classes, subclasses, and superclasses allows for a level of abstraction for grouping objects. Think of a class as a template for objects. This helps you in managing very complex objects. This capability to group by class also allows objects to take advantage of similarities of behaviors and other characteristics they share.

Encapsulation

One of the basics of the object-oriented model is the support of encapsulation. Encapsulation is when the data is bound to the object so that access to the data can only happen through the behaviors approved or accepted by that object. This has the direct benefit of protecting the data from illegal access....

Read More Show Less

Table of Contents

1 What Is Oracle? 1
2 The "i" in Oracle8i 43
3 Oracle8i and Object Relational Technology 61
4 Architecture 87
5 Database Objects 115
6 Installation 141
7 SQL 101 183
8 PL/SQL 227
9 Oracle Developer 281
10 Loader 331
11 Application Tuning 101 355
12 Advanced SQL 385
13 Advanced Application Tuning 419
14 DBA 101 455
15 Export and Import 491
16 Backup and Recovery 525
17 Database Tuning 557
18 Advanced DBA 577
19 Data Warehouse Features 631
20 WebDB 663
21 JDeveloper 705
Index 741
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted Thu Oct 12 00:00:00 EDT 2000

    Not a bad transition to Oracle products from academia

    If you understand relational database fundamentals (i.e. schemas, SQL, DDL and DML) this book is an OK introduction to the Oracle 8i product line. It hits every major topic, although lightly, to familiarize yourself with the Oracle 8i architecture and terminology. This book should be used as the first step, in a series of books to read. It is perfect for the former student who has studied general database concepts and would like to learn how to apply these concepts to a real-world product. Be aware, the quality control of editing is not very high. At one point, the text refers at length to a figure that does not exist. Instead of the intended figure, a copy of the previous figure is printed. Also, the word 'what' appears at random points within the text for no reason! This leads the reader to question and suspect several statements made by the author. Lastly, prepare yourself for a moderate does of Oracle propaganda. Bottom Line: Good book (if bought at discount) for the student, but not for the professional familiar with Oracle products.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted Tue Sep 26 00:00:00 EDT 2000

    don't waste your money/time/resources/effort/etc...

    Nothing in the book gets really specific about anything concerning oracle, it's written almost as if it's sole purpose is to get you to buy other oracle press books, if all you know about oracle is the name then this is a good book to pick up and read while at the book store, unfortunately it will confuse you even more as to what oracle is and you will give up and move on to better stuff like MySQL.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)