Oracle XML DB Developer’s Guide 10g

Oracle XML DB provides high-performance storage and retrieval of XML. It extends Oracle Database, by delivering the functionality associated with both a native XML database and a relational database. It include the following features:

Supports the World Wide Web Consortium (W3C) XML and XML Schema data models and provides standard access methods for navigating and querying XML. It absorbs these data models into Oracle Database.

Lets you store, query, update, transform, or otherwise process XML, while at the same time provides SQL access to the same XML data. Similarly it allows XML operations on SQL data.

Includes a simple, light-weight XML repository that allows XML content to be organized and managed using a file/folder/URL metaphor.

Provides a storage-independent, content-independent and programming-language-independent infrastructure for storing and managing XML data. It delivers new methods for navigating and querying XML content stored in the database. For example, Oracle XML DB XML repository facilitates this by managing XML document hierarchies.

Provides industry-standard methods for accessing and updating XML, including W3C XPath recommendation and the ISO-ANSI SQL/XML standard. FTP, HTTP, and WebDAV support make it possible to move XML-content in and out of Oracle Database. Industry-standard APIs allow for programmatic access and manipulation of XML content using Java, C, and PL/SQL.

XML-specific memory management and optimizations.

Enterprise-level Oracle Database features, such as reliability, availability, scalability, and unbreakable security for XML content.

Download Oracle XML DB Developer’s Guide 10g

Oracle Enterprise Manager Concepts 10g

The IT systems of today are growing more complex with each iteration of new technology. It is not unheard of to have 2,600 instances to manage. These instances can be as close as next door or on the other side of the world.

By using Enterprise Manager, you can:

1- Extract the information needed for critical and timely decisions.
2- Manage the extraordinary number of systems in an efficient manner.
3- In conjunction with virus protection software, prevent viruses and worms from attacking your system.
4- Manage your ecosystem, that is, your Oracle platform and all your third-party software, including your storage systems, hosts, routers, and so on.
5- Reduce your hardware and labor costs, that is, manage thousands of systems as if they were one.

Download Oracle Enterprise Manager Concepts 10g

Oracle Database SQL Reference 10g

Dr. E. F. Codd published the paper, ‘A Relational Model of Data for Large Shared Data Banks’, in June 1970 in the Association of Computer Machinery (ACM) journal, Communications of the ACM.

Codd’s model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation, Inc., to use Codd’s model. SEQUEL later became SQL (still pronounced ’sequel’). In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language.

Download Oracle Database SQL Reference 10g

Oracle Database JDBC Developer’s Guide and Reference 10g

JDBC (Java Database Connectivity) is a standard Java interface for connecting fromJava to relational databases. The JDBC standard was defined by Sun Microsystems,allowing individual providers to implement and extend the standard with their own JDBC drivers.

Download Oracle Database JDBC Developer’s Guide and Reference 10g

Oracle Database Java Developer’s Guide 10g

This section covers some basic terminology of Java application development in the Oracle Database environment. The terms should be familiar to experienced Java programmers.

A detailed discussion of object-oriented programming or of the Java language is beyond the scope of this book. Many texts, in addition to the complete language specification, are available at your bookstore and on the Internet. See ‘Suggested Reading’ in the Preface for pointers to reference materials and for places to find Java-related information on the Internet.

Download Oracle Database Java Developer’s Guide 10g

Oracle Database Data Warehousing Guide 10g

A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but can include data from other sources.

Data warehouses separate analysis workload from transaction workload and enable an organization to consolidate data from several sources.

Download Oracle Database Data Warehousing Guide 10g

Oracle Database Advanced Security Administrator’s Guide 10g

To increase efficiency and lower costs, companies adopt strategies to automate business processes. One such strategy is to conduct more business on the Web, but that requires greater computing power, translating to higher IT costs.

In response to rising IT costs, more and more businesses are considering enterprise grid computing architectures where inexpensive computers act as one powerful machine. While such strategies improve the bottom line, they introduce risks, which are associated with securing data in motion and managing an ever increasing number of user identities.

Download Oracle Database Advanced Security Administrator’s Guide 10g

Oracle C++ Call Interface Programmer’s Guide 10g

Oracle C++ Call Interface (OCCI) is an Application Programming Interface (API) that provides C++ applications access to data in an Oracle database. OCCI enables C++ programmers to utilize the full range of Oracle database operations, including SQL statement processing and object manipulation.

Download Oracle C++ Call Interface Programmer’s Guide 10g