Integrated Information Management System Design And Implementation Of Small And Medium-sized Companies

With the rapid development of computer and the increasing popularity of the Internet, the development and progress of technology and management and data application, the need for sharing and other reasons, to diversify the development and distribution are connected to each other in various regions of the independent management information system, to realize the system hardware, system software, application software and data sharing, has become the more and more urgent task. Management information system as the method and mode of automation business, technology, operation and management of high level, is getting more and more extensive application.Based on the comprehensive management system for small and medium sized companies as examples, expounds the realization of the system design process and the various functional modules, and presents a hybrid storage scheme based on column stores, in order to achieve these query optimization.(1) Describes the background, present situation of development of management information system, analyses the main problems of general management information system。Then summarizes the development structure of management information system in the popular, the Microsoft series of database management system SQL Server.NET FRAMEWORK development platform, back-end and front-end development language JavaScript.(2) In accordance with the software engineering thought and analysis of the system demand, according to the feasibility analysis and demand analysis, the function modules. In order to secure access to the target, design the system role, and through the use case diagram has carried on the description. According to the division of each functional module, the system flow chart of each module is given.(3) In the Visual Studio integrated development environment Microsoft, realization of the system function modules, the database model design using Power Designer.(4) in order to solve the problem of query optimization is a critical issue, the project is in the existing architecture, we propose a hybrid storage scheme based on column stores, in order to achieve these query optimization.