Experiment No.
Title: To import source data structures in Oracle.
Course Outcome: Establish scope and necessity of data warehouse for various applications.
Theory:
1. What are Data structures in Oracle.
1)Tables:
The table is the basic data structure used in a relational database. A table is a collection
of rows. Each row in a table contains one or more columns. If you’re unfamiliar with relational
databases, you can map a table to the concept of a file or database in a nonrelational database, just
as you can map a row to the concept of a record in a nonrelational database.
1.1) Editions:
Oracle Database 11g Release 2 introduced a new concept called an edition. An
edition is simply a version of a table, and a table can have more than one edition simultaneously.
Editions are used to implement edition-based redefinition (EBR), useful as table structures evolve
over time.
2)Views:
A view is an Oracle data structure constructed with a SQL statement. The SQL statement
is stored in the database. When you use a view in a query, the stored query is executed and the
base table data is returned to the user. Views do not contain data, but represent ways to look at the
base table data in the way the query specifies.
3)Indexes:
An index is a data structure that speeds up access to particular rows in a database. An
index is associated with a particular table and contains the data from one or more columns in the
table.
2. Steps to import data structures in Oracle.
To import metadata from a source:
1. Review the list of supported sources and targets in Table 1-1, "Sources and Targets Supported
in Oracle Warehouse Builder 11g Release 2 (11.2)" to determine if the source from which data
needs to be extracted is supported in Oracle Warehouse Builder.
2. Select an existing location or create a location:
To create a location:
2.1. In the Locations Navigator, expand the Locations node and then expand the node that
represents the type of location to create.
2.2. Right-click the type of location and select New <Object> Location.
2.3. Complete the dialog box. Click the Help button for additional details.
3. Create a module for the source metadata:
3.1To create a module: Expand the Projects Navigator until you find the node for the
appropriate metadata type.
3.2 Right-click the desired node and select New<Module Type>.
3.3 On the Name and Description page, provide a name and an optional description for the
module. For non-Oracle sources and applications, do not select the access method. Select
from Native Database Connection and Oracle Gateway.
3.4 Click Next. The Connection Information page is displayed.
3.5 Provide details about the location associated with the module. The contents of the
Connection Information page depend on the type of module created. For more information
about providing information about this page, click Help.
3.6 Click Next to display the Summary page. Review the information provided and click Back
to modify entered values.
3.7 Click Finish.
4. Right-click the module and select Import.
5. You can import metadata from database objects, flat files, COBOL copybook files, and
Oracle Warehouse Builder metadata.
6. Follow the prompts in the Import Metadata Wizard.
7. The wizard prompts you for information based on the type of source you selected. For
more information, see "Using the Import Metadata Wizard".
Conclusion:
Thus, data structures in Oracle and steps to import data structures in Oracle have been studied.
Assessment Scheme:
Process Related Product Related Total
Sign of Teacher
(15 Marks) (10 Marks) (25 Marks)