Oracle has been committed to supporting and implementing grid computing. Some techniques are new in Oracle Database10g, other technologies are inherent, and there is already many years. Now let's investigate these features from these techniques to function in the grid.
Providing a computing resource is one of the most important features of the grid, which can dynamically provide the computing resource to the application when needed. These resources must be correctly allocated based on business priorities and needs. Oracle provides a number of features for providing computing resources, including:
Real Application Clusters, RACs
Oracle Rac is the key to the standard grid. The RAC is a cluster database with a shared cache architecture that runs on multiple machines that are connected together through a cluster interconnection and a shared memory subsystem. For the user, the Oracle RAC database not only looks like a separate standard Oracle Database 10g, but also tools and processes for maintaining stand-alone Oracle Database 10g can also be used throughout the cluster. All standard backups and recovery operations include the use of recovery management (Recovery Manager), all through RAC transparently. For both configurations, all SQL operations (including data definition language and integrity constraints) are the same. However, the most important feature of RAC is that it can manage workloads based on business processing - add or delete nodes as needed.
Automatic Storage Management (ASM)
Oracle recommends automatically stores a cluster file system that manages database files and Oracle root directories. ASM Advanced Development Manager Rich Long said: "ASM is the new feature of Oracle Database 10g, which simplifies the management of the Oracle database file. SASM only manages a small amount of disk group, not to manage many database files. You can define a special disk The group is the default disk group for the database. "
"ASM provides many benefits as storage technology (such as RAID)." Oracle Cluster and Parallel Storage Technology Vice President Angelo Pruscino added: "Like these technologies, ASM enables you to create a separate disk device on a set of independent disk devices Disk group. Unlike RAID, ASM is strip-shaped and mirror storage in the file level. "
Oracle resource manager (Oracle Resource Manager)
Although Oracle Database 10g is a large extent is a self-managed database, administrators still need to control database resources. One of the important tools for managing resources in Oracle Database is Database Explorer, which allows resource administrators to change the way Oracle database resources to grid users.
Oracle Scheduler (Oracle Scheduler)
Oracle Database 10g also introduces an Oracle scheduler that provides a number of features that arrange and execute business and IT tasks (called jobs) in grid.
Information supply is another important feature supported by Oracle features, which means that information will be provided to users regardless of the user's information, no matter where information is stored on the grid. To process any information on any available resources, the grid must effectively share information across the distributed system. Grids must also enable users to access data stored in different systems (from multiple vendors and file systems). Oracle provides a large number of features and tools to provide information on mesh, which includes:
Oracle removable table space (Oracle Transportable TableSpaces)
Oracle removable tablespace enables Oracle data files to remove, move, or copy them from one database and insert it into another database. Removing or inserting a data file only involves reading or loading a small amount of metadata. The removable tablespace also supports two or more databases simultaneously with read-only table space. Oracle Streams Some data need to be shared when creating or modifying. The Oracle stream flows between the database, nodes, or blade fields in the grid, and can keep two or more backups in synchronization at the time of update. It also provides a unified framework for information sharing, queuing, replicating, events, data warehouses loading, notifications, and publishing / subscriptions into a single technology.
With the release of Oracle Database 10g, the combination of stream / removable table spatial characteristics enables the so-called "self-driven database" of Brajesh Goyal. Oracle's Grid Computing Advanced Product Manager Goyal said: "Use a command you can remove the table space from a database, then send the tablespace to another database. If the second database will be on different operating systems Reformat, then insert table space into the second database and keep the table space synchronize with changes that occur in the first database. If the second database is on the grid, you need to do it. A command migrates the application to the grid. "
Easily install OCI / JDBC
Using Oracle Database 10g, any app that uses Oracle Call Interface (OCILE) can now easily install rare Oracle client files that have little resource, no need to install and configure the entire client. These applications include Java Database Connections (JDBC) Type-2 type drivers. By downloading a small subset of Oracle client files and updating several environment variables to point to the location of the downloaded library, you can easily install the OCI and JDBC TYPE-2 type drivers (requires OCI). This means that your grid client does not have to install any Oracle software, and you can easily and securely access data in the Oracle database running on the grid.
Distributed SQL (Distributed SQL) and Distributed Transactions (Distributed Transactions) (DISTRIBUTED Transactions)
Oracle Distributed SQL enables grid users to effectively access and integrate data stored in multiple Oracle and non-Oracle databases. Using distributed SQL's transparent access to remote data enables grid users to run their applications on any other database without any code modification of the application. While integrating data and management transactions across multiple data memories, the Oracle database intelligently optimizes the execution plan to access data in the most effective way.
Super large database support
In order to support the ultra-large database (Ultra Large Databases, ULDB), Oracle Database 10g introduced an important concept that large file table space (Big file tablespace), which enables the Oracle database to consist of a single big file rather than many small files Table space. This enables the Oracle database to create and manage overall files using the functionality of the 64-bit system. As a result, Oracle Database 10g's capacity is now able to increase to 8 Exabytes, which is 8 times that of Microsoft SQL Server 2000, which is more than 1000 times the volume of IBM DB2.
Because there are some important goals of grids to provide high availability, scalability, and optimal service performance at the lowest cost and minimum complexity, the integrated method management grid is necessary. After several years of hard work, Oracle has provided extensive support for distributed resources in management enterprises. The tools and features provided by Oracle include:
Manage Grid by Oracle Enterprise Manager
Enterprise Manager provides a simplified, centralized management framework for managing enterprise resources and analyzing grid performance. With the enterprise manager, the grid administrator can manage the grid environment through the entire lifecycle of the system from the network from any location of the network. In the case of using Oracle Database 10g, this work includes integrating management and monitoring RAC databases, and managing and monitoring the Alternate Data Protection (Data Guard) system when performing failover and normal switching (SWITCHOVER). Manage the security in the grid
The dynamic environment in the grid is extremely important. Oracle makes security management very easy by using the Oracle Internet Directory (LDAP) of the Lightweight Directory, OICle Internet Directory (OID). In this regard, corporate user security provides the ability to create and manage user privileges across all enterprise databases worldwide. The management of enterprise user rights is completed in OID, so that the same user is not necessary to create the same user in multiple databases of a grid. In addition, there is Oracle Database 10g, you can now store a secure sockets layer, SSL certificate in a smart card to roam access grid.
Virtual private database
Oracle Database Security Advanced Product Manager Sudha Iyer Introduction: "VPD (Virtual Private Database) provides server enhanced, fine access control, and a safe application context that can be used in grid settings for Multiple customers, partners, or departments can securely access critical data using the same database. VPD enables each user and each customer to access data within a single database, and ensure that the data is physically separated. By One or more security policies are associated with tables or views, they can implement VPD. "
Oracle Label Security (Oracle Label Security)
Oracle Label Security provides an administrator with a network-based row (now a collections) security solution to eliminate the need for manually preparing this policy based on the sensitivity control of data. Oracle Database Security Products Management Director Paul Needham said: "With Graphical User Interface (GUI) Tool Oracle Policy Manager, administrators can quickly create Oracle label security policies and assign them into application tables Rows and columns. In addition, Oracle Database 10g has also added an integration of Oracle labels security and OID, enabling you to centrally manage these policies in dynamic changed grid settings. "(End) article: http: // www .chinabyte.com / Enterprise / 218709372618932224/20030924 / 1731138_1.SHTML
