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

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.

Name thesis:degree_name

M.S.

Level thesis:degree_level

Thesis

Discipline thesis:degree_discipline

Industrial Engineering

Grantor

University of Illinois at Urbana-Champaign

Year dc:date

2012

Author dc:creator

• Fan, Xueting

Contributors dc:contributor

• Dutta, Debasish
• Patil, Lalit

• Information Integration
• Data Retrieval
• Indexing

Statement dc:rights

• Copyright 2012 Xueting Fan

Language dc:language

en

Handle dc:identifier

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

OAI identifier oai:identifier

oai:www.ideals.illinois.edu:2142/30908