BestHub
Sign in
Tagged articles

databases

633 articles · Page 6 of 7
Architects' Tech Alliance
Architects' Tech Alliance
May 9, 2019 · Databases

From Single‑Node to Distributed: The Evolution of Modern Database Services

This article traces the historical laws that drove computing growth, examines how Redis, MongoDB and Memcached evolved, compares client‑side, proxy and compute‑storage‑separated architectures, evaluates their trade‑offs, and answers common questions about cloud‑based distributed databases.

Cloud databasesCompute-Storage SeparationDatabase Architecture
0 likes · 23 min read
From Single‑Node to Distributed: The Evolution of Modern Database Services
21CTO
21CTO
May 9, 2019 · Databases

How to Identify Database Bottlenecks and Choose the Right Sharding Strategy

This article explains common I/O and CPU bottlenecks in databases, compares horizontal and vertical sharding techniques, introduces practical tools, outlines migration steps, and discusses typical challenges such as non‑partition‑key queries, cross‑shard pagination, and scaling.

BottleneckHorizontal PartitioningPerformance
0 likes · 8 min read
How to Identify Database Bottlenecks and Choose the Right Sharding Strategy
Big Data Technology Architecture
Big Data Technology Architecture
May 8, 2019 · Databases

Understanding HBase Scan Process and Its Performance Compared to Parquet and Kudu

The article explains why HBase read operations are complex due to its LSM‑Tree storage and multi‑version design, details the step‑by‑step Scan workflow, discusses the reasons for its multi‑request architecture, compares scan performance with Parquet and Kudu, and offers recommendations for large‑scale data scanning.

HBaseLSM TreePerformance
0 likes · 7 min read
Understanding HBase Scan Process and Its Performance Compared to Parquet and Kudu
DataFunTalk
DataFunTalk
May 7, 2019 · Databases

Time Series Data Platform: Business Scenarios, Architecture, and Core Technologies

This article introduces the main business scenarios, system architecture, and core technologies of a time‑series data platform, covering data collection, processing, storage, analysis, and the specific features required for high‑performance, scalable, and reliable time‑series data management.

Big DataMonitoringarchitecture
0 likes · 10 min read
Time Series Data Platform: Business Scenarios, Architecture, and Core Technologies
21CTO
21CTO
Apr 3, 2019 · Backend Development

From LAMP to AI: A 10‑Year Journey Through Backend Architecture

This article reviews a decade‑long evolution of backend engineering—from early LAMP stacks to modern micro‑services, middleware, cloud, big data, AI, and containerization—explaining why new developers need to understand each layer's role in today’s complex internet systems.

AIDockerMiddleware
0 likes · 25 min read
From LAMP to AI: A 10‑Year Journey Through Backend Architecture
21CTO
21CTO
Mar 22, 2019 · Databases

Choosing the Right Open‑Source Database: PostgreSQL, MariaDB, and Percona Compared

This article examines why modern businesses rely on databases, explains the concept and advantages of open‑source software, and provides a detailed comparison of three popular open‑source databases—PostgreSQL, MariaDB, and Percona—highlighting their strengths, weaknesses, and ideal use cases.

MariaDBPerconaPostgreSQL
0 likes · 8 min read
Choosing the Right Open‑Source Database: PostgreSQL, MariaDB, and Percona Compared
21CTO
21CTO
Mar 9, 2019 · Databases

Which Databases Dominated March 2019 Rankings? MySQL and Oracle Surge

The March 2019 database popularity ranking shows Oracle, MySQL, and SQL Server all gaining points, with MySQL leading the surge, Oracle’s rise linked to its new 19c release, and PostgreSQL experiencing its first decline in six months.

MySQLOraclePostgreSQL
0 likes · 2 min read
Which Databases Dominated March 2019 Rankings? MySQL and Oracle Surge
Qunar Tech Salon
Qunar Tech Salon
Feb 27, 2019 · Databases

Evolution of Meituan’s Database Platform: From Manual Operations to Intelligent Automation

This article outlines Meituan’s transition of its database platform from manual, script‑based operations through tool‑ and product‑centric stages to a private‑cloud and automation era, discusses current challenges such as root‑cause analysis and staffing, and shares insights on moving toward fully intelligent, data‑driven database operations.

Big DataCloud ComputingIntelligent Operations
0 likes · 13 min read
Evolution of Meituan’s Database Platform: From Manual Operations to Intelligent Automation
JD Tech
JD Tech
Feb 21, 2019 · Databases

Analysis of MySQL Master‑Slave Replication Delay and Mitigation Strategies

The article recounts a pre‑promotion MySQL replication incident at JD.com, explains the master‑slave architecture and thread roles, identifies slow‑SQL and missing indexes as root causes of replication lag, and proposes practical measures to reduce latency and improve system stability.

