Design In-Memory Database
Design an in-memory database system. The system should support the following operations:
- Database Management: Create and delete databases.
- Table Management: Create and delete tables within databases.
- Data Operations: Perform
Select,Insert, andDeleteoperations on table records.
A table definition includes columns, each with a type. Supported column types are string (max length 20 characters) and int (range -1024 to 1024). Columns can be marked as required.
Additionally, the system should support:
- Printing all records in a table.
- Filtering and displaying records where column values match a given value.
- Support for constraints on columns.
AI interview prep
Core dilemma
Balancing efficient in-memory data access and manipulation with robust data integrity and constraint enforcement within a single-process or distributed environment.
3 tradeoffs and 3 stress tests locked
Interview prep
Unlock the interviewer X-Ray rubric, tradeoff matrix, stress tests, clarifying questions, and key concepts.
Design In-Memory Database
Design an in-memory database system. The system should support the following operations:
- Database Management: Create and delete databases.
- Table Management: Create and delete tables within databases.
- Data Operations: Perform
Select,Insert, andDeleteoperations on table records.
A table definition includes columns, each with a type. Supported column types are string (max length 20 characters) and int (range -1024 to 1024). Columns can be marked as required.
Additionally, the system should support:
- Printing all records in a table.
- Filtering and displaying records where column values match a given value.
- Support for constraints on columns.