BestHub
Sign in
Tagged articles

database

2754 articles · Page 27 of 28
dbaplus Community
dbaplus Community
Nov 20, 2016 · Operations

Top Insights from the 2016 Global Agile Operations Summit

The 2016 Global Agile Operations Summit in Shanghai concluded with a series of expert sessions covering agile DevOps trends, cloud‑native automation platforms, database performance tuning, container orchestration, and real‑world case studies from leading companies, followed by the award ceremony honoring ten MVPs who drove innovation across operations and infrastructure.

Cloud ComputingDevOpsMVP
0 likes · 15 min read
Top Insights from the 2016 Global Agile Operations Summit
Architects' Tech Alliance
Architects' Tech Alliance
Nov 19, 2016 · Databases

An Overview of Greenplum Database Architecture and Core Components

Greenplum is an open‑source, massively parallel processing (MPP) database built on PostgreSQL, offering ANSI‑SQL compliance, distributed ACID transactions, linear scalability, polymorphic storage, advanced optimizers, and extensive ecosystem integrations, making it suitable for large‑scale data warehousing, analytics, and big‑data workloads.

Data WarehousingGreenplumMPP
0 likes · 15 min read
An Overview of Greenplum Database Architecture and Core Components
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Nov 15, 2016 · Databases

How to Set Up Redis Master‑Slave Replication in Minutes

This guide walks you through configuring a simple Redis master‑slave setup, covering the benefits, step‑by‑step file modifications, essential replication directives, testing procedures, and common pitfalls to ensure high availability and read/write separation.

ConfigurationMaster-Slave ReplicationRedis
0 likes · 5 min read
How to Set Up Redis Master‑Slave Replication in Minutes
ITPUB
ITPUB
Nov 13, 2016 · Databases

Why Oracle DBMS_JOB Shows Next Date 4000‑01‑01 and How to Fix It

When an Oracle DBMS_JOB’s NEXT_DATE jumps to the far‑future date 4000‑01‑01, it indicates the job has failed repeatedly and been marked broken; this article explains the underlying reasons, examines error logs, and provides step‑by‑step commands to diagnose and restart the job.

DBMS_JOBJob SchedulingOracle
0 likes · 5 min read
Why Oracle DBMS_JOB Shows Next Date 4000‑01‑01 and How to Fix It
ITPUB
ITPUB
Nov 11, 2016 · Databases

Essential Oracle SQL Queries for Performance Monitoring and Troubleshooting

This guide compiles a comprehensive set of Oracle SQL statements and explanations for detecting fragmented tables, index fragmentation, high clustering factor tables, session and process mapping, DML lock analysis, DDL lock inspection, active SQL tracking, resource usage statistics, and various performance‑related metrics, helping DBAs diagnose and tune database behavior efficiently.

AdministrationOraclePerformance
0 likes · 26 min read
Essential Oracle SQL Queries for Performance Monitoring and Troubleshooting
dbaplus Community
dbaplus Community
Nov 10, 2016 · Databases

Doubling SQL Speed: From Execution Plans to Business Logic Overhaul

A real‑world case study shows how a seemingly simple intersect query that took 20 seconds was optimized to 10 seconds by analyzing execution plans, rewriting the SQL, exploring parallel execution, and ultimately redesigning the business logic with a new timestamp column to enable incremental checks.

Performance OptimizationSQLbusiness logic
0 likes · 10 min read
Doubling SQL Speed: From Execution Plans to Business Logic Overhaul
ITPUB
ITPUB
Nov 9, 2016 · Databases

Step‑by‑Step Guide to Downgrade Oracle Database 12c to Earlier Releases

This guide provides a comprehensive checklist and scripted procedure for safely downgrading Oracle Database 12c (Standard or Enterprise Edition) to prior releases such as 11.2.0.3, 11.2.0.2, or 11.1.0.7, covering prerequisites, command‑line steps, post‑downgrade validation, and common pitfalls.

12cOracleSQL
0 likes · 13 min read
Step‑by‑Step Guide to Downgrade Oracle Database 12c to Earlier Releases
ITPUB
ITPUB
Nov 8, 2016 · Databases

40+ Essential Oracle SQL Queries Every DBA Should Know