IndexingMaster‑SlaveMySQL
0 likes · 6 min read
Analysis of MySQL Master‑Slave Replication Delay and Mitigation Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 29, 2019 · Databases

DBLE Middleware Overview and schema.xml Configuration Guide

This article introduces the open‑source DBLE distributed middleware, provides official resource links, outlines its main configuration files—including server.xml, schema.xml, and rule.xml—explains the role of schema.xml for sharding, and presents a detailed example with code and diagrams to help users configure DBLE effectively.

DBLEdatabasesschema.xml
0 likes · 5 min read
DBLE Middleware Overview and schema.xml Configuration Guide
21CTO
21CTO
Jan 15, 2019 · Fundamentals

10 Essential Skills Every Aspiring Programmer Must Master

This guide outlines the ten core competencies—from data structures and version control to IDEs, databases, Unix, Excel, programming languages, networking, and scripting—that every new or aspiring software developer should master to build a successful career.

Data StructuresUnixcareer
0 likes · 8 min read
10 Essential Skills Every Aspiring Programmer Must Master
dbaplus Community
dbaplus Community
Jan 13, 2019 · Databases

January 2019 DB-Engines Newsletter: Latest Database Releases & Key Features

The January 2019 DB-Engines newsletter compiles the newest releases, feature highlights, and performance improvements across RDBMS, NoSQL, NewSQL, time‑series, big‑data, domestic, and cloud database families, while also explaining the ranking methodology and providing download links for the full issue.

Big DataCloud ComputingNewSQL
0 likes · 41 min read
January 2019 DB-Engines Newsletter: Latest Database Releases & Key Features
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jan 8, 2019 · Fundamentals

Master the Essential Skills to Become a Great Software Architect

This comprehensive guide outlines the mindset, methodology, general and professional skills, core architectural concepts, design principles, and essential tools needed for anyone aspiring to become a proficient software architect in modern technology environments.

Cloud ComputingDevOpsSoftware Architecture
0 likes · 12 min read
Master the Essential Skills to Become a Great Software Architect
Alibaba Cloud Developer
Alibaba Cloud Developer
Dec 7, 2018 · Databases

How Alibaba Achieved Extreme Database Elasticity with Hybrid Cloud, Containers, and Storage‑Compute Separation

This article explains how Alibaba transformed its database infrastructure through hybrid‑cloud high‑performance ECS, container‑based multi‑instance deployment, and a user‑space storage‑compute separation architecture with RDMA, dramatically improving resource utilization, scaling speed, and cost efficiency for massive traffic spikes.

RDMAStorage Compute Separationcloud-native
0 likes · 15 min read
How Alibaba Achieved Extreme Database Elasticity with Hybrid Cloud, Containers, and Storage‑Compute Separation
ITPUB
ITPUB
Dec 3, 2018 · Databases

How Ele.me Deployed a Dual‑Active Database System in Just Three Months

This talk details Ele.me’s three‑month rollout of a dual‑active (multi‑active) database system, covering design principles, architecture, migration steps, challenges such as data consistency and DDL handling, the tools built (DRC, D‑Bus, DCP, EMHA), and the performance and reliability benefits achieved.

DBAData ReplicationEle.me
0 likes · 14 min read
How Ele.me Deployed a Dual‑Active Database System in Just Three Months
MaGe Linux Operations
MaGe Linux Operations
Nov 28, 2018 · Fundamentals

Challenge Your IT Skills with 14 Quiz Questions on Databases, Linux, and Python

This article presents a set of 14 multiple‑choice and short‑answer questions covering database indexing, locking mechanisms, DELETE behavior, network protocols, OSPF LSA types, Linux signals, port inspection, list deduplication, Python data structures, class inheritance, HTTP GET/POST differences, site reliability improvements, and hash function evaluation.

IT fundamentalsNetworkingPython
0 likes · 8 min read
Challenge Your IT Skills with 14 Quiz Questions on Databases, Linux, and Python
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 9, 2018 · Databases

Inside the ACM Distinguished Scientist Award: Alibaba’s Li Fei‑Fei on Database Innovation

In November 2018, ACM honored Alibaba Damo Academy’s chief database scientist Li Fei‑Fei with the Distinguished Scientist award, recognizing his pioneering work on distributed, intelligent, and secure database systems, his transition from academia to industry, and his vision for future cloud‑native database technologies and academia‑industry collaboration.

Cloud ComputingIndustry-Academia CollaborationMachine Learning
0 likes · 11 min read
Inside the ACM Distinguished Scientist Award: Alibaba’s Li Fei‑Fei on Database Innovation
dbaplus Community
dbaplus Community
Nov 4, 2018 · Databases

