Design And Implementation Of Database And Access Interface For P2P Based Credit Investment Platform

In the background of China's rapid development,people's wealth is accumulating rapidly.The combination of the huge demand for personal credit investment and the P2 P mode of the Internet has brought about the rapid development of Internet finance,The credit investment platform based on P2 P has risen rapidly,which can satisfy the personal capital demand and greatly improve the utilization rate of social idle funds,The development of personal credit system has produced important social values.In order to better support the development of point-to-point mode of credit investment business on the Internet,quickly respond to business changes,while maintaining the stability of the system platform,necessary to design and develop a database system which matches a variety of P2 P business scenarios,suits user operation,conforms to business development,caters to industry trends,has strong stability,low system coupling,and is easy to expand,and a database access interface for standardized business functions of the P2 P credit investment platform.Starting from the business roles of lender,borrower and platform manager,this paper analyzes business process,parses process attributes,implements business logic,designs E-R model,uses relational database to design multi-scenario use cases,creates object tables and related dimension tables for storing business data and the results of business processing logic.At the same time,in order to ensure the stability of the business display layer architecture,prevent the impact of database selection,transformation,heterogeneity on business,hide the actual operation of the database,and provide transparent database services,a set of business-related such as add,delete,modify,check and business logic processing API interface is designed for business display layer,and finally carries out the unit test,integration test,performance test and other tests of the business database system.Through the design and implementation of the database and its access interface of the point-to-point mode credit investment platform,this paper provides a theoretical and practical reference method and an empirical case for the software engineering method to develop the commercial database system.