Oracle Database - Sample Schemas

Card Puncher Data Processing

Database

Oracle Database provide Sample Schemas which are filled with sample data.

List

SH

Schema Sales History (SH) is designed to allow for demos with large amounts of data. An extension to this schema provides support for advanced analytic processing with OLAP Services

The SH schema is an Oracle Database Sample Schemas. It is used on this web site for a lot of example and you can find it in a lot of Oracle By Example Series.

SCOTT

SCOTT is a simple database schema with two tables EMP and DEPT but as this is a minimal model, it tends to deprecated in the Oracle documentation.

From an Oracle installation (@ ?/rdbms/admin/scott.sql)

  • EMP, 
Name                             Null?    Type
 -------------------------------- -------- ----------------------
 EMPNO                            NOT NULL NUMBER(4)
 ENAME                                     VARCHAR2(10 CHAR)
 JOB                                       VARCHAR2(9 CHAR)
 MGR                                       NUMBER(4)
 HIREDATE                                  DATE
 SAL                                       NUMBER(7,2)
 COMM                                      NUMBER(7,2)
 DEPTNO                                    NUMBER(2)
  • DEPT, 
Name                             Null?    Type
 -------------------------------- -------- ----------------------
 DEPTNO                           NOT NULL NUMBER(2)
 DNAME                                     VARCHAR2(14 CHAR)
 LOC                                       VARCHAR2(13 CHAR)
  • BONUS 
Name                             Null?    Type
 -------------------------------- -------- ----------------------
 ENAME                                     VARCHAR2(10 CHAR)
 JOB                                       VARCHAR2(9 CHAR)
 SAL                                       NUMBER
 COMM                                      NUMBER
  • SALGRADE
Name                             Null?    Type
 -------------------------------- -------- ----------------------
 GRADE                            NOT NULL NUMBER
 LOSAL                                     NUMBER
 HISAL                                     NUMBER

Obiee

The Oracle By Example Series for the version 10g of OBIEE is also based on this schema. If you know all the steps to configure OBIEE, you can find the archive which contains the metadata based on the SH schema here: sh.zip

Installation

From a database installation

With the start sql plus command after database installation 

@?/rdbms/admin/utlsampl.sql

From git

oracle/db-sample-schemas

Reference




Discover More
Obiee Logical Sql Densification
Blog - Obiee 10G - Densification with the OBIEE logical Sql (Sparse to dense data)

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. And it’s also the most problem that you have when you...
Card Puncher Data Processing
Calcite - Relational Operator (RelNode)

in Calcite. They are used to build a relational expression. Because of the chaining nature of a relational expression, a relational operator is also a relational expression and share the same interface...
Data System Architecture
Dimensional Data Operation - Data Densification (sparse to dense data) - Preservation of the dimensions

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. The densification is also : known as thepreservation...
Mapbuilder Sh Cust Density Advanced Style
Mapviewer - SH Customer Density Semi-Static Map

You must have the sh schema and the spatial demo files installed. As sys : As mvdemo : With Oracle Maps, labels are manifest as tool-tips on mouse-over the feature on the map. ...
Data System Architecture
Number - Addition (or Sum, Sigma) or Total

The addition of all numbers in a set is called a total. Sum can be use as: an aggregate or a analytic function. It can follow the full syntax of the analytic function and in this way create It's...
Obiee Aggregate Sum Sum Formula
OBIEE - Aggregation rules in Logical SQL with the GROUP BY and BY clause

This section outlines the rules that the BI Server follows with respect to whether or not a logical query contains a GROUP BY clause and, if a GROUP BY clause is specified, what results you should expect...
Obiee Logical Sql Densification
OBIEE - Densification with logical Sql

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. And it's also the most problem that you have when you work...
Obiee Fact Cross Join
OBIEE - Densification with the fact-based fragmentation capabilities

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. The preservation of the dimensions is is also well known...
Obiee Fragmentation Content One Column
OBIEE - Fragmentation Content, value-based, horizontal partitioning

This capabilities of OBIEE is also known as : Content Fragmentation Value-Based fragmentation Fact Horizontal Partitioning The term Fragmentation is more an OBIEE term whereas the term partitioning...
Obiee Permission Automatic Filter
OBIEE - How to define the BI server security to add automatically a filter when a column is added to an answer (row security level)

“How do we make BI EE to generate different filters for every column(within a dimension) chosen from Answers?” The idea is when you add the column Channel desc from the SH sample schema to an answer...



Share this page:
Follow us:
Task Runner