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 …
19c – Clone PDB to another CDB using DBLink
Identify the Source PDB, which needs to be Cloned: SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO 3 TESTTST01 READ WRITE NO You may receive …
Big Data – MPP Shared-nothing Technologies and Architecture
MPP has evolved because traditional computing paradigms (indexes, distributed data sets, etc.) did not provide acceptable response times on massive tables. Massively Parallel Processing (MPP) Shared-nothing Database technologies have become …
Big Data Characterized in terms of V’s
Volume: Refers to the amount of data. Big Data often has thousands of entities or elements in billions of records. Velocity: Refers to the speed at which data is captured, …
Data Quality Program – Readiness Assessment / Risk Assessment
Findings from a readiness assessment will help determine where to start and how quickly to proceed. Findings can also provide the basis for roadmapping program goals. If there is strong …
Data Quality – Audit Code Module and Metrics
Quality Check and Audit Code Modules Create shareable, linkable, and re-usable code modules that execute repeated data quality checks and audit processes that developers can get from a library. If …
Data Quality – Tools
Tools should be selected and tool architectures should be set in the.planning phase of the enterprise Data Quality program. Tools provide a.partial rule set starter kit but organizations need to …
Data Quality – SLA – Service Level Agreements
A data quality Service Level Agreement (SLA) specifies an organization’s expectations for response and remediation for data quality issues in each system. Data quality inspections as scheduled in the SLA …
Data Quality Assessment
DQ Analysts will need to sort out and prioritize findings. The goal of an initial Data Quality Assessment is to learn about the Data in order to define an Actionable …
Reference and Master Data Management – Guiding Principles
Shared Data: Reference and Master Data must be managed so that they are shareable across the organization. Ownership: Reference and Master Data belong to the organization, not to a particular …