Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 9
Introduction to Database Administration
Oracle Schema Objects &
Data Access Oracle Schema Objects & Data Access Oracle Schema Objects & Data Access
• Schema Objects • Types of Schema Objects • Tables • Indexes • Tables & Indexes in a Schema • Views, Sequences & Synonym • Data Access Oracle Schema Objects & Data Access Schema Objects • Physical data storage is independent from logical data structures • Schema is a collection of data structures, or schema objects • Schema is owned by the database user name. • Schema objects such as tables, views, indexes and sequences etc. are user- created structures that directly refer to the data (files) in the database. • BMS created objects are data dictionary views, user’s roles etc. Oracle Schema Objects & Data Access Types of Schema Objects • Tables • Indexes • Constraints • Sequences • Views • Triggers • Sequences • Synonym • PL/SQL subprograms and packages, Java Classes etc. Oracle Schema Objects & Data Access Tables • Basic storage unit or schema object for storing data in structured form • Table consists rows and columns with specific data types of columns • Maximum number of columns are 255 and unlimited number of rows or tuples in a table • Every table is uniquely identified in a schema • Integrity constraints such as NOT NULL, CHECK and PKs etc. are applied on table's columns Oracle Schema Objects & Data Access Indexes • An index is an optional data structure that can be created on one or more columns of a table.
• Index can increase performance of
data retrieval
• Index can be created on searching
columns
• Indexes are physically and logically
independent Oracle Schema Objects & Data Access Tables & Indexes in a Schema Oracle Schema Objects & Data Access Views, Sequences & Synonym • Stored queries are called Views. Views do not keep separate data rather they extract data from tables
• A Sequence is a user-created object
that can be shared by multiple users. It can be ised for PK column.
• A Synonym is an alias for another
schema object and does not require separate storage Oracle Schema Objects & Data Access Data Access • Data is accessed by SQL from DBMS.
• PL/SQL, Java are also used to access
the data from DBMS
• Data is accessed by sub languages
DML and DCL.
• Data is accessed in logical schema
from physical data files through internal schema. Access paths for data access may varied.
