Databases Resources

Optimize Slow Data Queries With Doris JOIN Strategies

Today, let's dive into the world of JOIN operations in Doris and see how you can transform your queries into "lightning-fast" operations that will impress your boss!

April 7, 2025

by Zen Hua

· 3,215 Views · 2 Likes

Optimizing Natural Language Queries for Multi-Service Information Retrieval

Learn how to optimize natural language queries for orchestrated information retrieval across multiple services using AI, GraphQL, and embedding models.

April 7, 2025

by Abhay Patra

· 3,666 Views · 1 Like

Implementing Infrastructure as Code (IaC) for Data Center Management

Learn the benefits of infrastructure as code (IaC) for data center management and the best strategies for implementing it.

April 7, 2025

by Zac Amos

· 4,446 Views · 2 Likes

Achieving Zero Trust and Air-Gapped IaC in IBM Cloud With Schematics

IBM Cloud Schematics enables secure, automated, and policy-driven IaC deployments in air-gapped environments by enforcing zero-trust principles.

April 4, 2025

by Josephine Eskaline Joyce

CORE

· 5,783 Views · 4 Likes

How Doris Connects to Multiple Databases for Federated Analytics and Data Migration

Learn how to use Apache Doris’s JDBC Catalog to connect multiple databases, enable federated analytics, and migrate data efficiently.

April 4, 2025

by li yy

· 6,030 Views · 2 Likes

When Doris Learns to "Speak Dialects"

The SQL dialect conversion feature of Apache Doris understands more than ten SQL dialects, including Presto, Trino, Hive, and ClickHouse.

April 3, 2025

by Zen Hua

· 4,557 Views · 3 Likes

Problem Analysis in Apache Doris StreamLoad Scenarios

Troubleshoot common Apache Doris StreamLoad import errors, including missing partitions, data type mismatches, and special character issues, for smooth syncing.

April 3, 2025

by li yy

· 6,518 Views · 3 Likes

Lessons from Migrating an Oracle Database to AWS RDS

Migrating an on-prem Oracle database to AWS RDS brings cost savings and automation but comes with performance tuning limits, upgrade challenges, and DBA restrictions.

April 2, 2025

by arvind toorpu

CORE

· 4,669 Views · 3 Likes

AWS CloudTrail Monitoring Using Event-Driven Ansible

Automate AWS CloudTrail event responses with Event-Driven Ansible. Learn how to monitor EC2 actions and trigger workflows for security, compliance, and efficiency.

April 2, 2025

by Binoj Melath Nalinakshan Nair

CORE

· 6,401 Views · 6 Likes

How to Build a New API Quickly Using Spring Boot and Maven

Realizing that not all use Gradle, I thought I would demonstrate how quickly a RESTful API can be created by leveraging ChatGPT, Spring Boot, Maven, and Heroku.

April 1, 2025

by John Vester

CORE

· 51,260 Views · 15 Likes

Understanding SQL Server Query Store: A Comprehensive Guide

In this article, we will explore what the Query Store is, its benefits, scenarios for its use, and steps to implement it with examples.

April 1, 2025

by arvind toorpu

CORE

· 6,720 Views · 8 Likes

Building Scalable Data Lake Using AWS

Build a secure, scalable AWS data lake with S3, Glue, and Lake Formation, and learn key components, best practices, and analytics for optimized insights.

April 1, 2025

by Digvijay Waghela

· 4,792 Views · 3 Likes

Understanding Database Consistency: A Key Concept in Distributed Systems

This article explores database consistency models in distributed systems and explains trade-offs between strong, eventual, causal, and other consistency types.

March 31, 2025

by Sandeep Kumar Gond

· 6,264 Views · 5 Likes

Doris vs Elasticsearch: A Comparison and Practical Cost Case Study

Apache Doris excels in analytics, SQL support, and cost efficiency, while Elasticsearch leads in text search but has higher storage costs and complexity.

March 31, 2025

by Darren Xu

· 3,808 Views · 2 Likes

Stop Exposing Secrets! Secure Your APIs in Postman Like a Pro

Don't expose your secrets! Learn how to secure your APIs in Postman with Vault, Secret Scanner, and best practices to keep your data safe.

March 31, 2025

by Gbadebo Bello

· 4,723 Views · 6 Likes

AWS WAF Classic vs WAFV2: Features and Migration Considerations

AWS WAFV2 is a major upgrade over WAF Classic, offering better scalability, flexibility, and automation. We'll also look at key migration considerations.

March 31, 2025

by Srinivas Chippagiri

CORE

· 20,626 Views · 2 Likes

Product Design vs Platform Design for Software Development

Compare platform and product design approaches for business needs. Understand their differences and compare them to find the best fit for your use case.

March 31, 2025

by Ravi Kiran Mallidi

CORE

· 4,444 Views · 5 Likes

The Role of DevSecOps in Securing Multi-Cloud Architectures

Discover how DevSecOps enhances security in multi-cloud ecosystems, enabling safe implementation and addressing key challenges with effective strategies.

March 31, 2025

by Hrushikesh Deshmukh

· 4,540 Views · 2 Likes

Why Mocking Sucks

Mocking can be risky as it doesn't replicate real-world conditions, making real development versions of services preferable.

March 28, 2025

by Andy Pai

· 4,630 Views · 2 Likes

Using Terraform Moved Block to Refactor Resources

Terraform moved block, introduced in version 1.1.0, provides a straightforward way to refactor resources by explicitly mapping old resource addresses to new ones.

March 28, 2025

by Mariusz Michalowski

· 4,600 Views · 1 Like

The Latest Databases Topics