The invention provides an automatic material identification and matching method and
system for a three-dimensional model and a medium, and relates to the technical field of material management, and the method comprises the steps: constructing a standardized material
database, and extracting and standardizing material attribute information; analyzing first
material description information in the three-dimensional
software model by utilizing an
SQL (Structured
Query Language), and matching the first
material description information with the material attribute information to obtain a first material matching result; extracting second
material description information in the project material document by using VBA
programming, and matching the second material description information with the material attribute information to obtain a second material matching result; and
data integration is carried out through PowerBI, and a project material state visual billboard is constructed. The technical problems that in the prior art, a unified standardized material
database is lacked, material description formats in different sources are inconsistent, expression is not standard, a construction material
list cannot be accurately generated, and
informatization and intellectualization of project material management are limited are solved.