Research Andapplication Of Financial Services Software Data Modeling

Information Age Hurricane swept across the planet, IT planning is right or not has become the key to business survival, planning for IT is to deal with enterprise management bottlenecks, information asymmetry, not timely,and other issues. Data modeling is a part of IT planning,Any software architect must master and apply data modeling, That business of many, complex enterprise software development process to go through,data model has undergone two stages of formatted model and relational model. So far, there have been universal model. Now, data modeling faced with difficult to reach agreement on the definition of entity, poor portability, versatility is very weak, the industry is repeated in the same business modeling, resulting in waste of resources and other issues. Inaccurate financial data model led to the development of financial management software, which can not meet the needs and the changing needs of customers.To solve these problems, first of all, this article customized modeling conventions and corresponding standard for data modeling of the financial services to solve the difficult to reach agreement on the definition of entity based on Peter Chen and Richard Barker's notation. Secondly, based on Entity-Relationship data modeling approach, and introducted foreign key inherited ideology in object-oriented data modeling approach, analysis of the financial services, refining business data, abstracted and summarized the three elements,which are entities, attributes and relationship between entities, required for data modeling from the business data, which simplify the analysis of modeling the business data. Again, give a definition of entity, summary details of each entity's attribut es, and distinguish the relationship which is one to many, many to many or one to one, which makes the establishment of data model more accurate, solve the problem that the financial software can not meet the needs of enterprise management, adapt to the changing needs of customers and short life cycle, a more detailed analysis on various types of financial business, summary all types of business to get the most basic data which is people and organizations.In this thesis, people and organization logical data model are established by using PowerDesigner modeling tool in the Windows XP, and combining Entity-Relationship approach and Object-oriented approach. The role of parties and the parties, the parties relationship, invoice and invoice items, billing account, invoice payment and financial account etc general finanal data model are established based on people and organizations data model. The above mentioned general issues of the poor and the weak portability have been solved. Chapter V use bank accounts payable system as an example, by changing the common data model established by the Chapter IV accordingly based on OFBiz framework technology(in the base model, subclass entity organizational unit of organizational role are changed to be head office, branches and sub-branches. Other models also have the corresponding changes here). Using IBM's DB2 database as database and establishing a physical database model based on this model, which is applied develop bank accounts payable system, this is methods like column that the common data model is cited in similar finance business. The problem repeated modeling the same or similar financial business and waste of resources have been solved.