Category: Database Design for High end Applications

Database Design for High end Applications
Database Backup Simple Overview

There are many alternatives to backing up a database.   A summary is given below. Database Backup Solutions Database backup solutions are two kinds: Database Backup Native Solutions Database Backup 3rd Party Solutions But there is

Read More >>
Application Transformation
Big Data. Benefits. Challenges.

Most Big Data projects fail.  There are many reasons for this, usually around the business reason for the project, and data quality (along with a lack of skills).  A key part of ‘Cloud Transformation’ is

Read More >>
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 >>