2012 Database Design Storage 
Scalegrid
JULY 17, 2020
Why should a relational database even care about unstructured data? Wave 1: PostgreSQL 9.2 (2012) added support for JSON data type. JSON database in 9.2 It is useful to validate incoming JSON and store in the database. JSONB storage results in a larger storage footprint. JSONB Patterns & Antipatterns.
All Things Distributed
AUGUST 20, 2012
Managing Cold Storage with Amazon Glacier. By Werner Vogels on 21 August 2012 12:01 AM. With the introduction of Amazon Glacier , IT organizations now have a solution that removes the headaches of digital archiving and provides extremely low cost storage. All Things Distributed. Expanding the Cloud â?? Comments ().
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Percona
JUNE 4, 2023
Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.
Percona
JANUARY 14, 2019
What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Processed 4.15
All Things Distributed
JULY 19, 2012
By Werner Vogels on 19 July 2012 12:00 AM. Magnetic disks are rapidly starting to exhibit tape-like properties and with modern workloads being increasingly random, they are becoming less and less suitable as a storage system. Databases are one particular area that for scaling can benefit tremendously from high performance I/O.
SQL Server According to Bob
SEPTEMBER 26, 2016
When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). Our design needed to scale and be adaptable to the modern hardware on the market.
SQL Performance
MAY 1, 2019
The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model. For SQL Server 2012 and earlier , the transition point for this particular table is 898 rows. The thresholds are not dependent on the Cardinality Estimation model in use or the database compatibility level.
Expert insights. Personalized for you.
321 
Let's personalize your content