This article explores a heuristic for writing to databases safely and efficiently.
When AIMMS writes data to a database table, it uses structural information of the database table to determine a safe and efficient strategy for writing.
In this article we discuss:
- An example project
- Foreign key relations
- Available strategies
- Database schema design best practices