>> What's gone away is the practice of writing complex, highly linked, normalized database schemas with layers of constraints and foreign key references That h

>> What's gone away is the practice of writing complex, highly linked, normalized database schemas with layers of constraints and foreign key references That hasn't gone away, that is the default for most corporate CRUD apps, for good reasons. Apps that aren't corporate CRUD apps are a rounding error away from not existing. You use the term data warehouse 3 times, are you sure you are describing a general case rather than one you are familiar with? If you want to offer different views of data in a normalized database to different consumers, one way to do that would be to use views.