Êtes vous

BI-curious ?

*

Big Data

Data Science

Analytics

Data Viz

PetaByte Scale Computing !

1991

Mongo + BI

Marchandage (1 an+)

Dépression (1j)

Acceptation

Connecteur Mongo -> PostgreSQL 

Notre schéma

2NF

1NF

3NF, 4NF, 5NF

BATCH & STREAM

Nested objects

Tableaux

{
	"invoices": {
		"pk": "id",
		"_id": {
			"dest": "id",
			"type": "TEXT"
		},
		"title": {
			"dest": "title",
			"type": "TEXT"
		},
		"tva": {
			"dest": "tva",
			"type": "DOUBLE PRECISION"
		},
		"lines": {
			"dest": "invoice_lines",
			"type": "_ARRAY",
			"fk": "invoice_id"
		}
	},
	"invoice_lines": {
		"pk": "id",
		"invoice_id": {
			"dest": "invoice_id",
			"type": "TEXT"
		},
		"quantity": {
			"dest": "quantity",
			"type": "TEXT"
		}
	}
}

Merci !

Made with Slides.com