This article compiles over forty practical Oracle SQL queries covering date manipulation, server information, data dictionary lookups, database administration, performance monitoring, and utility functions, providing developers with ready-to-use commands to streamline everyday database tasks.

AdministrationOracleQueries
0 likes · 16 min read
40+ Essential Oracle SQL Queries Every DBA Should Know
ITPUB
ITPUB
Nov 3, 2016 · Databases

Why Nested Subqueries Slow Down Your SQL Queries and How to Diagnose Them

The article recounts a real‑world incident where a complex SQL query took over 20 seconds, explains how to pinpoint whether the slowdown originates from joins or nested subqueries, and shares practical steps and insights for diagnosing and fixing such performance issues.

OptimizationPerformanceSQL
0 likes · 6 min read
Why Nested Subqueries Slow Down Your SQL Queries and How to Diagnose Them
dbaplus Community
dbaplus Community
Nov 3, 2016 · Databases

Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization

A detailed case study describes how a rapidly growing edit‑log feature caused query times to soar to 30 seconds, and walks through the step‑by‑step investigation, identification of a custom function bottleneck, data‑volume analysis, and the eventual implementation of partitioning, mandatory time filters, and composite indexing to restore acceptable performance.

PL/SQLPartitioningSQL
0 likes · 12 min read
Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization
ITPUB
ITPUB
Oct 28, 2016 · Databases

Step‑by‑Step Oracle Data Guard Switchover and Failover Guide

This article provides a detailed, hands‑on walkthrough of Oracle Data Guard switchover in normal operation and the subsequent steps to convert the original primary to a standby, including all necessary SQL commands, instance restarts, and verification queries.

Data GuardOracleSQL
0 likes · 6 min read
Step‑by‑Step Oracle Data Guard Switchover and Failover Guide
ITPUB
ITPUB
Oct 27, 2016 · Databases

Mastering Oracle Permission Views: Query Roles, Privileges, and Sessions

This guide explains the most commonly used Oracle permission‑view tables, shows how to list role assignments, object privileges, system privileges, session privileges, and role memberships, and demonstrates the impact of the WITH ADMIN OPTION through practical SQL examples.

DBAOracleSQL
0 likes · 7 min read
Mastering Oracle Permission Views: Query Roles, Privileges, and Sessions
dbaplus Community
dbaplus Community
Oct 25, 2016 · Databases

Master MySQL: Essential Database Operations, Table Management, and Index Optimization

This guide walks through MySQL fundamentals—including viewing, creating, and using databases, managing users and privileges, creating and altering tables, inserting, updating, deleting, and querying data, as well as index types, best‑practice tips, and execution‑plan analysis—providing concrete commands and examples for each step.

MySQLSQLTable
0 likes · 14 min read
Master MySQL: Essential Database Operations, Table Management, and Index Optimization
ITPUB
ITPUB
Oct 23, 2016 · Databases

Essential MongoDB Interview Questions & Answers You Need to Master

This comprehensive guide presents the most common MongoDB interview questions, covering NoSQL fundamentals, replication, sharding, transactions, profiling, storage nuances, and operational details, providing concise yet thorough answers to help candidates confidently tackle technical interviews.

MongoDBNoSQLReplication
0 likes · 11 min read
Essential MongoDB Interview Questions & Answers You Need to Master
ITPUB
ITPUB
Oct 19, 2016 · Databases

Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes

This article demonstrates how InnoDB returns rows in primary‑key order during full‑table scans, while queries that use a secondary index follow the leaf‑node order of that index, and it compares performance implications of index‑only scans versus clustered‑index scans.

InnoDBMySQLQuery Optimization
0 likes · 12 min read
Why InnoDB Returns Rows in Primary‑Key Order When Scanning Without Indexes
ITPUB
ITPUB
Oct 15, 2016 · Databases

Mastering Redis: Data Types, Memory Tweaks, and Persistence Strategies

This article explains Redis's five core data types, their internal representations and typical commands, details memory‑saving parameters for each type, compares the four persistence methods with their trade‑offs, and offers practical recommendations for optimal performance and stability.

Data TypesMemory OptimizationRedis
0 likes · 16 min read
Mastering Redis: Data Types, Memory Tweaks, and Persistence Strategies
ITPUB
ITPUB
Oct 12, 2016 · Databases

