Oracle, PostgreSQL, MySQL Core Architecture : The Comparison of the Database basic concept including Oracle, PostgreSQL, MySQL

-
EXEM continues to research database technologies at a rapid pase to provide up-to-data resources to our partners and customers. We’re pleased to announce our newest book, “Oracle, PostgreSQL, MySQL Core Architecture”, written by Research & Contents team from EXEM.

Usage of open source database at enterprise is increasing gradually all over the world. But there is a shortage of professional technical books which deal with the comparison between Oracle and the others. If you have to operate system with several kinds of database at your work, this book will help you. You’ll be taught from history to how to operate each database and find what diffrences between each database by reading this book.


Here is just some of what you learn when you read “Oracle, PostgreSQL, MySQL Core Architecture”.

1.   Architecture of RDBMS and MVCC - CHAPTER1
The development of MVCC architecture
The two ways of MVCC
The MVCC mechanism comparison with each DBMS
2.   Oracle Deep Internal – CHAPTER2
History of Oracle
Undo Architecture of Oracle
Oracle MVCC
Oracle block layout
Delayed Block Cleanout
3.   PostgreSQL Deep Internal – CHAPTER3
History of PostgreSQL
MVCC of PostgreSQ
Page layout of PostgreSQL
Page Header
Line Pointer
Tuple Header
Vacuum
The definition and necessity
Vacuum running structure
The standard of Vacuum VS Full Vacuum
XID Wraparound and Freezing
Autovacuum
Structure analysis of VM and FSM
4.   MySQL Deep Internal – CHAPTER4
History of MYSQL
MVCC of MYSQL
Page layout of MYSQL
Purge

5.   References


Konwoo Kwon, CMO at EXEM and Geunho Lee, Manager of Research & Contents team write this book mainly and they said;
“We, the researchers are beginning of a journey that suggest whole new architecture studying 3 of DBMS; Oracle, the most successful DBMS, PostgreSQL, the earlist DBMS, MySQL, the most-used DBMS in era of Internet.”
Researchers are studying for offering information about how change the IT system adminitrators have to manage their system to customers.



Comments

Post a Comment

Popular posts from this blog

JAVA Learning Series l 1st "Setting Environment"

-
Image
Java is the most popular language for working with computers. Android is also based on the Java language. Big-Data, Artificial Intelligence and etc.. have increased the demand for data analysis, and the use of other languages (R, Python) has increased, but it is still the most used language.   [  Tools needed for Java  ] In order to develop J programs, a Java Development Kit (JDK) is required. And let's develop with Eclipse as a text editing tool to make development easier. The JDK includes a compiler (javac.exe) that translates the Java language written in Text into a machine language understood by a computer, and a program that runs compiled Java programs (java.exe). It is an essential tool.     In addition, the JDK provides a set of command toolbars (Java API libraries), and you will learn how to use this command tool one by one.   [  JDK Download & Install  ] The JDK can be downloaded from Oracle, the Java developer.   http:/
Read more

EXEM's New Slogan l 'AI First EXEM 2018'

-
Image
I n the meantime , EXEM has been preparing for the fourth industrial revolution era by promoting artificial intelligence experts and research organizations. ➤ Powerful drive with AI-centric 'Exem 4.0' We are pleased to introduce the new AI capabilities of EXEM, a specialized artificial intelligence company. EXEM has grown by leading the enterprise packaged software market through constant development and research based on software craftsmanship.  Database Performance Monitoring Solution, Max gauge pioneered the DB performance management field for the first time in Korea and introduced MaxGauge for Java, which enables end-to-end application performance management from the perspective of business transaction. It has become a responsible company. In addition, based on our data processing capability, we expanded the market into a big data space, and set up a core engine in the era of the fourth industrial revolution. Now, EXEM is showing a strong
Read more

[2018 Global Industry Revolution Conference l EXEM 4.0 People-centered, Future innovation]

-
Image
      After a successful AWS Summit event, EXEM again participated in the event in a hot summer. EXEM participated in the 2018 Global Innovation Conference in June!   This conference was a network where domestic and foreign businessmen and academics gather together on the theme of "people-oriented future innovation".   EXEM can‘t be missed in this conference! EXEM participated in the conference with strengthened AI Tech (EXEM 4.0). Let me show you how EXEM is at the heart of global industry innovation.     Preparation for Exhibition        We set up a booth early in the morning and were busy preparing to welcome our guests. Above photo is EXEM's exhibition booth and we introduced to our guests how EXEM has enhanced the solution with AI technology.   A new slogan for EXEM 'AI FIRST EXEM 2018' Here, too!        Start of Exhibition        Above photo was taken at 10:00 A.M in the morning and participants started to show u
Read more