Robert Mamayev - Data Modeling of Financial Derivatives: A Conceptual Approach

DATA MODELING OF FINANCIAL DERIVATIVES

A CONCEPTUAL APPROACH

_____________

Robert Mamayev

Data Modeling of Financial Derivatives: A Conceptual Approach

Copyright 2013 by Robert Mamayev

This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed. Exempted from this legal reservation are brief excerpts in connection with reviews or scholarly analysis or material supplied specifically for the purpose of being entered and executed on a computer system, for exclusive use by the purchaser of the work. Duplication of this publication or parts thereof is permitted only under the provisions of the Copyright Law of the Publishers location, in its current version, and permission for use must always be obtained from Springer. Permissions for use may be obtained through RightsLink at the Copyright Clearance Center. Violations are liable to prosecution under the respective Copyright Law.

ISBN-13 (pbk): 978-1-4302-6589-4

ISBN-13 (electronic): 978-1-4302-6590-0

Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.

The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights.

While the advice and information in this book are believed to be true and accurate at the date of publication, neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or omissions that may be made. The publisher makes no warranty, express or implied, with respect to the material contained herein.

President and Publisher: Paul Manning

Acquisitions Editor: Jeff Olson

Developmental Editor: Robert Hutchinson

Editorial Board: Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Louise Corrigan, Jonathan Gennick, Jonathan Hassell, Robert Hutchinson, Michelle Lowman, James Markham, Matthew Moodie, Jeff Olson, Jeffrey Pepper, Douglas Pundick, Ben Renow-Clarke, Dominic Shakeshaft, Gwenan Spearing, Matt Wade, Tom Welsh

Coordinating Editor: Rita Fernando

Copy Editor: Laura Poole

Compositor: SPi Global

Indexer: SPi Global

Cover Designer: Anna Ishchenko

Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail . Apress Media, LLC is a California LLC and the sole member (owner) is Springer Science + Business Media Finance Inc (SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation.

For information on translations, please e-mail .

Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use. eBook versions and licenses are also available for most titles. For more information, reference our Special Bulk SaleseBook Licensing web page at www.apress.com/bulk-sales .

Any source code or other supplementary materials referenced by the author in this text is available to readers at www.apress.com . For detailed information about how to locate your books source code, go to www.apress.com/source-code/ .

Apress Business: The Unbiased Source of Business Information

Apress business books provide essential information and practical advice, each written for practitioners by recognized experts. Busy managers and professionals in all areas of the business worldand at all levels of technical sophisticationlook to our books for the actionable ideas and tools they need to solve problems, update and enhance their professional skills, make their work lives easier, and capitalize on opportunity.

Whatever the topic on the business spectrumentrepreneurship, finance, sales, marketing, management, regulation, information technology, among othersApress has been praised for providing the objective information and unbiased advice you need to excel in your daily work life. Our authors have no axes to grind; they understand they have one job onlyto deliver up-to-date, accurate information simply, concisely, and with deep insight that addresses the real needs of our readers.

It is increasingly hard to find informationwhether in the news media, on the Internet, and now all too often in booksthat is even-handed and has your best interests at heart. We therefore hope that you enjoy this book, which has been carefully crafted to meet our standards of quality and unbiased coverage.

We are always interested in your feedback or ideas for new titles. Perhaps youd even like to write a book yourself. Whatever the case, reach out to us at to sign up for newsletters and discounts on future purchases.

The Apress Business Team

To all the people who believed in me and encouraged me to publish this work!

Contents

About the Author

Robert Mamayev is president of BinaryCurve.com . He has 15 years of experience as a data modeling, data warehousing, and data architect lead in the pharmaceutical, financial and government sectors. He is a trainer and developer of instructional materials in the field of data modeling. He is a certified Oracle Professional and holds a BS in computer science from Queens College.

Acknowledgments

I am profoundly grateful for the love, support, and constant encouragement of my amazing family, without whom this work would not have been possible.

I would like to express my great appreciation to the many other people who provided me support, encouragement, and advice during the writing of this book. I am especially grateful to Rebecca Stout and Joseph Licata for helping me edit the manuscript and to David C. Hay for reviewing and improving significant portions of the manuscript.

Preface

Endeavor always to conquer yourself rather than fortune.

Ren Descartes, Le Discours de la Mthode

Recently I witnessed an argument between two close friends, both of them data modeling practitioners. At issue was whether data modeling is an art form. One argued that successful data modelers are a select and unique breed of software professionals whose skills cannot be taught; youre either born with them or youre out of luck. The other argued that practically anyone can be taught data modeling and become a successful data modeling practitioner.

I didnt take part in this discussion, preferring to stay out of it. As a dedicated student of Dale Carnegie, I know that the best way to win friends and influence people is to avoid such arguments altogether. But now is the occasion for me to open up and express what I feel on the subject. I do not consider data modeling to be an innate art. To me, data modeling is a learned skill that gets better and better with experience. Data modeling, like any other profession, requires dedication, practice, and passion. Most knowledge is perishable and diminishes with the passage of time unless continually refreshed and exercised. To become good at something and stay good at it, you need to practice and practice hard. It is through practice and action that you really learn things and become confident in whatever it is you are doing.