34 Proven Oracle SQL Tricks to Boost Query Performance

This guide compiles 34 practical Oracle SQL optimization techniques—from selecting the optimal table order and rewriting WHERE clauses to leveraging indexes, avoiding costly operators, and fine‑tuning execution plans—helping developers dramatically reduce query execution time and resource consumption.

OptimizationOraclePerformance
0 likes · 19 min read
34 Proven Oracle SQL Tricks to Boost Query Performance
ITPUB
ITPUB
Oct 11, 2016 · Databases

How to Secure Oracle RMAN Backups with Password, Wallet, and Hybrid Encryption

This guide explains why backup security is critical for enterprise databases, introduces Oracle RMAN's three encryption strategies, and provides step‑by‑step commands to configure password‑based encryption, perform backups, handle decryption errors, and finally disable encryption safely.

OracleRMANbackup
0 likes · 9 min read
How to Secure Oracle RMAN Backups with Password, Wallet, and Hybrid Encryption
ITPUB
ITPUB
Oct 11, 2016 · Databases

How a Simple MySQL UPDATE Solved a Multi‑Threaded Counting Problem

A developer recounts how a seemingly trivial MySQL UPDATE statement—‘UPDATE table_name SET sum = sum + 5 WHERE id = 1’—proved thread‑safe for aggregating file counts across a multi‑threaded module, highlighting the importance of knowledge reserves and cautious evaluation before implementing complex synchronization solutions.

MySQLSQLThread Safety
0 likes · 5 min read
How a Simple MySQL UPDATE Solved a Multi‑Threaded Counting Problem
ITPUB
ITPUB
Oct 8, 2016 · Databases

Mastering Database Sharding, Replication, and High‑Availability Strategies

This article explains core database concepts such as sharding, replication, routing strategies, and high‑availability designs, detailing how to achieve read/write separation, cache integration, and consistency handling in a master‑slave architecture for large‑scale systems.

Read-Write SeparationReplicationdatabase
0 likes · 8 min read
Mastering Database Sharding, Replication, and High‑Availability Strategies
ITPUB
ITPUB
Oct 5, 2016 · Databases

How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools

This guide walks through exporting Oracle PL/SQL user objects and table data with PL/SQL Developer, then restoring them by dropping the existing user, recreating it with necessary privileges, executing the exported SQL script, and importing table data while handling constraints and triggers.

ExportOraclePL/SQL
0 likes · 5 min read
How to Backup and Restore Oracle PL/SQL User Objects Using Export/Import Tools
ITPUB
ITPUB
Sep 28, 2016 · Databases

How to Diagnose and Repair Bad Blocks in Oracle Databases

This guide explains what Oracle bad blocks are, how they affect the database, common causes, methods to detect them, and step‑by‑step recovery techniques—including full datafile restore, RMAN block recovery, ROWID range scans, EVENT 10231, and DBMS_REPAIR—plus pre‑emptive detection tools.

Bad BlocksDBMS_REPAIROracle
0 likes · 10 min read
How to Diagnose and Repair Bad Blocks in Oracle Databases
MaGe Linux Operations
MaGe Linux Operations
Sep 19, 2016 · Databases

Master Redis Cluster Setup: From Basics to Scaling Nodes

Learn how to build and manage a Redis cluster on Linux, covering the rationale for clustering, hash slot mechanics, node configuration, adding/removing nodes, resharding, and integrating master‑slave replicas, with step‑by‑step commands and practical examples.

ClusterDevOpsLinux
0 likes · 11 min read
Master Redis Cluster Setup: From Basics to Scaling Nodes
dbaplus Community
dbaplus Community
Sep 18, 2016 · Databases

Master Oracle Hierarchical Queries: From Basics to Advanced Techniques

This article provides a comprehensive guide to Oracle hierarchical queries, covering fundamental concepts, key clauses and operators, practical examples with the s_emp table, advanced features like SYS_CONNECT_BY_PATH, CONNECT_BY_ISLEAF, NOCYCLE, and real‑world use cases such as reporting, pruning branches, and calculating aggregates in tree structures.

