CST 363 Week 7

CST 363 Week 7

This week I learned about big data and the new forms of databases that are being implemented for them. I was able to learn about how data marts are used in data warehouses to help process large amounts of data for big corporations.

I also learned how OLAP is implemented to dynamically access data through the use of dimensions. A three dimensional OLAP report was examined.

With this knowledge I was able to create an OLAP report through Excel PivotTables. 

The different types of distributed databases was then explored. These include: 

I learned the difference between scale up (larger processor) vs. scale out(more servers). The No SQL movement and Hadoop were also explored.

Our group was able to complete the database design and add the data to the tables this week.