Blogs
Data Architecture 101, Part 5: Indexes
Indexes have two main purposes in relational databases. First, they can improve query performance. Second, they can implement data-integrity constraints.
Indexes have two main purposes in relational databases. First, they can improve query performance. Second, they can implement data-integrity constraints.
In software-development & data architecture nirvana, the business analysts, database technologists, and application developers all speak the same language. Everyone agrees about what each user story means.
Data marts, data warehouses, and some operational datastores use dimension tables. A dimension table categorizes a fact table that joins to the dimension. At query time one filters the facts by values in the dimension table, and uses those values to label the query results
This post uses those concepts to survey the main types of relational architectures. These divide fundamentally into two types, the second having four sub-types: OLTP & BI.
This blog aims to become a “nutshell” treatment of the subject, so those of you who work with data in a relational database management system (RDBMS) can quickly learn how to make the best possible use of a database.
Our paper focuses on why enterprise data warehouse projects fail and what to do about it.