Dimensional Modeling

Dimensional Modeling for Support Ticket Processing

By | May 19th, 2015|Data Modeling|

Dimensional modeling becomes challenging, sometimes in uncommon situations, or that are not straightforward. Dimensional modeling with multiple stages of processing can sometimes be confusing and difficult. Such is the nature of a ticket-based support system where a single ticket can go through multiple stages and multiple people. So, how do you do dimensional modeling for [...]

CA ERwin-Using Naming Standards, Model Templates

By | May 1st, 2015|Data Modeling|

Data Modeling (Relational or Dimensional,) is a job that needs more thinking than really doing. It has more to do with gaining a better understanding of business processes and data that follows through those processes than knowing a bunch of technical terms or tools. However, having a good technical handle on tools like CA ERwin [...]