NYOUG 2019 Winter Meeting: Succinct Study of Oracle SQL BI API as Evolution

NYOUG 2019 Winter Meeting: Succinct Study of Oracle SQL BI API as Evolution

A detailed study with a succinct number of examples is provided with use cases based on advancements made to the Oracle SQL BI API from version 12c through 19c with both retrospective and comparative approaches, seeking for variational features for improved maintenance, upgrade, and migrations, and for the relevant optimal query performance tuning. The study is based on several best-practices case studies as recommended by Oracle, and on personal experience working in SQL BI applications in the earlier releases of the Oracle12c database technology family.

Anthony D Noriega
Anthony D. Noriega is a Senior IT Consultant and computer scientist focused in Oracle database technology, network computing, software engineering, machine learning and artificial intelligence and probability research. He has been a database centered analyst, architect, engineer, developer, data scientist, and AI professor. He has earned his MBA MIS from Montclair State University (2006), his MS Computer Science from NJIT (1992 doctoral candidate through 1997) and his BS Systems Engineering
from Universidad del Norte (1987). He has been a consultant for over 50 USA and European Fortune 500 companies and a frequent speaker at IOUG, Collaborate, Oracle OpenWorld, ECO, Quest International Conference, and NYOUG events. He is also a trilingual writer and a published author of several books including the Alma Mater poetry saga.