A database design methodology is defined for the design of large relational databases. First, the data requirements are conceptualized using an extended entity-relationship model, with the extensions being additional semantics such as ternary relationships, optional relationships, and the generalization abstraction. The extended entity-relationship model is… (More)
The goal of on-line analytical processing (OLAP) is to quickly answer queries from large amounts of data residing in a data warehouse. Materialized view selection is an optimization problem encountered in OLAP systems. Published work on the problem of materialized view selection presents solutions scalable in the number of possible views. However, the… (More)
New software engineering techniques and the necessity to improve the user interface in increasingly interactive software environments have led to a change in traditional software development methods. Methodologies for improvement of the interface design, an overview of the human factors element, and cost/benefit aspects are explored.
A data warehouse stores materialized views of aggregate data derived from a fact table in order to minimize the query response time. One of the most important decisions in designing the data warehouse is the selection of materialized views. This paper presents an algorithm which provides appropriate views to be materialized while the goal is to minimize the… (More)
We develop an analytic performance model for client/server communications using Remote Procedure Call (RPC) with no security o v er the connectionless datagram protocol in the Open Software Foundation's Distributed Computing Environment (OSF/DCE). It combines features from NetMod, a network performance modeling tool, and the Method of Layers which is a… (More)
Entity-relationship clustering promotes the simplicity that is vital for fast end-user comprehension, as well as the complexity at a more detailed level to satisfy the database designer's need for extended semantic expression in the conceptual model.
The gathering of a variety of human-oriented information is vital in the development stages of a software system. This information can be applied at a given stage to improve the human-computer interface of the software product. To reflect this, new categories of design and~or development effort need to be added to the traditional systems development stages.… (More)