Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
Search
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database

    iLuminate Takes a New Data Warehouse Tack

    By
    Jason Brooks
    -
    June 4, 2009
    Share
    Facebook
    Twitter
    Linkedin

      PrevNext

      1iLuminate Takes a New Data Warehouse Tack

      1

      by Jason Brooks

      2Data Statistics

      2

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

      3Expression Generator

      3

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

      4Table Relationships

      4

      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.

      5Find Relations

      5

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

      6Data Loading Tools

      6

      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.

      7iLook & Load

      7

      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.

      8iLuminate Importer

      8

      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.

      9ODBC Connectivity

      9

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

      10Train-of-Thought Queries

      10

      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.

      11Service Monitor

      11

      I could start, stop, create and switch among database files using a service monitor tool that would minimize to my system tray.

      12Charts and Reports

      12

      I could generate typical chart types within iCorrelate, as well as export my data sets to CSV files and create reports.

      13No Title

      PrevNext

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×