How Spark Turns Traditional Databases into Powerful OLAP Engines

This article examines why traditional relational databases like MySQL struggle with analytical workloads, compares ROLAP and MOLAP approaches, explains Spark’s architecture and its advantages for OLAP, and details how Alibaba Cloud’s DRDS HTAP leverages a Spark‑based engine to deliver real‑time distributed query processing.

HTAPMPPOLAP
0 likes · 11 min read
How Spark Turns Traditional Databases into Powerful OLAP Engines
Architects' Tech Alliance
Architects' Tech Alliance
Oct 15, 2018 · Databases

Data Sharding in Distributed Systems: Partitioning Strategies, Metadata Management, and Consistency Mechanisms

The article explains how distributed storage systems solve the fundamental problems of data sharding and redundancy by describing three sharding methods (hash, consistent‑hash, and range‑based), the criteria for choosing a shard key, the role of metadata servers, and consistency techniques such as leasing, all illustrated with concrete examples and code snippets.

consistent hashingdatabasesdistributed systems
0 likes · 25 min read
Data Sharding in Distributed Systems: Partitioning Strategies, Metadata Management, and Consistency Mechanisms
dbaplus Community
dbaplus Community
Sep 27, 2018 · Databases

How We Built an Automated DBA Platform: Architecture, Design, and Lessons

This article outlines the journey of a financial services company from manual DBA tasks through tool‑assisted operations to a fully automated platform, detailing the platform’s technical stack, functional modules, metadata design principles, evolving SQL audit workflow, and future directions for intelligent database operations.

DBAPlatformSQL Auditing
0 likes · 17 min read
How We Built an Automated DBA Platform: Architecture, Design, and Lessons
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Sep 4, 2018 · Fundamentals

Comprehensive Interview Study Guide for Computer Networks, Databases, Data Structures, Linux, OS, Java, and PHP

This guide compiles essential interview topics covering computer network protocols, MySQL and Redis database concepts, core data structures and algorithms, Linux commands and system internals, operating‑system fundamentals, and key Java and PHP concepts, providing a thorough preparation checklist for developers.

AlgorithmsComputer NetworksLinux
0 likes · 11 min read
Comprehensive Interview Study Guide for Computer Networks, Databases, Data Structures, Linux, OS, Java, and PHP
Programmer DD
Programmer DD
Aug 28, 2018 · Backend Development

From Beginner to Pro: The Ultimate Skill Tree for Java Backend Developers

This comprehensive guide outlines the essential technical and soft‑skill roadmap for programmers, covering computer fundamentals, data structures, Java basics, multithreading, JVM internals, databases, distributed systems, architecture, learning methods, personal branding, English importance, and ways to stay competitive.

JavaLearning PathPerformance
0 likes · 18 min read
From Beginner to Pro: The Ultimate Skill Tree for Java Backend Developers
MaGe Linux Operations
MaGe Linux Operations
Aug 19, 2018 · Backend Development

Essential Python Backend Interview Questions and How to Ace Them

The author shares personal interview experiences and a comprehensive list of Python backend interview questions covering syntax, algorithms, networking, databases, Linux, and Django, while emphasizing daily coding practice and GitHub activity as key to impressing interviewers.

AlgorithmsDjangoLinux
0 likes · 9 min read
Essential Python Backend Interview Questions and How to Ace Them
Architecture Digest
Architecture Digest
Aug 18, 2018 · Fundamentals

A Curated Reading List of Essential Java Programming Books

This article presents a comprehensive, stage‑by‑stage recommendation of Java books covering fundamentals, advanced topics, architecture, software development processes, databases, networking, multithreading, and design patterns, helping developers navigate the overwhelming literature and deepen their expertise.

Javadatabasesmultithreading
0 likes · 27 min read
A Curated Reading List of Essential Java Programming Books
dbaplus Community
dbaplus Community
Aug 11, 2018 · Databases

Achieving Multi‑Active Disaster Recovery with Distributed Databases in Finance

Amid rising cloud outages and strict financial regulations, this article examines traditional multi‑active database solutions such as Oracle RAC and IBM GDPS, contrasts them with modern distributed database designs, and details SequoiaDB’s multi‑active architecture and concrete disaster‑recovery procedures for single‑node, site‑wide, and network failures.

Financial ServicesSequoiaDBdatabases
0 likes · 13 min read
Achieving Multi‑Active Disaster Recovery with Distributed Databases in Finance
Liangxu Linux
Liangxu Linux
Jun 30, 2018 · Fundamentals

Top Open‑Source C Projects Every Developer Should Explore

This article presents a curated list of noteworthy open‑source C projects—including event libraries, caching systems, databases, web servers, testing frameworks, and classic Unix kernels—each with a brief description, key features, and download links for developers seeking practical learning resources.

