Massive data storage and inquiry method

Abstract

The invention discloses a massive data storage and inquiry method which is characterized by comprising the following steps of: numbering seat computers of measuring places, constructing an ORACLE database, storing measured data acquired by a steel material weight connected to a seat computer, and storing picture data into a local hard disk of the seat computer; and adding a measuring odd-number field into a measuring data sheet of the ORACLE database for storing a measuring place number and accurate measuring time, wherein the measuring odd-number field is used as a mark for uniquely identifying the measured data at each time, so that a user can schedule and read the data through network sharing. Therefore, when a picture is browsed, the burden of a server is not increased; tasks are distributed into the seat computers; under the conditions that the real-time picture browsing amount is small, and extra investment is not increased, picture data are stored into idling hard disks of the seat computers, and pictures can be conveniently browsed.

Description

technical field [0001] The invention relates to the field of data storage and application, in particular to a massive data storage and query method. Background technique [0002] At present, generally mass data needs to be stored in a large database server in a centralized manner, and a dual-machine hot backup method is adopted to cope with real-time concurrent massive access to the database by multiple users. Generally, the data scale of a large-scale database can accumulate up to tens of millions in a few years, which requires a relatively high server configuration and a relatively large storage capacity. [0003] Under the current conditions, the following two methods are generally used for image storage: 1: Use the image field in the database to directly save image information, and this method can be used if the amount of data is small. 2. Save the picture information directly in the form of a file in a dedicated server. You need to upload the picture file. If the pictu...

AI Technical Summary

Problems solved by technology

2. Save the picture information directly in the form of a file in a dedicated server. You need to upload the picture file. If the picture volume is relatively large and the access frequency is not high, it will not only increase the burden on the server but also waste the storage resources of the server, especially for the steel production field. The data of the measuring location, not only contains the weight information of the steel but also includes a large amount of picture information