Electronic table general-purpose data parsing and leading-in method
A spreadsheet and data analysis technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as heavy workload, poor reusability, poor maintainability, etc., to increase availability and avoid mapping. and the effect of logical processing
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Benefits of technology
Problems solved by technology
Method used
Examples
Embodiment Construction
[0050] Method of the present invention is made up of following several parts:
[0051] (1) The spreadsheet data analysis import model;
[0052] (2) Data location method;
[0053] (3) The representation of primary and foreign keys;
[0054] (4) Judgment rules for valid records in multi-row tables
[0055] (5) Processing of enumerated values;
[0056] (6) the safety of the model;
[0057] They are described below.
[0058] (1) Spreadsheet data analysis import model
[0059] According to the requirements of data import, the content in the spreadsheet is finally mapped to tables and columns in the database. Therefore, the core content of the analysis model is also composed of two parts: the table model and the column model. In addition, the analysis model provides an enumeration Value model to handle key-value mappings.
[0060] 1. Table model
[0061] serial number model element illustrate 1 serial number Equivalent to the serial number of the data shee...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com