CONNECT BYHierarchical QueryOracle
0 likes · 25 min read
Master Oracle Hierarchical Queries: From Basics to Advanced Techniques
Efficient Ops
Efficient Ops
Sep 17, 2016 · Databases

How LeTV Built a Scalable Docker‑Powered RDS Platform

This article examines the limitations of traditional database provisioning, explains why a platform‑based RDS solution is needed, and details LeTV's evolution of its cloud‑native RDS service—including Docker containerization, architecture upgrades, elastic scaling, monitoring, and lessons learned—providing a comprehensive guide for building efficient, automated database platforms.

DockerRDSdatabase
0 likes · 25 min read
How LeTV Built a Scalable Docker‑Powered RDS Platform
Node Underground
Node Underground
Sep 12, 2016 · Databases

How to Keep Your Database Clean During Integration Tests?

When writing integration tests that involve database operations, developers must ensure that test execution does not pollute the original data, and the article explores strategies such as using transaction rollbacks, recreating databases, and mocking database interfaces to maintain data integrity.

Backend DevelopmentIntegration TestingMocking
0 likes · 2 min read
How to Keep Your Database Clean During Integration Tests?
dbaplus Community
dbaplus Community
Sep 1, 2016 · Databases

Master MySQL Optimization: Essential Commands, Logs, and Tools

This guide walks through practical MySQL optimization steps, including status checks, variable inspection, slow‑query and general‑log configuration, essential management commands, detailed mysqldump usage, mysqldumpslow analysis, and the mysqlsla utility for performance diagnostics.

MySQLOptimizationSQL
0 likes · 8 min read
Master MySQL Optimization: Essential Commands, Logs, and Tools
ITPUB
ITPUB
Aug 31, 2016 · Databases

Lock‑Free Transactions and Cache Switching: MVCC Techniques for Key‑Value Stores

This article explains how traditional ACID transactions fall short for modern large‑scale systems and presents lock‑free transaction methods, atomic and partial cache‑switch techniques, and a PostgreSQL‑style MVCC model for key‑value databases, including practical rules and trade‑offs.

Key-ValueMVCCTransactions
0 likes · 10 min read
Lock‑Free Transactions and Cache Switching: MVCC Techniques for Key‑Value Stores
dbaplus Community
dbaplus Community
Aug 3, 2016 · Databases

How to Build a Minimal Relational Database from Scratch

This article explains the theoretical foundations of relational databases, outlines the essential storage, engine, and UI layers, and walks through a concrete minimal implementation using fixed‑length tables, B+‑tree indexes, simple SQL parsing with regular expressions, and a TCP‑based client interface.

B+ TreeSQL parsingdatabase
0 likes · 12 min read
How to Build a Minimal Relational Database from Scratch
Architect
Architect
Jul 25, 2016 · Databases

Analysis of MySQL Network Communication Protocol (MySQL 5.7)

This article examines MySQL's network communication stack—from the high‑level MySQL packet protocol down to the socket layer—detailing session creation, NET/VIO handling, result‑set transmission, metadata overhead, and performance measurements using MySQL 5.7.

MySQLMySQL5.7Performance
0 likes · 10 min read
Analysis of MySQL Network Communication Protocol (MySQL 5.7)
Efficient Ops
Efficient Ops
Jul 17, 2016 · Operations

Why Oracle RAC Node Reboots Repeatedly? Time Sync, Heartbeats & Hardware Fixes

This article details a step‑by‑step investigation of a two‑node Oracle RAC environment where node 2 repeatedly rebooted, covering time‑synchronization checks, database and network heartbeat analysis, hardware diagnostics, and the final resolution through firmware and memory replacement.

RACTroubleshootingdatabase
0 likes · 7 min read
Why Oracle RAC Node Reboots Repeatedly? Time Sync, Heartbeats & Hardware Fixes
ITPUB
ITPUB
Jul 13, 2016 · Databases

MySQL Query Optimization vs Caching: Which Wins in a Greenfield Project?

This article compares MySQL query optimization and caching for a greenfield project, outlining their respective advantages and disadvantages, and concludes with guidance on when to prioritize database tuning over cache implementation.

MySQLOptimizationPerformance
0 likes · 6 min read
MySQL Query Optimization vs Caching: Which Wins in a Greenfield Project?
21CTO
21CTO
Jun 16, 2016 · Backend Development

