CN103093324A - Inventory management system based on data sheet splitting technology - Google Patents
Inventory management system based on data sheet splitting technology Download PDFInfo
- Publication number
- CN103093324A CN103093324A CN2011103354998A CN201110335499A CN103093324A CN 103093324 A CN103093324 A CN 103093324A CN 2011103354998 A CN2011103354998 A CN 2011103354998A CN 201110335499 A CN201110335499 A CN 201110335499A CN 103093324 A CN103093324 A CN 103093324A
- Authority
- CN
- China
- Prior art keywords
- data
- module
- tables
- inventory
- query
- 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
- 238000005516 engineering process Methods 0.000 title abstract description 8
- 238000007726 management method Methods 0.000 claims abstract description 15
- 238000012423 maintenance Methods 0.000 claims abstract description 9
- 238000000034 method Methods 0.000 claims description 16
- 238000005194 fractionation Methods 0.000 claims description 9
- 238000013523 data management Methods 0.000 claims description 3
- 238000012217 deletion Methods 0.000 claims description 2
- 230000037430 deletion Effects 0.000 claims description 2
- 230000004927 fusion Effects 0.000 claims description 2
- 238000012986 modification Methods 0.000 claims description 2
- 230000004048 modification Effects 0.000 claims description 2
- 238000012545 processing Methods 0.000 claims description 2
- 238000004891 communication Methods 0.000 abstract description 2
- 238000013144 data compression Methods 0.000 abstract 2
- 238000006243 chemical reaction Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005538 encapsulation Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to an inventory management system, in particular to an inventory management system based on the data sheet splitting technology, and belongs to the field of network communication. The inventory management system based on the data sheet splitting technology is characterized by comprising a data statistic module, a data compression module, a data splitting module, a data maintenance module, a data query module and a data backup management module, wherein the data statistic module is used for completing the statistical work of all data, the data compression module is used for compressing the data after statistics, the data splitting module is used for splitting of the compressed data, the data maintenance module is used for maintaining inventory data, the data query module is used for completing query work of an inventory system, and the data backup management module is used for data backup. According to the inventory management system based on the data sheet splitting technology, a user does not need to query logs from a large amount of data, and data amount in a split sheet can guarantee that the user can query a log in one second and data maintenance can be quick. By means of the data sheet splitting technology, under the premise that a storage space in a server is not enlarged, pressure of a database server can be reduced, and efficiency of the inventory system is improved.
Description
Technical field
The present invention relates to inventory management system, especially the inventory management system of based on data table disassemble technique.The invention belongs to network communication field.
Background technology
In recent years, the business activity of enterprise is day by day frequent, and the inventory data scale of generation is also day by day huge.Arrival along with digital times, enterprise faces the competition from links, and inventory management is exactly that stock to enterprise manages, and mainly comprises the information management of stock and decision analysis on this basis, control effectively at last, the final purpose that reaches inventory management is increased economic efficiency.Inventory management is the inventory policy of the inventory policy of manufacturer and value chain to be carried out the combined process of operation.Reaction method or claim pull-type stock method is to utilize customer demand, pulls the dispensing of product by the distribution channel.
But there is following drawback in above-mentioned technology: due to the increase of business data amount, data volume is increasing after enterprise uses system.This just causes the corresponding speed of system slack-off, and a common inventory statistics form often needs to wait for very long just seeing.Again stock's pressure that causes system of modifying is become large after annual or per month inventory statistics.Inventory management method has before reduced the efficient of inventory system greatly.
The present invention splits data per month by the tables of data disassemble technique automatically by a kind of inventory system of based on data table disassemble technique.Be based on the senior application of database technology due to the table disassemble technique of the present invention's employing, so native system has efficient faster.
Summary of the invention
The object of the invention is to: for the deficiencies in the prior art, inventory system by based on data table disassemble technique, make user data table split mode, inquire about or safeguard inventory data, by the tables of data disassemble technique, data are per month isolated, the user does not need query note from mass data again, and the data volume in split table guarantees that the user can inquire in 1 second, and also can carry out fast the maintenance of data.The tables of data disassemble technique has alleviated the pressure of database server under the prerequisite that does not strengthen the server stores space, improved the efficient of inventory system.
For achieving the above object, the present invention includes following functional module:
Data statistics module: complete the statistical work of all data.
--described data statistics module is added up the data of all tables of inventory system, the size of each tables of data and record number and store.
Data compressing module: compress according to the data after statistics.
--size after described data compressing module will be added up and record number and gather, identify accuracy and the redundancy of data.And obtain the processing speed of the I/O handling capacity/CPU of database server, and according to these indexs, data are reasonably compressed.
Data Division module: complete the fractionation to packed data.
--described Data Division module is obtained compressed data, and the fractionation of showing according to the size of data volume guarantees that the table data after fractionation have the highest access efficiency; Table after fractionation is the same with tables of data before can be safeguarded normally.
Data maintenance module: complete the maintenance of inventory data.
--described data maintenance module with all operations that need to safeguard in inventory system as: newly-increased, modification, deletion etc. operate.
Data query module: complete the inquiry work of inventory system.
--described data query module will arrange according to the querying condition of system.And according to binary tree algorithm, the table that has split is retrieved.If data exist in several tables.Adopt the method for Fusion query that data are read out.
Backup data management module: complete data backup function.
--described backup data management module splits the data full backup with former table data and table.Guarantee the security of data.
The user uses step to be:
Step 1: the statistics of carrying out tables of data by data statistics module;
Step 2: the tables of data that will add up good is compressed;
Step 3: size and line number according to tables of data select to split strategy;
Step 4: tables of data is split according to strategy;
Step 5: obtain the user to the attended operation of inventory system;
Step 6: database will automatically be searched the user and operate needed tables of data;
Step 7: database returns to the needed data of user;
Step 8: former tables of data and split table data are backed up.
Embodiment
The feature that the present invention announces and use step all can be carried out the equivalence replacement by similar function, and unless specifically stated otherwise, the arbitrary steps in this embodiment are an example of a series of equivalences or similar characteristics.
Embodiment one
The user uses step to be:
Step 1: carry out the statistics of tables of data by data statistics module, each tables of data of data-base recording take up room and tables of data record line number.And the data that come out are written in buffer memory.
Step 2: read the data statistics information in buffer memory.Also can compress for traditional LOB field, will reduce greatly the memory space requirements of large database.
Step 3: size and line number according to tables of data are selected to split strategy, and system default adopts take the moon as the flat data table disassemble technique.The user can also select to press data acknowledgment number, wait mode to add the fractionation strategy to tables of data per year according to demand.
Step 4: according to strategy, tables of data is split, the fractionation policy system of form will add days column for each system table by date.And strategy is saved in former tables of data.
Step 5: obtain the user to the concrete operations of inventory system.The user will carry out format conversion by the data exchange standard of database to all operations of inventory system.
Step 6: database will carry out searching of binary tree algorithm to data in split table according to the data layout of standard.
Step 7: database carries out standardized form encapsulation with the data that gather and returns to the data that the user wants, and normal data is shown to the user in the mode of UI.
Step 8: former tables of data and split table data are backed up.Backup policy has incremental backup, backs up 2 kinds of patterns fully.
In addition to the implementation, the present invention can also have other embodiments.All employings are equal to the technical scheme of replacement or equivalent transformation formation, all drop on the protection domain of requirement of the present invention.
Claims (2)
1. the inventory management system of a based on data table disassemble technique, it is characterized in that: completing inventory system needs data statistics module, data compressing module, Data Division module, data maintenance module, data query module:
Described data statistics module is added up the data of all tables of inventory system, the size of each tables of data and record number and store;
Size after described data compressing module will be added up and record number and gather identifies accuracy and the redundancy of data, and obtains the processing speed of the I/O handling capacity/CPU of database server, and according to these indexs, data reasonably compressed;
Described Data Division module is obtained compressed data, and the fractionation of showing according to the size of data volume guarantees that the table data after fractionation have the highest access efficiency, and the table after fractionation is the same with tables of data before can be safeguarded normally;
Described data maintenance module with all operations that need to safeguard in inventory system as: newly-increased, modification, deletion etc. operate;
Described data query module will arrange according to the querying condition of system, and according to binary tree algorithm, the table that has split is retrieved, if data exist in several tables, adopts the method for Fusion query that data are read out;
Described backup data management module splits the data full backup with former table data and table, guarantees the security of data.
2. a kind of inventory system of based on data table disassemble technique according to claim 1, be further characterized in that: completing inventory system also needs following steps:
Step 1: the statistics of carrying out tables of data by data statistics module;
Step 2: the tables of data that will add up good is compressed;
Step 3: size and line number according to tables of data select to split strategy;
Step 4: tables of data is split according to strategy;
Step 5: obtain the user to the attended operation of inventory system;
Step 6: database will automatically be searched the user and operate needed tables of data;
Step 7: database returns to the needed data of user;
Step 8: former tables of data and split table data are backed up.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103354998A CN103093324A (en) | 2011-10-27 | 2011-10-27 | Inventory management system based on data sheet splitting technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103354998A CN103093324A (en) | 2011-10-27 | 2011-10-27 | Inventory management system based on data sheet splitting technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103093324A true CN103093324A (en) | 2013-05-08 |
Family
ID=48205864
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011103354998A Pending CN103093324A (en) | 2011-10-27 | 2011-10-27 | Inventory management system based on data sheet splitting technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103093324A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105868421A (en) * | 2016-06-12 | 2016-08-17 | 浪潮通用软件有限公司 | Data management method and data management device |
| CN109325050A (en) * | 2018-08-01 | 2019-02-12 | 吉林盘古网络科技股份有限公司 | Data query method, apparatus and terminal device |
| CN112347098A (en) * | 2020-09-27 | 2021-02-09 | 武汉虹信科技发展有限责任公司 | Database table splitting method and system, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002093455A2 (en) * | 2001-05-16 | 2002-11-21 | Reengineering Llc | Semantic encoding and compression of database tables |
| CN101566986A (en) * | 2008-04-21 | 2009-10-28 | 阿里巴巴集团控股有限公司 | Method and device for processing data in online business processing |
| CN101968806A (en) * | 2010-10-22 | 2011-02-09 | 天津南大通用数据技术有限公司 | Data storage method, querying method and device |
| CN101996250A (en) * | 2010-11-15 | 2011-03-30 | 中国科学院计算技术研究所 | Hadoop-based mass stream data storage and query method and system |
| US20110185149A1 (en) * | 2010-01-27 | 2011-07-28 | International Business Machines Corporation | Data deduplication for streaming sequential data storage applications |
-
2011
- 2011-10-27 CN CN2011103354998A patent/CN103093324A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2002093455A2 (en) * | 2001-05-16 | 2002-11-21 | Reengineering Llc | Semantic encoding and compression of database tables |
| CN101566986A (en) * | 2008-04-21 | 2009-10-28 | 阿里巴巴集团控股有限公司 | Method and device for processing data in online business processing |
| US20110185149A1 (en) * | 2010-01-27 | 2011-07-28 | International Business Machines Corporation | Data deduplication for streaming sequential data storage applications |
| CN101968806A (en) * | 2010-10-22 | 2011-02-09 | 天津南大通用数据技术有限公司 | Data storage method, querying method and device |
| CN101996250A (en) * | 2010-11-15 | 2011-03-30 | 中国科学院计算技术研究所 | Hadoop-based mass stream data storage and query method and system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105868421A (en) * | 2016-06-12 | 2016-08-17 | 浪潮通用软件有限公司 | Data management method and data management device |
| CN109325050A (en) * | 2018-08-01 | 2019-02-12 | 吉林盘古网络科技股份有限公司 | Data query method, apparatus and terminal device |
| CN112347098A (en) * | 2020-09-27 | 2021-02-09 | 武汉虹信科技发展有限责任公司 | Database table splitting method and system, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102790686A (en) | Log data collecting method and system and log collecting server | |
| CN103116661B (en) | A kind of data processing method of database | |
| CN102779138B (en) | The hard disk access method of real time data | |
| CN109669975B (en) | Industrial big data processing system and method | |
| CN101087210A (en) | High-performance Syslog processing and storage method | |
| CN102609337A (en) | Rapid data recovery method for memory database | |
| CN101957865A (en) | Data exchange and sharing technology among heterogeneous systems | |
| CN104391948A (en) | Data standardization construction method and system of data warehouse | |
| CN110609813B (en) | A data storage system and method | |
| CN103473276B (en) | Ultra-large type date storage method, distributed data base system and its search method | |
| CN103365971A (en) | Mass data access processing system based on cloud computing | |
| CN110489490A (en) | Data storage and query method based on distributed data base | |
| CN103390045A (en) | Time sequence storage method and time sequence storage device for monitoring system | |
| CN111008183A (en) | Storage method and system for business wind control log data | |
| CN102890721A (en) | Database establishment method and database establishment system based on column storage technology | |
| CN103093324A (en) | Inventory management system based on data sheet splitting technology | |
| CN114691762A (en) | How to build enterprise data intelligence | |
| CN105786877B (en) | A data storage method, system and query method | |
| CN105447168A (en) | Method for restoring and recombining fragmented files in MP4 format | |
| CN103631600A (en) | Data processing method and system for embedded RFID (radio frequency identification) middleware | |
| CN101840563A (en) | Financial data service system | |
| CN104391891A (en) | Heterogeneous replication method for database | |
| CN104156395A (en) | Data storage system | |
| CN109829003A (en) | Database backup method and device | |
| US20080255974A1 (en) | Techniques to manage financial performance data exchange with standard taxonomies |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20130508 |