My experiences with oracle Architecture

These days, it was too busy. The provincial leaders on the 12th wanted to check the progress, so the project team was really a mess. Get off work at every night, and do not rest at noon. Learning over time has become a luxury. Over the past few days, I have a little bit of experience with oracle architecture, so I can write something.

Oracle's excellence was first reflected in cross-platform support. This is the key to oracle's early support for the camp. Let's talk about cross-platform. oracle is just a software running on the operating system. How can oracle be compatible with so many operating system platforms? The architecture of oracle development is worth studying. This is the internal model, mode, and external model architecture. This architecture ensures that the database provides driver interfaces to the operating system and is transparent to users, ensuring that the core architecture of oracle is unified. Later, Oracle acquired java, which is also a language with excellent compatibility. Oracle's acquisition of java ensures the compatibility and stability of its subsequent products. This allows its core engineers to focus only on the development of internal models, so as to free themselves from complicated other edge problems and achieve overall resource planning and coordinated development.

Oracle storage is embodied in the separation of logic and physical structure. There are various files, such as data files and log files, in the physical structure of oracle storage, which are managed by the operating system. Of course, the core is the logic structure, that is, how oracle stores data in the internal environment, and how to ensure effective recovery when data is damaged. Here, the logical structure of oracle includes directory, tablespace, segment, extend, block ), these logical structures ensure effective data storage and save storage resources.

The performance of oracle is reflected in the use of computer hardware platforms. Here, we have to say that the oracle design is really great. Sharing a listening service, each database and one instance ensures the performance allocation between instances. The SGA and PGA architecture is used for memory allocation, which ensures that the disk I/O is greatly reduced and the occupied computer bus is reduced. Implement some complex algorithms internally to monitor the hardware platform and operating system, and manage the operating system platform. Oracle is almost a virtual operating system. In this operating system, oracle fully processes data. Indeed, the general operating system will care about process scheduling, memory management, disk management, bus management, and hardware driver... Oracle only needs to manage data. That is to say, oracle will manage data in a series of ways based on the most appropriate storage, protection, and data methods.

Oracle also requires more excellent and amazing energy. As I study more and more deeply, I believe that oracle is not far from the future. Come on.

This article from "insist on forging ahead" blog, please be sure to keep this source http://bestlanzi.blog.51cto.com/4087355/1110064