CN105955974A - Corporate database based statistics analysis system - Google Patents

Corporate database based statistics analysis system Download PDF

Info

Publication number
CN105955974A
CN105955974A CN201610172224.XA CN201610172224A CN105955974A CN 105955974 A CN105955974 A CN 105955974A CN 201610172224 A CN201610172224 A CN 201610172224A CN 105955974 A CN105955974 A CN 105955974A
Authority
CN
China
Prior art keywords
data
corporate
enterprise
analysis
database
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
Application number
CN201610172224.XA
Other languages
Chinese (zh)
Inventor
杜景龙
张志敏
石快快
董京
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Suzhou University of Science and Technology
Original Assignee
Suzhou University of Science and Technology
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Suzhou University of Science and Technology filed Critical Suzhou University of Science and Technology
Priority to CN201610172224.XA priority Critical patent/CN105955974A/en
Publication of CN105955974A publication Critical patent/CN105955974A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE 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/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Quality & Reliability (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Operations Research (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention relates to a corporate database based statistics analysis system. The corporate database based statistics analysis system includes a WEB server end and a database server end; the WEB server end includes a key enterprise analysis module, a key industry analysis module, a key product analysis module, an important production factor monitoring module, a zone monitoring analysis module, an innovation ability analysis module, an industry development analysis module, an enterprise growth analysis module, and an advanced customization analysis module; and the database server end includes a corporate basic information database, a corporate labor wage database, a corporate financial situation database, a corporate production and management database, a corporate science and technology condition database, a corporate informatization database and a corporate energy water resource consumption database. The corporate database based statistics analysis system establishes a network structure of the corporate database server end and the WEB server end, can perform statistics and analysis of macro-economy and micro-economy, is simple in structure, is high in reliability and is low in cost.

Description

A kind of statistical analysis system based on corporate databases
Technical field
The present invention relates to database servers group network technology field, be specifically related to a kind of statistical analysis system based on corporate databases.
Background technology
Corporate databases is record business entity's essential information and the data message storehouse of economic activity thereof, corporate databases builds and is still in the starting stage in China, a lot of local even some big and medium-sized cities are also not set up the legal person storehouse of oneself, although the city of some developed regions establishes various types of legal person storehouse, but it is varied that it builds library standard disunity, data-base content and form, and lack and data are carried out the profound software system excavated and analyze.This invention, based on State Statistics Bureau's " a set of table " system, establishes a corporate databases that can contain enterprise's essential information and all kinds of economic activity, and has developed a set of statistical analysis system based on this data base.
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 statistical analysis system based on corporate databases.
For realizing above-mentioned technical purpose, reaching above-mentioned technique effect, the present invention is achieved through the following technical solutions:
A kind of statistical analysis system based on corporate databases, this system includes WEB server end and database server side:
Described WEB server end includes that key enterprise's analysis module, key industry analyze module, major products analyze module, important productive factor monitoring modular, area monitoring analysis module, innovation ability analyze module, industry development analysis module, business growth analyze module and senior custom analysis module;
nullDescribed key enterprise analyzes module for the definition of a certain economic indicator and configuration enterprise precedence data,For determining key enterprise,The ruuning situation of Monitoring Focus enterprise each economic target,Described key industry analyzes module definition and configuration industry statistical summaries data,Generate industry data,From the angle of industry, data are analyzed,Analysis for industry general status is provided、The data of the comparative analysis between analysis and the key industry of industry development trend,Described major products analyze module according to statistical summaries definition and configuration major products and the production of major products、Manage、Sale and stock are monitored the data analyzed,The data that the supply/demand of the definition of described important productive factor monitoring modular and configuration important productive factor is analyzed,Described area monitoring analyzes module according to statistical summaries definition and configuring area data、And from the angle in region, data are analyzed、Horizontal and vertical analysis for region is provided、The data of absolute and relative comparative analysis,Described innovation ability analyzes module definition and the analysis of configuration Technology Innovation for Enterprise situation and the data of evaluation,Module definition and the analysis of configuration enterprise industry development situation and the data of evaluation are analyzed in described industry development,Described business growth analyzes analysis and the data of evaluation of the growth situation of the module angle definition from time shaft and configuration enterprise,Described senior custom analysis module definition and configuration user select the data of the index subject dataset paid close attention to,And on the basis of self-defined subject dataset,Generate the application function belonging to user oneself,Rights management to self-defined analytic function is provided;
Described database server side includes legal person's basic information database, legal person labour wage data base, legal person financial situation data base, legal person production and operation data base, legal person Technological Status data base, corporate messageization data base and legal person energy water resource consumption data base;
The definition of described legal person's basic information database and the essential information data of configuration legal person, described legal person labour wage data base defines and configures enterprise practitioner and payroll data, described legal person financial situation data base definition and the financial situation data of configuration enterprise, described legal person production and operation data base definition and the production and operation data of configuration enterprise, described legal person Technological Status data base definition and the scientific and technological activities research and development ability data of configuration enterprise, described corporate messageization data base definition and the information-based level of application data of configuration enterprise, described legal person energy water resource consumption data base defines and configures the energy and the consumption data of water resource of enterprise.
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 database server side includes intranet data storehouse server, described WEB server end includes Intranet WEB server and outer net WEB server, being deployed with data base and application software in described intranet data storehouse server and Intranet WEB server, described outer net WEB server is connected with Intranet intranet data storehouse server and Intranet WEB server by exchange interface.
Further, described intranet data storehouse server, Intranet WEB server and outer net WEB server all comprise one main one secondary two-server and form dual-host backup strategy, for improving the safety of data, and ensure that, when master server quits work due to accidental cause, secondary server undertakes the function of master server.
Further, described intranet data storehouse server, Intranet WEB server and outer net WEB server pass sequentially through switch and outer net fire wall connects outer net terminal use, and Intranet user and System Management User connect and access intranet data storehouse server and Intranet WEB server by switch.
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 statistics analytical database are formulated, and define for data base and be configured with statistical analysis software, both macro and micro economic statistics and analysis can be carried out, and system structure is simple, reliability is high, low cost.
Accompanying drawing explanation
Fig. 1 is corporate databases's statistical analysis system overall framework figure;
Fig. 2 is present invention application deployment structural representation.
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.
With reference to shown in Fig. 1, statistical analysis system based on corporate databases is a server software, including database server and WEB server.Statistical analysis software operates in WEB server end, and including key enterprise's analysis module, key industry analyzes module, major products analyze module, important productive factor monitoring modular, area monitoring analysis module, innovation ability analyze module, industry development analysis module, business growth analyze module, senior custom analysis module.Described key enterprise analyzes module by enterprise being carried out ranking for a certain economic indicator data, to determine key enterprise, and the then ruuning situation of Monitoring Focus enterprise each economic target, and provide and overstate that annual forest monitoring and Nian Nei monitor for enterprise;Described key industry analyzes module by the statistical summaries to data, generates industry data, is then analyzed data from the angle of industry, it is provided that for the analysis of industry general status, comparative analysis between the analysis of industry development trend and key industry;Data, by the statistical summaries to data, formation zone data, are then analyzed, it is provided that for horizontal and vertical analysis, the absolute and relative comparative analysis in region by described area monitoring analysis module from the angle in region;Described major products analyze module by the statistical summaries to data, determine major products, then provide the production to major products, manage, sell and stock be monitored analyze;Described important productive factor monitoring modular provides the supply/demands such as the production and sales to important productive factors such as water, electricity, product oil, coals to be analyzed;Described innovation ability analyze module provide the analysis for Technology Innovation for Enterprise situation and evaluation, analyze including innovation talent, innovation service analysis, innovation investment analysis, Innovative Output analysis and innovation cooperating analysis;Described industry development is analyzed module and is provided the analysis for enterprise's industry development situation and evaluation, including industry size analysis, industrial benefit analysis, Analysis of Industrial Structure and industrial pattern analysis;Described business growth is analyzed module and from the angle of time shaft, the growth situation of enterprise is analyzed and is evaluated, and emphasis is for vigor type enterprise, leading type enterprise and the analysis of overseas-funded enterprise;Described senior custom analysis module supports that the index that user selects oneself to pay close attention to constitutes one's own subject dataset, on the basis of self-defined subject dataset, generates the application function belonging to user oneself, provides the rights management to self-defined analytic function simultaneously.
With continued reference to shown in Fig. 1, shown database server includes legal person's basic information database, legal person labour wage data base, legal person financial situation data base, legal person production and operation data base, legal person Technological Status data base, corporate messageization data base, legal person's energy water resource consumption data base seven large database concept.Described legal person's basic information database includes 2 big class lists, describes the basic condition of legal person in detail;Described legal person labour wage data base includes 5 big class lists, describes practitioner and the payroll situation of enterprise in detail;Described legal person financial situation data base comprises 12 big class lists, describes the financial situation of enterprise in detail;Described legal person production and operation data base comprises 15 big class lists, describes the production and management of enterprise in detail;Described legal person Technological Status data base includes 10 big class lists, describes the sci-tech innovation ability of enterprise in detail;Described corporate messageization data base includes 2 big class lists, describes the level of informatization of enterprise in detail;Described legal person energy water resource consumption data base includes 4 big class lists, describes the energy of enterprise and the Expenditure Levels of water resource in detail.
With reference to shown in Fig. 2, system is open architecture based on B/S framework, being made up of Intranet and outer net two parts, data base and application software are deployed in database server and the WEB server end of Intranet respectively, and outer net WEB server end is connected with Intranet by network communication interface.The server of intranet and extranet all uses dual-host backup strategy (providing one main one secondary two-server), on the one hand can improve the safety of data, also ensure that, when master server quits work due to accidental cause, secondary server can undertake the function of master server simultaneously.Client includes Intranet user (supporting concurrently to access), external user (supporting concurrently to access) and system manager user, and client has only to install browser.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, 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 statistical analysis system based on corporate databases, this system includes WEB server end and database server side, it is characterised in that
Described WEB server end includes that key enterprise's analysis module, key industry analyze module, major products analyze module, important productive factor monitoring modular, area monitoring analysis module, innovation ability analyze module, industry development analysis module, business growth analyze module and senior custom analysis module;
nullDescribed key enterprise analyzes module for the definition of a certain economic indicator and configuration enterprise precedence data,For determining key enterprise,The ruuning situation of Monitoring Focus enterprise each economic target,Described key industry analyzes module definition and configuration industry statistical summaries data,Generate industry data,From the angle of industry, data are analyzed,Analysis for industry general status is provided、The data of the comparative analysis between analysis and the key industry of industry development trend,Described major products analyze module according to statistical summaries definition and configuration major products and the production of major products、Manage、Sale and stock are monitored the data analyzed,The data that the supply/demand of the definition of described important productive factor monitoring modular and configuration important productive factor is analyzed,Described area monitoring analyzes module according to statistical summaries definition and configuring area data、And from the angle in region, data are analyzed、Horizontal and vertical analysis for region is provided、The data of absolute and relative comparative analysis,Described innovation ability analyzes module definition and the analysis of configuration Technology Innovation for Enterprise situation and the data of evaluation,Module definition and the analysis of configuration enterprise industry development situation and the data of evaluation are analyzed in described industry development,Described business growth analyzes analysis and the data of evaluation of the growth situation of the module angle definition from time shaft and configuration enterprise,Described senior custom analysis module definition and configuration user select the data of the index subject dataset paid close attention to,And on the basis of self-defined subject dataset,Generate the application function belonging to user oneself,Rights management to self-defined analytic function is provided;
Described database server side includes legal person's basic information database, legal person labour wage data base, legal person financial situation data base, legal person production and operation data base, legal person Technological Status data base, corporate messageization data base and legal person energy water resource consumption data base;
The definition of described legal person's basic information database and the essential information data of configuration legal person, described legal person labour wage data base defines and configures enterprise practitioner and payroll data, described legal person financial situation data base definition and the financial situation data of configuration enterprise, described legal person production and operation data base definition and the production and operation data of configuration enterprise, described legal person Technological Status data base definition and the scientific and technological activities research and development ability data of configuration enterprise, described corporate messageization data base definition and the information-based level of application data of configuration enterprise, described legal person energy water resource consumption data base defines and configures the energy and the consumption data of water resource of enterprise.
Statistical analysis system based on corporate databases 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.
Statistical analysis system based on corporate databases the most according to claim 1 and 2, it is characterized in that, described database server side includes intranet data storehouse server, described WEB server end includes Intranet WEB server and outer net WEB server, being deployed with data base and application software in described intranet data storehouse server and Intranet WEB server, described outer net WEB server is connected with Intranet intranet data storehouse server and Intranet WEB server by exchange interface.
Statistical analysis system based on corporate databases the most according to claim 3, it is characterized in that, described intranet data storehouse server, Intranet WEB server and outer net WEB server all comprise one main one secondary two-server and form dual-host backup strategy, for improving the safety of data, and ensure that, when master server quits work due to accidental cause, secondary server undertakes the function of master server.
Statistical analysis system based on corporate databases the most according to claim 3, it is characterized in that, described intranet data storehouse server, Intranet WEB server and outer net WEB server pass sequentially through switch and outer net fire wall connects outer net terminal use, and Intranet user and System Management User connect and access intranet data storehouse server and Intranet WEB server by switch.
CN201610172224.XA 2016-03-24 2016-03-24 Corporate database based statistics analysis system Pending CN105955974A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610172224.XA CN105955974A (en) 2016-03-24 2016-03-24 Corporate database based statistics analysis system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610172224.XA CN105955974A (en) 2016-03-24 2016-03-24 Corporate database based statistics analysis system

Publications (1)

Publication Number Publication Date
CN105955974A true CN105955974A (en) 2016-09-21

Family

ID=56917510

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610172224.XA Pending CN105955974A (en) 2016-03-24 2016-03-24 Corporate database based statistics analysis system

Country Status (1)

Country Link
CN (1) CN105955974A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107977547A (en) * 2017-12-20 2018-05-01 吉林大学 Data processing method based on metering system
CN108182502A (en) * 2016-12-08 2018-06-19 爱信诺征信有限公司 The generation method of growing quality evaluation index, the statistical method of business growth value

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2000068860A2 (en) * 1999-05-12 2000-11-16 Innovative Systems, Inc. Method of social network generation for customer relationships
CN101763563A (en) * 2008-12-26 2010-06-30 中国电子科技集团公司第五十研究所 Public traffic management information system
CN102226914A (en) * 2011-05-26 2011-10-26 李强 Science oriented medium and small size enterprises growth capability expert evaluating system
CN102682368A (en) * 2012-05-18 2012-09-19 苏州佰思迈信息咨询有限公司 Evaluation software for enterprise comprehensive capacity
CN104376406A (en) * 2014-11-05 2015-02-25 上海计算机软件技术开发中心 Enterprise innovation resource management and analysis system and method based on big data
CN105225052A (en) * 2015-10-13 2016-01-06 杭州市质量技术监督检测院 Multi-platform universal industry size analysis decision method

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2000068860A2 (en) * 1999-05-12 2000-11-16 Innovative Systems, Inc. Method of social network generation for customer relationships
CN101763563A (en) * 2008-12-26 2010-06-30 中国电子科技集团公司第五十研究所 Public traffic management information system
CN102226914A (en) * 2011-05-26 2011-10-26 李强 Science oriented medium and small size enterprises growth capability expert evaluating system
CN102682368A (en) * 2012-05-18 2012-09-19 苏州佰思迈信息咨询有限公司 Evaluation software for enterprise comprehensive capacity
CN104376406A (en) * 2014-11-05 2015-02-25 上海计算机软件技术开发中心 Enterprise innovation resource management and analysis system and method based on big data
CN105225052A (en) * 2015-10-13 2016-01-06 杭州市质量技术监督检测院 Multi-platform universal industry size analysis decision method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
苗青: "智慧城市法人基础数据库构建的若干问题研究", 《创新科技》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108182502A (en) * 2016-12-08 2018-06-19 爱信诺征信有限公司 The generation method of growing quality evaluation index, the statistical method of business growth value
CN107977547A (en) * 2017-12-20 2018-05-01 吉林大学 Data processing method based on metering system

Similar Documents

Publication Publication Date Title
US20130085813A1 (en) Method, Apparatus and Computer Program Product for Providing a Supply Chain Performance Management Tool
CN104361424A (en) Master data system integration method based on enterprise service bus (ESB)
CN105512790A (en) Integrated operation and maintenance management system
Cheng et al. Supply chain drivers of organizational flexibility—A study of US manufacturing industries
CA2746898A1 (en) Digital analytics platform
JP2008225789A (en) Management information management system, management information management method and management information management program
CN105955974A (en) Corporate database based statistics analysis system
Grandori 2. Linnaeus in the jungle: configurational lenses for discerning forms of economic organization in agri-business
CN101877110A (en) Product management system and application method thereof
Ke et al. A message negotiation approach to e-services by utility function and multi-criteria decision analysis
Huang et al. Cloud services platform based on big data analytics and its application in livestock management and marketing
CN102663539A (en) Operation cost management system based on platform of internet of things
CN110210890A (en) A kind of movable share system and implementation method based on Spring Cloud
CN101937553A (en) Shared union integrated business platform in common
Wang et al. The perspective of B2MML based on implementation
Oyatoye Information distortion in supply chain: A simulation approach to quantifying the bullwhip effect
Fernandez et al. Integrating business analytics into SMEs in Mexico: Challenges and opportunities
CN109214871A (en) Commercial square management system platform
Rong et al. The theoretical study and empirical research process of service innovation: a literature review
Zwicker et al. An assessment on the Informatization of Brazilian industrial companies
Sansone et al. Marketing innovation and key performance indicator in banking
Feng A framework for culturally influenced information systems management
Zhan et al. Study on scale-free product collaborative design supporting platform
Qiang et al. Research on the design of a new data warehouse system
Wei et al. Partnership in supply Chain risk management research

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: 20160921