Use this page of the Database Configuration Assistant to select the database features that you want to use in your Oracle database.
Note: Only features that are installed are available in the list. Features that are not installed are unavailable and grayed out.
OLAP (Online Analytical Processing) provides tools for developing and deploying internet-based business intelligence applications. It also provides services that support complex statistical, mathematical, and financial calculations within a multidimensional data model. Oracle OLAP Services consists of the following components:
Oracle's Java API for OLAP
One or more OLAP services that run as child processes of a database instance
OLAP metadata repository in each database instance
Tools within Oracle Enterprise Manager for creating OLAP metadata and managing OLAP services.
Oracle Spatial is primarily used for Geographical Information Systems (GIS) to implement geo-reference and solve queries such as how is something related to a specific location. It provides a way to store and retrieve multi-dimensional data in Oracle. GIS applications can include data capture, data editing, map creation, image processing, image classification, data conversion, data integration, data query, reporting and data analysis.
Oracle Text adds support that enables Oracle to manage multimedia content, both for Internet and traditional applications that need access to image, audio, video, text, and location information. What can you do with Oracle Text?
Search text and analyze documents
Parse, index, and store rich content
Develop content rich Web applications
Deploy rich content on the Web
Tune Oracle content repositories
Oracle Ultra Search is a text management solution that enables organizations to access text information sources as quickly and easily as structured data. It combines the power and scalability of the Oracle Database and its SQL-based tools with advanced text retrieval technology to help users find exactly the information needed. Together, these technologies allow enterprises to integrate large-scale document databases with mission-critical applications and provide hundreds or even thousands of concurrent users with fast, efficient access to text-based information.
Oracle Label Security is based on labeling concepts used by government and defense organizations to protect sensitive information and provide data separation. Using Oracle Label Security, application hosting, health care and other industries can also take advantage of data labeling to help solve security requirements in the Internet Age.
For example, in application hosting, a subscriber label can be used to separate data among subscribers in the same application. Oracle Label Security is enforced within the database, providing security even if the application is bypassed. Oracle Label Security provides a dimension of access control which is not easily achieved using existing application data.
If you are registering your database with Oracle Internet Directory, you can click Customize to configure Oracle Label Security with the directory service.
The sample schemas contain scripts for the following types of tables:
Human Resources: The Human Resources (HR) schema is a basic relational database schema. There are six tables in the HR schema: Employees, Departments, Locations, Countries, Jobs, and Job_History. The Order Entry (OE) schema has links into HR schema.
Order Entry: The Order Entry (OE) schema builds on the purely relational Human Relations (HR) schema with some object-relational and object-oriented features. The OE schema contains seven tables: Customers, Product_Descriptions, Product_Information, Order_Items, Orders, Inventories, and Warehouses. The OE schema has links into the HR schema and PM schema. This schema also has synonyms defined on HR objects to make access transparent to users.
Product Media: Product Media (PM) schema includes two tables, online_media and print_media, one object type, adheader_typ, and one nested table, textdoc_typ. The PM schema includes Multimedia and LOB column types. Note: To use Multimedia Text you must create an Multimedia Text index.
Sales History: The Sales History (SH) schema is an example of a relational star schema. It consists of one big range partitioned fact table SALES and five dimension tables: TIMES, PROMOTIONS, CHANNELS, PRODUCTS and CUSTOMERS. The additional COUNTRIES table linked to CUSTOMERS shows a simple snowflake.
Queued Shipping: The Queued Shipping (QS) schema is actually multiple schemas that contain message queues.
Sample Schemas can be installed automatically for you by the Database Configuration Assistant or you can install it manually at a later time. The schemas and installation instructions are described in detail in Oracle Sample Schemas.
The Enterprise Manager Repository schema is used by Oracle Enterprise Manager to store management data about your database. If you have chosen to manage your database locally, this schema is required. For more information about the components of Enterprise Manager, including the Oracle Management Repository, see Oracle Enterprise Manager Concepts.
Oracle Warehouse Builder is a single, comprehensive tool for all aspects of data management. Warehouse Builder leverages the Oracle Database to transform data into high-quality information. It provides data quality, data auditing, fully integrated relational and dimensional modeling, and full life cycle management of data and metadata. Warehouse Builder enables you to create data warehouses, migrate data from legacy systems, consolidate data from disparate data sources, clean and transform data to provide quality information, and manage corporate metadata.
Note: OWB option is dependent on the following options: Oracle Multimedia, Oracle XML DB, Oracle OLAP and Oracle JVM.
Oracle Database Vault helps you address security problems like protection against insider threats, meeting regulatory compliance requirements, and enforcing separation of duty. It provides a number of flexible features that can be used to apply fine-grained access control to your sensitive data. It hardens your Oracle Database instance and enforces industry standard best practices in terms of separating duties from traditionally powerful users. Most importantly, it protects your data from superprivileged users but still allows them to maintain your Oracle databases.
You can configure Oracle Database Vault to manage the security of an individual Oracle Database instance. You can install Oracle Database Vault on standalone Oracle Database installations, multiple Oracle homes, and in Oracle Real Application Clusters (RAC) environments.
Note: Oracle Database Vault option is dependent on Oracle Label Security and DB Control. Database Vault option is enabled only when the user has chosen DB Control to be configured for the database. If the database is configured with Database Vault option, DBCA does not allow switching from DB control to Grid Control.
Click Standard Database Components to display additional standard features that Oracle recommends you configure for your database.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.