Skip to main content
photo
 
HIMS Prototype Demonstration

Robert Dawes - BSS
Pat Schaffer - Oracle
Samir Ahuja - Oracle

The HIMS prototype runs on Oracle Express 6.0 and extracts data from an Oracle 8 database. Data were taken from various sources, consolidated or aggregated based on business rules, and displayed in cubes. The prototype summarizes transactions into multidimensional views ahead of time. And because the data are summarized or aggregated at the time they are loaded into the system, user queries are very fast. These data cubes display the HIMS information in several views, including by program, provider, time, and ad hoc.

On-Line Analytical Processing (OLAP) Data Mart

The prototype includes such user-friendly features as drop-down menus, spreadsheets, graphs, and drill-down capabilities. For example, users can view the client population, segmented into age groups, in a specific homeless shelter over the course of a year.

Clients by Facility by Age Groups

The ad hoc queries enable users to access specific slices of information. Data are available from the aggregate level all the way down to specific client populations and individual shelters. Users can search based on age, education level, family size, individual shelter, provider, and so on.

On-Line Analytical Processing (OLAP) Data Mart Terms

The versatility of the prototype system, which also produces graphs, allows users to access a wealth of information for analysis and decision making. The power of the HIMS data mart lies in allowing users to view the data according to their unique perspective and needs.

Data View: Pie Chart