How We Transformed a Legacy System’s Performance: Real‑World Code‑Level Optimizations

This article walks through a real‑world project's performance evolution, detailing server specs, a litany of scalability and reliability problems, and concrete code‑level solutions such as database deadlock mitigation, transaction shortening, thread‑pool redesign, and logging improvements.

BackendJavaPerformance Optimization
0 likes · 11 min read
How We Transformed a Legacy System’s Performance: Real‑World Code‑Level Optimizations
Java High-Performance Architecture
Java High-Performance Architecture
Jun 9, 2016 · Databases

Discover MySQL 5.7: 9 Powerful New Features You Must Know

MySQL 5.7 introduces major enhancements such as native JSON support, an expanded Performance Schema, a new SYS Schema for health monitoring, improved security, advanced GIS capabilities, three‑fold query throughput gains, InnoDB optimizations, multi‑source replication, and a smarter optimizer with dynamic costing.

GISInnoDBJSON
0 likes · 3 min read
Discover MySQL 5.7: 9 Powerful New Features You Must Know
Architecture Digest
Architecture Digest
Jun 7, 2016 · Databases

Curated List of MongoDB Learning Resources

This article provides a curated collection of online MongoDB learning resources, including the official website, Chinese community, issue tracker, blogs, and various tutorial sites such as Shiyanlou, imooc, Yiibai, Runoob, and others for developers seeking comprehensive database education.

Learning ResourcesMongoDBNoSQL
0 likes · 2 min read
Curated List of MongoDB Learning Resources
Tencent Music Tech Team
Tencent Music Tech Team
May 27, 2016 · Databases

Cross‑IDC Disaster Recovery Solution for KV Storage via a Proxy Layer

The article proposes a cross‑IDC disaster‑recovery architecture for key‑value stores that uses a storage proxy layer to record write logs in the primary data center, forward them to a read‑only backup center for replay, and route reads via load‑balancing, while noting current limitations such as complex configuration, low synchronization concurrency, and lack of multi‑write support.

KV storagecross-IDCdatabase
0 likes · 4 min read
Cross‑IDC Disaster Recovery Solution for KV Storage via a Proxy Layer
ITPUB
ITPUB
May 25, 2016 · Databases

Mastering Redis Replication: Features, Mechanics, and Deployment Guide

Redis replication offers high‑availability through master‑slave syncing, supporting multiple slaves, cascading replication, non‑blocking data transfer, read‑write separation, and optional disk‑less sync, with detailed steps for configuration, safety considerations, partial resynchronization, and practical deployment examples.

Master‑SlaveRedisReplication
0 likes · 8 min read
Mastering Redis Replication: Features, Mechanics, and Deployment Guide
Big Data and Microservices
Big Data and Microservices
May 11, 2016 · Backend Development

How to Build a Scalable Flash‑Sale System that Handles Massive Traffic

This article analyzes flash‑sale (抢购) business scenarios, outlines a layered architecture separating business and data layers, explains decoupling front‑end pressure, uses Redis‑based queues and caching to manage high‑frequency inventory checks, and describes multi‑party reconciliation mechanisms to ensure reliable stock consistency under extreme load.

RedisSystem Designbackend architecture
0 likes · 11 min read
How to Build a Scalable Flash‑Sale System that Handles Massive Traffic
MaGe Linux Operations
MaGe Linux Operations
May 10, 2016 · Operations

10 Essential Practices to Prevent Operational Failures in Database Management

This article outlines ten practical guidelines for operations engineers—ranging from mandatory rollback testing and cautious handling of destructive commands to robust backup verification, vigilant monitoring, and disciplined handover procedures—to dramatically reduce system outages and improve overall reliability.

Operationsautomationbackup
0 likes · 18 min read
10 Essential Practices to Prevent Operational Failures in Database Management
Big Data and Microservices
Big Data and Microservices
May 8, 2016 · Backend Development

How to Build a Scalable Flash‑Sale System: Architecture, Challenges & Solutions

This article dissects the technical challenges of high‑traffic flash‑sale (seckill) systems, outlining typical e‑commerce flow, unique seckill characteristics, and detailed solutions for isolation, load handling, bandwidth, request throttling, order processing, database design, caching, concurrency control, and anti‑cheat mechanisms.

