Automated Database Selection for Federated Systems

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

In federated database systems, determining the appropriate database type and data processing type for applications is manual, time-consuming, and complex, especially as data size grows, and there is a lack of automated solutions for selecting the best database and data processing type.

Innovation Solution

A data storage setting arrangement that includes a communication interface to obtain application requirement data, a database determining unit to predict and select the database type, a processing type determining unit to predict and select the processing type, a data model creating unit to create a data model, and an instantiating unit to connect the application with the selected database, using classifiers and natural language processing to automate these processes.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If manual determination of database type and data processing type is used, then flexibility and customization are maintained, but deployment time and complexity increase significantly

Engineering Contradiction:

Improvedeployment simplicityVSAvoiddeployment time

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The system performs self-service by automatically analyzing application requirements and selecting appropriate database types and data processing types without manual intervention. The automated determination process eliminates the need for experts to manually configure database settings, thereby reducing deployment time and complexity while maintaining optimal configuration.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The manual mechanical process of expert analysis and configuration is replaced with an automated computational system. The system uses application requirement data to automatically determine database type and data processing type through algorithmic analysis, substituting human expert manual work with automated mechanical/computational processes.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

2Productivity

If automated determination of database type is implemented, then deployment time is reduced, but system complexity increases

Engineering Contradiction:

Improvedeployment speedVSAvoidsystem complexity

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The automated determination system serves multiple functions: it analyzes application requirements, determines database type, determines data processing type, and configures data models. This multi-functional approach consolidates what would otherwise require separate manual processes into a single automated system, improving productivity while managing complexity through integration.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The system introduces an automated determination mechanism as an intermediary between application requirements and database configuration. This intermediary automatically translates application requirements into appropriate database type and data processing type selections, reducing deployment time while containing system complexity within the automated determination module.

Inventive Principle:

Principle #24Intermediary (Mediator)

3Measurement precision

If expert knowledge is required for database selection, then accuracy of database type selection is maintained, but ease of operation decreases

Engineering Contradiction:

Improvedatabase type selection accuracyVSAvoidoperational accessibility

Core Design Contradiction:

Measurement precisionVSEase of operation

Solution Approach 1:

The system embeds expert knowledge within the automated determination mechanism, allowing non-experts to benefit from expert-level database type selection accuracy. The system autonomously analyzes application requirements and selects appropriate database types without requiring user expertise, thereby maintaining high accuracy while dramatically improving ease of operation.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The manual expert analysis process is replaced with an automated computational system that encodes expert knowledge. The automated determination mechanism uses algorithmic analysis of application requirements to achieve accurate database type selection, substituting human expert mechanical/cognitive processes with automated computational processes that are both accurate and accessible to non-experts.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

Data Source

PatentUS10262055B2Selection of data storage settings for an application

Publication Date: 2019.04.16 TELEFONAKTIEBOLAGET LM ERICSSON (PUBL)

AI summary

The present disclosure is directed towards a data storage setting arrangement in a federated database system that includes applications configured to handle data in corresponding databases. The arrangement includes a communication interface for obtaining application requirement data (AIC) related to database usage, a database determining unit for predicting database type using the application requirement data and selecting database based on the database type prediction, a processing type determining unit for predicting database processing type based on the application requirement data and selecting database processing type based on the processing type prediction, a data model creating unit for creating a data model for storing of data in the database based on the application requirement data and an instantiating unit for instantiating a connection between the application and the selected database based on the selected database processing type and data model.