Business Query Interface for Enterprise Data Integration

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Employees in enterprise systems face inefficiencies and security risks due to the need to switch between multiple desktop applications to access and incorporate enterprise data, leading to time-consuming and inconsistent data access and retrieval.

Innovation Solution

A business query mechanism that allows direct access and incorporation of enterprise data into business productivity applications using an integrated, interpretive, editable scripting language, providing a guided query experience with context-based suggestions and security verification, eliminating the need for separate user interfaces and enabling data access within the application environment.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of time

If employees use multiple separate desktop applications to access enterprise data, then data can be retrieved from different business systems, but time is lost due to switching between applications and interfaces

Engineering Contradiction:
Improvetime spent switching between applicationsVSAvoidease of accessing data across systems
Core Design Contradiction:
Loss of timeVSEase of operation

Solution Approach 1:

The patent merges multiple separate desktop applications and their interfaces into a single integrated user interface. This unified interface allows employees to access data from various enterprise systems (HR, customer relations, databases) without switching between applications, directly resolving the time loss from context switching while maintaining ease of operation through a consistent interface paradigm.

Inventive Principle:
Principle #5Merging (Combining)

Solution Approach 2:

The invention creates a universal user interface that can access and display data from multiple different enterprise systems and databases. This single interface performs the functions previously requiring multiple separate applications, allowing employees to retrieve information from any business system through one consistent interface, thereby eliminating the need to switch applications while preserving operational simplicity.

Inventive Principle:
Principle #6Universality (Multi-functionality)

2Loss of time

If employees manually search through databases to find information, then data can be located, but considerable effort and time are spent on the search process

Engineering Contradiction:
Improvetime spent searching for dataVSAvoidproductivity in data retrieval
Core Design Contradiction:
Loss of timeVSProductivity

Solution Approach 1:

The system performs preliminary actions by pre-organizing and indexing data from multiple enterprise systems within the unified interface. When employees need information, the data is already structured and accessible through the single interface, eliminating the need for manual searching through multiple databases. This preliminary organization of data significantly reduces retrieval time while maintaining high productivity.

Inventive Principle:
Principle #10Preliminary action

3Reliability

If separate software systems are used for different business functions, then specialized functionality is available for each function, but security risks and inconsistencies increase

Engineering Contradiction:
Improveconsistency of data accessVSAvoidsecurity risks from multiple applications
Core Design Contradiction:
ReliabilityVSObject-affected harmful factors

Solution Approach 1:

The patent combines access to multiple separate software systems through a single unified interface with centralized security controls. This approach maintains the specialized functionality of individual business systems while consolidating security management, reducing security risks associated with multiple separate applications and ensuring consistent data access policies across all systems.

Inventive Principle:
Principle #5Merging (Combining)

4Loss of information

If data is accessed through multiple independent applications, then comprehensive data can be retrieved, but data access, retrieval, or use problems occur

Engineering Contradiction:
Improvecompleteness of data retrievalVSAvoidreliability of data access
Core Design Contradiction:
Loss of informationVSReliability

Solution Approach 1:

The unified user interface provides universal access to data from multiple enterprise systems, maintaining comprehensive data retrieval capability. By consolidating access points and standardizing data retrieval mechanisms across all systems, the invention eliminates data access and retrieval problems while preserving the ability to retrieve complete information from all business functions.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Data Source

PatentUS7802194B2Business query language
Publication Date: 2010.09.21 SAP SE
  • US7802194B2 patent drawing
  • US7802194B2 patent drawing
  • US7802194B2 patent drawing

AI summary

Methods and apparatuses enable providing a structured business query interface to receive a structured business query. The interface can be provided as an extension to a business productivity application. The query is made without having to change context from the application to another program, but rather can be made within the context of the application. The query triggers access to a backend, which may result in accessing a data object that is inserted or embedded into the application, or a document of the application. In one embodiment, a business process extension is also available to the application, which enables a task pane within the application with other features and/or data. In one embodiment, related data can be accessed in response to selecting the inserted data object, which can provide additional information on the data object without leaving the context of the application.