About Srinivas Maddali

I migrated to the USA to find a better future for my family. I have been Oracle DBA for the past 22 years in the USA. Before I migrated to the USA, I worked for the Union Bank of India in many places for 20+ years. 
 
I wish, I share my knowledge with everyone that is thirsty of the knowledge to maintain and manage RDBMS.
 
While Oracle, MySQL, and SQL Server are Relational Database Management Systems (RDBMS), I understand PostgreSQL is an Object-Oriented Relational Database Management System with a deferent kind of version management system.
 
After the Social Media Management systems such as Mongo, Couchbase, Cassandra, Hadoop,  Hive, etc., are grown after HW has been treated commodity HW and instead of High-Power Servers, the data is distributed over clustered commodity HW. when the data is sorted out from the haystack of social media data the data goes into RDBMS or OORDBMS and the data is analyzed and used for the business development.
 
The current DBA cannot claim of Oracle like one RDBMS. He needs to have multiple skills.
 
I owe my knowledge to Tom Kyte, Dyke Julian, Steve, Rama Viipuri,  Jonathan Lewis and many. I owe them my quest for knowledge. This site is for such who have quest for unlimited knowledge.
 
I am still a student of that knowledge. 

sign

Lorem Ipsum is simply text

images
image

RDBMS

Relational Database Management Systems (RDBMS)
 
Data is organized in tables defined by the relations of the data into organized tables.
Tables can have Primary AND/OR Unique keys.
They can also have Foreign Keys (FK)
Generally, each table/relation represents one "entity type" (such as customer or product - names of the tables).
Tables have columns and rows.
Every row represents an instance of related column values. 
Primary Key represents NOT nullable values of a table and remain unique.
Unique Key also represents in a database relational modeling and implementation, a unique key (also known as a candidate key or just a key) is a set of attributes (columns) within a relational database table (also called a relation)
Foreign Key (FK) is a key to link 2 or more tables. FK is column/s in a table that refers to a PK in another table. 

image

Big Data

Big data is extremely large data sets that may be analyzed computationally to reveal patterns, trends, and associations, especially relating to human behavior and interactions.
"much IT investment is going towards managing and maintaining big data"

image

RMAN Tutorials

RMAN - Recover Manager - Oracle 
 
RMAN (Recovery Manager) is a backup and recovery manager supplied for Oracle databases (from version 8) created by the Oracle Corporation. It provides database backup, restore, and recovery capabilities addressing high availability and disaster recovery concerns. Oracle Corporation recommends RMAN as its preferred method for backup and recovery and has written command-line and graphical (via Oracle Enterprise Manager) interfaces for the product.
 

image

Oracle Tutorials

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model[4] database management system produced and marketed by Oracle Corporation.
 
It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. 
 
The latest generation, Oracle Database 19c, is available on-prem, on-cloud, or in a hybrid-Cloud environment. 20c may also be deployed on Oracle Engineered Systems (e.g. Exadata) on-prem, on Oracle (public) cloud or (private) cloud at customer. At Openworld 2017 in San Francisco, Executive Chairman of the Board and CTO, Larry Ellison announced the next database generation, Oracle Autonomous Database.