ConnectOS

ReadOS / Technology

Digital Systems and Integration — Part 2

Software systems, integrations, infrastructure and engineering technology choices.

24 chapters · About 265 minutes · Free to read

Start reading →
KEVOS / READOSTECHNOLOGYDigital Systems andIntegration — Part2READOS COLLECTION

Contents

  1. 01Managing reference codes as changing business dataDesign lookup values with stable meaning, ownership, effective dates and migration rules so that changing codes do not silently rewrite operational history.
  2. 02Materialised views and reporting freshnessDesign stored reporting results with clear refresh rules, source watermarks and reconciliation checks, including the limits of incremental maintenance.
  3. 03Nearest-neighbour search and meaningful similarityDesign similarity searches by choosing useful features, distance rules and filters, then assessing exactness, recall and the meaning of returned neighbours.
  4. 04No universally best option: how context and scale change the right technology choiceElectric, renewable or bigger can be right in one setting and wrong in another. How energy supply, use, logistics and scale reverse rankings, and how to test choices against context.
  5. 05Optimistic concurrency for long-lived user editsProtect database records edited across separate requests by checking versions atomically, defining conflict scope and preserving users' work when changes collide.
  6. 06Organising CAD callouts with multileadersUse multileader styles, shared notes and numbered callouts to make CAD annotations easier to read, arrange and review when drawing geometry changes.
  7. 07Organising CAD drawings with layers and propertiesUse layers to organise drawing information, control appearance consistently and make editing and output easier for the next person who opens the file.
  8. 08Organising CAD projects with sheet setsOrganise drawing layouts into a coherent sheet set, with clear numbering, useful subsets and a review process that keeps published issues consistent.
  9. 09Owning your website and digital presence: domains, hosting, security, backups and professional emailDigital foundations for small businesses: owning a website not just social pages, choosing and protecting domains, hosting, HTTPS, backups, professional email and partners.
  10. 10Parameterised queries and safe dynamic searchHow to keep search values separate from SQL instructions, handle optional filters and sort choices, and test database queries without breaking legitimate customer data.
  11. 11Preparing CAD files for a reliable handoverPackage CAD drawings with the references, plotting information and revision notes recipients need, then test the actual package before handing it over.
  12. 12Preserving historical classifications in reporting dimensionsHow to report by the classifications that applied when an event happened, distinguish corrections from changes, and assign late records to the right dimension version.
  13. 13Privacy policies for small business websites and apps: what to include and why it matters in AustraliaWhat a website or app privacy policy should cover, how the Australian Privacy Act and its principles apply to small businesses, cookies and analytics, overseas transfers, data security and complaints.
  14. 14Proving a new technology is ready to depend on: beyond the best resultA strong demonstration shows a technology can work, not that it will keep working in your conditions. How to test variation, degradation, maintenance and fit before you rely on it.
  15. 15Reconciling offline records after reconnectionDesign offline data capture around provisional work, durable local records, conflict rules and clear reconciliation when devices reconnect to shared systems.
  16. 16Recursive queries for component structuresHow to traverse multi-level component relationships, multiply quantities along each path, preserve shared components and detect cycles before trusting a materials total.
  17. 17Reporting through ragged and shared-parent hierarchiesDesign reliable roll-ups when reporting hierarchies have uneven depth, shared membership or changing parents, with explicit attribution and reconciliation rules.
  18. 18Setting up CAD drawings with consistent unitsChoose clear drawing units, separate model size from sheet scale and build a tested template that gives new CAD drawings a dependable starting point.
  19. 19Soft deletion, uniqueness and record lifecycleDesign logical deletion around record identity, active uniqueness, historical relationships, restoration and eventual removal instead of relying on a flag alone.
  20. 20Standardising repeated CAD work with tool palettesUse tool palettes and small recorded actions to make repeated CAD work consistent, with clear defaults, dependable source files and practical checks.
  21. 21Testing business software that holds important data: test data, calculations, permissions and acceptanceData-heavy business systems fail in predictable places: calculations, dates, rounding, permissions and volume. How to plan tests, prepare data and run acceptance testing.
  22. 22Text encoding, collation and reliable record matchingWhy identical-looking names can compare differently, how text encoding and collation affect database matches, and how to migrate comparison rules without merging distinct records.
  23. 23Tracing report figures through data lineageHow to trace a reported number through source records, transformations and loading runs, investigate disagreements and assess the impact of changing a data definition.
  24. 24Transaction isolation and concurrent business decisionsUnderstand why individually valid database transactions can conflict, how isolation affects business rules, and how to test concurrent decisions and retries.

All chapters preserve the original KEVOS Insights content. These topic-based reading collections are organised alphabetically; chapters may be read in any order.

← All books