Data Interview Question | What is a Data hub ?

Hello Friends, Last month I recieved an email from one of my reader saying why you are not write on data related questions. I replied saying that I shall start soon. Today is a very good day to start the data related question. I shall also cover the BIG Data as well as data warehousing question. Now the category I am using these kind of questions as data interview questions. So today lets start with the data hub.

What is a data hub?-

A data hub basically is a collection of data (consider this as Big Data Management) from multiple sources. It uses a Hadoop platform as the central data repository. The idea of an data hub is to provide an organization with a centralized data source that can quickly provide users with the information they need.

The data distribution normally happens in the form of a hub and spoke architecture. The spoke-hub distribution paradigm is a form of transport topology optimization in which traffic routes are organized as a series of ‘spokes’ that connect outlying points to a central ‘hub.’

Enterprise data hubs are designed to address the challenge of data that is ballooning in volume, variety and velocity (3Vs). This term is largely associated with Cloudera and MapR.

Data Hub notes-
1. Data from all the sources data is moved to one place.
2. Data is (at least partially) harmonized as it is moved.
3. Data is indexed in the harmonized form for efficient access and analysis.

Data hubs products avaible are-

1. Apache Hadoop
2. Avoiding Mass Extinctions Engine
3. CKAN
4. DataHub
5. DataMarket
6. Dataverse
7. DSpace
8. MarkLogic
9. OpenDataSoft
10. Quandl
11. QuickCode
12. Socrata

References-

https://en.wikipedia.org/wiki/Data_hub
https://en.wikipedia.org/wiki/Spoke%E2%80%93hub_distribution_paradigm
https://searchcio.techtarget.com/definition/enterprise-data-hub
https://www.marklogic.com/blog/data-lakes-data-hubs-federation-one-best/

Enjoy 🙂

Please add comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com