Skip to content

Editors pass #2 #279

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 2 commits into from
Aug 25, 2022
Merged

Editors pass #2 #279

Changes from all commits
Commits
Show all changes
2 commits
Select commit Hold shift + click to select a range
e18f02c
Editors pass #2
levkk Aug 25, 2022
d92508c
typo
levkk Aug 25, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
20 changes: 10 additions & 10 deletions pgml-docs/docs/blog/data-is-living-and-relational.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -25,7 +25,7 @@ Data is Living and Relational
</div>


A common problem with data science and machine learning tutorials is the published and studied data sets are often nothing like what you’ll find in industry.
A common problem with data science and machine learning tutorials is the published and studied datasets are often nothing like what you’ll find in industry.

<center markdown>

Expand All @@ -42,11 +42,11 @@ They are:
- usually denormalized into a single tabular form, e.g. a CSV file
- often relatively tiny to medium amounts of data, not big data
- always static, with new rows never added
- sometimes pre-treated to clean or simplify the data
- sometimes pretreated to clean or simplify the data

As Data Science transitions from academia into industry, these norms influence organizations and applications. Professional Data Scientists need teams of Data Engineers to move data from production databases into data warehouses and denormalized schemas which are more familiar, and ideally easier to work with. Large offline batch jobs are a typical integration point between Data Scientists and their Engineering counterparts, who primarily deal with online systems. As the systems grow more complex, additional specialized Machine Learning Engineers are required to optimize performance and scalability bottlenecks between databases, warehouses, models and applications.
As Data Science transitions from academia into industry, these norms influence organizations and applications. Professional Data Scientists need teams of Data Engineers to move data from production databases into data warehouses and denormalized schemas, which are more familiar and ideally easier to work with. Large offline batch jobs are a typical integration point between Data Scientists and their Engineering counterparts, who primarily deal with online systems. As the systems grow more complex, additional specialized Machine Learning Engineers are required to optimize performance and scalability bottlenecks between databases, warehouses, models and applications.

This eventually leads to expensive maintenance and to terminal complexity: new improvements to the system become exponentially more difficult. Ultimately, previously working models start getting replaced by simpler solutions, so the business can continue to iterate. This is not a new phenomenon, see the fate of the Netflix Prize.
This eventually leads to expensive maintenance and terminal complexity: new improvements to the system become exponentially more difficult. Ultimately, previously working models start getting replaced by simpler solutions, so the business can continue to iterate. This is not a new phenomenon, see the fate of the Netflix Prize.

Announcing the PostgresML Gym 🎉
-------------------------------
Expand All @@ -55,17 +55,17 @@ Instead of starting from the academic perspective that data is dead, PostgresML

![relational data](/images/illustrations/uml.png)

Relationa data:
Relational data:

- is normalized for real time performance and correctness considerations
- has new rows added and updated constantly, which form the incomplete features for a prediction
- has new rows added and updated constantly, which form incomplete features for a prediction

Meanwhile, denormalized data sets:
Meanwhile, denormalized datasets:

- may grow to billions of rows, where single updates multiple into mass rewrites
- often span multiple iterations of the schema, where software bugs leave behind outliers
- may grow to billions of rows, where single updates multiply into mass rewrites
- often span multiple iterations of the schema, with software bugs leaving behind outliers

We think it’s worth attempting to move the machine learning process and modern data architectures beyond the status quo. To that end, we’re building the PostgresML Gym, a free offering, to provide a test bed for real world ML experimentation in a Postgres database. Your personal Gym will include the PostgresML dashboard, several tutorial notebooks to get you started, and access to your own personal PostgreSQL database, supercharged with our machine learning extension.
We think it’s worth attempting to move the machine learning process and modern data architectures beyond the status quo. To that end, we’re building the PostgresML Gym, a free offering, to provide a test bed for real world ML experimentation, in a Postgres database. Your personal Gym will include the PostgresML dashboard, several tutorial notebooks to get you started, and access to your own personal PostgreSQL database, supercharged with our machine learning extension.

<center>
<video autoplay loop muted width="90%" style="box-shadow: 0 0 8px #000;">
Expand Down