SDET- QA Automation Techie

Software Testing Blog

  • Home
  • Training
    • Online
    • Self-Paced
  • Video Tutorials
  • Interview Skills
    • HR Interview Questions Videos
    • Domain Knowledge
  • Career Guidance
  • Home
  • Software Testing
    • Manual Testing Tutorials
    • Manual Testing Project
    • Manaul Testing FAQS
    • ISTQB
    • AGILE
  • Web Automation Testing
    • Java Programmng
    • Python Programmng
    • Selenium with Java
    • Selenium with Python
    • Robot Framework(Selenium with Python)
    • selenium with Cucumber
    • TestNG+IntelliJ
    • Mobile App Testing(Appium)
    • JMeter
  • API Automation Testing
    • Rest Assured API Testing (BDD)
    • Rest Assured API Testing (Java+ TestNG)
    • Robot Framework(Rest API Testing with Python)
    • Postman
    • SoapUI
    • API Testing(FAQ's)
  • SDET|DevOps
    • Continuos Integration
    • SDET Essentials
    • AWS For Testers
    • Docker
  • SQL
    • Oracle(SQL)
    • MySQL for Testers
    • NoSQL
  • Unix/Linux
    • UNIX TUTORIALS
    • Linux Shell Scripting
  • ETL Testing
    • ETL Data warehouse Tutorial
    • ETL Concepts Tools and Templates
    • ETL Testing FAQ's
    • ETL Testing Videos
  • Big Data Hadoop
  • Video Tutorials
  • ApachePOI Video Tutorials
  • Downloads
    • E-Books for Professionals
    • Resumes
  • Automation Essencials
    • Cloud Technologies
      • Docker For Testers
      • AWS For Testers
      • Sub Child Category 3
    • Java Collections
    • Selenium Locators
    • Frequently Asked Java Programs
    • Frequently Asked Python Programs
    • Protractor
    • Cypress Web Automation

Operational data store (ODS)

 Operational data store (ODS)   

What is an Operational data store (ODS)?

It is a database which has integrated data from different business or sources with different rules. The data cleansing process applied also. It gets data from the transactional database directly or through staging area.
It will have a limited period of history data, hardly 30 to 90 days of data.

Why does ODS is required?

It will be used for operational monitoring and processing, and for creating simple analysis reports. The performance of processing will be faster since it has only less volume of data compare to data-mart.

Difference between data warehouse and ODS:

Factor
ODS
Data mart or data warehouse
PeriodIt will have limited period of data (30 to 90 days)It stores history of data
PurposeOperational processingForecasting and decision-making
Query complexitySQL query complexity will be lessQuery complexity will be high
Stage in architectureIt will be built before data warehouseODS data will be moved into data warehouse


Operational data store vs OLTP (Online Transactional Processing):

Factor
ODS
OLTP
PeriodIt will have limited period of data (30 to 90 days)It has only current data
PurposeOperational processingFor regular online transactions
DataIntegrated from different business linesOnly for specific business
NormalizationNormalized or de-normalizedNormalized to avoid data redundancy

Operational data store vs Staging database:

Factor
ODS
Staging
PeriodIt will have limited period of data (30 to 90 days)Based on type of load it stores incremental data or full volume of data
PurposeOperational processingTemporary data storage and for doing data cleansing and other calculations
DataIntegrated from different business linesBased on business need, normally the each business line would have dedicated staging



  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to TwitterShare to Facebook
Newer Post Older Post Home
popup

Popular Posts

  • How To Explain Project In Interview Freshers and Experienced
    “ Describe an important project you’ve worked on ” is one of the most common questions you can expect in an interview. The purpose of a...
  • MANUAL TESTING REAL TIME INTERVIEW QUESTIONS & ANSWERS
    1. How will you receive the project requirements? A. The finalized SRS will be placed in a project repository; we will access it fr...
  • API/Webservices Testing using RestAssured (Part 1)
    Rest Assured : Is an API designed for automating REST services/Rest API's Pre-Requisites Java Free videos: https://www.you...

Facebook Page

Pages

  • Home
  • Resumes
  • Job Websites India/UK/US
  • ISTQB
  • Selenium with Java
  • E-Books for Professionals
  • Manual Testing Tutorials
  • Agile Methodology
  • Manual Testing Projects

Live Traffic

YouTube


Blog Visitors

Copyright © SDET- QA Automation Techie | Powered by Blogger
Design by SDET | Blogger Theme by | Distributed By Gooyaabi Templates