Heli Helskyaho , Jean Yu and Kai Yu
Machine Learning for Oracle Database Professionals
Deploying Model-Driven Applications and Automation Pipelines
1st ed.
Logo of the publisher
Heli Helskyaho
Helsinki, Finland
Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/9781484270318. For more detailed information, please visit http://www.apress.com/source-code.
ISBN 978-1-4842-7031-8 e-ISBN 978-1-4842-7032-5
https://doi.org/10.1007/978-1-4842-7032-5
Heli Helskyaho, Jean Yu, Kai Yu 2021
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.
The use of general descriptive names, registered names, trademarks, service marks, etc. in this publication does not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective laws and regulations and therefore free for general use.
The publisher, the authors and the editors are safe to assume that the advice and information in this book are believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors give a warranty, expressed or implied, with respect to the material contained herein or for any errors or omissions that may have been made. The publisher remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
This Apress imprint is published by the registered company APress Media, LLC part of Springer Nature.
The registered company address is: 1 New York Plaza, New York, NY 10004, U.S.A.
Introduction
This book helps database developers and DBAs gain a conceptual understanding of machine learning, including the methods, algorithms, the process, and deployment. The book covers Oracle Machine Learning (OML) technologies that enable machine learning with Oracle Database, including OML4SQL, OML Notebooks, OML4R, and OML4Py. Machine Learning for Oracle Database Professionals focuses on Oracle machine learning in Oracle autonomous databases, such as the Autonomous Data Warehouse (ADW) database as part of the ADW collaborative environment. This book also covers some advanced topics, such as delivery and automation pipelines in machine learning.
This book also provides practical implementation details through hands-on examples to show how to implement machine learning with OML with ADW and how to automate the deployment of machine learning. The primary goal is to bridge the gap between database development/management and machine learning by gaining practical knowledge of machine learning. As a seasoned database professional skilled in managing data, you can apply this knowledge by analyzing data in the same data management system. Through this book, three authors with rich experience in machine learning and database development and management take you on a journey from being a database developer or DBA to a data scientist.
Readers and Audiences
This book is written for
Database developers and administrators who want to learn about machine learning
Developers wanting to build models and applications using Oracle Databases built-in machine learning feature set
Administrators tasked with supporting applications in Oracle Database and ADW that use the machine learning feature set
Readers will learn how to do the following.
Build an automated pipeline that can detect and handle changes in data/model performance
Develop and deploy machine learning projects in ADW
Develop machine learning with Oracle Database using the built-in machine learning packages
Analyze, develop, evaluate, and deploy various machine learning models using OML4R and OML4SQL
Acknowledgments
I want to thank my family, Marko, Patrik, and Matias, for their continuous support during this project, and my parents for their encouragement throughout my life. You gave me the confidence to write this book.
Thank you, Jean and Kai, for writing this book with me! It was a great pleasure to work with you. You are great friends and extremely talented.
Special thank you to Charlie Berger and Adrian Png for the extremely valuable comments, guidance, and support during this project. We could not have been able to write this book without your help!
And thank you, Jonathan, Jill, and the rest of the Apress team!
Heli Helskyaho
I want to thank my parents, my grandfather, and my middle school math teacher for encouraging me to pursue an engineering career. Special thank you to my husband Kai, and to my graduate advisors Dr. Steve Robbins and Dr. Kay Robbins of UTSA for introducing me to the software industry in 1995.
Thank you Heli and Kai for working with me on this amazing project. I greatly admire your dedication and passion for the Oracle Machine Learning community.
Id like to extend a special thanks to our reviewer Adrian Png and Apress editors Jonathan Gennick and Jill Balzano. I appreciate your extremely valuable review comments. Your guidance and support made this project possible for a novice writer like myself. I learned so much. Thank you!
Jean Yu
I dedicate this book to the readers of this book. I want to thank all the people who have assisted with this book, especially the technical reviewer, Andrew Peng, Apress editors Jonathan Gennick and Jill Balzano, and the rest of the Apress team, for their great efforts and patience in transforming the technical content into a finished book.
I thank Heli and Jean for their great talents, dedication, and amazing teamwork. It has been my great honor to be part of this great team with them.
I also thank my wife, Jean, and my daughter, Jessica, for their continuous support during this project. I want to dedicate this book to my parents, who encouraged me to pursue my education and career in computer technology.
I thank my mentor, Dell Senior Fellow Jimmy Pike, and the Dell Technical Leadership Community, who have inspired me to pursue technical excellence and expand my expertise in AI and machine learning. I also want to thank my manager, Ibrahim Fashho, for his great inspiration and longtime support.
Kai Yu