Backenddatabaseflash sale
0 likes · 37 min read
How to Build a Scalable Flash‑Sale System: Architecture, Challenges & Solutions
Architecture Digest
Architecture Digest
May 8, 2016 · Databases

MySQL High Availability Architectures: Overview of Common Solutions

This article reviews the main MySQL high‑availability architectures—including shared‑storage SAN, DRBD disk replication, keepalived/heartbeat, MHA, ZooKeeper‑based HA, Galera/PXC clustering, and middleware proxy solutions—detailing their principles, advantages, limitations, and suitability for different business scenarios.

ClusterHAMySQL
0 likes · 17 min read
MySQL High Availability Architectures: Overview of Common Solutions
ITPUB
ITPUB
May 6, 2016 · Databases

How Oracle Handles Physical & Logical Reads with Latches and Buffer Pins

Oracle’s block access mechanism involves hashing block addresses to locate hash buckets, using CBC latches and buffer pins to coordinate logical and physical reads, and following distinct step‑by‑step procedures for non‑unique index reads, unique index reads, and write operations, ensuring concurrency safety.

Buffer CacheLatchLogical Read
0 likes · 9 min read
How Oracle Handles Physical & Logical Reads with Latches and Buffer Pins
MaGe Linux Operations
MaGe Linux Operations
May 5, 2016 · Databases

Mastering MySQL Backups: Strategies, Types, and Tools for Reliable Data Protection

This guide explains why data backup is essential, outlines backup types (full, incremental, differential), compares MySQL backup methods (hot, warm, cold), evaluates physical vs logical approaches, reviews common tools like mysqldump, cp, tar, LVM snapshots, and xtrabackup, and offers strategies for choosing the right solution.

XtraBackupbackupdata protection
0 likes · 8 min read
Mastering MySQL Backups: Strategies, Types, and Tools for Reliable Data Protection
ITPUB
ITPUB
May 5, 2016 · Databases

Top 50 SQL Server Query Optimization Tips to Boost Performance

This comprehensive guide enumerates over forty common causes of slow SQL Server queries and provides detailed optimization techniques—including indexing strategies, hardware upgrades, partitioning, cursor handling, and configuration tweaks—to dramatically improve query performance and reduce resource bottlenecks.

Query OptimizationSQL Serverdatabase
0 likes · 21 min read
Top 50 SQL Server Query Optimization Tips to Boost Performance
ITPUB
ITPUB
May 4, 2016 · Databases

Master Oracle Triggers: Real‑World Examples and Step‑by‑Step Guide

This article explains Oracle trigger fundamentals, syntax, and a series of practical examples—including preventing weekend updates, auto‑incrementing IDs, logging DML actions, aggregating department salaries, capturing deletions, view‑based inserts, salary change alerts, and tracking CREATE/DROP operations—complete with full SQL code snippets.

OraclePL/SQLSQL
0 likes · 12 min read
Master Oracle Triggers: Real‑World Examples and Step‑by‑Step Guide
21CTO
21CTO
Apr 29, 2016 · Backend Development

How LeTV Scaled Its Payment System to 100k Orders per Second with Sharding and HA

This article explains how LeTV's payment platform handled a hundred‑fold surge in traffic by redesigning its architecture with database sharding, a custom order‑ID scheme, asynchronous consistency, high‑availability clustering, data tiering, and a coarse‑fine request pipeline to sustain up to 100,000 orders per second.

databasehigh-availabilityorder ID
0 likes · 15 min read
How LeTV Scaled Its Payment System to 100k Orders per Second with Sharding and HA
Efficient Ops
Efficient Ops
Apr 28, 2016 · Databases

How Oracle DB Embraces DevOps in the Cloud Era

This article summarizes Gai Guoqiang's presentation on Oracle Database DevOps practices, covering Oracle's cloud strategy, the shifting competitive landscape, the impact of cloud on DBA roles, and how DevOps principles are reshaping traditional database operations and performance management.

DBADevOpscloud
0 likes · 13 min read
How Oracle DB Embraces DevOps in the Cloud Era
dbaplus Community
dbaplus Community
Apr 28, 2016 · Databases

