depozite de date
DESCRIPTION
depozite de date proiectTRANSCRIPT
![Page 1: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/1.jpg)
PROIECT DEPOZITE DE DATE
- Online PC SHOP -
Echipa:
1. Lupu Petru Viorel2. Matasaru Bogdan Constantin3. Zaharia Andrei Daniel
SIA II - 2013
![Page 2: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/2.jpg)
CUBUL ONLINEPC
Figura 1. Model multidimensional FULG-DE-ZAPADA (snow-flake)
Figura 2. Dimensiunea Timp
![Page 3: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/3.jpg)
Figura 3. Dimensiunea Geografica
Figura 4. Dimensiunea Produs
Figura 5. Dimensiunea Model
![Page 4: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/4.jpg)
Figura 6. Cubul OnlinePC – Sql Server Manager
Figura 7. Reprezentarea incasarilor in functie de timp
Interogari MDX
Din totalul de 8 interogari am selectat principalele 4 pentru a fi exemplificate
![Page 5: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/5.jpg)
Figura 8. interogare - comenzi pe fiecare judet
Figura 9. interogare valoare facturi pe ani
![Page 6: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/6.jpg)
Figura 10. Principalii importatori
Figura 11. Valoarea totala a comenzilor si numarul lor pe anii 2011, 2012
![Page 7: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/7.jpg)
Interfata grafica interogare depozit de date
Figura 12. interfata de conectare la depozit si prezentarea datelor interogarii sub forma de chart
Modelele DM
Figura 14. msn_clustering
![Page 8: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/8.jpg)
Figura 15. modelDM - msn_clustering - Cluster Profiles
Figura 16. modelDM – Dtree
![Page 9: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/9.jpg)
Interogarile DMX
Figura 17. clustere cu mai mult de 7 cazuri
![Page 10: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/10.jpg)
Figura 18. clustere cu probabilitatea peste 0.05(inclusiv radacina)
Figura 19. clustere cu probabilitatea peste 0.10 (exclusiv radacina)
![Page 11: Depozite de date](https://reader030.vdocumente.com/reader030/viewer/2022033101/55cf99b6550346d0339ecdba/html5/thumbnails/11.jpg)
Figura 20. primele 10 seturi de valori cu probabilitatea cea mai mare
Interfata de conectare la modelul DM
Figura 22. interfata de conectare la un model DM si graficul cu rezultatele