C++LibrariesSystems
0 likes · 13 min read
Top Open‑Source C Projects Every Developer Should Explore
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 25, 2018 · Fundamentals

How to Turn Tactical Hard Work into Strategic Knowledge Growth

The article explores why many engineers repeat tasks without building lasting knowledge, explains how systematic practice, thorough review, and logical reasoning can transform isolated experiences into a connected web of expertise, and illustrates these ideas with a real MySQL connection‑slow case study.

Engineering EfficiencyLearning Strategiesdatabases
0 likes · 8 min read
How to Turn Tactical Hard Work into Strategic Knowledge Growth
ITPUB
ITPUB
Jun 20, 2018 · Databases

How JD Logistics Scales Warehouse Databases with Automation and High‑Availability Strategies

This article details JD Logistics' warehouse management system database architecture, the shift between local and centralized deployments, and how the UDBA automation platform, performance tuning, fault‑self‑healing, data archiving, and MySQL upgrades together ensure high performance and high availability across thousands of warehouses.

automationdatabasesoperations
0 likes · 13 min read
How JD Logistics Scales Warehouse Databases with Automation and High‑Availability Strategies
AntTech
AntTech
Jun 19, 2018 · Cloud Native

Financial‑Grade Cloud Native Architecture: Challenges, Practices, and Transformation Path

This article outlines the evolution of financial‑grade cloud native architecture, describing its origins, key principles, incremental delivery, sustainable innovation, and evolutionary planning, while addressing scalability, disaster‑recovery, distributed‑transaction, and elastic resource challenges with practical Ant Financial case studies.

databasesfinancial technologyoperations
0 likes · 37 min read
Financial‑Grade Cloud Native Architecture: Challenges, Practices, and Transformation Path
Efficient Ops
Efficient Ops
May 22, 2018 · Databases

Scaling Consumer‑Finance Databases: Architecture, DevOps, and Future Trends

This talk walks through the fundamentals of consumer‑finance services, details the evolving database architecture—including sharding, connection‑pool handling, resource isolation, and high‑performance caching—and shares the team's DevOps transformation and outlook toward NewSQL and AI‑driven operations.

DevOpsconsumer financedatabases
0 likes · 15 min read
Scaling Consumer‑Finance Databases: Architecture, DevOps, and Future Trends
ITPUB
ITPUB
May 14, 2018 · Databases

How Ant Group Built OceanBase: Key Lessons for Self‑Developed Databases

This article recounts Ant Group’s journey from early database research to the large‑scale deployment of OceanBase, outlining three strategic questions, architectural evolution, unit‑based design, and multi‑city disaster‑recovery solutions that illustrate how self‑developed database technology can become a core product.

Financial TechOceanBaseSelf‑Developed Technology
0 likes · 20 min read
How Ant Group Built OceanBase: Key Lessons for Self‑Developed Databases
Architecture Digest
Architecture Digest
Apr 30, 2018 · Backend Development

Modern Backend Developer Roadmap: A Step‑by‑Step Guide

This article presents a comprehensive, sequential roadmap for aspiring backend developers, covering language selection, practice projects, package managers, standards, security, testing, databases, frameworks, caching, APIs, authentication, messaging, search, Docker, web servers, WebSockets, GraphQL, graph databases, and continuous learning.

Roadmapbackenddatabases
0 likes · 10 min read
Modern Backend Developer Roadmap: A Step‑by‑Step Guide
360 Quality & Efficiency
360 Quality & Efficiency
Apr 27, 2018 · Databases

Common MySQL Commands and Comparison with Oracle

This article presents essential MySQL command-line operations, database and table management statements, and compares equivalent SQL syntax in Oracle, covering date handling, string functions, and notable differences such as pagination and auto‑increment behavior.

Database CommandsMySQLOracle
0 likes · 5 min read
Common MySQL Commands and Comparison with Oracle
360 Tech Engineering
360 Tech Engineering
Apr 25, 2018 · Fundamentals

A Guide to Qihoo 360’s Important Open‑Source Projects

This article surveys Qihoo 360’s notable open‑source projects—including distributed system testing tools, high‑performance storage services, AI scheduling platforms, database alternatives, frontend frameworks, mobile plugin solutions, and development utilities—highlighting their purposes, key features, and public GitHub repositories.

Artificial IntelligenceCloud ComputingDevOps
0 likes · 7 min read
A Guide to Qihoo 360’s Important Open‑Source Projects
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 21, 2018 · Databases

Consistency Models in Distributed Storage: Cosmos DB, Cassandra, OceanBase

