iLuminate Takes a New Data Warehouse Tack

1 of 13

iLuminate Takes a New Data Warehouse Tack

by Jason Brooks

2 of 13

Data Statistics

I used Illuminate's iCorrelate analysis tool to drill down into tables, columns or query results, and view statistics on the information.

3 of 13

Expression Generator

I used iCorrelate's expressions feature to create two copies of the recipient ID columns.

4 of 13

Table Relationships

I linked one of the copied columns to the candidates table and the other to the committees table to use the tool's Get Relations and Find Relations query options.

5 of 13

Find Relations

I used the tool's Find Relations option to locate all the records that pointed to my results set of candidate entries.

6 of 13

Data Loading Tools

Before I could begin exploring my campaign data, I had to load it into the iLuminate engine, a task for which Illuminate offers two tool options: the iLuminate Importer and iLook & Load.

7 of 13

iLook & Load

Of the two tools, iLook & Load provided more information about my data as it entered the system, such as the totals and averages of integer-typed columns and the maximum and minimum values of individual columns.

8 of 13

iLuminate Importer

The stock importer tool performed faster than iLook & Load, handling my 15 million-record individual contributions table in about an hour and a half, compared with about five and a half hours with iLook & Load. In either case, the engine indexes all the data at load time.

9 of 13

ODBC Connectivity

I could access any of my tables or stored queries through an external application (in my case, Microsoft Excel) via ODBC.

10 of 13

Train-of-Thought Queries

When one of my queries covering the 1990 to 2008 election cycles turned up only results after 2002, I modified my query and went in search of those missing results.

11 of 13