| With the rapid economic development,the scale of sales data within the enterprise is gradually expanding,and the data will be redundant,scattered and incomplete.The massive generation of sales data and the advancement of information technology have made the management and analysis based on sales data an important means for enterprises to further realize business development and increase product sales.At present,in the field of data analysis,OLAP is the most commonly used and most effective technology.It can realize multi-angle and multi-level query and analysis of sales data.OLAP solve the analysis of multi-dimensional relational data through data aggregation,and mine potential information in known data.Generally,enterprise management systems store sales information in a relational model,but with the rapid growth of the amount of information,the relationship between data objects becomes more complicated.For example,"sales personnel","orders","sold party companies" are different types of entities,there are also different types of relationships between these entities.Compared with the traditional relational data model,the information network model has a more powerful expressive ability,and can better express the semantic information contained in the data and the relationship between the objects.Therefore,in order to meet the sales data management and analysis needs of an automated product sales company,this thesis establishes a sales heterogeneous information network based on the sales data,and implements the management and analysis of the sales data based on the established sales information network data model,so as to provide enterprise reliable basis for products supply and marketing strategy formulation.This thesis completes the demand analysis,architecture design,and design of each functional module for a new sales data management and analysis system.Based on this,the coding is implemented and the system test is completed.The system is developed based on the Java environment and uses B / S architecture.Neo4 j and My SQL provide back-end database support,and the development framework uses a combination of Vue and Spring Boot.The sales data management and analysis system innovatively uses ontology technology to create a sales information network model,store sales data in the form of heterogeneous information networks,uses graph multidimensional analysis technology to analyze sales data,and present it to users in the form of visual knowledge networks.The system includes three functional modules: data loading,sales data management,and data multidimensional analysis.The data loading module enables the import of new sales data.The data management module enables users to visually effectively manage sales information such as sales orders,products,companies,and sales personnel.The data multidimensional analysis module realizes the analysis of sales data from different angles and different levels.Based on the defined structural and attribute dimensions for multi-dimensional analysis of sales information networks,users can specify query dimensions in a manner close to natural language,and the system returns visual analysis results. |