This article explains the fundamentals of consistency in distributed storage systems, contrasts it with database transaction consistency, and details the various consistency levels offered by Azure Cosmos DB, Apache Cassandra, and OceanBase, highlighting their guarantees, configurations, and the performance‑availability trade‑offs involved.

CassandraOceanBaseconsistency models
0 likes · 22 min read
Consistency Models in Distributed Storage: Cosmos DB, Cassandra, OceanBase
dbaplus Community
dbaplus Community
Mar 18, 2018 · Databases

What’s New in the Database World? March 2018 Release Roundup

The March 2018 DBAplus Newsletter compiles the latest releases across RDBMS, NoSQL, NewSQL, time‑series and big‑data ecosystems, highlighting new features, performance improvements, compatibility updates and key technical links for Oracle, MySQL, MariaDB, SQL Server, DB2, PostgreSQL, TiDB, CockroachDB, InfluxDB, Hadoop and several Chinese‑made databases.

Big DataDatabase ReleasesHTAP
0 likes · 21 min read
What’s New in the Database World? March 2018 Release Roundup
Java Backend Technology
Java Backend Technology
Mar 3, 2018 · Backend Development

Essential Java Interview Questions Every Backend Developer Should Master

A comprehensive collection of Java interview questions covering fundamentals, common collections, concurrency, JVM internals, design patterns, data structures, networking, databases, caching, messaging, frameworks, distributed systems, and micro‑service architecture to help developers prepare for junior to mid‑level positions.

Design PatternsJavaconcurrency
0 likes · 19 min read
Essential Java Interview Questions Every Backend Developer Should Master
21CTO
21CTO
Feb 4, 2018 · Fundamentals

What Core Skills Every Software Engineer Must Master

This article outlines the essential technical abilities a software engineer should develop, ranging from understanding computation models and efficient data handling to mastering programming languages, system architecture, testing, and tooling, providing a comprehensive roadmap for building robust, scalable software solutions.

Core SkillsProgramming Fundamentalsdatabases
0 likes · 10 min read
What Core Skills Every Software Engineer Must Master
Java Captain
Java Captain
Jan 21, 2018 · Backend Development

A Comprehensive Java Learning Roadmap and Personal Reflections

This article presents a detailed Java learning roadmap covering core language fundamentals, intermediate topics like I/O and multithreading, advanced concepts such as design patterns and frameworks, front‑end basics, databases, J2EE, popular frameworks, server technologies, development tools, and practical project recommendations.

FrameworksJ2EEJava
0 likes · 6 min read
A Comprehensive Java Learning Roadmap and Personal Reflections
ITPUB
ITPUB
Jan 16, 2018 · Databases

10 Groundbreaking Database Systems Launched in 2017

A 2017 roundup highlights ten innovative database releases—including a time‑series extension for PostgreSQL, a multi‑model Azure service, Google’s globally distributed Spanner, Amazon’s Neptune graph service, and several open‑source cloud‑native databases—detailing their key features, architectures, and intended use cases.

GraphSQLcloud
0 likes · 10 min read
10 Groundbreaking Database Systems Launched in 2017
Tencent Architect
Tencent Architect
Dec 8, 2017 · Databases

Modern Processors, Emerging Storage, and Database System Design: Challenges and Opportunities

This article reviews the evolution of modern multi‑core processors and non‑volatile memory, analyzes their impact on database system architecture, discusses cache‑friendly designs, distributed logging, and benchmark results, and highlights the opportunities and challenges for DBMS developers in the era of NVRAM.

Non-volatile Memorybenchmarkingcache locality
0 likes · 17 min read
Modern Processors, Emerging Storage, and Database System Design: Challenges and Opportunities
dbaplus Community
dbaplus Community
Dec 6, 2017 · Databases

How Multi‑Core CPUs and NVM Are Redefining Database Design

This article summarizes a 2017 Gdevops talk that examines the evolution of many‑core processors and non‑volatile memory, explains how memory‑wall effects impact modern DBMS performance, and presents architectural and algorithmic adaptations—including cache‑friendly structures, lock management, and write‑behind logging—to exploit new hardware.

Non-volatile Memorydatabasesmany-core
0 likes · 18 min read
How Multi‑Core CPUs and NVM Are Redefining Database Design
21CTO
21CTO
Nov 10, 2017 · Databases

What Do the Latest DB-Engines Rankings Reveal About Database Trends?

The November 2017 DB‑Engines ranking shows Oracle, MySQL and Microsoft SQL Server still dominate the top three, while Splunk and HBase swap places, PostgreSQL climbs to fourth with a 54.1% year‑over‑year gain, and the list is based on five popularity factors such as search engine queries, job postings, and Stack Overflow activity.

OraclePostgreSQLdatabases
0 likes · 3 min read
What Do the Latest DB-Engines Rankings Reveal About Database Trends?
JD Retail Technology
JD Retail Technology
Oct 16, 2017 · Databases

