Database Reference
In-Depth Information
Summary
The MDS, or Metadata Services, is a repository used by Oracle SOA Suite
11g
to store metadata of composites and their customizations that are deployed to
the service infrastructure. The Dehydration Store, on the other hand, maintains
instance related information. As an Oracle SOA Suite
11g
administrator, you will
likely be required to manage both of these database-based repositories.
This chapter covered numerous administrative activities as they pertain to the
MDS and Dehydration Store, namely:
•
Introducing file-based and database-based MDS repositories, as well as how
to register database-based MDS repositories with an Oracle SOA Suite
11g
environment.
•
Creating and cloning metadata repository partitions.
•
Deploying MARs as well as importing and exporting metadata to and from
MDS partitions to promote or replicate code and shared artifacts across envir-
onments.
•
Understanding the underlying database objects that comprise the Dehydra-
tion Store.
•
Understanding configurations that impact the Dehydration Store and ways to
measure database growth through SQL queries.
•
Purging through the use of Oracle Enterprise Manager Fusion Middleware
Control as well as single-threaded and multithreaded purge scripts and re-
claiming freed space.
•
Implementing database partitioning on the Oracle SOA Suite
11g
product
tables for improved data management and performance.
In the next chapter, we wrap up with the last major tasks surrounding Oracle SOA
Suite
11g
administration; backup and recovery.
