Data Models for Banking, Finance, and Insurance

This title is printed to order. This book may have been self-published. If so, we cannot guarantee the quality of the content. In the main most books will have gone through the editing process however some may not. We therefore suggest that you be aware of this before ordering this book. If in doubt check either the author or publisher’s details as we are unable to accept any returns unless they are faulty. Please contact us if you have any questions.

Jumpstart your financial application designs with proven conceptual and logical data models for banking, brokerage, and insurance.

From the beginnings of Western and Eastern civilizations, data has always driven our banking, stock trading, and insurance contracts, yet this data was collected and stored in hand ledgers. With the advent of digital technology in the 20th century, financial firms expanded exponentially. The key to this expansion has been relational databases and, more recently, NoSQL, which enable us to store detailed information about customers and products.

This book contains conceptual and logical data models for retail and commercial banking, including savings, checking, mortgages, and loans; credit cards, capital, and financial markets, including general ledger and chart of accounts; investment, brokerage and securities, including equities, options, and bonds; and insurance including property, casualty, and life. Also covered is how to translate into a physical design, including for analytics applications using star schemas.

Whether you are a business specialist, analyst, regulator, or IT professional, this book provides a roadmap and set of patterns for the initial design and construction of fundamental data models for the most frequently used applications in the financial world.