Data Access Layer for Interoperable Dataset Consolidation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional data storage and computing technologies face challenges in managing and analyzing large, complex datasets due to compatibility issues among different formats and systems, leading to inefficiencies in data interoperability, manual intervention, and fragmented data access, which hinders effective data operations and collaboration among stakeholders.

Innovation Solution

A collaborative dataset consolidation system that includes a data project controller and dataset ingestion controller to transform and consolidate datasets into a unified format, enabling interoperability and facilitating data project formation, analysis, and collaboration through a project-centric workspace interface, allowing for data ingestion, inspection, analysis, and modification across various formats and systems.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If conventional data storage and computing technologies are used to manage large, complex datasets, then data storage capacity is sufficient, but data interoperability and accessibility are poor due to compatibility issues among different formats and systems

Engineering Contradiction:

Improvedata interoperabilityVSAvoidsystem complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent introduces a data access layer as an intermediary component between the storage layer and users/applications. This layer provides standardized interfaces and protocols that enable different data formats and systems to interoperate without requiring direct compatibility between them, thus improving adaptability while managing system complexity through abstraction.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The data access layer is designed with universal interfaces that can handle multiple data formats and communication protocols simultaneously. This multi-functional approach allows a single layer to serve diverse data access needs across different systems and applications, enhancing interoperability without requiring separate specialized components for each data type.

Inventive Principle:

Principle #6Universality (Multi-functionality)

2Ease of operation

If datasets are stored in conventional data stores (data silos), then data storage is simple, but data access and collaboration are fragmented and require manual intervention

Engineering Contradiction:

Improvedata access efficiencyVSAvoidmanual intervention time

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The patent merges multiple data access operations and collaboration functions into a unified data access layer. This consolidation allows users to access, manipulate, and collaborate on datasets from multiple sources through a single interface, eliminating the need to switch between different systems and reducing manual intervention time while improving ease of operation.

Inventive Principle:

Principle #5Merging (Combining)

3Adaptability or versatility

If different data formats and systems are used, then data diversity and flexibility are high, but compatibility and interoperability among datasets are poor

Engineering Contradiction:

Improvedata format flexibilityVSAvoiddata compatibility

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The data access layer implements parameter transformation mechanisms that automatically convert between different data formats and protocols. By changing the interface parameters rather than the underlying data structures, the system maintains flexibility in supporting diverse data formats while ensuring reliable compatibility through standardized transformation rules.

Inventive Principle:

Principle #35Parameter changes

Data Source

PatentUS11068847B2Computerized tools to facilitate data project development via data access layering logic in a networked computing platform including collaborative datasets

Publication Date: 2021.07.20 SERVICENOW INC

AI summary

Various embodiments relate generally to data science and data analysis, computer software and systems, network communications to interface among repositories of disparate datasets and computing machine-based entities that seek access to the datasets, and, more specifically, to a computing and data storage platform configured to provide one or more computerized tools that facilitate data projects by providing an interactive, project-centric workspace interface that may include, for example, a unified view in which to identify data sources, generate transformative datasets, and/or disseminate insights to collaborative computing devices and user accounts. For example, a method may include generating data configured to generate a data project user interface to receive a user input to implement a computerized tool to resolve a project objective including a query applied against a collaborative dataset, and forming data configured to display a user input to access hierarchical levels of data, for example, related to an insight.