Scalegrid

MAY 13, 2020

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. What is an MPP Database?

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Abhishek Tiwari

DECEMBER 13, 2017

This is a question recently asked and explored by a team of Google researchers led by Jeff Dean with a major focus on database indexes. This has far-reaching implications how future data systems and algorithms will be designed. Can machine learning-based data structures i.e. learned data structures replace traditional data structures?

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Instead of worrying about infrastructure management functions, such as capacity provisioning and hardware maintenance, teams can focus on application design, deployment, and delivery.

Serverless 283

Serverless AWS Lambda Storage 283

Dotcom-Montior

NOVEMBER 27, 2018

Additionally, end users can access your site or applications from anywhere in the world using different browsers, operating systems, and mobile devices, all with varying connection speeds. Analyzing server performance (CPU, memory, bandwidth, disk I/O) and database response times. LoadView – Best Practices and Process.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

All Things Distributed

JULY 13, 2010

Cluster Computer Instances for Amazon EC2 are a new instance type specifically designed for High Performance Computing applications. During my academic career, I spent many years working on HPC technologies such as user-level networking interfaces, large scale high-speed interconnects, HPC software stacks, etc. until today.

Cloud 119

Cloud AWS Automotive Latency 119

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read. Requirements.

Database 106

Database AWS Network Design 106

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. Gen 5 is the primary hardware option now for most regions since Gen 4 is aging out. HyperScale Database.

Azure 55

Azure Database Serverless Hardware 55

All Things Distributed

JULY 14, 2015

I am excited to share with you that today we are expanding DynamoDB with streams, cross-region replication, and database triggers. In traditional database architectures, database engines often run a small search engine or data warehouse engines on the same hardware as the database.

Database 167

Database Lambda AWS IoT 167

KeyCDN

FEBRUARY 22, 2023

PWAs are designed to work offline, be fast, and provide a seamless user experience across different devices. Motion UI Motion UI is a design trend involving animation and other interactive elements to create a more dynamic and engaging user experience. They thus adapt to the user's browser, screen size, and device specifications.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. HammerDB is a software application for database benchmarking. What is HammerDB? Why HammerDB was developed.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

SQL Server According to Bob

JULY 13, 2016

desktop machine (I won’t tell you the hardware details. Don’t worry about taking screenshots or speed reading. So the initial time to run this all depends on your network speed. This option is not necessarily designed to save the setup files for use for subsequent basic installer setup. Go install it”. on my Windows NT 3.1

Servers 40

Servers Media Engineering Virtualization 40

O'Reilly

NOVEMBER 28, 2023

If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” And there are tools for archiving and indexing prompts for reuse, vector databases for retrieving documents that an AI can use to answer a question, and much more. of users and 3.9% of nonusers.

Open Source 108

Open Source Artificial Intelligence Google Infrastructure 108

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes. Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Percona

SEPTEMBER 1, 2023

Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. mongos --configdb <configReplSetName>/<cfg1.example.net:27019>,<cfg2.example.net:27019>,<cfg3.example.net:27019>

Best Practices 71

Best Practices Traffic Database Servers 71

All Things Distributed

MARCH 19, 2018

So, when designing Amazon SageMaker we took on a challenge: to build machine learning algorithms that can handle an infinite amount of data. This post lifts the veil on some of the scientific, system design, and engineering decisions we made along the way. What does that even mean though? This sounds like a pipe dream.

Scalability 160

Scalability Hardware AWS Tuning 160

Alex Podelko

SEPTEMBER 8, 2020

As you can import HAR files from any browser/proxy into OctoPerf and design your script in our UI, we thought the focus on JMeter wasn’t required. We do a lot of 1-hour sessions with our customers to get them up to speed and that usually enough time to have a first basic test on their application. Do you see it as a threat to OctoPerf?

Open Source 223

Open Source Performance Testing Testing Performance 223

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. First released in 2009, it is the most used NoSQL database and has been downloaded more than 325 million times. The bigger the database, the bigger the damage from a leak. This can leave your database instances exposed and vulnerable.

Database 80

Database Servers Storage Strategy 80

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. speeds up scans, . OLTP vs OLAP. Let’s get back to basics. drill-down. Getting it.

Database 92

Database Analytics Storage Processing 92

The Morning Paper

SEPTEMBER 19, 2019

MongoDB is an important database, and this paper explains the tunable (per-operation) consistency models that MongoDB provides and how they are implemented under the covers. Microsoft have a paper describing their new recovery mechanism in Azure SQL Database , the key feature being that it can recovery in constant time. Yes please!

Blockchain 46

Blockchain Hardware Google Analytics 46

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario. Esv3-series.

Azure 72

Azure Virtualization Servers Storage 72

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Percona

AUGUST 29, 2023

Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables. Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. citus_columnar | 11.1-1

C++ 79

C++ Database Storage Testing 79

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). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Abhishek Tiwari

DECEMBER 27, 2017

ETL is a product of the relational database era and it has not evolved much in last decade. Both Alluxio and Apache Arrow are designed to enable the data interoperability between existing big data frameworks by being a common interface for high-performance in-memory access however the approach is different.

Big Data 49

Big Data Artificial Intelligence Storage Hardware 49

Alex Russell

MARCH 6, 2021

Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version. Recall that single-core performance most directly translates into speed on the web. Mind The Gap. Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? This is different from ​​ the reference count design ​​ that was ​​ used in SQL Server 7.0

Servers 40

Servers Cache Database Media 40

Alex Russell

JUNE 20, 2020

built-in relational SQL database engines. In each quantum of time, hardware and OS vendors press ahead, adding features. As OS and hardware deployed base integrate these components, the set of what most computers can do is expanded. This is often determined by hardware integration and device replacement rates.

Hardware 55

Hardware Games Java Media 55

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. In order to speed up the benchmark indexes must be added.

Database 105

Database Benchmarking Latency C++ 105

SQL Performance

MARCH 8, 2021

The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. This uses hardware, typically a crystal oscillator, that produces ticks at a very high constant rate regardless of processor speed, power settings, or anything of that nature.

Servers 95

Servers Tuning Architecture Processing 95

All Things Distributed

NOVEMBER 15, 2016

They require companies to provision and maintain complex hardware infrastructure and invest in expensive software licenses, maintenance fees, and support fees that cost upwards of thousands of dollars per user per year. Customers can visualize their data by picking a table and then getting to a visualization in just a few clicks.

Analytics 152

Analytics Availability Media Social Media 152

Smashing Magazine

JANUARY 6, 2020

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Looking back now, things seem to have changed quite significantly. Large preview ). Large preview ).

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

Performance isn’t just a technical concern: it matters, and when baking it into the workflow, design decisions have to be informed by their performance implications. You need a business stakeholder buy-in, and to get it, you need to establish a case study on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about.

Performance 103

Performance Cache Metrics Network 103

High Scalability

NOVEMBER 25, 2019

To help our customers manage ongoing data explosion, we have designed many of the core components over the last few years. To add elasticity, reliability and durability, these data centers are connected to Google Cloud platform using high speed, secure Google Interconnect network. How much upfront design should you do?

Architecture 52

Architecture Cache Azure Storage 52