| Team Fly | |
Each manufacturer that supplies parts is uniquely identified by a ten-character manufacturer_id. When a new manufacturer is registered with the system, it is assigned a quad_id based on its location.
Each item in the store's inventory is uniquely identified by a ten-character part_id, and must be associated with a valid manufacturer_id.
Based on these three points, practitioners commonly develop statements similar to the following to describe the relationships between locations, manufacturers, and parts:
There is a one-to-many relationship between locations and manufacturers—more than one manufacturer can reside in a specified location.
There is a one-to-many relationship between manufacturers and computer parts—the store purchases many different parts from each manufacturer.
These two relationships are established as data is captured in the store's database and other relationships can be deduced as a result—for example, one can safely say ''parts are manufactured in one or more locations based on the fact that there are many manufacturers supplying many different products." Oracle has always been a relational database product, commanding a significant percentage of market share compared to its major competition. Let's get started and look at the Oracle Database 10g architecture.
As with many new software experiences, there is some jargon that we should get out of the way before starting this section.
Oracle Database 10g is said to be started when the appropriate commands have been invoked to make it accessible on a day-to-day basis to applications.
The act of stopping Oracle Database 10g is called shutdown. When Oracle Database 10g is shut down, nobody can access the data in its files.
An instance is a set of processes that run in a computer's memory and provide access to the many files that come together to define themselves as Oracle Database 10g.
A background process supports access to a started Oracle Database 10g, playing a vital role in Oracle's database implementation. Various background processes are spawned when starting the database and each performs a handful of tasks until a database is shut down.
Let's now look at the assortment of files and background processes that support the Oracle Database 10g.
| Team Fly | |