Database Systems with SQL - Full Course - Database Systems - Architecture Types: In-Memory, Embedded, Federated, and Data Lake - APPFICIAL

In-memory database – all the data is stored in memory (RAM) rather than on a storage media device, providing much faster access to data. Main memory is volatile, so if your database is in-memory, and your laptop crashes or battery dies, then you lost all that data. Most databases nowadays offer a hybrid of in-memory databases and databases on storage. Embedded database – a database combined with a programming language, that execute together when you run the program. They are typically single-user applications, that don’t require a DBA, and used often for mobile devices. SQLite is an example of a popular embedded database. Federated database – two or more databases that are coordinated by middleware (software application). They are autonomous, where they don’t interfere with each other, and heterogeneous where the schemas don’t match up or they are ran under different database systems. Federated database contain a global catalog, global query processor, and a database wrapper which converts queries to be compatible with the other database. A data lake is a database of unstructured raw data (as-is), which makes running different types of analytic easier in order to make better company decisions. With a data lake, you can create dashboards, visualizations in Tableau, big data processing, real-time analytics, and machine learning to guide better decisions. Data lakes are similar to data warehouse. Both data lakes and data warehouses are a separate database designed for analytic queries and the data comes from multiple source systems. Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!