This week, Mr. Iyad Koteich, my professor at Trebas Institute, gave me an opportunity to share my knowledge about Data Warehouses.
It was perfect because I could remember some concepts and share them with my classmates. Of course, to talk about business intelligence, data warehouse, and SGBD we need to
Initial Concepts.
Model ER - Or Entityโrelationship model. Before we start to develop a solution, is important to have the base requirements of the system to model the first structure of the Database. There is a pattern to do that and is important to be attended to because any user from the team can read the model. If not, all the knowledge about the project will be with a manager or a little part of the team.
SGBG - This is an acronym for "Database management system." Sometimes is common confusion between the concept of Database and SGBD. To be simple, just understand that the Database is a part of the SGBD. For example, the SGBD can control access to databases and tables in these databases.
Transaction System.
OLTP
Analytics Concepts
OLAP Fact Table Dimensions Cube