F09 - The Best of Both Worlds: SQL and NoSQL from a Single Database

Session Number: 5049
Track: Ala Carte - I
Session Type: Podium Presentation
Primary Presenter: George Baklarz [IBM]
Time: May 02, 2018 (08:00 AM - 09:00 AM)
Room: Congress A

Session Code: F09
Speaker Bio: George Baklarz, B. Math, M. Sc, Ph.D. Eng., has spent many years in IBM working on various aspects of database technology. In 1991, George was part of the team that helped move the OS/2 ES database to Toronto to become part of the DB2 family of products. Since this time he has worked on vendor enablement, competitive analysis, product marketing, product planning, and technical sales support. George currently works on the worldwide Core Database Technical Sales team helping customers understand the value of using DB2.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Implementing New DB2 Releases and Features
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: New Release (DB2 for LUW), SQL and XML Features
Objective 1: Learn about the existing JSON Support with Db2
Objective 2: See how new JSON features can be catalogued in a Db2 database
Objective 3: Examine the various JSON functions and explore how they are used
Objective 4: Learn about some of the future enhancements that will be coming in JSON

Abstract:  Now you can combine SQL and NoSQL data into one database! Db2 for Linux, UNIX and Windows introduced support for JSON in Version 10.5 through the use of a MongoDB wire listener, a NoSQL command line, and Java API support. What we didn't tell you was that there were some functions under the covers that you can take advantage of to use JSON natively within your SQL. This session will uncover some of these new supported features and show you how you can take advantage of them in your application development.