Reader small image

You're reading from  In-Memory Analytics with Apache Arrow

Product typeBook
Published inJun 2022
PublisherPackt
ISBN-139781801071031
Edition1st Edition
Concepts
Right arrow
Author (1)
Matthew Topol
Matthew Topol
author image
Matthew Topol

Matthew Topol is an Apache Arrow contributor and a principal software architect at FactSet Research Systems, Inc. Since joining FactSet in 2009, Matt has worked in both infrastructure and application development, led development teams, and architected large-scale distributed systems for processing analytics on financial data. In his spare time, Matt likes to bash his head against a keyboard, develop and run delightfully demented games of fantasy for his victims—er—friends, and share his knowledge with anyone interested enough to listen.
Read more about Matthew Topol

Right arrow

What is Flight SQL?

We've talked about Arrow Flight a lot in this chapter so far and learned how to create a simple Flight client and server. Back in Chapter 3, Data Science with Apache Arrow, we also talked about ODBC and JDBC as the standard way to connect to most databases currently. If you haven't guessed yet, that something better I was alluding to there was indeed Arrow Flight! Before we get into it, let's have a quick refresher on what ODBC and JDBC are.

ODBC and JDBC were created in 1992 and 1997, respectively, as a technology to help databases expose a common API. By creating a common abstraction layer that all database vendors could implement a driver for, application developers could simply build code to use this common interface with databases. They wouldn't have to create custom/bespoke objects for all the different database software they wanted to use. These technologies quickly became the de facto standard in the enterprise world, and then the...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
In-Memory Analytics with Apache Arrow
Published in: Jun 2022Publisher: PacktISBN-13: 9781801071031

Author (1)

author image
Matthew Topol

Matthew Topol is an Apache Arrow contributor and a principal software architect at FactSet Research Systems, Inc. Since joining FactSet in 2009, Matt has worked in both infrastructure and application development, led development teams, and architected large-scale distributed systems for processing analytics on financial data. In his spare time, Matt likes to bash his head against a keyboard, develop and run delightfully demented games of fantasy for his victims—er—friends, and share his knowledge with anyone interested enough to listen.
Read more about Matthew Topol