Design and Evolution of JD Elastic Database: Architecture, Sharding, and Automatic Failover

This article details the evolution of JD's Elastic Database, describing the challenges of scaling MySQL, the staged solutions including sharding, JProxy, and the final elastic architecture with services like Topology, JED‑Gate, and JED‑Tablet, and explains its query processing, dynamic resharding, and automatic failover mechanisms.

Elastic ArchitectureFailoverQuery Processing
0 likes · 11 min read
Design and Evolution of JD Elastic Database: Architecture, Sharding, and Automatic Failover
dbaplus Community
dbaplus Community
Sep 19, 2017 · Databases

Unlock Faster DB Maintenance with dbm_lite and mysql_mgr_test Scripts

This article introduces two open‑source script collections—dbm_lite for Oracle database administration and mysql_mgr_test for rapid MySQL Group Replication deployment—detailing their features, supported platforms, usage instructions, and how to obtain them from GitHub.

MGRShell Scriptsdatabases
0 likes · 9 min read
Unlock Faster DB Maintenance with dbm_lite and mysql_mgr_test Scripts
21CTO
21CTO
Sep 4, 2017 · Databases

How Monty Widenius Built MySQL into the World’s Top Database

From dropping out of university at 19 to founding MySQL, Monty Widenius’s relentless coding passion, open‑source philosophy, and partnership with David Axmark transformed a hobby project into the world’s most popular database, shaping modern data management and inspiring generations of developers.

Monty WideniusMySQLTech history
0 likes · 9 min read
How Monty Widenius Built MySQL into the World’s Top Database
ITPUB
ITPUB
Aug 29, 2017 · Databases

Why Set-Based SQL Beats Procedural Queries: Real Performance Comparisons

The article explains how set‑based SQL queries outperform procedural, row‑by‑row approaches by showing concrete examples, AUTOTRACE statistics, and PL/SQL function alternatives, highlighting massive differences in consistent gets, recursive calls, and overall resource consumption for large production data sets.

PL/SQLPerformanceProcedural
0 likes · 7 min read
Why Set-Based SQL Beats Procedural Queries: Real Performance Comparisons
ITPUB
ITPUB
Aug 2, 2017 · Databases

How Chinese Domestic Databases Evolved in 2017: Funding, Products, and Market Moves

The 2017 overview of China’s domestic database sector examines funding milestones, new product releases, and market activities of key players such as Nanda General, HanGao Software, Kingbase, Inspur K‑DB, and XingRuiGe, highlighting their technical capabilities and strategic directions.

Chinese marketData PlatformsEnterprise Software
0 likes · 9 min read
How Chinese Domestic Databases Evolved in 2017: Funding, Products, and Market Moves
Architecture Digest
Architecture Digest
Jul 19, 2017 · Fundamentals

A Curated List of Notable Alibaba Open‑Source Projects

This article presents a comprehensive overview of prominent Alibaba open‑source projects spanning frontend frameworks, mobile cross‑platform solutions, backend systems, databases, testing tools, and UI components, each with brief descriptions and GitHub links for developers seeking robust, enterprise‑grade resources.

AlibabaDevToolsbackend
0 likes · 13 min read
A Curated List of Notable Alibaba Open‑Source Projects
ITPUB
ITPUB
Jul 17, 2017 · Databases

Why SQL Still Dominates After 43 Years: 8 Compelling Reasons

Based on a 2017 Stack Overflow survey of 64,000 developers, this article explains why SQL remains the second‑most used programming language, detailing eight technical, community‑driven and practical reasons that keep relational databases indispensable despite the rise of newer technologies.

Data ManagementRDBMSSQL
0 likes · 10 min read
Why SQL Still Dominates After 43 Years: 8 Compelling Reasons
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Jul 17, 2017 · Big Data

Mastering Data Sync, Real‑Time Processing, and Scalable Storage for Modern Systems

This article explores practical techniques for synchronizing heterogeneous data sources, performing batch and incremental analytics with Hadoop and Spark, designing low‑latency real‑time computation pipelines, implementing push notifications, and choosing appropriate storage solutions—from in‑memory caches to distributed databases—while addressing performance, reliability, and scalability challenges.

Big DataData synchronizationdatabases
0 likes · 25 min read
Mastering Data Sync, Real‑Time Processing, and Scalable Storage for Modern Systems
Architecture Digest
Architecture Digest
Jul 8, 2017 · Fundamentals

A Comprehensive Learning Roadmap for Software Development

This article presents a detailed, game‑like learning roadmap for programmers, recommending foundational scripting languages, Unix/Linux mastery, web development, databases, C/C++ and Java, system programming, design patterns, and advanced topics such as distributed systems and big‑data technologies to guide career growth.