Unlock Oracle 12c Optimizer: New Stats, Adaptive Features & Advanced Techniques

This article explores the major enhancements in Oracle 12c's optimizer, including session‑level statistics for global temporary tables, new DBMS_STATS reporting procedures, adaptive features, advanced join elimination methods, incremental and concurrent statistics collection, and automatic column‑group detection, providing practical guidance for DBAs and developers.

12cDBMS_STATSOracle
0 likes · 23 min read
Unlock Oracle 12c Optimizer: New Stats, Adaptive Features & Advanced Techniques
ITPUB
ITPUB
Apr 25, 2016 · Databases

How to Move Oracle Tablespaces and Datafiles to a New Location

This guide explains step‑by‑step how to offline Oracle datafiles or tablespaces, copy them to a new directory, rename them, recover if needed, bring them back online, and safely shut down and restart the database to complete the migration.

DatafileOracleSQL
0 likes · 4 min read
How to Move Oracle Tablespaces and Datafiles to a New Location
ITPUB
ITPUB
Apr 21, 2016 · Databases

Master Oracle Profiles: Limits, Parameters, and Example Creation

Oracle profiles let administrators enforce password policies and resource limits such as CPU time, I/O, session count, and idle periods, with detailed parameters for both kernel resources and password rules, and the article provides a complete example of creating a custom profile using SQL.

OracleProfilesSQL
0 likes · 5 min read
Master Oracle Profiles: Limits, Parameters, and Example Creation
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Apr 13, 2016 · Databases

MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms

This article presents a series of MySQL backend improvements—including Group Commit redesign, DDL fast‑fail handling, GTID allocation refinements, persistent InnoDB auto‑increment values, replication parallelism, and key‑partition hash algorithm changes—detailing motivations, implementation steps, and performance results.

GTIDGroup CommitInnoDB
0 likes · 24 min read
MySQL Performance Optimizations and Feature Enhancements: Group Commit, DDL Fast‑Fail, GTID, InnoDB Auto‑Increment Persistence, Replication, and Key Partition Algorithms
21CTO
21CTO
Mar 31, 2016 · Databases

Why Does MySQL Produce Garbled Text? Causes, Prevention, and Fixes

This article explains the multiple encoding/decoding steps MySQL performs when storing and retrieving data, identifies why mismatched character sets cause mojibake, and provides practical methods to avoid and repair corrupted text in MySQL tables.

Character EncodingMySQLcharset conversion
0 likes · 17 min read
Why Does MySQL Produce Garbled Text? Causes, Prevention, and Fixes
ITPUB
ITPUB
Mar 25, 2016 · Databases

How to Perform a Silent Oracle 11g Database Installation and Resolve Common Errors

This guide explains the different Oracle database installation methods, focuses on silent installation using response files, shows the required file templates, demonstrates the runInstaller command, and walks through typical permission and syntax errors with practical troubleshooting steps.

OracleResponse FileSilent Install
0 likes · 5 min read
How to Perform a Silent Oracle 11g Database Installation and Resolve Common Errors
ITPUB
ITPUB
Mar 23, 2016 · Databases

Mastering COALESCE in PostgreSQL: Fix NULL Arithmetic Results

This guide shows how NULL values break numeric calculations in PostgreSQL and demonstrates using the COALESCE function to substitute default numbers, with step‑by‑step SQL examples that turn unexpected NULL results into accurate sums.

COALESCENull HandlingPostgreSQL
0 likes · 4 min read
Mastering COALESCE in PostgreSQL: Fix NULL Arithmetic Results
Qunar Tech Salon
Qunar Tech Salon
Mar 13, 2016 · Fundamentals

Understanding java.util.Date, Calendar, and SimpleDateFormat in Java

This article explains the legacy java.util.Date class, its limited useful constructors and methods, the more flexible java.util.Calendar API, how to format and parse dates with DateFormat and SimpleDateFormat, and best practices for storing timestamps in databases using long values.

DateSimpleDateFormatcalendar
0 likes · 9 min read
Understanding java.util.Date, Calendar, and SimpleDateFormat in Java
21CTO
21CTO
Mar 11, 2016 · Backend Development

