E-commerce Transaction Data Accounting via Secondary Server Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Large e-commerce websites face significant burdens on their servers due to real-time data accounting, which can lead to system crashes and unavailability, especially when direct data processing occurs within the transaction system database.
Innovation Solution
Implementing a secondary server within an e-commerce transaction data accounting system that receives transaction data from the primary server, analyzes it, and combines it with historical data to produce current transaction data, thereby offloading the burden from the primary database and ensuring continuous operation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If real-time data accounting is performed directly in the e-commerce transaction system database, then data accounting accuracy is improved, but server burden increases and system reliability deteriorates
Solution Approach 1:
The patent divides the monolithic e-commerce system into two independent subsystems: the transaction system (first server and first database) and the accounting system (second server and second database). This segmentation allows each subsystem to operate independently, with the transaction system handling real-time transactions and the accounting system performing data accounting, thereby eliminating the conflict between transaction processing and data accounting that caused system crashes.
Solution Approach 2:
The patent introduces a data warehouse system as an intermediary layer between the transaction system and the accounting system. The data warehouse receives transaction data from the first server and provides processed data to the second server, acting as a buffer that decouples the real-time transaction processing from the accounting operations, thus preventing direct database overload.
2Loss of time
If real-time data accounting is performed in the transaction system database, then data freshness is improved, but device complexity and operational burden increase
Solution Approach 1:
By separating the accounting function into an independent second server and second database, the patent enables real-time accounting operations without complicating the transaction system. The accounting system maintains its own database structure optimized for accounting operations, while the transaction system remains simple and focused on transaction processing.
Solution Approach 2:
The patent implements preliminary data preparation by the data warehouse system, which pre-processes and organizes transaction data before it reaches the accounting system. This preliminary action reduces the computational burden on the second server during accounting operations, maintaining real-time performance without excessive complexity.
3Productivity
If tens of millions of database operations are handled daily, then productivity is improved, but the risk of database crash and system unavailability increases
Solution Approach 1:
The patent segments the database operations into two separate databases: the first database optimized for high-volume transaction operations and the second database optimized for accounting operations. This segmentation allows each database to be tuned for its specific workload, enabling the system to handle tens of millions of operations daily while maintaining stability by preventing any single database from becoming a bottleneck or failure point.
Data Source
AI summary
Method and system for e-commerce transaction data accounting are disclosed. A method comprises: a second server receiving transaction data from a first server; the second server analyzing the received transaction data to identify a classification of the received transaction data; the second server obtaining historical transaction data from a second database based on the classification of the received transaction data, wherein the second database obtains transaction data that meet a preset condition from a data warehouse system and compares the transaction data that meet the preset condition with previously obtained transaction data to update inconsistency in the transaction data that meet the preset condition; and the second server combining the received transaction data and the historical transaction data to produce current transaction data.