TWI221234B - An improved method of data inquiry system - Google Patents

Abstract

The invention discloses an improved method of self-defined inquiry condition, which is primarily applied to inquiry operation of information system of Internet and the regular enterprise. First of all, the invention reads and displays all titles of data columns on the target data (column) selected for inquiry to provide user the choices of unlimited target data (column). For the condition of data to be inquired, determine different data type to provide user every type of appropriate comparison operand (e.g. >, <, = and so forth). Secondly, for the inquiry relations (associated between inquiry conditions) between more than two different or identical target data, not only provide complete logic operands (e.g. and, or and so on), but also add operator symbol ""( )"", using the inquiry conditions generated to automatically combine as a finally required inquiry condition so as to provide user the inquiry direction with unlimited combination, using minimum inquiry number to gain more precise data and achieve goal of higher user's satisfaction.

Description

1221234

The present invention relates to an improved method for customizing data query conditions, and in particular, to a method for providing query objects and query conditions for user-defined data using an electronic attack with a computer microprocessor (CPU). [Background of the Invention] As a matter of fact, with the knowledge and knowledge, the increase of human resources includes the general business. It has become a user and added data query function. It has been developed by the torrent of technology tools that have been exploding for a long time. Due to the fact that the Internet of Things, the kind of needle-like industry resource system has become a trend when the information has changed, the demand and interest of users are always full of information technology. It does not improve data search. It does indeed have data query functions on the Internet, or there are many. difficult. For this reason, the number of query systems is increasing. Query direction by data. Make continuous progress, collect and organize information, and seek energy. As the average enterprise user wants to find whether it is an item in the network system before, it has a query function, and then people who have paid attention to it facelessly ask questions. The users of the data are looking for assistance that is not available on the Internet. They are more precise and do not seek the most important questions in order to share. According to the requirements, the written information on the system can be used to provide suitable information. The query system is commonly used by people, and the search conditions are "quoted," and "疋: combined with the information". A collection of "query conditional expressions" of private objects of data that the subject &quot; and the data do the data query, and the &quot; query object &quot; of the feed represents the $ 5 page 1222234 i number 9012R1fl?

Information fields (such as the author, Laoshan :, σ, · 1 / Λ ^ V. Description of the invention (2) For the case, the number of publications is eight times as long as the date of publication). The query conditions of the data are "Qi, Qi" (for example, more than one of the same data objects (fields) as a collection of query conditions (for example, "Author = Wang Guolongbao considers eight or more different data, only eight%") ), Or .trj shell object (field) as the query condition expression (such as "Author = Wang Guo 荦 and 蚩 9S π ·, η ·) 1 the result of the combination of all five ^ = Visual Basic6 〇 博; ^ · Shi Yuan used two or more identical or different assets and talents ") 'or" Yu Ren Bu Bei Village Objects (fields) as the query conditional data to query the conditions must have different ratios to the secondary representation. For example, if a Cuiyi data object (column two is the same data object (block)) for inquiries or |; nd-: 〇 ^ .. not ^ See also "a single query condition" in the present invention There are three parts: the object (data block), the comparison operator (&gt;, <, = to, 3 ~, value). Any two or more single queries: expression and two: yuan (&quot; J 是, &quot;) To combine it into "composite operation ^", and use parentheses "(), and these two single query conditional expressions are expressed as a composite query conditional expression. Compound query and single query conditional Combination with another compound ^^ ^ mouth to become a more complex compound money conditional expression. — ^ Piece type combination for example, suppose the user wants to query a single one; respectively: "gender" is "female" , "Age == three --------------" is "20 years old or younger"

