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 KZbin: / 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/gatesmash...
► Follow us on Threads: www.threads.ne...
--------------------------------------------------------------------------------------------------------------------------------------
►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 😊

[@AbhijitZ-yyyy]

Give this man a oscar!

[@bestgamingsa497]

First Comment ❤ From Pakistan...

[@freefirelover618]

Bhai channel pr views kese ayge iski koi tip

[@sarthak98657]

Padhle saale ​@@freefirelover618

[@sp_9467]

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

[@BhagatBhutale..]

Video useful

[@Mansha_mehandi_art]

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

[@manasishimpi4356]

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

[@AdityaSharma-yj8jk]

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

[@ranjan_v]

Thank you very much

[@Jawariyakhaliq]

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

[@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

[@AnuMudhale-lj5bs]

Need more videos on snowflake schema, all types of transformation

[@yadavbipin19]

T🎉

[@rampanwar1316]

Great video 💯

[@RajneeshDabral]

good explanation

[@nawazmemon-ui6lo]

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

[@ishiqamalik3830]

Sir smart ho gy hn ap😅😅😅

[@PrithaMajumder]

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

[@technicalsyntax]

Good work sir

[@ShrilekhaJadhavNikam]

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

[@ayyan6061]

Stunning

[@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🙏

[@suparna_saha]

Thanks sir ❤

[@vimalradadiya5929]

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

[@ShreyashSangle-fu8to]

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

[@kamransayyed5497]

Helpful ❤️👍🏻

[@souviklaha1260]

sir, thank you😍

[@jayeshraokherkar8220]

🔥🔥🔥

[@duniyasirfekibaadat6507]

Before 1 day exam 😢

[@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

[@bbi-edu]

kzbin.info/www/bejne/bamak4ptfMSVhLs

[@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