GUI Schema Model Construction for Nested NoSQL Structures
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current methods lack a graphical way to model NoSQL database schema models and REST APIs, failing to provide a clear and functional representation of nested objects and relationships.
Innovation Solution
A GUI-supported method for constructing database schema models that extends traditional table-like representations with nested objects, using tree diagrams and entity relationship diagrams to visually represent collections and their relationships.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If traditional table-like representations are used for database schema models, then the representation is simple and easy to understand, but it cannot handle nested objects and complex NoSQL structures
Solution Approach 1:
The patent implements nested objects within table-like representations by allowing objects to contain other objects as members. This nested structure enables the representation to handle complex NoSQL schemas while maintaining the familiar table-like interface, thus improving adaptability without significantly increasing complexity
Solution Approach 2:
The patent adds a hierarchical dimension to the traditional flat table representation by introducing levels of nesting. This dimensional extension allows the representation to accommodate complex structures like arrays of objects and objects containing arrays, enabling versatile modeling of NoSQL databases while keeping the interface intuitive
2Adaptability or versatility
If existing relational database modeling methods are applied to NoSQL databases, then the modeling process is straightforward, but it fails to capture NoSQL-specific features like nested objects and flexible schemas
Solution Approach 1:
The patent creates a universal modeling language that can represent both relational and NoSQL database structures using the same table-like syntax. This multi-functional approach allows the same representation to accurately model NoSQL features such as nested objects, arrays, and flexible schemas while maintaining compatibility with traditional relational modeling concepts
Solution Approach 2:
The patent extends the modeling language by introducing new parameters and syntax elements specific to NoSQL databases, such as nested object definitions, array specifications, and type annotations. These parameter extensions enable accurate representation of NoSQL features without altering the fundamental simplicity of the table-like structure
3Ease of operation
If graphical representations are introduced to model NoSQL schemas, then the visual clarity and hierarchy are improved, but the system complexity increases
Solution Approach 1:
The patent merges the graphical visualization capabilities with the existing table-like representation syntax, combining structural information, hierarchy, and visual clarity into a single unified format. This integration allows complex NoSQL schemas to be represented graphically while maintaining the simplicity and ease of operation of the underlying table-like structure
Data Source
AI summary
The present invention relates to a method for constructing a schema model by a user by means of a computer, comprising the steps of: providing a set of collections and/or optionally one or more relationships linking at least two of said set of collections; editing one or more of said set of collections, each of which associated with a schema definition displayed by a single table on an entity relationship diagram on a graphical interface on said computer and comprising at least one object and/or one field; automatically generating by means of said computer said schema model; wherein said set of collections comprises at least one collection comprising a nested object comprising lower level nodes, each of said lower level nodes being displayed on the single table of the collection that comprises said nested object, wherein the schema model is generated for a database system or a REST API or a GraphQL API.