ISBN:  0-9776715-7-7  Library of Congress Number: 2007928048 722 pages Perfect Bind - 9x7 PD 907 Shelving:  Databases IT In-Focus Series  #5

EnterpriseDB The Definitive Reference The Oracle-Compatible Enterprise database Lewis Cunningham, Oracle ACE Retail Price $59.95 /  £44.95 The Officially Authorized book on EnterpriseDB Order now at 30% off and get access to the code depot! Only $41.95 (30% off)         Key Features   About the Author Table of Contents Index   Reader Comments Errata

About the Author:

Table of Contents:

All examples are elaborated in detail and compared with the other techniques and tools introduced in the book.

Chapter 1 : Introduction to EnterpriseDB Introduction A Mini-History of PostgreSQL Ingres University Postgres Postgres    PostgreSQL    PostgreSQL    PostgreSQL    PostgreSQL Today   PostgreSQL Discussion   PostgreSQL History Wrap-up   A Mini-History of Oracle and PL/SQL   PL/SQL v    PL/SQL v    PL/SQL v    PL/SQL v i   PL/SQL v i   PL/SQL v  g   PL/SQL  g and Beyond   PL/SQL Discussion   PL/SQL History Wrap-up   EnterpriseDB: Enterprise Compatibility   What is EnterpriseDB?   EnterpriseDB Discussion   Why EnterpriseDB?   For the Developer   For the Consultant   For the ISV   The Roadmap   The EnterpriseDB Platform   EnterpriseDB License   Download EnterpriseDB   Components of EnterpriseDB   EnterpriseDB Migration Toolset   Documentation   Support   Support Discussion   Conclusion     Chapter 2: The EnterpriseDB Platform   Introduction   Installing EnterpriseDB   Minimum Requirements & Dependencies   What's in the Install Package?   Installation Walk-through   Starting and Stopping the Database Server   An Introduction to the EnterpriseDB Toolset   EnterpriseDB Developer Studio   EnterpriseDB PL Debugger   EnterpriseDB DBA Management Server   EnterpriseDB Replication Server   EnterpriseDB Migration Toolset   EnterpriseDB Server Architecture   A Look at Oracle's Architecture   EnterpriseDB Architecture   Runtime Configuration    EnterpriseDB Clusters and Databases    EnterpriseDB Schemas    EnterpriseDB Tablespaces    EnterpriseDB Data Dictionary    EnterpriseDB Locking    Conclusion     Chapter  3: EnterpriseDB SQL: A Primer    Introduction    DATA ARCHITECTURE    DATA TYPES    TEXT Data    NUMERIC Data    Date and Time Data    Binary Data    Miscellaneous Types    Why All the Data Types    Database Objects and the Data Definition Language    PERMISSIONS    DATABASE    SCHEMA    TABLESPACE    SEQUENCE    TABLE    Indexes    CREATE INDEX    Synonym    Roles    Domains    Views    Stored Procedures    Triggers    Rules    Partitioned Tables    The Data Manipulation Language (DML)    COMMIT    ROLLBACK    SAVEPOINT    SELECT    INSERT    UPDATE    DELETE    PREPARED STATEMENTS    SQL Functions    Conclusion        Chapter 4: Programming For EnterpriseDB Advanced Server: A Primer    Introduction    Block Structure    Comments    Declaring and Initializing Variables    Records    Collections    Control Structures    Conditionals    Looping    Embedded SQL    Static    Dynamic SQL    Exception Handling    Exceptions    Named Exceptions

