Technics Publications Data Models for Banking, Finance, and Insurance: Jumpstart Database Designs with Proven Patterns

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.