Programming & Scientific Computing · Databases & Data Engineering

Database integration with statistical environments — Advanced technical reference

Public introduction · full guide in Eikos

Introduction

What this guide covers

Introduction Introduction Advanced Information Systems

Overview

Topics covered

  • Introduction
  • Integration of Databases with Statistical Environments
  • 1. Data Link Architectures
  • 1.1 Traditional Decoupling vs. In-Database Computing
  • 1.2 Serialization Costs and Impact of Columnar Storage
  • 2. Connection Protocols and Drivers

Related concepts

Main connections

  • SQL & relational data modeling
  • Variance & standard deviation
  • Quantiles & percentiles
  • Aggregation & grouping in SQL
  • Window functions in SQL
  • Maximum likelihood estimation

Compatible notation

Mathematical sample in LaTeX

The expression is rendered accessibly, with its LaTeX source preserved below.

Ttotal=Tdb+DB+Tdes
View LaTeX sourceT_{total} = T_{db} + \frac{D}{B} + T_{des}