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:

  • Going Agile:Revolutionizing Federal Digital Services Delivery

    Here’s one indication that times have changed: Harriet Tubman is going to be the next face of the twenty dollar bill. Another sign of change? The way in which the federal government arrived at that decision.

    View
  • Cyber Risk Report: Cybercrime Trends from 2016

    In our first half 2016 cyber trends report, SurfWatch Labs threat intelligence analysts noted one key theme – the interconnected nature of cybercrime – and the second half of the year saw organizations continuing to struggle with that reality. The number of potential cyber threats, the pool of already compromised information, and the ease of finding increasingly sophisticated cybercriminal tools continued to snowball throughout the year.

    View
  • Featured Content from RSA Conference: Dissed by NIST

    Learn more about the latest draft of the U.S. National Institute of Standards and Technology guidance document on authentication and lifecycle management.

    View
  • GBC Issue Brief: The Future of 9-1-1

    A Look Into the Next Generation of Emergency Services

    View
  • GBC Survey Report: Securing the Perimeters

    A candid survey on cybersecurity in state and local governments

    View
  • The New IP: Moving Government Agencies Toward the Network of The Future

    Federal IT managers are looking to modernize legacy network infrastructures that are taxed by growing demands from mobile devices, video, vast amounts of data, and more. This issue brief discusses the federal government network landscape, as well as market, financial force drivers for network modernization.

    View
  • eBook: State & Local Cybersecurity

    CenturyLink is committed to helping state and local governments meet their cybersecurity challenges. Towards that end, CenturyLink commissioned a study from the Government Business Council that looked at the perceptions, attitudes and experiences of state and local leaders around the cybersecurity issue. The results were surprising in a number of ways. Learn more about their findings and the ways in which state and local governments can combat cybersecurity threats with this eBook.

    View

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