doi: 10.4304/jsw.3.6.37-45
Information Storage and Retrieval Schemes for Recycling Products
- 1 Graduate School of Engineering, University of Fukui 3-9-1 Bunkyo, Fukui City, 910-8507, Japan
- 2 Graduate School of Engineering, University of Fukui 3-9-1 Bunkyo, Fukui City, 910-8507, Japan
Abstract
A recycling object is in its recycle chain andits status may often change according to recyclingstage or reusing status; even its structure could oftendynamically change according to its reusing demand.Capturing the structure of recycling objects with a singleuniform schema definition is hard and the conventionaldatabase management system would be inadequate to dealwith this situation. Moreover database management systememployed in a recycle management system is better toprovide the capability of not only storing and retrievinginformation but also that of OnLine Analytical Processing(OLAP) especially along the time axis. OLAP capabilityserves as an aid of better decision making for recyclingmanufactures or dealers. This paper considers severalrequirements needed for recycling management systems,especially on their information storage architecture andretrieval capability for recycling objects. Their realizationscheme adapting these requirements will also be discussed.Using concrete examples based on SQL statements, we willdemonstrate advantages of our realization scheme.Improving lower level storage organization or internal datastructuring strategy for storing recycling objects canprovide handling efficiency or retrieval efficiency ratherindependently of the kind of recycling object. Recyclingobjects discussed here are assumed to be end products.
Keywords
- storage structure
- recycling objects
- inf
How to Cite
Takayuki Tsuchida, Teppei Shimada, Tatsuo Tsuji, and Ken Higuchi, "Information Storage and Retrieval Schemes for Recycling Products," Journal of Software, vol. 3, no. 6, pp. 37-45, 2008. https://doi.org/ 10.4304/jsw.3.6.37-45
Copyright & License
Copyright © 2008 by the authors. This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited (CC BY 4.0).