Method and device for processing database file data index
A file data and data file technology, applied in the database field, can solve the problems of cumbersome and time-consuming data, and achieve the effect of solving cumbersome and time-consuming tasks and reducing the work of restoring the database and querying
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
no. 1 example
[0031] figure 1 It is a flow chart of the processing method of database file data index according to the first embodiment of the present invention, such as figure 1 As shown, the method includes the following steps S1 to S7:
[0032] Step S1: obtain mssql data file;
[0033] Step S2: carry out database restoration according to the mssql data file obtained, obtain the restored database;
[0034] Step S3: establish database connection to database through database connection middleware;
[0035] Step S4: obtain the data table of database;
[0036] Step S5: convert each row of data in the data table into a full-text document record respectively;
[0037] Step S6: generate a document collection with the full-text document record corresponding to the data table;
[0038] Step S7: Submit the document set to the full-text index server through the full-text index interface for data indexing.
[0039] Adopt the processing method of database file data index that this embodiment pro...
no. 2 example
[0041] This embodiment provides a processing method for data indexing of database files. In this method, file header information is automatically detected, files are automatically mounted, full-text indexes are automatically maintained, and the effect of automatic processing and maintenance is achieved.
[0042] The method first uses the header information of the file to identify the processed file to detect whether it is valid mdf data or bak file. Secondly, choose different recovery methods to restore the database according to the detection results, especially for bak files, choose a better processing method to restore complete files and differential files. Finally, extract all table data in the restored database and record them in the full-text index to realize the automatic indexing process of the mssql database.
[0043] The method of the present invention mainly comprises three stages: the stage of automatically identifying files; the stage of automatically restoring the...
no. 3 example
[0076] Figure 5 is a block diagram of a processing device for database file data indexing according to the third embodiment of the present invention, such as Figure 5 As shown, the device includes an automatic file identification module 10 , an automatic database recovery module 30 and a data extraction to full-text indexing module 50 .
[0077]Wherein, the automatic file identification module 10 is used for acquiring mssql data files. The automatic database recovery module 30 is used to recover the database according to the obtained mssql data file, and obtain the recovered database. Extracting data to the full-text index module 50 is used to establish database connection to the database through the database connection middleware, obtain each data table of the database, convert each row of data in the data table into a full-text document record respectively, and convert multiple corresponding data tables into a full-text document record. The full-text document record gene...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More