SQLCODE and SQLERRM    User Defined Exceptions    RAISE    Exception Propagation    SPL Stored Procedures    Parameters    Declaring and Calling Procedures    Declaring and Calling Functions    Declaring and Calling Packaged Code    Declaring and Understanding Triggers    XML in SPL    Other Programming Languages    Installing a Language    Function Syntax    PL/pgSQL    PL/TCL    PL/Perl    Conclusion      Chapter 5: Development Within EnterpriseDB Advanced Server    Introduction    Developer Studio    Navigation    Menu    Connections    Browsing Connections    Adding Objects    Removing Objects    Migrating Oracle Objects    SQL & SPL Development    Developing with Other Languages    Backup and Restore    Visual Explain    PL/Debugger    Third Party Tools    pgAdmin    EMS SQL Manager for PostgreSQL Lite    Navicat    Conclusion    Chapter  : EnterpriseDB Management Server    Introduction    Home    Home Page    Add/Remove Cluster    Monitoring    User Activity    Lock Status    Buffer Cache    Configuration    View DB Logs    View Audit Logs    SQL    iQuery    Query Profiler    Scheduler    Schedule DB Jobs    View DB Jobs    View Snapshot Jobs    DB Job Logs    Messaging    JMS Destinations  Reporting   Statistics  Meta Data   Procedural Logic  Security    EnterpriseDB Network    Installed Products      View Logs   Automatically Check Updates   Check Updates Now Online Help Conclusion    Chapter  6: Oracle to EnterpriseDB Replication  Introduction      Replication Console     Configure Oracle Administrator      Configure Replication Management Server   Starting the Services   Configure the Publisher (Oracle)    Configure the Subscription    Create Publication      Create Subscription     Snapshot    Synchronize The Schedule      Verify EDB Schema Verify Oracle Configuration   Insert Source Data      Select Target Data      Conclusion    Chapter  7: Oracle Compatibility    Introduction      Administration    Space Management  Database Creation Memory Management & Performance     Availability/Reliability      Security    Client Management Application Design      SQL   Procedural  Conclusion    Chapter  8: TimeTraker  Introduction      Requirements/Architecture     Data Model  Data Dictionary   The Application   Getting Data In   Reporting   Migration   Conclusion

Index Topics:

A ActivePERL     ADA              ADD CONSTRAINT        ADD_XML_RECORD            all_objects     all_synonyms          all_tab_columns       all_tables      all_users       all_view_columns      all_views       applicable_roles      archive_command      Archiving          array    Associative Table    Autocommit        Automatically Check Updates      autovacuum       B BFILE              BIGINT         BINARY         Binary Large OBjects       BINARY_DOUBLE             BINARY_FLOAT              BINARY_INTEGER            Bizgres       BLOB          block-structured     BOOLEAN        Buffer Cache                 BYTEA                C CASCADE                                       CAST               CDE         CHAR     CHAR VARYING         CHARACTER      CHARACTER VARYING    Check Updates Now    check_constraints     Checkpoint        CKPT        Clipper           CLOB          code overloading     Column Privileges    Column Statistics    column_domain_usage         column_privileges          column_udt_usage      columns         Common Development Environment        CONSTRAINT          constraint_column_usage     constraint_exclusion       constraint_table_usage      Constraints report         COPY                    CREATE DATABASE       CREATE INDEX          Create Object       CREATE TABLE          crontab scheduling         CTAS               Cygwin        D Data Definition Language              Data Manipulation Language       data_directory       data_type_privileges        Database Configuration Assistant        Database Server                     DATE     DateStyle      DB Writer         DBA Management Server               dba_role_privs        dba_roles       DBCA      dblink_exec    dblink_ora_call      dblink_ora_record              dbms_application_info      dbms_aq        dbms_job       dbms_output    DBMS_OUTPUT   dbms_pipe      dbms_sql       DBMS_SQL      DBWn    DDL                                                                                DECODE             Developer Studio                                    DML                                                                                                    DOMAIN         domain_constraints          domain_udt_usage      domains         DOUBLE PRECISION     Drop Cascade              Drop Object        Drop Schema    DROP SCHEMA          DROP TABLESPACE       dropdb         DynaTune        E Easy Connect               edb_audit      edb_audit_connect    edb_audit_directory        edb_audit_disconnect       edb_audit_filename         edb_audit_rotation_day     edb_audit_rotation_seconds       edb_audit_rotation_size    edb_audit_statement        edb_dynatune                      edb_package     edb_pkgelements       edb_redwood_date                    edb-postmaster                  element_types         EMS SQL Manager                enabled_roles         EnterpriseDB           EnterpriseDB components   EnterpriseDB license      EnterpriseDB Network       enterprisedb user              EXCEPTION                                             EXECUTE IMMEDIATE      G Grid Output             H \h             hba_file       Heterogeneous Gateway      host     hostnossl      hostssl

