All Articles

143557 articles · Page 6614 of 7178
Senior Brother's Insights
Senior Brother's Insights
Nov 29, 2017 · Databases

Mastering SQL Performance: Proven Optimization Techniques and Best Practices

Learn a comprehensive methodology for SQL performance tuning, from identifying resource bottlenecks and understanding query processing stages to applying practical optimization tactics such as efficient joins, index usage, avoiding costly operations, and best‑practice guidelines that improve execution speed and resource consumption.

IndexingQuery TuningSQL
0 likes · 13 min read
Mastering SQL Performance: Proven Optimization Techniques and Best Practices
dbaplus Community
dbaplus Community
Nov 29, 2017 · Databases

Why Fewer Permissions Slow Down Oracle SQL: A Deep Dive into EXISTS Subqueries

An Oracle SQL query with five EXISTS permission checks runs dramatically slower when only a few permissions are configured, and the author investigates the root cause using execution plans, SQL Monitor data, and step‑by‑step testing, ultimately revealing how execution counts and row returns drive the unexpected performance degradation.

OraclePermission ChecksSQL
0 likes · 11 min read
Why Fewer Permissions Slow Down Oracle SQL: A Deep Dive into EXISTS Subqueries
Efficient Ops
Efficient Ops
Nov 29, 2017 · Operations

What Is the New Chinese DevOps Standard and How Does It Shape Modern Operations?

This article introduces the Chinese DevOps standard released by the Cloud Computing Open Source Industry Alliance, detailing its overall architecture, the first three parts covering agile development, continuous delivery, and technical operations, and explaining the associated capability‑maturity model for enterprises.

DevOpsMaturity ModelStandard
0 likes · 21 min read
What Is the New Chinese DevOps Standard and How Does It Shape Modern Operations?
Java Captain
Java Captain
Nov 29, 2017 · Fundamentals

What Is an Immutable Object in Java? Understanding String Immutability

This article explains the concept of immutable objects in Java, using String as a case study, clarifies the difference between object references and objects, examines String’s internal fields across JDK versions, demonstrates how typical mutating methods actually create new instances, and shows how reflection can bypass immutability.

Immutable ObjectProgramming FundamentalsString
0 likes · 9 min read
What Is an Immutable Object in Java? Understanding String Immutability
JD Retail Technology
JD Retail Technology
Nov 29, 2017 · Operations

iOS Thread Synchronization Mechanisms and Lock Implementations

This article explains various iOS thread synchronization tools—including NSLock, NSRecursiveLock, NSConditionLock, NSCondition, @synchronized, dispatch_semaphore, pthread_mutex, and the deprecated OSSpinLock—detailing their internal implementations, usage patterns, code examples, and performance considerations for developers seeking safe concurrent programming on Apple platforms.

ConcurrencyLocksNSLock
0 likes · 22 min read
iOS Thread Synchronization Mechanisms and Lock Implementations
Dada Group Technology
Dada Group Technology
Nov 29, 2017 · Backend Development

How Dada Delivery Platform Scaled to 8 Million Orders per Day for Double‑11

This article explains how Dada's order platform was refactored from a Python Flask service to a Java‑based microservice architecture, employing load testing, circuit breaking with Hystrix, and multi‑datacenter disaster recovery to reliably handle eight million orders in a single day during the Double‑11 shopping festival.

Circuit BreakingJavadisaster recovery
0 likes · 6 min read
How Dada Delivery Platform Scaled to 8 Million Orders per Day for Double‑11
Tencent Database Technology
Tencent Database Technology
Nov 29, 2017 · Information Security

Database Auditing: Concepts and Methods

Database auditing involves monitoring and recording database activities to detect and prevent security breaches, with methods ranging from application layer to kernel-level implementations across different database systems.

Database Auditingdatabase-securityinformation-security
0 likes · 17 min read
Database Auditing: Concepts and Methods
Baixing.com Technical Team
Baixing.com Technical Team
Nov 29, 2017 · Artificial Intelligence

How Content Features Power Modern Recommendation Systems

Content features transform unstructured entities like articles, images, and videos into structured descriptors—such as categories, tags, and keywords—enabling precise search recall, personalized recommendations, and effective labeling through methods like classification, convergent tags, keyword extraction, and both manual and automated annotation.

