Тематический план

• Managing Tables with Partitioning in InterSystems IRIS

  Managing Tables with Partitioning in InterSystems IRIS

  Content Type
  Video

  Duration
  6m

  Level
  Introductory

  See how table partitioning in InterSystems IRIS® data platform allows you to efficiently manage and query your data by distributing it across multiple databases. Explore partitioning approaches and common strategies, and learn how to set up a partitioned table.
• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Creates a database storage file to store table data	3:17	CREATE DATABASE FILE "visits-2023"
  Creates a PatientVisits table to store patient visit information. Configures the table to automatically partition data by visit date in monthly ranges.	3:30	CREATE TABLE Hospital.PatientVisits ( visit_id BIGINT, patient_id BIGINT, visit_date DATE, department VARCHAR(100), diagnosis VARCHAR(500) ) PARTITION BY RANGE (visit_date) INTERVAL 1 MONTH
  Inserts a patient visit record dated into the table	3:46	INSERT INTO Hospital.PatientVisits VALUES (1, 1001, '01/15/2023', 'Cardiology', 'Hypertension');
  Queries the system to display all partitions created for the PatientVisits table	3:56	SELECT * FROM INFORMATION_SCHEMA.TABLE_PARTITIONS WHERE TABLE_NAME = 'PatientVisits';
  Moves the partition containing 2023 visit data into the visits-2023 database file	4:16	ALTER TABLE Hospital.PatientVisits MOVE PARTITION BETWEEN '2023-01-01' AND '2023-12-31' TO "visits-2023";
  Retrieves all patient visits occurring in 2023 from the table	4:50	Begin code: SELECT * FROM Hospital.PatientVisits WHERE visit_date BETWEEN '2023-01-01' AND '2023-12-31'; End code,
• What's Next?

  What's Next?
  • Read more about SQL Table Partitioning (documentation, 10m).
  • Explore the Table Partitioning Demo Tutorial to see how it works in practice (30 min).