Category: Database Design for High end Applications

Database Design for High end Applications
UML and Real Time System example

Real Time Maritime Lifeboat System and UML UML example – real time system.  Use Cases, Sequence Diagrams, Class Packages and Architecture example.  UML is necessary to properly elicit Business and IT requirements and system constraints

Read More >>
database indexing framework
Database Design for High end Applications
OLTP, OLAP, Columnar Data Stores – overview

All VLEs (very large enterprises) will have a mix of transaction, analytical and data storage technologies.  ‘Polyglot’ may refer to the variations in the database models used for different use-cases and application demands.  A mainframe

Read More >>
SQL sample database schema
Database Design for High end Applications
Schema, Encoding, JSON, XML

Schema details Application developers who understand the internals of the storage engine (s) within the TOM (target operating model); are in a very good position to build models, schemas and deploy the proper tooling and

Read More >>
database transactions
Database Design for High end Applications
DB Indexing, In-Memory Computing

Building and deploying highly available database systems involve many dimensions.  There are also the considerations of indexing and clustering that this blog post covers. Types of DataStore categories:     DB Indexes and In-Memory Caching

Read More >>
Database Design for High end Applications
Database Design for High end Applications Part 1

Many applications today are data-intensive, not CPU intensive.  Raw unlimited CPU power is rarely an architectural or application limiting phenomenon for most applications.  Raw CPU power is rarely a limiting factor for these applications.  Data

Read More >>