Design And Implementation Of Drilling Material Management System Based On Django In Big Data Environment

With the rapid development of computer technology and oil drilling information technology,the drilling material business data managed by drilling enterprises in various oil fields has increased dramatically.The traditional drilling material management system has been unable to meet the needs of data management and application under the environment of big data.This paper uses Django framework to design and implement a drilling material management system based on Django framework under the environment of big data,and constructs the database of daily routine data management of drilling materials and uses big data technology to build the corresponding drilling material data warehouse.Data analysis and visual presentation assist enterprise in drilling material management and application decisions.The research work of this paper mainly includes the following aspects.Firstly,in the face of the needs of massive drilling material data management and application,and in order to improve the maintainability of the web-based management system and the convenience of database driving,using Django framework and big data technology to build the corresponding drilling material management system software architecture.Secondly,design and implement a drilling material data warehouse based on Hadoop and HDFS to solve the problem of mass data storage and analysis of drilling materials.Hierarchical design is adopted in the data warehouse,and dimensional modeling is adopted between tables.According to specific business requirements,statistical analysis is carried out on the data in the data warehouse from the company dimension,warehouse dimension,well dimension,region dimension,time dimension and other different dimensions.Thirdly,based on the collected material data,the random forest algorithm in the machine learning algorithm is used to design and implement a data model that recommends the BHA according to the spud environment.Fourth,the using of python written open source Django framework to achieve a frontend separation management system,user management and data visualization functions.