14 Database

★Partitioning

Vertical Partitioning

Split tables with many columns into multiple tables

limit number of columns per table

split large, infrequently used columns into a separate table

@Entity

public class Customer {

int userId;

String email;

String password;

@OneToOne(fetch = LAZY)

CustomerInfo info;

}

@Entity

public class CustomerInfo {

int userId;

String skills;

String interests;

@OneToOne(mappedBy = "CustomerInfo")

Customer customer;

}

Phantom reads