Online Database Schema Design Tool for Cloud Services

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional cloud computing services lack convenient online tools for designing and building databases or database schema, limiting users' ability to customize and enhance their database systems effectively.

Innovation Solution

Providing an online toolset that allows users to define and modify database schema elements, automatically altering the schema based on user input, enabling customization and enhancement of databases within an on-demand services environment.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If cloud computing services provide database functionality, then users can access databases remotely without installing software, but users lack convenient online tools for designing and building database schema

Engineering Contradiction:

ImproveDatabase schema design and buildingVSAvoidOnline toolset for schema design

Core Design Contradiction:

Ease of operationVSDevice complexity

Solution Approach 1:

The database schema design process is segmented into distinct visual components: entity representation, relationship definition, and attribute configuration. Users interact with these segmented elements through a graphical interface, making the complex schema design process more manageable and intuitive without requiring technical expertise in database construction.

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

A graphical user interface serves as an intermediary between users and the database schema. This interface translates user-friendly visual operations into database schema modifications, eliminating the need for users to directly manipulate complex database structures while maintaining full schema customization capability.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Adaptability or versatility

If users want to customize and enhance their database systems, then they can tailor data structures to their specific needs, but they lack the necessary tools to efficiently create and modify schema

Engineering Contradiction:

ImproveDatabase schema customizationVSAvoidTime for schema creation and modification

Core Design Contradiction:

Adaptability or versatilityVSLoss of time

Solution Approach 1:

The system provides pre-defined templates and suggested schema structures that users can start with before customizing. This preliminary action reduces the time required for schema creation by establishing a solid foundation that users can then adapt to their specific needs without starting from scratch.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The schema design interface is dynamic, allowing users to real-time modify entities, relationships, and attributes through visual operations. Changes are immediately reflected in the database structure, enabling iterative customization without time-consuming manual coding or configuration steps.

Inventive Principle:

Principle #15Dynamics

Data Source

PatentUS8914422B2Methods and systems for designing and building a schema in an on-demand services environment

Publication Date: 2014.12.16 SALESFORCE INC

AI summary

Methods and systems are provided for displaying a graphical representation of data objects of a schema using an online tool. In an embodiment, the online tool may be used to create or modify a schema. Modifying a schema may include adding or modifying or deleting data objects. Modifying data objects may include adding or modifying or deleting data fields. The online tool may be used to define relationships between data objects. In an embodiment, user permissions may be set for data objects. In an embodiment, the graphical representations of data objects may be selected and placed is a different location.