August 2000
Intermediate to advanced
288 pages
7h 50m
English
Content preview from Oracle Parallel Processing
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Partitioning Techniques
You need to start planning for partitioning during the database analysis and design. In addition to dealing with the usual database analysis and design issues, you need to analyze every application and transaction with respect to the data that it accesses. Then you need to formulate an appropriate partitioning technique for each application.
There are three partitioning techniques that you can use in an OPS environment in order to reduce contention between instances:
- Application partitioning
Aligns applications and nodes in a manner that avoids inter-nodal conflicts.
- Data partitioning
Makes each node responsible for a different subset of the data within a table.
- Transaction partitioning
Makes each node responsible for a different set of tables. Transactions are then routed to the most appropriate node by a transaction monitor or by the applications themselves.
Application Partitioning
Application partitioning is the process of separating database applications in such a way that each OPS node accesses a disjoint set of tables. Figure 11.2 shows two applications that are neatly partitioned between two nodes. Instance 1 runs the sales application, which has its own set of tables. Instance 2 runs the accounts application, which uses a different set of tables.
Figure 11-2. A neatly partitioned application
Tables used by multiple applications are referred to as overlap ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.