—ES_i〇1261〇2 5. Description of the invention 0 query files = 2 ^ university (not included) or more ". The "three ages of this query" and the data object (shelves) 'are "sex", "year (referring to &quot; 比 _ ΐ ^"); the "query conditions" of each data object (shelves), and Cn are different. :, And the combination of &quot; query condition value &quot;), which are "= female and three crickets", and &gt; university ". Therefore, from these three data objects, you can form three single query conditional expressions (that is, data (that is, data like image two: gender = * sex "*). A single-query conditional expression is &quot; son-in-law sex &quot;; The comparison operand is; query condition value gender = female (^ may / to three single query condition expressions, respectively: 者 者 "logical operation symbol &quot; 〇Γ &quot; (or), or

, 00). If A, B, and C are followed by eight sn JLs and two single βLs, βL sequentially represents the upper one, and the other does not refer to the query: = d, the combination of conditional expressions that the user wants to query (specially (A and Bratd ΓΓ; 9 ^ # ^ ^ ^ ^ #

(Α π B) β is logically equal to (A and B -HI (AaJ): r C [equal to mathematically ("" B0rC) C;] m

(B and C) or a (C and A) 〇r B (A or B) and C (B or C) and A (C or A) and B

Assume that the real condition that the user wants to query is genp m cattle-like set. The meaning is as follows: Γ (Β or C) and

Page 7 V. Explanation of the invention (4) ___ ((Age> 20 or Educational Degree> Big _) This query condition is formed by -yo) π and gender, female) Yuan "or, and combined into a single tour of a single query Condition 0 element ", and this complex person 杳%: query the conditional expression, and then induce the logical operation of Γ 忑 口

Yu Sheng made a conclusion and became a final waiting condition, a query condition formula "gender = female but uncle", if supplemented by a general compound query bar symbol (), its apricot: to query the conditions listed above / ,, A will force the whole ^ categorically; the conditional expression is "B ^: person missing =) &quot; query bar connected to household category V cow type = there is a logical operation meta sign": 珣 conditional expression, and becomes The next two cases are c and A) Priority University "or Age &gt; 20", and the method: "(Gender = Female and Educational Level> Check the same. /, The user's real query needs are not currently widely used for actual input query When the conditions are met, only the / and query system can be used to determine the fixed logic conditions and fixed (such as>, &lt;, =, etc.) and logic — operations, no : Deflexibility selection comparison operation metagraph 'is the process of conventional technology: ° and,.:, Etc.), please refer to the second and second query system AQ chart, check the unified, query system technology, for ::: :; The common process of material query operation, the block of custom parts is subject to the logical judgment of the system's neighbor set Needed for the query and data query = the target fruit is not completely in line with the user's real query system until the end of the second operation 'the limited data fields and data records that are currently in the market and are still being searched. -IL has weak points b. It needs to be improved. The general daily amendment No. 90126102 is given. V. Description of the invention (5) The query system sees the following, and separately describes the following query system. . From the third picture can be seen / words "(Keywords) to enter the restricted block, but can not mention the various data blocks for query assistance (= keywords / words); the set of expressions, there are only" or "species The data query system can only query, any data block can only be searched out. Therefore, there are thousands of web page addresses obtained. In a single time, it is difficult to cope with the burden such as excess, and because the accuracy is also not high. Inquiry network "Yahoo Qimo" as an example, Qimo retrieves data in rows on the query system. The conditions of the data retrieved by the user are only logical operations and different data blocks. Check the logical operator for auxiliary. Also ^ Different data blocks make a single piece of resource information that matches the user's input. The user-filter, even if this huge amount of information, results in a wide range of coverage. "As the third" keyword icon is no choice. The condition of the query of yuan 丨 丨 = 丨 丨 is to say that the string key of this piece will be retrieved. " System two: 乂 1 0 4 talent search network as an example, as shown in the fourth figure. From the fourth figure, this search system is in each data field, allowing users to enter the work, compared to the query system one Provides the auxiliary of the logical operator π> „(the query two packs make η &gt;” — 丨 丨, not Ί, =). However, the set of conditional expressions to be swept between the same data blocks is only Provides ,, 〇r ,, the logical operand auxiliary; 1 For the set of conditional expressions to be queried between different data blocks, only the hidden 1221234 _ case number. Qoi ^ nn? V. Description of the invention (6) Modified land: Forced join, Iand "logic operation element help. The negative material query object is the auxiliary selection of the limited stop H search conditions). There are 7 types of data fields available for query system 3: Take the National Library's query network as an example, as shown in the figure, it can be seen that this query system strengthens the system as shown in Figure K. From the fifth: no] or the same data block, I want to query because it = 'k for &quot; and &quot;, |' 〇r &quot;, "n〇t &quot; The conditional expressions that you want to query in the bit also help. Each 疋 &gt; ,, &quot; &lt; &quot;, &quot; = &quot; is an auxiliary. However, in terms of resources, there are only limited data to stop the officials, The selection of objects on May 10th; the same or different information is used to hold the list; ::: The meaning of the request: the request string, only three query fields are provided, although you can group people above 7: said that it contains the exchange rate i · To include monetary policy) / such as "=" ΐ ", but the key person cannot combine the m rate and (the abstract contains monetary policy or key query conditions or y (the name of the thesis contains sink · · · :: =") (the abstract contains The query of the monetary policy "Keywords Contains the System)" is therefore not available to users in the conventional interface. The combination of "unrestricted" query conditions has a precision of ~ fruit. The function of "Information (such as .Dbase III Plus' Access) system, I inquiry form" provides users with the option to fill in Information to be searched on page 10 1222234 __Case No. 901261 ⑽ __ &quot; a 1 Amendment _ V. Description of the invention (7)… a ^ ever j ——— 一 ——___} conditions' and the conditions are also linked ( and, 〇r, η 〇t) provide optional use, but the conventional system still has the following three restrictions: (1) The "query form" function of the conventional access system requires professionals with database knowledge to apply, And cannot be popularized to general users ...

The use of the conventional system such as Access is not a general user, and it must have the ability to understand and memorize which data table is stored in the required query bar. In addition to using the "query table" function of this knowledge, even if it has data The data structure in the database of the knowledge base, how each data table corresponds to the query conditions, and the "function" can not generate a required data to check the technical knowledge of any database, but also to the general user who knows, if they have information Conditions of "Query Form" of the learning system. This is because it belongs to the technical knowledge of a database that is familiar with information technology. It is also necessary to have the data in the query field and the corresponding field names in order to generate the required query conditional expressions. If this technician ca n’t understand the relation between the data grid and the block in the database, he will use the “query table query conditions” of the conventional technology. Therefore, for those who do not have the database structure and association, they have nowhere to search for the query, but they often cannot. Function to generate the required data. Take the query conditions of "(male and unmarried and birthday> 1 960/1/1/1) or (female ^ unmarried and birthday H 970 / WD" as examples. (In =, first: For example, in Access's "Query Form" function, the user must first select which data tables to display. J: The user must know the query condition φ-Think P uses 1221234 V. Description of the invention (8) Each query object Λ了解 Knowed by &amp; Kaoshang and §Remember by far; the name of the corresponding stop in the asset database, for example, "Sex marriage, brother's corresponding stop name is" Gendermf ", corresponding in marriage The name of the block is "Marra- the marriage position is" and i's μ grandson, and different search links in the Φ # column, and the query condition in the same column is "or" user, the second one ^ the query condition The corresponding stop as shown in Figure 5bis After the name, enter the query condition value of "quasi," ρ symbol q, and complete the setting of the query condition. T In this example, the recognition system of the learning system is known in Knowledge 4 and has the structure and name of the database. Understand and record in advance, the included data table contains in the actual application database ί = hundreds of, and the data blocks it contains can be tabulated "to set the query conditions, you must first = ίί Action. Therefore, query conditions can be executed only after the structure is set: No (or ΙΙΙΡ1_ is not intended to be used by users who are not equipped with technical knowledge. (2) If you want to use a knowledge system (such as Access) "to determine more complex query conditions, you must first add the query conditions" to: analysis and dismantling can be set. A clever condition is used for analysis. 1ί! Ϋcharge (such as A⑽SS) The "query form" is set to 1221234 days ^ S_90126102_ ^ V P. V. Description of the invention (9) To set more complex search conditions, you must first set the search. To search conditions "((male and unmarried, Untied only 1 960/1/1) or (female and unmarried and birthday (Highest degree = university or highest degree = master) "= n) and the relationship between the two conditional expressions of the system is only" or "because in the exercise and (most southern degree = university or highest academic sentence part must be To dismantle it, find out the relationship with the previous two. The user must first disassemble the query condition: the marriage priest ’s birthday m 960/1/1 and the highest degree = university) male 1 ^ not yet unmarried And birthday> 196〇 / 1/1 and highest education = master ^ VT female i is unmarried and birthday> 1 970/1 / l and highest education = "University) ί) Λΐ / marriage and birthday> 1 970/1 / 1 and the highest education level = 1 = Figure 1 "Query form" settings' Please refer to the fifth 矣: *, the user in addition to confirming the corresponding query conditions, names and field names, also need to The disassembly of the query conditional expression (such as Λ will result in the same conditional expression that must be repeated for the same key, and it is inconvenient to use two and one person repeatedly in # unmarried and birthday &gt; 1 960/1/1). (3) Restricted queries require repeated input of query condition formulas: μ ... If the query condition formula becomes more complicated, it is even more difficult for ordinary users to easily access the "query form" of Access in the conventional technology. Based on the query male male and unmarried and birthday &gt; 1960/1/1) or (female and unmarried birthday &gt; 1970 / 1/1)) and ((highest degree = university or highest page 13 1221234

_Case No. 90126102 V. Description of the invention (10) Educational background = Master's degree or (Live in Taipei and (Blood type = 0 or Blood type = type 8))) "as an example, the user must disassemble this query condition first Kailai becomes (male and unmarried and born> 196〇 / 1/1 and highest education-university) or (female and unmarried and born> 197〇 / 1/1 and highest education = university) or (male and Unmarried and birthday> 196/1 / q and highest education = master) or (female and unmarried and birthday> 1 970/1/1 and most recent education = master) or (male and unmarried and birthday> 1 960 / 1/1 and live in Taipei and blood type = a) or (male and unmarried and blood type> 1960/1/1 and live in Taipei and blood type = 0) or (female and unmarried and birthday> 1 970/1/1 And live in Taipei with blood type = a) or (female and unmarried with birthday> 197〇 / 1/1 and live in Taipei with blood type = 0) in order to enter the inquiry form of the learning system according to the above query conditions ", As shown in Figure 5-4. In other words, the above query was originally a query structure belonging to "[(ΑχΒ 和 C) or (D and B and E)] and 丨 (F or G) or [Η 和 (J or Κ)]}", But it must pass through the user first, 5 be analyzed and disassembled into "(Α and B and C and 趵 or (Α and 8 and c and ㈨ and B and C and Η and) or (Α and B and C and Η And (K) or (D and B and E and F) or (&quot; D said β and E: and G) or and B and £ and or "structure of the serious" or ". For example, compare entered queries Conditional expression, the person must repeatedly enter the same query condition multiple times, for example (male and unmarried and birthday &gt; 1 960/1/1), it must be entered four times, (evening woman and unmarried and birthday &gt; 197 〇 / 1/1) It is also necessary to repeat the input four times and more. On the other hand, the user must set the original query condition to a fixed query structure: "(... and ... and ...) or (··· and ·· Solve into ...) or ... ", meaning that each is composed of" 了, Λ · and 122 UJ4 case number 90〗 26? Like five, invention description (ιό ZZZZZ ^ 3w§bi-fe. "Or" combination, has been restricted User ^ style, so use The user must solve the original ζ ^ query condition formula into such a special structure. When the query condition ^ query condition is analyzed and disassembled, the query condition expression will be multiplied, and it is difficult to disassemble ^ complex '. It also increases the difficulty of user input repeated repeated increase of user disassembly, so the inconvenience of the "query table ^, query conditional expression of the system Access. It is necessary to have knowledge of the database and use it again, except for the user must In addition to the field names, you must first enter the structure of the original search 11 library and the corresponding ones, and then input them one by one into the Access system ^ 4 for analysis, disassembly, and opening methods. 'There is no condition for ordinary users.' In general, the query you want to query is combined. In general data, the system, if you need to query the resource planning practice of the second industry in the database: the language provided by the system ; =: To use the database system, the method must require; =: Pieces of data. However, the query syntax of each = 1 fSD s in such a database structure, and must be connected before writing: Code, information Type 'state and mutual prerequisite work: J :: Query: method to find the required sample to be independent of the query method': two: general: users can not benefit from the query results:; = member In order to get the information you want to query ', you need to use such ancient liters * to increase the margin. Even the information person ζζζζ;-the retrieval of information, it is quite not K look at her ----- page 15 1222234 correction Ία} yCj j 号 9012610? V. Description of the invention (12) Two, ~ ,, bid, alpha shell bamboo rhinoceros data block number is customized, redundant or remarks, the block title and block of each data field Correspondence between bit codes, data types, and the interrelationship between the blocks are quite difficult; and the data block codes in general databases are often TD1 0 0 0 1, TD1 00 02 and other English generations 2 Ma has increased the corresponding difficulties, so you must first look up the table to write the grammar of the f condition; and each time you have different query requirements, you must rewrite the grammar of the query condition, which cannot achieve system automation and convenience. Claim. SUMMARY OF THE INVENTION The purpose of the electronic device of the main processor of the present invention and the custom logic is to provide a combination of operands. Another object of the invention is that one or multiple query bars must be set for selections that are frequently checked. The purpose is to set the check combination as infinite and effective in the storage type. The feature of the query is to provide a query method that allows the user to customize the query bar when the computer has micro-inquired data, which is the main method of the present invention. Customized query condition input and flexible logic simplify user data query operations. This issue saves the different orders that the user has set up to provide users with future use, without 疋 &gt; material query conditions, every time you have to make an inquiry due to the current data block and data bar inquired on the market Two backup two "system, for users to check the function query. In order to improve the current value = 'the second position of the data that users who want to take into account of all needs at the same time' $ is inadequate, the present invention can be used according to the ugliness, according to the 1212234 different information in the data shelf The analogy of the compound material shelf is the same as the present invention. "Selecting a group to distinguish the pattern, select one query bar, one or more query conditional expressions are not limited to a number of methods.

Then do the query condition and compare the operands. The combination of conditional expressions on the query action is the single or query input of the combined data, the system component before and after the compound query bar, or the purpose of the compound query action. You can query the system's composite condition first order, but you can add it before the piece type, or add it before the piece type in the open-ended condition formula. For the material type data block and the phase logic row, (For users to join) 丨 丨 Add case number 5. Description of invention (13) Arbitrarily select a variety of various data field states. The conditional expressions of the provided bits must be the same or different types of query; it is also based on the user ’s query. Symbols where more than one condition is in two or more single query conditional expressions and more than one compound query conditional expression, and before and after the combination, the same or more special users can make arbitrary expressions. By using parentheses π (more than one After being single, or added to a fixed number of single arbitrary permutation groups, the combination of the query conditional expression method of the present invention is lost: more than two data objects (data blocks) to be queried, with =! :: value; The value of the conditions in the block will automatically be based on two or more single query conditions to be queried, which is 2 ^ into the second user's query of the item list-query condition (column is not The comparison query element and the limited query condition in the field are equal to the bit and the ratio = the row-to-item-query condition is compounded.

Page 17 1221234 V. Description of the invention (14) 90126102

In order to achieve the brain microprocessor method, the main purpose of which includes selecting the data to be selected in the query conditions for selection, formula setting, starting the conditional operands, according to the query condition system, and the generation of a single query After that, the query conditional expression is convenient for the user to achieve the above purpose. The electronic device should include the preset timing of the query and provide results, and then enter the query system of the data object and the data shelf and automatically display the combination. Receive the final expression of the user to add flexibility. The design of logical conditional expressions can be added at any time, and it can also be used again in the future. The present invention provides an overview of the use of query condition settings and stores condition values that are selected by users to compare their data types to show each single The user can select the desired query combination, and there is no query operand available, which can be entered in one. And it is stored to electricity. Reveals a complete set of beneficial assets and conditions. The two query conditions are stored in the system. It is significantly different to complete the query conditions of each single query condition selection and select the query condition. The user selects more than one. Compound, when the user's brain storage medium is used in the second part with the electric material inquiry side; the second part. First, the system will select a query condition based on the comparison operator in the selection of the query block. Secondly, the open type and logic take the limit of the number of single or multiple entries; and each of the above query conditional formulas determines the final file, [Detailed description of the invention] Chu Yi You Guan Yi Figure is the query operation of the embodiment of the present invention The schematic diagram of the process, the details of the invention, and the technology are described below in conjunction with the diagram: First, the query condition setting starts 20, and the user &quot; the data object (field) to be queried enters at least two groups and the corresponding fields Comparison freight rate-vW 豕 I 佴), and the ratio corresponding to this position-t query condition value, that is, enter at least two single queries

Page 18 Japanese Case No. 90126102 V. Description of the invention (15) Conditional expression 21. The “person,” after the user turns in each single 杳, you, ^ query object, comparison operand, and query ^ conditional expressions "the query object, comparison, value of the input has been entered, the system will automatically Each and every single 2 ff after the combination is completed, and the condition values are combined to the relationship of the original desired query conditions. Let the &amp; person, = formula 22, and then, according to the combined single or composite query file & At least two or more elements, And, or ,, 0r ”New 24;, and then press the logical operation selected by logical operation to add New $ ::: selected query condition and conditional expression 25, and use The symbol &quot; (, is generated and displayed as a -complex query, and then judges the-compound) 杳 encloses the 5 Hai-compound conditional expression. Query conditional expression 26, if the required maximum === is equal to the required maximum = piece setting 28; if in step then the G conditional expression has not yet been generated, only the final check required by the user is new. Is the final query condition required for query condition 2 missing? At step 27, if the determinant is used, continue to the previous step. "Enter a new query condition query with a single-query condition.) Select to> two or more To select as a combination), and then press: a: the piece or compound query condition is the query condition and selection of Minamachi; after r, the system will judge the selected ⑼; the ：: compound search condition Equation 25, and repeating the above-mentioned one-step query conditional step 27 again, if the user needs to enter a new single conditional expression), and X Α, then return to step 21 (that is, enter a new single query element, and The query condition estimation system automatically turns the query objects that have been rotated, the comparison operation ^ 1, and combines them to show the individual queries after the combination f. Page 19 I22l234

Case No. 90126102 V. Description of the invention (16) ^ After conditional expression 22, continue to return to the previous step 9q, 9 pieces and combinations to generate and display conditional expressions i, 25 (that is, the person who selects the article and repeats the determination of step 26 above) Operation. Qiaoyi, 'Finally, if you repeat the above step 27 and then return to step +26 to determine the step 26, the step 25 that produced the most cooking =, and the setting 28 for ending the query condition. When querying the conditional expression, that is, the user does not need to know the code stored in the computer, but directly uses the two: the title of each data field to select the data to be searched. "Supplier code", "Sell = (the amount of the second block of the system will automatically select the user directly, no two: f if: the title of the block, let you enter after checking the table) the information of these block of data ^ TM嶋, SUP⑽ or TM_ This system will judge each data block ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ = If the type is numeric or date type, it will be more convenient; Yuan &quot;:, &quot; = ( Equal to "", &quot;> (greater than) &quot;, &quot; (less than ", two or two H, two &lt; = ( t is equal to) &quot; 'If it is a date type, it also includes mentioning λ or no = yy ending with? &quot;: Body type, such as 5 choices for the Bollinger type value 疋, yes &quot; Menu type "(that is, the system provides a plurality of query conditions for comparison operators" 笑 ", and. The system is based on ΙΙΗΙ data; and off: η image (block), determine its data type, and display This data type is different from #. The operation is different. The system determines the input data field's value. ^^ 1 ± ^ The input conditions of the query condition value display different input types.

Page 20

I Ϊ221234 Case No. 90126102 V. Description of the invention (16) After L__ conditional expression 22, continue to the previous step 2 ^ 24 The condition and combination generate and display the conditional expression 25 (that is, the person who selects the condition and repeats the previous step) The judgment operation of 26., ^ ^, finally, if the judgment operation which is returned by repeating the above step 27 and then returns to the 5th time: End the setting of the query conditional expression 28. When a coincidence conditional expression is used, The user does not need to know the code stored in the computer database, but directly selects the data pair to be queried based on the title of each user ’s location. ^ The identified data location can be directly selected by the user, without having to check. (Enter after the table) The data booth of these data stops · TTM0003, SUPCOD or TM0009, SALAMT, etc.). (The system also judges the data type of each data field. If the data type in the basin is a numeric value or a date type, you will be provided with u 4), and &lt; = (less than or equal to), if it is a date type State, more inclusive for now? "Day" and "Before?" If the type of the comparison operator is a character type, the comparison operators "off", "=,", "including J," begins with? ", And" ends with? "Are provided. · If the data type is a Bollinger type (yes or no) or a "menu type" (that is, a menu of a plurality of query condition values provided by the system), a comparison operator is provided, total, and, , = ,,. The system determines the data type according to the input data object (block) and displays the comparison operator of the data type. The system determines the data type of the input data block and displays a different input type in the block of the input query condition value. Page 20 1221234 Case No. 9012fi1D9 V. Description of the invention (17) State, where if the data type Is a numeric value, a treasure: state, and the selected comparison operator is ": 70 center, or a date type", the system displays a blank block that can control the previous date or the character; if the data type is- 'Condition value is not limited to numerical operands, before the material? The second type is selected and the selected comparison shows that one will control the input, and the second one is U'. "" The system appears as &quot; // Hi conditions are limited to date format Field, for example, the right negative type is Bollinger type or "menu type center", the system will read the menu of the data block and display in the input as "Is there a minimum amount; ί! The selected query data block will be discarded. In the field where the query condition value is entered, there will be 4 and "2" options for selection. For example, the selected query data block $ "currency type", Enter the value of the query condition in this field: a correction bit will be displayed "The options of menu types such as New Taiwan Dollar are available for selection. The formula &amp; for generating a single query condition formula provided by the present invention increases the flexibility and convenience of the user to set the required query conditions, so that the user can generate unlimited Single-query conditional expression, and the system automatically reads and displays the title of the data shelf for selection of the query object, and the system determines its different data types and gives appropriate and diverse comparison operators, allowing the user's The setting of the data bit title and the comparison operator are more in line with the query conditions to be queried, so as to improve the limitation of the number and ratio of query conditions in the conventional query system. Bit headings or logical operator parts (and, or, etc.) can be used to indicate the country of the user, to help users understand the meaning more easily. For example, Chinese characters

J USD USD Yuan Factory Euro

IHHI P.21 1221234 Case No. 90126102

5. The user of the invention description (18) will replace "and" with ",", and "or" the unit price of the goods sold, that is, the "unit price" to replace the US envoy "&quot; Selling Price ". Then the system receives the selected user logic operands and combines them and displays them as a compound query_ ° conditional expression and the selected query conditional formula is combined into another compound query ^ 2 == when it is combined Continue to display, and can continue to be the selected query condition, = will still continue to other compound query conditions. And the compound query bar = ^ combined to produce more than a single query condition, at least two to 丄= I consists of at least two formulas, or at least-more than a single query bar = query, a compound query conditional condition, and the logical operator "and / / more than one combination. Each combination produces a compound query condition" 5 〇r "" (")" To enclose, and produce the best recipe in \ 糸, first automatically through the query method provided by the present invention, ", can check the conditions . The required query conditional expression, and the user: = Generation-final structure, the code (code) of the data block, and :: :: or: Disassociate the database position, or each computer operation form or = 中= Query pairs that match the query conditions required by the material bar; Shaking: =: 'Select the data type of the 1 object and display it appropriately = ie, the search conditions can also be mentioned according to the present invention; 珣 conditions. Furthermore, these queries or "Or" perform ^, methods, and logical operators "And" w "xe 仃 various combinations to produce" "rules, and also do not require: title,-typing to enter

P. 22 style. Then use a pointing device such as a mouse or light; 2 What is required: query conditions When the required query condition is required, and specifically click to generate the final result

Case No. 9012610? 5. Description of the invention (19). The query system of the present invention improves the query condition expression of the query, and becomes quite easy. , Precision, and compound generation Clear any: produce t 3 of ^ ί: In addition to the necessary steps, if the user wants to remove / = the earlier one generated or the query conditions are combined, they can press &quot; delete,. In addition, the user completes the final 杳% ^ ^ query action. The final query condition formula performs the formula information and displays any one of the compound or single-query questions of the query condition of the query result. The “&button; button” has been set to save this query condition, so that you can enter the query system of the present invention, and you can directly retrieve the query condition that is stored = μ $ condition Update = fm 'without having to re-enter the query bar: see, the second one of the picture' is the computer function of the query method of the present invention = brain (1 client = 脑 (CHent C — :: 电 细 ( S03) contains at least the memory Λ ?. The server computer (s〇5) contains at least the record t (S06) X &quot; Λ '

The nature of the data Ύ Λ other mother and child data table (S07) to store different ι ϋ query system interface (s〇i) contains condition settings --1_ 月 agger ’to allow users to set a single query condition; condition combination

Case No. 90126102 V. Description of the invention (20) (S 0 1 2) function to combine each single query bar and compound query condition; quick preview (S013) = two logical operations to combine results and common query (S014) function In order to display data retrieval and display the relevant programming language to perform the query condition of ^, when a computer is operating, 'the user will query the data in the condition to compare the comparison elements for (S 0 1 2) The function, formula, system and according to the library's data table, (S 0 1 3) function. Store it. When you save the functional part of (S014) next time, you can directly call the query system interface (s〇i) set (SOU) function (SOU) function in the search form (S02). According to the different data types, the appropriate user setting order-conditions are displayed. In the combination of conditions, the user can combine the query conditions that he eventually needs-the query conditions that he finally needs, and retrieve the matching data from the relevant data And it is displayed that when the user can quickly perform the same query condition for a query condition that is finally required, the user can directly select the updated data in the outbound database for the query in common use. In the following, several preferred embodiments of the present invention are used to illustrate the functions and features of the present invention. Explanation of the first embodiment: Take a member database query system of a society as an example, and the sixth to seventeenth diagrams are the system of the present invention. The screen shots of the interface illustrate the methods and steps of using the inquiry system of the present invention. The &amp; $ community wants to hold a small networking event for members and select

Page 24 1221234 No. 9Q1i? Fnn9 Amendment V. Description of Invention (21) ------------------------ Members with the following conditions are required to join this union丄 &丄; w ^ The qualifications and conditions for participating in the activity are as follows. If it is a male club, the age must be 3 = If it is a female member, then the age must be 25 years or older:: Under college degree. Only members who meet the above conditions can participate in the She Changbang ί ί Friendship event members should have the conditions required, then they can enter the Beibei negative material storage system and press the "Query" button to check the system-conditions The "day" of "setting" is shown in Fig. 6. According to the inquiry system of the present invention, users can inquire the member information that can join this friendship event according to the qualifications and conditions of the members to participate in the activity. In the interface, the user can select and enter the following query condition values according to participating membership, and the system will read each data block stored in the computer's member database and display the title of each data block in the query block 6- 1 for selection: Condition 1 · Query stop 6 — 1 is “sex”; comparison condition 6 — 2 is “equal to”; query condition value 6-3 is “male”. The selected "gender" query object is the menu data type, so the system will display "equal to" and "not equal to", two types of operands in the comparison conditions 6-2 field, and the query condition value In the 6-3 column, two options, "male" and "female", are available for selection. Condition 2: The query stop is "age"; the comparison condition is, greater than; and the query condition value is π 3 Οπ. The selected "age" query object is a numeric data type, so in the comparison condition 6-2, the system will display 11 levels "," = "" "" "> =", and "<=", etc. Operand for selection 'and displays an inputable age value in the query condition value field 6-3

Page 25 1221234 Case No. 90126102 Amendment V. Blank field of invention description (22). The comparison condition is "equal!" The comparison condition is "greater than", ^ condition 3: the query field is "sex" and the value is ff female. Condition 4: The query stop is "age" and the value is π 25 ". Condition 5 ·· The query field is" degree, "and the comparison condition is" equal to, · The value is π university ". The selected "educational" query pair is in the form of ten months, so in the comparison condition 6_2, the system will predate the data equal to &quot; two operands, and it will stop at the query condition value 6-3. -With "Not in" &"; College, |," University "," Institute "and other options: select it for the display, 'high check box 6-5 will automatically check each input For query conditions, the user can uncheck the input query conditions without entering the entry to make it work. The system accepts the combination of the user ’s stage, newcomer, and force β / down to automatically switch to 杳 xuan / gu After the instruction of t4, as shown in the query diagram), the cook's noodles (such as the first + output system): (this invention is called "conditional storage area, a output system automatically combines the output The five items of the single inquiry bar "8, and the search conditions are the gold form for the system to switch to the condition- ^ bar. The combination of the" command combination of the button "is composed of the display values of the inquiry shelf ["). Face ^ 口 _, face, you can also directly click the "quotation." 糸, washing will show the currently received orders-query Under the conditions of &quot; And: button 7: 3 ,: f: condition &quot; 2, '7 ~ 2 two conditions, and a table showing the combination of day and time according to the eighth and eighth charge conditions shown in Figure 8_i The Chinese condition is "gender equals male sex", and the internal "content" system automatically groups the selected query operators "and" to "generate with the selected logical operation." Query the conditional expression on page 26 1 ^ 90126102 V. Description of the invention (23) Day _ Amend "(Gender is equal to male and age-type storage area, 1 is greater than 30)" and display it in "Selection of conditional selection I" The conditional expression still exists. K takes the condition “3 丨 丨 8 —2 and Ding you down” and, button 8 ~ 4, “，” 牛 4 8 one 3 two conditions, and as shown in the ninth figure 9- "Information," internal: condition combination "in the table on the screen will display the conditional expression" Sex * # 2. "The system will automatically select the selected query operator" and the age is greater than 25 "and the selected logic operation" ( Gender and other women are displayed in a compound query conditional expression storage area "ΛϊΛ 5)" and displayed in "The conditional expression selected by the condition source still exists. Next" or:. ,,, &quot; And conditions ... and 4)% !; such as the data content of the tenth; "two = hardened conditions" and then the selected logic will automatically select the selected one-an age greater than 25) or (sex ^ H ((Gender is equal to female and 30)) ". ^ Fei Wsheng specializes in males and is older than and press;, take: Ί (1 and 2) or (3 and 4)), '10-1 and conditions ,, 5 ,, &quot; -2, that is: If the query conditions &lt; "(((Gender. H \ Rong. The compound search shown is equal to 4 and female and the age is greater than 25) or (sexual is / The cooking man is older than 30)) and his education is equal to the university) "is the final query condition. If you perform the i rough preview button 11 3, the system will search for the final query condition formula: η 'from the relevant database to find the matching final ^^^ news' and click "Quick Preview" 1M of the day? Critical review MW _________________ * --- Page 27 1221234 Amend the _ ^ number 901261 (1 ?. V. Description of the invention (24) The query results are displayed. The messenger is displayed in the twelfth picture of the quick preview screen Conditions for querying 丨 2 — 1 and query result data 丨 2 — 2. The user must use this query result. If you want to leave the query system at this time, ΐ, last name Γ1 / 2-3, if you press "Use", button 12-4, then use this check = ,,, Q results, that is, the system will automatically store in the computer memory media = query results are directly related to each detailed bit of data, start the computer operation of this query system The form is used. Good, .... Start two users can press the "Save" button 丨 2_5 to start the file storage day (the first ~, and enter the file name 13-3 in it, and press the "OK" button 13 -1 can store this query condition in the file. 1) This selection makes Γ in &quot; search System 1 uses the query, to directly name the condition 14-1, and sees the query condition combination 14 in the daytime. I delete this query condition 14_3, preview 14 ~ · 4, adopt ^ 14 — 5 and give up 14 -6 and other operations. See the 4 method of querying to generate the final search condition 4 search, although the action selected by the user is required to produce &amp; The query type "such as degree; if it is a girl J :; 3 ° or older, and the academic degree needs to be a college degree or a college degree." It can be simply added according to the query formula !: The m method produces five single-conditional query condition unions, and the self-use—: if-produced &quot; simple and easy-to-understand &quot; query bar 21221234

• V

Amend _Case No. 90126102 V. Explanation of the invention (25) and use the generated dynamic query code to retrieve the required information in the database ’, which has the effect of repeated reproduction. Through the query method of the present invention, a user interface is provided, which can accurately generate the final query condition formula. The system retrieves the matching information according to this final query condition formula. The user does not need to After carrying out a single query operation for many times, the user can manually or manually write a program to sort out the query data that meets his real needs. The user does not need to understand the structure of the database in the system or the code of the data block. (Code) and data type, the relationship between each data field, or the fields and structures contained in each computer operation form or database, and use specific programming languages or syntax to perform the query action of compound query conditions . Therefore, the method of the query system of the present invention significantly improves the accuracy of the query and makes it easy to generate a compound query condition. The description of the second embodiment: The storage method of the "conditional storage area" described in the first embodiment can also be used to store the search conditional expressions of different properties using the "source area" and "target area", which is explained in the second embodiment. The differences. After the user completes the single-query condition input, press the "Group 2" button 6-4, the query system will automatically switch to, 杳 condition group

The daytime surface, as shown in the fifteenth figure, is the source area in the table; "1 5-1 'cannot be displayed according to the query fields, comparison conditions, and query condition values entered by the user. The five-item list formed by the query condition. i take the terms of the item and press the "&" button 15- 丄 厶:) 4 丄 厶:) 4

15-2 ^ ^ System-condition combination, the table below the day is the "target area" 2 and the data content as shown in Figure 16 is displayed. ^^ 90126102 V. Description of the invention (26) 3, &quot; ^ ^ ^ pieces "3 '' and conditions '' 4" two conditions, and press, and, button 15, a dry system i ----- The combination of conditions, the table "target area" below the daytime surface cannot sing the data content as shown in Figure 17. 6 ,,, Ϊ ^ ^ pieces '丨 2 "and conditions" 3 and 4 ,, and press ,, move up, button 15 a data ^ 1 system-a condition combination', the table below the screen "target area ". Said back to the above form "source area", as shown in the eighteenth figure data 15, -4, choose the conditions: (1 and 2) "and conditions ·, (3 and 4) Π, and press, Or, the button will show the two systems-conditional combination "table" target area "P below the day and time, the members do not show the data content as shown in Figure 19. 15 6 choices, choose the conditions "((1 and 2) or (3 and 4)), and press, move up one of the" New 15-2 ": ^ charge one-condition combination, day The table "Target Area" below will first return to the above table "Source Area" 15-1, as shown in the data content of Figure 10 above. Down "and select 3 ((1 and 2) or (3 and 4))" and conditions "5", and press "2 15-3 Query System—Conditions and Combinations" The form below the screen is private. " The data content shown in Figure 21 is displayed. If you want to do this, the query system will not show the user's desired query conditions in the quick preview screen. ★ — · 1221234

Day 2 Amended the special method of Rensi arrangement before and after. In this query condition "(((1 and 2) or (3 and 4)) and 5)", "J and 2" is a combination of two single query conditions, so in the query condition ,,, ( The combination of i and 2) ,, illustrates that the present invention can automatically add the bracket symbol &quot; (), before and after two or more single query condition expressions; and the query condition "(1 and 2)" is composed of two A compound query condition composed of a single condition. In addition, the combination of ((1 and ^ or y 3 and 4)) "illustrates that the present invention can automatically add the bracket character 旎 '() &quot; before and after two or more compound query condition expressions; and query conditions, &quot; ((1 and 2) or (3 and 4)) and 5 "," ((1 and 2) or (3 and ^) "π is two or more compound query conditions, and" 5 "is ^ ^^ (((1jl2) ^ (3x4)) ^ 5) · ^ ^ Λ Λ. Move the brackets &quot; () &quot; arbitrarily before and after more than one list— 杳 more than one compound query condition. Among them, Enclosing query conditional expressions with a bracket $ symbol "()", in addition to letting users understand the combined structure of query conditions at a glance, the system will generate parentheses before and after any number of conditionals. The original multiple conditional expressions can be combined: ί ί required conditional expressions, 1 system only needs to follow this-the final conditional expression, and can immediately retrieve the information the user needs, without ίϊ: The user executes multiple query instructions, and then filters and compares the results by other people to write their own programming languages. Example 3 illustrates: Another preferred embodiment of M A t &amp;

1221234 fix

Case No. 90126102 %%]: Pd: V V. Invention Description (28) — f Factory startup method in computer operation form for sales order entry. The user (starts) the inquiry function of the present invention in the computer operation form of the "lock sale order input", please refer to + _ ^ to show the "inquiry system of the present invention-condition combination" ::] Book: Uniform :: When using the computer operation form,-two b ~ use step check words, in the query system of the present invention, directly select the title of the field to be negative, without the need to renew and supplement Feng The prefecture will show you if you are forgiven by using the == or understand the burning of each data block in advance. If the computer operation form passes this query system :: household ": 纟 query block", the data block (title) must be at least one hundred yards, and it is not necessary to memorize the title or generation of each data block. Top: You need to know the structure, query and query of these data blocks in advance> "The data block titles that are not displayed in the system, except for the data in the parent data form of the" sales order dual entry, electricity month &amp; operation form " Bit (data, and other data included in the computer operation form, other = data sheet sub-data table for each data slot to choose from, and expand ^ = search range: please refer to Figure 24, The system also displays ^ ^ fields in the sub-data table such as platooning are available for selection. ^ Figure 15. If the selected query object is "total sales net," the system automatically determines that its data type is numeric. "State" in the "Compare i ,, pieces" field displays &quot; equal to &quot;, "not equal to ,,,, greater than ,,,, small T ,: greater than or equal to", "less than or equal to," etc. Compare operands for selection, query condition value " The automatic control in the position can only accept and display the input of numerical values. If the selected query object is "Order Date", the system automatically determines that the data type is the date type. Compare

m p. 321221234 i No. 9019… (ίο V. Description of the invention (29) / Jfr / jtL »〇n A l one by one one by one condition" Stop in the middle of + ,, Rong + person &quot; Yu &quot; ,,, specializing in, &quot; not equal to &quot;, &quot; greater than &quot;, specializing in greater than, ', "f W ^ is less than or equal to, f," before? Correct the small front within the day? Yue Wai 丨 丨Wait for comparison-& jinbei • mouth Π, distance display shows &quot; / 运 异 7 ^ for selection, and enter the format in the "query condition value" period. The format and automatic control can only accept the date If the selected query object is "payer", it will automatically determine that the data type is character type, then the "杳; condition letter "? Ending" and other comparison operators are available for selection, and in the ^ Check money value "block, you can only accept and display" Yuan "^ Figure 18, if the selected query needle is in" 六和 敝 " Do n’t, the system automatically judges that its asset is the second condition of the parent ’s condition, and “Equal to &quot;, &quot; ^ ,, &quot;, Zaosheng ~, is displayed in the" Compare Take, and in "Query condition value, not equal to: comparison operator for currency selection", "US dollar", "Euro, I" "I show the options for the query object 丨 new Taiwan, central pounds ,, , Π yen ", etc. to choose from. If the location of the user's request is Taipei or Hsinchu, and G, the item is" sales order within the last three months ", the net amount in the present invention is greater than 10,000 ", And not cancelled cancellation" computer function 1f query system of a query method in the day and time-a condition set to enter each order _ query conditions (see below). The 29th figure is the setting condition Γ 1221234 case number 90126102

Amendment V. Explanation of the invention (30) Computer screen diagram; Figure 30 is the computer screen of the set condition "Sales diagram; area equals Taipei". The third picture is the diagram of the setting condition "Miscellaneous warehouse surface; the sale area is equal to The thirty-second picture of electricity in Hsinchu is the schematic diagram of the "brain screen; the status of the electricity sale order with the total net sales greater than 1 0 0 0 0" is not equal to the cancellation of the order. Day and night have no intention. After completing the setting of the single search condition & two items entered by the above unit, the system will automatically combine the search conditions, comparison operands, and formulas with the search condition values, please refer to the thirtieth The four query conditions are completed. / 、 Display a single query completed by 5 combinations, "Jie please 考 test the thirty-fifth figure 'selection conditions" 2 "and condition II 3", 廿 &gt; or "press sister, thirty-sixth figure g 5 _ ， and Know: the following conditional expression and the selected logical operation = the system will not automatically combine the selected query with the query conditional expression "(2 two, generated and displayed as -duplicate" (2 or 3) &quot;, "&quot; , &Quot; 4 &quot;, &quot;, test, and number: ten "seven graphs, select bar thirty-eight graphs to show that the system will automatically know and know the" button "logical operators to generate and query conditional expressions With the selected formula &quot; ((2 or 3) and i and 4 and I7: a compound query condition equal to Taipei or sales area equal to ^

The query conditional expression on page 34 is “below” and 1 is displayed. ^ —The final check is required. 1221234 Any sale of Gangan-Mtfe flni9Rlf) 05. Description of the invention (31) Within 90 days and the total net sales amount is cancelled on order) ". Press the final query condition formula to perform the query code. The information from the relevant condition formula is displayed as data using the query method of the present invention. The query object in the data in this screen = the number of matching data is 53 Single status "," Single area of each data value, and you can click the order of increasing or decreasing. The amendment and the status of the sales order are not equal to the button, the system will formulate the final query according to the query condition, please refer to the reference Figure 39 shows the number of data items that meet the final query conditions and the title bar of each query object that meets the query results of the preferred embodiment in the preferred embodiment. = The query conditions are stored, then the book with the storage name is used: Save button, the system will display the inquiry process] Alias #, and the system has automatically restored the production code error in the computer storage In the media for future use, if you press the "Adopt" button, it is the condition information. Please refer to the forty-first chart [^ not all the sales order information that meets the query, and you can press "front", "4 ^ &lt; the information requested by the second child's query conditions. One-person pen "and other buttons to browse the inspection 1221234

No. 1 9Πΐ9 (ηη9 V. Description of the invention (32) The user uses the stored query conditional expressions directly for the commonly used query conditional expressions, must work, ring, ν * &amp; Xia Fujin 仃 condition setting, I retrieved directly Information that meets the query condition. Step package = 2 ^^, the functional signal of the stored query condition; the identification name of the input query condition type η: the function signal of the query result; and the system shows The code will go to the inspection center. The search process of the conditional search retrieves and displays all the data that meets the conditions. Chromium &amp; Day & amp. Please refer to the "Rolling Item" and the cumulative order of the calculations. Please click on the query conditions and display the electronic reference of the query system in the 42nd figure. 'The stored query bar is displayed, and you can click any one to refer to the 40th. The three pictures of the query conditional formula are deleted; press "to show the matching information; the conditional brainstorming form of each resource. 'Enter the query condition of this issue will be listed in the latest title column, if you want to delete And press the "Delete Preview" button and press the "Use query details name in Qiming's" Query-type name, and use the daily data to increment and save the check "button, and the" System goes in "button. Development system-commonly used systems with record periods and query conditions that use times or decreasing, can be used to display the query system of the search line to indicate that the query is to increase the convenience of personalized query. The eclipse used will always be set at the same time § I set the user name of your style, and our door ^

P.36 This query system stores a query bar: ^ Picture 44 ’to other people # ®. $ Ask whether the conditional expression is publicly used. A remote user logs in to the telephone again ------- J € Detailed execution of the query system 1222234 1221234 _1 No. 9012fi1 V. Description of the invention (33) Amended 丨 丨 —I · — \ I _: query "System-Frequently Used Query" t, J Kao Tong will select and display the search bar whose user name is stored for public use by other users. Twenty = its search conditions' Identified by any user: m Take the-query conditional. In order to facilitate the personalization of the search, through the description of the preferred embodiment, users who do not have knowledge of the database system in the present invention can also make information. You can quickly and accurately obtain the query. Therefore, in the query method of the present invention, the system reads * each computer as an example, and the second is a computer operation form. Mind = two votes, the benefits have been fixed. If you want to achieve the logical position of each block, comparison operators, logical operations = for designing multiple reports in the query data block computer operation form, you need to With the same stoppage and logical conditions, adding the "possible combination of" including specific query bits "-cut query stop: included in the industry table earlier, and the query method of the present invention,-have the same query in any item The interface structure and the operation table soap are provided for users to select and combine. Users can read different data blocks greatly improved, and can be minimized: two uses: ease and flexibility are both efficient and non-existent. Page 37 of the Limit 1221234

Field query combination! The fourth embodiment of the query method of the present invention is shown in the description of the fourth embodiment: Please refer to Figures 46 to 48. After the combination of check Π = ΐ, the system can still allow users to swallow it early. Check the written conditional formula of φbismuth ^ ^, go down, and go to M ^ = add the previous query conditional setting. Is 4 test 19th figure, the result of the query has a block containing the amount, and The total amount of each data will be added up and displayed. The technical feature of the present invention is to provide general users, who can query the conditions according to what is directly expected, and use the present invention to select multiple data blocks and set the conditions of 疋 ', person and 珣. Between the conditions and conditions, The user selects 2 combination relationships according to his needs to generate the final data query conditions, so that he can use ^ to search for the required data with the least number of searches. The connection relationship between special conditions is quite complicated. With the method of the present invention, the user does not need to disassemble or analyze the required data query4 in advance, but can directly combine the query conditions to generate The final query condition. The fifth embodiment illustrates the difference between the present invention and the conventional system such as the "query form" function of A c c e s s, which solves the following three limitations, and also uses the same three file types for comparison.

1221234

(1) General users can use the data query method of the present invention. General users do not need to have technical knowledge of any database.: 疋 Know and remember in advance which data table each query field corresponds to: The field K is directly selected and set according to the required query conditions, which can better meet the application of general users with non-technical background. = "(Male and unmarried and birthday &gt; 1 960/1/1) or (female and un_ 〇 ^ & Ϊ1 &gt; Η70 / 1/1)" for example, please refer to the 50th bathroom 4 When you set the query conditions, you don't need to know or memorize in advance. Ί The name of the relevant data table and the data fields in the database. Select the query stop and compare conditions according to the required query conditions. can. The fifty-first picture is a schematic diagram of the query conditions of "(male and non-L person"; 1 960/1/1) ", the fifty-second picture of the second female J student t is unmarried and has a birthday> 1970 / 1/1) "query bar" # ", the fifty-second figure is the above two query conditions with $ and) = &amp; 'and produces" (male and not 1970 / 1 / η 6 # 〇 / 1/1) or (female and unmarried and birthday> ACcesSh i. The final query condition. Compare the conventional technology (such as = month: can intuitively display the query condition formula combined by the user, The general users of the office can directly use the invention of this case to: combine training or understand the structure of the database.

Page 39 ^ 21234

(!) Syrian users can quickly and easily set data search conditions without disassembling and analyzing their search conditions in advance: __Case No. 901261⑽ V. Description of the invention (36) έ $ 以 查 珣 condition "((Male and unmarried And birthday &gt; 1 9 6 0/1/1) 1 and female red sex / ancient unmarried and birthday &gt; 1 970/1/1)) and (highest education = inquiry; 円 education = master's) "as an example, The present invention does not require the dismantling of foreign investigations. Compared with the query conditions in the previous example, the difference is that the calendar = university) and (the highest degree ... the two investigations add two more: 十: Figure 学 learns in the condition setting screen separately), (the highest degree ί V scholar) is (the highest degree = Dalai. Fifth + 1 country-staff) 14 two query conditions are combined with "or" Master's degree and ((Male \ figure will be (highest degree = university or highest degree = and unmarried and ί and unmarried with birthday &gt; 196〇 / 1/1) or (check required by female users; 7 二 / 1) 2:: "and" combined to produce the ^ D ox style of the conventional technology, Jing refer to Figure 58. Compare the formula of the invention of this case, go ^: Figure and the fifth of the invention of this case The difference between the eighteen pictures, the understanding of the query conditional expression === The piece type is more in line with the user's query of the system. For the conditions, as long as each condition is selected according to its needs: (3) There is no combination of four query systems. Method: 1 960/1 / υ ^ Jing condition, "((male and not ---- 3 (female and unmarried and · married and birthday> birthday &gt; 1 970/1/1)) and

Page 40 for this 杳% 1ZJ4 1ZJ4 Ά 90128109 V. Description of the invention (37) a amendment ((highest degree = university or and (blood type = 0 type cloth 1 pre-degree = master)) or (live in Taipei 59th picture , Κ needs or == ")))", the present invention, please refer to the bit, comparison conditions, and query place 'select each query bar query condition to each query bar two: after the value, then, according to the original query It is not necessary to know the combination of the database surname broadcast $ t "or" or "in advance, and it is not necessary to disassemble the corresponding field names in the original mm database. Figure 63, which is the group" "::. Please refer to Figure 60th to = Master's degree) or (Second degree in Taipei; University * Highest degree type))) ", then blood" Male 0 type or blood type = A 1960/1/1) or (Female ^ Un :: sex and unmarried and birthday> points are combined using "and", and the second life: &gt; 1 970/1/1)) "query condition. Therefore, in the 64th test of this test, a unified "query form" can be generated (the combination of the conditions of the invention of "please /" is more familiar than the condition of the second and the fifth of the fourth in accordance with the conditions of the inquiry) Easy and fast, as long as the user can combine them. And the general memory of the data structure and database: 旬 conditions need to understand or conditions. In the case of search, it is not necessary to disassemble the article. Therefore, if the user according to the present invention knows this article, he can use this link = two, no, generally do not have the database information, and do not need to know the data Ku Ergogo H: 2 The combined query method of the desired query system: Because: 2 is being provided to the general user infinitely so 'the technical characteristics of the present invention are already more familiar 1222234

Amendment No. 90126102 V. Description of the invention (38) The technology is highly advanced, not for those who are familiar with Access 4Dbase nj P ^ us or the query interface on the general global network (www) or enterprise information application software , Can easily infer the improvement method of the data query system in this case. [The effect of the invention provides a better query system, that is, the condition of the material used on the query surface of the query system is unclear, that is, the query developed based on the lack of the system. To achieve the same query system, query the system: All the data strip systems take into account both the diversification and the functions, and increase the goals. It is said that the number of query files is more than the use. Each needs to have a unique ontology, which is superior to the user, and achieves the system's multi-functional framework, and the satisfaction of the innovative prior technology. The goal is to transform and develop. The ability to inquire is not just about invention. The degree of technical independence is a necessary condition, which is targeted at the current market. Because of the current market barriers and capital, Ben Fazen currently has the following advantages according to the present invention. The data query pair provided: the item (= bit is broader than the current market system, users cannot meet their final needs) is a fixed query data object. In order to improve this method, it is necessary to provide the user with the query method of the present invention according to the most original place, that is, to provide the user with no restrictions on the data block: Two options # "data Railing

Page 1212234

No. 90126102__year / I V. Description of the invention (39) f ____ (2) The query system for the purpose of achieving the "data condition" query diversification is for the user's data query bar I. Because currently only a limited number of logical operators are available on the market. Although there are a few '$' part of the system logic operands, in terms of logical operands, for a set of conditional expressions that are not complete, the query method is ^ /, the same or the same order, In order, andn, n orn, "n0tn, this ^^ has a certain priority material conditions" query the goal of diversification. The so-called "material = two to achieve" capitalization, that is, the user for the same or different resources "query multiple people -r * strips between the stomach material shelves &gt;, hundred, you can do any logical arrangement Query v, query condition. In order to achieve this goal, the data conditions of the search combination required by this issue = 2 are selected, and the system will use: () &quot; plus the first, it can also be based on the user's final search sequence of 7 ^ combination, this Part of the === combination order of the present invention, this part is one of the features of the present invention. You Wu (It is expected that the other most important originality is in terms of the object of the sentence, and it is used for the best use of this station. 4 JL Μ% rain t. The user will not limit the number of stops. The selection is based on the query condition formula finally required by 2f students to perform a one-time search for filial piety. In the present invention, the data type Neng Xingmen 1 w check m 1 卞 system element supply, g pen She Hu Xin 1 The difference of the heart, such as the appropriate comparison operation two, 'select' helps the user to select the nature of the comparison condition. For different logical operations, the ampersand &quot; ㈠ &quot; is used to combine different two. 'Added the operator t I &gt; Μ + + a conditional expression, so as to provide suitable

From the user's more needs and professional tAA staff Hi, L IHg --- a ^ other / interesting search direction, to improve the user

Page 43 1221234 Case No. 90126102 V. Description of the invention (40) The goal of satisfying the privacy degree% year ’

St correction (4) According to the present invention, when a user enters a query condition, it can be taken at least through a drop-down menu (dropdown m — volume field), which provides a more convenient user interface, according to the needs of the user Scroll to $ to choose, to avoid the time spent by the manual keyboard to enter verbatim and the error caused by the user; and the error that may be caused by the input of the user. The title pair of the data block =: Γ ΐ or the structure and relevance of the database, and you can directly place the title to generate the required conditions. J Click the user to select the column "5.杳 ^ Conditions of query 乂 For each data field, you want to compare the operands. The data in the block: Be: The type provides different comparison operators, respectively. When it is a numeric or date type, provide a period type, including the quotation &quot; 〈~ and $ &quot;, if it is a comparison operation element before now? Within the day, and &quot; Before now? Day outside &quot; The two different &quot; &quot;, the data type is a character, which provides an operation If it is Brin (^ "^, beginning with? And" ending with? "; Multiple queries are provided in the data. 5 ge is &quot; menu type &quot; (that is, automatically and &quot; =" by the system. Warranty Value menu), which provides operands &quot;# &quot;, (6) The present invention provides a combination of flexibility and convenience in querying by the user according to one + &amp; Limit of the number of times; = Set the combination of logical operations, 1 without a field and-使用者 maximum for the user Page 44 1221234 Case No. 90126102 a- Amendment V. Description of the invention (41) (7) The present invention will query the user Conditions are recorded and archived, which is convenient for users to use again to increase the convenience of the system. (8) The query method of the present invention has the same search interface structure in any computer operation form, and the system automatically reads it; Total = Select and combine 1 Ease of use and information by the user, change the t = number of times to find the user's final required query combination: display;; = accuracy, operation efficiency and unlimited restrictions The advancement of the inquiry method of the present invention. System: ΐ: Comment 1 fully shows that the present invention uses computers to carry out data "industrial utilization price *" and is for the purpose; progressive, fully in line with the requirements of invention patents, new inventions not seen in the above, and finished, apply according to law. 70 &amp; However, the above is only the preferred embodiment of the present invention which is limited to this, and it is not to be prayed. An important member of the Ming Jian, and pray for approval, is wherever we go.

1221234 Case No. 90126102 丨 嗲 monthly recommendation 8> j Simple illustration of modified diagram [Simplified illustration of diagram] The first diagram is a schematic diagram of the data query operation process in conventional technology; the second diagram is the data query of the embodiment of the present invention Schematic diagram of the operation process; the second one is a computer function block diagram of the inquiry method of the present invention; the third diagram is a schematic diagram of the screen of the conventional technology inquiry system one; the fourth picture is the conventional technology inquiry system two Schematic diagram of the day and time of the screen; The fifth diagram is the diagram of the screen of the conventional technology inquiry system III; the fifth diagram is the diagram of the computer screen for selecting which data tables to display in the "query form" function of the knowledge system; The second figure is a schematic diagram of a computer screen for setting query conditions in the "query form" function of the knowledge system; the fifth third figure is a computer screen diagram of setting another query condition example in the "query form" function of the knowledge system; Figure 5-4 shows another query in the "Query Form" function of the learning system.

Page 46 1221234} * 〆 · ί ο, Λ ν; h case No. 90126102_: year month month 'amended _ schematic diagram of the computer day and time schematic illustration of query conditions; the sixth figure is the query conditions of the embodiment of the present invention The schematic diagram of the day and time of the screen is set. The seventh diagram is a schematic diagram of the screen of the query condition combination 1 of the first embodiment of the present invention; the eighth diagram is the screen of the query condition combination 2 of the first embodiment of the present invention is not intended, the ninth FIG. Is a schematic diagram of the screen of the query condition combination 3 of the first embodiment of the present invention; tenth diagram is a schematic diagram of the screen of the query condition combination 4 of the first embodiment of the present invention; the eleventh diagram is the first embodiment of the present invention. The screen of the query condition combination five is not intended, and the twelfth figure is a schematic diagram of the screen of the query result of the embodiment of the present invention; the thirteenth figure is the daytime screen of the screen of the result storage of the embodiment of the present invention

Page 47 1221234 This year / month jn Case No. 90126102_I year and month) Revised _ diagram is a simple explanatory diagram; The fourteenth diagram is a schematic diagram of the day and time of the screen loaded and stored in the embodiment of the present invention; the fifteenth diagram is A screen shot of a conditional combination of the second embodiment of the present invention; the sixteenth diagram is one of the data content results of the second embodiment of the present invention;

The seventeenth diagram is the second diagram of the data content results of the second embodiment of the present invention; the eighteenth diagram is the third diagram of the data content results of the second embodiment of the present invention; the nineteenth diagram is the second embodiment of the present invention. The fourth diagram of the data content result; the twenty diagram is the fifth diagram of the data content result in the second embodiment of the present invention; the twenty-first diagram is the sixth diagram of the data content result in the second embodiment of the present invention; the twenty-second FIG. Is a schematic diagram of a screen for starting a query function according to the third embodiment of the present invention; FIG.

Page 48 Brief Description of Schematic Forms

The screen of the title of the data block indicates the twentieth industry form: the five pictures are the schematic diagrams of the early screens selected by several of the third embodiment of the invention; the sales order is entered into the computer for the four pictures. Example of the invention = the data of the child data table "II if the screen title of the sales field title is not displayed; the comparison bar of the value data type is shown in Figure 26, which is the screen of the date document menu in the third embodiment of the present invention Schematic diagram of the day; comparison of material types; comparison of types; comparison of items in character data; Example 3 of menu data types; comparison of figures 9 through 33; Schematic diagram of the daytime screen of a single query condition; Figure 14 is a schematic diagram of the screen of a single query condition displayed in combination with the third embodiment of the present invention; Figures 15 to 38 are the implementation of the present invention Combination query of example three

Page 49 1221234 Case No. 90126102: Correction of the day and time diagram of the screen that simply explains the conditions for the correction of the "month gold" car in year i; the thirty-ninth figure is the screen shot of the query result display of the third embodiment of the present invention, which is not intended The fortieth picture is the screen shot of storing the query conditional expression according to the third embodiment of the present invention, and the forty-first picture is the intention screen showing the detailed information of the query result according to the third embodiment of the present invention. The forty-second figure is the day and time of the screen for performing common queries according to the third embodiment of the present invention. The forty-third figure is the day and time of the glory screen for deleting the stored query condition according to the third embodiment of the present invention. The forty-fourth to forty-fifth figures are schematic diagrams of the day and time screens of the personalized query condition storage according to the embodiment of the present invention; the forty-sixth figure is a screen shot of setting a single query condition according to the fourth embodiment of the present invention. Not intended, the forty-seventh figure is a screen shot of the combined query condition of the fourth embodiment of the present invention i

I Page 50 1221234 Case No. 90126102%, the month of the gallbladder is right and the sun, the revised diagram simply explains' · — ——— 一-· —-... It is not intended, the forty-eighth figure is an embodiment of the present invention The fourth is to increase the screen diagram of setting a single query condition; the forty-ninth diagram is a schematic diagram of the screen displaying the query results in the fourth embodiment of the present invention; the fiftyth diagram is to select each query in one embodiment of the present invention; Figures of computer screens; Figures 51 to 53 are a combination of one embodiment of the present invention, "(Male and unmarried and birthday &gt; 1960/1/1) or (Female and unmarried and birthday &gt; 1 970/1/1) "computer day and time schematic diagram of each step of the query conditions; Figure 54 is a combination of one embodiment of the invention of the present invention" (male and unmarried and birthday &gt; 1960/1 / 1) or (women and unmarried and birthday> 197 0/1/1) "computer screen diagram of the results of query conditions; Figures 55 to 57 are a combination of one embodiment of the invention Out of "((male and unmarried and birthday &gt; 1960/1/1) or (female and Students said marriage and &gt; 1 970/1/1)) and (the most highest degree or college educated = = Master) "computer day schematic surface of each step of the query terms;

Page 51 1221234 Case No. 90126102 / month a Modified diagram Brief description The fifty-eighth picture is a combination of one embodiment of the invention of the present invention, "((male and unmarried and birthday &gt; 1960/1/1) or ( Female and unmarried and born &gt; 1 970/1/1)) and (highest education = university or highest education = master's) query results of computer day and day diagrams; Figures 59 to 63 A combination of one embodiment of the invention of this case yields "((male and unmarried and birthday &gt; 1960/1/1) or (female and unmarried and birthday &gt; 1 9 70/1/1/1)) and ((highest degree = University or highest degree = Master) or (Living in Taipei and (blood type = 0 or blood type = type A))) computer screen diagram for each step of the query conditions; Figure 64 is an example of an embodiment of the invention A combination of "((male and unmarried and birthday &gt; 1960/1/1) or (female and unmarried and birthday &gt; 1 970/1/1/1)) and ((highest degree = university or highest degree = master) or (Living in Taipei and (blood type = 0 or blood type 2A)))) Computer schematic diagram of the results of the query conditions;

Page 52

Claims (1)

1221234 t A method for customizing the conditions of using the electronic device with a computer microprocessor to at least include the following steps: Dingbei Inquiry- * A1) The system repeatedly receives at least two sets of data for users. Cui: Inquiry object (g 卩 Be cautiously a. The hall selects and enters the T mound (that is, Bei's stop) , Comparison condition (that is, comparison operation I 疋), and query condition value; 1 operation difference (compared with S 笪 is to automatically query each group of query objects (block), comparison conditions (comparison operation difference 70) and query conditions The value is added, and the query condition is displayed; the system displays the group of people: 1 single search condition, and a mother-inquiry condition generated by the mouth; VII i prostitute, and take at least two displayed query conditions The formula “receives the logic of the selected input. The system will combine the query conditional expressions. The system will display the newly generated composite query conditional expressions. 1I 生 (4 ) If any of the compound query condition formulas combined and generated by the system are not placed in the final required query conditions, look for β △ 1; 1 formula, let the user select at least two displayed Query condition (single query condition or compound query condition Both can be selected) 'then receive the selected logical operand (_ or 〇〇, combine them and generate and display a new compound query condition; ⑸ repeat the foregoing item ㈣, until any compound The query conditional expression '4 is the final query conditional expression required. &Gt; 2. As the method of applying for the scope of the patent application, the step ⑷, including step 3, the system receives the input selected by the user, bits), comparison Condition (comparison operand) and query condition value ' 1221234 Case No. 90126102 6. The scope of the patent application L · 丨 is combined to generate a new single query conditional formula, and the method of displaying the items that can be selected as the query conditional expression is displayed. The step of selecting the input data query object (that is, the comparison operator) 'is to include the data type of the data query object (block)' and the comparison operator to which the type applies for selecting the character type ", then The displayed and selectable inputs include "equal to", "not equal to", "", and "ending with?"; The numerical type ", then the displayed and selectable inputs include" equal to "," not equal to ", and" greater than " Equal to "," less than or equal to ";" date type ", then the displayed and available for selection include" equal to "," not equal to "," greater than or equal to "," less than or equal to ", and before? "Bryn type" or "menu split state" compared to the operands, including at least "equal to", 3 · If the first scope of the patent application, at least two groups are closed to allow the use of data), comparison Condition (The system judges the selected data to dynamically adjust and display the data: (1) If the data type is "comparison of the input operator, at least" include "," begins with? (2)) If the data type is "Incoming comparison operator, at least" greater than "," less than ", (3) If the data type is" incoming comparison operator, at least "greater than", "less than", "before? Within days", "( 4) If the data type is "displayed and selected for input, the ratio is" not equal to ". Among them, the system described by the householder repeatedly repeats the method", ^ ^ tin # 4-r, and the method "six" is selected. The data query object of the input I (that is, the comparison operator), and 4 of the condition value of σ. If the scope of the patent application is}, at least two sets of data should be collected to allow the use of data.), The comparison condition ( Page 54 ^ 1234 ^ 1234 M No. 90126102 Application for amendment of the scope of patent application VI, j 匕 连 j •, 乂 / &lt; | ^ Γ / μ system ^ more, including the system to determine the data query object (data I ί) ϋ shell material type, and dynamically adjust the display and control the data query to C if :: Steps to access the data type of the input data. · In the block, i dry type ^ ^ "character type", then The system of the query condition value can only take the blank of the query condition value, and the system automatically controls) the two = ΐΐϊϊ, distance;:, state ", 丨 period type" and the selected ,, @ |, y- ^ ^ At 7? "Inside" or "Before? The blank value field of the date value shows a query bar that can be entered (3) If the data bear 2" Motion control can only accept numerical input; it is "equal to", Equal date type "and the selected comparison operator is equal to" or "less than or equal to", "greater than", "less than", "greater than ^^ showing an input date, within the limit of the query condition value , Explicit input; eight ', and the system automatic control can only accept the date grid (4) If the data type is "in the block, the display contains selection", type "", then the query condition value is available for selection Enter; menu format including, "Yes", "No", (5) If the data type is "inside the block, display by the department knows * i ^", then the text of the query condition value "will be explained in text "" Described above> A read of the data block may include input input. And the option of querying the value of the parent for selection. 5. As described in the method of item 1 of the scope of patent application, combine and produce Page 55, 1221234, Case No. 90126102 VI. Generate a compound query condition formula in the scope of patent application "and, as shown, display the compound query condition formula", it means that the system selects at least two selected, displayed If the query condition expression and the selected logical operator are combined, the parentheses "(), ri" will be generated, and the swollen xitai 乜 place "I" to the eye "will be swollen to form Α—bismuth compound query Conditional. Fengmaxin 6. As the method of applying for the scope of patent application item 丨, it also includes a storage area "storage method to store at least one of the n: combined Ϊ pieces type", which is the user's turn; ^ type Storage area 'for users to generate another-combined query condition; again, the system :::. The combined query condition Risi ’was originally selected for combination of the single: complex or compound query condition also exists. One. Conditional expression 7. If the method of the first scope of the patent application, the method of combining the logical operators of the "OR". 3 and "and more than one in the" conditional storage area ": Or select any two: After receiving the logical conditional expression of the selected "and" or "or", the system will store this one after the query conditional expression is combined; = the synthetic expression is stored in the "conditional expression storage area". The new compound condition is the function of the depositor's deletion of item 7 in the scope of patent application; the system accepts the user's selection in the "deleted piece-type storage area! Page 56 1221234 i No. 901 plus Π9. = More than a single query conditional or delete delete "function, after the system is about to select a component: select the conditional and delete it from the" conditional storage area ". Conditional expression or compound 9. After the final query conditional expression required by the user described in item 丨 of the patent application scope, after generating a query data result of the query conditional expression: 3 shows that-the specific system receives The selected specific query condition 3. / The system receives the selected input to display the query 2 results 0 and the system according to the specific query condition expressions, the details are recorded as 5 tigers, and the detailed information items recorded by the condition data "To: After all the methods that meet the 10th, such as the scope of the patent application, i, the final query conditional expression required by A, the steps of the package and the person to generate a user conditional expression include: The specific query system receives the selected input. The specific query bar system receives the selected input's "save" function. ^ · The system receives the input of the query condition owing =, another name; and the identification system in the Bekoku file will Specific query conditions and restore media for future use. ^ Is stored in a computer storage under a different name. 11. As described in item 1 of the scope of the patent application, 1 the final query condition formula required by the user, save, save ~ produce J, an I word, and store a specific search term. Page 571221234 Case No. 90126102 After the amendment 6, the scope of the patent application, it further includes the step of using the query condition formula that has been stored in the computer storage medium, including: The system receives the entered query condition for access and storage The function signal; the system displays and receives the identification name of the selected input query condition; the system receives the function signal of the selected input to display the query result; and the system retrieves and displays all data records that meet the conditions according to the query condition Of detailed information items and their data. 12. The method according to item 10 of the scope of patent application, which further includes a user identification name of the saver who records the stored search conditional expression, and the search conditional expression belongs to the depositor's login system with the user identification name. 3, the special nature of the conditional expression; ▲ The query conditional expression is: usability: 'Use any user identification name to register the query conditional expression. Where can be taken: the method of item 12 ... includes the display and memorization ;; query the most recently used date and time of the conditional expression, and is taken Page 4 of 1 on page 58: "Methods of = 3 第 =" also includes "Sorting" 2 query conditions; there are multiple saved search users who can store the identification names according to the query conditions. , Or 1221234 The date and time of the most recent use, or the order of use from highest to largest, and from largest to smallest, conditional expressions. Use these three items to find the required query from any convenience. 15. For example, the query conditions stored in the database for the item u of the patent application range. The query conditions stored in the database: 2 steps include deleting and selecting any Included in the phone include: Select the "Delete" function; + Query conditions in the media; The system displays either "Delete delete" and "Undelete" two warning messages are numbered. If the user selects "OK" to delete the saved The query condition in the database; ^ This, the system deletes the ^ If the user selects the "cancel the delete operation. Delete" function, the system does not perform the deletion. 16. If the patent application scope of the 6th storage area " The storage method can also be changed to the two temporary storage areas of the "conditional area" described in the above, which can be divided into "source area" and factory head K: storage method. Among them, "two: early check of nature—conditional formula" or "composite condition", put at least one or more disciplines: more than "composite conditional formula"; The name and description of 'all belong to the two source areas' or' the four political changes of the month of the goods. Page 1212234 1. The method in item 4 of the patent scope of claim 4, which further includes "and" and 7 f? Combination method of ί series operands; after the user selects any single-or compound condition of any two ^ ί districts, and then selects the AND operator to combine them into a composite condition, the system will A compound conditional is moved to the "target zone". 18 · If the function of patent application is applied; after the conditional expression, the user selects the conditional expression to move to the method of “around item 16”, and selects any one or more of the “moving” function. The source area (. It also includes “moving The compound system of the "target zone" is about to be selected, and it also contains one of "delete" or "target zone" to select the function or compound condition of "delete" from the "come." The formula of 16 items :: Yes; the user deletes the "single-conditional formula or composite conditional formula in the source area ^ π system to be selected single condition, product" or "target area".