The paper firstly analyze cache replacement strategies at present, and proposed the ideas of the semantic query cache replacement based on user access features, and describe the semantic similarity calculation and rea...The paper firstly analyze cache replacement strategies at present, and proposed the ideas of the semantic query cache replacement based on user access features, and describe the semantic similarity calculation and realize the algorithm of replacement strategy. The strategy use semantic to match information in the query cache, through dynamic analysis and tracking three characteristics of user access time, user access to content and Business Association, give out the similarity minimum of the cache item, to improve the hit ratio of the cache and the response time and throughput of the server is improved.展开更多
Evolving From principal-subordinate structure of C /S to flexible multileveled distributed structure, i.e. B/S architecture so as to form a wide, distributed and orderly Internet/Intranet integrated management inf orm...Evolving From principal-subordinate structure of C /S to flexible multileveled distributed structure, i.e. B/S architecture so as to form a wide, distributed and orderly Internet/Intranet integrated management inf ormation system, is the trend of development of application software of the whol e world. Advantages and disadvantages of the two modes: C/S and B/S are compared . It is pointed out that at present onefold B/S mode cannot yet fully fullfil th e demands of some complicated data processing, information statistics and analys is, etc, therefore it still awaits further development of technology to achieve 100% Internet. In this paper, a mode of B/S-C/S-blended multileveled architect ure is discussed; the logical levels of B/S mode is studied; Furthermore, combin ing some up-to-date software developing technology, combinatorial design of di fferent database application technology based on B/S is discussed. The expatiati on is made with following points: (1) Organic combination of the network distrib uted object technology of CORBA and the computation technology among different n etwork operating system ─ Java; (2) Organic combination of two modes of ASP and Plug_in; (3) JDBC Server and JDBC Client; (4) An expanded B/S model, i.e. the c lient application of browser communicates directly with Web server, and the serv er application communicates directly with database server through middle ware.展开更多
An electromagnet design system is developed using Visual C++ language and OpenGL technology to visualize parametric 3D model. The system consists of primary design, optimization design, dynamic and static characterist...An electromagnet design system is developed using Visual C++ language and OpenGL technology to visualize parametric 3D model. The system consists of primary design, optimization design, dynamic and static characteristics, and visual simulation. All empirical parameters and curves used in design process are stored in database. Through human-computer interactions, an electromagnetic system can be designed conveniently with the results and characteristics curves displayed in graphic model. Using this system can greatly shorten the process of product design, and the results satisfy technical requirements.展开更多
This paper describes the design, implementation and applications of theeco-environmental information system in Tianjin City, which is the kernel of the decision support sys-tem for urban eco-environmental regulation (...This paper describes the design, implementation and applications of theeco-environmental information system in Tianjin City, which is the kernel of the decision support sys-tem for urban eco-environmental regulation (DSSUER) The design of this information system isbased on the analysis of the requirements of users. The system features that it has expendability,maintainability and universality, makes data be shared between different components of DSSUERand provides help facilities and protection. The system is built by using database and graphic basetechnologies it consists of the main control module, data-management module and data-proassingniodule. The applications of this system is demonstrated by an example which is the case ofsuitability analysis of land use for residential areas in Tianjin.展开更多
Large language model-based(LLM-based)text-to-SQL methods have achieved important progress in generating SQL queries for real-world applications.When confronted with table content-aware questions in real-world scenario...Large language model-based(LLM-based)text-to-SQL methods have achieved important progress in generating SQL queries for real-world applications.When confronted with table content-aware questions in real-world scenarios,ambiguous data content keywords and nonexistent database schema column names within the question lead to the poor performance of existing methods.To solve this problem,we propose a novel approach towards table content-aware text-to-SQL with self-retrieval(TCSR-SQL).It leverages LLM's in-context learning capability to extract data content keywords within the question and infer possible related database schema,which is used to generate Seed SQL to fuzz search databases.The search results are further used to confirm the encoding knowledge with the designed encoding knowledge table,including column names and exact stored content values used in the SQL.The encoding knowledge is sent to obtain the final Precise SQL following multirounds of generation-execution-revision process.To validate our approach,we introduce a table-content-aware,questionrelated benchmark dataset,containing 2115 question-SQL pairs.Comprehensive experiments conducted on this benchmark demonstrate the remarkable performance of TCSR-SQL,achieving an improvement of at least 27.8%in execution accuracy compared to other state-of-the-art methods.展开更多
文摘The paper firstly analyze cache replacement strategies at present, and proposed the ideas of the semantic query cache replacement based on user access features, and describe the semantic similarity calculation and realize the algorithm of replacement strategy. The strategy use semantic to match information in the query cache, through dynamic analysis and tracking three characteristics of user access time, user access to content and Business Association, give out the similarity minimum of the cache item, to improve the hit ratio of the cache and the response time and throughput of the server is improved.
文摘Evolving From principal-subordinate structure of C /S to flexible multileveled distributed structure, i.e. B/S architecture so as to form a wide, distributed and orderly Internet/Intranet integrated management inf ormation system, is the trend of development of application software of the whol e world. Advantages and disadvantages of the two modes: C/S and B/S are compared . It is pointed out that at present onefold B/S mode cannot yet fully fullfil th e demands of some complicated data processing, information statistics and analys is, etc, therefore it still awaits further development of technology to achieve 100% Internet. In this paper, a mode of B/S-C/S-blended multileveled architect ure is discussed; the logical levels of B/S mode is studied; Furthermore, combin ing some up-to-date software developing technology, combinatorial design of di fferent database application technology based on B/S is discussed. The expatiati on is made with following points: (1) Organic combination of the network distrib uted object technology of CORBA and the computation technology among different n etwork operating system ─ Java; (2) Organic combination of two modes of ASP and Plug_in; (3) JDBC Server and JDBC Client; (4) An expanded B/S model, i.e. the c lient application of browser communicates directly with Web server, and the serv er application communicates directly with database server through middle ware.
文摘An electromagnet design system is developed using Visual C++ language and OpenGL technology to visualize parametric 3D model. The system consists of primary design, optimization design, dynamic and static characteristics, and visual simulation. All empirical parameters and curves used in design process are stored in database. Through human-computer interactions, an electromagnetic system can be designed conveniently with the results and characteristics curves displayed in graphic model. Using this system can greatly shorten the process of product design, and the results satisfy technical requirements.
文摘This paper describes the design, implementation and applications of theeco-environmental information system in Tianjin City, which is the kernel of the decision support sys-tem for urban eco-environmental regulation (DSSUER) The design of this information system isbased on the analysis of the requirements of users. The system features that it has expendability,maintainability and universality, makes data be shared between different components of DSSUERand provides help facilities and protection. The system is built by using database and graphic basetechnologies it consists of the main control module, data-management module and data-proassingniodule. The applications of this system is demonstrated by an example which is the case ofsuitability analysis of land use for residential areas in Tianjin.
基金supported by the National Key Research and Development Program of China under(Grant 2023YFB3106504)Guangdong Provincial Key Laboratory of Novel Security Intelligence Technologies under(Grant 2022B1212010005)+2 种基金the Major Key Project of PCL under(Grant PCL2023A09)Shenzhen Science and Technology Program under(Grants ZDSYS20210623091809029 and RCBS20221008093131089)the project of Guangdong Power Grid Co.Ltd.under(Grants 037800KC23090005 and GD-KJXM20231042).
文摘Large language model-based(LLM-based)text-to-SQL methods have achieved important progress in generating SQL queries for real-world applications.When confronted with table content-aware questions in real-world scenarios,ambiguous data content keywords and nonexistent database schema column names within the question lead to the poor performance of existing methods.To solve this problem,we propose a novel approach towards table content-aware text-to-SQL with self-retrieval(TCSR-SQL).It leverages LLM's in-context learning capability to extract data content keywords within the question and infer possible related database schema,which is used to generate Seed SQL to fuzz search databases.The search results are further used to confirm the encoding knowledge with the designed encoding knowledge table,including column names and exact stored content values used in the SQL.The encoding knowledge is sent to obtain the final Precise SQL following multirounds of generation-execution-revision process.To validate our approach,we introduce a table-content-aware,questionrelated benchmark dataset,containing 2115 question-SQL pairs.Comprehensive experiments conducted on this benchmark demonstrate the remarkable performance of TCSR-SQL,achieving an improvement of at least 27.8%in execution accuracy compared to other state-of-the-art methods.
