Research on Comprehensive Query Method in Database System
MU Tong-na
Abstract
MU Tong-na
Abstract
A method of designing comprehensive query mode was presented based on dynamic query sentence.It can make the query operation much simply and flexibly.Query principle and realization process were explained.By means of analyzing the grammar,usage of SQL,the designing thinking and function of comprehensive query,the readers can have a clear cognition for the realization of the method.According to the users' demands,the control of logic relation can be appended,the dynamic SQL query sentence that the multicondition assembly freely and the order arrange discretionarily can be created.Therefore,the query demands can be realized and the comprehensive query can be achieved.At last,combining with the multicondition query example of material intelligentized loading system developed by Delphi,the code about the function realization of comprehensive query was provided.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
A method of designing comprehensive query mode was presented based on dynamic query sentence.It can make the query operation much simply and flexibly.Query principle and realization process were explained.By means of analyzing the grammar,usage of SQL,the designing thinking and function of comprehensive query,the readers can have a clear cognition for the realization of the method.According to the users' demands,the control of logic relation can be appended,the dynamic SQL query sentence that the multicondition assembly freely and the order arrange discretionarily can be created.Therefore,the query demands can be realized and the comprehensive query can be achieved.At last,combining with the multicondition query example of material intelligentized loading system developed by Delphi,the code about the function realization of comprehensive query was provided.
Key concepts: Query by Example, Query optimization, Computer science, Sargable, Query expansion, RDF query language, Query language, Realization (probability)