What is the i-Template?

   Modeling within the data warehousing industry has evolved, just as businesses have. With organizations now required to comply with multiple regulations, and with competition becoming an even bigger issue, companies must rely on their data warehouses to answer questions quickly, accurately, with an eye on the big picture. This can be facilitated through the i-Template, an evolutionary approach to data warehouse modeling. The patent-pending i-Template is an approach that combines the traditional Star Schema with 3rd Normal Form (3NF) modeling techniques.

Why is the i-Template Important?

  Stability. Flexibility. Efficiency. All are key components of a data warehouse strategy that will stand the test of time. That is what makes the i-Template an important part of your data warehouse approach. The model is flexible; it adapts to the functional needs of an organization without compromising the existing structure. The model is stable; it can support small-scale environments as well as terabyte size implementations – without worry about the stability or integrity of the data. It is efficient; by combining Star Schema and 3NF models we have embraced the best of both techniques.

In addition the i-Template offers:

   • Rapid adaptability to the business community
   • Support for both batch and near real time processing
   • Decreased storage costs
“On target” builds no matter the scope
   • Extensibility, scalability, and repeatability

 What is the Value of the i-Template?

  Implementation of the i-Template allows organizations to integrate new functional areas into their environment in a repeatable, efficient manner. This adapts to the fast-paced world that is realized once data warehouse infrastructures are in production. As requirements tend to come at a fast pace, so too can the implementation.

How Can Innovative Logic Help?

   • i-Template Assessment
   • Data Warehouse Assessment

   • i-Template Leadership and Mentoring
   • Data Warehouse Design using the i-Template


Just imagine walking into a business meeting where all analysts in the meeting are working with the same, accurate, complete set of data. The value of decisions made in those types of meetings is unsurpassable. ..

Do you have a good technique for nailing down VLDW requirements with your end users? Do you have analysts trained in capturing reporting and analysis requirements? If not, we can help...

The definition of a data warehouse has taken on many meanings and interpretations throughout the years. But at its core, a data warehouse represents a consolidated view of an entity's data – an integration point for all sources into one vision of the organization. ..