Blog
Technical exploration and thoughts · 655 articles
AI Investigation #57: Five Major Categories of Robots - I...
Robots can be divided into five major categories based on function and form: industrial robots, service robots, humanoid robots, mobile robots, and specialty robots.
AI Investigation #56: Robotics Technology Iteration - Evo...
Robotics has undergone profound evolution from early hydraulic drive and analog control to modern electric drive, digital control and perception systems.
AI Investigation #55: Robotics - A Century of Evolution f...
Since the term 'Robot' was first introduced in 1921, robotics has undergone a century of evolution from science fiction to reality. Starting with Unimate in 1959 pioneering the industrial robot era...
AI Investigation #54: Big Data Industry Applications and ...
Big data has achieved deep integration in finance, e-commerce, internet, communications, manufacturing, healthcare, education and other industries, becoming the core engine for business innovation.
AI Investigation #53: Big Data Talent Landscape - Experie...
The talent structure in the big data industry shows characteristics of youth and rapid growth. The 25-30 age group is the main force, while 30-35 year-olds are gradually becoming the core strength.
AI Investigation #52: Big Data Technology Landscape - Lak...
Big data technology is undergoing a new wave of transformation. Lakehouse architecture combines the advantages of data lakes and data warehouses. Data Mesh...
MySQL Transaction Control: Lost Update, Locking and MVCC
Concurrent transaction problems: lost update, dirty read, non-repeatable read, phantom read, lock mechanism: shared lock, exclusive lock, MVCC. This article provides in-depth analysis of principles...
AI Investigation #51: Big Data Technology Evolution - Obs...
Big data technology evolution: MapReduce replaced by Spark, Storm replaced by Flink, Pig/Hive gradually phased out. This article analyzes why these technologies were eliminated and the technical re...
MySQL Transaction and Lock Mechanism: ACID Properties
ACID properties: atomicity, consistency, isolation, durability, WAL mechanism. This article provides in-depth analysis of principles and practical applications.
AI Investigation #50: Big Data Evolution - Two Decades of...
Two decades of big data evolution: from 2006 MapReduce batch processing to 2013 Spark in-memory computing, to 2019 Flink real-time computing. Architecture evolved from monolithic Hadoop to YARN mul...
MySQL Slow Query Analysis and Optimization Guide
Slow query log, mysqldumpslow, EXPLAIN analysis, common optimization solutions. This article provides in-depth analysis of principles and practical applications.
AI Research 49 - Big Data Survey Report: Development Hist...
Big data development began in 1997 when NASA proposed the concept, 2003-2006 Google published GFS, MapReduce, Bigtable three major papers leading distributed computing revolution. 2005 saw Hadoop b...
MySQL Index and Sorting: Filesort and Index Sort
filesort sorting, index sorting, two-pass sorting, single-pass sorting, clustered index and secondary index sorting. This article provides in-depth analysis of principles and practical applications.
MySQL Index Optimization: Table Lookup, Covering Index, L...
Table lookup queries, covering index, leftmost prefix principle, LIKE queries, NULL value handling. This article provides in-depth analysis of principles and practical applications.
MySQL EXPLAIN: Index Analysis and Query Optimization
EXPLAIN command: select_type, type, possible_keys, key, rows, key_len, Extra. This article provides in-depth analysis of principles and practical applications.
MySQL Clustered vs Secondary Index: Structure and Perform...
Clustered index (secondary index, primary key index), secondary index, table lookup query, covering index. This article provides in-depth analysis of principles and practical applications.
MySQL Index Principles: B+Tree, Hash, Binary Search
Index principles: B+Tree, Hash index, binary search, InnoDB adaptive hash index. This article provides in-depth analysis of principles and practical applications.
MySQL Index Types: BTree, Hash, FULLTEXT, RTree Explained
Index types: BTree, Hash, FULLTEXT, RTree, regular index, unique index, primary key index, composite index, clustered index. This article provides in-depth analysis of principles and practical appl...
MySQL Binlog: Recording Modes, Replication, Data Recovery
Binlog three recording modes: STATEMENT, ROW, MIXED, file format, write mechanism, master-slave replication. This article provides in-depth analysis of principles and practical applications.
MySQL Undo/Redo Log: Transaction Rollback and Persistence
Undo Log for rollback, Redo Log for redo, transaction atomicity, durability, MVCC. This article provides in-depth analysis of principles and practical applications.