摘要 |
PURPOSE: A method for processing a natural query language is provided to convert into an SQL(structured query language) which is a query language of an RDBMS(relational database management system) by extracting a commodity term in a natural query language when a user requests a search according to a desired commodity using a natural language. CONSTITUTION: If a buyer requests a search for a commodity by a natural query language for buying the commodity through Internet virtual stores(S1), a query language is extracted by an extractor(S3) and stored in a storing place array through an HTTPa(40) which is a web server in an electronic commerce system(S2). A token of the stored natural query language is separated by a separator by making various conditions as a space, a pause, a period, and a symbol such as a delimiters(S4). If a term which indicates a commodity price is existed in the separated token, the term is stored in a storage location array and removes the corresponding token(S5). After a postposition is removed in each token(S6), an unused token is removed(S7). If an ESQL(embedded SQL) is created according to an extracted term and an electronic commerce term table is searched, characteristics(CIC(Company Identification Code), PCC(product Classification Code), BN(Brand name), CFC(Chief Function Code)) of each term may be sensed from a control field(S8). A term, which is not possessed in five categories(company identification code, product classification code, brand name, chief function code, and price), is excluded in a processing object, and an ESQL is created according to the four terms except the price and an electronic commerce synonym table is searched, thus a synonym/similar language/foreign language may be obtained(S9). The synonym/similar language/foreign language is processed as one term group and is not considered in a normal creation according to a query language(S10).
|