Papers by Richard Ramirez
Omega, 1986
Recent technological developments have brought on a revolution in the design and operation of war... more Recent technological developments have brought on a revolution in the design and operation of warehousing systems. Automatic storage/retrieval systems (AS/RS) driven by embedded computers are becoming increasingly more prevalent. The increased use of AS/RS is creating the need for computerized control algorithms to support the scheduling and logistical decisions in such automated warehouses. In this research we explore the problem of deciding which storage locations to retrieve when confronted with a set of discrete orders for a given inventory item. In addition to the normal costs associated with the retrieval decision, this support introduces the cost of a location "breakdown" as a complicating factor in the retrieval decision. The problem is formulated as a type of mixed zero--one integer program. Computational results from a sample set of problems are reported.
Negotiation in organizational DSS using extended relational views
Hawaii International Conference on System Sciences, 1993
Subscript-free indexing in a mathematical programming language
Hawaii International Conference on System Sciences, 1993
Indexing in mathematical programming languages is supported explicitly through subscripts or impl... more Indexing in mathematical programming languages is supported explicitly through subscripts or implicitly through vector and matrix notations. An approach that combines the best features of subscripts and implicit indexing is presented. Algebraic expressions are defined without subscripts. The indexing information is made explicit and precedes each expression. Applications are shown for dense, sparse, offset, and other forms of indexing
Omega, 1986
Recent technological developments have brought on a revolution in the design and operation of war... more Recent technological developments have brought on a revolution in the design and operation of warehousing systems. Automatic storage/retrieval systems (AS/RS) driven by embedded computers are becoming increasingly more prevalent. The increased use of AS/RS is creating the need for computerized control algorithms to support the scheduling and logistical decisions in such automated warehouses. In this research we explore the problem of deciding which storage locations to retrieve when confronted with a set of discrete orders for a given inventory item. In addition to the normal costs associated with the retrieval decision, this support introduces the cost of a location "breakdown" as a complicating factor in the retrieval decision. The problem is formulated as a type of mixed zero--one integer program. Computational results from a sample set of problems are reported.
NF2 relations and complex objects for model management systems
Hawaii International Conference on System Sciences, 1990
An SQL-based system is described that supports complex objects, nonnormalized (NF2) relations, ar... more An SQL-based system is described that supports complex objects, nonnormalized (NF2) relations, arrays, matrices, ordered lists, and versions. Both object-oriented and data views of a relational database are supported. The system supports the integration of OR/MS (operations research and management science) modeling with corporate databases. It is part of the ASUMMS model management system. The data subsystem includes a fully-fledged
Negotiation in organizational DSS using extended relational views
Hawaii International Conference on System Sciences, 1993
Information & Management, 1990
Mathematical specifications of data models provide formal means to prove the correctness of the m... more Mathematical specifications of data models provide formal means to prove the correctness of the models. Such specifications may be used as prototypes to determined the result of transactions on a database. This paper describes the use of logic programming to mechanize the axiomatization of a proposed extension to the relational data model. The extended model is defined using a many-sorted algebra termed DRE-algebra. The DRE-algebra is then directly implemented in PROLOG. The implementation helps in verifying the correctness of the DRE-algebra and is used as an early prototype to investigate design decisions.
Subscript-free indexing in a mathematical programming language
Hawaii International Conference on System Sciences, 1993
Indexing in mathematical programming languages is supported explicitly through subscripts or impl... more Indexing in mathematical programming languages is supported explicitly through subscripts or implicitly through vector and matrix notations. An approach that combines the best features of subscripts and implicit indexing is presented. Algebraic expressions are defined without subscripts. The indexing information is made explicit and precedes each expression. Applications are shown for dense, sparse, offset, and other forms of indexing
Modeling the business via object-oriented techniques
Hawaii International Conference on System Sciences, 1992
Information systems architecture (ISA) aims to provide an encompassing and integrated environment... more Information systems architecture (ISA) aims to provide an encompassing and integrated environment for both logical design and physical implementation of information systems. The authors propose a framework of information systems architecture by means of object-oriented techniques. Previous research influencing the design consideration is reviewed. Advantages of using the object-oriented approach in developing an ISA are discussed. The proposed ISA framework helps to model multiple organizational layers in a top-down fashion. Explanation of the framework is assisted with a real life example. The design of global meta tables and views is also discussed. The conclusions summarize current research status and set forth future research directions
NF2 relations and complex objects for model management systems
Hawaii International Conference on System Sciences, 1990
An SQL-based system is described that supports complex objects, nonnormalized (NF2) relations, ar... more An SQL-based system is described that supports complex objects, nonnormalized (NF2) relations, arrays, matrices, ordered lists, and versions. Both object-oriented and data views of a relational database are supported. The system supports the integration of OR/MS (operations research and management science) modeling with corporate databases. It is part of the ASUMMS model management system. The data subsystem includes a fully-fledged
Information & Management, 1990
Mathematical specifications of data models provide formal means to prove the correctness of the m... more Mathematical specifications of data models provide formal means to prove the correctness of the models. Such specifications may be used as prototypes to determined the result of transactions on a database. This paper describes the use of logic programming to mechanize the axiomatization of a proposed extension to the relational data model. The extended model is defined using a many-sorted algebra termed DRE-algebra. The DRE-algebra is then directly implemented in PROLOG. The implementation helps in verifying the correctness of the DRE-algebra and is used as an early prototype to investigate design decisions.
Derived Relations with Exceptions: Decision Support Capabilities
Derived Relations with Exceptions: Decision Support Capabilities RONALD DATTERO, RICHARD G. RAMIR... more Derived Relations with Exceptions: Decision Support Capabilities RONALD DATTERO, RICHARD G. RAMIREZ, and JOOBIN CHOOBINEH Ronald Dattero is Visiting Assistant Professor of MIS at Louisiana State Univer-sity. He received his Ph.D. from Purdue University. ...
Modeling the business via object-oriented techniques
Hawaii International Conference on System Sciences, 1992
Information systems architecture (ISA) aims to provide an encompassing and integrated environment... more Information systems architecture (ISA) aims to provide an encompassing and integrated environment for both logical design and physical implementation of information systems. The authors propose a framework of information systems architecture by means of object-oriented techniques. Previous research influencing the design consideration is reviewed. Advantages of using the object-oriented approach in developing an ISA are discussed. The proposed ISA framework helps to model multiple organizational layers in a top-down fashion. Explanation of the framework is assisted with a real life example. The design of global meta tables and views is also discussed. The conclusions summarize current research status and set forth future research directions
Scenario Management in Organizational DS
Hawaii International Conference on System Sciences, 1994
Page 1. SCENARIO MANAGEMENT IN ORGANIZATIONAL DSS Kathleen A. Moser, College of Business, Iowa st... more Page 1. SCENARIO MANAGEMENT IN ORGANIZATIONAL DSS Kathleen A. Moser, College of Business, Iowa state University, Ames, Iowa 5001 1-#)63 Uday R Kulkami, Decisioo and Information Systems, Arizona State University ...
Derived Relations with Exceptions: Decision Support Capabilities
Derived Relations with Exceptions: Decision Support Capabilities RONALD DATTERO, RICHARD G. RAMIR... more Derived Relations with Exceptions: Decision Support Capabilities RONALD DATTERO, RICHARD G. RAMIREZ, and JOOBIN CHOOBINEH Ronald Dattero is Visiting Assistant Professor of MIS at Louisiana State Univer-sity. He received his Ph.D. from Purdue University. ...
Model integration in an object-oriented model management system
Hawaii International Conference on System Sciences, 1991
Model integration is a difficult task. The difficulty is partly due to the complexity of represen... more Model integration is a difficult task. The difficulty is partly due to the complexity of representing each individual model and model relationships, and partly due to the lack of uniform references to model components. Object-oriented database systems have the capability of depicting different levels of data abstraction and assigning a unique identifier to each object. By applying object-oriented representation techniques, models and their relationships can be better expressed. By assigning object identifiers to model components, the problem of uniform references becomes easier to solve. The authors show a logical flow linking integration related modeling activities. They illustrate how model relationships are detected through the concept of object predicates. A procedure to implement model integration is also discussed
Scenario Management in Organizational DS
Hawaii International Conference on System Sciences, 1994
Page 1. SCENARIO MANAGEMENT IN ORGANIZATIONAL DSS Kathleen A. Moser, College of Business, Iowa st... more Page 1. SCENARIO MANAGEMENT IN ORGANIZATIONAL DSS Kathleen A. Moser, College of Business, Iowa state University, Ames, Iowa 5001 1-#)63 Uday R Kulkami, Decisioo and Information Systems, Arizona State University ...
The cost of retrievals in what-if databases
Hawaii International Conference on System Sciences, 1991
Multiple scenarios are critical to what-if analysis. Alternate versions of a database are require... more Multiple scenarios are critical to what-if analysis. Alternate versions of a database are required. Each version is manipulated and updated as if it were the real database; however, only differences between the version and the real database are stored. Extensions to relational databases to support alternate versions include hypothetical relations and derived relations with exceptions. This paper introduces independently-updated views (IUVs) for creating multiple scenarios and analyzes the overhead for supporting different types of views and queries. The overhead is minimum for creating what-if scenarios based on aggregate views and on views which are small subsets of the database. In case of views which require retrieval of entire or large portions of base tables, the overhead can be high
Model integration in an object-oriented model management system
Hawaii International Conference on System Sciences, 1991
Model integration is a difficult task. The difficulty is partly due to the complexity of represen... more Model integration is a difficult task. The difficulty is partly due to the complexity of representing each individual model and model relationships, and partly due to the lack of uniform references to model components. Object-oriented database systems have the capability of depicting different levels of data abstraction and assigning a unique identifier to each object. By applying object-oriented representation techniques, models and their relationships can be better expressed. By assigning object identifiers to model components, the problem of uniform references becomes easier to solve. The authors show a logical flow linking integration related modeling activities. They illustrate how model relationships are detected through the concept of object predicates. A procedure to implement model integration is also discussed
The cost of retrievals in what-if databases
Hawaii International Conference on System Sciences, 1991
Multiple scenarios are critical to what-if analysis. Alternate versions of a database are require... more Multiple scenarios are critical to what-if analysis. Alternate versions of a database are required. Each version is manipulated and updated as if it were the real database; however, only differences between the version and the real database are stored. Extensions to relational databases to support alternate versions include hypothetical relations and derived relations with exceptions. This paper introduces independently-updated views (IUVs) for creating multiple scenarios and analyzes the overhead for supporting different types of views and queries. The overhead is minimum for creating what-if scenarios based on aggregate views and on views which are small subsets of the database. In case of views which require retrieval of entire or large portions of base tables, the overhead can be high
Uploads
Papers by Richard Ramirez