Concise Oracle Database For People Who Has No Time

Chapter 1- Introduction

A database is a collection of data/information. A Database Management System (DBMS) is a collection of programs that have been written to manage a database. A DBMS acts as an interface between a user and a database. A DBMS that works based on the relational model is referred to as a Relational Database Management System (RDBMS).

Oracle is an Object-Relational DBMS and the leading vendor in the world. Almost half of all RDBMS available worldwide are owned by Oracle. The Oracle database is produced and marketed by the Oracle Corporation. It is the largest software company in the database business field.

Every Oracle Database is made up of Logical and Physical Structures. The Logical Structures are the tablespaces, extents, schema objects and segments. The Physical Structures are the Datafiles, Control File and Redo Log Files.

A databases is divided into tablespaces, which are logical storage units. The purpose of tablespaces is to group logically-related structures together. Each tablespace has one of more datafiles.

The Oracle Database can run on the major platforms, including UNIX, Windows, Linux and Mac OS. The database comes in different versions. You should choose the version you need based on your requirements and budget. The Oracle Database editions are hierarchically organized as follows:

Enterprise Edition

This edition provides all the features, including superior security and performance, and it is the most robust Oracle Database Edition.

Standard Edition

It provides users with base functionality. It is suitable for users who do not need the robust features provided by the Enterprise Edition.

Express Edition (XE)

This is a free, lightweight and limited Linux and Windows edition. It is easy and fast to install.

Oracle Lite

This edition runs on mobile devices.

As stated earlier, the architecture is split between Logical Structure and Physical Structure. For grid computing/large-scale distributed computing, the location of data is irrelevant and transparent to the user. This allows for a more modular physical structure that can be modified without affecting the database activity, users or the data. This way of resource sharing allows for flexible data networks whose capacity can be scaled up or down to suit demand, with no degradation of service. It also means that there is no single point whose failure can bring the database down.

Chapter 2- Who is it for?

First and foremost, this book is dedicated to the managers who have no background in database technologies yet have to manage the DBAs. Due to explosion in the data-related technologies such as Big Data, Data Mining etc., managers are finding that they are increasingly getting closer to the DBAs and vice versa. Without fully understanding the database technology, they are bound to make mistakes.

Secondly, this book is also dedicated to the developers who may not be fully trained in the Oracle Database technology but have to develop applications with it. As above, without fully understanding the technology, the application will end up in a disaster.

Finally, this book is dedicated to DBAs who have to communicate or work with everyone else on a daily basis. The DBAs have to explain to them every words that they speak and yet knowing full well that the colleagues may not fully understand everything that has been explained to them.

This is the best book for you that will help you grasp every aspect of Oracle 12c database. The author has written the book in a step-by-step approach while adding explanations to every step. Enjoy reading!

Chapter 3- Introduction to Database Technology in General

A database is stored in a database management system (DBMS). The DBMS is a system software that facilitates the creation and management of databases. It provides programmers and users with a systematic way to create, update, retrieve and manage data.

With a DBMS, end users are able to create, update, read and delete data from a database. The DBMS acts as an interface between the database