How WordPress Achieves Extensibility with Meta Tables and Hook System

This article explains how WordPress uses the wp_postmeta table for flexible metadata storage and the hook (action) system for dynamic code insertion, illustrating both the benefits and trade‑offs of these extensibility techniques for plugin development.

HooksMetaWordPress
0 likes · 8 min read
How WordPress Achieves Extensibility with Meta Tables and Hook System
ITPUB
ITPUB
Mar 11, 2016 · Databases

Unlock Real-Time Analytics with Oracle 12c In-Memory: Architecture & Best Practices

This article explains how Oracle 12c's In-Memory feature enables hybrid OLTP/OLAP workloads by storing columnar data in a dedicated memory area, covering its architecture, data loading, consistency mechanisms, query acceleration techniques, and integration with RAC for high‑availability deployments.

In-MemoryOLAPOracle
0 likes · 19 min read
Unlock Real-Time Analytics with Oracle 12c In-Memory: Architecture & Best Practices
21CTO
21CTO
Mar 6, 2016 · Operations

Inside Stack Overflow’s 2016 Architecture: Handling 61 Million Daily Requests

The article details Stack Overflow’s 2016 infrastructure upgrades—including hardware, networking, load balancing, caching, database, and service layers—that enabled the site to process over 61 million daily requests while reducing processing time by hundreds of hours.

ArchitectureOperationsStack Overflow
0 likes · 12 min read
Inside Stack Overflow’s 2016 Architecture: Handling 61 Million Daily Requests
Architect
Architect
Mar 2, 2016 · Databases

InnoDB Full-Text Index Architecture and Operations in MySQL 5.7

This article explains MySQL InnoDB full-text indexing, covering supported modes, auxiliary tables, creation, DML handling, query processing, transaction management, cache synchronization, optimization, background threads, monitoring, stopwords, plugins, and the built‑in n‑gram parser, with code references from MySQL 5.7.

InnoDBMySQLOptimization
0 likes · 17 min read
InnoDB Full-Text Index Architecture and Operations in MySQL 5.7
ITPUB
ITPUB
Mar 1, 2016 · Databases

Oracle Database Architecture: Instances, Memory, Processes, and Structures

This article provides a comprehensive overview of Oracle Database architecture, detailing the server components, instance memory structures such as SGA, essential background processes, and the physical and logical storage layers, helping readers understand how Oracle organizes data and manages operations.

ArchitectureInstanceOracle
0 likes · 27 min read
Oracle Database Architecture: Instances, Memory, Processes, and Structures
ITPUB
ITPUB
Feb 23, 2016 · Databases

Uncovering Oracle’s Massive CREATE TABLE Docs: Core Database Concepts Explained

This article reveals why Oracle’s CREATE TABLE documentation spans dozens of pages and walks readers through essential Oracle database concepts such as tables, indexes, sequences, views, clusters, tablespaces, database links, and synonyms to help master the platform efficiently.

ConceptsOracleSQL
0 likes · 7 min read
Uncovering Oracle’s Massive CREATE TABLE Docs: Core Database Concepts Explained
Architect
Architect
Jan 31, 2016 · Databases

Understanding Database Vertical and Horizontal Splitting, Their Challenges, and Practical Solutions

The article explains the concepts of vertical and horizontal database splitting, compares their technical difficulties, discusses the impact on joins and transactions, and proposes practical approaches such as careful SQL refactoring, ORM decoupling, and selective use of distributed‑transaction techniques to maintain system stability and scalability.

Distributed TransactionsORMdatabase
0 likes · 14 min read
Understanding Database Vertical and Horizontal Splitting, Their Challenges, and Practical Solutions
Java High-Performance Architecture
Java High-Performance Architecture
Jan 30, 2016 · Databases

Understanding Redis 3 Cluster: Key Concepts, Features, and Operations

Redis 3 now officially supports clustering, introducing hash slots and dynamic node management to simplify key distribution, scaling, and fault tolerance, allowing seamless read/write operations across multiple nodes without manual hashing, and offering features like online node addition, automatic slave monitoring, and performance‑aware key allocation.

ClusterHash SlotRedis
0 likes · 4 min read
Understanding Redis 3 Cluster: Key Concepts, Features, and Operations