General Ledger Multi-Dimensional Database Synchronization

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current accounting systems, such as ledgers and relational databases, face challenges in easy data entry and maintenance, as well as effective analysis, particularly when trying to retrieve complex financial data across multiple subsidiaries and time periods, due to the difficulty in performing complex queries and maintaining data synchronization between different database types.

Innovation Solution

A system that combines a ledger and a multi-dimensional database using metadata dimensions to map data, ensuring automatic synchronization with minimal latency, allowing for easy data entry and analysis without manual copying, and maintaining both systems in sync through a single update process.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If a ledger is used for data entry and storage, then easy entry and maintenance are achieved, but complex query capabilities for analyzing financial data across multiple subsidiaries and time periods are lost

Engineering Contradiction:

Improvedata entry and maintenanceVSAvoidcomplex query capability

Core Design Contradiction:

Ease of operationVSAdaptability or versatility

Solution Approach 1:

The patent introduces a synchronization layer that acts as an intermediary between the ledger and multi-dimensional database. This layer automatically transfers data from the ledger to the database, enabling complex queries on the database side while maintaining the simple ledger interface for data entry. The intermediary resolves the contradiction by decoupling the entry interface from the analysis capability.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The patent combines the strengths of both ledger and multi-dimensional database systems into a unified architecture. The ledger provides easy data entry while the database provides complex query capabilities, and the synchronization mechanism merges these two functions into a single system that delivers both ease of operation and analytical versatility.

Inventive Principle:

Principle #5Merging (Combining)

2Adaptability or versatility

If a multi-dimensional database is used for complex queries, then effective analysis capability is improved, but data entry and maintenance difficulty increase

Engineering Contradiction:

Improvecomplex query capabilityVSAvoiddata entry and maintenance

Core Design Contradiction:

Adaptability or versatilityVSEase of operation

Solution Approach 1:

The synchronization layer serves as an intermediary that handles the complexity of data population and maintenance automatically. Users interact with the simple ledger interface while the intermediary manages the complex tasks of data transformation and population into the multi-dimensional database structure, thus improving ease of operation without sacrificing query capability.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Reliability

If manual data copying is used between ledger and database, then data synchronization is achieved, but time consumption and operational complexity increase

Engineering Contradiction:

Improvedata synchronizationVSAvoidmanual copying time

Core Design Contradiction:

ReliabilityVSLoss of time

Solution Approach 1:

The system implements self-service automation where the synchronization layer automatically detects changes in the ledger and propagates them to the database without human intervention. This eliminates manual copying time and operational complexity while maintaining reliable data synchronization between the two systems.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent establishes continuous automated synchronization between the ledger and database, ensuring that data remains consistent without periodic manual intervention. This continuous action eliminates the time loss associated with manual copying and maintains reliable synchronization state.

Inventive Principle:

Principle #20Continuity of useful action

4Adaptability or versatility

If separate ledger and database systems are used, then functional flexibility is maintained, but system complexity and synchronization difficulty increase

Engineering Contradiction:

Improvefunctional flexibilityVSAvoidsystem integration complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent creates a universal interface layer that handles multiple functions: data entry validation, transformation, and synchronization. This multi-functional layer manages the complexity of integrating separate ledger and database systems while maintaining their individual functional flexibility, thus reducing overall system complexity.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS8156150B2Fusion general ledger

Publication Date: 2012.04.10 ORACLE INT CORP

AI summary

A database system combines a general ledger and a multi-dimensional database. The general ledger and multi-dimensional database are mapped such that relationships between the general ledger and multi-dimensional database are characterized with metadata dimensions. Using the mapping, data can be received into the general ledger and stored in both the general ledger and multi-dimensional database substantially simultaneously. Further, a synchronization of the data copies changes to the data automatically from the general ledger to the multi-dimensional database. Thus, there is no manual copying of data between the general ledger and the database. Further, the latency between the general ledger and database is minimal ensuring accurate analysis even contemporaneous with the input of the data.