Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

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
       

 


EnterpriseDB is rapidly becoming the top choice for mission-critical databases, and this is the "Officially Authorized" book on EnterpriseDB database management.

EnterpriseDB is becoming popular for many reasons, foremost being its open source foundation, its ability to run applications written for Oracle, its enterprise-class performance and stability, world-class 24x7 technical support, professional tools, and best of all, its attractive pricing.

EnterpriseDB Advanced Server is an increasingly popular choice among savvy database professionals, and this is the definitive reference for this popular technology.

Written by working DBAs and developers, is the indispensable reference to installing, configuring, programming, and administering EnterpriseDB Advanced Server, whether in enterprises deploying new applications or in those migrating legacy applications from Oracle to EnterpriseDB.

Packed with working code—all available for immediate download from the Rampant Books code depot—this great reference takes a hands-on, practical approach to getting the most out of the award-winning EnterpriseDB RDBMS.

Database professionals migrating their enterprises’ existing Oracle infrastructures to EnterpriseDB will particularly appreciate the step-by-step migration tutorial which details the process of migrating a working Oracle application, including its application code, stored procedures, data, and business logic, to EnterpriseDB using the automated Database Migration Toolset.

“EnterpriseDB: The Definitive Reference” also explains how to use the powerful and flexible EnterpriseDB Replication Server to meet a wide array of business challenges, including cost-effective reporting in Oracle environments, high availability and disaster recovery, database performance enhancement, and data transfer.

This all-in-one reference book covers all the fundamentals, advanced techniques, and expert tips, tricks, and hints for using every aspect of EnterpriseDB Advanced Server, including these important topics:

• EnterpriseDB Database Server
• EnterpriseDB Replication Server
• EnterpriseDB Developer Studio
• EnterpriseDB Procedural Language Debugger
• EnterpriseDB Database Migration Toolset
• EnterpriseDB DBA Management Server
 


 

 
 

               
                Expert
                Secrets
            for migrating
             from Oracle

 

Key Features

• Understand the internal features of EnterpriseDB.

• Learn how to migrate legacy databases to EnterpriseDB.

• Understand the benefits of the EnterpriseDB PL/SQL language.

• Learn insider secrets for of the EnterpriseDB product suite.

• Learn how to Replicate mission-critical applications data across the enterprise in near-real time with the EnterpriseDB Replication Server.

• See how to automatically migrate data and business logic from Oracle to EnterpriseDB.

• See how to write Oracle-compatible PL/SQL code with the EnterpriseDB Developer Studio.

• See Learn to use real-time monitoring, profiling, reporting, and querying tools.

• Ensure a smooth and seamless migration from a legacy system to the
EnterpriseDB platform.
 

About the Author:


Lewis Cunningham

  Lewis Cunningham is an Oracle ACE and a Database Architect.  His specialties are Oracle, PL/SQL, SQL, and XML. He also has a fondness for SOA, security and most anything related to databases. He is an Oracle 9i Certified PL/SQL Developer and is a member of several user groups and ACM.

Lewis has been a developer, DBA, manager, team lead, architect and consultant. He has worked with Oracle since 1993. He currently works as a data architect designing and building OLTP and large-scale analytical using Oracle 10g.

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:

 

 
 

Hit Counter

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks