CN103955483A - Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain - Google Patents
Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain Download PDFInfo
- Publication number
- CN103955483A CN103955483A CN201410137551.2A CN201410137551A CN103955483A CN 103955483 A CN103955483 A CN 103955483A CN 201410137551 A CN201410137551 A CN 201410137551A CN 103955483 A CN103955483 A CN 103955483A
- Authority
- CN
- China
- Prior art keywords
- data
- star
- dimension table
- multidimensional analysis
- supply chain
- 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
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a multi-dimensional analysis method of data in an RFID (Radio Frequency Identification) supply chain. The multi-dimensional analysis method comprises the following steps: (1) acquiring data; (2) designing a star-type multidimensional analysis model according to the acquired data; (3) converting data in an intermediate database into a relational database with star-type architectural features according to the designed star-type multidimensional analysis model; and (4) displaying data in the relational database with the star-type architectural features by a client terminal. The multi-dimensional analysis method disclosed by the invention has the advantages that the star-type multidimensional analysis model is designed by multi-dimensional data analysis, and the data in the intermediate database is converted into the relational database with the star-type architectural features on the basis of the star-type multidimensional analysis model, and finally is displayed by the client terminal; the data and the relation between the data can be displayed intuitively, and the multi-dimensional analysis method is mainly used for providing support for decision making and management of decision makers and senior managers.
Description
Technical field
The present invention relates to a kind of multidimensional analysis method, be specifically related to a kind of multidimensional analysis method of RFID supply chain data.
Background technology
In RFID supply chain system, there are the data of magnanimity, such as the possession at the numbering of, article, the numbering that is stored in region in storehouse, storehouse, place, storehouse, stock etc.For businessman, the packet of these magnanimity has contained the sales situation of article, directly affects the interests of self.Therefore just need to carry out good tissue to these data presents.
Conventionally these data are stored in relational database (OLTP) now, but OLTP faces is operating personnel and low layer managerial personnel, data is carried out to basic inquiry and additions and deletions operation is more convenient, and cannot provide support to decision-making and management.Be basic complex data analysis technology and multidimensional data analysis (OLAP) is a mass data, that stress to face is decision-making level and senior management staff, can show very clearly the relation of data.Therefore multidimensional data analysis provides new thinking and method to us, can provide support for decision-making and management.
Summary of the invention
The invention provides a kind of multidimensional analysis method of RFID supply chain data, the data that solved in relation data library storage RFID supply chain system cannot and be managed the problem providing support to decision-making.
In order to solve the problems of the technologies described above, the technical solution adopted in the present invention is:
A multidimensional analysis method for RFID supply chain data, comprises the following steps,
Step 1, data acquisition, by all data acquisitions of each site in RFID supply chain system in an intermediate database on statistic analysis server;
Step 2, according to the star-like multidimensional analysis models of design data gathering;
Step 3, deposits the data in intermediate database in a relevant database with star schema feature according to the star-like multidimensional analysis models of design;
Step 4, shows the data that have in the relevant database of star schema feature by client terminal.
The process that designs star-like multidimensional analysis models in step 2 is, according to the data construct fact table and the dimension table that gather, dimension table is linked in fact table on a corresponding with it external key by a major key.
Described fact table comprises numbering, date, region, total amount and day maximum extracted amount, and wherein numbering, date and region are external key; Described dimension table comprises numbering dimension table, date dimension table and region dimension table, described numbering dimension table comprises Item Number, kind numbering and large class numbering, wherein Item Number is major key, described date dimension table comprises date, month and time, wherein the date is major key, described region dimension table comprises storehouse area code, storehouse number and possession title, and wherein storehouse area code is major key.
In step 3, before data storage, to first clear up, then change, finally storage; Cleaning, in order to by nonsignificant data and incomplete data dump, is changed in order to the character that does not meet storage class is changed.
The invention has the beneficial effects as follows: the present invention designs star-like multidimensional analysis models by multidimensional data analysis, and on the basis of star-like multidimensional analysis models, the data in intermediate database are transformed in a relevant database with star schema feature, finally show by client terminal; The present invention can with present intuitively data and between relation, that face emphatically is decision-making level and senior management staff, for its decision-making and management provide support.
Brief description of the drawings
Fig. 1 is process flow diagram of the present invention.
Fig. 2 is the structural drawing of star-like multidimensional analysis models.
Embodiment
Below in conjunction with Figure of description, the invention will be further described.Following examples are only for technical scheme of the present invention is more clearly described, and can not limit the scope of the invention with this.
As shown in Figure 1, a kind of multidimensional analysis method of RFID supply chain data, comprises the following steps.
Step 1, data acquisition, by all data acquisitions of each site in RFID supply chain system in an intermediate database on statistic analysis server.
Step 2, according to the star-like multidimensional analysis models of design data gathering.
The process that designs star-like multidimensional analysis models is, according to the data construct fact table and the dimension table that gather, dimension table is linked in fact table on a corresponding with it external key by a major key.
As shown in Figure 2, fact table comprises numbering, date, region, total amount and day maximum extracted amount, and wherein numbering, date and region are external key; Described dimension table comprises numbering dimension table, date dimension table and region dimension table, described numbering dimension table comprises Item Number, kind numbering and large class numbering, wherein Item Number is major key, described date dimension table comprises date, month and time, wherein the date is major key, described region dimension table comprises storehouse area code, storehouse number and possession title, and wherein storehouse area code is major key.
Step 3, deposits the data in intermediate database in a relevant database with star schema feature according to the star-like multidimensional analysis models of design.
Before storage, first to clear up data, change.Along with the data that gather are more and more,, may there are two kinds of situations: the first, nonsignificant data in the reason such as wherein numerous and diverse the and typing of kind is lack of standardization; The second, significant data, but there is incomplete situation.These data need to be cleared up to it (content of cleaning and method can be with reference to " computer auditing technology and methods ", and the method that the inside is described is consistent with method for cleaning flesh and blood of the present invention).
Data after having cleared up are carried out suitable conversion, make it be more suitable for storage.Because the type of data in the data that gather may have difference with needed type, for example, for time on date field, being stored in intermediate database may be character string type, is unfavorable for like this classification, therefore needs it to change.
Step 4, shows the data that have in the relevant database of star schema feature by client terminal.
The multidimensional analysis method of above-described a kind of RFID supply chain data designs star-like multidimensional analysis models by multidimensional data analysis, and on the basis of star-like multidimensional analysis models, the data in intermediate database are transformed in a relevant database with star schema feature, finally show by client terminal; The present invention can with present intuitively data and between relation, that face emphatically is decision-making level and senior management staff, for its decision-making and management provide support.
More than show and described ultimate principle of the present invention, principal character and advantage.The technician of the industry should understand; the present invention is not restricted to the described embodiments; that in above-described embodiment and instructions, describes just illustrates principle of the present invention; without departing from the spirit and scope of the present invention; the present invention also has various changes and modifications, and these changes and improvements all fall in the claimed scope of the invention.The claimed scope of the present invention is defined by appending claims and equivalent thereof.
Claims (4)
1. a multidimensional analysis method for RFID supply chain data, is characterized in that: comprises the following steps,
Step 1, data acquisition, by all data acquisitions of each site in RFID supply chain system in an intermediate database on statistic analysis server;
Step 2, according to the star-like multidimensional analysis models of design data gathering;
Step 3, deposits the data in intermediate database in a relevant database with star schema feature according to the star-like multidimensional analysis models of design;
Step 4, shows the data that have in the relevant database of star schema feature by client terminal.
2. the multidimensional analysis method of a kind of RFID supply chain data according to claim 1 is characterized in that: the process that designs star-like multidimensional analysis models in step 2 is, according to the data construct fact table and the dimension table that gather, dimension table is linked in fact table on a corresponding with it external key by a major key.
3. the multidimensional analysis method of a kind of RFID supply chain data according to claim 2 is characterized in that: described fact table comprises numbering, date, region, total amount and day maximum extracted amount, and wherein numbering, date and region are external key; Described dimension table comprises numbering dimension table, date dimension table and region dimension table, described numbering dimension table comprises Item Number, kind numbering and large class numbering, wherein Item Number is major key, described date dimension table comprises date, month and time, wherein the date is major key, described region dimension table comprises storehouse area code, storehouse number and possession title, and wherein storehouse area code is major key.
4. the multidimensional analysis method of a kind of RFID supply chain data according to claim 1 is characterized in that: in step 3, before data storage, will first clear up, then change, finally storage; Cleaning, in order to by nonsignificant data and incomplete data dump, is changed in order to the character that does not meet storage class is changed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410137551.2A CN103955483A (en) | 2014-04-08 | 2014-04-08 | Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410137551.2A CN103955483A (en) | 2014-04-08 | 2014-04-08 | Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103955483A true CN103955483A (en) | 2014-07-30 |
Family
ID=51332758
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410137551.2A Pending CN103955483A (en) | 2014-04-08 | 2014-04-08 | Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103955483A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105913188A (en) * | 2016-04-13 | 2016-08-31 | 苏州大成电子科技有限公司 | Multidirectional management system and multidirectional management method of RFID supply chain |
| CN108345602A (en) * | 2017-01-22 | 2018-07-31 | 株式会社日立制作所 | Data multidimensional modeling and data multidimensional modeling method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1617138A (en) * | 2003-11-12 | 2005-05-18 | 鸿富锦精密工业（深圳）有限公司 | Data integration and analysis system and method |
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
| US8503761B2 (en) * | 2009-11-12 | 2013-08-06 | Harris Corporation | Geospatial modeling system for classifying building and vegetation in a DSM and related methods |
-
2014
- 2014-04-08 CN CN201410137551.2A patent/CN103955483A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1617138A (en) * | 2003-11-12 | 2005-05-18 | 鸿富锦精密工业（深圳）有限公司 | Data integration and analysis system and method |
| CN101197876A (en) * | 2006-12-06 | 2008-06-11 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
| US8503761B2 (en) * | 2009-11-12 | 2013-08-06 | Harris Corporation | Geospatial modeling system for classifying building and vegetation in a DSM and related methods |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105913188A (en) * | 2016-04-13 | 2016-08-31 | 苏州大成电子科技有限公司 | Multidirectional management system and multidirectional management method of RFID supply chain |
| CN108345602A (en) * | 2017-01-22 | 2018-07-31 | 株式会社日立制作所 | Data multidimensional modeling and data multidimensional modeling method |
| CN108345602B (en) * | 2017-01-22 | 2021-06-25 | 株式会社日立制作所 | Data multidimensional modeling system and data multidimensional modeling method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200301895A1 (en) | System for analysing data relationships to support data query execution | |
| CN104391948B (en) | The data normalization construction method and system of data warehouse | |
| CA2717673C (en) | Detecting and applying database schema changes to reports | |
| EP3513315A1 (en) | System for data management in a large scale data repository | |
| WO2018051096A1 (en) | System for importing data into a data repository | |
| US20110231359A1 (en) | Synchronization of relational databases with olap cubes | |
| CN106294888A (en) | A kind of method for subscribing of object data based on space-time database | |
| CN109582695A (en) | Data general-purpose querying method and inquiry system under a kind of micro services framework | |
| CN110442620B (en) | Big data exploration and cognition method, device, equipment and computer storage medium | |
| CN105787059A (en) | Data warehouse based financial data integration method | |
| CN105117587A (en) | Medical big data based intelligent analysis method in field of medical insurance | |
| CN106021422B (en) | A kind of method and system forming Hive data warehouse based on relevant database | |
| CN102023983A (en) | Statistical space-time database and managing method thereof | |
| CN103942266A (en) | Data analysis method capable of achieving self-defining of complex service computational logic on basis of OLAP | |
| US8751543B2 (en) | Database view modeling using existing data model | |
| CN105405069A (en) | Electricity purchase operating decision analysis and data processing method | |
| CN104881462B (en) | Metadata management system | |
| Krneta et al. | A direct approach to physical Data Vault design | |
| CN103955483A (en) | Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain | |
| CN105913188A (en) | Multidirectional management system and multidirectional management method of RFID supply chain | |
| CN102902614A (en) | Dynamic monitoring and intelligent guide method | |
| US20150363711A1 (en) | Device for rapid operational visibility and analytics automation | |
| CN103559255B (en) | A kind of visualization data processing method of distributed hydraulic system | |
| CN102855354A (en) | Industrial-enterprise-oriented online multi-dimensional energy consumption data statistics modeling method | |
| Anand et al. | Modeling and optimization of extraction-transformation-loading (ETL) processes in data warehouse: An overview |
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: 20140730 |
|
| RJ01 | Rejection of invention patent application after publication |