Database Allocation Identification via Domain Linking
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In global data storage systems, determining the allocation of data to specific entities or departments becomes challenging due to a lack of transparency, especially in large-scale systems like SAP applications with numerous tables, where data from multiple departments is stored together, making it difficult to identify how much data is allocated to a particular department.
Innovation Solution
A computer-implemented method and database system that identifies directly and indirectly associated table fields by linking domains and type definitions, calculates the number of records allocated to an entity, and generates a histogram to represent the database allocation, improving the efficiency and flexibility of determining data storage allocation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of energy
If data from multiple departments is stored together in a centralized database system, then cost savings in administration, backups, maintenance, and staff are achieved, but transparency of data allocation deteriorates making it difficult to determine how much data is associated with a particular country or department
Solution Approach 1:
The patent introduces intermediary components (domain objects, type definitions, and allocation determination mechanisms) that mediate between the centralized database storage and the need for transparent data allocation tracking. These intermediaries enable the system to maintain centralized storage benefits while providing clear visibility into which department or country each data record belongs to, without requiring separate physical storage systems.
2Quantity of substance
If the number of systems is increased to handle global data storage needs, then data coverage is improved, but lack of transparency of data allocation worsens making it difficult to track data by entity
Solution Approach 1:
The patent implements a universal data allocation determination mechanism that can identify and track data belonging to any entity, department, or country within the database system. This multi-functional approach allows the same system to handle diverse data types and organizational structures while maintaining consistent transparency, enabling the system to scale without losing allocation visibility.
3Adaptability or versatility
If manual methods are used to determine database allocation, then flexibility in analysis is maintained, but productivity and efficiency deteriorate due to the time-consuming nature of the process
Solution Approach 1:
The patent enables the system to automatically determine and report data allocation without requiring manual intervention. The automated determination mechanism queries the database, identifies relevant records based on domain and type definition criteria, and generates allocation reports autonomously. This self-service capability dramatically improves productivity while maintaining the flexibility to analyze data by different entities, departments, or countries as needed.
Data Source
AI summary
Various embodiments illustrated and described herein pertain to at least one of systems, methods, databases, and instructions stored on computer-readable mediums for data allocation identification. One method according to some embodiments includes determining a database allocation of an entity and identifying a domain directly associated with the entity. The method may further include determining at least one header table field directly associated with the entity by identifying a directly associated type definition linked to the directly associated domain, wherein the directly associated type definition refers to the header table field, wherein each header table field is in a corresponding header table. This, and other embodiments, are illustrated and describe in detail herein.