Skip to Main Content
  • Questions
  • Kindly help with Data Integration Related Terms in below

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Rajneesh.

Asked: April 07, 2020 - 3:55 am UTC

Last updated: April 08, 2020 - 8:25 am UTC

Version: 19 c

Viewed 1000+ times

You Asked

Hello TOM,

May I know what we mean by below terms with examples:

Data Outages
Siloed Data
Data Automation
Data Profiling
Push Down Data movement

Thanks
Rajneesh

and Chris said...

Is this homework?

Data Outages

The data are unavailable for some reason (server crashes, disk failures, ...)

Siloed Data

Data about a business or application are stored in separate databases, making it hard to get a complete picture of the enterprise. For example, customer details may be in a CRM (customer relations management) system, their orders may be in a separate online ordering application.

Data Automation

I'm not quite sure what they're getting at here, but it's likely to do with automating the storage and processing of data.

Data Profiling

Analyzing the data to produce summary stats about it.

Push Down Data movement

I think this should be about data processing, rather than movement. The idea here is you filter the data at source, instead of transferring data then filtering.

A simple example. To find all the orders for a customer, you could query every order:

select * from orders


Then inspect every row in your application to see if it matches the given customer. But this means sending thousands, millions or even billions of rows over the network. A big waste if the customer has only placed a handful of orders.

Instead it's much more efficient to "push down" the processing to the database, so you run:

select * from orders
where  customer_id = :customer


This then only returns rows for that customer to the application.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks for your help

A reader, April 08, 2020 - 10:26 am UTC

Thanks, it helps

Looks more like homework

A reader, April 08, 2020 - 12:31 pm UTC

;)

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.