How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Part I What Is Oracle? → Part I provides an overview of Oracle server concepts and terminology. It contains the following chapters: Chapter 1, "Introduction to the Oracle Server" Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback
Extensibility Services → Figure 1-1 shows the standard services implemented by the Oracle server. This section describes some of these services, not to provide exhaustive descriptions but to highlight major Oracle capabilities as they relate to data cartridge development. Figure 1-1 Oracle Services Text description of the illustration addci009.gif
1 What Is a Data Cartridge? → In addition to the efficient and secure management of data ordered under the relational model, Oracle now also provides support for data organized under the object model. Object types and other features such as large objects ( LOBs ), external procedures, extensible indexing and query optimization can be used to build powerful, reusable server-based components called data cartridges. This chapter
Object Type Body Code → written in C, C++, and other 3GLs must be packaged in a runtime or dynamic link library. This is
Extensible Indexing → and indexing. Oracle's solution is to build an extensible server which lets you define new index … application-specific domain. The cartridge is responsible for defining the index structure … domain index is a schema object. It is created, managed, and accessed by routines implemented as … implementation of the
Installing a Data Cartridge → Data cartridges are packaged so that their constituents (type definitions, PL/SQL packages, external procedures, users, roles, synonyms, and so forth) can be installed into or de-installed from the Oracle universal data server as a unit. See Also: Oracle Universal Installer Concepts Guide Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback
Why Build Data Cartridges? → The Need to Handle Complex Data Objects Over the years, virtually every industry has evolved sophisticated models to handle complex data objects that make up the essence of their business. By data objects, we mean both the structures that relate different units of information and the operations that are performed on them. The simple names given these data objects often conceal considerable complexity
Extending the Server--Services and Interfaces → specialized applications, the basic services have been made extensible. That is, where some aspects of a
Data Cartridge Domains → application domains. Put another way: a data cartridge is typically domain-specific. Domains are … scalar data or complex and multimedia forms of data. Scalar data is data that can be modeled using native … retrieval of textual data is cross-industry in scope, whereas a data cartridge for the storage and … retrieval of legal documents
External Library Code → The external library is the runtime or dynamic link library that contains any 3GL method code. You
DBMS Interfaces → The DBMS interfaces are the simplest kind of extensibility services. DBMS interfaces are made available through extensions to SQL or to the Oracle Call Interface (OCI). For example, the extensible type manager utilizes the CREATE TYPE syntax in SQL. Similarly, extensible indexing uses DDL and DML support for specifying and manipulating indexes.
Extensible Type System → … Historically, mainstream applications have focused on accessing and modifying corporate data that is stored … An object type differs from native SQL datatypes in that it is user-defined and it specifies both … . The syntax for defining object types is discussed in Chapter 3. A method is a procedure or a
Cartridges as Software Components → for data cartridges occurs at the server or is dispatched from the server in the form of an external procedure.
Object Type Specification → with the server. Each domain-specific type is an object type (or ODT, for object data type) and
What Are Data Cartridges? → capabilities into a new domain. This is all possible because the database has itself been made … extensible. That is, you can now customize the indexing and query optimization mechanisms of the database … implementations instead its own when doing your specialized processing. This is all possible because … the database has itself
Data Cartridge Interfaces → index interface whenever an index search or fetch operation is performed. For user-defined query
External Library Linkage Specification → If the implementation of your methods is in C, C++, or some other 3GL, the methods must be packaged … within a runtime or dynamic link library. The external library linkage specification is necessary … libraries, you should be aware of this overhead. In general, the cost of dispatch is less
Extensible Server Execution Environment → server. This ensures that the database server is insulated from any program failures that might occur
Cartridge Basic Service Interfaces → Generic interfaces provide basic services like memory management, context management, internationalization, and cartridge-specific management. These cartridge basic interface services are used by data cartridges to implement behavior for new datatypes in the context of the server's execution environment. These services provide helper routines that make it easy for data cartridge developers to write
Extensible Optimizer → create statistics collection, selectivity, and cost functions. This information is used by the optimizer … in choosing a query plan. The cost-based optimizer is thus extended to use the user-supplied … information; the rule-based optimizer is unchanged. The optimizer generates an execution plan for a SQL … method and chooses the