C++Learning RoadmapUnix
0 likes · 19 min read
A Comprehensive Learning Roadmap for Software Development
Architects' Tech Alliance
Architects' Tech Alliance
Jul 1, 2017 · Operations

Comprehensive Overview of Data Migration: Purposes, Challenges, and Main Technologies

This article provides a detailed introduction to data migration, explaining why and when it is needed, outlining its major challenges such as security, compatibility and downtime, and describing the four primary migration approaches—application, volume‑manager, network, and storage—along with common tools and technologies.

Data MigrationLVMNetwork
0 likes · 10 min read
Comprehensive Overview of Data Migration: Purposes, Challenges, and Main Technologies
Tencent IMWeb Frontend Team
Tencent IMWeb Frontend Team
May 21, 2017 · Artificial Intelligence

What’s Shaping Tech This Week? AI Breakthroughs, Electron Revamp, and More

This week’s tech roundup covers GitHub’s shift to Electron for cross‑platform desktop clients, Tencent’s AI‑powered location services, Facebook’s open‑source ParlAI dialogue framework, Microsoft’s AR glasses prototype, Google Lens advancements, FDA‑approved medical VR, Apache Beam’s first stable release, Amazon DAX preview, and MapD’s open‑source GPU database.

AIARElectron
0 likes · 10 min read
What’s Shaping Tech This Week? AI Breakthroughs, Electron Revamp, and More
MaGe Linux Operations
MaGe Linux Operations
May 15, 2017 · Databases

Top 10 Must‑Know Data Storage Tools for Java Developers

Facing ever‑growing complexity, Java developers can streamline their projects by mastering a curated list of essential data storage and processing tools—including MongoDB, Elasticsearch, Cassandra, Redis, Hazelcast, EHCache, Hadoop, Solr, Spark, and Memcached—each offering distinct strengths for modern big‑data applications.

Big DataData ProcessingJava
0 likes · 8 min read
Top 10 Must‑Know Data Storage Tools for Java Developers
Architects' Tech Alliance
Architects' Tech Alliance
Apr 27, 2017 · Big Data

Curated List of Big Data Learning Resources from w3cschool

This article presents a comprehensive, Chinese‑language collection of big‑data resources—including relational databases, distributed file systems, key‑value stores, distributed programming tools, file data models, and key‑map frameworks—compiled by w3cschool to help programmers deepen their understanding of big data technologies.

Big DataLearningResources
0 likes · 6 min read
Curated List of Big Data Learning Resources from w3cschool
Tencent IMWeb Frontend Team
Tencent IMWeb Frontend Team
Apr 2, 2017 · Fundamentals

What Were the Biggest Software Development Trends of 2016 and What to Expect in 2017?

The article reviews the major software development trends of 2016—including progressive web apps, chatbots, evolving front‑end frameworks, cloud adoption, and machine‑learning breakthroughs—while highlighting key programming languages, databases, tools, and technologies to watch in 2017.

Cloud ComputingMachine LearningProgramming Languages
0 likes · 17 min read
What Were the Biggest Software Development Trends of 2016 and What to Expect in 2017?
ITPUB
ITPUB
Mar 23, 2017 · Databases

How to Slash Distributed Oracle Query Time with the driving_site Hint

This article explains how to use Oracle's driving_site hint to minimize network traffic in distributed DBLINK queries, demonstrates a banking case where execution time drops from over eight seconds to under one second, and provides step‑by‑step view‑based solutions for DML optimization.

Distributed QueryOracleSQL
0 likes · 8 min read
How to Slash Distributed Oracle Query Time with the driving_site Hint
Efficient Ops
Efficient Ops
Jan 24, 2017 · Databases

Essential DBA Holiday Checklist: Keep Your Databases Safe During Chinese New Year

This guide outlines the critical tasks DBA teams should perform before, during, and after the Chinese New Year holiday, including daily security practices, pre‑holiday inspections, on‑call rotations, post‑holiday reviews, and detailed checklist scripts to ensure database reliability and prevent incidents.

ChecklistDBAHoliday
0 likes · 13 min read
Essential DBA Holiday Checklist: Keep Your Databases Safe During Chinese New Year
Architecture Digest
Architecture Digest
Nov 23, 2016 · Backend Development

Evolution of .NET Web Architecture: From Single Server to Distributed Cloud Services

The article outlines the step‑by‑step evolution of a .NET‑based web system, describing how a single‑server setup grows into a multi‑tier, load‑balanced, clustered, stateless, micro‑service architecture that leverages caching, NoSQL, search engines, cloud services, Docker and CDN to handle large‑scale traffic and data processing.

