Question : Recently I’m learning concurrency control techniques in transactional databases. However, I am so confused about the differences between […]
Tag: consistency
what is an Assert in Database world?
Question : I searched for Assert and found general explanations: Assertion (software development) In computer programming, an assertion is a […]
SQL Server backup versus third party snapshot based backup using VSS
Question : Is it safe to assume that SQL Server instance or database level backup to a NAS share or […]
Data inconsistency prohibition if a table refers to another via two many-to-many relationships
Question : I have following database design (by => foreign key constraints are depicted): Company[id] CompanyRealm[id, company_id=>Company.id]many2many Project[id, company_id=>Company.id] ProjectRealm[id, […]
Is it safe to insert the newest row with SELECT INTO?
Question : Trying to keep rows consistent then referencing previous rows. CREATE TABLE transactions ( id int PRIMARY KEY GENERATED […]
what is an Assert in Database world?
Question : I searched for Assert and found general explanations: Assertion (software development) In computer programming, an assertion is a […]
Data inconsistency prohibition if a table refers to another via two many-to-many relationships
Question : I have following database design (by => foreign key constraints are depicted): Company[id] CompanyRealm[id, company_id=>Company.id]many2many Project[id, company_id=>Company.id] ProjectRealm[id, […]
Optimize queries that need to be 100% ACID compliant but can tolerate latency in persistence
Question : Introduction I’m writing a trading program in C++. The program involves having user balances and orderbooks. The orderbook […]
Optimize queries that need to be 100% ACID compliant but can tolerate latency in persistence
Question : Introduction I’m writing a trading program in C++. The program involves having user balances and orderbooks. The orderbook […]
SQL Server backup versus third party snapshot based backup using VSS
Question : Is it safe to assume that SQL Server instance or database level backup to a NAS share or […]
- 1
- 2