âNo Bugsâ Bunny
Representing The Same Data Structure in SQL and NoSQL (from Classical Codd-style SQL to Key-Value NoSQL with SQL-with-XML and Structured NoSQL in between)
December 5, 2016 by ⢠âNo Bugsâ Bunny
Quote:
while duplication MAY indeed improve performance â undue duplication also MAY hit performance pretty badly
Another Quote:
NoSQL will usually call for another denormalisation on top of what weâve described above for SQL-with-XML.
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions
Read moreOLTP. Compiling SQL Bindings.
November 28, 2016 by ⢠âNo Bugsâ Bunny
Quote:
If weâre speaking about millions transactions per day over just a few hundred of different SQL statements â compiling those statements a million times (instead of a few hundred times) will be a dramatic waste of resources.
Another Quote:
Once upon a time, I observed the largest C++ file in my career â it was a 30â000-line file(!) consisting merely of ODBC bindings (and that was just for 300 or so SQL statements)
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions
Read moreHistorical Data in Databases. Audit Tables. Event Sourcing
November 21, 2016 by ⢠âNo Bugsâ Bunny
Quote:
99% of reporting requests and 99.9% of analytics is purely historical
Another Quote:
Information within the audit table should be sufficient to validate/justify current state
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions(Re)Actors
Read moreChoosing RDMBS for OLTP DB
November 14, 2016 by ⢠âNo Bugsâ Bunny
Quote:
As the RDBMS keeps modifying its tables â the tables gradually degrade
Another Quote:
As we can see from the table above â choosing your RDBMS it is not as easy as it might seem.
Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisions
Read more