What is Oracle’s Autonomous Database? 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 …
Applying the DSTv update for the Oracle Database – Timezone Upgrade
Applying the DSTv Update for the Oracle Database Applying the RDBMS DSTv36 patch 32327201 on the server side in Oracle RDBMS 12c and above DST Patch After a DST patch is installed …
Data Quality – Incident Tracking System
Data Quality Incident Tracking System Overview The incident tracking system will collect performance data relating to issue resolution, work assignments, volume of issues, frequency of occurrence, as well as the …
Data Quality – Causes of Data Quality Issues – Part-02
Resolving 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 …
Data Warehouse / Business Intelligence Projects – Critical Success Factors
Securing Executive Support Through Business Sponsorship 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. Defining …
OLAP – ROLAP, MOLAP and HOLAP
How OLAP, ROLAP, MOLAP, and HOLAP Work OLAP – Online Analytical Processing It is a technology used to organize large business databases and supports performing complex and multidimensional analysis, at …
Data Warehouse, Data Lake & Data Vault
Understanding Data Lake vs Data Warehouse Data Lake and Data Warehouse both act as repositories, but they are designed for very different purposes. Data Warehouses work best for specific projects …
Data Modeling – Conceptual, Logical and Physical Model – CDM, LDM and PDM
What is Data Modeling? 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 …
NoSQL Column-Oriented Database – Columnar Database – Column Store Database – C-Store
Introduction to NoSQL Column-Oriented Database NoSQL Column-Oriented Database is also known/called Columnar Database, Column Store Database, and C-Store. OLTP and OLAP in Column-Oriented Systems Column-oriented systems have been developed as …