You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for data mart


1 to 20 of 23483 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Data Warehousing Guide, 11g Release 1 (11.1)

Glossary

data martfinance. 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

Database Concepts, 11g Release 1 (11.1)

Business Intelligence

Transportable Tablespacesmoving 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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Materialized Views

Loading Data into Data WarehousesA 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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Transportation in Data Warehouses

Overview of Transportation in Data Warehousesdata 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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Overview of PL/SQL

PL/SQL Data Abstractionexplicitly. PL/SQL Data Abstraction Data abstraction lets you work with the essential properties of … data without being too involved with details. After you design a data structure, you can focus on … designing algorithms that manipulate the data structure. Topics: Cursors %TYPE Attribute %ROWTYPE

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Data Access for TriggersDISABLE clause of the CREATE TRIGGER statement. See Also: CREATE TRIGGER Statement Data Access for … guidelines: Queries see the current read-consistent materialized view of referenced tables and any data … changed within the same transaction. Updates wait for existing data locks to be released before proceeding.

Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

BLOB Data TypeYou use the BLOB data type to store large binary objects in the database, inline or out-of-line

Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

CLOB Data TypeYou use the CLOB data type to store large blocks of character data in the database, inline or out … a locator, which points to a large block of character data. CLOB s participate fully in

Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

NCLOB Data TypeYou use the NCLOB data type to store large blocks of NCHAR data in the database, inline or out-of … locator, which points to a large block of NCHAR data. NCLOB s participate fully in transactions

Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

BFILE Data TypeYou use the BFILE data type to store large binary objects in operating system files outside the

Database Data Warehousing Guide, 11g Release 1 (11.1)

Transportation in Data Warehouses

Transportation Using Transportable Tablespacesdatabase 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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Materialized Views

Overview of Materialized View Management Taskslonger 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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Materialized Views

Rolling Materialized ViewsWhen 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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Hardware and I/O Considerations in Data Warehouses

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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Extraction in Data Warehouses

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

Database Data Warehousing Guide, 11g Release 1 (11.1)

Database Data Warehousing Guide - Contents

ContentsConventions 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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Data Manipulation Language (DML) StatementsTo manipulate database data, you can include DML operations, such as INSERT, UPDATE, and DELETE … Processing in PL/SQL. Example 6-1 Data Manipulation with PL/SQL CREATE TABLE employees_temp AS SELECT … the use of PL/SQL records with SQL to update and insert data, see Inserting Records Into the … /SQL variables, see Assigning SQL

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Static SQL

Querying Data with PL/SQLtraditional database programming, you process query results using an internal data structure called

Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

3 PL/SQL Data TypesEvery constant, variable, and parameter has a data type (also called a type ) that determines its … /SQL provides many predefined data types and subtypes, and lets you define your own PL/SQL subtypes. A … subtype is a subset of another data type, which is called its base type. A subtype has the same … data types

Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Data Types

PL/SQL Data Type ConversionSometimes it is necessary to convert a value from one data type to another. For example, to use a … implicit data type conversion. For best reliability and maintainability, use explicit conversion