Academic Journals Database
Disseminating quality controlled scientific knowledge

Information Storage and Retrieval Schemes for Recycling Products

Author(s): Takayuki Tsuchida | Teppei Shimada | Tatsuo Tsuji | Ken Higuchi

Journal: Journal of Software
ISSN 1796-217X

Volume: 3;
Issue: 6;
Start page: 37;
Date: 2008;
Original page

Keywords: storage structure | recycling objects | information retrieval | multidimensional data | OLAP

A recycling object is in its recycle chain and its status may often change according to recycling stage or reusing status; even its structure could often dynamically change according to its reusing demand. Capturing the structure of recycling objects with a single uniform schema definition is hard and the conventional database management system would be inadequate to deal with this situation. Moreover database management system employed in a recycle management system is better to provide the capability of not only storing and retrieving information but also that of OnLine Analytical Processing (OLAP) especially along the time axis. OLAP capability serves as an aid of better decision making for recycling manufactures or dealers. This paper considers several requirements needed for recycling management systems, especially on their information storage architecture and retrieval capability for recycling objects. Their realization scheme adapting these requirements will also be discussed. Using concrete examples based on SQL statements, we will demonstrate advantages of our realization scheme. Improving lower level storage organization or internal data structuring strategy for storing recycling objects can provide handling efficiency or retrieval efficiency rather independently of the kind of recycling object. Recycling objects discussed here are assumed to be end products.
Affiliate Program      Why do you need a reservation system?