CN109542975A - A kind of intelligent report forms inquiry system - Google Patents
A kind of intelligent report forms inquiry system Download PDFInfo
- Publication number
- CN109542975A CN109542975A CN201811234042.6A CN201811234042A CN109542975A CN 109542975 A CN109542975 A CN 109542975A CN 201811234042 A CN201811234042 A CN 201811234042A CN 109542975 A CN109542975 A CN 109542975A
- Authority
- CN
- China
- Prior art keywords
- data
- storage
- inquiry
- local
- report forms
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to intelligent report forms technical fields, more particularly to a kind of intelligent report forms inquiry system, by the storage data out for reading commodity, the data of storage out are stored in local server and back-end server, to be respectively formed local reporting system and rear end reporting system, user obtains corresponding query result information according to search access right, and the present invention can guarantee the safety of enterprise's sensitive data.
Description
Technical field
The present invention relates to intelligent report forms technical fields, and in particular to a kind of intelligent report forms inquiry system.
Background technique
Report is the basic measures and approach of business administration, is the basic service requirement of enterprise, and implements BI strategy
Basis.Report can help accessed enterprise, format data, and data information is presented to use in reliable and safe mode
Person.
Enterprise-level reporting system is filled out except realization report drafting, self-defined report exploitation, general polling, extemporaneous report, report
Outside report, statement analysis, report is remotely managed and maintained, load balancing is can be realized and report software is deployed in
On distributed server, in addition batch processing report and report achieve function, provide flexible batch report generation function.Report
Report is put into individual paging, the user data view based on permission that report uses according to permission by table batch processing mode respectively
Figure will be controlled by stringent permission, and in data such as the producing and selling for being related to enterprise, this point is particularly important, and how
There is provided a kind of intelligent report forms inquiry system that can guarantee enterprise's sensitive data safety and becoming is worth solving the problems, such as.
Summary of the invention
The purpose of the present invention is to provide a kind of intelligent report forms inquiry systems, can guarantee the safety of enterprise's sensitive data.
A kind of intelligent report forms inquiry system provided by the invention, the system comprises reading device, local server, rear ends
Server, inquiry unit；
The data of storage out are sent to local service for reading the storage data out of commodity by the reading device
Device；
The local server, for save it is described go out storage data, and by it is described go out storage data be synchronized to it is described after
Server is held, to realize the strange land dual-active for being put in storage data out；
The back-end server is provided for importing the data of storage out in report data warehouse as data source
It is used to rear end reporting system.
The inquiry unit obtains the corresponding inquiry of the inquiry instruction according to search access right for receiving inquiry instruction
Result information.
Further, described to go out to be put in storage product name, model, quantity, coding, unit price that data packet includes library and storage, with
And every commodity go out to be put in storage the corresponding time.
Further, the local server is also used to: being supplied to this for storage data are gone out described in preservation as data source
Ground reporting system uses.
Further, it is described by it is described go out storage data be synchronized to the process of the back-end server and be, in local server
On to needing synchronous data to issue, then the data of the publication are subscribed on back-end server.
Further, described import the data of storage out in report data warehouse specifically includes: after data result cleaning,
It is sent in report data warehouse, the cleaning is logical to be tested, will be inconsistent by the sentence judgement in SQL script
Data exclude in data warehouse.
Further, the inquiry unit includes authority module, and the authority module according to the identity information of user for sentencing
Break the search access right of the user.
Further, the inquiry unit includes local search device, and the local search device can transfer local report
The query result information of system.
Further, the inquiry unit includes rear end inquiry unit, and the rear end inquiry unit can transfer local report
The query result information of system and rear end reporting system.
The beneficial effects of the present invention are: the present invention discloses a kind of intelligent report forms inquiry system, by the discrepancy for reading commodity
The data of storage out are stored in local server and back-end server, to be respectively formed local reporting system by library data
With rear end reporting system, user obtains the corresponding query result information of inquiry instruction according to search access right, and the present invention can guarantee enterprise
The safety of industry sensitive data.
Detailed description of the invention
The invention will be further described with example with reference to the accompanying drawing.
Fig. 1 is a kind of structural schematic diagram of intelligent report forms inquiry system of the embodiment of the present invention；
Fig. 2 is a kind of flow diagram of intelligent report forms querying method of the embodiment of the present invention.
Specific embodiment
With reference to Fig. 1, a kind of intelligent report forms inquiry system provided in an embodiment of the present invention, the system comprises reading device 1,
Local server 2, back-end server 3, inquiry unit 4；
The data of storage out are sent to local service for reading the storage data out of commodity by the reading device 1
Device 2；
The local server 2, for save it is described go out storage data, and by it is described go out storage data be synchronized to it is described after
Server 3 is held, to realize the strange land dual-active for being put in storage data out；
The back-end server 3 is provided for importing the data of storage out in report data warehouse as data source
It is used to rear end reporting system；
The inquiry unit 4 obtains the corresponding query result information of the inquiry instruction for receiving inquiry instruction.
Further, described to go out to be put in storage product name, model, quantity, coding, unit price that data packet includes library and storage, with
And every commodity go out to be put in storage the corresponding time.
Further, the local server 2 is also used to: being supplied to this for storage data are gone out described in preservation as data source
Ground reporting system uses.
Further, it is described by it is described go out storage data be synchronized to the process of the back-end server 3 and be, in local server
To needing synchronous data to issue on 2, then the data of the publication are subscribed on back-end server 3, it is described
The data of publication can be the partial data of one table of publication, be also possible to the data of whole table.
Further, described import the data of storage out in report data warehouse specifically includes: after data result cleaning,
It is sent in report data warehouse, the cleaning is logical to be tested, will be inconsistent by the sentence judgement in SQL script
Data exclude in data warehouse.
Further, the inquiry unit 4 includes authority module, and the authority module according to the identity information of user for sentencing
Break the search access right of the user.
Further, the inquiry unit 4 includes local search device 4, and the local search device 4 can transfer local report
The query result information of table system.
Further, the inquiry unit 4 includes rear end inquiry unit 4, and the rear end inquiry unit 4 can transfer local report
The query result information of table system and rear end reporting system.
With reference to Fig. 2, the present embodiment also provides a kind of intelligent report forms querying method, comprising the following steps:
Step S1, the described reading device 1 reads the storage data out of commodity, and the data of storage out are sent to local clothes
Business device 2；
Step S2, the described local server 2 save it is described go out storage data, and by it is described go out storage data be synchronized to it is described
Back-end server 3, to realize the strange land dual-active for being put in storage data out；
Step S3, the described back-end server 3 described will go out to be put in storage in data importing report data warehouse, mention as data source
Rear end reporting system is supplied to use；
Step S4, the described inquiry unit 4 receives inquiry instruction, obtains the corresponding query result information of the inquiry instruction.
The above, only presently preferred embodiments of the present invention, the invention is not limited to above embodiment, as long as
It reaches technical effect of the invention with identical means, all should belong to protection scope of the present invention.
Claims (8)
1. a kind of intelligent report forms inquiry system, which is characterized in that the system comprises reading device, local server, rear end clothes
Business device, inquiry unit；
The data of storage out are sent to local server for reading the storage data out of commodity by the reading device；
The data of storage out for saving the storage data out, and are synchronized to the rear end and taken by the local server
Business device；
The back-end server, for importing the data of storage out in report data warehouse, after being supplied to as data source
Reporting system is held to use；
The inquiry unit obtains the corresponding query result information of the inquiry instruction for receiving inquiry instruction.
2. a kind of intelligent report forms inquiry system according to claim 1, which is characterized in that the data packet of storage out includes
The product name of library and storage, model, quantity, coding, unit price and every commodity go out to be put in storage the corresponding time.
3. a kind of intelligent report forms inquiry system according to claim 1, which is characterized in that the local server is also used
In: storage data will be gone out described in preservation and be supplied to local reporting system as data source and use.
4. a kind of intelligent report forms inquiry system according to claim 1, which is characterized in that described described to go out to be put in storage data
The process for being synchronized to the back-end server is, to needing synchronous data to issue on local server, then rear
The data of the publication are subscribed on client database server.
5. a kind of intelligent report forms inquiry system according to claim 1, which is characterized in that described described to go out to be put in storage data
It imports in report data warehouse and specifically includes: after data result cleaning, then reaching in report data warehouse, the cleaning is logical
The sentence judgement crossed in SQL script is tested, will not be inconsistent logical data exclusion in data warehouse.
6. a kind of intelligent report forms inquiry system according to claim 1, which is characterized in that the inquiry unit includes permission
Module, the authority module are used to judge according to the identity information of user the search access right of the user.
7. a kind of intelligent report forms inquiry system according to claim 1, which is characterized in that the inquiry unit includes local
Inquiry unit, the local search device can transfer the query result information of local reporting system.
8. a kind of intelligent report forms inquiry system according to claim 1, which is characterized in that the inquiry unit includes rear end
Inquiry unit, the rear end inquiry unit can transfer the query result information of local reporting system and rear end reporting system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811234042.6A CN109542975A (en) | 2018-10-23 | 2018-10-23 | A kind of intelligent report forms inquiry system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811234042.6A CN109542975A (en) | 2018-10-23 | 2018-10-23 | A kind of intelligent report forms inquiry system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109542975A true CN109542975A (en) | 2019-03-29 |
Family
ID=65845023
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811234042.6A Pending CN109542975A (en) | 2018-10-23 | 2018-10-23 | A kind of intelligent report forms inquiry system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109542975A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050209892A1 (en) * | 2004-03-19 | 2005-09-22 | Miller Jonathan K | [Automated system and method for providing accurate, non-invasive insurance status verification] |
| CN101639855A (en) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | Report inquiry method and device thereof |
| CN104834694A (en) * | 2015-04-24 | 2015-08-12 | 同程网络科技股份有限公司 | OTA-based quick and intelligent report form processing method |
| WO2016178673A1 (en) * | 2015-05-05 | 2016-11-10 | ESL Air, Inc. | Hydroxyl generation and/or ozone reduction system, components and method |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
-
2018
- 2018-10-23 CN CN201811234042.6A patent/CN109542975A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050209892A1 (en) * | 2004-03-19 | 2005-09-22 | Miller Jonathan K | [Automated system and method for providing accurate, non-invasive insurance status verification] |
| CN101639855A (en) * | 2009-09-02 | 2010-02-03 | 华为技术有限公司 | Report inquiry method and device thereof |
| CN104834694A (en) * | 2015-04-24 | 2015-08-12 | 同程网络科技股份有限公司 | OTA-based quick and intelligent report form processing method |
| WO2016178673A1 (en) * | 2015-05-05 | 2016-11-10 | ESL Air, Inc. | Hydroxyl generation and/or ozone reduction system, components and method |
| CN106649225A (en) * | 2016-12-30 | 2017-05-10 | 冶金自动化研究设计院 | JSON self-definition-based report generation system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Minbo et al. | Information service system of agriculture IoT | |
| Zheng et al. | Construct food safety traceability system for people’s health under the internet of things and big data | |
| Chen et al. | Development of foundation models for Internet of Things | |
| CN109189782A (en) | A kind of indexing means in block chain commodity transaction inquiry | |
| CN107896175A (en) | Collecting method and device | |
| CN104680338A (en) | Product full-service-life quality guarantee management system based on two-dimensional code | |
| CN106375528A (en) | Mobile phone ID determining method and abnormal detection and processing method | |
| CN102117467A (en) | Question and answer mode online shopping guide method | |
| CN204631931U (en) | A kind of intelligence goes out to put in storage unmanned automatic metering system | |
| CN104615721A (en) | Method and system for recommending communities based on returned goods related information | |
| CN110716955A (en) | Method and system for quickly responding to data query request | |
| CN110704486A (en) | Data processing method, device, system, storage medium and server | |
| CN111127153A (en) | One-stop type e-commerce service management platform | |
| CN110442647A (en) | Data consistency synchronous method, device and computer readable storage medium | |
| US20220156251A1 (en) | Tenant specific and global pretagging for natural language queries | |
| CN106777276B (en) | Method and device for index storage of user information and native information display | |
| CN109542975A (en) | A kind of intelligent report forms inquiry system | |
| CN205451175U (en) | Data acquisition system based on big data | |
| CN203260049U (en) | Satisfaction degree evaluating system based on two-dimension code verification | |
| Shougang et al. | Research on RFID-based meat product track and traceability system | |
| Zhang et al. | Construction of traceability system for maintenance of quality and safety of beef | |
| CN103279825B (en) | A kind of electronic record subsystem based on event and the asynchronous integrated system of operation system | |
| CN105550326A (en) | Electricity consumption query method and apparatus | |
| Cao et al. | Architectural considerations for distributed RFID tracking and monitoring | |
| Cao et al. | General framework for animal food safety traceability using GS1 and RFID |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190329 |