Snowflake, a quick overview, from their documentation and some project usage experience. Snowflake is a columnar data warehouse and data integration platform SaaS hosted on AWS, GCP, or Azure. Snowflake Use Cases include: Session Data,
AWS RDS is a managed DBaaS. Amazon RDS is a web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for
Monolithic applications are designed to handle multiple related tasks. They’re typically complex applications that encompass several tightly coupled functions. You don’t need to, nor will you, ‘containerise’ every single application. Depending on the use
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
What is Amazon Athena? Amazon Athena is a cloud-based query service for large-scale data analysis. Buyers of the product can use standard SQL to prepare and analyse their datasets or integrate with other business
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
Database Types and their Use Cases summarised in a Table Database Type Examples Pros Cons Use cases Relational Databases Oracle, MySQL, SQL, DB2 etc. Organize data into tables with columns, each with a specified
Databases and different data varieties and structures: Relational or SQL, NoSQL, Graph. Given the wide variety of data sources, data processes and use cases around data, including ‘Big Data’ it is necessary to understand
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
