CN111078750B - Data statistical method and device of project model and computer storage medium - Google Patents
Data statistical method and device of project model and computer storage medium Download PDFInfo
- Publication number
- CN111078750B CN111078750B CN201911199531.7A CN201911199531A CN111078750B CN 111078750 B CN111078750 B CN 111078750B CN 201911199531 A CN201911199531 A CN 201911199531A CN 111078750 B CN111078750 B CN 111078750B
- Authority
- CN
- China
- Prior art keywords
- data
- project
- model
- database
- item
- 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
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Fuzzy Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a data statistical method, a device and a computer storage medium of a project model, wherein the project model comprises a plurality of sub-items, and the data statistical method comprises the following steps: acquiring project data of a plurality of sub-project models of the same project model; uploading a plurality of project data to a database; and merging the plurality of project data by utilizing the database to obtain data information of the project model. By the method, the data information of the project model can be quickly acquired.
Description
Technical Field
The present invention relates to the field of model data statistics, and in particular, to a data statistics method and apparatus for a project model, and a computer storage medium.
Background
For an existing BIM project, for a plurality of sub-projects of a project, if data of the project needs to be counted, data of each sub-project needs to be independently exported to be a data table, then a table is manually created, and data of each data table is further summarized item by item on the basis of the created table, so that the whole work is complicated and errors are easy to make.
Disclosure of Invention
The invention provides a data statistics method and device of a project model and a computer storage medium, which aim to solve the problem of complex project data statistics in the prior art.
In order to solve the technical problems, the invention adopts a technical scheme that: a data statistics method of a project model is provided, the project model comprises a plurality of sub-items, and the data statistics method comprises the following steps: acquiring project data of a plurality of sub-project models of the same project model; uploading a plurality of the project data to a database; and merging the plurality of project data by utilizing the database to obtain the data information of the project model.
In order to solve the technical problem, the invention adopts another technical scheme that: providing a data statistics apparatus of a project model, wherein the data statistics apparatus of the project model comprises a processor and a memory; the memory has stored therein a computer program for execution by the processor to implement the steps of the method as claimed in any one of the above.
In order to solve the above technical problem, another technical solution of the present invention is to provide a computer storage medium, in which a computer program is stored, and the computer program implements the steps of the data statistical method of the project model when being executed.
Different from the prior art, the project data of a plurality of sub-project models of the same project model are acquired and uploaded to the database, and the database is utilized to merge the plurality of project data. And then the data information of the same project model can be rapidly acquired. The plurality of subitem models do not need to be compared and calculated one by one in an artificial mode, the statistical efficiency is greatly improved, and the statistical error is reduced.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a schematic flow chart diagram of a first embodiment of a data statistics method for a project model according to the present invention;
FIG. 2 is a schematic diagram of a first embodiment of a data statistics apparatus of the project model of the present invention;
FIG. 3 is a schematic structural diagram of an embodiment of a computer storage medium according to the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, belong to the protection scope of the present invention.
Referring to fig. 1 in detail, fig. 1 is a schematic flow chart of a first embodiment of a data statistical method for a project model according to the present invention.
And S11, acquiring the project data of a plurality of sub-project models of the same project model.
Project data of a plurality of sub-project models of the same project model are obtained.
In particular embodiments, in a BIM design, a project model may include multiple sub-project models, for example, the project model may be a cell model and the multiple sub-project models may be multiple buildings.
Specifically, the sub-item model may specifically include a plurality of components, and for the same project model, the plurality of sub-item models have certain interoperability, for example, the plurality of sub-item models all have similar or identical components.
The project data specifically includes component names of components in the sub-project model and parameter information, which may be, for example, quantity, cost, and the like. And the parameter information specifically includes parameter names and parameter values.
Specifically, taking the component as a prefabricated column as an example, for a certain subentry model, 6 prefabricated columns are included. The component names may be prefabricated columns, the parameter names may be numbers, and the parameter values may be 6. In other embodiments, the parameter name may be a cost, the parameter value may be an amount of money, and the like. That is, for one component, a variety of parameter information may be included.
Specifically, a plurality of sub-item models may be created based on the reference file, and since they belong to one project model, the plurality of sub-item models include the same or corresponding project numbers. Specifically, the item number of the item model may be directly used. The item data also includes an item number of the sub-item model corresponding to the item data.
And S12, uploading the plurality of item data to a database.
Uploading the plurality of project data to a database.
Specifically, it is necessary to upload a plurality of project data to the same database according to the project number.
In order to prevent confusion during uploading, the project data of the sub-project models of different project models are uploaded to the same database. The item numbers in the item data can be judged, and the item data with the same item numbers or corresponding item data are uploaded to the same database.
In an embodiment, a database may be preset, and the name of the database is consistent with the name of the project model. Specifically, when the project model is created, a database with the same name as the project model can be directly and automatically generated correspondingly.
Specifically, a plurality of data tables may be established in the database according to the project data, and one data table may correspond to one member of one sub-project model. Specifically, the naming of the data table can be named according to the name of the sub-item model and the name of the member. For example, for a prefabricated column in item A, the data sheet name may be the A-prefabricated column sheet.
In other embodiments, a data table may correspond to a type of component, so that components of the same type may be compared. Specifically, for preformed columns, there may be multiple dimensions, such as preformed column 300 x 400, preformed column 300 x 600, and preformed column 400 x 400, among others, but all of the same type of component, and thus may be stored in a table.
And S13, merging the plurality of project data by using the database to obtain data information of the project model.
And then merging the plurality of project data by using the database to obtain data information of the project model, specifically, merging the parameter information of the plurality of project data according to the component names. Specifically, for the project data of the multiple sub-project models, the parameter information with the same component name in the multiple project data is merged according to the component name in the project data, that is, the parameter values with the same parameter name are merged.
In a specific embodiment, data tables with the same corresponding components are merged, and the project data of different sub-project models are displayed in the tables. The method specifically comprises the names, the component names, the parameter names and the parameter values of the subitem models, and the parameter values after combination. Therefore, the merged data table can visually represent the parameter information of the member in each sub-item model and the data information of the whole project model.
In another embodiment, the merging may also be performed as follows:
after a plurality of items of data are acquired, a plurality of data tables corresponding to the component names are created in the database according to the first item of data, and then for other items of data, the item of data only needs to be merged into the data table created at the beginning.
In the above embodiment, the project data of a plurality of sub-project models of the same project model are obtained and uploaded to the database, and the database is used to merge the plurality of project data. And then the data information of the same project model can be rapidly acquired. The plurality of subitem models do not need to be compared and calculated one by one in an artificial mode, the statistical efficiency is greatly improved, and the statistical error is reduced.
Furthermore, the database is automatically established when the project model is established, and the project data of a plurality of sub-project models in the project model are imported into the database, so that the data information of the project model can be synchronously acquired.
In a specific embodiment, the data statistics method of the project model further includes sorting the merged project data according to a preset sorting rule.
In a specific embodiment, the data statistics method of the project model further includes binding and associating the database with the project model, so that when the project data of the sub-project model in the project model is modified, the database correspondingly modifies the project data and merges the modified project data.
Specifically, a binding association is made between the database and the project model. Therefore, when the sub item model in the item model is modified, namely the item data of the sub item model is modified, the database can correspondingly modify the item data, and the modified item data are combined, namely the database and the item model are synchronously modified.
In a specific embodiment, each data table in the database may be bound to a component in the project model, and when a component is modified, the data table corresponding to the component is modified and updated, and other data tables do not need to be modified or re-imported, so that data information of the modified project model can be obtained very quickly. And furthermore, which parameter information in the component is modified can be judged, and the parameter information in the data table is modified correspondingly.
Compared with the prior art that after the project model is modified, the modified project data needs to be obtained again, and all the project data need to be rearranged manually to obtain the data information of the modified project model, the method only needs to obtain the modified project data again, modifies and updates the data table according to the modified project data, does not need to re-import the whole database, and greatly shortens the statistical time.
In a specific embodiment, the database may be backed up before the database correspondingly modifies the project data and merges the modified project data. That is, when the database needs to be updated and modified, the database needs to be backed up in advance, so that data loss can be prevented on one hand, and the modification process can be recorded on the other hand.
The data statistical method of the project model is generally realized by a data statistical device of the project model, so the invention also provides a data statistical device of the project model. Referring to fig. 2, fig. 2 is a schematic structural diagram of a data statistics apparatus of a project model according to an embodiment of the present invention. The data statistics apparatus 100 of the project model of the present embodiment includes a processor 12 and a memory 11; the memory 11 stores a computer program, and the processor 12 is used for executing the computer program to realize the steps of the data statistical method of the project model.
The logical processes of the data statistical method of the project model described above are presented as a computer program, which can be stored in a computer storage medium if it is sold or used as a stand-alone software product, and thus the present invention proposes a computer storage medium. Referring to fig. 3, fig. 3 is a schematic structural diagram of an embodiment of a computer storage medium, in which a computer program 21 is stored in a computer storage medium 200 of the embodiment, and the computer program is executed by a processor to implement the distribution network method or the control method.
The computer storage medium 200 may be a medium that can store a computer program, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, or may be a server that stores the computer program, and the server may send the stored computer program to another device for running or may run the stored computer program by itself. The computer storage medium 200 may be a combination of a plurality of entities from a physical point of view, for example, a plurality of servers, a server plus a memory, or a memory plus a removable hard disk.
In summary, the present invention provides a data statistics method and apparatus for project model, and a computer storage medium. The project data of a plurality of sub-project models of the same project model are obtained and uploaded to a database, and the database is utilized to combine the project data. And then the data information of the same project model can be rapidly acquired. The plurality of subitem models do not need to be compared and calculated one by one in an artificial mode, the statistical efficiency is greatly improved, and the statistical error is reduced. Furthermore, the database is automatically established when the project model is established, and the project data of a plurality of sub-project models in the project model are imported into the database, so that the data information of the project model can be synchronously acquired. Compared with the prior art that after the project model is modified, the modified project data needs to be obtained again, and all the project data needs to be rearranged manually to obtain the data information of the modified project model, the method only needs to obtain the modified project data again, modifies and updates the data table according to the modified project data, does not need to re-import the whole database, and greatly shortens the statistical time.
The above description is only an embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes performed by the present specification and drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (8)
1. A method of statistics of a project model, wherein the project model comprises a plurality of sub-items, the method comprising:
acquiring project data of a plurality of sub-project models of the same project model;
uploading a plurality of the project data to a database, wherein the project data comprises a first project data, and the first project data comprises a component name;
creating a plurality of data tables corresponding to the component names in the database according to the first project data;
merging the plurality of project data by using the data table corresponding to the component name to obtain data information of the project model;
wherein, the data statistical method further comprises:
binding and associating the database with the project model, so that when the project data of the sub-project model in the project model is modified, the database correspondingly modifies the project data and merges the modified project data;
wherein, the database correspondingly modifies the project data and also comprises the following steps before merging the modified project data:
and backing up the database.
2. The method of claim 1, wherein the sub-item models include the same or corresponding item numbers, and the item data includes the item numbers of the sub-item models corresponding to the item data.
3. The data statistics method of claim 2, wherein the step of uploading a plurality of the project data into a database comprises:
and uploading the plurality of item data to the same database according to the item numbers.
4. The method of claim 1, wherein the sub-item model comprises a plurality of components, the project data comprises component names and parameter information of the components, and the step of merging the plurality of project data with the database comprises:
and merging the parameter information of the plurality of item data according to the component names.
5. The data statistics method of claim 1, further comprising:
and sequencing the merged project data according to a preset sequencing rule.
6. The data statistics method of claim 1, wherein the name of the database is consistent with the name of the project model.
7. A data statistics apparatus of a project model, characterized in that the data statistics apparatus of the project model comprises a processor and a memory; the memory has stored therein a computer program for execution by the processor to implement the steps of the method according to any one of claims 1-6.
8. A computer storage medium, characterized in that it stores a computer program which, when executed, implements the steps of the method according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911199531.7A CN111078750B (en) | 2019-11-29 | 2019-11-29 | Data statistical method and device of project model and computer storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911199531.7A CN111078750B (en) | 2019-11-29 | 2019-11-29 | Data statistical method and device of project model and computer storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111078750A CN111078750A (en) | 2020-04-28 |
| CN111078750B true CN111078750B (en) | 2023-03-10 |
Family
ID=70312052
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911199531.7A Active CN111078750B (en) | 2019-11-29 | 2019-11-29 | Data statistical method and device of project model and computer storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111078750B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111930742B (en) * | 2020-07-23 | 2023-08-25 | 深圳市万翼数字技术有限公司 | Building information model BIM-based data storage method and related device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107301527A (en) * | 2017-04-17 | 2017-10-27 | 昆明理工大学 | A kind of engineering project subitem method that quickly can precisely evaluate again |
| CN107464284A (en) * | 2017-08-26 | 2017-12-12 | 济南万维数字传媒有限公司 | Three-dimensional visualization property information management system based on mobile terminal |
| CN108959694A (en) * | 2018-05-17 | 2018-12-07 | 青岛理工大学 | A kind of BIM geometrical model construction method of big scale of construction complex building |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11256833B2 (en) * | 2017-05-05 | 2022-02-22 | Nucor Corporation | System for on-site tracking, managing, planning and staging construction projects |
-
2019
- 2019-11-29 CN CN201911199531.7A patent/CN111078750B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107301527A (en) * | 2017-04-17 | 2017-10-27 | 昆明理工大学 | A kind of engineering project subitem method that quickly can precisely evaluate again |
| CN107464284A (en) * | 2017-08-26 | 2017-12-12 | 济南万维数字传媒有限公司 | Three-dimensional visualization property information management system based on mobile terminal |
| CN108959694A (en) * | 2018-05-17 | 2018-12-07 | 青岛理工大学 | A kind of BIM geometrical model construction method of big scale of construction complex building |
Non-Patent Citations (1)
| Title |
|---|
| BIM技术在铁路"四电"工程项目管理中的应用;杨建伟;《铁道经济研究》;20181210(第06期);第23-25页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111078750A (en) | 2020-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2017167065A1 (en) | Page resource delivery method and apparatus | |
| EP1862956A1 (en) | Systems and methods for assignment generation in a value flow environment | |
| US9182963B2 (en) | Computerized migration tool and method | |
| WO2017070533A1 (en) | System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment | |
| CN109684211B (en) | Order scheduling system pressure testing method and device based on shop dimensions | |
| CN110728123A (en) | Report generation method, system and related equipment | |
| CN110209714A (en) | Report form generation method, device, computer equipment and computer readable storage medium | |
| CN111078750B (en) | Data statistical method and device of project model and computer storage medium | |
| CN107798120B (en) | Data conversion method and device | |
| CN111190814B (en) | Method and device for generating software test case, storage medium and terminal | |
| CN106372160A (en) | Distributive database and management method | |
| CN108182204A (en) | The processing method and processing device of data query based on house prosperity transaction multi-dimensional data | |
| CN111984882A (en) | Data processing method, system and equipment | |
| CN110362540B (en) | Data storage and visitor number acquisition method and device | |
| CN112732242A (en) | Wide table processing script generation method and device | |
| CN115130959B (en) | Method, system, terminal and storage medium for generating spare part BOM | |
| CN116089518A (en) | Data model extraction method and system, terminal and medium | |
| CN111221517A (en) | Model creating method and device, computer equipment and readable storage medium | |
| CN115268863A (en) | Low-code platform data description method, equipment and medium | |
| CN109992573B (en) | Method and system for realizing automatic monitoring of HDFS file occupancy rate | |
| CN111813880B (en) | Homeland space planning project management method, system and storage medium | |
| CN114239095A (en) | Method and device for generating product customization module, electronic equipment and storage medium | |
| CN111966688A (en) | Form processing method and device based on big data and storage medium | |
| CN112862399A (en) | Method, device and equipment for changing material list table and storage medium | |
| CN111949743A (en) | Method, device and equipment for acquiring network operation data |
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 |