CN112527739A - Local area network file retrieval preview system and equipment - Google Patents
Local area network file retrieval preview system and equipment Download PDFInfo
- Publication number
- CN112527739A CN112527739A CN202011426382.6A CN202011426382A CN112527739A CN 112527739 A CN112527739 A CN 112527739A CN 202011426382 A CN202011426382 A CN 202011426382A CN 112527739 A CN112527739 A CN 112527739A
- Authority
- CN
- China
- Prior art keywords
- file
- path
- previewing
- files
- area network
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 claims abstract description 17
- 239000000126 substance Substances 0.000 claims 1
- 230000008569 process Effects 0.000 abstract description 9
- 230000004044 response Effects 0.000 abstract description 3
- 230000000007 visual effect Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 5
- 230000006872 improvement Effects 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 230000008094 contradictory effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/156—Query results presentation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/18—File system types
- G06F16/182—Distributed file systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a system and equipment for previewing file retrieval of a local area network. The system comprises: the document server is used for storing the files and hierarchically organizing the files according to the folders; the database server is used for constructing a file path table, traversing file paths under the specified paths according to time intervals and updating the file paths in the database table; the client sides are used for retrieving the files and previewing the retrieved files; the document server, the database server and the plurality of clients are connected through the Ethernet. The local area network file retrieval preview system and the local area network file retrieval preview device provided by the embodiment of the invention have the characteristics of high retrieval response speed, real-time update of file paths without manual intervention, high file searching efficiency, support of more format preview function extensions, and visual and rapid file content presentation, improve the file identification utilization efficiency, and ensure the safety of the file using process.
Description
Technical Field
The embodiment of the invention relates to the technical field of electronic document management, in particular to a system and equipment for previewing file retrieval of a local area network.
Background
Engineering companies involve multiple specialties and multiple stages of implementation, producing large and rapidly growing numbers of documents, on the order of millions or even tens of millions. Generally, technicians search for files and preview the files manually, and with the increasing amount of the files, the technicians are difficult to quickly find and preview the required files, so that the working efficiency is influenced to a certain extent. Therefore, it is an urgent technical problem in the art to develop a system and a device for retrieving and previewing files on a lan to effectively overcome the above-mentioned drawbacks in the related art.
Disclosure of Invention
In view of the above problems in the prior art, embodiments of the present invention provide a system and an apparatus for previewing a file search on a local area network.
In a first aspect, an embodiment of the present invention provides a system for previewing file retrieval on a local area network, including: the document server is used for storing the files and hierarchically organizing the files according to the folders; the database server is used for constructing a file path table, traversing file paths under the specified paths according to time intervals and updating the file paths in the database table; the client sides are used for retrieving the files and previewing the retrieved files; the document server, the database server and the plurality of clients are connected through the Ethernet.
On the basis of the contents of the above system embodiment, the file path table of the local area network file retrieval preview system provided in the embodiment of the present invention includes: the file ID, file name, file path and creation date, the file name and file path being indexed separately.
On the basis of the contents of the above system embodiment, the system for retrieving and previewing files on a local area network provided in the embodiment of the present invention updates a file path in a database table, including: the method comprises the steps of backing up original file path data, obtaining a first initial folder path, adding a subfolder name and a subfolder path or a subfile name and a subfile path to a file path table if the subfolder or the subfile exists in the first initial folder path, setting the subfolder path or the subfile path as a second initial folder path, and ending updating the file path in a database table if a new subfolder or a new subfile does not exist in the second initial folder path.
On the basis of the contents of the above system embodiment, the system for retrieving and previewing a file on a local area network provided in the embodiment of the present invention includes: and inputting a file name and a file path in a user interface, and searching the file through a file searching SQL statement.
On the basis of the contents of the above system embodiment, the system for previewing file retrieval of a local area network provided in the embodiment of the present invention, which previews a retrieved file, includes: and presenting the searched files on the interface in a tree structure, double-clicking the corresponding file names, and previewing the file formats by adopting corresponding controls according to different file formats.
In a second aspect, an embodiment of the present invention provides an electronic device, including:
at least one processor; and
at least one memory communicatively coupled to the processor, wherein:
the memory stores program instructions executable by the processor, the processor calling the program instructions to perform the local area network file retrieval preview system provided by any of the various implementations of the first aspect.
In a third aspect, an embodiment of the present invention provides a non-transitory computer-readable storage medium storing computer instructions for causing a computer to implement the lan file retrieval preview system provided in any one of the various implementations of the first aspect.
According to the local area network file retrieval preview system and the local area network file retrieval preview equipment, the file server, the database server and the plurality of clients are subjected to system integration through the Ethernet, and the system has the characteristics of high retrieval response speed, real-time updating of file paths without manual intervention, high file searching efficiency, support of more format preview function expansion, visual and fast file content presentation, improvement of file identification and utilization efficiency and guarantee of the safety of a file using process.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, a brief description will be given below to the drawings required for the description of the embodiments or the prior art, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a schematic structural diagram of a local area network file retrieval preview system according to an embodiment of the present invention;
fig. 2 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a file path updating process according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a document retrieval interface according to an embodiment of the present invention;
fig. 5 is a schematic diagram of a PDF file preview according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention. In addition, technical features of various embodiments or individual embodiments provided by the present invention may be arbitrarily combined with each other to form a feasible technical solution, and such combination is not limited by the sequence of steps and/or the structural composition mode, but must be realized by a person skilled in the art, and when the technical solution combination is contradictory or cannot be realized, such a technical solution combination should not be considered to exist and is not within the protection scope of the present invention.
An embodiment of the present invention provides a system for previewing file retrieval on a local area network, and referring to fig. 1, the system includes: the document server is used for storing the files and hierarchically organizing the files according to the folders; the database server is used for constructing a file path table, traversing file paths under the specified paths according to time intervals and updating the file paths in the database table; the client sides are used for retrieving the files and previewing the retrieved files; the document server, the database server and the plurality of clients are connected through the Ethernet.
Based on the content of the foregoing system embodiment, as an optional embodiment, the file path table of the local area network file retrieval preview system provided in the embodiment of the present invention includes: the file ID, file name, file path and creation date, the file name and file path being indexed separately. Specifically, the database software runs on a database Server, the database software can select typical database software such as Oracle, SQL Server, MySQL and the like, a file path table is established on the database software, the file path table comprises fields such as file ID, file name, file path, creation date and the like, and indexes are respectively established on the file name and the file path.
Based on the content of the foregoing system embodiment, as an optional embodiment, the system for previewing file retrieval on a local area network provided in the embodiment of the present invention, where the updating a file path in a database table includes: the method comprises the steps of backing up original file path data, obtaining a first initial folder path, adding a subfolder name and a subfolder path or a subfile name and a subfile path to a file path table if the subfolder or the subfile exists in the first initial folder path, setting the subfolder path or the subfile path as a second initial folder path, and ending updating the file path in a database table if a new subfolder or a new subfile does not exist in the second initial folder path. Specifically, the path updating software runs on the database server, automatically traverses the file path under the designated path at a time interval and updates the file path in the database table, the file path updating process is as shown in fig. 3, the original file path data is backed up, the initial folder path is obtained after the backup is completed, whether the subfolder or the subfile exists is judged, if the subfolder or the subfile exists, the subfolder, the file name of the subfolder and the file path are added to the file path table, the subfolder path is set as the initial folder path one by one, the initial folder path and the subsequent steps are repeatedly obtained until the subfolder or the subfile cannot be found, and the process is ended. The partial file path can be referred to table 1.
TABLE 1
Based on the content of the foregoing system embodiment, as an optional embodiment, the system for retrieving and previewing a file on a local area network provided in the embodiment of the present invention, where the retrieving file includes: and inputting a file name and a file path in a user interface, and searching the file through a file searching SQL statement.
Based on the content of the foregoing system embodiment, as an optional embodiment, the system for previewing file retrieval on a local area network provided in the embodiment of the present invention includes: and presenting the searched files on the interface in a tree structure, double-clicking the corresponding file names, and previewing the file formats by adopting corresponding controls according to different file formats.
Specifically, file retrieval and preview software is operated on a client, a user logs in the file retrieval and preview software after inputting a user name and a domain access password to verify the identity, a retrieval user interface is shown in fig. 4, a file name and a file path can be input on the user interface, file retrieval is realized through a file retrieval SQL statement, after a relevant file is retrieved, a result is presented on the interface in a tree structure and is expanded step by step, preview of a corresponding file format can be realized through double clicking of the corresponding file name and through a corresponding control, as shown in fig. 5, for different file formats, the corresponding control is selected to realize preview, and preview and expansion of various file formats are realized. And operating file searching and previewing software, inputting file names and file path keywords, searching files, expanding the tree structure step by step as shown in figure 4, double-clicking the corresponding file names, and previewing the corresponding file formats as shown in figure 5.
According to the local area network file retrieval preview system and the local area network file retrieval preview equipment, the file server, the database server and the plurality of clients are subjected to system integration through the Ethernet, and the system has the characteristics of high retrieval response speed, real-time updating of file paths without manual intervention, high file searching efficiency, support of more format preview function expansion, visual and fast file content presentation, improvement of file identification and utilization efficiency and guarantee of the safety of a file using process.
The system of the embodiment of the invention is realized by depending on the electronic equipment, so that the related electronic equipment is necessarily introduced. To this end, an embodiment of the present invention provides an electronic apparatus, as shown in fig. 2, including: at least one processor (processor)201, a communication Interface (communication Interface)204, at least one memory (memory)202 and a communication bus 203, wherein the at least one processor 201, the communication Interface 204 and the at least one memory 202 are configured to communicate with each other via the communication bus 203. The at least one processor 201 may invoke logic instructions in the at least one memory 202 to implement the various systems provided in the system embodiments.
Furthermore, the logic instructions in the at least one memory 202 may be implemented in software functional units and stored in a computer readable storage medium when sold or used as a stand-alone product. Based on such understanding, the technical solution of the present invention may be substantially implemented or contributed to by the prior art, or the technical solution may be implemented in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the system according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for enabling a computer device (which may be a personal computer, a server, or a network device, etc.) to implement the methods or systems of the various embodiments or some parts of the embodiments.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. Based on this recognition, each block in the flowchart or block diagrams may represent a module, a program segment, or a portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In this patent, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (7)
1. A system for previewing file searches on a local area network, comprising: the document server is used for storing the files and hierarchically organizing the files according to the folders; the database server is used for constructing a file path table, traversing file paths under the specified paths according to time intervals and updating the file paths in the database table; the client sides are used for retrieving the files and previewing the retrieved files; the document server, the database server and the plurality of clients are connected through the Ethernet.
2. The lan file retrieval preview system of claim 1, wherein the file path table comprises: the file ID, file name, file path and creation date, the file name and file path being indexed separately.
3. The system for previewing file retrieval on local area network according to claim 1, wherein said updating the file path in the database table comprises: the method comprises the steps of backing up original file path data, obtaining a first initial folder path, adding a subfolder name and a subfolder path or a subfile name and a subfile path to a file path table if the subfolder or the subfile exists in the first initial folder path, setting the subfolder path or the subfile path as a second initial folder path, and ending updating the file path in a database table if a new subfolder or a new subfile does not exist in the second initial folder path.
4. The system for previewing file retrieval for local area network according to claim 1, wherein said retrieving file comprises: and inputting a file name and a file path in a user interface, and searching the file through a file searching SQL statement.
5. The system for previewing file retrieval on local area network of claim 1, wherein said previewing the retrieved file comprises: and presenting the searched files on the interface in a tree structure, double-clicking the corresponding file names, and previewing the file formats by adopting corresponding controls according to different file formats.
6. An electronic device, comprising:
at least one processor, at least one memory, a communication interface, and a bus; wherein the content of the first and second substances,
the processor, the memory and the communication interface complete mutual communication through the bus;
the memory stores program instructions executable by the processor, which are invoked by the processor to implement the system of any one of claims 1 to 5.
7. A non-transitory computer-readable storage medium storing computer instructions that cause a computer to implement the system of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011426382.6A CN112527739A (en) | 2020-12-09 | 2020-12-09 | Local area network file retrieval preview system and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011426382.6A CN112527739A (en) | 2020-12-09 | 2020-12-09 | Local area network file retrieval preview system and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112527739A true CN112527739A (en) | 2021-03-19 |
Family
ID=74996793
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011426382.6A Pending CN112527739A (en) | 2020-12-09 | 2020-12-09 | Local area network file retrieval preview system and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112527739A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113505153A (en) * | 2021-05-11 | 2021-10-15 | 深圳软牛科技有限公司 | Memorandum backup method based on iOS system and related equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810221A (en) * | 2012-11-15 | 2014-05-21 | 腾讯科技（深圳）有限公司 | File previewing method and device |
| CN105630932A (en) * | 2015-12-22 | 2016-06-01 | 北京奇虎科技有限公司 | Method and device for managing files of intelligent terminals |
| US20180288124A1 (en) * | 2017-03-28 | 2018-10-04 | Turner Broadcasting System, Inc. | Platform for publishing graphics to air |
| CN111680005A (en) * | 2020-04-27 | 2020-09-18 | 平安国际智慧城市科技股份有限公司 | File online preview method, device, system, equipment and storage medium |
-
2020
- 2020-12-09 CN CN202011426382.6A patent/CN112527739A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810221A (en) * | 2012-11-15 | 2014-05-21 | 腾讯科技（深圳）有限公司 | File previewing method and device |
| CN105630932A (en) * | 2015-12-22 | 2016-06-01 | 北京奇虎科技有限公司 | Method and device for managing files of intelligent terminals |
| US20180288124A1 (en) * | 2017-03-28 | 2018-10-04 | Turner Broadcasting System, Inc. | Platform for publishing graphics to air |
| CN111680005A (en) * | 2020-04-27 | 2020-09-18 | 平安国际智慧城市科技股份有限公司 | File online preview method, device, system, equipment and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113505153A (en) * | 2021-05-11 | 2021-10-15 | 深圳软牛科技有限公司 | Memorandum backup method based on iOS system and related equipment |
| CN113505153B (en) * | 2021-05-11 | 2024-06-04 | 深圳软牛科技有限公司 | Memorandum backup method based on iOS system and related equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8332357B1 (en) | Identification of moved or renamed files in file synchronization | |
| CN102741803B (en) | For the system and method promoting data to find | |
| Sanderson et al. | Automatic data organization, storage, and analysis of camera trap pictures | |
| US7685106B2 (en) | Sharing of full text index entries across application boundaries | |
| US20080270462A1 (en) | System and Method of Uniformly Classifying Information Objects with Metadata Across Heterogeneous Data Stores | |
| US20020116402A1 (en) | Information component based data storage and management | |
| US8880463B2 (en) | Standardized framework for reporting archived legacy system data | |
| CN110727687B (en) | Material list conversion method and system | |
| US20070156791A1 (en) | File system dump/restore by node numbering | |
| JP6645850B2 (en) | Information management apparatus, information management method, and information management program | |
| CN111984732B (en) | Method, node and blockchain network for implementing decentralization search on blockchain | |
| CN109376121A (en) | A kind of document indexing system and method based on ElasticSearch full-text search | |
| CA2734207C (en) | Electronic file comparator | |
| CN112527739A (en) | Local area network file retrieval preview system and equipment | |
| US20080250068A1 (en) | System for preparing reports | |
| EP2691881A2 (en) | Finding a data item of a plurality of data items stored in a digital data storage | |
| US8032521B2 (en) | Managing structured content stored as a binary large object (BLOB) | |
| CA3135324A1 (en) | Versioned backup on an object addressable storage system | |
| CN103309899A (en) | Data protection system file index structure and updating and positioning methods | |
| CN105453086B (en) | Concept utilization to obtain user-specific data of interest from one or more data storage locations | |
| US20170293645A1 (en) | Organizing multiple versions of content | |
| CN115033526A (en) | Electronic file filing system and method | |
| CN111694988B (en) | Analysis method and equipment for AE300 aeroengine event record file | |
| KR20160139694A (en) | Ship Design Data Management System Using Hadoop and HBase | |
| Singhal et al. | Computational transformation from web to Ebook archiving |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210319 |