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
power() → This method returns the value of the Number object raised to the power of the value provided by the … parameter specified. Syntax const Number power(const Number &val) const; Parameters val The number to whose power this number has to be raised.
POWER → Syntax power::= Text description of power Purpose POWER returns m raised to the n th power. The … The following example returns 3 squared: SELECT POWER(3,2) "Raised" FROM DUAL; Raised ---------- 9
Testing the Domain Index → This section explains the parts of the power demand example that perform some simple tests of the … domain index. These tests consist of: Creating the power demand table ( PowerDemand_Tab ) and
Creating the Schema to Own the Index → Before you create a domain index, create a database user (schema) to own the index. In the power
Defining the Object Type Methods → definition: TotGridDemand, the total demand for the entire power grid for the hour in question (identified … by SampleTime ) MaxCellDemand, the highest power demand value for all cells for the SampleTime … MinCellDemand, the lowest power demand value for all cells for the SampleTime The logic for each … ...) for this type: --
Power (OraNumber) Method → Feedback Power (OraNumber) Method Applies To OraNumber Description Raises the OraNumber to the power of … OraNumber. Power operand Remarks The result of the operation is stored in OraNumber. There is no
Querying Without the Index → The queries is this section are executed by applying the underlying function ( PowerEqualsSpecific_Func ) for every row in the table, because the index has not yet been defined. The example file includes queries that check, both for a specific cell number and for any cell number, for values equal to, greater than, and less than a specified value. For example, the equality queries are as follows: SET
Analyzing the Database Objects → Analyzing tables, columns, and indexes ensures that the optimizer has the relevant statistics to estimate accurate costs for various access paths and choose a good plan. Further, the selectivity and cost functions defined in the power_statistics object type rely on the presence of statistics. The following statements analyze the database objects and verify that statistics were indeed collected. --
Creating the Functions and Operators → The power demand cartridge is designed so that users can query the power grid for relationships of
Creating and Populating the Power Demand Table → The power demand table is created with two columns: region, to allow the electric utility to use … , Pennsylvania, and so on) is represented by a 10x10 grid. sample, a collection of samplings (power demand … PowerDemand_Tab ( -- Region for which these power demand readings apply region NUMBER, -- Values for each … power
Querying with the Index → The queries in this section are the same as those in "Querying Without the Index", but this time the index is used. The execution plans show that Oracle is using the domain index and not performing full table scans, thus resulting in more efficient execution. For example: SQLPLUS> ------------------------------------------------------------------- SQLPLUS> -- Query, referencing the operators (with
Creating the Statistics Table (PowerCartUserStats) → The table PowerCartUserStats is used to store statistics about the hourly power grid readings … which the statistics are collected The minimum and maximum power demand for the given cell over all … power grid readings The number of non- readings for the given cell over all power grid … power demand
Creating the Extensible Optimizer Methods → The power demand cartridge creates an object type that specifies methods that will be used by the … the method functions created for the power demand cartridge. (Names of all but one of the functions … over all power grid readings. For a given cell, the statistics collected are the minimum and maximum … power
Defining a Type and Methods for Extensible Optimizing → This section explains the parts of the power demand cartridge as they relate to extensible optimization. Explanatory text and code segments are mixed.
Feature Requirements → A power utility, Power-To-The-People, develops a sophisticated model to decide how to deploy its … whose power needs are supplied by other utilities. As pictured, every region is composed of … illustration addci006.gif Within the area represented by each cell, the power used by consumers in … that area is recorded
Queries Not Benefiting from Extensible Indexing → power demand for 13:00 on 01-Jan-1998 does not change after it has been computed.) For queries that … extensible indexing (using the power demand cartridge) include: Find the cell with the highest power … demand for a specific time. Find the time when the total grid power demand was highest. Find all … cells where
Creating the Object Type (PowerDemand_Typ) → The object type PowerDemand_Typ is used to store the hourly power grid readings. This type is used … attributes ( TotGridDemand, MaxCellDemand, MinCellDemand ) that are set by three member procedures Power … demand readings (100 cells in a grid) The date/time of the power demand readings. (Every hour, 100 … areas transmit their
Creating the Indextype Implementation Methods → The power demand cartridge creates an object type for the indextype that specifies methods for the … starting with ODCIIndex ) created for the power demand cartridge. Table 13-4 Indextype Methods … the grid from 1 to 100, and the power demand value in that cell ( cval ). BEGIN -- Construct the SQL … the Export and Import utilities,
Sample Queries → as percentages greater / lesser than specified values? The Power Demand cartridge as implemented is … described in the following class diagram. Figure 13-8 Use Case Diagram for Power Demand Cartridge … about current conditions and from power stations about ongoing power utilization for specific … historical data
13 Power Demand Cartridge Example → This chapter explains the power demand sample data cartridge that is discussed throughout this book … . The power demand cartridge includes a user-defined object type, extensible indexing, and