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

Information Integration;Data Retrieval;Indexing

Fan, Xueting ; Dutta ; Debasish ; Patil ; Lalit

关键词: Information Integration;    Data Retrieval;    Indexing;   

Others  :  https://www.ideals.illinois.edu/bitstream/handle/2142/30908/Fan_Xueting.pdf?sequence=1&isAllowed=y

美国|英语

来源: The Illinois Digital Environment for Access to Learning and Scholarship

【 摘 要 】

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.