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.

Xiaodong Wang, Yi Miao, Xiaohui Liu, Zhen Zhang, Ti Zhou, Yan Liu. Design and Implementation of Flexible-Specified Retrieval in a Unified Framework for Management System of Diverse Information. Academic Journal of Computing & Information Science (2021), Vol. 4, Issue 6: 48-53. https://doi.org/10.25236/AJCIS.2021.040608.

[1] https://docs.microsoft.com/zh-cn/sql/?view=sql-server-ver15.

[2] Zhong Zhishui and Yao Jun, "Implementation of library information management system based on Delphi," 2010 International Conference on Computer and Communication Technologies in Agriculture Engineering, 2010, pp. 170-173, doi: 10.1109/CCTAE.2010.5544394.

[3] https://docs.microsoft.com/en-us/dotnet/api/?view=netframework-4.8. 

[4] Ying Bai, "Accessing Data in ASP.NET," in SQL Server Database Programming with Visual Basic. NET: Concepts, Designs and Implementations, IEEE, 2020, pp.429-504, doi: 10.1002/9781119608493. ch8.

[5] Zhu Li-juan, "Research and application of SQL Server in the trade management system," 2011 3rd International Conference on Computer Research and Development, 2011, pp. 209-213, doi: 10.1109/ ICCRD.2011.5764282.

[6] C. Qi, "On index-based query in SQL Server database,"2016 35th Chinese Control Conference (CCC), 2016, pp. 9519-9523, doi: 10.1109/ChiCC.2016.7554868.