Data modeling is a method of preparing data so it is ready for analysis and exploitation. Today’s BI applications include powerful tools that automate the traditionally time-consuming work of preparing, modeling, and profiling data for analysis.
Most of these apps use the OLTP (online transaction processing) data modeling approach. OLTP systems focus on fast query processing, while maintaining data integrity in multiple access environments and effectiveness, measured by number of transactions per second. An important attribute of an OLTP system is its ability to maintain concurrency. To avoid single points of failure, OLTP systems are often decentralized.