On.System Architecture

System Architecture (and it’s subfield Software Architecture) is a discipline which is surprisingly poorly covered. In a sense, it is still more an art than a science, and usually requires somebody intimately familiar with practical systems, to tell what’s to do and what’s to avoid when building a system.

IT Hares have lots of experience in both Software Architecture and more general System Architecture, and are trying to share their knowledge (and more importantly, their feelings) about them.

Determinism: Requirements vs Features

December 26, 2016 by “No Bugs” Bunny

Determinism: Requirements vs Features - Post preview image

Abstract:

Apparently, in practice there is big difference between cross-platform determinism and same-executable determinism, both in abilities they can provide, and from implementation complexity point of view

Quote:

Cross-platform determinism is the strictest definition of determinism I know; not surprisingly, there are quite a few factors which can break it

Filed under: On.System Architecture(Re)ActorsOn.ProgrammingTips and Tricks

Read more

Gradual OLTP DB Development - from Zero to 10 Billion Transactions per Year and Beyond

December 13, 2016 by “No Bugs” Bunny

Gradual OLTP DB Development - from Zero to 10 Billion Transactions per Year and Beyond - Post preview image

Quote:

to make an efficient representation usable for OLAP – we need to modify our data on its way to OLAP replicas

Another Quote:

Each of the DB Server Apps is a replica master, but all replica targets are within the same Replica DB

Filed under: Book: D&D of MOGs1st beta of Vol. IV-VIOn.System ArchitectureDesign decisionsDistributed systems(Re)Actors

Read more

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

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) - Post preview image

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 more

OLTP. Compiling SQL Bindings.

November 28, 2016 by “No Bugs” Bunny

OLTP. Compiling SQL Bindings. - Post preview image

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 more