Design and Implementation of Flexible-Specified Retrieval in a Unified Framework for Management System of Diverse Information

Abstract

We have designed and implemented a diversed-information management system for both staff and department information based on .NET framework, B/S structure, Sql Server database and Visual Studio Develop Environment of Microsoft Corporation are adopted. Many kinds of personal and department-related information tables are created in the Sql Server database which results to difficulties in uniform retrieve and analysis. In traditional information retrieval applications, designers generate sql sentence from several fixed inputs and show the results in a fixed view. To enable flexible-specified advanced query of all that sorts of information in a unified framework, we import extra tables for describing information table columns called ‘AllTableInfo’ and extra views for personal information integration. Besides, query strings can be generated and transferred to the background processing program when the user selects the info-fields to output in specified form and sequence and sets the where condition. Sub query strings can be added to fulfill all-around queries using all kinds of where condition permutation and combination. Once specifying the query instance, the query string can be chosen as memorized so that the user can choose it easily and only set a few where conditions instead of specifying the query instance allover again. Through our design, the query input view and query results view can be generated dynamically and flexibly in a unified framework according to user’s choice of query need. What’s more, our work make it possible for user to set the query need accurately covering all conditions. In this paper we will explain how all these are designed and implemented.