Flatiron Health

Inductive bias is the set of assumptions or preferences a machine learning algorithm uses to generalize from limited training data to unseen examples , essentially guiding it to choose one solution over others that fit the data equally well, like assuming a smooth curve rather than a jagged one, and it's crucial for learning but must be chosen carefully to avoid errors . It's the "outside knowledge" built into a model, influencing its architecture, choice of functions (e.g., linear vs. tree-based), or regularization, enabling it to make educated guesses instead of random predictions.1234

This video provides a brief overview of what inductive bias is:
40s[

AI and Machine Learning Explained YouTube • Dec 1, 2025](https://www.youtube.com/watch?v=9IlHaeTMFoU&t=140)

Key Concepts

• Generalization: Without inductive bias, an algorithm can't move beyond memorizing training data to predict new data.
• Assumptions: It embodies assumptions about the underlying patterns, like assuming simplicity (Occam's Razor ) or locality (nearby points are similar).
• Types:
  • Restrictive Bias: Narrows down the possible functions (e.g., preferring linear functions).
  • Preferential Bias: Ranks hypotheses, preferring simpler ones.
• Examples in Models:
  • Linear Regression: Assumes a straight-line relationship (strong bias).
  • Decision Trees: Assumes hierarchical, step-like rules.
  • Transformers: Uses self-attention as a bias for understanding context in sequences.123456

"Flatiron" commonly refers to the iconic triangular-shaped Flatiron Building in NYC, steep, wedge-shaped rock formations near Boulder, Colorado, or a historical non-electric clothes iron . It also describes a type of steak, a cancer research data company, an infrastructure company, and scientific research institutes.12345

Key Definitions of "Flatiron"

• The Flatiron Building (NYC): A famous 22-story, triangular landmark built in 1902 at the intersection of Fifth Avenue and Broadway in Manhattan.
• The Flatirons (Colorado): A series of five, large, steeply sloping, triangular rock formations on the eastern slope of Green Mountain in Boulder, Colorado.
• Historical Appliance: A flat-bottomed iron tool made of metal, heated on a stove, and used to press clothes.
• Flat Iron Steak: A top-blade steak cut from the shoulder of a cow, known for being flavorful.
• Flatiron Health: A company specializing in oncology data and electronic health records to improve cancer care.
• Infrastructure/Construction: Flatiron is also a major firm specializing in transportation and infrastructure projects (roads, bridges, rail).
• Scientific Research: The Flatiron Institute is a division of the Simons Foundation that focuses on computational science.12345678

Geological Meaning
In geology, a "flatiron" refers to a steeply dipping triangular ridge of rock that has been eroded, leaving a flat-faced surface that resembles an old, triangular clothes iron.12

A PostgreSQL unique constraint is a database integrity feature that guarantees all values within a specified column or group of columns are distinct across all rows in a table . It prevents the insertion or update of duplicate entries and automatically creates a unique B-tree index to enforce this rule efficiently.1234

Key Characteristics

• Data Integrity: Enforces business rules that require unique identifiers, such as email addresses or usernames, at the database level.
• Allows NULL values (by default): Unlike a PRIMARY KEY , a UNIQUE constraint permits multiple rows to contain NULL values in the constrained column(s), as NULL values are not considered equal to each other in SQL by default.
• Multiple Constraints: A table can have multiple UNIQUE constraints, but only one PRIMARY KEY.
• Automatic Indexing: PostgreSQL automatically creates a unique index when a unique constraint is defined, which is the underlying mechanism for enforcing uniqueness and optimizing lookup performance.
• Error Handling: Attempting to violate the constraint by inserting or updating a duplicate value will result in an error message, such as "duplicate key value violates unique constraint".12345

Syntax and Usage

You can define a unique constraint when creating a new table or add one to an existing table using ALTER TABLE.1

Creating a New Table

A unique constraint can be defined at the column level or the table level.123

• Column-level: sql```
  CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE,
  username TEXT NOT NULL UNIQUE
  );

- **Table-level (for single or multiple columns):** sql```
CREATE TABLE products (
    product_no integer,
    name text,
    price numeric,
    UNIQUE (product_no),
    CONSTRAINT unique_prod_name UNIQUE (name)
);

For a composite unique constraint on multiple columns, the combination of values must be unique:sql```
CREATE TABLE transactions (
customer_id INT NOT NULL,
product_id INT NOT NULL,
quantity INT NOT NULL,
UNIQUE (customer_id, product_id)
);

<!--CITE:1--><!--CITE:2--><!--CITE:3--><!--CITE:4--><!--CITE:5-->

Adding to an Existing Table

You can add a unique constraint to an existing table using the `ALTER TABLE` statement, provided the existing data does not contain duplicates.<!--CITE:1-->

sql```
ALTER TABLE table_name
ADD CONSTRAINT constraint_name UNIQUE (column1, column2);

Removing a Unique Constraint

To remove a unique constraint, you need to know its name. PostgreSQL automatically generates a name if you don't provide one (e.g., tablename_columnname_key).1234

sql```
ALTER TABLE table_name
DROP CONSTRAINT constraint_name;

Advanced Option: `NULLS NOT DISTINCT` <!--CITE:1--><!--CITE:2-->

By default, multiple `NULL` values are allowed in a unique column. If you want to enforce that a column can have at most one `NULL` value (treating all `NULL` s as equal), use the `NULLS NOT DISTINCT` clause (available in newer PostgreSQL versions).<!--CITE:1--><!--CITE:2--><!--CITE:3--><!--CITE:4-->

sql```
CREATE TABLE products (
    product_no integer UNIQUE NULLS NOT DISTINCT,
    name text,
    price numeric
);

For more details and official documentation, refer to the PostgreSQL documentation on constraints.12

In PostgreSQL, a UNIQUE constraint guarantees that all values in a specified column or group of columns are distinct across all rows in a table. This is essential for maintaining data integrity and preventing duplicate entries like email addresses or usernames.123

Key Characteristics

• Data Integrity: Prevents insertion or update of rows that would result in duplicate values in the constrained columns.
• Automatic Index: PostgreSQL automatically creates a unique B-tree index to enforce the constraint and optimize lookups, so you do not need to create one manually.
• Allows NULL Values (by default): Unlike a PRIMARY KEY , a UNIQUE constraint allows multiple NULL values in the constrained column(s), as NULL values are not considered equal to each other in SQL by default.
• Multiple Constraints: A table can have multiple UNIQUE constraints, but only one PRIMARY KEY.
• Primary Key Alternative: A PRIMARY KEY is functionally a UNIQUE constraint plus a NOT NULL constraint.1234567

Syntax and Usage

You can define a UNIQUE constraint when creating a new table or add it to an existing table using ALTER TABLE.1

Creating a new table with a unique constraint

• Column Level: sql```
  CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email TEXT UNIQUE,
  username TEXT NOT NULL
  );

- **Table Level (for a single column):** sql```
CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    email TEXT,
    username TEXT NOT NULL,
    UNIQUE (email)
);

• Composite Unique Constraint (multiple columns): Ensures the combination of values is unique.sql```
  CREATE TABLE reservations (
  user_id INT REFERENCES users(id),
  room_id INT REFERENCES rooms(id),
  start_time TIMESTAMP,
  end_time TIMESTAMP,
  UNIQUE (user_id, room_id, start_time)
  );

<!--CITE:1--><!--CITE:2--><!--CITE:3--><!--CITE:4--><!--CITE:5-->

Adding a unique constraint to an existing table

sql```
ALTER TABLE users ADD CONSTRAINT unique_email_address UNIQUE (email);

If you don't provide a constraint name (unique_email_address in the example), PostgreSQL will generate one for you.1

Removing a unique constraint

sql```
ALTER TABLE users DROP CONSTRAINT unique_email_address;

You will need the constraint's name to drop it.<!--CITE:1-->

Advanced Usage

- **`NULLS NOT DISTINCT`:** PostgreSQL 15+ introduced the option `NULLS NOT DISTINCT` to treat `NULL` values as duplicates, preventing more than one `NULL` in a unique column.
- **Partial Unique Index:** You can enforce uniqueness for only a subset of rows by creating a unique partial index, which cannot be done with a standard `UNIQUE` constraint directly.
- **Concurrent Index Creation:** For large tables, you can create the underlying index concurrently to avoid locking the table for writes, then add the constraint using that index:sql```
CREATE UNIQUE INDEX CONCURRENTLY users_email_idx ON users (email);
ALTER TABLE users ADD CONSTRAINT unique_email UNIQUE USING INDEX users_email_idx;

12345