Database Generation from Spreadsheet Control Codes
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Spreadsheets face challenges in managing version control and tracking ownership of data across multiple copies, making it difficult to determine which user originated specific information and ensuring authorized access.
Innovation Solution
A database generation machine configures a system to convert a modified spreadsheet into a database by parsing control codes, tracking data as values of variables, and providing authorized access, thereby generating a structured database from unstructured spreadsheet data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If multiple copies of spreadsheets are maintained to track data versions, then data tracking capability is improved, but system complexity and difficulty of managing versions increases
Solution Approach 1:
The patent creates a digital copy of the spreadsheet and converts it to a database format, allowing the original spreadsheet to remain unchanged while the database stores tracked versions. This eliminates the need to manage multiple spreadsheet copies while maintaining full version tracking capability through the database's structured storage.
Solution Approach 2:
The patent introduces a database as an intermediary between the spreadsheet and the version tracking system. The database receives data from the spreadsheet, stores it in a structured format with version information, and provides authorized access without requiring users to manage multiple spreadsheet copies directly.
2Productivity
If spreadsheet data is converted to database format, then data management efficiency is improved, but conversion process complexity increases
Solution Approach 1:
The patent implements a self-service conversion process where the system automatically detects control codes in the spreadsheet, identifies data structures, and generates the corresponding database schema without requiring manual intervention. Users simply upload the spreadsheet and select authorized access, and the system handles the entire conversion process automatically.
Solution Approach 2:
The patent changes the data structure parameters from unstructured spreadsheet format to structured database format. The system automatically transforms data types, relationships, and storage formats based on the control codes detected in the spreadsheet, enabling efficient data management while abstracting the complexity from the user.
3Measurement precision
If control codes are added to spreadsheets for database generation, then data structure identification accuracy is improved, but spreadsheet complexity increases
Solution Approach 1:
The patent applies control codes only to specific cells or ranges within the spreadsheet where data structure information is needed, rather than requiring the entire spreadsheet to follow a complex structured format. This allows accurate identification of data structures while keeping the rest of the spreadsheet simple and usable.
Solution Approach 2:
The patent creates a separate layer of control code information that copies the essential structure metadata from the spreadsheet into a format that can be independently processed. This allows the control codes to carry structure identification information without altering the visual and functional appearance of the original spreadsheet.
4Reliability
If authorized access control is implemented in the database, then data security is improved, but access management complexity increases
Solution Approach 1:
The patent implements authorized access control during the database generation process itself, before data is stored. The system prompts users to specify authorized access during upload, and access rights are established in advance. This preliminary action ensures security is built into the system structure rather than added later as a complex management layer.
Data Source
AI summary
A machine may generate a database from a spreadsheet, track the data from its cells as values of variables, and provide such values to authorized users. The machine may receive an upload spreadsheet that was generated by modification of a source spreadsheet by inclusion of control codes, such as a first control code that labels a column of owner names, a second control code that labels a column of measures, and a third control code that labels a column of values of those measures. The machine may parse the upload spreadsheet based on its control codes. The machine may generate a database that contains a data record in which the value of the measure quantifies a variable, and this variable may have a variable name that includes the owner name of the row and the measure of the row. The machine may allow authorized users to download variables and values.