backendcachingcloud
0 likes · 10 min read
Evolution of .NET Web Architecture: From Single Server to Distributed Cloud Services
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Nov 18, 2016 · Databases

Mastering Database Schema: From Normalization to Sharding Strategies

This article explores core database design concepts, covering normalization principles, denormalization tactics, schema simplification, MySQL architecture, various data partitioning methods—including vertical, horizontal, logical, and time‑based sharding—and practical routing and storage optimizations for high‑performance systems.

DenormalizationScalingdatabases
0 likes · 27 min read
Mastering Database Schema: From Normalization to Sharding Strategies
Architecture Digest
Architecture Digest
Nov 11, 2016 · Backend Development

High‑Availability Architecture Sessions at the China Software Developers Conference (Nov 18‑20)

The conference featured a series of high‑availability architecture talks covering performance‑driven design, RPC framework resilience, big‑data platform evolution, MySQL cluster consistency, and cloud infrastructure best practices, presented by experts from 58.com, Alibaba, Tencent, Baidu, and others.

Big DataCloud ComputingRPC
0 likes · 10 min read
High‑Availability Architecture Sessions at the China Software Developers Conference (Nov 18‑20)
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 31, 2016 · Cloud Computing

How Taobao Scaled from LAMP to Cloud: Lessons in Cloud Migration Architecture

This article examines the evolution of Taobao's technical architecture—from a LAMP stack through Oracle‑based mainframes to a cloud‑native platform—highlighting the performance, scalability, and cost challenges of traditional IT and offering best‑practice strategies for migrating enterprise systems to the cloud.

Big DataCloud Computingarchitecture migration
0 likes · 15 min read
How Taobao Scaled from LAMP to Cloud: Lessons in Cloud Migration Architecture
Efficient Ops
Efficient Ops
Oct 29, 2016 · Databases

Why Your System Slows Down: Uncover Hidden Database Bottlenecks

The article explains how unnoticed database issues often cause system slowness, outlines key diagnostic questions for operations teams, and presents a three‑step approach—discover, solve, prevent—to regularly health‑check and optimize databases for reliable performance.

MonitoringPerformanceTroubleshooting
0 likes · 8 min read
Why Your System Slows Down: Uncover Hidden Database Bottlenecks
MaGe Linux Operations
MaGe Linux Operations
Oct 20, 2016 · Databases

Boost Your SQL SELECT Performance: Proven Checklist & Practical Tips

This guide presents a concise, experience‑based checklist for optimizing SQL SELECT statements, covering index verification, dataset reduction, column selection, unnecessary table removal, outer join elimination, and computed column cleanup, each illustrated with real‑world examples and visual aids.

Query OptimizationSQLdatabases
0 likes · 6 min read
Boost Your SQL SELECT Performance: Proven Checklist & Practical Tips
Architecture Digest
Architecture Digest
Oct 17, 2016 · Databases

Common Redis Data Types, Memory Optimizations, and Persistence Mechanisms

This article explains Redis's five primary data types—String, Hash, List, Set, and Sorted Set—detailing their commands, use‑cases, internal encodings, memory‑saving configuration parameters, and the available persistence strategies, while offering practical recommendations for production deployments.

Data TypesPersistenceRedis
0 likes · 14 min read
Common Redis Data Types, Memory Optimizations, and Persistence Mechanisms
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 16, 2016 · Big Data

Mastering Data Sync, Real-Time Analytics, and Scalable Storage for Modern Systems

This article explains how to design and implement heterogeneous data synchronization, leverage batch and stream processing frameworks like Hadoop and Storm for large‑scale analysis, and choose appropriate storage solutions—from in‑memory databases to distributed column‑family stores—while addressing performance, reliability, and monitoring in complex distributed environments.

Big DataData synchronizationdatabases
0 likes · 26 min read
Mastering Data Sync, Real-Time Analytics, and Scalable Storage for Modern Systems
ITPUB
ITPUB
Aug 12, 2016 · Databases

Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters

This article explains Oracle cursor concepts, details the key V$SQL and related views, highlights crucial columns for performance tuning, and describes important parameters such as open_cursor and cursor_sharing, helping DBAs optimize SQL execution and manage shared pool memory effectively.

Database PerformanceOracleSQL Tuning
0 likes · 13 min read
Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters
ITPUB
ITPUB
May 9, 2016 · Databases

Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond

This article explains MySQL backup fundamentals, compares cold, snapshot, logical (mysqldump, mydumper) and physical (Xtrabackup) methods, outlines their workflows, pros and cons, and discusses lock‑related performance impacts and Percona's backup‑lock improvements.

LVMMyDumperMySQL
0 likes · 11 min read
Mastering MySQL Backups: From Cold Copies to Xtrabackup and Beyond