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

Tanker: Embrace the relational model

Formale Metadaten

Titel
Tanker: Embrace the relational model
Serientitel
Anzahl der Teile
611
Autor
Lizenz
CC-Namensnennung 2.0 Belgien:
Sie dürfen das Werk bzw. den Inhalt zu jedem legalen Zweck nutzen, verändern und in unveränderter oder veränderter Form vervielfältigen, verbreiten und öffentlich zugänglich machen, sofern Sie den Namen des Autors/Rechteinhabers in der von ihm festgelegten Weise nennen.
Identifikatoren
Herausgeber
Erscheinungsjahr
Sprache
Produktionsjahr2017

Inhaltliche Metadaten

Fachgebiet
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.