Spreadsheet Interface for Relational Database Data Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Accessing and interacting with data stored in relational databases can be challenging for users due to unfamiliar interfaces and differing skill requirements across various database forms, especially when trying to view, modify, or simulate changes to the data.
Innovation Solution
A system that uses a spreadsheet application as an interface to access and interact with relational databases, employing a relational access server to facilitate communication, authorization, and data retrieval, allowing users to view and modify data presented in a familiar spreadsheet format.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If users access data stored in a relational database using traditional database interfaces, then data can be retrieved and viewed, but the interface is unfamiliar and requires specialized skills that most users do not possess
Solution Approach 1:
The patent introduces a spreadsheet application as an intermediary layer between the user and the relational database. The spreadsheet application provides a familiar, intuitive interface for users to interact with database data without requiring knowledge of complex database querying languages or interfaces. The system translates user-friendly spreadsheet operations into appropriate database operations behind the scenes.
Solution Approach 2:
The patent creates a copy or representation of the database data in spreadsheet format. Instead of requiring users to directly interact with the database interface, the system retrieves database data and presents it in a spreadsheet copy that users can manipulate using familiar spreadsheet operations. This copying approach allows users to work with data in a familiar environment while the underlying database remains unchanged.
2Productivity
If users are forced to work with unfamiliar database interfaces, then data access is possible, but user productivity and ease of use significantly decrease
Solution Approach 1:
The patent makes the spreadsheet application universal by enabling it to connect with and manipulate relational database data in addition to its traditional local data handling capabilities. Users can perform data manipulation tasks in a familiar spreadsheet environment while the system handles the complexity of database interactions, thereby increasing productivity without sacrificing ease of operation.
3Adaptability or versatility
If different forms of databases require different user skills, then various database types can be accessed, but the learning curve and skill requirements increase for users
Solution Approach 1:
The spreadsheet application serves as a universal intermediary that handles different database types through a single, consistent interface. Users interact with the spreadsheet application using the same familiar operations regardless of whether the underlying data source is a relational database, multidimensional database, or other database type. The system manages the complexity of different database protocols and data structures behind the scenes.
Data Source
AI summary
Systems, methods, and computer-readable mediums are presented that may provide for an interface to a relational database. A request may be received for data stored in a relationship database, wherein the request is received from a spreadsheet application. In response to the request for data stored in the relational database, a plurality of tables in the relational database may be accessed to retrieve the data indicated in the request. The retrieved data may be translated from the plurality of tables of the relational database into a format for output to the spreadsheet application. The translated data may be output to the spreadsheet application.