CN103186673A - Massive data storage and inquiry method - Google Patents
Massive data storage and inquiry method Download PDFInfo
- Publication number
- CN103186673A CN103186673A CN2013101088087A CN201310108808A CN103186673A CN 103186673 A CN103186673 A CN 103186673A CN 2013101088087 A CN2013101088087 A CN 2013101088087A CN 201310108808 A CN201310108808 A CN 201310108808A CN 103186673 A CN103186673 A CN 103186673A
- Authority
- CN
- China
- Prior art keywords
- banquet
- attending
- computing machine
- picture
- metering
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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
The present invention relates to data storage and utilization field, particularly a kind of mass data storage and querying method.
Background technology
At present general mass data all needs centralized stores in the large database server, and adopts the two-node cluster hot backup mode with reply multi-user Real-time and Concurrent magnanimity accessing database.The accumulation in several years of general large database data scale can reach up to ten million, and this just requires the server configuration quite high, and memory capacity is quite big.
General picture is preserved and is adopted following dual mode under present condition: 1: adopt the image field in the database directly to preserve image information, adopt this mode as the data volume I.2. pictorial information directly is kept in the private server in the mode of file, need the uploading pictures file, not high again as the bigger access frequency of picture amount, not only increase the weight of server and bear but also wasted the storage resources of server, particularly at the data in the metering place of steel production field, the weight information that not only comprises steel also comprises a large amount of pictorial informations.
At above-mentioned problem, a kind of novel mass data storage and querying method are provided, need not extra storage resources and can having access at any time for the network user easily is the problem that prior art need solve.
Summary of the invention
Technical matters to be solved by this invention is, a kind of mass data storage and querying method are provided, and the continuous data that need not to increase steel production under the prerequisite of extra storage resources can be had access to for the network user easily at any time.
For achieving the above object, technical scheme of the present invention is, a kind of mass data storage and querying method, it is characterized in that: described method is numbered and sets up the ORACLE database storage continuous data that steel pound that computing machine is connected to collects of originally attending a banquet for the computing machine of attending a banquet for each metering place, and image data is kept in the local hard drive of the computing machine of attending a banquet; In ORACLE database continuous data table, increase a metering odd numbers field and be used for preserving metering place numbering and accurate measurement time, as unique identification each time the sign of continuous data have access to by network is shared for the user.
The title that the described Computer Storage of attending a banquet is captured picture comprises the computing machine numbering of attending a banquet, concrete time, camera numbering are numbered in the metering place.
Increase a metering odd numbers field in the described ORACLE database continuous data table and comprise metering ground piont mark, accurate measurement time, the computing machine label of attending a banquet.
Set up the mapping table of attend a banquet computing machine numbering and a computing machine static ip address in the described ORACLE database, when the network user inquires certain car continuous data, the computing machine of attending a banquet by this mapping table finds picture to preserve shows all image datas again.
The described computer system of attending a banquet is installed the IIS service, and the path that picture is preserved is made as the default access path of http protocol.
A kind of mass data storage and querying method, just do not increase the weight of load of server like this during browsing pictures, task distribution is finished in the computing machine of respectively attending a banquet, under the little situation of real time picture pageview, can be under the situation that does not increase extra investment, the idle big hard disk that takes full advantage of the computing machine of attending a banquet is preserved image data, can make things convenient for browsing pictures again.
Embodiment
The present invention for a change conventional with a large amount of pictorial information centralized stores in database or the way in the special server, carry out a large amount of metering vehicle pictorial information distributed and saved is attended a banquet in the computing machine respectively weighing, save existing server stores space to reach, alleviate server and network burden, do not increase extra server apparatus investment, improve the server operational efficiency, can guarantee that again the network user has access to required picture fast at any time.
For example, there be more than 20 motortruck scale metering place in certain factory, after carrying out concentrated long-distance metering task scheduling formula distribution and computation task is carried out in all motortruck scales meterings, need to be equipped with tens computing machines of attending a banquet motortruck scale is measured, all continuous data centralized stores are visited for all user's Real-Time Sharing at the ORACLE database.The computing machine of will attending a banquet is numbered (such as 01 ~ 15), and the metering place also is numbered and sets in configuration file.The image data of metering vehicle snapshot as file distributed and saved independently in the local hard drive of the computing machine of respectively attending a banquet, set special picture and preserve file, picture is captured the filename naming rule of preserving the back and is " two+two time+two month+two day+twice+two branch+two bps of+two meterings of computing machine numbering place numbering+camera numberings of attending a banquet ", be the picture of the 1# camera when measured 13: 17: 15 on the 26th May in 2012, captured of No. 13 computing machines of attending a banquet as " 1325120526132745-1.jpg " expression, the camera of 4 different angles is installed in general automobile metering at least, several cameras are installed are just preserved a few pictures data, with "-" after numeral distinguish different cameras, so just do not limit the number of camera, the later stage is added camera does not need to change any configuration yet.
In ORACLE database continuous data table except the field that business information such as the license number of preserving the data of weighing, forwarding unit, institutional recipient, the name of an article are set, increasing a metering odd numbers field is used for preserving metering place numbering and accurate measurement time and (carries out the preservation of computation weigh data 13: 34: 25 on the 23rd May in 2012 such as No. 16 stoichiometric points, measuring odd numbers so for " 16120523133425 ") this metering odd numbers is as unique identification sign of continuous data each time, as the primary key section of tables of data.Increase the computing machine number field of attending a banquet in addition, be used for this car of identification by any platform computer metering of attending a banquet.In database, also need to set up the mapping table of attend a banquet computing machine numbering and a computing machine static ip address.When the network user inquired certain car continuous data, if need have access to the picture concerned data, the computing machine of attending a banquet by this mapping table finds picture to preserve showed by http protocol all image datas with this car again.
What attend a banquet the general installation of computing machine is WINDOWS XP system, be can not be by http protocol visit information wherein under the default situations, therefore the computer system of attending a banquet also needs to install separately the IIS service, and the path that picture is preserved is made as the default access path of http protocol.
With will being kept in the database server in the pictures or setting up the picture file server separately of routine, which kind of mode no matter, all will increase equipment investment, server hard disc generally all is the SCSI dedicated hard disk, capacity is generally little a lot of than the serial ports hard disk that common PC uses, the former price of hard disk with capacity is the latter's several times, as it is bigger to set up picture file server investment, and centralized stores also will disperse to upload, strengthened network burden, when the picture amount reaches magnanimity, increase the weight of the server burden again, influenced the server reaction velocity.With the picture distributed and saved in capturing the computing machine of attending a banquet of picture, not only taken full advantage of the idle jumbo hard drive space of computing machine of attending a banquet, the serial ports hard-disk capacity of main flow all reaches the competent fully big capacity storage task needs of TB level at present, CPU and demonstration configuration are all than higher, can fully finish own task and can share the task of part server again, response speed is also than comparatively fast.As calculating the investment that needs to increase tens thousand of units with server hard disc, as also increasing the investment of tens thousand of units so that server calculating independently to be set, therefore can save tens thousand of units and invest.
Just do not increase the weight of load of server like this during browsing pictures, task distribution is finished in the computing machine of respectively attending a banquet, under the little situation of real time picture pageview, above method can be under the situation that does not increase extra investment, the idle big hard disk that takes full advantage of the computing machine of attending a banquet is preserved image data, can make things convenient for browsing pictures again.
By reference to the accompanying drawings the present invention has been carried out exemplary description above; obviously specific implementation of the present invention is not subjected to the restriction of aforesaid way; as long as the various improvement of having adopted technical solution of the present invention to carry out, or directly apply to other occasion without improvement, all within protection scope of the present invention.
Claims (5)
1. a mass data storage and querying method, it is characterized in that: described method is numbered and sets up the ORACLE database storage continuous data that steel pound that computing machine is connected to collects of originally attending a banquet for the computing machine of attending a banquet for each metering place, and image data is kept in the local hard drive of the computing machine of attending a banquet; In ORACLE database continuous data table, increase a metering odd numbers field and be used for preserving metering place numbering and accurate measurement time, as unique identification each time the sign of continuous data have access to by network is shared for the user.
2. a kind of mass data storage according to claim 1 and querying method is characterized in that: the title that the described Computer Storage of attending a banquet is captured picture comprises the computing machine numbering of attending a banquet, concrete time, camera numbering are numbered in the metering place.
3. a kind of mass data storage according to claim 1 and querying method is characterized in that: increase a metering odd numbers field in the described ORACLE database continuous data table and comprise metering ground piont mark, accurate measurement time, the computing machine label of attending a banquet.
4. a kind of mass data storage according to claim 1 and querying method, it is characterized in that: the mapping table of setting up attend a banquet computing machine numbering and a computing machine static ip address in the described ORACLE database, when the network user inquires certain car continuous data, the computing machine of attending a banquet by this mapping table finds picture to preserve shows all image datas again.
5. a kind of mass data storage according to claim 1 and querying method is characterized in that: the described computer system of attending a banquet is installed the IIS service, and the path that picture is preserved is made as the default access path of http protocol.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101088087A CN103186673A (en) | 2013-03-30 | 2013-03-30 | Massive data storage and inquiry method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101088087A CN103186673A (en) | 2013-03-30 | 2013-03-30 | Massive data storage and inquiry method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103186673A true CN103186673A (en) | 2013-07-03 |
Family
ID=48677840
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013101088087A Pending CN103186673A (en) | 2013-03-30 | 2013-03-30 | Massive data storage and inquiry method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103186673A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105825567A (en) * | 2016-05-18 | 2016-08-03 | 浪潮通用软件有限公司 | Weighing device, system and method used in grain purchase |
| CN112667830A (en) * | 2020-12-25 | 2021-04-16 | 厦门博海中天信息科技有限公司 | Lightweight view storage method, device, medium and equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101004679A (en) * | 2006-11-28 | 2007-07-25 | 北京龙阁创意数码科技有限公司 | Development system and development method for multiple unit animated cartoon products based on mass data |
| CN101277272A (en) * | 2008-05-16 | 2008-10-01 | 北京航空航天大学 | Method for implementing magnanimity broadcast data warehouse-in |
| US20120188252A1 (en) * | 2007-01-31 | 2012-07-26 | Salesforce.Com Inc. | Method and system for presenting a visual representation of the portion of the sets of data that a query is expected to return |
| CN102724292A (en) * | 2012-05-22 | 2012-10-10 | 中国科学院上海应用物理研究所 | Real-time database cluster architecture of control system of accelerator and establishment method thereof |
| CN102831245A (en) * | 2012-09-17 | 2012-12-19 | 洛阳翔霏机电科技有限责任公司 | Real-time data storage and reading method of relational database |
-
2013
- 2013-03-30 CN CN2013101088087A patent/CN103186673A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101004679A (en) * | 2006-11-28 | 2007-07-25 | 北京龙阁创意数码科技有限公司 | Development system and development method for multiple unit animated cartoon products based on mass data |
| US20120188252A1 (en) * | 2007-01-31 | 2012-07-26 | Salesforce.Com Inc. | Method and system for presenting a visual representation of the portion of the sets of data that a query is expected to return |
| CN101277272A (en) * | 2008-05-16 | 2008-10-01 | 北京航空航天大学 | Method for implementing magnanimity broadcast data warehouse-in |
| CN102724292A (en) * | 2012-05-22 | 2012-10-10 | 中国科学院上海应用物理研究所 | Real-time database cluster architecture of control system of accelerator and establishment method thereof |
| CN102831245A (en) * | 2012-09-17 | 2012-12-19 | 洛阳翔霏机电科技有限责任公司 | Real-time data storage and reading method of relational database |
Non-Patent Citations (1)
| Title |
|---|
| 黄少敏等: "《水电站计算机监控技术》", 31 December 2008 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105825567A (en) * | 2016-05-18 | 2016-08-03 | 浪潮通用软件有限公司 | Weighing device, system and method used in grain purchase |
| CN112667830A (en) * | 2020-12-25 | 2021-04-16 | 厦门博海中天信息科技有限公司 | Lightweight view storage method, device, medium and equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8555018B1 (en) | Techniques for storing data | |
| CN101576918B (en) | Data buffering system with load balancing function | |
| CN104391737B (en) | The optimization method of load balance in cloud platform | |
| CN104317800A (en) | Hybrid storage system and method for mass intelligent power utilization data | |
| CN105074702A (en) | Database system providing single-tenant and multi-tenant environments | |
| CN107026881B (en) | Method, device and system for processing service data | |
| CN103106218B (en) | Plug-in type on-line transaction treatment system and plug-in type on-line transaction processing method | |
| WO2012018347A1 (en) | Systems and methods for apportioning power consumption | |
| CN104462432A (en) | Self-adaptive distributed computing method | |
| CN104978324A (en) | Data processing method and device | |
| CN106649828A (en) | Data query method and system | |
| CN104866521A (en) | Apparatus For Processing Query In Database With Hybrid Storages | |
| CN103186673A (en) | Massive data storage and inquiry method | |
| CN103442056B (en) | A kind of intelligent shoe cabinet control system based on cloud platform | |
| CN106575296B (en) | Dynamic N-dimensional cube for hosted analytics | |
| CN102779298A (en) | Book and periodical printing management system | |
| CN101645062A (en) | Report form generation method, system and information management equipment | |
| JP6757437B1 (en) | How to level the annual work by having the delivery person replace the meter | |
| JP2013210816A (en) | Arrangement method by remote use | |
| CN108959324B (en) | Method and device for estimating multimedia display resource inventory and storage medium | |
| KR20110035665A (en) | Ranking data system, ranking query system and ranking computation method for computing large scale ranking in real time | |
| CN112115120B (en) | Service data storage method, device and equipment | |
| AU2019422010B2 (en) | Intelligent geofence provisioning | |
| CN204102026U (en) | Large database concept all-in-one | |
| TWI630496B (en) | Data storage method and system thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130703 |
|
| RJ01 | Rejection of invention patent application after publication |