Dynamic Lightweight Object Mechanism for Database Customization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional database systems limit user customization and control over data resources, restricting users to service providers' default entities and imposing limitations on the number of custom objects that can be created and managed.

Innovation Solution

A mechanism for facilitating the evaluation and management of dynamic lightweight objects in an on-demand services environment, allowing users to create and manage an unlimited number of custom objects with virtually unlimited key space, transient memory usage, and user-controlled metadata, enabling flexible data manipulation and presentation across various platforms.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If conventional database systems are used, then data management is provided through service provider default entities, but user customization control and the number of custom objects are limited

Engineering Contradiction:
Improveuser customization controlVSAvoidsystem structure
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent segments the database system into multiple independent layers: service provider default entities, tenant-level custom objects, and user-level dynamic lightweight objects. This segmentation allows each layer to operate independently with its own customization capabilities, enabling users to create unlimited custom objects without affecting the core system structure or other users' objects.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent introduces a new dimensional layer (dynamic lightweight objects) above the traditional database structure. Instead of expanding customization within the existing single dimension of custom objects, the system adds a new dimension of transient, in-memory objects that exist separately from persistent database storage, thereby enabling unlimited customization without increasing database complexity.

Inventive Principle:
Principle #17Another dimension (Dimensionality change)

2Adaptability or versatility

If unlimited custom objects are created, then user flexibility increases, but memory management and system performance may deteriorate

Engineering Contradiction:
Improvenumber of custom objectsVSAvoidmemory usage
Core Design Contradiction:
Adaptability or versatilityVSUse of energy by moving object

Solution Approach 1:

The patent implements dynamic lightweight objects as transient, short-lived entities that exist only in memory during runtime. These objects are automatically discarded after use without requiring persistent storage, analogous to disposable objects. This allows users to create unlimited custom objects for specific tasks while avoiding the memory overhead of permanently storing each object definition in the database.

Inventive Principle:
Principle #27Cheap short-living objects (Disposable)

Solution Approach 2:

The patent extracts object definitions from persistent database storage and places them in transient memory space. By separating the object definition phase (in-memory) from the data storage phase (database), the system enables unlimited custom objects without the memory management burden of storing each object's schema permanently, thereby improving both flexibility and memory efficiency.

Inventive Principle:
Principle #2Taking out (Extraction)

3Ease of operation

If service provider default entities are used, then system stability is maintained, but user control over data resources is restricted

Engineering Contradiction:
Improveuser controlVSAvoidsystem stability
Core Design Contradiction:
Ease of operationVSReliability

Solution Approach 1:

The patent applies local quality by allowing different levels of customization control at different layers of the system. Service provider default entities maintain system-wide stability and consistency, while tenant-level and user-level objects provide localized customization control. This layered approach enables users to exercise full control over their specific data resources without compromising the overall system stability provided by the default entities.

Inventive Principle:
Principle #3Local quality

Data Source

PatentUS10585852B2Mechanism for facilitating evaluation of data types for dynamic lightweight objects in an on-demand services environment
Publication Date: 2020.03.10 SALESFORCE INC
  • US10585852B2 patent drawing
  • US10585852B2 patent drawing
  • US10585852B2 patent drawing

AI summary

In accordance with embodiments, there are provided mechanisms and methods for facilitating evaluation of data types for dynamic lightweight objects in an on-demand services environment. In one embodiment and by way of example, a method includes uploading a data file having data at a first computing device in response to a request, and detecting data types relating to the data within the data file. The detecting includes scanning data rows and data columns of the data file. The method may further include classifying the detected data types into one or more categories, and creating one or more dynamic objects based on the one or more categories.