Chapter 5
Working with a Relational DBMS
IN THIS CHAPTER
Understanding RDBMS characteristics
Working with RDBMS data
Developing datasets from RDBMS data
Using more than one RDBMS product
Relational databases accomplish both the manipulation and data retrieval objectives with relative ease. However, because data storage needs come in all shapes and sizes for a wide range of computing platforms, many different relational database products exist. In fact, for the data scientist, the proliferation of different Relational Database Management Systems (RDBMSs) using various data layouts is one of the main problems you encounter with creating a comprehensive dataset for analysis. The first part of this chapter focuses on common characteristics of RDBMS so that you have a better idea of what commonality you can expect when working with them.
The second part of the chapter discusses the mechanics of working with an RDBMS. However, in contrast to how code is done in many other chapters in this book, writing functional code is nearly impossible in this case because of variations between RDBMS ...
Get Data Science Programming All-in-One For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
