CN112948427A - Data query method, device, equipment and storage medium - Google Patents

Data query method, device, equipment and storage medium Download PDF

Info

Publication number
CN112948427A
CN112948427A CN202110408315.XA CN202110408315A CN112948427A CN 112948427 A CN112948427 A CN 112948427A CN 202110408315 A CN202110408315 A CN 202110408315A CN 112948427 A CN112948427 A CN 112948427A
Authority
CN
China
Prior art keywords
attribute
engineering
information
data query
data
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.)
Granted
Application number
CN202110408315.XA
Other languages
Chinese (zh)
Other versions
CN112948427B (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.)
Shenzhen Saiante Technology Service Co Ltd
Original Assignee
Ping An International Smart City Technology Co Ltd
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 Ping An International Smart City Technology Co Ltd filed Critical Ping An International Smart City Technology Co Ltd
Priority to CN202110408315.XA priority Critical patent/CN112948427B/en
Publication of CN112948427A publication Critical patent/CN112948427A/en
Application granted granted Critical
Publication of CN112948427B publication Critical patent/CN112948427B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

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/24Querying
    • G06F16/245Query processing
    • 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/22Indexing; Data structures therefor; Storage structures
    • G06F16/2228Indexing structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/10Geometric CAD
    • G06F30/13Architectural design, e.g. computer-aided architectural design [CAAD] related to design of buildings, bridges, landscapes, production plants or roads

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Geometry (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Computational Mathematics (AREA)
  • Civil Engineering (AREA)
  • Computational Linguistics (AREA)
  • Structural Engineering (AREA)
  • Architecture (AREA)
  • Mathematical Analysis (AREA)
  • Mathematical Optimization (AREA)
  • Pure & Applied Mathematics (AREA)
  • Evolutionary Computation (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to a data processing technology, and discloses a data query method, which comprises the following steps: the method comprises the steps of carrying out identification analysis on an engineering source file set to obtain an engineering identification, carrying out data separation on the engineering source file set by using the engineering identification to obtain attribute information and geometric information, carrying out attribute storage on the attribute information to obtain an attribute storage table, constructing a database cluster by using the attribute storage table, storing the geometric information to a pre-constructed object database, packaging the object database and the database cluster by using a preset service layer to obtain a query service layer, obtaining data query information, and analyzing the data query information by using the query service layer to obtain a data query result. In addition, the invention also relates to a block chain technology, and the data query result can be stored in a node of the block chain. The invention also provides a data inquiry device, an electronic device and a computer readable storage medium. The invention can solve the problem of low data query efficiency.

Description

Data query method, device, equipment and storage medium
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data query method and apparatus, an electronic device, and a computer-readable storage medium.
Background
The Building Information Model (BIM) Information base aims at the management of the whole life cycle of a Building, emphasizes the utilization of a digital technology and provides a complete Building engineering Information base for the Building model. The information base contains not only geometric information describing the building element, but also professional attributes of the element and spatial status information associated with the building element. The BIM digital-analog separation system is an important technology and tool in a BIM information base, and separates and independently manages geometric information of a building model and other professional attribute data according to data characteristics.
At present, the following challenges and problems exist in the management of BIM professional attribute data by the conventional BIM platform system: 1. with the continuous development of building engineering, building models are more and more complex, and component attributes are more and more huge. At present, the number of millions of components is large in a project building model, each component has dozens of attribute data, and a BIM platform needs to store and manage massive professional attribute data, so that the storage space is greatly occupied. 2. In the traditional BIM platform, the association between model data and professional attribute data is only bound by the service Id of a component, and the association and query based on the spatial relationship cannot be flexibly and efficiently realized, so that the data query efficiency is low.
Disclosure of Invention
The invention provides a data query method, a data query device and a computer readable storage medium, and mainly aims to solve the problem of low data query efficiency.
In order to achieve the above object, the present invention provides a data query method, including:
acquiring an engineering source file set, and performing identification analysis on the engineering source file set to obtain an engineering identification;
performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information;
performing attribute storage on the attribute information to obtain an attribute storage table, and constructing a database cluster by using the attribute storage table;
storing the geometric information to a pre-constructed object database, and packaging the object database and the database cluster by using a preset service layer to obtain a query service layer;
and acquiring data query information, and analyzing the data query information by using the query service layer to obtain a data query result.
Optionally, the performing identifier resolution on the engineering source file to obtain an engineering identifier includes:
analyzing each engineering source file in the engineering source file set in sequence by using a pre-constructed engineering management platform to obtain a unique identifier of each engineering source file;
and taking the unique identifier as the engineering identifier of the corresponding engineering source file.
Optionally, the performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information includes:
identifying the engineering identification by using a digital-analog separation module in the engineering management platform;
and carrying out data and model separation on the source files with the same engineering identification to obtain attribute information of the component and geometric information of the component.
Optionally, the attribute storing the attribute information to obtain an attribute storage table includes:
acquiring a preset attribute extraction field;
extracting the attributes of the components with the same engineering identification by using the attribute extraction field to obtain the attributes of the components, wherein the attributes of the components comprise the spatial attributes of the components;
and performing sub-table storage on the constructed attributes to obtain the attribute storage table.
Optionally, the performing table-splitting storage on the constructed attributes to obtain the attribute storage table includes:
performing character conversion on the engineering identification to obtain a sub-table ID;
and based on the sub-table ID, performing sub-table storage on the constructed attributes with the same engineering identification to obtain the attribute storage table.
Optionally, the constructing a database cluster by using the attribute storage table includes:
storing the attribute storage table in a pre-constructed cluster main node and a pre-constructed standby node;
and summarizing the cluster main node, the standby nodes and the pre-constructed arbitration nodes to obtain the database cluster.
Optionally, the obtaining data query information, and analyzing the data query information by using the query service layer to obtain a data query result includes:
acquiring data query information, wherein the data query information comprises an attribute index, a spatial index and a geometric index;
calling an attribute query interface and a geometric query interface of the query service layer;
analyzing the attribute index and the spatial index by using the attribute query interface to obtain attribute information, wherein the attribute information comprises a component spatial attribute, and analyzing the geometric index by using the geometric query interface to obtain geometric information;
and summarizing the geometric information and the attribute information to obtain the data query result.
In order to solve the above problem, the present invention also provides a data query apparatus, including:
the identification analysis module is used for acquiring an engineering source file set and carrying out identification analysis on the engineering source file set to obtain an engineering identification;
the data separation module is used for performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information;
the attribute storage module is used for performing attribute storage on the attribute information to obtain an attribute storage table, and constructing a database cluster by using the attribute storage table;
the data encapsulation module is used for storing the geometric information to a pre-constructed object database, and encapsulating the object database and the database cluster by using a preset service layer to obtain an inquiry service layer;
and the data query module is used for acquiring data query information, and analyzing the data query information by using the query service layer to obtain a data query result.
In order to solve the above problem, the present invention also provides an electronic device, including:
a memory storing at least one instruction; and
and the processor executes the instructions stored in the memory to realize the data query method.
In order to solve the above problem, the present invention further provides a computer-readable storage medium, which stores at least one instruction, where the at least one instruction is executed by a processor in an electronic device to implement the data query method described above.
According to the invention, the engineering source file set is identified and analyzed to obtain the engineering identifier, and the data separation is carried out on the engineering source file set by using the engineering identifier. And the obtained attribute information and the geometric information are stored separately, so that the occupation of storage space can be reduced. Meanwhile, the attribute information comprises the spatial attributes of the components, so that the obtained attribute storage table can efficiently and quickly inquire the spatial relationship. Therefore, the data query method, the data query device, the electronic equipment and the computer readable storage medium provided by the invention can solve the problem of low data query efficiency.
Drawings
Fig. 1 is a schematic flow chart of a data query method according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart showing a detailed implementation of one of the steps in FIG. 1;
FIG. 3 is a schematic flow chart showing another step of FIG. 1;
FIG. 4 is a schematic flow chart showing another step of FIG. 1;
FIG. 5 is a schematic flow chart showing another step in FIG. 1;
FIG. 6 is a functional block diagram of a data query device according to an embodiment of the present invention;
fig. 7 is a schematic structural diagram of an electronic device for implementing the data query method according to an embodiment of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The embodiment of the application provides a data query method. The execution subject of the data query method includes, but is not limited to, at least one of electronic devices such as a server and a terminal that can be configured to execute the method provided by the embodiments of the present application. In other words, the data query method may be performed by software or hardware installed in the terminal device or the server device, and the software may be a block chain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like.
Fig. 1 is a schematic flow chart of a data query method according to an embodiment of the present invention. In this embodiment, the data query method includes:
s1, acquiring the engineering source file set, and performing identification analysis on the engineering source file set to obtain an engineering identification.
In the embodiment of the present invention, the engineering source file set may be a Building Information Model (BIM) source file set, which includes files of suffixes such as rvt, ifc, and the like. The building information model is a datamation tool applied to engineering design, construction and management, is shared and transmitted in the whole life cycle process of project planning, operation and maintenance by integrating the datamation and informatization models of buildings, and is characterized in that a complete building engineering information base consistent with the actual condition is provided for the model by establishing a virtual building engineering three-dimensional model and utilizing the digitization technology.
Specifically, referring to fig. 2, the performing identification analysis on the engineering source file set to obtain an engineering identifier includes:
s10, analyzing each engineering source file in the engineering source file set in sequence by using a pre-constructed engineering management platform to obtain a unique identifier of each engineering source file;
and S11, taking the unique identifier as the project identifier of the corresponding project source file.
In the embodiment of the present invention, the pre-constructed engineering management platform may be a Building Information Model (BIM) management platform, and the BIM management platform is configured to store a million-level BIM model, and store and manage massive Building components in the BIM model, professional attribute data of the Building components, spatial state Information of the Building components, and other data.
In an optional embodiment of the present invention, the unique identifier may be a GUID identifier of an item, because different BIM source files belong to different engineering items, each item has a globally unique GUID identifier, and using the unique identifier as an engineering identifier of a corresponding engineering source file can improve the efficiency and accuracy of data retrieval.
And S2, performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information.
In this embodiment of the present invention, the attribute information may be attribute information of a building component in a BIM source file, including: professional attribute information of the building component, space state information of the building component and the like. The geometric information may be geometric information of building components in a BIM source file, including: building models and building component models.
Specifically, referring to fig. 3, the performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information includes:
s20, identifying the project identification by using a digital-analog separation module in the project management platform;
and S21, performing data and model separation on the source files with the same engineering identification to obtain attribute information of the component and geometric information of the component.
In an optional embodiment of the present invention, the digital-analog separation module may be a BIM digital-analog separation system, which is an important technology and tool in a BIM management platform, and can separate and independently manage geometric information of a building model and professional attribute data of other building components according to data characteristics. The member refers to a building member constituting the BIM model, such as a wall, a door, a stair, a column, etc.
And S3, performing attribute storage on the attribute information to obtain an attribute storage table, and constructing a database cluster by using the attribute storage table.
In this embodiment of the present invention, referring to fig. 4, the performing attribute storage on the attribute information to obtain an attribute storage table includes:
s30, acquiring a preset attribute extraction field;
s31, extracting attributes of the components with the same engineering identification by using the attribute extraction field to obtain component attributes, wherein the component attributes comprise component space attributes;
and S32, performing sub-table storage on the constructed attributes to obtain the attribute storage table.
In an optional embodiment of the present invention, the database cluster may be a mongodb cluster. The preset attribute extraction field includes: projectGuid: the GUID is used for extracting the item to which the member belongs; modelGuid: a GUID used to extract a model to which the component belongs; elementId: id used to extract the component; elementType: for extracting component family types; properties: attribute array used to extract the building blocks, categoryName: class name used to extract attributes, categoryId: class Id to extract attributes, attributes: list of specific attribute values used to extract attributes, name: for extracting attribute names, value: used for extracting attribute values; loc is used for extracting the spatial position information of the member, and the type is extended GeoJSON, type: GeoJSON object type native to Mongo, coordinates: coordinate information of GeoJSON, z: the self-defined GeoJSON extended attribute is used for improving the spatial index of the Mongo so as to support the three-dimensional spatial index.
In the embodiment of the invention, the native GeoJSON of MongoDB only supports two-dimensional position information; extending it here adds the z component and creates a spatial index of the 2dsphere type on the loc field; while creating an ascending index on the loc.z field. In search, a spatial query statement and a z-component range query are combined, so that a component list and an attribute list in a specific spatial range can be efficiently screened.
Specifically, the performing table-splitting storage on the constructed attributes to obtain the attribute storage table includes:
performing character conversion on the engineering identification to obtain a sub-table ID;
and based on the sub-table ID, performing sub-table storage on the constructed attributes with the same engineering identification to obtain the attribute storage table.
In an optional embodiment of the present invention, the engineering identifier (i.e., projectGuid) may be converted into two 64-bit integers x and y, and then a preset formula f (x, y, n) ((x mod n) × (y mod n)) mod n is used, where n represents the number of the preset attribute storage tables.
In detail, the constructing a database cluster by using the attribute storage table includes:
storing the attribute storage table in a pre-constructed cluster main node and a pre-constructed standby node;
and summarizing the cluster main node, the standby nodes and the pre-constructed arbitration nodes to obtain the database cluster.
In an optional embodiment of the present invention, the database cluster may be a mongodb cluster, where the mongodb cluster includes: a main node (Mongodb (M)), a standby node (Mongodb (S)) and an arbitration node (Mongodb (A)). The main node and the standby node store data, the arbitration node does not store data, the main node provides all the services of increasing, deleting, checking and modifying under default setting, the standby node does not provide any service, but the standby node can provide the inquiry service through setting, so that the pressure of the main node can be reduced. The arbitration node is a special node which does not store data, and the main function of the arbitration node is to determine which standby node is promoted to be the master node after the master node is hung up.
In the embodiment of the invention, the attribute storage table stores the spatial information of the components, and the association and query based on the spatial relationship of the components can be flexibly and efficiently realized.
S4, storing the geometric information to a pre-constructed object database, and packaging the object database and the database cluster by using a preset service layer to obtain a query service layer.
In the embodiment of the present invention, the pre-constructed object database may be an object storage database AWS 3, and the AWS S3 may store data (geometric information) as an object, use an engineering identifier as a unique identifier of the object, and use the engineering identifier to implement object query.
In an optional embodiment of the present invention, the preset service layer may be an API layer, and the API layer may provide various attributes and component query interfaces according to service requirements.
And S5, acquiring data query information, and analyzing the data query information by using the query service layer to obtain a data query result.
Specifically, referring to fig. 5, the acquiring data query information and analyzing the data query information by using the query service layer to obtain a data query result includes:
s50, acquiring data query information, wherein the data query information comprises an attribute index, a spatial index and a geometric index;
s51, calling an attribute query interface and a geometric query interface of the query service layer;
s52, analyzing the attribute index and the spatial index by using the attribute query interface to obtain attribute information, wherein the attribute information comprises a component spatial attribute, and analyzing the geometric index by using the geometric query interface to obtain geometric information;
and S53, summarizing the geometric information and the attribute information to obtain the data query result.
In the embodiment of the present invention, for example, all attributes of all doors of a certain floor are queried, and a native $ geoWithIn query statement and loc.z component are combined in the query statement: { $ and { $ geoWithin { $ geometric: { type: "Polygon", associates [ [ [0,0], [10,0], [10,10], [0,10], [0,0] ] } } } }, { $ and { "loc.z" { $ 0} }, { $ loc.z "{ $ 3} } } } }, {" properties. elementType "{ $ eq:" Door "} }, where {. geWithIn is the native query statement of MongoDB, and loc.z denotes the spatial index.
In the embodiment of the invention, the spatial state information of the component is stored in the attribute storage table as an attribute (namely, the spatial attribute), and the spatial attribute is inquired through the spatial index, so that the inquiry of the three-dimensional data spatial information can be realized through the MongoDB two-dimensional spatial index, and the inquiry efficiency is greatly improved.
According to the invention, the engineering source file set is identified and analyzed to obtain the engineering identifier, and the data separation is carried out on the engineering source file set by using the engineering identifier. And the obtained attribute information and the geometric information are stored separately, so that the occupation of storage space can be reduced. Meanwhile, the attribute information comprises the spatial attributes of the components, so that the obtained attribute storage table can efficiently and quickly inquire the spatial relationship. Therefore, the embodiment of the invention can solve the problem of low data query efficiency.
Fig. 6 is a functional block diagram of a data query apparatus according to an embodiment of the present invention.
The data query apparatus 100 according to the present invention may be installed in an electronic device. According to the implemented functions, the data query apparatus 100 may include an identifier parsing module 101, a data separation module 102, an attribute storage module 103, a data encapsulation module 104, and a data query module 105. The module of the present invention, which may also be referred to as a unit, refers to a series of computer program segments that can be executed by a processor of an electronic device and that can perform a fixed function, and that are stored in a memory of the electronic device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
the identification analysis module 101 is configured to obtain an engineering source file set, and perform identification analysis on the engineering source file set to obtain an engineering identification.
In the embodiment of the present invention, the engineering source file set may be a Building Information Model (BIM) source file set, which includes files of suffixes such as rvt, ifc, and the like. The building information model is a datamation tool applied to engineering design, construction and management, is shared and transmitted in the whole life cycle process of project planning, operation and maintenance by integrating the datamation and informatization models of buildings, and is characterized in that a complete building engineering information base consistent with the actual condition is provided for the model by establishing a virtual building engineering three-dimensional model and utilizing the digitization technology.
Specifically, the identifier parsing module 101 obtains the engineering identifier by the following operations:
analyzing each engineering source file in the engineering source file set in sequence by using a pre-constructed engineering management platform to obtain a unique identifier of each engineering source file;
and taking the unique identifier as the engineering identifier of the corresponding engineering source file.
In the embodiment of the present invention, the pre-constructed engineering management platform may be a Building Information Model (BIM) management platform, and the BIM management platform is configured to store a million-level BIM model, and store and manage massive Building components in the BIM model, professional attribute data of the Building components, spatial state Information of the Building components, and other data.
In an optional embodiment of the present invention, the unique identifier may be a GUID identifier of an item, because different BIM source files belong to different engineering items, each item has a globally unique GUID identifier, and using the unique identifier as an engineering identifier of a corresponding engineering source file can improve the efficiency and accuracy of data retrieval.
The data separation module 102 is configured to perform data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information.
In this embodiment of the present invention, the attribute information may be attribute information of a building component in a BIM source file, including: professional attribute information of the building component, space state information of the building component and the like. The geometric information may be geometric information of building components in a BIM source file, including: building models and building component models.
Specifically, the data separation module 102 obtains the attribute information and the geometric information by:
identifying the engineering identification by using a digital-analog separation module in the engineering management platform;
and carrying out data and model separation on the source files with the same engineering identification to obtain attribute information of the component and geometric information of the component.
In an optional embodiment of the present invention, the digital-analog separation module may be a BIM digital-analog separation system, which is an important technology and tool in a BIM management platform, and can separate and independently manage geometric information of a building model and professional attribute data of other building components according to data characteristics. The member refers to a building member constituting the BIM model, such as a wall, a door, a stair, a column, etc.
The attribute storage module 103 is configured to perform attribute storage on the attribute information to obtain an attribute storage table, and construct a database cluster by using the attribute storage table.
In this embodiment of the present invention, the attribute storage module 103 obtains an attribute storage table by:
acquiring a preset attribute extraction field;
extracting the attributes of the components with the same engineering identification by using the attribute extraction field to obtain the attributes of the components, wherein the attributes of the components comprise the spatial attributes of the components;
and performing sub-table storage on the constructed attributes to obtain the attribute storage table.
In an optional embodiment of the present invention, the database cluster may be a mongodb cluster. The preset attribute extraction field includes: projectGuid: the GUID is used for extracting the item to which the member belongs; modelGuid: a GUID used to extract a model to which the component belongs; elementId: id used to extract the component; elementType: for extracting component family types; properties: attribute array used to extract the building blocks, categoryName: class name used to extract attributes, categoryId: class Id to extract attributes, attributes: list of specific attribute values used to extract attributes, name: for extracting attribute names, value: used for extracting attribute values; loc is used for extracting the spatial position information of the member, and the type is extended GeoJSON, type: GeoJSON object type native to Mongo, coordinates: coordinate information of GeoJSON, z: the self-defined GeoJSON extended attribute is used for improving the spatial index of the Mongo so as to support the three-dimensional spatial index.
In the embodiment of the invention, the native GeoJSON of MongoDB only supports two-dimensional position information; extending it here adds the z component and creates a spatial index of the 2dsphere type on the loc field; while creating an ascending index on the loc.z field. In search, a spatial query statement and a z-component range query are combined, so that a component list and an attribute list in a specific spatial range can be efficiently screened.
Specifically, the attribute storage module 103 obtains the attribute storage table by:
performing character conversion on the engineering identification to obtain a sub-table ID;
and based on the sub-table ID, performing sub-table storage on the constructed attributes with the same engineering identification to obtain the attribute storage table.
In an optional embodiment of the present invention, the engineering identifier (i.e., projectGuid) may be converted into two 64-bit integers x and y, and then a preset formula f (x, y, n) ((x mod n) × (y mod n)) mod n is used, where n represents the number of the preset attribute storage tables.
Specifically, the attribute storage module 103 constructs a database cluster by:
storing the attribute storage table in a pre-constructed cluster main node and a pre-constructed standby node;
and summarizing the cluster main node, the standby nodes and the pre-constructed arbitration nodes to obtain the database cluster.
In an optional embodiment of the present invention, the database cluster may be a mongodb cluster, where the mongodb cluster includes: a main node (Mongodb (M)), a standby node (Mongodb (S)) and an arbitration node (Mongodb (A)). The main node and the standby node store data, the arbitration node does not store data, the main node provides all the services of increasing, deleting, checking and modifying under default setting, the standby node does not provide any service, but the standby node can provide the inquiry service through setting, so that the pressure of the main node can be reduced. The arbitration node is a special node which does not store data, and the main function of the arbitration node is to determine which standby node is promoted to be the master node after the master node is hung up.
In the embodiment of the invention, the attribute storage table stores the spatial information of the components, and the association and query based on the spatial relationship of the components can be flexibly and efficiently realized.
The data encapsulation module 104 is configured to store the geometric information in a pre-constructed object database, and encapsulate the object database and the database cluster by using a preset service layer to obtain an inquiry service layer.
In the embodiment of the present invention, the pre-constructed object database may be an object storage database AWS 3, and the AWS S3 may store data (geometric information) as an object, use an engineering identifier as a unique identifier of the object, and use the engineering identifier to implement object query.
In an optional embodiment of the present invention, the preset service layer may be an API layer, and the API layer may provide various attributes and component query interfaces according to service requirements.
The data query module 105 is configured to obtain data query information, and analyze the data query information by using the query service layer to obtain a data query result.
Specifically, the data query module 105 obtains a data query result by:
acquiring data query information, wherein the data query information comprises an attribute index, a spatial index and a geometric index;
calling an attribute query interface and a geometric query interface of the query service layer;
analyzing the attribute index and the spatial index by using the attribute query interface to obtain attribute information, wherein the attribute information comprises a component spatial attribute, and analyzing the geometric index by using the geometric query interface to obtain geometric information;
and summarizing the geometric information and the attribute information to obtain the data query result.
In the embodiment of the present invention, for example, all attributes of all doors of a certain floor are queried, and a native $ geoWithIn query statement and loc.z component are combined in the query statement: { $ and { $ geoWithin { $ geometric: { type: "Polygon", associates [ [ [0,0], [10,0], [10,10], [0,10], [0,0] ] } } } }, { $ and { "loc.z" { $ 0} }, { $ loc.z "{ $ 3} } } } }, {" properties. elementType "{ $ eq:" Door "} }, where {. geWithIn is the native query statement of MongoDB, and loc.z denotes the spatial index.
In the embodiment of the invention, the spatial state information of the component is stored in the attribute storage table as an attribute (namely, the spatial attribute), and the spatial attribute is inquired through the spatial index, so that the inquiry of the three-dimensional data spatial information can be realized through the MongoDB two-dimensional spatial index, and the inquiry efficiency is greatly improved.
Fig. 7 is a schematic structural diagram of an electronic device implementing a data query method according to an embodiment of the present invention.
The electronic device 1 may comprise a processor 10, a memory 11 and a bus, and may further comprise a computer program, such as a data query program 12, stored in the memory 11 and operable on the processor 10.
The memory 11 includes at least one type of readable storage medium, which includes flash memory, removable hard disk, multimedia card, card-type memory (e.g., SD or DX memory, etc.), magnetic memory, magnetic disk, optical disk, etc. The memory 11 may in some embodiments be an internal storage unit of the electronic device 1, such as a removable hard disk of the electronic device 1. The memory 11 may also be an external storage device of the electronic device 1 in other embodiments, such as a plug-in mobile hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the electronic device 1. Further, the memory 11 may also include both an internal storage unit and an external storage device of the electronic device 1. The memory 11 may be used not only to store application software installed in the electronic device 1 and various types of data, such as codes of the data inquiry program 12, but also to temporarily store data that has been output or is to be output.
The processor 10 may be composed of an integrated circuit in some embodiments, for example, a single packaged integrated circuit, or may be composed of a plurality of integrated circuits packaged with the same or different functions, including one or more Central Processing Units (CPUs), microprocessors, digital Processing chips, graphics processors, and combinations of various control chips. The processor 10 is a Control Unit (Control Unit) of the electronic device, connects various components of the electronic device by using various interfaces and lines, and executes various functions and processes data of the electronic device 1 by running or executing programs or modules (e.g., data query programs, etc.) stored in the memory 11 and calling data stored in the memory 11.
The bus may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is arranged to enable connection communication between the memory 11 and at least one processor 10 or the like.
Fig. 7 only shows an electronic device with components, and it will be understood by a person skilled in the art that the structure shown in fig. 7 does not constitute a limitation of the electronic device 1, and may comprise fewer or more components than shown, or a combination of certain components, or a different arrangement of components.
For example, although not shown, the electronic device 1 may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so as to implement functions of charge management, discharge management, power consumption management, and the like through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The electronic device 1 may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
Further, the electronic device 1 may further include a network interface, and optionally, the network interface may include a wired interface and/or a wireless interface (such as a WI-FI interface, a bluetooth interface, etc.), which are generally used for establishing a communication connection between the electronic device 1 and other electronic devices.
Optionally, the electronic device 1 may further comprise a user interface, which may be a Display (Display), an input unit (such as a Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the electronic device 1 and for displaying a visualized user interface, among other things.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
The data query program 12 stored in the memory 11 of the electronic device 1 is a combination of instructions, which when executed in the processor 10, can implement:
acquiring an engineering source file set, and performing identification analysis on the engineering source file set to obtain an engineering identification;
performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information;
performing attribute storage on the attribute information to obtain an attribute storage table, and constructing a database cluster by using the attribute storage table;
storing the geometric information to a pre-constructed object database, and packaging the object database and the database cluster by using a preset service layer to obtain a query service layer;
and acquiring data query information, and analyzing the data query information by using the query service layer to obtain a data query result.
Specifically, the specific implementation method of the processor 10 for the instruction may refer to the description of the relevant steps in the embodiments corresponding to fig. 1 to fig. 5, which is not repeated herein.
Further, the integrated modules/units of the electronic device 1, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. The computer readable storage medium may be volatile or non-volatile. For example, the computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM).
The present invention also provides a computer-readable storage medium, storing a computer program which, when executed by a processor of an electronic device, may implement:
acquiring an engineering source file set, and performing identification analysis on the engineering source file set to obtain an engineering identification;
performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information;
performing attribute storage on the attribute information to obtain an attribute storage table, and constructing a database cluster by using the attribute storage table;
storing the geometric information to a pre-constructed object database, and packaging the object database and the database cluster by using a preset service layer to obtain a query service layer;
and acquiring data query information, and analyzing the data query information by using the query service layer to obtain a data query result.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof.
The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the system claims may also be implemented by one unit or means in software or hardware. The terms second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.

Claims (10)

1. A method for data query, the method comprising:
acquiring an engineering source file set, and performing identification analysis on the engineering source file set to obtain an engineering identification;
performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information;
performing attribute storage on the attribute information to obtain an attribute storage table, and constructing a database cluster by using the attribute storage table;
storing the geometric information to a pre-constructed object database, and packaging the object database and the database cluster by using a preset service layer to obtain a query service layer;
and acquiring data query information, and analyzing the data query information by using the query service layer to obtain a data query result.
2. The data query method of claim 1, wherein said performing an identification resolution on the engineering source file to obtain an engineering identification comprises:
analyzing each engineering source file in the engineering source file set in sequence by using a pre-constructed engineering management platform to obtain a unique identifier of each engineering source file;
and taking the unique identifier as the engineering identifier of the corresponding engineering source file.
3. The data query method of claim 2, wherein the performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information comprises:
identifying the engineering identification by using a digital-analog separation module in the engineering management platform;
and carrying out data and model separation on the source files with the same engineering identification to obtain attribute information of the component and geometric information of the component.
4. The data query method of claim 3, wherein the performing attribute storage on the attribute information to obtain an attribute storage table comprises:
acquiring a preset attribute extraction field;
extracting the attributes of the components with the same engineering identification by using the attribute extraction field to obtain the attributes of the components, wherein the attributes of the components comprise the spatial attributes of the components;
and performing sub-table storage on the constructed attributes to obtain the attribute storage table.
5. The data query method of claim 4, wherein the performing sub-table storage on the constructed attributes to obtain the attribute storage table comprises:
performing character conversion on the engineering identification to obtain a sub-table ID;
and based on the sub-table ID, performing sub-table storage on the constructed attributes with the same engineering identification to obtain the attribute storage table.
6. The data query method of any one of claims 1 to 5, wherein the constructing a database cluster using the attribute storage table comprises:
storing the attribute storage table in a pre-constructed cluster main node and a pre-constructed standby node;
and summarizing the cluster main node, the standby nodes and the pre-constructed arbitration nodes to obtain the database cluster.
7. The data query method according to any one of claims 1 to 5, wherein the obtaining data query information and analyzing the data query information by using the query service layer to obtain a data query result includes:
acquiring data query information, wherein the data query information comprises an attribute index, a spatial index and a geometric index;
calling an attribute query interface and a geometric query interface of the query service layer;
analyzing the attribute index and the spatial index by using the attribute query interface to obtain attribute information, wherein the attribute information comprises a component spatial attribute, and analyzing the geometric index by using the geometric query interface to obtain geometric information;
and summarizing the geometric information and the attribute information to obtain the data query result.
8. A data query apparatus, characterized in that the apparatus comprises:
the identification analysis module is used for acquiring an engineering source file set and carrying out identification analysis on the engineering source file set to obtain an engineering identification;
the data separation module is used for performing data separation on the engineering source file set by using the engineering identifier to obtain attribute information and geometric information;
the attribute storage module is used for performing attribute storage on the attribute information to obtain an attribute storage table, and constructing a database cluster by using the attribute storage table;
the data encapsulation module is used for storing the geometric information to a pre-constructed object database, and encapsulating the object database and the database cluster by using a preset service layer to obtain an inquiry service layer;
and the data query module is used for acquiring data query information, and analyzing the data query information by using the query service layer to obtain a data query result.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform a data query method as claimed in any one of claims 1 to 7.
10. A computer-readable storage medium, in which a computer program is stored, which, when being executed by a processor, carries out a data query method according to any one of claims 1 to 7.
CN202110408315.XA 2021-04-15 2021-04-15 Data query method, device, equipment and storage medium Active CN112948427B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110408315.XA CN112948427B (en) 2021-04-15 2021-04-15 Data query method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110408315.XA CN112948427B (en) 2021-04-15 2021-04-15 Data query method, device, equipment and storage medium

Publications (2)

Publication Number Publication Date
CN112948427A true CN112948427A (en) 2021-06-11
CN112948427B CN112948427B (en) 2024-02-06

Family

ID=76232809

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110408315.XA Active CN112948427B (en) 2021-04-15 2021-04-15 Data query method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN112948427B (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114897393A (en) * 2022-05-24 2022-08-12 宜时云(重庆)科技有限公司 Method, system, medium and device for realizing intelligent construction site management by using BIM
CN115017234A (en) * 2022-06-29 2022-09-06 贵州财经大学 Block chain information management system, block chain information storage and query method
CN115827816A (en) * 2023-02-21 2023-03-21 山东铁路投资控股集团有限公司 BIM component data storage and authentication method and device based on block chain
CN116956332A (en) * 2023-09-20 2023-10-27 深圳市智慧城市科技发展集团有限公司 BIM data processing method, BIM data processing equipment and computer readable storage medium
CN117194704A (en) * 2023-11-07 2023-12-08 航天宏图信息技术股份有限公司 Method, device and equipment for inquiring attribute of component-level live-action three-dimensional model

Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6119126A (en) * 1998-05-29 2000-09-12 Oracle Corporation Object-relational query builder which determines existence of structures from information loaded from the server and cached locally on the client computing system
WO2002103466A2 (en) * 2001-01-19 2002-12-27 Engeneos, Inc. Methods and systems for designing machines including biologically-derived parts
US20160092510A1 (en) * 2014-09-26 2016-03-31 Applied Materials, Inc. Optimized storage solution for real-time queries and data modeling
CN108052688A (en) * 2017-10-09 2018-05-18 深圳高速工程顾问有限公司 Calculation amount data processing method, device, storage medium and computer equipment
CN108363722A (en) * 2018-01-04 2018-08-03 山东浪潮通软信息科技有限公司 A kind of coal mine date storage method and device
CN108647330A (en) * 2018-05-11 2018-10-12 厦门海迈科技股份有限公司 A kind of 3D lightweight conversion methods based on BIM model files
CN109344223A (en) * 2018-09-18 2019-02-15 青岛理工大学 A kind of Building Information Model management system and method based on cloud computing technology
CN109544084A (en) * 2018-08-16 2019-03-29 中建科技有限公司深圳分公司 A kind of assembled architecture systematic difference method, system and terminal device
CN109685896A (en) * 2018-12-14 2019-04-26 天津未来科技城开发有限公司 A kind of pipe engineering survey data delivery method that supporting geotechnical engineering BIM and system
EP3511842A1 (en) * 2018-01-16 2019-07-17 Palantir Technologies Inc. Concurrent automatic adaptive storage of datasets in graph databases
CN110245368A (en) * 2018-03-09 2019-09-17 北京东晨工元科技发展有限公司 A kind of the structuring processing and storage method of BIM data
CN110688692A (en) * 2019-08-27 2020-01-14 水利部水利水电规划设计总院 Two-three-dimensional linkage and superposition display method based on structured BIM model
CN111813963A (en) * 2020-09-10 2020-10-23 平安国际智慧城市科技股份有限公司 Knowledge graph construction method and device, electronic equipment and storage medium
CN111930694A (en) * 2020-07-17 2020-11-13 万翼科技有限公司 Electronic file processing method, electronic device and processing server

Patent Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6119126A (en) * 1998-05-29 2000-09-12 Oracle Corporation Object-relational query builder which determines existence of structures from information loaded from the server and cached locally on the client computing system
WO2002103466A2 (en) * 2001-01-19 2002-12-27 Engeneos, Inc. Methods and systems for designing machines including biologically-derived parts
US20160092510A1 (en) * 2014-09-26 2016-03-31 Applied Materials, Inc. Optimized storage solution for real-time queries and data modeling
CN108052688A (en) * 2017-10-09 2018-05-18 深圳高速工程顾问有限公司 Calculation amount data processing method, device, storage medium and computer equipment
CN108363722A (en) * 2018-01-04 2018-08-03 山东浪潮通软信息科技有限公司 A kind of coal mine date storage method and device
EP3511842A1 (en) * 2018-01-16 2019-07-17 Palantir Technologies Inc. Concurrent automatic adaptive storage of datasets in graph databases
CN110245368A (en) * 2018-03-09 2019-09-17 北京东晨工元科技发展有限公司 A kind of the structuring processing and storage method of BIM data
CN108647330A (en) * 2018-05-11 2018-10-12 厦门海迈科技股份有限公司 A kind of 3D lightweight conversion methods based on BIM model files
CN109544084A (en) * 2018-08-16 2019-03-29 中建科技有限公司深圳分公司 A kind of assembled architecture systematic difference method, system and terminal device
CN109344223A (en) * 2018-09-18 2019-02-15 青岛理工大学 A kind of Building Information Model management system and method based on cloud computing technology
CN109685896A (en) * 2018-12-14 2019-04-26 天津未来科技城开发有限公司 A kind of pipe engineering survey data delivery method that supporting geotechnical engineering BIM and system
CN110688692A (en) * 2019-08-27 2020-01-14 水利部水利水电规划设计总院 Two-three-dimensional linkage and superposition display method based on structured BIM model
CN111930694A (en) * 2020-07-17 2020-11-13 万翼科技有限公司 Electronic file processing method, electronic device and processing server
CN111813963A (en) * 2020-09-10 2020-10-23 平安国际智慧城市科技股份有限公司 Knowledge graph construction method and device, electronic equipment and storage medium

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
史杏荣, 孙贞寿, 何振峰: "地球物理勘探地图数据库GEMDB的设计与实现", 计算机工程与应用, no. 04, pages 74 - 78 *
李璨: "BIM技术在建筑设计质量检查中规范转译的方法研究", 中国优秀硕士学位论文全文数据库工程科技Ⅱ辑, no. 1, pages 038 - 506 *

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114897393A (en) * 2022-05-24 2022-08-12 宜时云(重庆)科技有限公司 Method, system, medium and device for realizing intelligent construction site management by using BIM
CN115017234A (en) * 2022-06-29 2022-09-06 贵州财经大学 Block chain information management system, block chain information storage and query method
CN115827816A (en) * 2023-02-21 2023-03-21 山东铁路投资控股集团有限公司 BIM component data storage and authentication method and device based on block chain
CN115827816B (en) * 2023-02-21 2023-05-02 山东铁路投资控股集团有限公司 BIM component data verification and right confirmation method and device based on blockchain
CN116956332A (en) * 2023-09-20 2023-10-27 深圳市智慧城市科技发展集团有限公司 BIM data processing method, BIM data processing equipment and computer readable storage medium
CN116956332B (en) * 2023-09-20 2024-01-05 深圳市智慧城市科技发展集团有限公司 BIM data processing method, BIM data processing equipment and computer readable storage medium
CN117194704A (en) * 2023-11-07 2023-12-08 航天宏图信息技术股份有限公司 Method, device and equipment for inquiring attribute of component-level live-action three-dimensional model
CN117194704B (en) * 2023-11-07 2024-02-06 航天宏图信息技术股份有限公司 Method, device and equipment for inquiring attribute of component-level live-action three-dimensional model

Also Published As

Publication number Publication date
CN112948427B (en) 2024-02-06

Similar Documents

Publication Publication Date Title
CN112948427B (en) Data query method, device, equipment and storage medium
CN111813963B (en) Knowledge graph construction method and device, electronic equipment and storage medium
CN112052242A (en) Data query method and device, electronic equipment and storage medium
CN111428451B (en) Text online editing method and device, electronic equipment and storage medium
CN110941614A (en) Form generation method and device, electronic equipment and computer readable storage medium
CN111897831A (en) Service message generation method and device, electronic equipment and storage medium
CN112115145A (en) Data acquisition method and device, electronic equipment and storage medium
CN111538573A (en) Asynchronous task processing method and device and computer readable storage medium
CN112685117A (en) System language internationalization maintenance method, device and computer readable storage medium
CN113806434A (en) Big data processing method, device, equipment and medium
CN112580079A (en) Authority configuration method and device, electronic equipment and readable storage medium
CN114185895A (en) Data import and export method and device, electronic equipment and storage medium
CN114979120A (en) Data uploading method, device, equipment and storage medium
CN112464619B (en) Big data processing method, device and equipment and computer readable storage medium
CN113468175A (en) Data compression method and device, electronic equipment and storage medium
CN113360139A (en) Integration method and device of front-end frame, electronic equipment and storage medium
CN112541688A (en) Service data checking method and device, electronic equipment and computer storage medium
CN115220740A (en) Database environment deployment method and device, electronic equipment and storage medium
CN115129753A (en) Data blood relationship analysis method and device, electronic equipment and storage medium
CN114911479A (en) Interface generation method, device, equipment and storage medium based on configuration
CN114116673A (en) Data migration method based on artificial intelligence and related equipment
CN113297180A (en) Data migration method and device, electronic equipment and storage medium
CN112328656A (en) Service query method, device, equipment and storage medium based on middle platform architecture
CN114398282A (en) Test script generation method, device, equipment and storage medium
CN113485711A (en) Task triggering method and device based on dependency relationship, electronic equipment and medium

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
TA01 Transfer of patent application right

Effective date of registration: 20211019

Address after: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.)

Applicant after: Shenzhen saiante Technology Service Co.,Ltd.

Address before: 1-34 / F, Qianhai free trade building, 3048 Xinghai Avenue, Mawan, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong 518000

Applicant before: Ping An International Smart City Technology Co.,Ltd.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant