We have used SQL databases, PC based software tools, high volume network printers, and optical scanning technology to build an information system for a clinical trial that tracks the ambulatory care of over 60,000 patients at seven VA hospitals. The system presents patient information to providers at General Internal Medicine (GIM) clinic visits for 26,800 patients assigned to the intervention ...

Health care claims data are complicated animals. The eccentricities of this data include differences in the types of claims files and the services which populate those files, variations in the type of providers who service the population and the information needed about each type of provider, and finally, the actual populations of health care recipients and all of their individual specification...

QBX is a CASE tool for data mart design resulting from a close collaboration between academy and industry. It supports designers during conceptual design, logical design, and deployment of ROLAP data marts in the form of star/snowflake schemata, and it can also be used by business users to interactively explore project-related knowledge at different levels of abstraction. We will demonstrate QB...

Hormone antagonist therapy for estrogen receptor positive (ER+) breast cancer patients post radical surgery and radiation therapy has a poor prognosis and also causes bone loss. 1α,25-dihydroxyvitamin D(3) [1α,25(OH)(2)D(3)] is a potent antitumor agent in pre-clinical studies, but caused hypercalcemia when its effective antitumor doses were used. Therefore, we investigated the effects of a less...

The DWB architecture pictures an enterprise composed of a set of business processes. In many businesses the processes may be components of supply chains and value chains. In other businesses they may represent "value circles." Either way, taken as a whole they represent the activities that produce the value stream of the enterprise. To describe the properties of the processes and ultimately the...

In data warehouse and data mart systems, queries often take a long time to execute due to their complex nature. Query response times can be greatly improved by caching final/intermediate results of previous queries, and using them to answer later queries. An automatic caching system that makes intelligent decisions on what results to cache would be an important step towards knobs-free operation...

This paper proposes a bottom-up method that helps designers of decision support systems to construct data mart schemas based on an object database. Our method extracts the database schema from the repository of the object DBMS in order to work on the most recent version of the transactional system’s data model. It then applies a set of rules to identify facts, measures, dimensions and their att...