Whether on-premises or in the cloud, people often ask database administrators to create and manage optimal database designs for data warehouses. This also extends to data lakes and many other extensive databases. People ask them to do this using relational database management systems. Organizations will use these databases for business intelligence, data mining, and data analytics. They are rather different from traditional online transaction processing systems. So what special design concerns will we face? What database editions and features will we rely upon? What kind of query execution plans should we seek?
Watch the educational Geek Sync webinar “Tips for data warehouses and other very large databases” with Bert Scalzo to learn more about all pertinent issues. Some may even consider them best practices for such specialized database requirements. While the basic concepts will apply, examples will be in Oracle Database, with some also in MySQL, SQL Server, and PostgreSQL.