Let me just clarify that I am just starting out with database administration and development. I have been programming for about 13 years in assorted OOL including other languages like SQL. However, when it comes to developing and maintaining a database, I'm pretty wet behind the ears.
That said, I'm having trouble understanding the terminology of OLAP and Data Warehousing. For example, I have a test database that is labeled as a OLAP database with a Snowflake schema. It has dimension tables and fact tables. When trying to learn more about this database and how it's structured, I get these keywords: OLAP, OLAP Database, Data Warehouse and of course Snowflake Schema.
When I asked if this is a data warehouse, I was told, "No, this is a OLAP database." However, research says data warehouses are structured in the same way. So, I'm a bit confused. If this is a OLAP database, then what's needed to create a data warehouse from here? Or, is a OLAP database pretty much a data warehouse? If not, what's the difference?