In this article that I wrote for SearchDataManagement.com, I discuss the fact that as relational database management systems handle more and more data, a strategic approach to data modeling has become vital.
One of the fundamental considerations in designing databases so they can meet performance expectations is what kinds of applications they’ll be supporting. There are three broad usage categories to factor into the design planning and data modeling stages: 1.Transactional or business workflow applications; 2. Business intelligence applications; 3. Data integration processes for funneling information into data warehouses, master data management hubs and other systems.
Author: Rick Sherman