What is Star Schema | Schema for Multi Dimensional Data Model | Data Warehouse

00:00 - Star schema
01:37 - example of star schema
02:41 - example of dimension table
05:08 - Advantages
A star schema is a type of database schema that is commonly used in data warehousing and business intelligence applications. It is designed to simplify querying and improve the performance of complex queries on large datasets. The star schema consists of fact tables and dimension tables arranged in a star-like pattern, hence the name.
👉Subscribe to our new channel: / @varunainashots
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on TH-cam: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: [e-mail]
#dataextraction #datawarehouse #datamining

[@meena.123.]

*Star schema is also know as starjoin
* star schema is type of data modeling technich to represent data
*star schema is multi dimesion data modeling to organize data
*star schema contains only one fact table or multiples dimesion table
*star schema can be aplied data warehouse, database, data mart or other tool for organized data
*all the dimesion are connected to fact table through the forign key
*primary key of each dimesion table is part of the fact table

[@danishali0001]

Thanks brother 😊

[@Mansha_mehandi_art]

The thumbnail is very good and your way of teaching is super.

[@sp_9467]

Watching From Bits Pilani... Great Explanation... Tomorrow is exam

[@vimalradadiya5929]

Thank you sir 🙏 for this video
Excited for more videos on big data topics

[@ayyan6061]

Stunning

[@manasishimpi4356]

Accha hua ye video banaye
Puri playlist chahiye star aur snowflakes ke aur bhi problems lo na solve larke

[@ranjan_v]

Thank you very much

[@PrithaMajumder]

Sir, Thanks a lot for This Amazing Lecture 🙂
Lecture - 4 Completed ✅ in Data Warehouse Playlist

[@rampanwar1316]

Great video 💯

[@bestgamingsa497]

First Comment ❤ From Pakistan...

[@freefirelover618]

Bhai channel pr views kese ayge iski koi tip

[@sarthak98657]

Padhle saale ​@@freefirelover618

[@technicalsyntax]

Good work sir

[@Akhand2207]

Sir yadi maine gaye kai leye padha to ibps so it ka syllabus ve ho jayega ya particular hmko ibps so it padhna hoga...#pleasehelp

[@kamransayyed5497]

Helpful ❤️👍🏻

[@souviklaha1260]

sir, thank you😍

[@RajneeshDabral]

good explanation

[@nawazmemon-ui6lo]

Thank you sir❤️‍🔥❤️‍🔥❤️‍🔥

[@suparna_saha]

Thanks sir ❤

[@AnuMudhale-lj5bs]

Need more videos on snowflake schema, all types of transformation

[@yadavbipin19]

T🎉

[@Jawariyakhaliq]

Sir is playlist ko exam sy pehly finish kar dein please 🥺

[@jayeshraokherkar8220]

🔥🔥🔥

[@ShrilekhaJadhavNikam]

Employee table primary key is not present in fact table...so no relation between them..pls correct it

[@rupeshsingh943]

Great sir 💯❤

[@deepikasisode]

Need more videos on datawarehouse sir,types of dimensions types of fact table what is confirmed dimensions scenarios on real time basis projects please

[@GateSmashers]

Ok will make very soon

[@deepikasisode]

@@GateSmashers Thank you sir 🙏, from in which scenarios we go for star and snowflake schema ,in depth pls sir

[@stemtechacademy8828]

@@GateSmashers hi bring up an affordable course on 60 Questions of IBPS IT officer post

[@stemtechacademy8828]

@@GateSmashers please do reply in yes or no

[@aditishrivastava8330]

@@GateSmashers sir i have exam please complete the series

[@ShreyashSangle-fu8to]

November takh pls almost syllabus cover kar dena DWM ka 🙏end sem me jarurat hogi

[@user-mm8lm5nm1e]

Understood Everything but the only doubt is about the Employee Dimesion i dont find tha is connected to the fact as the other three dimensions are connected with fact whereas there is no foreign key releation of Employee Dimension in the fact table Kindly Help🙏

[@ishiqamalik3830]

Sir smart ho gy hn ap😅😅😅

[@AdityaSharma-yj8jk]

Watching from Harvard University Great explanation. Watching 1 day before the exam 😅😅😅

[@Tamanna_K_Hardy]

Naina Mem Kaa Birthday hai Naa Aaj To 😏😏😏😎 Wish Kaha Kare 👀

[@dewanganprashant6853]

Gauss law 😢😢😢

[@raosahab_123]

sir ek request h hpsc pgt ka subjective paper ka cource suru krdo