CN110457368A - A kind of method for visualizing of supply chain, system and storage medium - Google Patents
A kind of method for visualizing of supply chain, system and storage medium Download PDFInfo
- Publication number
- CN110457368A CN110457368A CN201910687420.4A CN201910687420A CN110457368A CN 110457368 A CN110457368 A CN 110457368A CN 201910687420 A CN201910687420 A CN 201910687420A CN 110457368 A CN110457368 A CN 110457368A
- Authority
- CN
- China
- Prior art keywords
- data
- supply chain
- interface
- container
- different
- 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.)
- Granted
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured 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/24—Querying
- G06F16/248—Presentation of query results
-
- 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/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6245—Protecting personal data, e.g. for financial or medical purposes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0486—Drag-and-drop
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Security & Cryptography (AREA)
- Data Mining & Analysis (AREA)
- Computer Hardware Design (AREA)
- Computational Linguistics (AREA)
- Human Computer Interaction (AREA)
- Automation & Control Theory (AREA)
- Medical Informatics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method for visualizing of supply chain, system and storage mediums, which comprises using the general character of each different data among systems of BI technology mining, acquires and integrate the data of different system databases;Data processing is carried out in ETL to the data of different system databases, by summarizing after SQL Server database unified Modeling into Power BI data set, and it is further analyzed integration by the data that DAX shows needs, finally required data are shown in report;It is several grids by the thematic boundary division on backstage, continuous module of several grids as customized displaying, the content and layout of on-demand customization special topic interface display are chosen in dragging;User is set and accesses setting, the special topic for distributing different user checks permission.The present invention can integrate various forms of data, and the content and layout of each showing interface are customized according to user demand, improve the customized property of system;Reinforce privacy and the safety of data by configuring user right.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of method for visualizing of supply chain, system and storage to be situated between
Matter.
Background technique
In big data era, data is caught to be equivalent to have caught the throat of destiny, but the data in enterprise's hand
Be it is dead, flexibility is lower, only carries out finishing analysis and follow-up by certain technology, could be flexibly with the number in hand
According to, perceive in data hide profoundness, then more accurately make a policy, to carry forward an enterprise, improve the competing of enterprise
Strive power.Enterprise generally by establishing Visualization Platform system, realizes and analyzes data acquisition, data transmission, data storage, data
Processing and data displaying etc..
But in the research and practice process to the prior art, it was found by the inventors of the present invention that the prior art is to data
Show with certain limitation, and can not be according to the idea dynamic self-defining data report of user, functionally, only
It only supports to show data, cannot achieve and otherwise visualization is showed, such as video monitoring, vehicle monitoring and temperature
Monitoring etc.;In terms of data processing, currently available technology partial data in the database with the different instructions major key of capital and small letter, but
DAX language does not but support capital and small letter to distinguish, can not be directly using the major key of initial data as the unique identification of the data.Cause
This, needs a kind of visualization system of contents and distribution for capableing of on-demand customization showing interface, supports the data of diversified forms.
Summary of the invention
The technical problem to be solved in the present invention is that propose a kind of method for visualizing of supply chain, system and storage medium,
It can complete the integration to various system datas, and the content and layout of each showing interface of on-demand customization.
To solve the above problems, a kind of method for visualizing for supply chain that one embodiment of the present of invention provides, is suitable for
It calculates and is executed in equipment, included the following steps:
Using the general character of each different data among systems of BI technology mining, the number of different system databases is acquired and integrated
According to;
Data processing is carried out in ETL to the data of the different system databases, is united by SQL Server database
Summarize after one modeling into Power BI data set, and be further analyzed integration by data of the DAX to required displaying,
Finally required data are shown in report;
It is several grids by the thematic boundary division on backstage, dragging chooses several continuous grids as customized exhibition
The module shown, the content and layout of on-demand customization special topic interface display;
User is set and accesses setting, the special topic for distributing different user checks permission.
Further, the method for visualizing of the supply chain, further includes:
Power BI related data report is transferred from the Power BI data set by api interface, and is shown to institute
State thematic interface.
Further, the data acquired and integrate different system databases, further includes: mentioned using application integration gateway
After the data of different system databases are extracted and converted by the data-interface of confession, it is loaded onto target data warehouse.
Further, the thematic interface includes camera container, BI container, map cases and link container, wherein
The camera container includes base attribute information, warehouse information and Default device information;
The BI container includes same name in an account book, password, client id, workspace ID and report ID.
Another embodiment of the present invention provides a kind of visualization systems of supply chain, comprising:
Data acquisition module is acquired and is integrated for the general character using each different data among systems of BI technology mining
The data of different system databases;
Data processing module carries out data processing for the data to the different system databases in ETL, passes through
Summarize after SQL Server database unified Modeling into Power BI data set, and by DAX to the data of required displaying
It is further analyzed integration, finally shows required data in report;
Custom block, for being several grids by the thematic boundary division on backstage, dragging choose it is continuous several
Module of the grid as customized displaying, the content and layout of on-demand customization special topic interface display;
Setup module accesses setting for user to be arranged, and the special topic for distributing different user checks permission.
Further, the visualization system of the supply chain, further includes:
Power BI related data report is transferred from the Power BI data set by api interface, and is shown to institute
State thematic interface.
Further, the data acquired and integrate different system databases, further includes: mentioned using application integration gateway
After the data of different system databases are extracted and converted by the data-interface of confession, it is loaded onto target data warehouse.
Further, the thematic interface includes camera container, BI container, map cases and link container, wherein
The camera container includes base attribute information, warehouse information and Default device information;
The BI container includes same name in an account book, password, client id, workspace ID and report ID.
One embodiment of the present of invention additionally provides a kind of computer readable storage medium, the computer-readable storage medium
Matter includes the computer program of storage, wherein controls the computer readable storage medium in computer program operation
Place equipment executes the method for visualizing such as above-mentioned supply chain.
The implementation of the embodiments of the present invention has the following beneficial effects:
Method for visualizing, system and the storage medium of a kind of supply chain provided in an embodiment of the present invention, which comprises
Using the general character of each different data among systems of BI technology mining, the data of different system databases are acquired and integrated;To institute
The data for stating different system databases carry out data processing in ETL, by summarizing after SQL Server database unified Modeling
It is further analyzed integration into Power BI data set, and through data of the DAX to required displaying, it finally will be required
Data show in report;It is several grids by the thematic boundary division on backstage, several continuous grids are chosen in dragging
As the module of customized displaying, the content and layout of on-demand customization special topic interface display;User is set and accesses setting, distribution is not
Special topic with user checks permission.The present invention can integrate various forms of data, be to use according to the demand of each user
Family customizes the content and layout of each showing interface, improves the customized property of system;By configuring user right, reinforce the hidden of data
Private and safety;Can also have certain extensibility by accessing related Intelligent hardware simultaneously.
Detailed description of the invention
Fig. 1 is a kind of flow diagram of the method for visualizing for supply chain that one embodiment of the present of invention provides;
Fig. 2 is a kind of flow diagram for integral data that one embodiment of the present of invention provides;
Fig. 3 is the structural schematic diagram at the thematic interface that one embodiment of the present of invention provides;
Fig. 4 is a kind of structural schematic diagram of the method for visualizing system for supply chain that one embodiment of the present of invention provides.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
First embodiment of the invention
Please refer to Fig. 1-3.
As shown in Figure 1, a kind of method for visualizing of supply chain provided in this embodiment, suitable for being executed in calculating equipment,
Include the following steps:
S101, using the general character of each different data among systems of BI technology mining, acquire and integrate different system datas
The data in library;
Specifically, using existing BI technology, the general character of each data among systems is excavated for step S101, it will not
The data of homologous ray are integrated, wherein the visual data of supply chain each Joint Enterprises built-in system in supply chain
Database or Joint Enterprises between the data such as EDI, the XML file traded.
S102, data processing is carried out in ETL to the data of the different system databases, passes through SQL Server data
Summarize after the unified Modeling of library into Power BI data set, and is further analyzed by data of the DAX to required displaying
Integration finally shows required data in report;
Specifically, as shown in Fig. 2, the data of not homologous ray are carried out data processing in ETL, being wrapped for step S102
The extraction of data is included, conversion is cleaned and is loaded onto data warehouse, by SQL Server database unified Modeling, then by data
Summarize to Power BI, comes out corresponding report form showing finally by Visualized management system.Partial data is in data at present
With the different instructions major key of capital and small letter in library, but DAX language does not support capital and small letter to distinguish, so can not be directly by initial data
Unique identification of the major key as the data, in view of the above-mentioned problems, in the present embodiment, the method combined using data is led to
Custom function and storing process are crossed, initial data character string is traversed, encounters lowercase, then is converted into " corresponding big
Write mother ", then other character strings of recombinant form new major key, a series of caused by solving due to case sensitive to ask
Topic is realized directly using the major key of initial data as the effect of the unique identification of the data.
It S103, is several grids by the thematic boundary division on backstage, dragging is chosen several continuous grids and is used as certainly
Define the module shown, the content and layout of on-demand customization special topic interface display;
Specifically, for step S103, in order to be compatible with disparate modules in the displaying at thematic interface, system is by the special topic on backstage
Boundary division is 16 grids, and system manager, which can arbitrarily drag, chooses continuous grid to show customized module, such as
Video module, Reports module and link module, administrator can be that user customizes each showing interface according to the demand of each user
Content and layout.Special topic has merged camera container, BI container, map cases, link 4 kinds of different types of containers of container,
Every kind of container has all carried out corresponding ratio and parameter configuration to it on backstage, such as: the attribute that camera container is included has
Base, warehouse, Default device have got through the API between system and utilizing camera interface, and the relevant data of camera are cleverly melted
System is entered.The attribute that BI container includes has user name, password, client id, work to remove ID, report ID, passes through api interface tune
Power BI related data report is taken, then by certain adjustment, finally by report form showing at thematic interface.As shown in figure 3, exhibition
Show in a thematic interface configurations camera container, BI container, the effect for linking container.
Meanwhile system has reserved sufficient extending space, for subsequent Intelligent hardware access and management provide it is certain
It may extend, such as monitoring temperature, car tracing, goods delivery, entrance guard management etc., have certain extensibility.Such as: with
.net it is basic programming language, system has been incorporated into video and has checked technology, user can check each prison in oneself extent of competence
Video is controlled, so as to the operation traffic-operating period in real time inspection warehouse;And be extracted the data of vehicular traffic, can to vehicle data into
Row analysis is interpreted, and related data report is generated, and checks and analyze providing a great convenience property of data for company related personnel.
S104, setting user access setting, and the special topic for distributing different user checks permission.
Specifically, after special topic configuration is good, by the setting of " addressable people ", distributing different user for step S104
Special topic check permission, addressable user can check the special topic on foreground after issuing the special topic from the background.By to permission into
Row configuration distinguishes the data and content that different user is seen, strengthens management to the privacy of data, be effectively controlled items
The safety of data.
In a preferred embodiment, the method for visualizing of the supply chain, further includes:
Power BI related data report is transferred from the Power BI data set by api interface, and is shown to institute
State thematic interface.
In the particular embodiment, Power BI tool is introduced, data are passed through into various vivid visualization visions
Object is shown, and is drilled through layer by layer to data, carries out linkage analysis to the data of various aspects, can not only be more convenient
User is helped to carry out analysis decision, moreover it is possible to conveniently export user's specified data, while can also be according to user's oneself
Requirement definition data sheet.
In a preferred embodiment, the data acquired and integrate different system databases, further includes: using application collection
After the data of different system databases are extracted and converted at the data-interface that gateway provides, it is loaded onto target data warehouse
In.
Specifically, being extracted using the various data-interfaces that application integration gateway provides, being converted, being loaded into target data
In warehouse;Cube, on-line analysis and processing are established for visualized objects, assembles skill using cube and data
Art carries out tissue to the data in data warehouse and summarizes, and is commented rapidly with on-line analysis and visualization tool these data
Valence;Visual information is intuitively shown using front-end presentation tool in a manner of various charts finally, is convenient for customer analysis
Decision.
In a preferred embodiment, the thematic interface includes that camera container, BI container, map cases and link are held
Device, wherein
The camera container includes base attribute information, warehouse information and Default device information;
The BI container includes same name in an account book, password, client id, workspace ID and report ID.
Provided in this embodiment the invention discloses a kind of method for visualizing of supply chain, comprising: utilizes BI technology mining
The general character of each difference data among systems, acquires and integrates the data of different system databases;To the different system datas
The data in library carry out data processing in ETL, by summarizing after SQL Server database unified Modeling to Power BI data
It concentrates, and is further analyzed integration by data of the DAX to required displaying, finally reporting the displaying of required data
In table;It is several grids by the thematic boundary division on backstage, dragging chooses several continuous grids as customized displaying
Module, the content and layout of on-demand customization special topic interface display;User is set and accesses setting, the special topic for distributing different user is looked into
See permission.The present invention can integrate various forms of data, be that user customizes each interface according to the demand of each user
The content and layout of displaying improve the customized property of system;By configuring user right, reinforce privacy and the safety of data;
Can also have certain extensibility by accessing related Intelligent hardware simultaneously.
Second embodiment of the invention
Please refer to Fig. 2-4.
As shown in figure 4, a kind of visualization system of supply chain provided in this embodiment, comprising:
Data acquisition module 100 acquires and whole for the general character using each different data among systems of BI technology mining
Close the data of different system databases;
Specifically, using existing BI technology, excavating being total to for each data among systems for data acquisition module 100
Property, the data of not homologous ray are integrated, wherein the visual data of supply chain are in supply chain in each Joint Enterprises
The data such as EDI, the XML file traded between the database or Joint Enterprises of portion's system.
Data processing module 200 carries out data processing for the data to the different system databases in ETL, leads to
Summarize after crossing SQL Server database unified Modeling into Power BI data set, and by DAX to the number of required displaying
According to integration is further analyzed, finally required data are shown in report;
Specifically, for data processing module 200, as shown in Fig. 2, the data of not homologous ray are carried out data in ETL
Processing, extraction, cleaning including data are converted and are loaded onto data warehouse, by SQL Server database unified Modeling, so
Afterwards by data summarization to Power BI, corresponding report form showing is come out finally by Visualized management system.Part number at present
According in the database with the different instructions major key of capital and small letter, but DAX language does not support capital and small letter to distinguish, thus can not directly by
Unique identification of the major key of initial data as the data, in view of the above-mentioned problems, in the present embodiment, using data combination
Method traverses initial data character string, encounters lowercase by custom function and storing process, then be converted into "
Corresponding capitalization ", then other character strings of recombinant form new major key, one caused by solving due to case sensitive
The problem of series is realized directly using the major key of initial data as the effect of the unique identification of the data.
Custom block 300, for being several grids by the thematic boundary division on backstage, dragging is chosen continuous several
Module of a grid as customized displaying, the content and layout of on-demand customization special topic interface display;
Specifically, in order to be compatible with disparate modules in the displaying at thematic interface, system will backstage for custom block 300
Thematic boundary division be 16 grids, system manager, which can arbitrarily drag, chooses continuous grid to show customized mould
Block, such as video module, Reports module and link module, administrator can be that user customizes each boundary according to the demand of each user
The content and layout that face is shown.Special topic merged camera container, BI container, map cases, link 4 kinds of container it is different types of
Container, every kind of container have all carried out corresponding ratio and parameter configuration to it on backstage, such as: the category that camera container is included
Property has base, warehouse, Default device, has got through the API between system and utilizing camera interface, and the relevant data of camera are ingenious
Incorporated system.The attribute that BI container includes has user name, password, client id, work to remove ID, report ID, is connect by API
Mouth transfers Power BI related data report, then by certain adjustment, finally by report form showing at thematic interface.Such as Fig. 3 institute
Show, illustrates in a thematic interface configurations camera container, BI container, the effect for linking container.
Setup module 400 accesses setting for user to be arranged, and the special topic for distributing different user checks permission.
Specifically, after special topic configuration is good, by the setting of " addressable people ", distributing different use for setup module 400
The special topic at family checks permission, and addressable user can check the special topic on foreground after issuing the special topic from the background.By to permission
It is configured, distinguishes the data and content that different user is seen, strengthen management to the privacy of data, be effectively controlled each
The safety of item data.
In a preferred embodiment, the visualization system of the supply chain, further includes:
Power BI related data report is transferred from the Power BI data set by api interface, and is shown to institute
State thematic interface.
In the particular embodiment, Power BI tool is introduced, data are passed through into various vivid visualization visions
Object is shown, and is drilled through layer by layer to data, and carries out linkage analysis to the data of various aspects, can not only be more convenient
Help user carry out analysis decision, moreover it is possible to conveniently export user's specified data, while can also be according to user oneself
Requirement definition data sheet.
In a preferred embodiment, the data acquired and integrate different system databases, further includes: using application collection
After the data of different system databases are extracted and converted at the data-interface that gateway provides, it is loaded onto target data warehouse
In.
Specifically, being extracted using the various data-interfaces that application integration gateway provides, being converted, being loaded into target data
In warehouse;Cube, on-line analysis and processing are established for visualized objects, assembles skill using cube and data
Art carries out tissue to the data in data warehouse and summarizes, and is commented rapidly with on-line analysis and visualization tool these data
Valence;Visual information is intuitively shown using front-end presentation tool in a manner of various charts finally, is convenient for customer analysis
Decision.
In a preferred embodiment, the thematic interface includes that camera container, BI container, map cases and link are held
Device, wherein
The camera container includes base attribute information, warehouse information and Default device information;
The BI container includes same name in an account book, password, client id, workspace ID and report ID.
A kind of visualization system of supply chain provided in this embodiment, comprising: data acquisition module, for utilizing BI technology
The general character for excavating each different data among systems, acquires and integrates the data of different system databases;Data processing module is used
Data processing is carried out in ETL in the data to the different system databases, passes through SQL Server database unified Modeling
After summarize into Power BI data set, and be further analyzed integration by data of the DAX to required displaying, finally will
Required data are shown in report;Custom block, for being several grids, dragging by the thematic boundary division on backstage
Choose continuous module of several grids as customized displaying, the content and layout of on-demand customization special topic interface display;If
Module is set, accesses setting for user to be arranged, the special topic for distributing different user checks permission.The present invention can collect various forms of
Data are the content and layout that user customizes each showing interface according to the demand of each user, and raising system is made by oneself
Justice;By configuring user right, reinforce privacy and the safety of data;Simultaneously can also by accessing related Intelligent hardware,
Has certain extensibility.
Another embodiment of the invention additionally provides a kind of computer readable storage medium, the computer-readable storage
Medium includes the computer program of storage, wherein controls the computer-readable storage medium in computer program operation
Equipment executes the method for visualizing such as above-mentioned supply chain where matter.
Method for visualizing, system and the storage medium for a kind of supply chain that the embodiment of the present invention provides, the method packet
It includes: using the general character of each different data among systems of BI technology mining, acquiring and integrate the data of different system databases;It is right
The data of the difference system database carry out data processing in ETL, by converging after SQL Server database unified Modeling
Always into Power BI data set, and it is further analyzed integration by data of the DAX to required displaying, it finally will be required
The data wanted are shown in report;It is several grids by the thematic boundary division on backstage, several continuous sides are chosen in dragging
Module of the lattice as customized displaying, the content and layout of on-demand customization special topic interface display;User is set and accesses setting, distribution
The special topic of different user checks permission.The present invention can integrate various forms of data, and the demand according to each user is
User customizes the content and layout of each showing interface, improves the customized property of system;By configuring user right, reinforce data
Privacy and safety;Can also have certain extensibility by accessing related Intelligent hardware simultaneously.
In the above embodiment of the invention, it all emphasizes particularly on different fields to the description of each embodiment, does not have in some embodiment
The part of detailed description, reference can be made to the related descriptions of other embodiments.
In several embodiments provided herein, it should be understood that disclosed technology contents can pass through others
Mode is realized.Wherein, system embodiment described above is only schematical, such as the division of the module, Ke Yiwei
A kind of logical function partition, there may be another division manner in actual implementation, for example, multiple module or components can combine or
Person is desirably integrated into another system, or some features can be ignored or not executed.Another point, shown or discussed is mutual
Between coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or communication link of unit or module
It connects, can be electrical or other forms.
The module as illustrated by the separation member may or may not be physically separated, aobvious as module
The component shown may or may not be physical module, it can and it is in one place, or may be distributed over multiple
In module.Some or all of the modules therein can be selected to achieve the purpose of the solution of this embodiment according to the actual needs.
It, can also be in addition, each functional module in each embodiment of the present invention can integrate in a processing module
It is that modules physically exist alone, can also be integrated in two or more modules in a module.Above-mentioned integrated mould
Block both can take the form of hardware realization, can also be realized in the form of software function module.
The above is a preferred embodiment of the present invention, it is noted that for those skilled in the art
For, without departing from the principle of the present invention, several improvement and deformations can also be made, these improvement and deformations are also considered as
Protection scope of the present invention.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the program can be stored in a computer-readable storage medium
In, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, the storage medium can be magnetic
Dish, CD, read-only memory (Read-Only Memory, ROM) or random access memory (Random Access
Memory, RAM) etc..
Claims (9)
1. a kind of method for visualizing of supply chain, suitable for being executed in calculating equipment, which comprises the steps of:
Using the general character of each different data among systems of BI technology mining, the data of different system databases are acquired and integrated;
Data processing is carried out in ETL to the data of the different system databases, is uniformly built by SQL Server database
Summarize after mould into Power BI data set, and be further analyzed integration by data of the DAX to required displaying, finally
Required data are shown in report;
It is several grids by the thematic boundary division on backstage, dragging chooses several continuous grids as customized displaying
Module, the content and layout of on-demand customization special topic interface display;
User is set and accesses setting, the special topic for distributing different user checks permission.
2. the method for visualizing of supply chain according to claim 1, which is characterized in that further include:
Power BI related data report is transferred from the Power BI data set by api interface, and is shown to described special
Inscribe interface.
3. the method for visualizing of supply chain according to claim 1, which is characterized in that the acquisition simultaneously integrates not homologous ray
The data of database, further includes: carried out the data of different system databases using the data-interface that application integration gateway provides
After extracting and converting, it is loaded onto target data warehouse.
4. the method for visualizing of supply chain according to claim 1, which is characterized in that the special topic interface includes camera
Container, BI container, map cases and link container, wherein
The camera container includes base attribute information, warehouse information and Default device information;
The BI container includes same name in an account book, password, client id, workspace ID and report ID.
5. a kind of visualization system of supply chain characterized by comprising
Data acquisition module acquires for the general character using each different data among systems of BI technology mining and integrates difference
The data of system database;
Data processing module carries out data processing for the data to the different system databases in ETL, passes through SQL
Summarize after Server database unified Modeling into Power BI data set, and by data of the DAX to required displaying do into
The analytical integration of one step finally shows required data in report;
Custom block, for being several grids by the thematic boundary division on backstage, several continuous grids are chosen in dragging
As the module of customized displaying, the content and layout of on-demand customization special topic interface display;
Setup module accesses setting for user to be arranged, and the special topic for distributing different user checks permission.
6. the visualization system of supply chain according to claim 5, which is characterized in that further include:
Power BI related data report is transferred from the Power BI data set by api interface, and is shown to described special
Inscribe interface.
7. the visualization system of supply chain according to claim 5, which is characterized in that the acquisition simultaneously integrates not homologous ray
The data of database, further includes: carried out the data of different system databases using the data-interface that application integration gateway provides
After extracting and converting, it is loaded onto target data warehouse.
8. the visualization system of supply chain according to claim 5, which is characterized in that the special topic interface includes camera
Container, BI container, map cases and link container, wherein
The camera container includes base attribute information, warehouse information and Default device information;
The BI container includes same name in an account book, password, client id, workspace ID and report ID.
9. a kind of computer readable storage medium, which is characterized in that the computer readable storage medium includes the calculating of storage
Machine program, wherein equipment where controlling the computer readable storage medium in computer program operation is executed as weighed
Benefit requires the method for visualizing of supply chain described in 1-4.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910687420.4A CN110457368B (en) | 2019-07-26 | 2019-07-26 | Visualization method, system and storage medium for supply chain |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910687420.4A CN110457368B (en) | 2019-07-26 | 2019-07-26 | Visualization method, system and storage medium for supply chain |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110457368A true CN110457368A (en) | 2019-11-15 |
CN110457368B CN110457368B (en) | 2023-07-21 |
Family
ID=68483827
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910687420.4A Active CN110457368B (en) | 2019-07-26 | 2019-07-26 | Visualization method, system and storage medium for supply chain |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110457368B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021143057A1 (en) * | 2020-01-13 | 2021-07-22 | 平安国际智慧城市科技股份有限公司 | Graph data processing method, device, computer apparatus, and storage medium |
CN113672594A (en) * | 2021-06-08 | 2021-11-19 | 厦门锐特信息技术有限公司 | BI report system suitable for logistics supply chain business |
Citations (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060025930A1 (en) * | 2004-08-02 | 2006-02-02 | Xiongwu Xia | Automated analysis of multiplexed probe-target interaction patterns: pattern matching and allele identification |
US20070208669A1 (en) * | 1993-11-19 | 2007-09-06 | Rivette Kevin G | System, method, and computer program product for managing and analyzing intellectual property (IP) related transactions |
CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
CN103458033A (en) * | 2013-09-04 | 2013-12-18 | 北京邮电大学 | System for providing services of event-driven service-oriented internet of things and working method thereof |
CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学(北京) | Multidimensional model based oil and gas resource data key system implementation method and system |
CN106022560A (en) * | 2016-05-05 | 2016-10-12 | 四川铁安达科技有限公司 | Subway shield segment attitude monitoring and management system based on Internet of Things and cloud computing |
US9563608B1 (en) * | 2016-01-29 | 2017-02-07 | International Business Machines Corporation | Data analysis results authoring and peer review |
CN108512691A (en) * | 2018-02-07 | 2018-09-07 | 复旦大学 | Cloud automatic early-warning O&M monitoring system based on Hadoop |
CN108628608A (en) * | 2018-04-16 | 2018-10-09 | 朗新科技股份有限公司 | A kind of method and device of data visualization |
CN108711030A (en) * | 2017-04-11 | 2018-10-26 | 埃森哲环球解决方案有限公司 | The end-to-end project management platform integrated with artificial intelligence |
CN109284330A (en) * | 2018-09-04 | 2019-01-29 | 福建奇点时空数字科技有限公司 | A kind of Internet of Things big data management system for garden |
CN109446221A (en) * | 2018-10-29 | 2019-03-08 | 北京百分点信息科技有限公司 | A kind of interactive data method for surveying based on semantic analysis |
-
2019
- 2019-07-26 CN CN201910687420.4A patent/CN110457368B/en active Active
Patent Citations (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070208669A1 (en) * | 1993-11-19 | 2007-09-06 | Rivette Kevin G | System, method, and computer program product for managing and analyzing intellectual property (IP) related transactions |
US20060025930A1 (en) * | 2004-08-02 | 2006-02-02 | Xiongwu Xia | Automated analysis of multiplexed probe-target interaction patterns: pattern matching and allele identification |
CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
CN103458033A (en) * | 2013-09-04 | 2013-12-18 | 北京邮电大学 | System for providing services of event-driven service-oriented internet of things and working method thereof |
CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学(北京) | Multidimensional model based oil and gas resource data key system implementation method and system |
US9563608B1 (en) * | 2016-01-29 | 2017-02-07 | International Business Machines Corporation | Data analysis results authoring and peer review |
CN106022560A (en) * | 2016-05-05 | 2016-10-12 | 四川铁安达科技有限公司 | Subway shield segment attitude monitoring and management system based on Internet of Things and cloud computing |
CN108711030A (en) * | 2017-04-11 | 2018-10-26 | 埃森哲环球解决方案有限公司 | The end-to-end project management platform integrated with artificial intelligence |
CN108512691A (en) * | 2018-02-07 | 2018-09-07 | 复旦大学 | Cloud automatic early-warning O&M monitoring system based on Hadoop |
CN108628608A (en) * | 2018-04-16 | 2018-10-09 | 朗新科技股份有限公司 | A kind of method and device of data visualization |
CN109284330A (en) * | 2018-09-04 | 2019-01-29 | 福建奇点时空数字科技有限公司 | A kind of Internet of Things big data management system for garden |
CN109446221A (en) * | 2018-10-29 | 2019-03-08 | 北京百分点信息科技有限公司 | A kind of interactive data method for surveying based on semantic analysis |
Non-Patent Citations (1)
Title |
---|
刘西青等: "基于物联网的煤矿可视化系统研究", 煤矿机械, pages 253 - 254 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021143057A1 (en) * | 2020-01-13 | 2021-07-22 | 平安国际智慧城市科技股份有限公司 | Graph data processing method, device, computer apparatus, and storage medium |
CN113672594A (en) * | 2021-06-08 | 2021-11-19 | 厦门锐特信息技术有限公司 | BI report system suitable for logistics supply chain business |
Also Published As
Publication number | Publication date |
---|---|
CN110457368B (en) | 2023-07-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107247788A (en) | A kind of method of the comprehensive regulation service based on government data | |
CN108351883A (en) | The display of dynamic context hinge network analysis | |
US5692175A (en) | Decision modeling and analysis for object oriented data access and analysis system | |
CN108512691A (en) | Cloud automatic early-warning O&M monitoring system based on Hadoop | |
AU2021204978A1 (en) | Using an object model of heterogeneous data to facilitate building data visualizations | |
CN107256247A (en) | Big data data administering method and device | |
CN110050257A (en) | The difference of executable data flow diagram | |
US20090006318A1 (en) | Multi-source data visualization system | |
US20030095142A1 (en) | System and method for displaying a layout of GUI properties panel | |
CN106557457B (en) | QT-based system for automatically generating cross-platform complex flow chart | |
CN103154942B (en) | Enterprise applies work centre | |
CN110086665A (en) | A kind of network topological diagram methods of exhibiting based on jTopo | |
DE10002305A1 (en) | Band saw cutting machine management system, has user interface which provides process information from database to dynamic user interface as required by user | |
DE10051645A1 (en) | Method and device for controlling versions and producing logs and lists in a process control system incorporates a computer-readable medium and a processor for communicating with that medium. | |
CN110134674A (en) | A kind of money and credit big data monitoring analysis system | |
US8984433B2 (en) | Graphical representation of tabular data | |
WO2005008403A2 (en) | Apparatuses and methods for dynamic creation of phase gantt charts | |
CN110807015A (en) | Big data asset value delivery management method and system | |
CN103970872B (en) | Multi-level data processing method based on service aperture | |
CN107111639A (en) | Build form | |
DE102007046049A1 (en) | System, procedure and program to support the creation of business processes | |
CN106709017A (en) | Big data-based aid decision making method | |
CN110457368A (en) | A kind of method for visualizing of supply chain, system and storage medium | |
CN104182226B (en) | A kind of General Mobile information system adaptation method and device | |
CN110489441A (en) | A kind of extemporaneous querying method and equipment based on big data |
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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |