Tools for Building a Warehouse

Data warehouses work by extracting information from multiple databases working on many types of computer platforms. They can be built by in-house staff or systems integrators such as I-Net and Sylvest. Here are the major components involved:

  • Extract Tools. These can be anything from programming languages, like COBOL or Natural, to automated tools that create new images of the data, such as Carlton's Passport. "Scrubbing" is generally performed during the extraction phase.
  • Data Transfer Tools. Products such as Software AG's SourcePoint help users move data into warehouses.
  • Database Management Software. Programs from companies such as Informix, Oracle and Sybase offer strong query capabilities and large storage capacity. Relational databases are best for simple, two-dimensional queries, while on-line analytical processing databases are better for multidimensional tasks, such as forecasting and trend analysis.
  • Application Software. Tools such as Patrol from BMC Software help manage and optimize multiple databases.
  • Servers. Powerful, enterprise-wide computers, such as Digital Equipment Corp.'s TurboLaser 8000, process and distribute data.
  • Query Tools. These software programs enable users to ask questions and essentially "mine" the data. Some perform two-or three-dimensional queries while others use deductive reasoning to determine relationships between data.
  • Delivery Systems. Products such as Digital's TeamLinks, Lotus Notes or Netscape's Web browser help route query results back to end-users via e-mail, local-area networks or the Internet.
Stay up-to-date with federal news alerts and analysis — Sign up for GovExec's email newsletters.
FROM OUR SPONSORS
JOIN THE DISCUSSION
Close [ x ] More from GovExec
 
 

Thank you for subscribing to newsletters from GovExec.com.
We think these reports might interest you:

  • Sponsored by G Suite

    Cross-Agency Teamwork, Anytime and Anywhere

    Dan McCrae, director of IT service delivery division, National Oceanic and Atmospheric Administration (NOAA)

    Download
  • Data-Centric Security vs. Database-Level Security

    Database-level encryption had its origins in the 1990s and early 2000s in response to very basic risks which largely revolved around the theft of servers, backup tapes and other physical-layer assets. As noted in Verizon’s 2014, Data Breach Investigations Report (DBIR)1, threats today are far more advanced and dangerous.

    Download
  • Federal IT Applications: Assessing Government's Core Drivers

    In order to better understand the current state of external and internal-facing agency workplace applications, Government Business Council (GBC) and Riverbed undertook an in-depth research study of federal employees. Overall, survey findings indicate that federal IT applications still face a gamut of challenges with regard to quality, reliability, and performance management.

    Download
  • PIV- I And Multifactor Authentication: The Best Defense for Federal Government Contractors

    This white paper explores NIST SP 800-171 and why compliance is critical to federal government contractors, especially those that work with the Department of Defense, as well as how leveraging PIV-I credentialing with multifactor authentication can be used as a defense against cyberattacks

    Download
  • Toward A More Innovative Government

    This research study aims to understand how state and local leaders regard their agency’s innovation efforts and what they are doing to overcome the challenges they face in successfully implementing these efforts.

    Download
  • From Volume to Value: UK’s NHS Digital Provides U.S. Healthcare Agencies A Roadmap For Value-Based Payment Models

    The U.S. healthcare industry is rapidly moving away from traditional fee-for-service models and towards value-based purchasing that reimburses physicians for quality of care in place of frequency of care.

    Download
  • GBC Flash Poll: Is Your Agency Safe?

    Federal leaders weigh in on the state of information security

    Download

When you download a report, your information may be shared with the underwriters of that document.