Novell is now a part of Micro Focus

Oracle8 for NetWare

Articles and Tips: article

01 Sep 1998


Provides details of the recent announcement by Oracle Corp. and Novell to bundle a five-user version of Oracle8 with NetWare 5. Optimized for NetWare, Oracle8 delivers a robust application development and deployment environment. Oracle8 also offers light integration with NDS to provide single sign-on and management capabilities.

Introduction

Oracle Corp. and Novell recently announced that a five-user version of Oracle8 will be bundled with versions of NetWare 4.11 and above, including NetWare 5. NetWare users will thus receive a powerful application platform for immediately developing and deploying network computing solutions including Java applications to streamline their business processes.

This announcement builds on the agreement signed in March 1997 for enhanced integration capabilities between NetWare, Novell Directory Services (NDS), Oracle data server and Oracle Application Server technology. These products are based on open industry standards, including Java, and when deployed together, unleash an enterprise-capable, cross-platform environment. This bundle provides a network computing solution that can reduce system complexity, provide users with faster and more secure access to critical data and applications, improve management of network resources, and reduce total cost of ownership. Since the complete Oracle8 product is included in the bundle, NetWare users can seamlessly add more Oracle8 users in the future.

Novell NetWare provides an ideal server platform for deploying network computing applications primarily because of its manageability, high performance and low cost of implementation. NetWare delivers outstanding scalability as a network application server through enhanced native support for multiprocessor hardware. In addition, new operating system memory protection features bolster the reliability of the platform. Novell has further established NetWare as an application server through strategic initiatives with key partners like Oracle.

The Oracle data server is a reliable, scalable and high performance database for network computing. Optimized for the Novell NetWare platform, Oracle8 delivers a robust application development and deployment environment for developers and end-users. In addition, Oracle8 offers tight integration with Novell Directory Services (NDS) to provide single sign-on and management capabilities.

Oracle8 for NetWare Key Features

System Integration

  • Native support for Symmetric Multiprocessing (SMP)

  • Single process, multithreaded, parallel architecture

  • Dynamic load balancing for high load

  • Novell Directory Service (NDS) Integration

  • Automatic operating system authentication-operating system role/privilege management

  • Direct file system support

  • Asynchronous I/O for high-performance data access

Networking

  • Net8

  • TCP/IP, IPX/SPX, NDS Security and Naming Adapters

Management/Ease of Use

  • Oracle Database Assistant

  • Oracle Web Publishing Assistant

  • Oracle Migration Assistant for Microsoft Access

  • Oracle INTYPE File Assistant

  • Oracle Net Assistant

  • Backup/Recovery Manager

Transaction Processing and Decision Support

Transaction Processing

  • Multithreaded Server Architecture

  • Scalable SMP performance

  • Shared database buffer cache

  • Shared SQL cache (SQL statements, PL/SQL procedures, functions, packages, and triggers)

  • Shared dictionary cache

  • Fast and Group Commits

  • Deferred Writes

  • Serializable Transactions

  • Queuing

SQL Optimizer

  • Cost-based, syntax-independent optimization

  • ANALYZE table statistics generation

  • Histogram statistics

  • Nested-loop and sort-merge join selection

  • "Star" query algorithm support

  • Manual UNION ALL predicate push-down

Transactional Data Access

  • B-tree single column and concatenated column indexes

  • Clustered tables, hash-clusters, application-specific hash functions

  • ROWIDs

  • Query results directly from index lookup

  • Integrated bitmapped indexes

  • Index-organized tables

VLDB support

  • Table partitioning

  • Index partitioning

  • Partition-aware optimizer

  • Concurrency Control and Reliable Results

  • Unrestricted row-level locking

  • No lock escalation

  • Contention-free queries

  • Unique sequence number generation

  • Non-blocking, multi-version, read-consistent query results

Oracle8 Parallel DML

  • Parallel execution of SELECT, INSERT, UPDATE, and DELETE commands

  • Parallel sorts, joins, and aggregates

  • Parallel inserts, updates, deletes

  • Parallel direct database reads and direct database writes

  • Parallelization of user-written code

  • Parallel CREATE INDEX and CREATE TABLE AS SELECT commands

  • Parallel direct-path data loading

  • Fully integrated parallel query architecture

  • Application transparency

  • Supports standard server features/options

  • Dynamic workload balancing

High Availability

  • Online backup by file, table-space, or database

  • Online recovery

  • Parallel recovery

  • Parallel backup/restore utility

  • Point-in-time database, tablespace recovery

  • Incremental backup

  • Read-only tablespaces

  • Mirrored multisegment log files Checksums on database and redo log file blocks

  • Dynamic resizing of database files

  • Standby database

  • Third-party integration of tape backup

Distributed Systems

Distributed Queries and Transactions

  • Transparent remote and distributed query

  • Distributed, optimized joins

  • Location and network transparency

  • Integrated distributed query architecture

  • Transparent, multi-site distributed transactions

  • Distributed SQL updates and remote procedure calls (RPCs)

  • Commit transparency

  • Automatic failure detection and resolution

Open Gateways

  • Data source transparency

  • Transparent SQL gateways

  • Transparent procedural gateways

  • Distributed queries and update transactions

  • Compliant with XA standard for TP-monitor coordinated two-phase commits*

Data Replication

  • Multiple, read-only snapshots (basic primary site replication)

  • Symmetric Replication

  • Updatable snapshots (both master and snapshot tables updatable)

  • Multiple master configurations (full table replication between master sites hybrid configurations (combine snapshot and multiple master configurations)

  • Fail-over configuration support

  • Automatic conflict detection and resolution

  • Distributed schema management

  • Synchronous and Asynchronous Replication support

  • Subquery snapshots

  • Object-Relational Database*

Object Types

  • Object types with constructor methods

  • VARRAY and Nested Table collection types

  • Object ID reference pointers

  • User-defined member methods

  • Ordering methods

Views

  • Relational and object views over relational and object data

  • INSTEAD OF triggers to update views

Client-side Object Support

  • Client-side cache

  • Object support in Pro*C, OCI

  • Object Type Translator utility to generate C header files

LOBs

  • Binary, character LOBs with random, piece-wise access

  • LOB storage inside or outside the database Application Development

SQL Implementation

  • 100-percent ANSI/ISO SQL 92 Entry Level compliant NIST tested

  • ANSI/ISO standard precompilers applications interface (API)

  • Robust SQL extensions including UNION, INTERSECT, MINUS, outer join, and tree-structured queries (CONNECT BY)

  • SQL3 inline views (query in the FROM clause of another query)

  • Updatable join views

Declarative Integrity Constraints

  • 100-percent ANSI/ISO standard declarative entity and referential integrity constraints

  • CHECK, DEFAULT, not NULL constraints

  • PRIMARY, FOREIGN, UNIQUE keys

  • Optional DELETE CASCADE

  • Constraint checking at end of statements or end of transactions

Stored Procedures

  • PL/SQL procedural extension to ANSI/ISO standard SQL Strongly typed variable declarations (SQL datatypes)

  • Block structure flow control, including FOR and WHILE loops, and IF... THEN... ELSE SQL cursor support

  • Static and dynamic SQL support

  • Robust exception handling

  • JSQL Java-stored procedures and triggers

  • Subprogram types: procedures, functions, and packages

  • Subprograms stored in shared, compiled form

  • Called from Oracle and third-party tools==, Oracle Precompilers==, Oracle Call Interface, and other stored procedures and database triggers

  • Remote procedure calls (RPCs) protected by a transparent two-phase commit

  • User-defined PL/SQL functions in SQL

  • Cursor variables for easy retrieval of multi-row result sets

  • Wrapper utility hiding PL/SQL application code in binary source format

  • External procedure callouts

  • Server side file I/O

Database Triggers

  • Procedural code executed automatically on INSERT, UPDATE, or DELETE

  • Triggers execute either BEFORE or AFTER operations

  • Triggers fire once per statement or once per row. Modeled after ANSI/ISO SQL3 specification

Programmatic Interfaces

  • Pro*C/C++ for Windows NT supports Microsoft Visual C++ 5.0

  • Pro COBOL for Windows NT supports MicroFocus COBOL 4.0

  • Embedded SQL and PL/SQL application development

  • 100-percent ANSI/ISO X3.135- 1992 compliant. FIPS flagger meets FIPS 127-2 requirements

  • Oracle Call Interface: procedure/function call interface

  • JDBC and JSQLTM for Java applications

  • Multi-threaded client application support National Language Support

  • Unicode UTF-2 variable-width encoding

  • Per-session control of language preference with system defaults

  • Character set conversion for heterogeneous client/server and distributed database environments

  • National calendar support

  • Dual database character sets Data Security

  • Choice of internal or external user authentication

  • Encrypted passwords

  • Password policy enforcement

  • Global users and roles

  • Full datastream encryption through DES and RSA RC4 encryption algorithms=

  • Complete protocol support and application transparency

  • Fine-grained database privileges

  • Hierarchical role-based security for group-level access control

  • Site customized DBA roles

  • Roles are basis for ANSI/ISO SQL3 security standard

  • Evaluated at US TCSEC C2, European ITSEC E3

  • Automatic auditing on per-session or per-object basis

  • Application-specific or context-sensitive auditing via PL/SQL stored procedures and database triggers Systems Management

Oracle Enterprise Manager

  • Systems Manager easy to use, GUI, menu-driven DBA utility for Windows

  • Secure remote database administration

  • Data Dictionary and Dynamic Performance Tables

  • Application Identification Facility

  • PROFILEs limit user resource consumption

  • Job Queues for automatic scheduling of PL/SQL stored procedure execution

  • Remote SQL Tracing

  • SNMP Support: public RDBMS MIB, Oracle8 private MIB, Replication MIB

  • Table TRUNCATE

  • Enable/disable constraints and triggers

  • Advanced space management features

  • Oracle Expert and Oracle TRACE

= Requires Oracle Advanced Networking Option

== Requires Oracle or third-party tools, Oracle pre-complier, or Oracle SQL*Module

* Requires appropriate optional feature bundle: Advanced Replication option, or Objects option

* Originally published in Novell AppNotes

Disclaimer

The origin of this information may be internal or external to Novell. While Novell makes all reasonable efforts to verify this information, Novell does not make explicit or implied claims to its validity.

© Copyright Micro Focus or one of its affiliates