Posts

Showing posts from July, 2017

Oracle database structure: Understanding the basics

Image
In today's blog post we will be looking at how data is arraigned and stored in the database.  An Improperly o rganized   data could reduce the database integrity or negatively impact on its performance.  This arrangement can be likened to an organogram (Organisations hierarchy structure)  where we have segmentation like: - Groups - Departments - Units - Teams - Staff (this being the smallest unit) Now that the concept is clear let us get busy.....

Oracle Database Architecture: Understanding the basics

Image
“The Captain of a plane that knows nothing about the mechanical parts of his plane would eventually crash it one day.” I believe it would be nice to introduce you to the inner workings of the Oracle database. This would be useful to the intending DBA, audit or control officer and finally the ordinary enthusiast. You cannot effectively manage the oracle database if you don’t know how it processes data and presents information to you. So let’s get busy………