Research On Dynamic Inventory Query Optimization And Inventory Model

Query efficiency is one of important indexes in database systems. Query optimization is a difficult and hot issue in the field. Query optimization method is proposed based on genetic algorithms, which uses keyword preprocessing module. The user enters a keyword into the internal keywords to improve query accuracy, setting up a user searches for statistical records index table can be avoided repeat the search when scanning the whole library, and thus a greater reduction in the query response time, using genetic algorithms for solving the optimal scan in the whole database. The calculation method of correlation, sorted according to size of the correlation, user queries.In the course of business, inventory, accounts for a large part of the business operating costs. How do both to ensure production needs but not so overstock, and companies must now solve the problem, the paper companies on the basis of historical stock data, information granulation using SVM regression to predict the timing to create a model from the model to predict trends in stock and changes in space, to verify the accuracy of the results showed that some of the specific model.The main contents of the thesis are in the following three aspects:(1)The proposed query method of dynamic agricultural inventory. For changes in the characteristics of agricultural stocks, over time selling agricultural products must frequently be searched. Create a temporary index table in the database, the most popular current inventory records changes in agricultural products, agricultural stocks can accelerate query speed to a certain extent, to shorten the response time. According to provisional results of the query index table and then determine whether you need full library search, which to some extent, to accelerate query speed of the system as a whole. Show respect in the query results, a method is proposed based on the sort of correlation, so that the top surface of the hot target keywords, user browsing search results.(2)Established inventory models. Paper describes the importance of a common method of inventory control inventory control, and finally to establish a method of fuzzy information model, Predictive value of the model can provide a reference for the enterprise.It is proved this method has a certain accuracy.(3)Evaluation method proposed inventory model. Experts believe that the first collection inventory model factor, assessed using the right weight factor analysis of eight in method of AHP. In practical applications, according to the inventory model factor weight than to further optimize the inventory model to improve the inventory model.In the National Natural Science Foundation of the National Science and supported by the "12th Five-Year Plan" National Science and Technology Support Program, the findings of this research method of database queries related fields, as well as companies such as inventory control by a certain sign value, further build efficient, accurate inventory optimization system to achieve optimal inventory levels, has some theoretical significance and practical value.