CN105843913A - Statistical integrated information query system based on corporate economic database - Google Patents
Statistical integrated information query system based on corporate economic database Download PDFInfo
- Publication number
- CN105843913A CN105843913A CN201610172267.8A CN201610172267A CN105843913A CN 105843913 A CN105843913 A CN 105843913A CN 201610172267 A CN201610172267 A CN 201610172267A CN 105843913 A CN105843913 A CN 105843913A
- Authority
- CN
- China
- Prior art keywords
- enterprise
- data
- database
- server side
- web server
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/21—Design, administration or maintenance of databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a statistical integrated information query system based on a corporate economic database. The system comprises a database server side and a WEB server side, wherein the database server side comprises an enterprise basic information database, an enterprise labor cost database, an enterprise financial situation database, an enterprise production and management database, an enterprise science and technology database, an enterprise information database and an enterprise energy and water resource consumption database. The WEB server side is an operational site for integrated information query software and comprises a single index query module, a multi-index query module, an enterprise data query module, a subject query module, an original report query module, an integrated query module and an intelligent search module. According to the system, a networking structure of the corporate database server side and the WEB server side is constructed, macroscopic and microscopic economic query and analysis can be carried out, and the system has the advantages of simple structure, high reliability and low cost.
Description
Technical field
The present invention relates to corporate databases's server networking technology field, be specifically related to a kind of statistic for receiver information query system based on legal person's economic data storehouse.
Background technology
Statistical department of legal person economic data Ku Shi governments at all levels carries out the basic data source of both macro and micro economic analysis, but the most unified the most domestic corporate databases builds library standard, corporate databases's standard that some places are built up differs, content and form is widely different, lacks corresponding software kit system.The present invention based on State Statistics Bureau's " a set of table " system, has formulated standard set corporate databases's index system in this regard, constructs legal person's economic data storehouse, has developed a set of information query system for data base simultaneously.
Summary of the invention
The problem that it is an object of the invention to overcome prior art to exist, it is provided that a kind of statistic for receiver information query system based on legal person's economic data storehouse.
For realizing above-mentioned technical purpose, reaching above-mentioned technique effect, the present invention is achieved through the following technical solutions:
A kind of statistic for receiver information query system based on legal person's economic data storehouse, this system includes database server side and WEB server end:
Described database server side includes enterprise's basic information database, enterprise labour wage data base, financial position of the enterprise data base, enterprise production and management data base, science and technology in enterprise status data storehouse, enterprise information data storehouse and enterprise energy water resources consumption data base；
The basic information database definition of described enterprise and the essential information data of configuration enterprise, described enterprise labour wage data base defines and configures enterprise practitioner and payroll data, described financial position of the enterprise data base definition and the financial situation data of configuration enterprise, described enterprise production and management data base definition and the production and operation data of configuration enterprise, the scientific and technological activities research and development data of the definition of described science and technology in enterprise status data storehouse and configuration enterprise, the definition of described enterprise information data storehouse and the information-based application data of configuration enterprise, described enterprise energy water resources consumption data base defines and configures the energy and the consumption data of water resource of enterprise；
Described WEB server end is for the operational site of comprehensive information searching software, and it includes single index enquiry module, multi objective enquiry module, business data enquiry module, theme enquiry module, the original report enquiry module, comprehensive inquiry module and wisdom search module；
nullDescribed single index enquiry module defines and configures single index、Query function data under the conditions of multiple choices，Target value is referred to for inquiring about any one from database server side，Described multi objective enquiry module defines and configures multiple index、Query function data under the conditions of multiple choices，For inquiring about the combined value of any index from database server side，The definition of described business data enquiry module and the configuration pin condition query data to specific enterprise，For inquiring about all data of a certain specific enterprise from database server side，The definition of described theme enquiry module and the configuration pin inquiry data to a certain particular topic demand，For inquiring the value reflecting this theme feature from database server side by given condition，The data with the original report form that described the original report enquiry module defines and configuration imposes a condition down，For inquiring setting phase other report data of enterprise from data base with the form of the original report，All conditions data in described comprehensive inquiry module definition and configuration system-oriented，For the comprehensive inquiry service according to multiple condition，The definition of described wisdom search module and configuration webpage way of search data，For providing the user snap information location and retrieval service.
Further, connected by SQL data access interface between described WEB server end and database server side and realize information transmission, described WEB server end is provided with network interface, Man Machine Interface and for the web Service interface connected with external client, and described database server side is provided with network interface and for inputting the data acquisition interface of data.
Further, described WEB server end sends SQL request by SQL data access interface to database server side, described SQL request includes one or more in common messenger service, form and graph service, after described database server side receives SQL request, data in the data base of called data storehouse server end, return to WEB server end, at WEB server end, the data returned are shown in a corresponding manner.
Further, described database server side and WEB server end are arranged in intranet server, and described WEB server end is mirrored in external network server form mirror image WEB server end.
Further, described database server side, WEB server end and WEB mirror image W server end pass sequentially through switch and fire wall connects external user, Intranet user and System Management User.
The invention has the beneficial effects as follows:
The present invention constructs corporate databases's server end and WEB server end networking structure, standard set corporate databases's index system and legal person's economic data storehouse are formulated, and define for data base and be configured with comprehensive information searching software, both macro and micro economy inquiry and analysis can be carried out, and system structure is simple, reliability is high, low cost.
Accompanying drawing explanation
Fig. 1 is the general frame of present system；
Fig. 2 is present invention application deployment environment schematic.
Detailed description of the invention
Below with reference to the accompanying drawings and in conjunction with the embodiments, the present invention is described in detail.
Shown in Figure 1, statistic for receiver information query system based on legal person's economic data storehouse is a server software, including database server side and WEB server end two equipment.Described database server side includes enterprise's basic information database, enterprise labour wage data base, financial position of the enterprise data base, enterprise production and management data base, science and technology in enterprise status data storehouse, enterprise information data storehouse, enterprise energy water resources consumption data base seven large database concept, constitutes a data-base cluster (data warehouse).Described enterprise basic information database defines 30 indexs such as name of judicial person, components mechanism code, industry code, describes the essential information of enterprise in detail；Described enterprise labour wage data base defines 33 indexs such as practitioner's end of term number, practitioner's payroll, describes practitioner and the payroll situation of enterprise in detail；Described financial position of the enterprise data base defines 54 indexs such as stock at the beginning of the year, end of term asset-liabilities, the profit and loss and distribution, cost of labor and value-added tax, describes the financial situation of enterprise in detail；Described enterprise production and management data base defines 55 indexs such as product value, product yield, sales volume, the turnover according to the different types of business (industry, building industry, wholesale and retail industry, lodging catering trade), describes the production and management of enterprise in detail；Described science and technology in enterprise status data storehouse defines 132 indexs such as science and technology item, scientific and technological activities, enterprise innovation, R&D activity, research institution according to the different types of business (industry, building industry, service trade), describes the sci-tech innovation ability of enterprise in detail；Described enterprise information data storehouse defines 12 indexs such as the use of the information-based input of enterprise, information technology, describes the level of informatization of enterprise in detail；24 indexs such as described enterprise energy water resources consumption data base defines the energy and buys, consumes and stock, recycling, the use of water resource, describe the energy of enterprise and the Expenditure Levels of water resource in detail.
Shown in Figure 1, described WEB server end is the operational site of comprehensive information searching software, including single index enquiry module, multi objective enquiry module, business data enquiry module, theme enquiry module, the original report enquiry module, comprehensive inquiry module, the big functional module of wisdom search module seven.Described single index enquiry module provides the data query function under single index, multiple choices condition (phase not, packet), it is possible to any one inquired about in 340 indexs from database server side 7 large database concept refers to target value；Described multi objective enquiry module provides the data query function under multiple indexs, multiple choices condition (index, phase not, packet), it is possible to inquire about the combined value of any index in 340 indexs from database server side 7 large database concept；Described business data enquiry module provides condition for specific enterprise (index, phase not, packet) inquiry, is used for inquiring about all data (choice sets in 340 indexs) of a certain specific enterprise；Described theme enquiry module provides for the inquiry of a certain particular topic demand, inquires, by given condition (index, phase other), the data reflecting this theme feature from data base；Described the original report enquiry module is by certain condition (phase not, enterprise), inquires certain phase other report data of certain enterprise from data base with the form of the original report；All data in described comprehensive inquiry module system-oriented, it is provided that according to the comprehensive inquiry service of the multiple conditions such as time, department, enterprise, index；Described wisdom search module, in Webpage search mode, provides the user snap information location and retrieval service.
Shown in Figure 1, WEB server end and database server side realize information by data access interface and transmit: WEB server end sends SQL request to database server, this request is probably common messenger service, it is also likely to be form or graph service, after database server receives this request, data in called data storehouse, return to WEB server end, at WEB server end, the data returned are shown in different forms.
Shown in Figure 2, system is based on B/S(browser/server) open architecture of framework: comprehensive information searching software is deployed in the WEB server of intranet server, and be mirrored in the WEB server of outer net, in view of the safety of data, data base is deployed only on the database server of intranet server end.Client includes Intranet user (support Multi-Client Concurrency Access), external user (support Multi-Client Concurrency Access) and system manager user, and client has only to install browser.
The foregoing is only the present invention is preferable to carry out peace example, is not limited to the present invention, and for a person skilled in the art, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, any modification, equivalent substitution and improvement etc. made, should be included within the scope of the present invention.
Claims (5)
1. a statistic for receiver information query system based on legal person's economic data storehouse, this system includes database server side and WEB server end, it is characterised in that:
Described database server side includes enterprise's basic information database, enterprise labour wage data base, financial position of the enterprise data base, enterprise production and management data base, science and technology in enterprise status data storehouse, enterprise information data storehouse and enterprise energy water resources consumption data base；
The basic information database definition of described enterprise and the essential information data of configuration enterprise, described enterprise labour wage data base defines and configures enterprise practitioner and payroll data, described financial position of the enterprise data base definition and the financial situation data of configuration enterprise, described enterprise production and management data base definition and the production and operation data of configuration enterprise, the scientific and technological activities research and development data of the definition of described science and technology in enterprise status data storehouse and configuration enterprise, the definition of described enterprise information data storehouse and the information-based application data of configuration enterprise, described enterprise energy water resources consumption data base defines and configures the energy and the consumption data of water resource of enterprise；
Described WEB server end is the operational site of comprehensive information searching software, and it includes single index enquiry module, multi objective enquiry module, business data enquiry module, theme enquiry module, the original report enquiry module, comprehensive inquiry module and wisdom search module；
nullDescribed single index enquiry module defines and configures single index、Data query function under the conditions of multiple choices，Target value is referred to for inquiring about any one from database server side，Described multi objective enquiry module defines and configures multiple index、Data query function under the conditions of multiple choices，For inquiring about the combined value of any index from database server side，The definition of described business data enquiry module and the configuration pin condition query to specific enterprise，For inquiring about all data of a certain specific enterprise from database server side，The definition of described theme enquiry module and the configuration pin data query to a certain particular topic demand，For inquiring the value reflecting this theme feature from database server side by given condition，The data with the original report form that described the original report enquiry module defines and configuration imposes a condition down，For inquiring setting phase other report data of enterprise from data base with the form of the original report，All conditions data in described comprehensive inquiry module definition and configuration system-oriented，For the comprehensive inquiry service according to multiple condition，The definition of described wisdom search module and configuration webpage way of search data，For providing the user snap information location and retrieval service.
Statistic for receiver information query system based on legal person's economic data storehouse the most according to claim 1, it is characterized in that, connected by SQL data access interface between described WEB server end and database server side and realize information transmission, described WEB server end is provided with network interface, Man Machine Interface and for the web Service interface connected with external client, and described database server side is provided with network interface and for inputting the data acquisition interface of data.
Statistic for receiver information query system based on legal person's economic data storehouse the most according to claim 2, it is characterized in that, described WEB server end sends SQL request by SQL data access interface to database server side, described SQL request includes one or more in common messenger service, form and graph service, after described database server side receives SQL request, data in the data base of called data storehouse server end, return to WEB server end, at WEB server end, the data returned are shown in a corresponding manner.
Statistic for receiver information query system based on legal person's economic data storehouse the most according to claim 1 and 2, it is characterized in that, described database server and WEB server are arranged in intranet server, and described WEB server is mirrored in external network server form mirror image WEB server end.
Statistic for receiver information query system based on legal person's economic data storehouse the most according to claim 4, it is characterized in that, described database server side, WEB server end and WEB mirror image server end pass sequentially through switch and fire wall connects external user, Intranet user and System Management User.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610172267.8A CN105843913A (en) | 2016-03-24 | 2016-03-24 | Statistical integrated information query system based on corporate economic database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610172267.8A CN105843913A (en) | 2016-03-24 | 2016-03-24 | Statistical integrated information query system based on corporate economic database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105843913A true CN105843913A (en) | 2016-08-10 |
Family
ID=56583150
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610172267.8A Pending CN105843913A (en) | 2016-03-24 | 2016-03-24 | Statistical integrated information query system based on corporate economic database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105843913A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113254745A (en) * | 2021-04-28 | 2021-08-13 | 深圳格隆汇信息科技有限公司 | Economic information collection system, method, computer device and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102081625A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团北京有限公司 | Data query method and query server |
| CN102609421A (en) * | 2011-01-24 | 2012-07-25 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN103218691A (en) * | 2013-04-26 | 2013-07-24 | 吉林市赢科信息技术有限责任公司 | Embedded type business intelligent information management system and management method |
| CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
-
2016
- 2016-03-24 CN CN201610172267.8A patent/CN105843913A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102081625A (en) * | 2009-11-30 | 2011-06-01 | 中国移动通信集团北京有限公司 | Data query method and query server |
| CN102609421A (en) * | 2011-01-24 | 2012-07-25 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN103218691A (en) * | 2013-04-26 | 2013-07-24 | 吉林市赢科信息技术有限责任公司 | Embedded type business intelligent information management system and management method |
| CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
Non-Patent Citations (1)
| Title |
|---|
| 段莹: ""四川省宏观经济信息数据库系统总体方案设计"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113254745A (en) * | 2021-04-28 | 2021-08-13 | 深圳格隆汇信息科技有限公司 | Economic information collection system, method, computer device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9578082B2 (en) | Methods for dynamically generating an application interface for a modeled entity and devices thereof | |
| US8937618B2 (en) | Graphical representations of corporate networks | |
| US10089583B2 (en) | Distributed cloud services system and uses thereof | |
| CN103136335B (en) | A kind of data control method based on data platform | |
| US9158532B2 (en) | Methods for managing applications using semantic modeling and tagging and devices thereof | |
| US8356026B2 (en) | Predictive data caching | |
| US7856420B2 (en) | Zero latency enterprise enriched publish/subscribe | |
| US20140244325A1 (en) | Systems and methods for capturing, managing, sharing, and visualising asset information of an organization | |
| US20200097875A1 (en) | Systems and methods for managing information about building resources | |
| CN105930446B (en) | A kind of telecom client label generating method based on Hadoop distributed computing technology | |
| US10944705B2 (en) | Systems and methods for improved processing of message queries | |
| US20080046412A1 (en) | System and method for monitoring information of trademarks | |
| Schiefer et al. | Management and controlling of time-sensitive business processes with sense & respond | |
| Dong | [Retracted] Construction of Mobile E‐Commerce Platform and Analysis of Its Impact on E‐Commerce Logistics Customer Satisfaction | |
| CN110162515A (en) | A kind of uncoupled elastic data warehouse schema | |
| SG177868A1 (en) | Digital analytics platform | |
| US8375038B2 (en) | Method to send a short message service (SMS) campaign to a related object by selecting the base object | |
| CN105843913A (en) | Statistical integrated information query system based on corporate economic database | |
| Ruiz et al. | Quantitative analysis of crime incidents in chicago using data analytics techniques | |
| CN116821106A (en) | Enterprise data digital management system and method | |
| Saxena et al. | Business intelligence | |
| US11853336B2 (en) | Method and apparatus for providing relation note using correlation | |
| Ke et al. | Analysis of a batch arrival queue with vacation policy and exceptional service | |
| KR20100078493A (en) | Sales statistical analytic and productivity service system based upon website and method thereof and media that can record computer program sources for method the same | |
| Karim et al. | Near real-time big data analytics for NFC-enabled logistics trajectories |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160810 |