The many ways to insert data and why they matter
Business semantics “Just insert the data!” has a very different meaning depending on your field, and it is sometimes frustrating to get the proper behavior from your DataBase Management System (DBMS). For example, in investment banking, you may want to keep all the versions and have (partial) duplicates, whereas, in manufacturing, duplicates may be undesired. […]