Generation method of wide table in structured query language database and device thereof
A structured query and database technology, which is used in electrical digital data processing, special data processing applications, instruments, etc., and can solve problems such as low query performance and inability to improve query performance.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0063] The embodiment of the present application obtains the log file of the structured query language database, and obtains its change data through the log file. Therefore, according to the change data, the association relationship of the association table corresponding to the log file and the operation to be performed on the data are obtained, a data conversion operation is performed, and the converted data is loaded into the wide table of the target database. Therefore, this application monitors the log files of the structured query language database to obtain the change content of the table data in the structured query language database, and synchronizes the data of multiple related tables in the structured query language database into a wide table in real time, thereby Improve the query performance of the program and simplify the query operation.
[0064] While the present application is capable of embodiments in many different forms, certain embodiments have been shown i...
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