I ident_file     IN OUT parameter      IN parameter               INCREMENT           INDEX    Index By Binary_Integer    Indexes Meta Data    information_schema_catalog_name         Ingres           INHERITS       initdb              installation package                  Instant Client        INTERVAL                 iQuery               J jDeveloper    JMS                  K key_column_usage      KILL          L Large Object Import        LIKE     listen_addresses     local    Lock Status    Locking              log_destination      log_directory        log_filename         log_min_messages     log_rotation_size    LONG     LONG VARCHAR         LONGTEXT       LVARCHAR         M max_connections      MEDIUMTEXT     Migration Toolset                        multi-version concurrency control       Multi-Version Concurrency Control      MVCC              MySQL     N Navicat                                      Nested Table           O Object Identifier    OCI             OEM            OID                     Online Migration                    Open-Xchange        Oracle Call Interface     Oracle Enterprise Manager         Oracle Forms            Oracle Process Monitor    OUT parameter                P parameters      password_encryption        pg_aggregate          pg_am     pg_amop         pg_amproc       pg_attrdef      pg_attribute          pg_auth_members       pg_authid       pg_autovacuum         pg_buffercache        pg_cast         pg_class        pg_constraint         pg_conversion         pg_ctl                     pg_database     pg_depend       pg_description        pg_function     pg_group        pg_hba.conf                                  pg_ident.conf                  pg_index        pg_indexes      pg_inherits     pg_language     pg_largeobject        pg_listener     pg_locks        pg_namespace          pg_opclass      pg_operator     pg_pltemplate         pg_prepared_xacts     pg_proc         pg_procedure          pg_rewrite      pg_roles        pg_rules        pg_settings     pg_shadow       pg_shdepend     pg_stat_*       pg_statio_*     pg_statistic          pg_stats        pg_synonym      pg_tables       pg_tablespace         pg_trigger      pg_type         pg_user         pg_views        pgAdmin III                   PL Debugger                          PL/pgSQL                                                                                                                   PL/SQL         PL/TCL                             PLS_INTEGER    PMON    port     Postgres        Postgres      PostgreSQL                             postgresql.conf                PRIMARY KEY    PROCESS_XML_DATA                 Q Query Logging       Query Profiler                          R RAISE     RAW           READ COMMITTED            REAL     redirect_stderr      REDO logs         Redwood                                REF CURSOR              REFERENCES     referential_constraints     Register Management Server       Relational Software  Inc.       Replication Console                                     Replication Server                                          ROLE     role_column_grants          role_routine_grants         role_table_grants     role_usage_grants     routine_privileges          routines        runas       running man icon

S SCALAR types         Schedule Task Wizard       schema         schemata        SEQUENCE       Sequences Meta Data        SERIALIZABLE              Shared Memory       Show Settings report       SHUTDOWN      SHUTDOWN ABORT      SHUTDOWN FAST       SHUTDOWN IMMEDIATE        SHUTDOWN TRANSACTIONAL    Slony-I       SMALLINT       SMON        SPL               SQL   SQL Interactive     SQL LOCK       SQL Terminal                                                            SQL*Loader               SQL*Plus                    sql_features          sql_implementation_info     sql_languages         sql_packages          sql_sizing      sql_sizing_profiles         SQLX               ssl            stats_block_level        stats_command_string                stats_row_level          stats_start_collector      STORED CODE    Structured Query Language     super user              Superset Procedural language     Superset Procedural Language             superuser      SYNONYM        SYSDATE                      sysindexes      sysobjects      systables       systypes        sysusers          T TABLE    table_constraints     table_privileges           tables          Tables Meta Data report    tablespace                                                                                  TEXT     Text Output               TIMESTAMP      TimeTraker     TINYINT        TNS                to_char        to_date        to_number      Tool Command Language      Traker                                  Transparent Network Substrate     TRIGGER        triggered_update_columns          triggers        TT_CALENDAR_ADMIN                        TT_MANAGER_USER_RECORDS    TT_REPORT_OUTPUT                                        TT_USER_ADMIN                                      TT_XML_INTERFACE                                                              U UDT      UNIQUE                             usage_privileges      User Defined Type    user_objects          user_synonyms         user_tab_columns      user_tables     user_view_columns     user_views      USING INDEX TABLESPACE     utl_file       UTL_FILE                                         utl_http       utl_smtp         V Vacuum         VARBINARY      VARCHAR                  VARCHAR         Varray              Very Large Database       VIEW     View Audit Report    View Log                 view_column_usage     view_table_usage      views     Views Meta Data      Visual Explain                                                VLDB           W Write Ahead Log       X xBase   XML DB            XMLElement                         XMLForest                     XMLType                                               XPATH

Reviews:

Errata: