CN116910036B - Construction method of multisource forest soil attribute database - Google Patents

Construction method of multisource forest soil attribute database Download PDF

Info

Publication number
CN116910036B
CN116910036B CN202311161508.5A CN202311161508A CN116910036B CN 116910036 B CN116910036 B CN 116910036B CN 202311161508 A CN202311161508 A CN 202311161508A CN 116910036 B CN116910036 B CN 116910036B
Authority
CN
China
Prior art keywords
data
database
soil
forest
information
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.)
Active
Application number
CN202311161508.5A
Other languages
Chinese (zh)
Other versions
CN116910036A (en
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.)
Institute Of Forest Ecological Environment And Nature Conservation Chinese Academy Of Forestry World Natural Heritage Conservation Research Center State Forestry And Grassland Administration
Original Assignee
Institute Of Forest Ecological Environment And Nature Conservation Chinese Academy Of Forestry World Natural Heritage Conservation Research Center State Forestry And Grassland Administration
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 Institute Of Forest Ecological Environment And Nature Conservation Chinese Academy Of Forestry World Natural Heritage Conservation Research Center State Forestry And Grassland Administration filed Critical Institute Of Forest Ecological Environment And Nature Conservation Chinese Academy Of Forestry World Natural Heritage Conservation Research Center State Forestry And Grassland Administration
Priority to CN202311161508.5A priority Critical patent/CN116910036B/en
Publication of CN116910036A publication Critical patent/CN116910036A/en
Application granted granted Critical
Publication of CN116910036B publication Critical patent/CN116910036B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1448Management of the data involved in backup or backup restore
    • G06F11/1451Management of the data involved in backup or backup restore by selection of backup contents
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/215Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2365Ensuring data consistency and integrity
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24552Database cache management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/254Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Computational Linguistics (AREA)
  • Computer Security & Cryptography (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention relates to the technical field of soil ecology, in particular to a construction method of a multisource forest soil attribute database, which comprises data storage, data verification, data operation data backup and log management; the data storage comprises two types of structured data and unstructured data, the structured data is stored in a database, the unstructured data is stored in a file system, metadata in the file system is also stored in the database, the data verification is that the data are preprocessed and verified before data are put in storage, the data operation comprises data addition, data modification, data query and data deletion, and the data backup adopts a corresponding backup mode for the data from different sources.

Description

Construction method of multisource forest soil attribute database
Technical Field
The invention relates to the technical field of soil ecology, in particular to a construction method of a multisource forest soil attribute database.
Background
Forest soil is one of the most important components of a forest ecological system, and forest soil resources in China are rich and various, so that the forest soil has obvious horizontal and vertical zonal distribution patterns. The process for acquiring the forest soil data is complex, the cost is high, and the current situation that the forest soil data is multi-source and heterogeneous and difficult to manage and apply is caused.
The traditional forest attribute database generally does not contain soil attribute data, and the soil attribute database also does not contain forest attribute information, so that the forest attribute information and the soil attribute information exist as two independent bodies, and the existing work does not interconnect the two information, therefore,
1. when in storage, in order to enable information to be matched, two databases are required to store corresponding identification information, redundancy is increased, and meanwhile storage and maintenance cost is increased;
2. in maintenance, in order to update one piece of data, two databases may need to be operated simultaneously, so that data consistency is difficult to ensure, and particularly when a plurality of tasks are performed simultaneously, the difficulty is higher;
3. in use, to query a piece of data, it is necessary to span two databases and then merge the data, which is inefficient.
Based on the reasons, the invention designs a construction method of the multi-source forest soil attribute database, which is characterized in that the forest soil unit data standard is formulated after the historical observation data, the literature data and the sample plot investigation data are fully collected, integrated and utilized, and the multi-source forest soil attribute database is constructed, so that the forest soil attribute related data in various formats can be efficiently managed at the same time.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provide a construction method of a multi-source forest soil attribute database, which is used for formulating forest soil unit data standards and constructing the multi-source forest soil attribute database by fully collecting, integrating and utilizing historical observation data, literature data and sample plot investigation data, so that forest soil attribute related data in various formats can be efficiently managed at the same time.
In order to achieve the above purpose, the invention provides a construction method of a multisource forest soil attribute database, which comprises data storage, data verification, data operation, data backup and log management;
the data storage comprises two types of structured data and unstructured data, the structured data is stored in a database, the unstructured data is stored in a file system, and metadata in the file system is also stored in the database;
the data verification comprises a verification and validation step before the data is put into a database, and the data is preprocessed and verified to ensure the correctness, the reliability and the consistency of the data, and the method comprises the following steps:
s1, verifying whether data accords with a specification by utilizing a rule defined by the data;
s2, detecting data to be put in storage by using historical observation data, if the data fall within a reasonable numerical range of the data, the data are regarded as effective data, otherwise, users are prompted that abnormal values possibly exist in the data;
the data operation comprises data addition, data deletion, data modification and data query, and in order to efficiently manage data, the database system uses a unified SQL language for inquiring, the SQL language supports data analysis and geographic information inquiry, and when the object of the data operation is file data, the operation is performed in a mode of only adding and deleting, so that history information can be conveniently recorded;
the data backup adopts a corresponding backup mode for data from different sources, and specifically comprises the following steps:
for the structured data, backtracking the data by adopting a backup log mode, and merging database data in the backup log, so that the database is convenient to recover;
and for the file data, backing up the newly added file.
The data in the data store includes image data, vector data, raster data, and text data.
And carrying out standardized preprocessing on data with multiple formats before data verification.
The data query uses SQL language to query geographic information, and queries statistical operation information and display information.
Compared with the prior art, the method combines the forest attribute information and the forest soil attribute information, and the connected information is uniformly managed, so that the method has the following beneficial effects:
in the same database, the forest attribute database is expanded to increase the soil attribute information, the information format is uniform, irrelevant data fields are removed, the incremental backup technology is adopted for subsequent maintenance, the storage cost is reduced, and the information redundancy is eliminated;
the invention aims at the database containing forest attribute and forest soil attribute information at the same time, combines the existing data processing technology, ensures that dirty data cannot be generated when abnormal operation occurs to different data tables due to data content during deletion or modification, and ensures the consistency of the data;
in the same database, the common data table can be cached by utilizing the techniques of database index, view and the like, so that multiple format data can be extracted at a time, and the query performance and the processing efficiency are improved.
Drawings
FIG. 1 is a schematic diagram of the overall architecture of the present invention.
Fig. 2 is a schematic diagram of an embodiment of the architecture of the present invention.
Detailed Description
The invention will now be further described with reference to the accompanying drawings.
Referring to fig. 1-2, the invention provides a construction method of a multisource forest soil attribute database, which comprises data storage, data verification, data operation, data backup and log management;
the data storage comprises two types of structured data and unstructured data, the structured data is stored in a database, the unstructured data is stored in a file system, and metadata in the file system is also stored in the database;
the data verification comprises a verification and validation step before the data is put into a database, and the data is preprocessed and verified to ensure the correctness, the reliability and the consistency of the data, and the method comprises the following steps:
s1, verifying whether data accords with a specification by utilizing a rule defined by the data;
s2, detecting data to be put in storage by using historical observation data, if the data fall within a reasonable numerical range of the data, the data are regarded as effective data, otherwise, users are prompted that abnormal values possibly exist in the data;
the data operation comprises data addition, data modification, data query and data deletion, and in order to efficiently manage data, the database system uses unified SQL language for query, the SQL language supports data analysis and geographic information query, and when the object of the data operation is file data, the operation is performed in a mode of only adding and deleting, so that history information can be conveniently recorded;
the data backup adopts a corresponding backup mode for data from different sources, and specifically comprises the following steps:
for the structured data, backtracking the data by adopting a backup log mode, and merging database data in the backup log, so that the database is convenient to recover;
for file data, a newly added file is backed up.
The data in the data store includes image data, vector data, raster data, and text data.
And carrying out standardized preprocessing on data with multiple formats before data verification.
The data query uses SQL language to query geographic information, and queries statistical operation information and display information.
The invention manages heterogeneous data sources, integrates the heterogeneous data sources, uses a unified space query language to query and use the heterogeneous data, uses different incremental backup methods to backup the heterogeneous data, and reduces the storage space.
The parameters of the database table of the present invention are defined as follows:
chinese name English name Definition of the definition Data type
Coding of a pattern in a region Region_ID Coding of a pattern in a region Text of
Coding of the province of the plot Province_ID Coding of the province of the plot Text of
Sample site name Plot Name Sample site name Text of
Sample position Location Sample position Text of
Digital elevation of the region where the sample is located Digital Elevation Model High precision DEM in a sample plot Grid structure
Longitude and latitude X Longitude of soil sampling point of sample plot Vector quantity
Latitude of latitude Y Latitude of soil sampling point of sample plot Vector quantity
Elevation of the sea Elevation Elevation of soil sampling point of sample plot Vector quantity
Topography of the ground Topography Topography of soil sampling point of sample plot Vector quantity
Gradient of slope Slope Slope of soil sampling point of sample plot Vector quantity
Slope direction_1 Aspect_1 Slope direction of soil sampling point of sample plot, language description Vector quantity
Slope direction_2 Aspect_2 Slope direction of soil sampling point of sample land and digital expression Vector quantity
Soil type Soil Type Soil type of soil sampling point of sample plot Text of
Soil general category Soil Group Soil general class of soil sampling points of sample lands Text of
Soil porosity Soil Porosity Soil porosity of soil sampling points of sample plot Text of
Soil texture Soil Texture Soil texture of soil sampling points of sample lands Text of
Sandy soil Sand Soil sandiness soil content percentage of soil sampling point of sample land Text of
Clay Clay Soil clay content percentage of soil sampling point of sample plot Text of
Loam soil Silt Soil loam content percentage of soil sampling points of sample land Text of
Upper bound of single soil layer Upper Depth Soil single soil layer upper bound of soil sampling point of sample area Text of
Soil single soil layer lower boundary Lower Depth Soil single soil layer lower bound of soil sampling point of sample land Text of
Depth of soil Soil Depths Soil depth of soil sampling point of sample plot Text of
Earth-forming matrix Parent Material Soil forming matrix of soil sampling point of sample land Vector quantity
Mineral ratio of matrix clay Clay Mineral Ratio Clay mineral ratio in soil-forming matrix of soil sampling point of sample plot Vector quantity
Type of soil erosion Soil Erosion Type Soil erosion type of soil sampling points of a sample plot Vector quantity
Soil erosion degree Soil Erosion Intensity Soil erosion degree of soil sampling point of sample plot Vector quantity
Forest origin Forest origin Forest origin of sample plot Text of
Forest type Forest Type Pattern forest type, pure forest or mixed forest Text of
Forest structure Forest Structure Forest structure of sample plot and space structure Text of
Abundance of tree species in forest stand Species Richness Forest stand number of various trees in unit area Text of
High diameter of forest stand chest Stand DBH Height diameter of forest stand horizontal chest Text of
Age of forest stand Stand Age Average age of dominant tree species in forest Text of
Height of stand tree Tree Height Average tree height of stand level Text of
Stand photo Photographs Real photo in forest stand, in-forest and under-forest Image processing apparatus
Soil density of sample plot Bulk Density of sites Layered soil Density in sample plot Text of
Soil organic carbon content of sample plot Soil Organic Carbon Content of sites Organic carbon content of layered soil in sample plot Text of
Forest sample soil pH value pH of sites Layered soil pH value in sample field Text of
Soil total nitrogen of forest sample land Total Nitrogen of sites (TN) Layering soil total nitrogen in sample land Text of
Forest sample soil total phosphorus Total Phosphorous of sites (TP) Stratified soil total phosphorus in sample field Text of
Soil potassium for forest sample land Total Potassium of sites (TK) Layered soil total potassium in sample field Text of
Quick-acting nitrogen for forest sample soil Available Nitrogen of sites (AN) Quick-acting nitrogen for layered soil in sample field Text of
Quick-acting phosphorus for forest sample soil Available Phosphorous of sites (AP) Quick-acting phosphorus in soil stratified in sample field Text of
Quick-acting potassium for forest soil Available Potassium of sites (AK) Quick-acting potassium for layered soil in sample field Text of
Regional forest soil density Bulk Density of regions (BD) Regional layered soil density profile Grid structure
Organic carbon content of regional forest soil Soil Organic Carbon Content of regions Regional layered soil organic carbon content profile Grid structure
Regional forest soil pH value pH of regions Regional layered soil ph profile Grid structure
Regional forest soil total nitrogen Total Nitrogen of regions Regional stratified soil total nitrogen distribution map Grid structure
Regional forest soil total phosphorus Total Phosphorous of regions Regional stratified soil total phosphorus distribution map Grid structure
Regional forest soil total potassium Total Potassium of regions Regional stratified soil total potassium distribution map Grid structure
Quick-acting nitrogen for regional forest soil Available Nitrogen of regions Regional stratified soil quick-acting nitrogen distribution map Grid structure
Quick-acting phosphorus for regional forest soil Available Phosphorous of regions Regional layered soil quick-acting phosphorus distribution map Grid structure
Quick-acting potassium for regional forest soil Available Potassium of regions Regional layered soil quick-acting potassium distribution map Grid structure
The foregoing is a preferred embodiment of the present invention, which is only used to help understand the method and core idea of the present application, and the protection scope of the present invention is not limited to the foregoing embodiments, and all technical solutions belonging to the concept of the present invention belong to the protection scope of the present invention. It should be noted that modifications and adaptations to the present invention may occur to one skilled in the art without departing from the principles of the present invention and are intended to be within the scope of the present invention.
The method solves the important problems of high storage and maintenance cost, incapability of ensuring data consistency, low efficiency and the like caused by not linking the soil attribute database with the forest attribute information in the prior art on the whole, and greatly improves the management efficiency compared with the traditional database by fully collecting, integrating and utilizing historical observation data, literature data and sample plot survey data, formulating forest soil unit data standard and constructing a multisource forest soil attribute database, supporting forest survey data, sample basic information data, forest soil attribute data, forest and under-forest soil picture data and forest soil drawing result data, connecting all relevant data of forest soil attributes, supporting management and query of various types of data and supporting grid map data query.

Claims (4)

1. The construction method of the multisource forest soil attribute database is characterized by comprising data storage, data verification, data operation, data backup and log management;
the data storage comprises two types of structured data and unstructured data, wherein the structured data is stored in a database, the unstructured data is stored in a file system, and metadata in the file system is also stored in the database;
the data verification comprises a verification and confirmation step before the data is put into a database, and the data is preprocessed and verified to ensure the correctness, the reliability and the consistency of the data, and the data can be put into a warehouse when meeting the conditions, and the method comprises the following steps:
s1, verifying whether data accords with a specification by utilizing a rule defined by the data;
s2, detecting data to be put in storage by using historical observation data, if the data fall within a reasonable numerical range of the historical observation data, the data are regarded as effective data, otherwise, users are prompted that abnormal values possibly exist in the data;
the data operation comprises data addition, data deletion, data modification and data query, and in order to efficiently manage data, the database system uses a unified SQL language for supporting data analysis and geographic information query, and when the object of the data operation is file data, the operation is performed in a mode of only adding and deleting, so that history information can be conveniently recorded;
the data backup adopts a corresponding backup mode for data from different sources, and specifically comprises the following steps:
for the structured data, backtracking the data by adopting a backup log mode, and merging database data in the backup log, so that the database is convenient to recover;
for the file data, backing up the newly added file;
the data storage is specifically to combine forest attribute information and forest soil attribute information into the same database, unify information formats, remove irrelevant data fields and uniformly manage the connected information;
and caching the common data table in the same database by utilizing the database index and the view, and extracting data in multiple formats at a time.
2. A method of constructing a multi-source forest soil property database according to claim 1, wherein the data in the data store comprises image data, vector data, raster data and text data.
3. A method of constructing a multisource forest soil property database according to claim 1, wherein the data is subjected to standardized pre-processing prior to verification of data in a plurality of formats.
4. The method for constructing a multi-source forest soil attribute database according to claim 1, wherein the data query uses SQL language to query geographic information and to query statistical operation information and presentation information.
CN202311161508.5A 2023-09-11 2023-09-11 Construction method of multisource forest soil attribute database Active CN116910036B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311161508.5A CN116910036B (en) 2023-09-11 2023-09-11 Construction method of multisource forest soil attribute database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311161508.5A CN116910036B (en) 2023-09-11 2023-09-11 Construction method of multisource forest soil attribute database

Publications (2)

Publication Number Publication Date
CN116910036A CN116910036A (en) 2023-10-20
CN116910036B true CN116910036B (en) 2023-12-26

Family

ID=88356829

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311161508.5A Active CN116910036B (en) 2023-09-11 2023-09-11 Construction method of multisource forest soil attribute database

Country Status (1)

Country Link
CN (1) CN116910036B (en)

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111930723A (en) * 2020-09-25 2020-11-13 国网冀北电力有限公司经济技术研究院 Scientific and technological achievement data fusion method based on big data
WO2021107760A1 (en) * 2019-11-29 2021-06-03 Mimos Berhad System and method for dynamically processing data into a knowledge base repository

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2021107760A1 (en) * 2019-11-29 2021-06-03 Mimos Berhad System and method for dynamically processing data into a knowledge base repository
CN111930723A (en) * 2020-09-25 2020-11-13 国网冀北电力有限公司经济技术研究院 Scientific and technological achievement data fusion method based on big data

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
Digital Soil Mapping Based on Fine Temporal Resolution Landsat Data Produced by Spatiotemporal Fusion;Haoxuan Yang et al.;《IEEE Journal of Selected Topics in Applied Earth Observations and Remote Sensing》;第16卷;全文 *
基于混合架构的高校数据平台构建研究;张军 等;《当代教育实践与教学研究》;第一段,第一节至第三节 *

Also Published As

Publication number Publication date
CN116910036A (en) 2023-10-20

Similar Documents

Publication Publication Date Title
CN112270027B (en) Paperless intelligent interactive examination method for city design based on entity model
CN109783665B (en) Design method for realizing Hbase database remote sensing big data storage model based on Google S2
CN106547853B (en) Forestry big data construction method based on one graph
CN104700191A (en) Intelligent mobile terminal based agricultural product quality and safety geographic information supervision and management method and system
CN109635068A (en) Mass remote sensing data high-efficiency tissue and method for quickly retrieving under cloud computing environment
CN103049549A (en) Island data management method and system
CN109508363A (en) Water conservancy big data service platform and its working method based on GIS
CN113742505B (en) Mass synthetic aperture radar interferometry (InSAR) data online visualization method
CN116910036B (en) Construction method of multisource forest soil attribute database
Khatri et al. Supporting user-defined granularities in a spatiotemporal conceptual model
CN109189873A (en) A kind of Meteorological Services big data monitoring analysis system platform
CN109710814B (en) Multi-source remote sensing data filing processing method and device
CN112686468B (en) Public facility stability optimization method
CN105761313A (en) Method of setting up three-dimensional landform symbol model and electronic device
CN111858808A (en) Automatic evaluation method for topographic map characteristic ground object precision based on massive real measuring points
CN115269500B (en) Ecological environment data storage method, ecological environment data retrieval method and electronic equipment
Lemenkova Linking Data Between the Worksheets and GIS Databases for Effective Management of the Environmental Projects
CN115564908B (en) Three-dimensional modeling system for ground surface matrix layer
Chen et al. Organization and query of point clouds data based on SQL server spatial
YueShun et al. A study of spatial data mining architecture and technology
Li et al. Research of Fuzhou Historical Building Management Platform Based on Data Warehouse Technology
Yan et al. System for automatic generalization of topographic maps
Liu et al. The Research on Wetland Ecological Engineering Database Based on 3S Technology
CN114706930A (en) Traffic cell land area statistical method for various types based on AOI data and GeoHash algorithm
CN116644116A (en) Method for extracting site-level karst collapse risk evaluation factors

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant