Files in this item



application/pdfFan_Xueting.pdf (2MB)
(no description provided)PDF


Title:An indexing-based approach for rapid and efficient product information integration and retrieval
Author(s):Fan, Xueting
Advisor(s):Dutta, Debasish; Patil, Lalit
Department / Program:Industrial&Enterprise Sys Eng
Discipline:Industrial Engineering
Degree Granting Institution:University of Illinois at Urbana-Champaign
Subject(s):Information Integration
Data Retrieval
Abstract:Throughout a product's lifecycle, multiple stakeholders interact with each other to generate large amounts of disparate information about it. All of modern product development, particularly, in Original Equipment Manufacturers (OEMs), involves integrating such information that exists in a number of databases into a cohesive decision support solution, for various activities, such as Resource Management and Prototype Management. This integration is typically handled in the current environment using ad-hoc and manual combinations of data to address specific queries. This approach is error-prone, time consuming and limiting because every new analysis requires the definition of a specific combination of data. In this paper, as first step towards the ideal dynamic system for information integration and retrieval, we present a novel framework called CachingDB that consists of a centered database built of optimized data tables and index structures from the underlying product databases. We exemplify the multiple challenges, such as disparity of data types (structured, unstructured, and geometric) within and across the databases, redundancy of information, huge data set, rapid changes to the underlying data, and a wide variety of complex queries. We demonstrate the issues by and conclude with results of application to structured data (non-shape) stored in different databases for Prototype Management, i.e., managing components, costs, and schedules in building Vehicle Prototypes.
Issue Date:2012-05-22
Rights Information:Copyright 2012 Xueting Fan
Date Available in IDEALS:2012-05-22
Date Deposited:2012-05

This item appears in the following Collection(s)

Item Statistics