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
data mart → finance. In a dependent data mart, the data can be derived from an enterprise-wide data warehouse. In … an independent data mart, data can be collected directly from sources. … A data warehouse that is designed for a particular line of business, such
Loading Data into Data Warehouses → A popular and efficient way to load data into a data warehouse or data mart is to use SQL*Loader … with the DIRECT or PARALLEL option, Data Pump, or to use another loader tool that uses the Oracle … -phase. In one-phase loading, data is loaded directly into the target table, quality
Overview of Transportation in Data Warehouses → data warehouse to a data mart Transportation is often one of the simpler portions of the ETL process … Transportation is the operation of moving data from one system to another system. In a data … warehouse environment, the most common requirements for transportation are in moving data
Transportable Tablespaces → moving data from a staging database to a data warehouse, or in moving data from a data warehouse to a data mart. … Transportable tablespaces are the fastest way for moving large volumes of data between two Oracle … systems. Previously, the most scalable data
Transportation Using Transportable Tablespaces → database to a data warehouse, or in moving data from a data warehouse to a data mart. Transportable … the data warehouse to the data mart. Step 1 Place the Data to be Transported into its own … file jan_sales.dmp to the data
Configure I/O for Bandwidth not Capacity → , consider a 200GB data mart. Using 72GB drives, this data mart could be built with as few as six drives … Storage configurations for a data warehouse should be chosen based on the I/O bandwidth that they … data, but cannot provide the same I/O throughput as a larger number of small
Overview of Materialized View Management Tasks → longer useful. After the initial effort of creating and populating the data warehouse or data mart, the … materialized views should be dropped. Archiving old detail and materialized view data that is no … incremental changes from the operational systems. Transforming the data. Verifying that the incremental
Rolling Materialized Views → When a data warehouse or data mart contains a time dimension, it is often desirable to archive the … few fast partition maintenance operations provided the unit of data that is rolled out equals, or is … data warehouse, you should determine how frequently you plan to perform partition maintenance
Extraction Through Distributed Operations → … country_name='United States of America'; This statement creates a local table in a data mart, country_city … Oracle gateway technology. Specifically, a data warehouse or staging database can directly access … tables and data located in a connected source system. Gateways are another form of distributed-query
Contents → Conventions What's New in Oracle Database? Oracle Database 11g Release 1 (11.1) New Features in Data … Warehousing Oracle Database 10 g Release 2 (10.2) New Features in Data Warehousing Part I Concepts 1 … Data Warehousing Concepts What is a Data Warehouse? Subject Oriented Integrated Nonvolatile Time … Variant
13 Defining Oracle Data Objects → After you finish designing your data warehouse or data mart, you are ready to design your target … system. Most of your target schema modelling takes place within the Data Object Editor. This chapter … shows you how to use the Data Object Editor to create data objects.
subject area → knowledge. A data mart is often developed to support a subject area such as sales, marketing, or geography.
Benefits of Using Transportable Modules → modules to copy from a read-only data mart to multiple departmental databases. In this way, you can use … relatively less time, you can publish and distribute a data mart for daily analytical or business … Before the introduction of transportable modules, the most scalable data transportation method
third normal form schema → significant data loading requirements that is used to feed a data mart and execute long-running queries. Compare with snowflake schema and star schema. … normal form schemas are sometimes chosen for a large data warehouse, especially an environment with
Contents → Documentation Where to Find Database Tuning Documentation Conventions What's New in Oracle Data … Mining Administration No DMSYS Schema Mining Models in the Oracle Data Dictionary Enhanced Security … Scoping of Nested Data Enhanced Handling of Sparse Data Features Not Available in This Release … Create a Data
Contents → Documentation Accessibility Related Documents Conventions What's New in Oracle Data Guard Broker? New … Features in Data Guard Broker 11.1 1 Oracle Data Guard Broker Concepts 1.1 Overview of Oracle Data … Guard and the Broker 1.1.1 Data Guard Configurations and Broker Configurations 1.1.2 Oracle Data
Contents → Documentation Accessibility Related Documentation Conventions What's New in Oracle Data Mining? Oracle … Data Mining 11 g Release 1 (11.1) New Features Oracle Data Mining 10 g Release 2 (10.2) New … Features Part I Introductions 1 What Is Data Mining? What Is Data Mining? Automatic Discovery Prediction
Contents → Documentation Accessibility Related Documents Conventions What's New in Oracle Data Guard? Part I … Concepts and Administration 1 Introduction to Oracle Data Guard 1.1 Data Guard Configurations 1.1.1 … Primary Database 1.1.2 Standby Databases 1.1.3 Configuration Example 1.2 Data Guard Services 1.2.1 Redo … Transport
Contents → Documentation Accessibility Related Documentation Conventions What's New in Oracle Data Mining? Oracle … Data Mining 11 g Release 1 (11.1) New Features Oracle Data Mining 10 g Release 2 (10.2) New … Features 1 Data Mining API Use Cases Analyze Customer Demographics and Buying Patterns Segment Customer … Base and
About Transportable Modules → modules can also be used for publishing data marts. A data mart is normally a portion of a larger data … warehouse for single or departmental access. At times, creating a data mart amounts to copying what has … deploy a data mart to multiple locations.