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.
A misconfigured mount_maxsize limited each Data Server to 20 GB, causing 96% storage usage, and after correction led to block corruption that required a custom script to clean up, illustrating the importance of proper storage settings and automated remediation in TFS operations.
The article examines Alibaba's Zeus resource scheduling platform, detailing its background, problem analysis, container‑based virtualization, distributed architecture, strategies for improving resource utilization such as overselling and hybrid deployment, as well as stability measures and automation for large‑scale operations.
This article explains the fundamentals of GPS/GNSS positioning, why a cold start can take up to 30 seconds, how multiple satellite constellations like BeiDou work together, the causes of urban positioning errors, and techniques such as A‑GPS and sensor fusion that aim to improve accuracy.
The article details the author’s experience upgrading a production Spark cluster from version 1.4.1 to 1.6.1, exposing memory‑spill, unified memory, BlockManager deadlock, Yarn‑kill, UI quirks, and Spark‑SQL compatibility issues, and proposes concrete code‑level fixes for each problem.
This guide shows how to configure Vim so that pressing F4 automatically adds or updates a header containing author details, file name, and modification timestamp, using custom functions and a mapping, making it easy for programmers to embed metadata into their scripts.
This article demystifies the Linux free command, explains the distinction between buffer and page caches, shows how various caches are reclaimed—or not—through practical tests with tmpfs, shared memory, and mmap, and provides actionable tips for accurately interpreting memory usage on RHEL 6 systems.
From 2012 to 2016, EMC’s World conferences introduced a series of groundbreaking storage and data‑management technologies—including XtremIO flash arrays, ViPR software‑defined storage, Isilon OneFS, VxRack hyper‑convergence, and the formation of Dell Technologies—shaping industry trends and highlighting the shift toward cloud‑centric data solutions.
A seasoned developer shares his 15‑year journey from a small‑town programmer to architect and aspiring CTO, emphasizing the power of interest‑driven learning, clear objectives, continuous skill expansion, and leadership principles for turning technical expertise into influential management roles.
This guide outlines concrete strategies to reduce I/O and CPU overhead in Oracle queries, covering scope reduction, partition pruning, join simplification, hint usage, bind variables, and common pitfalls like Cartesian products and inefficient filters.
The article examines various messaging patterns—Message Channel, Publisher‑Subscriber, Message Router, and others—explaining their principles, advantages, and implementation details, and illustrates their use in enterprise distributed architectures through concrete code examples and case studies such as CIMS and a medical system.
This article explains the fundamentals of Dependency Injection for front‑end developers, covering its design‑pattern roots, the Dependency Inversion Principle, practical JavaScript examples, various injection techniques, and a comparison with the Service Locator pattern.
This article explains how npm interprets dependency version specifiers such as caret (^), tilde (~), and range operators, illustrates their effects with lodash examples, covers semantic versioning rules, special cases like 0.x.x versions, and provides test cases to help developers choose the appropriate version constraints.
Learn how to efficiently validate user input in Node.js using the powerful Joi library, covering schema definitions, conditional rules, handling unknown fields, and integrating validation into Hapi routes, with clear code examples that replace cumbersome if‑else checks.
This article explains how to build a micro‑blogging social system using Redis, covering core data models, read‑through replication, Sentinel failover, and write‑side sharding techniques that enable the platform to handle hundreds of millions of users and massive traffic.
This tutorial walks you through installing Thrift, creating the interface file, and writing both server and client programs in Python to demonstrate a basic cross‑language RPC service.
This article demonstrates how to leverage JDK7's standard library—Path, Paths, Files, and FileSystem—to perform flexible file operations, safe path concatenation, size‑checked reading, automatic resource management, directory traversal with FileVisitor, and security measures for preventing unsafe file access.
This article details how Ping An Technology designed and operated the Padis platform—an internal Docker‑based PaaS that evolved to Mesos + Marathon, providing independent container IPs, automated networking, load balancing, CMDB integration, monitoring, and log aggregation to support thousands of containers in production financial applications.
This article introduces MySQL 5.7's sys schema, explains its purpose and components—including views, functions, and stored procedures—demonstrates practical queries for redundant indexes, unused indexes, and full table scans, and discusses potential future extensions.
This guide explains how to use MySQL’s MERGE storage engine to merge identically structured MyISAM tables into a single logical table, covering creation, querying, INSERT handling, adding new members, and important caveats such as avoiding primary keys.
