We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Tanker: Embrace the relational model

Formal Metadata

Title
Tanker: Embrace the relational model
Title of Series
Number of Parts
611
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language
Production Year2017

Content Metadata

Subject Area
Genre
Abstract
Tanker goal is to allow easy batch operations without compromising databasemodeling. For pandas users, it's like DataFrame.to_sql on steroids. The Tanker inception is based on two strong observations (not particularlynew): * The object-relation mapping in so called libraries is sometimes source of performance and semantic difficulties, especially with queries involving multiple joins. On the other hand, the relational model is both powerful and simple, and there are no reason not to expose it to the Python world. * When working with external data sources, we are often faced with the challenge of matching those records with the database content. We have to know which record is new, which has been updated, etc. We also often have to de-normalize content and map it with a (hopefully) well-designed and 3NF schema. This presentation will show how Tanker answers those two aspects, how it wasinspired by existing libraries and how it is currently used in productionapplications.