Multitree Payroll Ledger for Immutable Event-Driven Calculations
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing payroll systems lack the ability to immediately conduct required calculations in response to payroll events and ensure immutability of payroll data, particularly in the context of multitree structures, which are essential for secure and efficient management of payroll information.
Innovation Solution
A method and system utilizing multitree structures, comprising origin, timeline, child, grandchild, and subsequent descendent nodes, to manage payroll data, where each node stores immutable payroll entries and calculations, allowing for corrections through new nodes without altering existing data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If payroll data is stored in traditional database systems, then data can be easily modified and updated, but data immutability and security are compromised
Solution Approach 1:
The payroll ledger is segmented into a multitree structure with multiple nodes (origin nodes, child nodes, grandchild nodes, etc.), where each node contains specific payroll data or calculation results. This segmentation allows the system to maintain immutability at the node level while enabling corrections through adding new nodes rather than modifying existing ones.
Solution Approach 2:
The system performs preliminary actions by creating immutable payroll entries in origin nodes before any corrections are needed. When corrections are required, new nodes are added to the tree structure rather than modifying existing nodes, preserving the immutability of original data while allowing updates through addition of corrective entries.
2Productivity
If payroll calculations are performed in batches, then system resource usage is reduced, but calculation speed and responsiveness to payroll events deteriorate
Solution Approach 1:
The calculation system transitions from static batch processing to dynamic event-driven processing. Child nodes automatically execute calculations in response to payroll events occurring in origin nodes, allowing immediate calculation execution when needed while the system remains idle and resource-efficient when no events occur.
Solution Approach 2:
The multitree structure enables self-service calculations where child nodes automatically perform their calculations in response to payroll events in parent nodes without requiring external batch processing triggers. This automatic execution maintains high productivity when events occur while avoiding unnecessary resource consumption during idle periods.
3Measurement precision
If corrections to payroll data are made by updating existing entries, then data accuracy is improved, but data integrity and auditability are compromised
Solution Approach 1:
The correction mechanism uses a nested structure where new nodes are added to the existing multitree, with each correction node referencing and building upon previous nodes. This nesting preserves the complete audit trail of all payroll data changes while maintaining data accuracy, as each correction is visibly linked to the original data it modifies.
Solution Approach 2:
Instead of modifying original payroll entries, the system creates copies in new nodes to represent corrections. Each correction node contains the corrected data while maintaining references to the original nodes, preserving the complete history of changes and ensuring both data accuracy and full auditability.
4Device complexity
If a simple tree structure is used for payroll ledgers, then system complexity is reduced, but the ability to represent complex payroll relationships and calculations deteriorates
Solution Approach 1:
The multitree structure serves multiple functions within a single unified data structure: it represents hierarchical payroll relationships, stores immutable payroll data, performs calculations, maintains audit trails, and enables corrections. This multi-functionality provides the versatility needed for complex payroll relationships while avoiding the need for multiple separate systems.
Solution Approach 2:
The system transitions from a simple single-level tree structure to a multi-dimensional multitree structure with multiple types of nodes (origin, child, grandchild, etc.) and multiple relationships between them. This dimensional expansion enables the representation of complex payroll relationships, calculations, and corrections while maintaining a unified data structure that doesn't excessive complicate the system.
Data Source
AI summary
The present invention provides a method, preferably a computer-implemented method, and system of representing ledgers, and specifically payroll ledgers, using multitrees. While most existing accounting, payroll, and tax systems are based on periodic calculations processing certain input data, the proposed method and system relies on defining and persisting the complete set of information required for such purposes in the form of a special type of directed acyclic graphs.