Search PubMed⌕ Search
Home/Archive/PubMed

PubMed · 8591249

Dimensional modeling: beyond data processing constraints.

A Bunardzic
View original source ↗Export metadata ↓

Abstract

The focus of information processing requirements is shifting from the on-line transaction processing (OLTP) issues to the on-line analytical processing (OLAP) issues. While the former serves to ensure the feasibility of the real-time on-line transaction processing (which has already exceeded a level of up to 1,000 transactions per second under normal conditions), the latter aims at enabling more sophisticated analytical manipulation of data. The OLTP requirements, or how to efficiently get data into the system, have been solved by applying the Relational theory in the form of Entity-Relation model. There is presently no theory related to OLAP that would resolve the analytical processing requirements as efficiently as Relational theory provided for the transaction processing. The "relational dogma" also provides the mathematical foundation for the Centralized Data Processing paradigm in which mission-critical information is incorporated as 'one and only one instance' of data, thus ensuring data integrity. In such surroundings, the information that supports business analysis and decision support activities is obtained by running predefined reports and queries that are provided by the IS department. In today's intensified competitive climate, businesses are finding that this traditional approach is not good enough. The only way to stay on top of things, and to survive and prosper, is to decentralize the IS services. The newly emerging Distributed Data Processing, with its increased emphasis on empowering the end user, does not seem to find enough merit in the relational database model to justify relying upon it. Relational theory proved too rigid and complex to accommodate the analytical processing needs. In order to satisfy the OLAP requirements, or how to efficiently get the data out of the system, different models, metaphors, and theories have been devised. All of them are pointing to the need for simplifying the highly non-intuitive mathematical constraints found in the relational databases normalized to their 3rd normal form. Object-oriented approach insists on the importance of the common sense component of the data processing activities. But, particularly interesting, is the approach that advocates the necessity of 'flattening' the structure of the business models as we know them today. This discipline is called Dimensional Modeling and it enables users to form multidimensional views of the relevant facts which are stored in a 'flat' (non-structured), easy-to-comprehend and easy-to-access database. When using dimensional modeling, we relax many of the axioms inherent in a relational model. We focus on the knowledge of the relevant facts which are reflecting the business operations and are the real basis for the decision support and business analysis. At the core of the dimensional modeling are fact tables that contain the non-discrete, additive data. To determine the level of aggregation of these facts, we use granularity tables that specify the resolution, or the level/detail, that the user is allowed to entertain. The third component is dimension tables that embody the knowledge of the constraints to be used to form the views.

Explore related subjects

Electronic Data ProcessingModels, TheoreticalJournal Article

Keep this discovery

Explore connections, maps & timelines

BibTeXRIS

A Bunardzic. 1995. Dimensional modeling: beyond data processing constraints.. https://pubmed.ncbi.nlm.nih.gov/8591249/

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

PubMed1999

Mobilizing a health professional's workstation--results of an evaluation study.

To evaluate the idea of a multifunctional mobile pen computer to support information processing tasks of health care professionals we carried out a field study. On a tablet-sized mobile pen computer we set up a health professional workstation, MEDIAS/WIN, with most of the application systems that are presently used by health professionals at Heidelberg University Medical Center. Our experiences during the study, involving 11 physicians, nine nurses and four computer scientists showed that it's not enough to make existing applications mobile most user interfaces have to be adapted for pen input. The presented system served as a valuable basis for study purposes but was not suitable for use in clinical routine. Patient data of the current clinical case and medical knowledge in the form of reference lists were found to be most important for mobile usage. Desirable functionality also included mobile access to electronic mail, electronic ordering of meals and some documentation tasks, e.g. the documentation of diagnoses and orders for diagnostic and therapy.

Electronic Data Processing↗
PubMed1999

Current techniques for assessing physical exposure to work-related musculoskeletal risks, with emphasis on posture-based methods.

Physical exposure to risks for potential work-related musculoskeletal injuries has been assessed using a variety of methods, including pen and paper based observation methods, videotaping and computer-aided analysis, direct or instrumental techniques, and various approaches to self-report assessment. These methods are critically reviewed in this paper. The applications of these techniques in ergonomic and epidemiologic studies are considered, and their advantages and shortcomings are highlighted. Finally, a strategy that considers both the ergonomics experts' view and the practitioners' needs for developing a practical exposure assessment tool is then discussed.

Electronic Data Processing↗
PubMed1999

Optical tracking of a microscope for image-guided intranasal sinus surgery.

The objective of this study was to examine the effects of optical and tracking properties on the accuracy of an optically locatable operating microscope. The intraoperative arrangement was based on experimental results obtained from a skull model. Measurements were taken from 24 patients undergoing intranasal microscopic sinus surgery for various disorders. Two major groups of influencing factors were determined from measurements on the model: 1) optical properties of the microscope, such as the method of focal point adjustment, focal length, and magnification of the lens; and 2) tracking properties of the microscope, such as the distance of the digitizer to the tracked object, the number of reference infrared light-emitting diodes (IR-LEDs), and the area circumscribed by these IR-LEDs. Patient measurements showed an overall spatial error of 2.39+/-1.15 mm with a laser-supported adjustment of the focal point of the microscope. Although the associated 95th percentile was at 4.36 mm, such a value is encouraging for further development of microscopically navigable systems. It must be noted that the noninvasive patient-to-image registration was performed on the basis of a computed tomographic image with a slice distance of 2 mm.

Electronic Data Processing↗