Business Objects Reloads Mid-Market Product Line

Business Objects Reloads Mid-Market Product Line 7/23/2008 By Stephen SwoyerWith new releases of two of its signal SME offerings on tap this week, Business Objects -- now an SAP AG company -- hopes to build on its success in the small to mid-size company market. The rules of the mid-market game are changing, but one thing hasn't changed: SME customers -- much like their larger enterprise brethren -- are still wild about reporting....

Read more »

Decode Function

n Oracle/PLSQL, the decode function has the functionality of an IF-THEN-ELSE statement. The syntax for the decode function is: decode( expression , search , result [, search , result]... [, default] ) expression is the value to compare. search is the value that is compared against expression. result is the value returned, if expression is equal to search. ...

Read more »

Differences between OLTP and OLAP databases.

Differences between OLTP and OLAP databases.Relational Database (OLTP) Data is atomized Data is current Processes many records at a timeProcess oriented Designed for highly structured repetitive processing Dimensional Database (OLAP)Data is summarizedData is historicalProcesses one record at a timeSubject orientedDesigned for highly unstructured analytical process...

Read more »

Operational data store (ODS)

Operational data storeA subject-oriented system that is optimized for looking up one or two records at a time for decision making. An operational data store is a hybrid form of data warehouse that contains timely, current, integrated information. The data typically is of a higher level granularity than the transaction. You can use an operational data store for clerical, day-to-day decision making. This data can serve as the common...

Read more »

Data Mart

What is Data mart? A subset of data warehouse that is stored in a smaller database and that is oriented toward a specific purpose or data subject rather than for enterprise-wide strategic planning. A data mart can contain operational data, summarized data, spatial data, or metadata. Typically, you use a dimensional data model to build a data ma...

Read more »

The Star Schema

A good dimensional data warehouse has a simple database structure. Technically, a simple structure means faster queries. In a dimensional data warehouse, the implementation relational database has two types of tables, the fact table and the dimension table. The fact table consists of the facts (or measures) of the business. Dimension tables...

Read more »

Data warehouse Concepts - Day 2 i

What is datawarehouse?A data warehouse is built on relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization...

Read more »

Data warehouse Concepts - Day 2

dimension table:A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes. LookUp tableA LookUp table is the one which is used when updating a warehouse. When the lookup is placed on the target table (fact table / warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated...

Read more »

Data warehouse Concepts - Day 1

Data warehouse :A Data warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated. This makes it much easier and more efficient to run queries over data that originally came from different sources". Another definition for data warehouse is: " A data warehouse is a logical collection of information gathered from many...

Read more »