Databases Resources

Enhancing Avro With Semantic Metadata Using Logical Types

Avro logical types add semantic meaning to primitive data types, making schemas more expressive. This blog explores their benefits and common use cases.

April 16, 2025

by Gurmeet Saran

· 6,502 Views · 2 Likes

How to Attach SQL Database Without a Transaction Log File

Learn to attach a SQL database without a log file using SSMS or T-SQL. Follow steps to seamlessly attach your database, even if the log file is missing.

April 15, 2025

by Priyanka Chauhan

· 6,062 Views · 1 Like

A Deep Dive into Apache Doris Indexes

Apache Doris offers various index types, each designed for specific needs. Let’s delve into their features and discover what drives their exceptional performance.

April 14, 2025

by Darren Xu

· 5,902 Views

How Doris + Hudi Turned the Impossible Into the Everyday

Want to know how this "data giant ship" navigates the waves? Follow this article to uncover the amazing story of Doris and Hudi, the "dream team" of data.

April 14, 2025

by Zen Hua

· 5,791 Views · 4 Likes

Transforming Data Analytics by Combining SQL and ML

Learn how AI and ML extend SQL's capabilities for advanced analytics, predictive insights, and query optimization, transforming database interactions.

April 10, 2025

by Ramalakshmi Murugan

· 5,442 Views · 2 Likes

Python Packages for Validating Database Migration Projects

This article analyzes three widely used Python libraries — Pandas, SQLAlchemy, and PyMySQL/psycopg2 — detailing their capabilities, advantages, and limitations.

April 10, 2025

by Vignesh Govindarajan Ravichandran

· 4,127 Views

Unlocking the Power of Serverless AI/ML on AWS: Expert Strategies for Scalable and Secure Applications

Learn how to combine AWS Serverless with AI/ML to build scalable, automated, and intelligent workflows with this practical guide.

April 9, 2025

by Bal Reddy Cherlapally

· 6,575 Views · 1 Like

Context Search With AWS Bedrock, Cohere Model, and Spring AI

In this article, learn how to build a simple Java application using Spring AI and Amazon Bedrock to generate and compare text embeddings with Cohere’s Embed Multilingual v3 model.

April 9, 2025

by Danil Temnikov

CORE

· 73,724 Views · 22 Likes

It's 2025: How Do You Choose Between Doris and ClickHouse?

Doris or ClickHouse? Doris excels in complex SQL analytics, real-time updates, and usability, while ClickHouse offers extreme performance in single-table queries.

April 9, 2025

by Zen Hua

· 5,520 Views · 2 Likes

Spring Boot Sample Application Part 1: Introduction and Configuration

This tutorial covers building a bilingual Spring Boot application for a digital library, detailing setup, database integration, and advanced features like caching and error management.

April 9, 2025

by Liliz EQ

· 4,705 Views · 5 Likes

Building Scalable and Efficient Architectures With ECS Serverless and Event-Driven Design

Learn how to build scalable and efficient architectures using ECS serverless and event-driven design by adopting serverless architecture.

April 9, 2025

by Bal Reddy Cherlapally

· 5,885 Views · 1 Like

AWS S3 Strategies for Scalable and Secure Data Lake Storage

Optimize your Amazon S3 data lake with strategic bucket configurations, data layers, encryption, and lifecycle policies for security, efficiency, and cost savings.

April 8, 2025

by Digvijay Waghela

· 6,895 Views

Evaluating Performance Gains in MySQL Lock Scheduling Algorithms

This article shows that MySQL’s CATS algorithm offers only a small performance gain over FIFO once deadlock logging interference is removed.

April 8, 2025

by Bin Wang

· 5,219 Views · 1 Like

Optimizing Data Storage With Hybrid Partitioned Tables in Oracle 19c

Learn how to implement Hybrid Partitioned Tables (HPT) to streamline data management, boost query performance, and cut storage costs.

April 8, 2025

by arvind toorpu

CORE

· 4,034 Views · 3 Likes

Why Rate Limiting Matters in Istio and How to Implement It

In this post, we’ll explore why rate limiting is important in Istio and show you how to set it up effectively.

April 8, 2025

by Josephine Eskaline Joyce

CORE

· 7,420 Views · 9 Likes

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

· 2,968 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,306 Views · 1 Like