Data Warehousing and Emerging Database Technologies

Start with data warehousing

For an introduction, start with the Databases Topic 10 flashcards. They cover data warehousing and business intelligence, including operational systems, business intelligence systems and the extract, transform, load process. Go through the cards once, then return to the terms you want to examine more closely.

Next, open the Data warehousing mind map. It sets out characteristics of a warehouse, including subject orientation, integration and historical data. Use the map to organize the terms from the flashcards and see which ideas you want to study again.

Explore emerging technologies

The page also has several mind maps about database technologies in enterprises. Their opening text asks whether databases have entered an era of specialization. A related note describes alternatives including NoSQL, NewSQL, in-memory databases and cloud relational databases. Read the note alongside a map to compare how the resources present these ideas.

There is also a mind map on big data that includes nodes, edges, properties and graph schema, as well as a flashcard deck with questions about data and stages of a database life cycle.

Test and connect your study

After using the maps and flashcards, try the quiz with questions on data management technologies and tools for statistical analysis. Use its questions to identify terms worth returning to in the other resources. You can move between a quiz and a map as often as you need.

This topic is a section of Database Concepts and DBMS Fundamentals in Databases and data science. Use the resources here to organize your study of data warehousing and emerging technologies within that unit. When you are ready, choose a resource and begin exploring.