Taggingautomatic annotationcontent features
0 likes · 12 min read
How Content Features Power Modern Recommendation Systems
ITPUB
ITPUB
Nov 29, 2017 · Databases

Understanding Oracle Wait Events: Buffer Busy Waits, Latches, and I/O Operations

This article explains the most common Oracle wait events—including buffer busy waits, buffer latch, control file parallel write/read, various DB file reads and writes, latch free, and library cache lock—detailing their causes, parameters, and how to query them for performance analysis.

BufferDatabase I/OLatch
0 likes · 15 min read
Understanding Oracle Wait Events: Buffer Busy Waits, Latches, and I/O Operations
Alibaba Cloud Infrastructure
Alibaba Cloud Infrastructure
Nov 29, 2017 · Databases

Case Study: Resolving a One‑Cent Discrepancy Caused by Distributed‑Lock Timeout and Concurrency Issues in Alibaba’s Financial System

This article analyzes a real Alibaba internal financial‑system incident where a one‑cent accounting error arose from concurrent database writes after a distributed‑lock timeout, details the root‑cause investigation, and presents two remediation strategies—adjusting timeout settings and strengthening idempotent controls—to prevent similar issues.

AlibabaConcurrencydistributed lock
0 likes · 7 min read
Case Study: Resolving a One‑Cent Discrepancy Caused by Distributed‑Lock Timeout and Concurrency Issues in Alibaba’s Financial System
网易UEDC
网易UEDC
Nov 29, 2017 · Fundamentals

How Geometry Shapes Everyday Design – From Honeycombs to Vinyl Records

This article explores how fundamental geometric principles influence diverse designs, covering the honeycomb conjecture, slime‑mold network experiments, the physics of vinyl records, never‑loose nuts, Fibonacci sequences in nature, the golden ratio myth, and hidden geometric secrets in famous logos.

DesignFibonacciGeometry
0 likes · 15 min read
How Geometry Shapes Everyday Design – From Honeycombs to Vinyl Records
MaGe Linux Operations
MaGe Linux Operations
Nov 29, 2017 · Fundamentals

Essential Python Tips Every Beginner Should Know

This guide offers practical Python beginner tips, covering how to clear the interactive terminal on different OSes, correctly create single‑element tuples, test for None using the proper idiom, retrieve documentation with help(), and swap variable values effortlessly, all illustrated with clear examples.

Coding Tipsbeginners
0 likes · 5 min read
Essential Python Tips Every Beginner Should Know
MaGe Linux Operations
MaGe Linux Operations
Nov 29, 2017 · Fundamentals

Is the Linux Kernel Design Still Cutting‑Edge? Experts Weigh In

A Reddit discussion sparked a deep dive into Linux kernel architecture, comparing microkernel and monolithic approaches, exploring security versus performance trade‑offs, and questioning whether the kernel's design remains modern compared to Windows, macOS, and other systems.

Kernel DesignOperating Systemsmicrokernel
0 likes · 5 min read
Is the Linux Kernel Design Still Cutting‑Edge? Experts Weigh In
Qunar Tech Salon
Qunar Tech Salon
Nov 29, 2017 · Backend Development

Optimizing the Pricing Engine for High‑Volume Flight Search: Hash Sharding, Caching, and Response‑Time Improvements

This article explains how Qunar's international ticket pricing engine was optimized by redesigning hash rules for sharding, enhancing local cache replication, employing multi‑stage result delivery, and applying common distributed‑system patterns to boost computational capacity and reduce response latency for massive flight‑search workloads.

cachingflight searchpricing engine
0 likes · 8 min read
Optimizing the Pricing Engine for High‑Volume Flight Search: Hash Sharding, Caching, and Response‑Time Improvements
Efficient Ops
Efficient Ops
Nov 28, 2017 · Fundamentals

Master Python Fast: A Practical Guide for Ops Engineers to Automate Tasks

This comprehensive tutorial walks operations engineers through Python fundamentals, from installation and basic syntax to data structures, functions, modules, and debugging, illustrating each concept with clear examples and diagrams to enable rapid automation development in real‑world DevOps environments.

automationops
0 likes · 31 min read
Master Python Fast: A Practical Guide for Ops Engineers to Automate Tasks