Tenant-data-based processing method and computer
A computer and data technology, applied in the computer field, can solve problems such as not supporting configurability, not being able to operate across databases, not being able to view backup data, etc., and achieve the effect of convenient viewing
Active Publication Date: 2012-05-23
深圳市金蝶精斗云网络科技有限公司
View PDF4 Cites 11 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0003] However, the data backup and recovery operations of the method provided by the above-mentioned prior art are relatively fixed, do not support configuration, cannot operate across databases, and are not suitable for the data storage method of the SAAS tenant mode
[0004] The user obtains the backup file, and cannot easily view the backup data from the backup file. The corresponding database software must be installed, and the backup file needs to be used to restore the data from the database. to related data
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0045] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.
[0046] The embodiment of the present invention provides a processing method based on SAAS tenant data, such as figure 1 As shown, the method includes the steps of:
[0047] S110. Store the template in a file format to form a template file.
[0048] In this embodiment, the template file includes a table structure file, a table primary key file and a table description file. Among them: the table structure file defines the database table name and field that needs to be backed up, and is used to generate the SELECT (selection) and INSERT (insert) data statements of the table, and the table primary ke...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention relates to a software-as-a-service (SAAS)-tenant-data-based processing method and a computer. The method comprises the following steps of: storing templates in a file format to form template files; and receiving a backup request from a user, resolving the template files according to the backup request, storing backup data in the template files in data files, compressing and encrypting all the data files and storing the compressed and encrypted data files on a server. By the method and the computer, custom backup is performed, the template files are recovered and resolved to generate corresponding structured query language (SQL) (database) statements, and the generated SQL statements are executed to operate data in the database to finally achieve the effects of configurable backup and recovery of the backup data without the limitation of the database and operate a single piece or a plurality of pieces of tenant data, thereby realizing combination with an SAAS tenant way. The backup data is stored in a file which can be a text file, and a user can conveniently view the backup data.
Description
technical field [0001] The present invention relates to the field of computer technology, in particular to a processing method based on SAAS tenant data and a computer. Background technique [0002] Data backup and recovery are very important in the process of computer data processing. The method of data backup and recovery provided by the prior art using database backup is: first back up a database backup file, and then use the backup file when restoring to restore. [0003] However, the data backup and recovery operations of the method provided by the above-mentioned prior art are relatively fixed, do not support configurability, cannot operate across databases, and are not suitable for the data storage mode of the SAAS tenant mode. [0004] The user obtains the backup file, and cannot easily view the backup data from the backup file. The corresponding database software must be installed, and the backup file needs to be used to restore the data from the database. to the ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F17/30
Inventor 唐战祥
Owner 深圳市金蝶精斗云网络科技有限公司