Difference between Database vs Data lake vs Warehouse

  Рет қаралды 36,342

Sumit Mittal

Sumit Mittal

Күн бұрын

Пікірлер: 51
@sumitmittal07
@sumitmittal07 2 жыл бұрын
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_bd12
@abhijeetghosh8073
@abhijeetghosh8073 2 жыл бұрын
Tried looking for defination in many videos but the way you explained really made it easy to understand. Thanks for sharing knowledge 🙏
@rishabh31415
@rishabh31415 2 жыл бұрын
Got this question in Amazon DE interview round 1
@ashutoshsharma3396
@ashutoshsharma3396 2 жыл бұрын
Thanks for this video! In our project we were loading data from oracle db to Teradata stg tables using informatica one to one mapping and after loading to stg tables were doing transformations and loading dimension and fact tables so it was ELT process.
@funtime12345
@funtime12345 2 жыл бұрын
What an amazing explanation sir!!! Superb!! Love it!!! You are great sir!!!
@sumitmittal07
@sumitmittal07 2 жыл бұрын
Thanks a ton. Keep watching
@JuniorMarci27
@JuniorMarci27 Жыл бұрын
Perfect explication! Thanks!!! You changed my mind about this subject.
@nklee1980
@nklee1980 Жыл бұрын
Your explanation 100% very clear and understanding.....
@devasaniganesh8196
@devasaniganesh8196 2 жыл бұрын
You made this easy to understand, Thank you sir.
@sumitmittal07
@sumitmittal07 2 жыл бұрын
Happy to hear that!
@Youtuz124
@Youtuz124 4 ай бұрын
Very well explained, especially the ETL Vs ELT, Thank you Sumit!
@ushavr
@ushavr Жыл бұрын
Very thorough and helpful! Easy to understand. Thanks
@ishaqkhan8653
@ishaqkhan8653 7 ай бұрын
Thank you for the wonderful explanation. It was simple and crisp
@arpangupta2162
@arpangupta2162 2 жыл бұрын
it was a much needed session
@sumitmittal07
@sumitmittal07 2 жыл бұрын
Happy that you found the session useful!
@abhijeetpatil8958
@abhijeetpatil8958 2 жыл бұрын
Now I understand better
@udaypatilSiR
@udaypatilSiR 2 жыл бұрын
Sumit sir really hats off to you.
@rakish81
@rakish81 Жыл бұрын
Superb & Informative! nicely articulated.
@shreyashwaghmare9136
@shreyashwaghmare9136 Жыл бұрын
Bro your video helped me a lot. Thanks man
@andreanlobo7373
@andreanlobo7373 2 жыл бұрын
Extremely useful. Thanks for this video and all the valuable information
@MSG_22
@MSG_22 2 жыл бұрын
It was simple and clear, thank you
@nandansingh1482
@nandansingh1482 2 жыл бұрын
Very well explained thanks a lot
@gerardt.5172
@gerardt.5172 2 жыл бұрын
Great explanation and very esay to follow!👍 Thanks!
@avinashshinde2659
@avinashshinde2659 2 жыл бұрын
excellent,got Deep knowledge!
@ganish5431
@ganish5431 2 жыл бұрын
Good explanation..!
@ravirajchenna612
@ravirajchenna612 2 жыл бұрын
Loved the explanation
@dhruvpandey1189
@dhruvpandey1189 2 жыл бұрын
Are datawarehouse and data lake different sections of the same set up? For example if we have a snowflake DW, can the data lake be also within the same snowflake set up but an isolated environment?
@vandanasharma4738
@vandanasharma4738 2 жыл бұрын
Snowflake is created/hosted on any of the three clouds we have. So as per my understanding, snowflake is data warehouse but it can be used as a datalake as well. When used as a datawhere house it stores the data in snowflake itself but when you use it as a data Lake, it keeps or make use of Amazon S3 for example bucket for storage
@vandanasharma4738
@vandanasharma4738 2 жыл бұрын
Please correct for better understanding
@prajitkarande5214
@prajitkarande5214 2 жыл бұрын
Can we use ELT for datawarehouse ? Ca we store log file as it in datawarehouse if yes then what's exactly different between data warehouse and data lake?
@ANKITKUMAR-nv8ur
@ANKITKUMAR-nv8ur 2 жыл бұрын
No in data warehouse we can not store log file as it is unstructured data. but in data lake we can have unstructured and structure data that's the difference exactly
@VikashSoni-o3z
@VikashSoni-o3z Жыл бұрын
Nice explanation
@madhavareddy3488
@madhavareddy3488 2 жыл бұрын
Nice one!! Thanks!
@ameerullah2260
@ameerullah2260 10 ай бұрын
Super awesome
@alessandroceccarelli6889
@alessandroceccarelli6889 2 жыл бұрын
Can MongoDB, with its analytical engine and Time Series collections, be considered a hybrid DB/Warehouse? Would it be inherently wrong to store e.g. historical sales transactions of a shop and current transactions within a Time Series Collections on Mongo? If not, which alternative would you consider for it? Thank you so much for your video 👏🏻👏🏻
@AbhishekTiwari-vf9ru
@AbhishekTiwari-vf9ru 2 жыл бұрын
I have a doubt , does datawarehouse supports acid properties? Also is only historical data stored in datawarehouse?
@vandanasharma4738
@vandanasharma4738 2 жыл бұрын
The idea behind developing data warehouses is to keep historical data you can relate it with a normal datawhere house people are using to store goods so it's a kind of storing huge amount of data
@gopinathg318
@gopinathg318 2 жыл бұрын
If we cannot store historical data in data base then how we will copy those data to a data warehouse to do analysis.
@vandanasharma4738
@vandanasharma4738 2 жыл бұрын
So what happens is when you have data in a database then on regular intervals we move this data from database to a datawarehouse using an ETL tool. So the data flows from your database -> then ETL tool ~> then a datawarehouse. The frequency at which you move data from a database to a data warehouse is generally suggested by the clients or the business users
@omkarm7865
@omkarm7865 2 жыл бұрын
can we use Oracle also as data warehouse because as far I know Teradata is also database only. so any database available in market, we can use that as data warehouse. Am I correct?
@sonu-if4ym
@sonu-if4ym 2 жыл бұрын
Yup.. We have used oracle as dwh
@nvasudeva
@nvasudeva 2 жыл бұрын
While technically u could use but this would be at the cost of performance. Please note that traditional databases works on rows where as typical DWH database is configured to operate in columnar fashion.
@dishashetty866
@dishashetty866 Жыл бұрын
Is Google Cloud Storage a database or a data lake?
@gcpchannelforbegineers7080
@gcpchannelforbegineers7080 2 жыл бұрын
Thanks for the amazing content :)
@MJoe-fb9ps
@MJoe-fb9ps Жыл бұрын
Awesome
@deepanshujain4119
@deepanshujain4119 2 жыл бұрын
Can a database become a datawarehouse and visa versa?
@MaheshTiwari-hq7lr
@MaheshTiwari-hq7lr 11 ай бұрын
both have certain limitations as discussed in the video.
@ashutoshyadav8348
@ashutoshyadav8348 2 жыл бұрын
Why cost of storing data in database is high?
@ramm3020
@ramm3020 2 жыл бұрын
May be onpremises storaege . now due to cloud the storage cost comes down. Pls comment it is correct or not. THanks.
@azingo2313
@azingo2313 2 жыл бұрын
Wonderful explanation
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 30 МЛН
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 81 МЛН
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 36 МЛН
What is ETL | What is Data Warehouse | OLTP vs OLAP
8:07
codebasics
Рет қаралды 433 М.
Database vs Data Warehouse vs Data Lake | What is the Difference?
5:22
Alex The Analyst
Рет қаралды 838 М.
Data Lake VS Data Warehouse VS Data Marts | CodeLearnX
12:07
CodeLearnX
Рет қаралды 29 М.
Introduction to Apache Spark | Apache Spark Tutorial | Trendytech
27:26
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН