Insight Enterprises has filed a patent for a method of creating dimension tables and fact tables for data warehouses. The method involves accessing an ordered sequence of activities in a template, organizing code into different processing classes, executing the activities, and creating the tables accordingly. The patent aims to streamline the process of creating tables in data warehouses. GlobalData’s report on Insight Enterprises gives a 360-degree view of the company including its patenting strategy. Buy the report here.

According to GlobalData’s company profile on Insight Enterprises, Holographic HUDs was a key innovation area identified from patents. Insight Enterprises's grant share as of September 2023 was 41%. Grant share is based on the ratio of number of grants to total number of patents.

Method for creating dimension and fact tables for data warehouse

Source: United States Patent and Trademark Office (USPTO). Credit: Insight Enterprises Inc

A recently filed patent (Publication Number: US20230315760A1) describes a method and system for creating dimension tables and fact tables for a data warehouse. The method involves accessing an ordered sequence of activities arranged in a template. These activities include importing code, defining standard variables, creating instances of dimension processing and fact processing classes, reading data from a source data store, performing transformations on the data, identifying attributes, writing the data into a target table in the data warehouse, and performing checks on the target table. The ordered sequence of activities is executed, resulting in the creation of the dimension table when the dimension processing class is created and the creation of the fact table when the fact processing class is created.

The patent also describes the organization of the code into a class infrastructure, where a common processing class serves as the parent class and the dimension and fact processing classes are child classes that inherit from the common processing class. The code defining the ordered sequence of activities may include additional sets of code for auditing steps and data transformation steps, which are components of the common processing class. These sets of code can include methods for generating and storing metadata during the execution of the activities.

The ordered sequence of activities can be accessed by a user through a user interface, with the code associated with the activities hidden from the user. The template used for the activities includes locations for the user to input code statements. Standard variables, such as the identification of the data object and the data warehouse, are defined as part of the method.

The functionality of the ordered sequence of activities can be modified by adding methods into the dimension processing class, fact processing class, or common processing class. The method and system described in the patent are particularly applicable to extract-transform-load (ETL) processes, which are commonly used in data warehousing.

In summary, the patent presents a method and system for creating dimension tables and fact tables in a data warehouse. The method involves accessing an ordered sequence of activities, executing them, and utilizing a class infrastructure for organizing the code. The patent also describes the inclusion of additional code for auditing and data transformation, as well as the ability to modify the functionality of the activities. The method and system are designed to be user-friendly, with a user interface and hidden code.

To know more about GlobalData’s detailed insights on Insight Enterprises, buy the report here.

Premium Insights


The gold standard of business intelligence.

Blending expert knowledge with cutting-edge technology, GlobalData’s unrivalled proprietary data will enable you to decode what’s happening in your market. You can make better informed decisions and gain a future-proof advantage over your competitors.


GlobalData, the leading provider of industry intelligence, provided the underlying data, research, and analysis used to produce this article.

GlobalData Patent Analytics tracks bibliographic data, legal events data, point in time patent ownerships, and backward and forward citations from global patenting offices. Textual analysis and official patent classifications are used to group patents into key thematic areas and link them to specific companies across the world’s largest industries.