Oracle says, Autonomous Database is a mission-critical, converged database that runs transactional and analytic workloads. It automatically scales, tunes, patches, and secures all the workloads using machine learning to provide …
Applying the DSTv update for the Oracle Database – Timezone Upgrade
Applying the RDBMS DSTv36 patch 32327201 on the server side in Oracle RDBMS 12c and above After a DST patch is installed on 12c $ORACLE_HOME there are steps who need to be …
Data Quality – Incident Tracking System
The incident tracking system will collect performance data relating to issue resolution, work assignments, volume of issues, frequency of occurrence, as well as the time to respond, diagnose, plan a …
Data Quality – Causes of Data Quality Issues – Part-02
Issues Caused by Data Entry Processes Data Entry Interface Issues: Poorly designed data entry interfaces can contribute to data quality issues. If a data entry interface does not have edits …
Data Warehouse / Business Intelligence Projects – Critical Success Factors
Business Sponsorship: Is there appropriate executive sponsorship, i.e., an identified and engaged steering committee and commensurate funding? DW/BI projects require strong executive sponsorship. Business Goals and Scope: Is there a …
OLAP – ROLAP, MOLAP and HOLAP
OLAP – Online Analytical Processing It is a technology, used to organize large business databases and supports to perform complex and multidimensional analysis, at high speeds on large volumes of …
Data Warehouse, Data Lake & Data Vault
Data Lakes & Data Warehouses Data Lakes and Data Warehouses both act as repositories, but they are designed for very different purposes. Data Warehouses work best for specific projects with …
Data Modeling – Conceptual, Logical and Physical Model – CDM, LDM and PDM
Data Modeling is the process of creating an illustrative and visual representation of either a whole information/database system or parts of it to show the relationships among data types, the …
NoSQL Column-Oriented Database – Columnar Database – Column Store Database – C-Store
NoSQL Column-Oriented Database is also known/called Columnar Database, Column Store Database and C-Store. Column-Oriented Systems have been developed as Hybrids Capable for both OLTP and OLAP operations with some of …