CN115309839A - Intelligent forestry system and medium based on data warehouse and construction method - Google Patents
Intelligent forestry system and medium based on data warehouse and construction method Download PDFInfo
- Publication number
- CN115309839A CN115309839A CN202210949683.XA CN202210949683A CN115309839A CN 115309839 A CN115309839 A CN 115309839A CN 202210949683 A CN202210949683 A CN 202210949683A CN 115309839 A CN115309839 A CN 115309839A
- Authority
- CN
- China
- Prior art keywords
- data
- forestry
- information
- intelligent
- warehouse
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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
- 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/29—Geographical information databases
-
- 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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/02—Agriculture; Fishing; Mining
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Mining & Mineral Resources (AREA)
- Economics (AREA)
- Animal Husbandry (AREA)
- Marine Sciences & Fisheries (AREA)
- Life Sciences & Earth Sciences (AREA)
- Remote Sensing (AREA)
- Health & Medical Sciences (AREA)
- Agronomy & Crop Science (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an intelligent forestry system and medium based on a data warehouse and a construction method, relates to the field of intelligent forestry, and provides a command forestry construction method based on a data warehouse, which determines a corresponding function theme and a corresponding business entity of the intelligent forestry according to information of all departments of the forestry, obtains corresponding original forestry data, designs a forestry data standard, standardizes and stores the original forestry data, can integrate the forestry system data with complicated and generalized data forms into the data warehouse, and establishes a forestry command system based on the data warehouse. The intelligent forestry system established based on the characteristics of theme orientation, data integration and high stability of the data warehouse can meet the requirements of the forestry system from digitization to intellectualization, and realizes the unified management of various data of forestry services.
Description
Technical Field
The invention relates to the field of intelligent forestry, in particular to an intelligent forestry system based on a data warehouse, a medium and a construction method.
Background
The intelligent forestry is a new forestry development mode which makes full use of new-generation information technologies such as cloud computing, internet of things, mobile internet, big data and the like and forms forestry three-dimensional perception, management synergy high efficiency, ecological value highlighting and service internal and external integration through perception, physical connection and intelligentization means. With the rapid development of IT technology, various industries tend to be intelligent and flat in business processing. As the traditional industry, the data form of the forestry is complicated and generalized, the stored or used data of each department, unit and department in the forestry system have the same, similar, partially same or completely different conditions due to different businesses, and the business data and the forestry resource background data borne by various informatization systems used by each department, unit and department in the forestry system also have certain difference and cannot meet the requirement of the intelligent forestry system on data flattening.
Disclosure of Invention
In order to solve the problems that various data forms in the traditional forestry system are complicated and generalized, and forestry data used among departments, units and rooms of the forestry system are different, so that a plurality of forestry data designed by the forestry system cannot be uniformly managed, and the forestry informatization to intelligent development is not facilitated, the invention provides an intelligent forestry system based on a data warehouse, which comprises:
a data access unit: the system is used for accessing a data source and obtaining a plurality of original forestry data;
ETL unit: the system is used for processing the plurality of original forestry data to obtain a plurality of bottom layer forestry data;
a data storage unit: for storing the underlying forestry data;
a data analysis unit: the data storage unit is used for calling and analyzing the bottom layer forestry data in the data storage unit according to business requirements;
a data feedback unit: for feeding back the analysis result obtained by the data analysis unit.
Wherein, the principle of the system is as follows: the intelligent forestry system is established based on the characteristics of theme orientation, data integration and high stability of a data warehouse, a data access unit is connected with a data source to obtain a plurality of forestry data corresponding to a plurality of forestry services, and then the plurality of forestry data are distinguished and integrated according to different service themes through an ETL unit, so that the plurality of forestry data are processed into operable data and stored by the storage unit. And calling the data in the data storage unit for corresponding analysis through the data analysis unit according to the requirements, and finally feeding back the analysis result through the data feedback unit to realize the unified management of all data of the forestry service.
For different service requirements, the required data refining degrees are different, the higher the data refining degree of the service requirements is, the larger the data quantity is, and the lower the data granularity is; the lower the data thinning degree of the service requirement is, the smaller the data quantity is, and the higher the data granularity is; in order to provide data with different granularities according to different business requirements, the data storage unit comprises a plurality of data warehouses and a plurality of data marts, the data warehouses and the data marts are both used for storing the bottom forestry data, and the data granularity of the bottom forestry data stored by the data warehouses is lower than that of the bottom forestry data stored by the data marts.
Furthermore, in order to enable the structure of the intelligent forestry system to be more complete and facilitate the intelligent forestry system to adapt to new business requirements when business requirements change, the intelligent forestry system distinguishes the bottom layer forestry data according to business themes, and the data warehouses and the data marts have different function themes.
The method comprises the steps that a plurality of original forestry data obtained from various departments, units and rooms of the forestry are data subjected to adjustment and adaptive adjustment according to different business requirements of the departments, the units and the rooms, the original forestry data obtained from the various departments, the units and the rooms are data combined by forestry background data and corresponding business modification, the original forestry data possibly have the problem of data redundancy, namely the data representing unified meanings appear for a plurality of times in different description modes, and in order to eliminate unnecessary data storage cost caused by data redundancy, the ETL unit processes the forestry data according to a forestry data standard to obtain a plurality of bottom layer forestry data.
In order to achieve the purpose, the invention provides a method for constructing an intelligent forestry system based on a data warehouse, which comprises the following steps:
the business theme building step comprises the following steps: determining corresponding function themes and business entities of the intelligent forestry according to information of all parts of the forestry, and establishing corresponding data warehouses and data marts according to the function themes and the business entities;
a data preparation step comprising: acquiring corresponding original forestry data from a data source according to the function theme and the business entity, and reserving an input format, a structure and fine granularity of the original forestry data, wherein the original forestry data comprises redundant data and also comprises structured and/or unstructured data;
data standard construction steps, including: designing forestry data standards according to the function theme, the business entity and the original data;
a data normalization step comprising: processing the raw data into standardized data according to the forestry data standard;
a data storage step, comprising: and storing the standardized data in a corresponding data warehouse and/or data mart.
The method comprises the following steps: the method comprises the steps of obtaining function themes and business entities of all departments of forestry, determining function themes corresponding to a data warehouse and a data mart for storing forestry data in the intelligent forestry system, obtaining original forestry data from a data source, classifying the original data according to the function themes, obtaining input formats, structures and fine granularity of the original data corresponding to all the function themes, creating standardized data according to the original forestry data, processing the original data into standardized data, and finally storing the standardized data in the corresponding data warehouse and/or the data mart in a data storage step, so that construction of the intelligent forestry system based on the data warehouse is achieved.
The method comprises the steps that data are obtained in a mode of directly connecting with a national database, wherein confidential data may exist in forestry data, and the corresponding original forestry data are obtained from a data source in a mode of calling a data offline packet and/or a real-time link connection source database in the data preparation step in order to obtain the original forestry data.
In order to completely and clearly describe service differences among departments, units and rooms of the forestry system, the service entity comprises a plurality of service attributes, wherein the service attributes comprise but are not limited to data sequence numbers, data description, data classification, data quantity, data limitation, data time, data tasks, data places, data states and data auditing.
In order to completely and clearly describe business differences among all departments, units and departments of the forestry system, the information of all the departments of the forestry system comprises organization structure information, existing system information and business requirement information.
Further, in order to completely and clearly describe business differences among various departments, units and rooms of the forestry system, the organizational structure information at least comprises: office function information, manager information and responsibility division information;
the existing system information at least comprises: operating system information, database information, data stream information, and permission information;
the service requirement information at least comprises: service entity information and service event information.
In order to achieve the above object, the present invention provides a computer-readable storage medium storing a computer program which, when executed by a processor, implements the functions of the data-warehouse-based intelligent forestry system.
One or more technical schemes provided by the invention at least have the following technical effects or advantages: the method comprises the steps of determining corresponding function subjects and business entities of the intelligent forestry according to information of all parts of the forestry, obtaining corresponding original forestry data, designing a forestry data standard, carrying out standardized processing on the original forestry data and storing the original forestry data, integrating forestry system data which are complicated in data form and generalized into a data warehouse, and establishing a command forestry system based on the data warehouse. An intelligent forestry system established based on the characteristics of theme oriented, data integration and high stability of a data warehouse can meet the requirements of the forestry system from digitization to intellectualization, and realizes the unified management of various data of forestry business.
Drawings
The accompanying drawings, which are included to provide a further understanding of the embodiments of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention;
fig. 1 is a schematic diagram of a data warehouse-based intelligent forestry system structure in the invention;
fig. 2 is a schematic flow chart of the construction method of the intelligent forestry system based on the data warehouse in the invention.
Detailed Description
In order that the above objects, features and advantages of the present invention can be more clearly understood, a more particular description of the invention will be rendered by reference to the appended drawings. It should be noted that the embodiments of the present invention and features of the embodiments may be combined with each other without conflicting with each other.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention, however, the present invention may be practiced in other ways than those specifically described and thus the scope of the present invention is not limited by the specific embodiments disclosed below.
Example one
Referring to fig. 1, an embodiment of the present invention provides an intelligent forestry system based on a data warehouse, including:
a data access unit: the system is used for accessing a data source and obtaining a plurality of original forestry data;
the original forestry data comprises one map of homeland, one map of forestry, one map of forest land, one map of forest resources, forestry management information, forestry condition information, ecological monitoring information and the like corresponding to all departments, units and departments in the forestry system.
ETL unit: the system is used for processing the plurality of original forestry data to obtain a plurality of bottom layer forestry data;
the ETL extracts (Extract), converts (Transform) and loads (load) data, and the bottom layer forestry data excludes internal processing of forestry data by each department, unit and office in the forestry system, and describes standard data corresponding to a plurality of businesses in the forestry system.
A data storage unit: for storing the underlying forestry data;
a data analysis unit: the data storage unit is used for calling and analyzing the bottom layer forestry data in the data storage unit according to business requirements;
a data feedback unit: for feeding back the analysis result obtained by the data analysis unit.
The data access unit comprises a dao layer, a service layer and a controller layer, wherein the dao layer is used for being in contact with a database and comprises a plurality of interfaces connected with the database; the service layer is used for calling a defined dao layer interface as required; and the controller layer is used for calling the service layer to abstract and summarize different data access tasks, so that the system program structure is clear.
In this embodiment, the data access unit obtains the corresponding original forestry data from the data source by calling a data offline package and/or a real-time chain connection source database.
Specifically, for the database which is a national system database or the database contains confidential data, the data access unit obtains corresponding original forestry data from a data source by calling a data offline package, namely, non-confidential useful data is led out to be an offline package, and the problem of information security caused by direct connection with the confidential data is avoided; and for the non-secret-related database, the data access unit is directly connected with the source database through an IP address or a data source port, so that corresponding original forestry data is obtained.
In this embodiment, the data storage unit includes a plurality of data warehouses and a plurality of data marts, the data warehouses and the data marts are both used for storing the bottom forestry data, and the data granularity of the bottom forestry data stored in the data warehouses is higher than that of the bottom forestry data stored in the data marts.
Specifically, the data warehouse is used for storing data with smaller enterprise-level data granularity and higher data refinement degree, such as a forestry graph, a homeland graph and the like, and the data mart is used for storing data with larger department-level data granularity and lower data refinement degree, such as certain forest land monitoring condition information, meteorological information and the like.
In this embodiment, the intelligent forestry system distinguishes the bottom layer forestry data according to business themes, the data warehouses and the data marts have different functional themes, specifically, one forestry chart and one homeland chart are stored in different data warehouses, and monitoring condition information, meteorological information and the like of a certain forest land are stored in different data marts.
Different functional topics corresponding to the data warehouses and the data marts are determined according to needs of the system type actual use, and the embodiment is not specifically limited herein.
In this embodiment, data redundancy exists in the plurality of forestry data, and the ETL unit processes the plurality of forestry data according to a forestry data standard to obtain a plurality of bottom layer forestry data.
Specifically, the ETL unit processes the plurality of original forestry data according to the forestry data standard to obtain a plurality of bottom layer forestry data, including data extraction, data conversion and data loading, that is, the ETL unit extracts the plurality of original forestry data obtained by the data access unit, performs data conversion on the plurality of original forestry data according to the forestry data standard to obtain a plurality of bottom layer forestry data, and finally loads the plurality of bottom layer forestry data to the data storage unit.
Wherein, the forestry data standard is determined according to the requirement of the system in actual use, and the embodiment is not specifically limited herein.
Example two
Referring to fig. 2, a second embodiment of the present invention provides a data-warehouse-based intelligent forestry construction method, where the data-warehouse-based intelligent forestry system construction method includes the following steps:
the business theme building step comprises the following steps: determining corresponding function themes and business entities of the intelligent forestry according to information of all parts of the forestry, and establishing corresponding data warehouses and data marts according to the function themes and the business entities;
a data preparation step, comprising: acquiring corresponding original forestry data from source data according to the function theme and the business entity, and reserving an input format, a structure and fine granularity of the original forestry data, wherein the original forestry data comprise redundant data and structured and/or unstructured data;
data standard construction steps, including: designing a forestry data standard according to the function theme, the business entity and the original forestry data;
a data normalization step comprising: processing the original forestry data into standardized data according to the forestry data standard;
a data storage step, comprising: and storing the standardized data in a corresponding data warehouse and/or data mart.
In this embodiment, in the data preparation step, the corresponding original forestry data is obtained from the data source by calling a data offline package and/or a real-time link connection source database.
Specifically, in the data preparation step, corresponding original forestry data are obtained from a data source by calling a data offline package mode, namely non-confidential useful data are led out to be offline packages, and the problem of information safety caused by direct connection with the confidential data is avoided; for the non-secret-involved database, the data preparation step is directly connected with the source database through an IP address or a data source port, so that corresponding original forestry data is obtained.
In this embodiment, the service entity includes a plurality of service attributes, and the service entities are differentiated by the service attributes. Specifically, due to the fact that forestry data is systematized definitely, main attribute definitions of various types of data are relatively independent on the basis of services, and the service attributes include, but are not limited to, data sequence numbers, data description, data classification, data quantity, data limitation, data time, data tasks, data places, data states, data auditing and other attributes.
In this embodiment, the business theme construction is implemented by investigating various places of the forestry bureau related to the intelligent system, and includes organizational structure information, existing system information, and business requirement information.
Specifically, determining the organizational structure information, namely investigating the forestry subordinate department, and acquiring the department function, the number of personnel and the work division of the personnel duty. Based on the information, performing theme modeling on the department, namely determining the attention points of the personnel in the department to the business corresponding to the functions of the department; after analyzing the focus, the subject domain, i.e. the boundary of the subject, is determined.
Specifically, the existing system information is determined, that is, the forestry source system is investigated, and each room, business, object, operating system, database, data stream and the like are investigated. The service research comprises obtaining information of source system positioning, functions, service scenes and ranges, whether future service expansion exists and the like. The operating system research comprises software, hardware, a database, authority and other information of the interactive two operating systems. The data flow investigation comprises information such as a data model, a data operation process, a final presentation result and the like.
Specifically, the service requirement information is determined, that is, the corresponding service event is determined according to the actual service scene.
Data standard construction steps, including: designing forestry data standards according to the function theme, the business entity and the original data;
in the data standard construction step, as the forestry is a field with strong service and strong field, for different forestry services, such as forestry planning monitoring and forestry protection monitoring, the two may be related to a forest land map, but different services may have a heterogeneous situation, that is, the same theme exists, but because the service meanings are different, the attributes corresponding to the theme are different. Specifically, for a forestry planning unit and a forestry protection unit, for the description of tree species information in a forest land map, the forestry planning unit uses tree species for description, and the forestry protection unit uses tree species for description. The tree species and the forest species are the same in description content, but semantically, the range expressed by the former is larger than that expressed by the latter, and the attribute range in one map corresponding to the former is also larger than that expressed by the latter; secondly, the forestry protection unit and the forestry planning unit should use unified forestry data, but due to the business difference, the forestry protection unit and the forestry planning unit modify certain terms according to the business thereof, so as to cause the data difference. The data standard construction step is to ensure that corresponding attributes and expression ranges of forestry data with the same theme in each business are kept the same by determining forestry data standards.
In the data standardization step, due to the fact that forestry data systematization is definite, the data type is different from that of e-commerce platforms or enterprise data and is complex, a plurality of data models are needed to describe various data in the operation process, business-based standardization of forestry data can be achieved through the forestry data standard, specifically, the most common processing in the standardization process of the forestry data is repeated processing of forestry data attribute names, the forestry data is achieved through the forestry data standard, specifically, a unique number is determined for the forestry attribute names according to a name-code form, a field length and a field remark are determined, if the code of a forest land specified in the forestry data standard is 001001, the code of a non-forest land is 001002, and the repeated attribute names in the forestry data can be cleaned and replaced through the unique number.
EXAMPLE III
A third embodiment of the present invention provides a computer-readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the computer program implements the functions of the data-warehouse-based intelligent forestry system.
The computer storage medium may comprise a propagated data signal with the computer program code embodied therewith, for example, on baseband or as part of a carrier wave. The propagated signal may take any of a variety of forms, including electromagnetic, optical, etc., or any suitable combination. A computer storage medium may be any computer-readable medium that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code located on a computer storage medium may be propagated over any suitable medium, including radio, cable, fiber optic cable, RF, or the like, or any combination of the preceding.
Computer program code required for the operation of various portions of this specification may be written in any one or more programming languages, including an object oriented programming language such as Java, scala, smalltalk, eiffel, JADE, emerald, C + +, C #, VB.NET, python, and the like, a conventional programming language such as C, visual Basic, fortran 2003, perl, COBOL 2002, PHP, ABAP, a dynamic programming language such as Python, ruby, and Groovy, or other programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer may be connected to the user's computer through any network format, such as a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet), or in a cloud computing environment, or as a service, such as a software as a service (SaaS).
Additionally, the order in which the elements and sequences of the process are recited in the specification, the use of alphanumeric characters, or other designations, is not intended to limit the order in which the processes and methods of the specification occur, unless otherwise specified in the claims. While various presently contemplated embodiments of the invention have been discussed in the foregoing disclosure by way of example, it is to be understood that such detail is solely for that purpose and that the appended claims are not limited to the disclosed embodiments, but, on the contrary, are intended to cover all modifications and equivalent arrangements that are within the spirit and scope of the embodiments herein. For example, although the system components described above may be implemented by hardware devices, they may also be implemented by software-only solutions, such as installing the described system on an existing server or mobile device.
Similarly, it should be noted that in the preceding description of embodiments of the present specification, various features are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure aiding in the understanding of one or more of the embodiments. This method of disclosure, however, is not intended to imply that more features are required than are expressly recited in the claims. Indeed, the embodiments may be characterized as having less than all of the features of a single embodiment disclosed above.
For each patent, patent application publication, and other material, such as articles, books, specifications, publications, documents, etc., cited in this specification, the entire contents of each are hereby incorporated by reference into the specification. Except where the application history document does not conform to or conflict with the contents of the present specification, it is to be understood that the application history document, as used herein in the present specification or appended claims, is intended to define the broadest scope of the present specification (whether presently or later in the specification) rather than the broadest scope of the present specification. It is to be understood that the descriptions, definitions and/or uses of terms in the accompanying materials of this specification shall control if they are inconsistent or contrary to the descriptions and/or uses of terms in this specification.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the invention.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
Claims (10)
1. An intelligent forestry system based on a data warehouse, characterized in that the intelligent forestry system based on the data warehouse comprises:
a data access unit: the system is used for accessing a data source and obtaining a plurality of original forestry data;
ETL unit: the system is used for processing the plurality of original forestry data to obtain a plurality of bottom layer forestry data;
a data storage unit: for storing the underlying forestry data;
a data analysis unit: the data storage unit is used for calling and analyzing the bottom layer forestry data in the data storage unit according to business requirements;
a data feedback unit: for feeding back the analysis result obtained by the data analysis unit.
2. The intelligent forestry system based on data warehouse according to claim 1, wherein the underlying forestry data have different data granularities, the data storage unit comprises a plurality of data warehouses and a plurality of data marts, the data warehouses and the data marts are used for storing the underlying forestry data, and the data warehouses store the underlying forestry data with a data granularity lower than that of the data marts.
3. The data-warehouse-based intelligent forestry system of claim 2, wherein the data warehouses and data marts have different functional themes.
4. The intelligent forestry system based on data warehouse of claim 1, wherein data redundancy exists in the forestry data, and the ETL unit processes the raw forestry data according to forestry data standard to obtain bottom forestry data.
5. A data warehouse-based intelligent forestry system construction method, wherein the data warehouse-based intelligent forestry system modeling method is used for constructing a data warehouse-based intelligent forestry system as claimed in any one of claims 1 to 4, and the data warehouse-based intelligent forestry system construction method comprises the following steps:
the business theme building step comprises the following steps: determining corresponding function themes and business entities of the intelligent forestry according to information of all parts of the forestry, and establishing corresponding data warehouses and data marts according to the function themes and the business entities;
a data preparation step comprising: acquiring corresponding original data from source data according to the functional theme and the business entity, and reserving the input format, structure and fine granularity of the original data, wherein the original data comprises redundant data and also comprises structured and/or unstructured data;
data standard construction steps, including: designing forestry data standards according to the function theme, the business entity and the original data;
a data normalization step, comprising: processing the raw data into standardized data according to the forestry data standard;
a data storage step, comprising: and storing the standardized data in a corresponding data warehouse and/or data mart.
6. The intelligent forestry system construction method based on data warehouse as claimed in claim 5, wherein in the data preparation step, the corresponding raw forestry data is obtained from the data source by calling a data offline package and/or a real-time link connection source database.
7. The intelligent forestry system construction method based on data warehouse as claimed in claim 5, wherein the business entity comprises a plurality of business attributes, wherein the business attributes include but are not limited to data sequence number, data description, data classification, data quantity, data limitation, data time, data task, data location, data status and data audit.
8. The intelligent forestry construction method based on the data warehouse of claim 5, wherein the forestry department information includes organizational structure information, existing system information and business requirement information.
9. The intelligent forestry construction method based on data warehouse according to claim 8, wherein the organizational structure information at least includes: office function information, manager information and responsibility division information;
the existing system information at least comprises: operating system information, database information, data flow information, and permission information;
the service requirement information at least comprises: service entity information and service event information.
10. A computer-readable storage medium, having a computer program stored thereon, which, when being executed by a processor, carries out the steps of the data-warehouse based intellectual forestry system according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210949683.XA CN115309839A (en) | 2022-08-09 | 2022-08-09 | Intelligent forestry system and medium based on data warehouse and construction method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210949683.XA CN115309839A (en) | 2022-08-09 | 2022-08-09 | Intelligent forestry system and medium based on data warehouse and construction method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115309839A true CN115309839A (en) | 2022-11-08 |
Family
ID=83861544
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210949683.XA Pending CN115309839A (en) | 2022-08-09 | 2022-08-09 | Intelligent forestry system and medium based on data warehouse and construction method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115309839A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116383222A (en) * | 2023-03-28 | 2023-07-04 | 中国标准化研究院 | Construction method of grass ecological restoration monitoring core database |
| CN117290343A (en) * | 2023-11-24 | 2023-12-26 | 航天宏图信息技术股份有限公司 | Intelligent forestry big data system, method, server and medium based on data lake |
-
2022
- 2022-08-09 CN CN202210949683.XA patent/CN115309839A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116383222A (en) * | 2023-03-28 | 2023-07-04 | 中国标准化研究院 | Construction method of grass ecological restoration monitoring core database |
| CN117290343A (en) * | 2023-11-24 | 2023-12-26 | 航天宏图信息技术股份有限公司 | Intelligent forestry big data system, method, server and medium based on data lake |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2022095435A1 (en) | Multilevel linkage management platform for aiot device accessing paas and saas | |
| CN115309839A (en) | Intelligent forestry system and medium based on data warehouse and construction method | |
| US11943225B2 (en) | Hierarchical permissions model for case management | |
| US7523135B2 (en) | Risk and compliance framework | |
| US6606740B1 (en) | Development framework for case and workflow systems | |
| US11829368B2 (en) | Systems and methods for management of data analytics platforms using metadata | |
| US11163906B2 (en) | Adaptive redaction and data releasability systems using dynamic parameters and user defined rule sets | |
| US11334593B2 (en) | Automated ETL workflow generation | |
| US20130166602A1 (en) | Cloud-enabled business object modeling | |
| US20070043716A1 (en) | Methods, systems and computer program products for changing objects in a directory system | |
| US20190340562A1 (en) | Systems and method for project management portal | |
| US8335756B2 (en) | Software for facet classification and information management | |
| CN111858615A (en) | Database table generation method, system, computer system and readable storage medium | |
| US9195841B2 (en) | Automated and delegated model-based row level security | |
| US20210152559A1 (en) | Hierarchical case model access roles and permissions | |
| US20200387802A1 (en) | Dynamically adaptable rules and communication system for managing process controls | |
| US7693185B1 (en) | Method and apparatus for creation and management of intelligent packets | |
| US20150228032A1 (en) | Meta-model for monitoring payroll processes across a network | |
| US10650353B2 (en) | Context oriented assessment for travel companionship | |
| CN112365220A (en) | Informationized dynamic supervision platform | |
| US20220366337A1 (en) | Machine learning platform for real time occupancy forecasting and resource planning | |
| US9411836B2 (en) | Facilitating consistency between a glossary and a repository | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| US11632375B2 (en) | Autonomous data source discovery | |
| CN111143322A (en) | Data standard treatment system and method |
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 |