Category: RDBMS

Truth First, or Why You Should Mostly Implement Database First Designs – Java, SQL and jOOQ.

In this much overdue article, I will explain why I think that in almost all cases, you should implement a “database first” design in your application’s data models, rather than a “Java first” design (or whatever your client language is), the latter approach leading to a long road of pain and suffering, once your project……

Read More

Recovering from a failed LOAD operation

If the load utility does not start because of a user error such as a nonexistent data file or invalid column names, the operation terminates and leaves the target table in a normal state. In such a case, the table is already in normal state and no further action is needed. When the load operation…

Read More