CN102467421A - Tenant-data-based processing method and computer - Google Patents
Tenant-data-based processing method and computer Download PDFInfo
- Publication number
- CN102467421A CN102467421A CN2010105519651A CN201010551965A CN102467421A CN 102467421 A CN102467421 A CN 102467421A CN 2010105519651 A CN2010105519651 A CN 2010105519651A CN 201010551965 A CN201010551965 A CN 201010551965A CN 102467421 A CN102467421 A CN 102467421A
- Authority
- CN
- China
- Prior art keywords
- data
- backup
- file
- template file
- request
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
The present invention relates to field of computer technology, specifically be meant a kind of disposal route and computing machine based on the SAAS tenant data.
Background technology
The backup of data and recover extremely important in to the data processing procedure at computing machine.The data backup that prior art provides, recovery adopt the method for DB Backup to be: back up out earlier a database backup file, the backup file when using backup again in the time of reduction reduces.
But data backup, the recovery operation of the method that above-mentioned prior art provides are more fixing, do not support configurable, can not integration across database operation, and be not suitable for the data storage method of SAAS tenant's pattern.
The user obtains backup file; Can not from this backup file, check Backup Data very easily; Corresponding database software must be housed, also need utilize backup file from this database, to carry out data and recover the back and see related data through professional's operation is capable after recovering.
Summary of the invention
Fundamental purpose of the present invention provides a kind of based on SAAS (Software-as-a-service; Software operation) disposal route of tenant data and computing machine; Can configurablely back up, restore data; Not limited by database, and the data that backup is come out are preserved with the form of file, make things convenient for the user to check Backup Data.
The technical solution adopted for the present invention to solve the technical problems is:
The present invention provides a kind of disposal route based on the SAAS tenant data, and it comprises:
With the format of template, form template file with file;
Receive user's backup request, resolve said template file, the Backup Data in the said template file is saved in the data file, all data files are compressed and encryption, and be stored on the server according to said backup request.
Preferably, all data files are compressed and encryption, and are stored on the server, afterwards, further comprise:
According to user's recovery request, resolve said template file, read from said data file according to said template file then and recover said Backup Data.
Preferably, said template file comprises list structure file, table major key file and table description document.
Preferably, resolve said template file, specifically comprise according to said backup request:
Said backup request is added task manager, wait until this backup request of calling of said task manager;
When calling this backup request, read said template file, resolve said template file, generate case statement;
Submit to database to carry out said backup request said case statement; According to all tables in the said template file of said request traversal fully; Generate corresponding query statement; From said database, inquiring data according to said query statement, is that unit is saved in the said data file with the table with said data.
Preferably, saidly from said data file, read and recover said Backup Data, specifically comprise according to said template file:
Related with data file according to template file, the Backup Data in the read data files generates said Backup Data the insertion statement and submits database to;
Said Backup Data is returned to the respective table of said template file according to said insertion statement from said database;
Travel through all tables in the said template file, recover all Backup Datas.
The present invention also provides a kind of computing machine, and it comprises:
Template file is set up the unit, is used for the format of template with file, forms template file;
The data backup unit; Be used to receive user's backup request, resolve said template file, the Backup Data in the said template file is saved in the data file according to said backup request; All data files are compressed and encryption, and be stored on the server.
Preferably, said computing machine also comprises:
Data recovery unit is used for the recovery request according to the user, resolves said template file, reads from said data file according to said template file then and recovers said Backup Data.
Preferably, said template file comprises list structure file, table major key file and table description document.
Preferably, said data backup unit also comprises:
Request receives subelement, is used for said backup request is added task manager, waits until this backup request of calling of said task manager;
Statement generates subelement, is used for when calling this backup request, reading said template file, resolves said template file, generates case statement;
Data are carried out subelement; Be used for submitting to database to carry out said backup request said case statement; According to all tables in the said template file of said request traversal fully; Generating corresponding query statement, from said database, inquire data according to said query statement, is that unit is saved in the said data file with the table with said data.
Preferably, said data recovery unit also comprises:
Subelement generate to be submitted in statement, is used for according to template file relatedly with data file, and the Backup Data in the read data files is with said Backup Data generation insertion statement and submit database to;
The data recovery process subelement is used for said Backup Data being returned to from said database according to said insertion statement the respective table of said template file;
The data traversal is recovered subelement, is used to travel through all tables in the said template file, recovers all Backup Datas.
The technical scheme of embodiment of the present invention has following beneficial effect: method provided by the invention and computing machine, through custom backup, recovery template file; Resolve this template file and generate corresponding SQL (database) statement; The SQL statement of carrying out generation finally reaches the effect of configurable backup, recovery Backup Data with regard to the data in the ability operating database, not limited by database; And can operate single or a plurality of tenant datas, thereby follow the combination of SAAS tenant's mode.The data that backup is come out are preserved with the form of file, and this document can be a text, and the user can easily check Backup Data.
Description of drawings
The method flow diagram that Fig. 1 provides for the embodiment of the invention;
Another process flow diagram of the method that Fig. 2 provides for the embodiment of the invention;
Fig. 3 is the particular flow sheet of the step S120 of Fig. 1 and Fig. 2;
Fig. 4 is the particular flow sheet of the step S130 of Fig. 2;
The structural representation of the computing machine that Fig. 5 provides for the embodiment of the invention;
Another structural representation of the computing machine that Fig. 6 provides for the embodiment of the invention;
Fig. 7 is the structural representation of the data backup unit among Fig. 5 and Fig. 6;
Fig. 8 is the structural representation of the data recovery unit among Fig. 6.
The realization of the object of the invention, functional characteristics and advantage will combine embodiment, further specify with reference to accompanying drawing.
Embodiment
In order to make the object of the invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with accompanying drawing and embodiment.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
The embodiment of the invention provides a kind of disposal route based on the SAAS tenant data, and as shown in Figure 1, the method comprising the steps of:
S110, with the format of template with file, form template file.
In the present embodiment, said template file comprises list structure file, table major key file and table description document.Wherein: the list structure document definition needs backed up data storehouse table name and field; With the SELECT (selection) and INSERT (insertion) data statement that generate table; Table major key document definition table name, the description of table, the major key of table, for the tables of data operation provides the unique key index, the description of table description document definition list and field description be field type; Be used for the backup file of data of description, make things convenient for the user to check Backup Data.These three template files associate through the description of table name, table.During the database structure change, only need to revise above-mentioned template file, need not revise stand-by program, just can in time back up up-to-date data.
S120, reception user's backup request is resolved said template file according to said backup request, and the Backup Data in the said template file is saved in the data file, all data files is compressed and encryption, and be stored on the server.
In the present embodiment, more concrete, as shown in Figure 3, saidly resolve said template file according to said backup request, specifically comprise:
S121, said backup request is added task manager, wait until this backup request of calling of said task manager;
S122, when calling this backup request, read said template file, resolve said template file, generate case statement;
S123, submit to database to carry out said backup request said case statement; According to all tables in the said template file of said request traversal fully; Generate corresponding query statement; From said database, inquiring data according to said query statement, is that unit is saved in the said data file with the table with said data.
In the present embodiment, when carrying out data backup, the user submits backup request to; Computing machine receives backup request through corresponding system (as: ERP, management system, perhaps other management system); Add task manager, wait for that the task of this task manager is handled.When task manager calls this backup request; Computing machine at first reads the template of configuration; Resolve template file; Generating the SELECT data statement according to this template file, submit to database to carry out query task this SELECT data statement, is that unit is saved in the data file with the table with the data that inquire.Traversal all tables in the template file, all are used for the backed up data file and compress and encrypts the most at last, and will through compression and ciphered data document storage to server, supply user's download and recovery use.
Among other the embodiment, as shown in Figure 2 on the basis of the foregoing description, at step S120, all data files are compressed and encryption, and be stored on the server, afterwards, further comprise step:
S130, according to user's recovery request, resolve said template file, read from said data file according to said template file then and recover said Backup Data.
In the present embodiment, more concrete, as shown in Figure 4, saidly from said data file, read and recover said Backup Data according to said template file, specifically comprise:
S131, related with data file according to template file, the Backup Data in the read data files generates said Backup Data the insertion statement and submits database to;
S132, said Backup Data is returned to the respective table of said template file from said database according to said insertion statement;
All tables in S133, the said template file of traversal recover all Backup Datas.
In the present embodiment, when carrying out data restore operation, the user submits the data recovery request to, and computing machine receives this data recovery request, and this data recovery request is added task manager, and the wait task manager carries out task to be handled.When task manager calls this data recovery request, at first read the template of configuration, resolve template file; Generate DELETE (deletion) statement, submit to database to carry out this SELECT (selection) data statement, deletion will recover the data (data in the past) of the table in the template file; According to template file and backed up data file association; Backup Data in the read data files, and said Backup Data is generated INSERT (look into into) data statement submit to database to carry out, Backup Data is returned in the respective table; Specifically comprise: 1, read the backup data files of this table, read Backup Data through " filename " value of each table in the table description template file; 2, describe associated data to tables of data through the title and the Chinese of each table in the table major key template file, the data in the backup file are returned to this tables of data.All tables in the traversal template file recover all Backup Datas.
The method that the foregoing description provides; Through custom backup, recovery template file, generate corresponding SQL (database) statement at this template file of parsing, the SQL statement of carrying out generation is with regard to the data in the ability operating database; Finally reach the effect of configurable backup, recovery Backup Data; Not limited by database, and can operate single or a plurality of tenant datas, thereby with the combination of SAAS tenant's mode.The data that backup is come out are preserved with the form of file, and this document can be a text, and the user can easily check Backup Data.
The embodiment of the invention also provides a kind of computing machine, and is as shown in Figure 5, and this computing machine comprises:
Template file is set up unit 510, is used for the format of template with file, forms template file, and wherein, in the present embodiment, said template file comprises list structure file, table major key file and table description document.
Request receives subelement 521, is used for said backup request is added task manager, waits until this backup request of calling of said task manager;
Statement generates subelement 522, is used for when calling this backup request, reading said template file, resolves said template file, generates case statement;
Data are carried out subelement 523; Be used for submitting to database to carry out said backup request said case statement; According to all tables in the said template file of said request traversal fully; Generating corresponding query statement, from said database, inquire data according to said query statement, is that unit is saved in the said data file with the table with said data.
Among other the embodiment, further, as shown in Figure 6, said computing machine also comprises:
Among the concrete embodiment, as shown in Figure 8, said data recovery unit 530 also comprises:
Data recovery process subelement 532 is used for said Backup Data being returned to from said database according to said insertion statement the respective table of said template file;
The data traversal is recovered subelement 533, is used to travel through all tables in the said template file, recovers all Backup Datas.
The computing machine that the foregoing description provides; Through custom backup, recovery template file, generate corresponding SQL (database) statement through resolving this template file again, the SQL statement of carrying out generation is with regard to the data in the ability operating database; Finally reach the effect of configurable backup, recovery Backup Data; Not limited by database, and can operate single or a plurality of tenant datas, thereby with the combination of SAAS tenant's mode.The data that backup is come out are preserved with the form of file, and this document can be a text, and the user can easily check Backup Data.
The above is merely preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of within spirit of the present invention and principle, being done, is equal to and replaces and improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the disposal route based on the SAAS tenant data is characterized in that, comprising:
With the format of template, form template file with file;
Receive user's backup request, resolve said template file, the Backup Data in the said template file is saved in the data file, all data files are compressed and encryption, and be stored on the server according to said backup request.
2. method according to claim 1 is characterized in that, all data files is compressed and encryption, and be stored on the server, afterwards, further comprises:
According to user's recovery request, resolve said template file, read from said data file according to said template file then and recover said Backup Data.
3. method according to claim 1 is characterized in that, said template file comprises list structure file, table major key file and table description document.
4. method according to claim 1 is characterized in that, resolves said template file according to said backup request, specifically comprises:
Said backup request is added task manager, wait until this backup request of calling of said task manager;
When calling this backup request, read said template file, resolve said template file, generate case statement;
Submit to database to carry out said backup request said case statement; According to all tables in the said template file of said request traversal fully; Generate corresponding query statement; From said database, inquiring data according to said query statement, is that unit is saved in the said data file with the table with said data.
5. like the said method of claim 2, it is characterized in that, saidly from said data file, read and recover said Backup Data, specifically comprise according to said template file:
Related with data file according to template file, the Backup Data in the read data files generates said Backup Data the insertion statement and submits database to;
Said Backup Data is returned to the respective table of said template file according to said insertion statement from said database;
Travel through all tables in the said template file, recover all Backup Datas.
6. a computing machine is characterized in that, comprising:
Template file is set up the unit, is used for the format of template with file, forms template file;
The data backup unit; Be used to receive user's backup request, resolve said template file, the Backup Data in the said template file is saved in the data file according to said backup request; All data files are compressed and encryption, and be stored on the server.
7. like the said computing machine of claim 6, it is characterized in that, also comprise:
Data recovery unit is used for the recovery request according to the user, resolves said template file, reads from said data file according to said template file then and recovers said Backup Data.
8. like the said computing machine of claim 6, it is characterized in that said template file comprises list structure file, table major key file and table description document.
9. like the said computing machine of claim 6, it is characterized in that said data backup unit also comprises:
Request receives subelement, is used for said backup request is added task manager, waits until this backup request of calling of said task manager;
Statement generates subelement, is used for when calling this backup request, reading said template file, resolves said template file, generates case statement;
Data are carried out subelement; Be used for submitting to database to carry out said backup request said case statement; According to all tables in the said template file of said request traversal fully; Generating corresponding query statement, from said database, inquire data according to said query statement, is that unit is saved in the said data file with the table with said data.
10. like the said computing machine of claim 7, it is characterized in that said data recovery unit also comprises:
Subelement generate to be submitted in statement, is used for according to template file relatedly with data file, and the Backup Data in the read data files is with said Backup Data generation insertion statement and submit database to;
The data recovery process subelement is used for said Backup Data being returned to from said database according to said insertion statement the respective table of said template file;
The data traversal is recovered subelement, is used to travel through all tables in the said template file, recovers all Backup Datas.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010551965.1A CN102467421B (en) | 2010-11-19 | 2010-11-19 | Tenant-data-based processing method and computer |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010551965.1A CN102467421B (en) | 2010-11-19 | 2010-11-19 | Tenant-data-based processing method and computer |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102467421A true CN102467421A (en) | 2012-05-23 |
| CN102467421B CN102467421B (en) | 2014-04-16 |
Family
ID=46071085
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010551965.1A Active CN102467421B (en) | 2010-11-19 | 2010-11-19 | Tenant-data-based processing method and computer |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102467421B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103118011A (en) * | 2013-01-12 | 2013-05-22 | 合肥华云通信技术有限公司 | Method for protecting customer data in multi-tenant environment |
| CN103617161A (en) * | 2013-09-26 | 2014-03-05 | 金蝶软件（中国）有限公司 | Data storing method and device for SAAS mode |
| CN107122364A (en) * | 2016-02-25 | 2017-09-01 | 华为技术有限公司 | Data manipulation method and data management server |
| CN107291574A (en) * | 2016-03-30 | 2017-10-24 | 中国石油化工股份有限公司 | Backup Data based on solution release system recovers major key generation method |
| CN109299099A (en) * | 2018-10-11 | 2019-02-01 | 瀚高基础软件股份有限公司 | A kind of the data flashback query and restoration methods, device of PostgreSQL database |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | SQL statement processing method and device |
| CN116382974A (en) * | 2023-03-21 | 2023-07-04 | 安芯网盾(北京)科技有限公司 | Customized data protection processing method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001080092A2 (en) * | 2000-04-13 | 2001-10-25 | Accenture Llp | Method for a health care solution framework |
| CN1549128A (en) * | 2003-05-15 | 2004-11-24 | 深圳市中兴通讯股份有限公司南京分公 | Databank back-up method |
| CN101158975A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for accessing distinct type data-base |
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
-
2010
- 2010-11-19 CN CN201010551965.1A patent/CN102467421B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001080092A2 (en) * | 2000-04-13 | 2001-10-25 | Accenture Llp | Method for a health care solution framework |
| CN1549128A (en) * | 2003-05-15 | 2004-11-24 | 深圳市中兴通讯股份有限公司南京分公 | Databank back-up method |
| CN101158975A (en) * | 2007-11-21 | 2008-04-09 | 金蝶软件（中国）有限公司 | Method and system for accessing distinct type data-base |
| CN101183356A (en) * | 2007-12-14 | 2008-05-21 | 华为技术有限公司 | Realization method of Excel report forms and Excel reporting system |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103118011A (en) * | 2013-01-12 | 2013-05-22 | 合肥华云通信技术有限公司 | Method for protecting customer data in multi-tenant environment |
| CN103118011B (en) * | 2013-01-12 | 2016-08-03 | 合肥华云通信技术有限公司 | The method protecting customer data in multi-tenant environment |
| CN103617161A (en) * | 2013-09-26 | 2014-03-05 | 金蝶软件（中国）有限公司 | Data storing method and device for SAAS mode |
| CN107122364A (en) * | 2016-02-25 | 2017-09-01 | 华为技术有限公司 | Data manipulation method and data management server |
| US11100101B2 (en) | 2016-02-25 | 2021-08-24 | Huawei Technologies Co., Ltd. | Data operation method and data management server |
| CN107291574A (en) * | 2016-03-30 | 2017-10-24 | 中国石油化工股份有限公司 | Backup Data based on solution release system recovers major key generation method |
| CN107291574B (en) * | 2016-03-30 | 2020-08-25 | 中国石油化工股份有限公司 | Backup data recovery primary key generation method based on interpretation system |
| CN110555030A (en) * | 2018-03-28 | 2019-12-10 | 北京京东尚科信息技术有限公司 | SQL statement processing method and device |
| CN109299099A (en) * | 2018-10-11 | 2019-02-01 | 瀚高基础软件股份有限公司 | A kind of the data flashback query and restoration methods, device of PostgreSQL database |
| CN109299099B (en) * | 2018-10-11 | 2020-11-06 | 瀚高基础软件股份有限公司 | Data flashback query and recovery method and device for PostgreSQL database |
| CN116382974A (en) * | 2023-03-21 | 2023-07-04 | 安芯网盾(北京)科技有限公司 | Customized data protection processing method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102467421B (en) | 2014-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102467421B (en) | Tenant-data-based processing method and computer | |
| CN110032604B (en) | Data storage device, translation device and database access method | |
| CN106776780B (en) | Data exchange and sharing method and system in cloud environment | |
| US8417746B1 (en) | File system management with enhanced searchability | |
| US10242051B2 (en) | Efficient multi-tenant spatial and relational indexing | |
| US20060251073A1 (en) | Methods and apparatus for transferring data | |
| US9110601B2 (en) | Backup lifecycle management | |
| US20170344433A1 (en) | Apparatus and method for data migration | |
| CN110096476A (en) | Data back up method, device and computer readable storage medium | |
| US11340838B2 (en) | Sub-cluster recovery using a partition group index | |
| US11163724B2 (en) | Data pruning based on metadata | |
| CN102339321A (en) | Network file system with version control and method using same | |
| CN101859303A (en) | Metadata management method and management system | |
| CN108334514B (en) | Data indexing method and device | |
| CN103810272A (en) | Data processing method and system | |
| CN101667178B (en) | Transaction processing method used for C/S architecture file management system | |
| CN102654878B (en) | Data operation method for distributed database in embedded system and board card | |
| KR101522870B1 (en) | Apparatus and method for encrypting data column | |
| CN103198100A (en) | Renaming method and renaming system for file synchronization among multiple devices | |
| Larson et al. | Grid-based digital libraries: Cheshire3 and distributed retrieval | |
| US20100312753A1 (en) | File management apparatus, method, and program | |
| CN102737082A (en) | Method and system for dynamically updating file data indexes | |
| WO2024051090A1 (en) | Data index management method, storage device, and medium | |
| CN102171696A (en) | Producing method and device for ordered material | |
| JP4947407B2 (en) | High efficiency cache system, high efficiency cache storage method, and high efficiency cache operation program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address |
Address after: 518000, Shenzhen, Guangdong science and Technology Park, Nanshan District science and technology twelve South Road 2 Kingdee Software Park, A, 3 South Zone Patentee after: Shenzhen Kingdee fine fighting cloud Network Technology Co., Ltd. Address before: 518000, W1 building, building 4, South high tech Industrial Village, South District, Nanshan District hi tech Zone, Guangdong, Shenzhen, Patentee before: Shenzhen Jindie Youshang E-Business Service Co., Ltd. |
|
| CP03 | Change of name, title or address |