Why Nasa Converted Its Lessons-Learned Database into a Knowledge Graph
Learning from mistakes—your own and those made by others—is a mark of effective organizations. Fostering a learning environment means seeing every...
New Query Language for Graph Databases to Become International Standard
Read the latest Neo4j press releases and company news, including product launches, partnerships, and milestones in graph database and analytics.
Using Altair for most of my visualization in Python
Fernando Irarrázaval Stream of consciousness about Data Science, Python, and Economics.
Modern Data Practice and the SQL Tradition
This made it to the Hacker News front-page too: some very interesting comments there
Google Cloud Firestore NoSQL database is in GA
The Cloud Firestore database is a NoSQL, serverless solution for mobile and web application development -- now generally available globally.
PostgreSQL 11.3 and 10.8
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.3, 10.8, …
Hedge funds use satellite images to beat Wall Street
Berkeley Haas research finds there may be a dark side to the rise of “alternative data” in capital markets While Assoc. Prof. Panos Patatoukas was discussing Walmart in his Financial Information Analysis course last year, a student brought up the story of how company founder Sam Walton used to count cars in store…
AWS Elasticsearch: a fundamentally-flawed offering
I'm currently working on a logging project that was initially implemented using AWS Elasticsearch. Having worked with large-scale mainline Elasticsearch clusters for several years, I'm absolutely stunned at how poor Amazon's implementation is and I can't fathom why they're unable to fix or at least improve it. I…
We need new data books, so we started one: Cloud Data Management
Introducing Chartio and Data School’s new book Cloud Data Management (4 Stages for Informed Companies).
2020 Cloud Report: AWS vs. GCP vs. Azure
The 2020 Cloud Report compares AWS, GCP, and Azure on microbenchmarks and customer-like-workloads to understand performance tradeoffs within each cloud.
Memory Management in Python
To speed-up memory operations and reduce fragmentation Python uses a special manager on top of the general-purpose allocator, called PyMalloc.
File systems unfit as distributed storage back ends: lessons from Ceph evolution
File systems unfit as distributed storage backends: lessons from 10 years of Ceph evolution Aghayev et al., SOSP’19 Ten years of hard-won lessons packed into just 17 pages (13 if you don’t co…
FaunaDB 2.5.4
In 2012, Thomson, Diamond, Weng, et al. published Calvin: Fast Distributed Transactions for Partitioned Database Systems : a transactional protocol optimized for geographic replication. Each Calvin cluster is comprised of multiple replicas , where a replica is a collection of nodes which store a complete copy of the…
Say no to Venn diagrams when explaining SQL joins (2016)
In recent times, there have been a couple of tremendously popular blog posts explaining JOINs using Venn Diagrams. After all, relational algebra and SQL are set oriented theories and languages, so …
Backblaze Hard Drive Stats Q2 2019
This review looks at the Q2 2019 and lifetime hard drive failure rates of the 108,461 hard drives in use at Backblaze's data centers.
PostgreSQL at low level: stay curious
Yes, I know, it’s a long text, and it was my conscious decision to write it in this way. But fear not! Imagine that you read a book, take a look at the introduction and first few interesting sections, think about it and then find time to read further. I hope I’ve left enough references, so if you don’t get some ideas…
Arima Model – Guide to Time Series Forecasting in Python
Using ARIMA model, you can forecast a time series using the series past values. In this post, we build an optimal ARIMA model from scratch and extend it to Seasonal ARIMA (SARIMA) and SARIMAX models. You will also see how to build autoarima models in python
Indexing Billions of Text Vectors
Optimizing memory-usage for approximate nearest neighbor search
Fast Way to Load Data into PostgreSQL Using Python
From two minutes to less than half a second!
Discovering less-known Postgres v12 features
Get to know and learn how to use some less-known features of Version 12 of PostgreSQL. You'll surely discover something new for yourself.
Books: an immutable double-entry accounting database service
Tracking financial transactions at scale
To ORM or Not to ORM
I've been enjoying using Go's database/sql package for working with databases. Recently, some mentions of gorm piqued my curiosity about using ORMs in Go vs. using database/sql directly. Having had some mixed experiences with ORMs in the past, I decided to start with a practical experiment by writing the same simple…
PartiQL: One query language for all your data
Data is being gathered and created at rates unprecedented in history. Much of this data is intended to drive business outcomes but, according to the Harvard Business Review, “…on average, less than half of an organization’s structured data is actively used in making decisions…” The root of the problem is that data is…