An indexing-based approach for rapid and efficient product information integration and retrieval

Fan, Xueting

Permalink

https://hdl.handle.net/2142/30908 Copy

Description

Title

An indexing-based approach for rapid and efficient product information integration and retrieval

Author(s)

Fan, Xueting

Issue Date

2012-05-22T00:14:31Z

Director of Research (if dissertation) or Advisor (if thesis)

• Dutta, Debasish
• Patil, Lalit

Department of Study

Industrial&Enterprise Sys Eng

Discipline

Industrial Engineering

Degree Granting Institution

University of Illinois at Urbana-Champaign

Degree Name

M.S.

Degree Level

Thesis

Keyword(s)

• Information Integration
• Data Retrieval
• Indexing

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.

Graduation Semester

2012-05

Permalink

http://hdl.handle.net/2142/30908

Copyright and License Information

Copyright 2012 Xueting Fan

Owning Collections