CN116414854A - Data asset query method, device, computer equipment and storage medium - Google Patents

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

Info

Publication number
CN116414854A
CN116414854A CN202310206701.XA CN202310206701A CN116414854A CN 116414854 A CN116414854 A CN 116414854A CN 202310206701 A CN202310206701 A CN 202310206701A CN 116414854 A CN116414854 A CN 116414854A
Authority
CN
China
Prior art keywords
identifier
data asset
index
data
acquiring
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310206701.XA
Other languages
Chinese (zh)
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.)
Hangzhou Xiaodian Technology Co ltd
Original Assignee
Hangzhou Xiaodian 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 Hangzhou Xiaodian Technology Co ltd filed Critical Hangzhou Xiaodian Technology Co ltd
Priority to CN202310206701.XA priority Critical patent/CN116414854A/en
Publication of CN116414854A publication Critical patent/CN116414854A/en
Pending legal-status Critical Current

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/242Query formulation
    • G06F16/2428Query predicate definition using graphical user interfaces, including menus and forms
    • 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/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • G06Q10/06393Score-carding, benchmarking or key performance indicator [KPI] analysis
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Development Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Strategic Management (AREA)
  • Computational Linguistics (AREA)
  • Educational Administration (AREA)
  • Economics (AREA)
  • Game Theory and Decision Science (AREA)
  • Human Computer Interaction (AREA)
  • Mathematical Physics (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The application relates to a data asset query method, a data asset query device, computer equipment and a storage medium, wherein the method comprises the following steps: acquiring a query request of a user, wherein the query request comprises a first-level requirement index; acquiring a first identifier based on the query request, wherein the first identifier is established based on a first-level demand index and a summary algorithm; acquiring a second identifier based on the first identifier, wherein the second identifier consists of the first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and a summary algorithm; and acquiring the data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier. According to the method and the device for inquiring and analyzing the data asset, the technical problem that the data asset management platform in the traditional technology is low in inquiring and analyzing efficiency of the data asset is solved, the inquiring and analyzing efficiency of the data asset is improved, meanwhile, the first identifier and the second identifier are generated based on the abstract algorithm, and safety is higher.

Description

Data asset query method, device, computer equipment and storage medium
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a data asset query method, a data asset query device, a computer device, and a storage medium.
Background
With the development of the internet and storage technologies, the application of data asset management platforms is becoming more and more widespread. The data asset management platform is used for integrating, classifying, analyzing and the like a large amount of data, and plays an important role in links of enterprise production, management and the like.
In the conventional art, the primary role of a data asset management platform is to store and manage data assets to determine the data content and storage location generated during an enterprise business. However, in the practical application scenario, the management of the data asset is closely related to the business requirement, but in the conventional technology, the data asset and the business requirement are often disjointed, so that the data asset cannot be traced, a query link between the business requirement and the data asset cannot be established, and the query and analysis efficiency of the data asset in the conventional technology is low.
Aiming at the technical problem that the data asset management platform has lower query and analysis efficiency on data assets in the traditional technology, no effective solution is proposed at present.
Disclosure of Invention
Based on the above, the application provides a data asset query method, a data asset query device, a computer device and a storage medium, which solve the technical problem that the query and analysis efficiency of the data asset management platform on the data asset is low.
In a first aspect, the present application provides a data asset querying method, including:
acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
acquiring a first identifier based on the query request, wherein the first identifier is established based on the primary demand index and a summary algorithm;
acquiring a second identifier based on the first identifier, wherein the second identifier consists of a first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and the abstract algorithm;
and acquiring a data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
In one embodiment, the obtaining the query request of the user further includes:
judging whether the primary demand index exists in a database or not;
if so, acquiring a first identifier based on the query request;
and if the primary requirement index does not exist, storing the primary requirement index into a database.
In one embodiment, the saving the primary demand index into the database includes:
processing the first-level demand index based on the abstract algorithm to obtain a first identifier;
And correspondingly storing the first-level demand index and the first identifier into a database.
In one embodiment, the processing the primary requirement index based on the summary algorithm to obtain the first identifier includes:
processing the first-level demand index based on the abstract algorithm to obtain a first initial identifier;
acquiring a plurality of second initial identifiers based on the first initial identifiers, wherein the hamming distance between each second initial identifier and the first initial identifier is the same;
the first identifier is created based on a plurality of the second initial identifiers.
In one embodiment, after the storing the primary requirement index and the first identifier in the database, the method further includes:
establishing the secondary demand index associated with the primary demand index;
processing the secondary demand index based on the abstract algorithm to obtain the second sub-identifier;
splicing the first identifier and the second sub-identifier to obtain the second identifier;
and correspondingly storing the second-level requirement index and the second identifier into a database.
In one embodiment, after the storing the second level requirement index and the second identifier in the database, the method further includes:
The second identification is added to an associated data model for storing and analyzing the data asset.
In one embodiment, the method further comprises:
acquiring access heat information of the data asset, wherein the access heat information comprises at least one of searching times and quoting times;
based on the access heat information, a lifecycle of the data asset is determined.
In a second aspect, the present application further provides a data asset querying device, including:
the first acquisition module is used for acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
the second acquisition module is used for acquiring a first identifier based on the query request, and the first identifier is established based on the primary demand index and a summary algorithm;
the third acquisition module is used for acquiring a second identifier based on the first identifier, wherein the second identifier consists of the first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and the abstract algorithm;
and the fourth acquisition module is used for acquiring the data asset based on the second identifier and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor which when executing the computer program performs the steps of:
acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
acquiring a first identifier based on the query request, wherein the first identifier is established based on the primary demand index and a summary algorithm;
acquiring a second identifier based on the first identifier, wherein the second identifier consists of a first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and the abstract algorithm;
and acquiring a data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
Acquiring a first identifier based on the query request, wherein the first identifier is established based on the primary demand index and a summary algorithm;
acquiring a second identifier based on the first identifier, wherein the second identifier consists of a first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and the abstract algorithm;
and acquiring a data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
The application provides a data asset query method, a data asset query device, computer equipment and a storage medium, wherein the method comprises the following steps: acquiring a query request of a user, wherein the query request comprises a first-level requirement index; acquiring a first identifier based on the query request, wherein the first identifier is established based on the primary demand index and a summary algorithm; acquiring a second identifier based on the first identifier, wherein the second identifier consists of a first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and the abstract algorithm; and acquiring a data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier. The second identifier of the second-level demand index is queried through the first identifier corresponding to the first-level demand index, and then the corresponding data asset is obtained, so that the service demand and the data asset are connected in series through the first identifier and the second identifier, a bidirectional query link between the service demand and the data asset is constructed, the technical problem that the query link between the service demand and the data asset cannot be established in the traditional technology, the data asset management platform queries the data asset, and the analysis efficiency is lower is solved, the data asset management platform can query the other party directly based on one of the service demand and the data asset, a bidirectional query route from the service demand to the specific data asset is rapidly and accurately detected, and the query and analysis efficiency of the data asset is improved.
Drawings
FIG. 1 is an application environment diagram of a data asset querying method according to an embodiment of the present application;
FIG. 2 is a flow diagram of a data asset querying method according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a display interface of a data asset management system according to one embodiment of the present application;
FIG. 4 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application;
FIG. 5 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application;
FIG. 6 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application;
FIG. 7 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application;
FIG. 8 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application;
FIG. 9 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application;
FIG. 10 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application;
FIG. 11 is a flow chart of a data asset querying method according to another embodiment of the present application;
FIG. 12 is a schematic diagram of an interactive architecture of a data asset management system according to one embodiment of the present application;
FIG. 13 is a block diagram of a data asset querying device according to an embodiment of the present application;
Fig. 14 is an internal structural diagram of a computer device according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The data asset query method provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104 or may be located on a cloud or other network server. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices, and portable wearable devices, where the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart vehicle devices, and the like. The portable wearable device may be a smart watch, smart bracelet, headset, or the like. The server 104 may be implemented as a stand-alone server or as a server cluster of multiple servers.
Referring to fig. 2, fig. 2 is a flow chart of a data asset query method according to an embodiment of the present application.
In one embodiment, a data asset querying method includes:
s202: and obtaining a query request of the user, wherein the query request comprises a first-level requirement index.
Specifically, the user inputs a query request on the display interface, where the query request includes a first-level requirement index to be queried. The user can input the query request by clicking a primary demand index button of the display interface or directly typing in a primary demand index.
The primary demand index in this embodiment refers to a service index associated with a service demand, specifically, a readable and globally unique index name generated based on the service demand, for example, an index name "successful order amount" associated with a trade order demand.
Illustratively, after a user logs in the data asset management platform, the user enters a query page provided by the data asset management platform, and similar indexes are retrieved through the requirement content keywords, the index keywords and the like, so that a first-level requirement index which needs to be accessed is obtained.
S204: the first identification is acquired based on the query request, and is established based on the first-level demand index and the abstract algorithm.
Specifically, according to the first-level demand index in the query request, a corresponding first identifier is obtained, wherein the first identifier is a coded identifier character string generated after the first-level demand index is processed based on a summary algorithm.
The summary algorithm in this embodiment refers to an algorithm that processes input data and outputs pseudo random data with a fixed length. It can be understood that in this embodiment, the primary demand index and the secondary demand index described below are processed by the summarization algorithm, so that a fixed-length code identification string corresponding to the primary demand index and the secondary demand index can be obtained, thereby facilitating unified management of the primary demand index and the secondary demand index by the code identification string. Meanwhile, the summary algorithm has no limitation on the length of the input primary demand index and the length of the input secondary demand index, and has higher scene adaptability.
S206: and acquiring a second identifier based on the first identifier, wherein the second identifier consists of the first identifier and a second sub-identifier, and the second sub-identifier is established based on the second-level requirement index and a summary algorithm.
Specifically, matching search is performed on the second identifiers through the first identifiers to obtain second identifiers corresponding to the first identifiers, wherein the corresponding relation between the first identifiers and the second identifiers is represented by the characters of the first identifiers contained in the second identifiers, and the matching search process is to perform similarity search on the characters in each second identifier so as to determine whether partial character strings identical to the first identifiers exist.
The second identifier in this embodiment is composed of the first identifier and the second sub-identifier, for example, the first identifier may be used as a prefix of the second sub-identifier, so as to generate the second identifier. The second sub-identifier is a coded identifier character string generated after the secondary demand index is processed through a summary algorithm.
The secondary demand index in this embodiment refers to an index name of a next level associated with the service demand, which is derived from the primary demand index, that is, the secondary demand index is a derived index corresponding to a specific implementation manner of the primary service index. For example, the primary demand index may be set to "successful order amount" and the secondary demand index may be set to: an "assembly work order amount", "success amount", "assembly work amount", etc.
The system determines the corresponding secondary demand index based on the corresponding first identifier and displays the secondary demand index on the display interface through the index button after the user inputs the query request on the display interface of the data asset management platform. After clicking the index button corresponding to the second-level requirement index, the user can further acquire the corresponding data asset.
S208: and acquiring the data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
Specifically, the corresponding data asset is obtained through the second identifier, and asset information of the data asset is displayed on a display interface, for example, a related asset report is displayed on a reporting system. Wherein the data asset establishes an association with the second identifier in advance.
All data assets used for query in this embodiment are generally collected and counted based on a certain period of time, for example, enterprise business activity data generated in the last month can be stored and managed in the data asset management platform.
For example, in this embodiment, the correspondence between the data asset and the second identifier may be stored in advance in the database, so as to determine the data asset corresponding to the second identifier conveniently; alternatively, the second identifier may be used as one of the data segments in the data asset, and the data asset is directly matched when the data asset is extracted, so as to determine the data asset corresponding to the second identifier.
For example, after the data asset is acquired, the user may be authenticated based on the user ID to determine whether the user has the authority to operate on the data asset, and if so, display the related asset information of the data asset on the display interface and respond to the related instruction of the user.
Referring to fig. 3, fig. 3 is a schematic diagram of a display interface of a data asset management system according to an embodiment of the present application.
Illustratively, as shown in FIG. 3, the associated description of the display information in the display interface is as follows: sequence number 1: inquiring service indexes; sequence number 2: the ordering mode of the business index results comprises matching degree, updating time and creation time; serial number 3: business index life cycle state; serial number 4: associating derivative indexes; sequence number 5: an associated data model for storing and analyzing the data asset; serial number 6: details of business indexes; serial number 7: all changed versions of the business index are recorded. In addition, the display interface also has a plurality of functional modules, including a term management module, a data domain and business process management module, an index management module, a model field management module, a number bin configuration management, a data external system and the like, wherein the index management module has 6 sub-functional modules of index inquiry, old index management, atomic index management, business index management, derived index management and index data overview.
The index query sub-module is mainly used for realizing the data asset query method in the embodiment. The specific information in the index query sub-module comprises: business index name, life status, business domain to which the business belongs, english ID of the index, business index caliber description (business requirement), index alias (business habit call), application product, creator, maintainer, last update time, etc.
For example, after the user inputs the keyword of the service index in the "index name", if the "data field/service process/index state/application product" is not selected, the system directly queries in the database through the keyword, and displays the result in a reverse order with the default creation time; when the user selects the data field/business process/index state/application product and the ordering mode, the system brings the conditions into the query conditions and displays the query conditions in the ordering mode selected by the user.
Illustratively, when querying the database, if the business index already has a data asset corresponding thereto, the upper right corner of the derived index button will display a "numerical corner mark" to alert the user that the business index has a corresponding data asset, such as serial number 4 and serial number 5 in FIG. 3, whereas the buttons of serial number 4 and serial number 5 are gray and non-clickable. When the user clicks the sequence number 4 and the sequence number 5, the corresponding data asset can be directly seen, so that a query link from the business index to the derivative index to the data asset is realized.
In this embodiment, the second identifier of the second-level demand index is queried through the first identifier corresponding to the first-level demand index, and then the corresponding data asset is obtained, so that the service demand and the data asset are connected in series through the first identifier and the second identifier, a bidirectional query link between the service demand and the data asset is constructed, the technical problem that the query link between the service demand and the data asset cannot be established in the traditional technology, which results in lower query and analysis efficiency of the data asset by the data asset management platform, can directly query the other party based on one of the service demand and the data asset, realizes a bidirectional query route from the service demand to the specific data asset quickly and accurately tracing to the specific service demand from the data asset, improves the query and analysis efficiency of the data asset, and meanwhile, the first identifier and the second identifier are generated based on a summary algorithm, and have higher security compared with a direct naming method.
In another embodiment, the obtaining the query request of the user further includes:
step (a) 1: judging whether a primary demand index exists in a database or not;
step 2: if yes, acquiring a first identifier based on the query request;
step 3: if not, the first-level requirement index is stored in a database.
Specifically, the data asset management system acquires the primary demand index after receiving the inquiry request of the user and judges whether the primary demand index is established in the database. If the primary demand index is established in the database, continuing to execute the data asset query step in the application; if the primary demand index is not established in the database, the primary demand index is established in the database.
For example, if the primary demand index does not exist in the data asset management system, the primary demand index is newly added on the display interface based on the business demand.
Optionally, after the primary demand index is created, the validity of the primary demand index is inspected, and the inspected content includes but is not limited to: whether the naming format meets the requirements, whether the index semantics have ambiguity, and the like. After the validity examination is passed, the first-level demand index is online to enter a use state, and a corresponding second-level demand index, a data asset and the like can be created based on the first-level demand index.
Referring to FIG. 4, for an example, FIG. 4 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application.
Illustratively, in the display interface shown in fig. 4, the business index management submodule of the index management module is used for adding a new business index and storing the business index in the database in the system. The specific new construction process is as follows: the user clicks a new business index button, the display interface pops up a new business index popup window, and the user inputs basic information of the business index on the popup window page; after the user inputs the basic information of the business index, if clicking a button for storing the draft, the system initiates a writing instruction to the database after receiving the request data, and the business index stored in the database is in the draft state at the moment, so that the user can click on the business index again and edit the business index for the second time; if the user clicks the determined and submitted button, the system initiates a writing instruction to the database after receiving the request data, and the business index stored in the database is a determined state.
In the embodiment, whether the primary demand index is established is judged, if not, the primary demand index is stored in the database, so that the data asset management system can respond to the service demand in time, and the use experience of the data asset management system is improved.
In another embodiment, saving the primary demand index into the database includes:
step 1: processing the first-level demand index based on a summary algorithm to obtain a first identifier;
step 2: and correspondingly storing the first-level demand index and the first identifier into a database.
Specifically, in the process of storing the primary demand index into the database, mapping is performed on the primary demand index based on a summary algorithm to obtain a first identifier, and the primary demand index, the first identifier and the corresponding relation between the primary demand index and the first identifier are stored into the database.
The digest algorithm in this embodiment includes, but is not limited to, MD5 message digest algorithm, rivemd-160 cryptographic hash function algorithm, and the like.
In the embodiment, the first-level requirement index is processed through the abstract algorithm to obtain the first identifier, and the first identifier and the first-level requirement index are correspondingly stored in the database, so that the first identifier can be conveniently and directly searched based on the query request input by the user, and the data asset query efficiency is improved.
In another embodiment, processing the first level of demand indicators based on a summary algorithm, the obtaining the first identifier includes:
step 1: processing the first-level demand index based on a summary algorithm to obtain a first initial identifier;
Step 2: acquiring a plurality of second initial identifiers based on the first initial identifiers, wherein the Hamming distance between each second initial identifier and the first initial identifier is the same;
step 3: the first identifier is created based on the plurality of second initial identifiers.
Specifically, the process of processing the first-level requirement index and generating the first identifier in this embodiment specifically includes: mapping the first-level demand index through a summary algorithm to obtain a first initial identifier; processing the first initial identifiers to generate a plurality of second initial identifiers, wherein the hamming distance between each second initial identifier and the first initial identifier is the same; and performing operations such as superposition or fusion on the plurality of second initial identifiers to obtain a first identifier.
The hamming distance in this embodiment refers to the number of steps for transforming one set of string data with the same length into another set of string data, where the hamming distance is used to identify the number of bits with different characters at corresponding positions in two sets of string data with the same length.
The first identifier is formed by splicing the plurality of second initial identifiers according to the sequence after the plurality of second initial identifiers are acquired.
It should be noted that, in this embodiment, the method of processing the first-level requirement index is also applicable to the process of processing the second-level requirement identifier to generate the second sub-identifier, which is not described in detail in this application.
In this embodiment, the first-level requirement index is processed to generate the first initial identifier, the first initial identifier is further encoded through the same hamming distance to obtain the second initial identifier, and finally the first identifier is generated.
In another embodiment, after storing the first-level requirement index and the first identifier in the database, the method further includes:
step 1: establishing a secondary demand index associated with the primary demand index;
step 2: processing the second-level requirement index based on a summary algorithm to obtain a second sub-identifier;
step 3: splicing the first mark and the second sub mark to obtain a second mark;
step 4: and correspondingly storing the second-level requirement index and the second identifier into a database.
Specifically, after the primary demand index and the corresponding first identifier are created, a secondary demand index associated with the primary demand index is obtained, wherein the association relation is embodied as that the secondary demand index can be a sub-index of the primary demand index; processing the secondary demand index through a summary algorithm to generate a second sub-identifier; splicing the first identifier and the second sub-identifier by taking the first identifier as a prefix, so as to obtain the second sub-identifier; and finally, storing the second-level requirement index, the second identifier and the corresponding relation of the second-level requirement index and the second identifier into a database.
The addition, auditing, and offline work of the derived index is illustratively performed by the derived index management sub-module shown in fig. 3. When the derivative index needs to be newly added, clicking a derivative index creation button of the display interface, and generating a unique identification ID (second identification) by the data asset management system, wherein the first identification is used as a prefix of the unique identification ID. For example, the first identifier is a sacc_amt and the second identifier is a sacc_amt_1d.
In this embodiment, the second-level requirement index is processed to obtain the second identifier, and the second identifier is stored in the database, so that the corresponding second identifier is conveniently determined directly based on the second-level requirement index in the data asset query process, and thus the efficiency of data asset query is improved.
In another embodiment, after storing the second level requirement index and the second identifier in the database, the method further includes:
the second identification is added to an associated data model for storing and analyzing the data asset.
The data model in the embodiment is used for storing and analyzing the data assets. Specifically, the data model is a model generated by modeling an operation activity and the like under a certain business observation view of a user, and is used for storing derivative indexes, corresponding data assets and the like, and the data model can be interpreted as the data assets and a container for storing the data assets. It will be appreciated that since the data model is a tool for statistically analyzing business operations, the data model itself carries perspective information for viewing business data.
In particular, the second identifications are added to an associated data model, wherein the data model may be associated with a plurality of second identifications, i.e. the data model may correspond to a plurality of secondary demand indicators.
For example, after the data model is newly added by the model field management module shown in fig. 3 and the user clicks the newly added data model, the derived index can be directly used as a metric field and added to the model because the data model is a container for bearing the derived index. After the data model is built, the data in the data model can be updated manually or automatically.
Illustratively, the link relation among the business index, the derivative index and the data model is established through the first identifier and the second identifier.
Referring to fig. 5, fig. 5 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application.
Illustratively, FIG. 5 is a page presented by a user clicking on the view button of "associated derived metrics" with numerical subscripts as shown in FIG. 3. When the user clicks the button, the data asset management system will use the hidden identity ID of the business index, i.e. the first identification, as a query condition to find the data asset associated with it from the database and present it on this page. In the page shown in fig. 5, the displayed information includes derived metrics, data fields, and association models.
Referring to fig. 6, fig. 6 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application.
Illustratively, FIG. 6 is a page displayed after the user clicks on the derivative index succ_order_amt_1d shown in FIG. 5. When the user clicks the succ_order_amt_1d button, the system uses the succ_order_amt_1d as a query condition to search out the basic information of the derivative index succ_order_amt_1d from the database and display the basic information on the popup page. The basic information of the derived index displayed on the page comprises derived index names, chinese descriptions, index caliber, data fields, atomic indexes (root indexes or father indexes), time periods, modifier words, service index names, asset security levels, data types, creator, auditor, maintainer and the like.
Referring to fig. 7, fig. 7 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application.
Illustratively, FIG. 7 is information presented after the user clicks on the dws_fin_shop_stts_1d data model in the association model column shown in FIG. 5. When the user clicks dws_fin_shop_stts_1d, the data asset management system searches the database in the background for detailed information of the data model dws_fin_shop_stts_1d and displays the detailed information in the page. The derivative index "succ_order_amt_1d" and the service index "successful order amount" are shown in the page, as shown in fig. 7, which shows that the dws_fin_shop_stts_1d data model carries the derivative index "succ_order_amt_1d" on the field name, and a bidirectional query link with the service index "successful order amount" is realized.
In the embodiment, the second identifier is added to the associated data model, so that a bidirectional query link between the service requirement and the data model is realized, and the query efficiency of the data asset is further improved.
In another embodiment, the method further comprises:
step 1: acquiring access heat information of the data asset, wherein the access heat information comprises at least one of searching times and quoting times;
step 2: based on the access heat information, a lifecycle of the data asset is determined.
Specifically, access records of the data asset are recorded, access heat information of the data asset is obtained, and the life cycle of the data asset is determined based on the heat access information.
The hot access information in this embodiment includes, but is not limited to, the number of searches and references of the data asset. Illustratively, when the data asset is used in the reporting system or the display interface through the data service, the data asset management system records the call log relation and the embedded point log data of the used data asset, and the hot access information of the data asset can be obtained by processing the data through the data processing tool.
It will be appreciated that the access to the heat information may be used to adjust the lifecycle, i.e., the storage deadline, of the data asset. When the access heat of the data asset corresponding to the service requirement is reduced or even no access record exists, the data asset management system can perform offline operation on the service index of the service requirement, and the corresponding data asset performs operations such as cold backup, suspension maintenance or elimination offline operation.
Referring to fig. 8-9, fig. 8 and 9 are schematic diagrams of display interfaces of a data asset management system according to another embodiment of the present application.
For example, fig. 8 and fig. 9 are both display pages of the index data overview submodule, and the displayed content includes a business index report reference number, a business index search number, a business index and derived index association number, and a business index and model association number. As shown in fig. 8, the number of business index report references and the number of business index searches are used to quantify the heat and scope of the business index, reflecting whether the business requirement has reached the end of the lifecycle; as shown in fig. 9, the number of correlations between the business index and the derivative index and the number of correlations between the business index and the model are used to quantify the data asset yield of the business demand, and when the business demand reaches the end of the life cycle, the number of correlations between the business index and the derivative index and the number of correlations between the business index and the model are the data asset list that needs to be subjected to operations such as cold backup, suspension maintenance or elimination of offline.
According to the embodiment, the life cycle of the data asset is determined based on the access heat information of the data asset, so that the data asset is maintained and cleaned in time, and the use cost and the maintenance cost of the data asset management system are reduced.
Referring to fig. 10, fig. 10 is a schematic diagram of a display interface of a data asset management system according to another embodiment of the present application.
In another embodiment, FIG. 10 is information presented after clicking the change history button of FIG. 3. After receiving a click command of a user, the data asset management system searches all change records of the business index from the database through the first identification of the business index and displays the change records on the display interface.
The change record in this embodiment includes, but is not limited to, a change time, a comparison of contents before and after the change, a change person, and the like.
In the embodiment, the data asset management system records various change information of the business requirements in the full life cycle in the database, so that the change of all data assets of the business requirements is trackable, and the accuracy and the comprehensiveness of inquiring the data assets are further ensured.
Referring to fig. 11, fig. 11 is a flowchart of a data asset query method according to another embodiment of the present application.
Specifically, as shown in fig. 11, the data asset query method includes:
s1102: generating a service demand;
illustratively, a user gathers business demands generated in daily business activities;
S1104: retrieving service indexes;
illustratively, a user enters business metrics and retrieves them in a data asset management system;
s1106: determining whether it already exists;
illustratively, the data asset management platform performs matching search in the database based on the business index, determines whether the business index already exists in the database, if yes, S1108 is executed, and if not, S1114 is executed;
s1108: searching for a data asset;
illustratively, the data asset is matched and searched based on a first identification of the business index or a second identification of a derivative index associated with the business index;
s1110: applying for data asset rights;
illustratively, the user applies for the operational rights of the data asset, and the data asset management system authenticates the operational rights of the user based on the user ID;
s1112: using the data asset;
illustratively, after the rights authentication passes, the user views the relevant information of the data asset.
S1114: determining a demand;
illustratively, the business needs are validated;
s1116: generating a business index;
illustratively, generating a business index; optionally, generating a derived index associated with the service index, a first identifier of the service index and a second identifier of the derived index, and establishing a data model;
S1118: developing a data asset;
illustratively, data assets are collected, stored, and maintained;
s1120: informing and putting on line;
illustratively, after completing the above steps, a completion notification is issued and the service requirements are online
Referring to FIG. 12, FIG. 12 is a schematic diagram of an interaction structure of a data asset management system according to an embodiment of the present application.
As shown in fig. 12, the content managed by the data asset management platform includes operations such as query and addition of business indexes, and contents such as data model, derivative indexes and business process of the data asset, wherein a bidirectional query link relationship exists between the business indexes and the data asset; business personnel communicate with product personnel, and the business personnel and the product personnel can query, add and the like the business indexes based on the data asset management platform; the developer can update and maintain the data asset; the cloud platform, the database and the like interact with the data asset management platform to be used for storing the data assets; the data asset management platform may also be connected to other data service modules such as data analytics.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a data asset query device for realizing the above related data asset query method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in the embodiments of the data asset querying device provided below may refer to the limitation of the data asset querying method hereinabove, and will not be repeated herein.
In one embodiment, as shown in FIG. 13, there is provided a data asset querying device comprising:
the first obtaining module 10 is configured to obtain a query request of a user, where the query request includes a first-level requirement index;
the second obtaining module 20 is configured to obtain a first identifier based on the query request, where the first identifier is established based on the first-level requirement index and the summary algorithm;
the third obtaining module 30 is configured to obtain a second identifier based on the first identifier, where the second identifier is composed of the first identifier and a second sub-identifier, and the second sub-identifier is established based on the second-level requirement index and the summary algorithm;
a fourth obtaining module 40, configured to obtain a data asset based on the second identifier, and display asset information of the data asset on the display interface, where the data asset is associated with the second identifier;
The data asset inquiry device further comprises an establishment module;
the establishing module is used for judging whether the primary demand index exists in the database or not;
if yes, acquiring a first identifier based on the query request;
if the first-level requirement index does not exist, the first-level requirement index is stored in a database;
the building module is also used for processing the first-level requirement index based on a summary algorithm to obtain a first identifier;
correspondingly storing the first-level demand index and the first identifier into a database;
the building module is also used for processing the first-level requirement index based on a summary algorithm to obtain a first initial identifier;
acquiring a plurality of second initial identifiers based on the first initial identifiers, wherein the Hamming distance between each second initial identifier and the first initial identifier is the same;
creating a first identifier based on the plurality of second initial identifiers;
the building module is also used for building a secondary demand index associated with the primary demand index;
processing the second-level requirement index based on a summary algorithm to obtain a second sub-identifier;
splicing the first mark and the second sub mark to obtain a second mark;
correspondingly storing the second-level requirement index and the second identifier into a database;
the building module is further used for adding a second identification to an associated data model, and the data model is used for storing and analyzing the data asset;
The data asset inquiry device further comprises a maintenance module;
the maintenance module is used for acquiring access heat information of the data asset, wherein the access heat information comprises at least one of searching times and quoting times;
based on the access heat information, a lifecycle of the data asset is determined.
The various modules in the data asset querying device described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 14. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is for storing data assets. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data asset querying method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, can also be keys, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the structure shown in fig. 14 is merely a block diagram of a portion of the structure associated with the present application and is not limiting of the computer device to which the present application applies, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:
acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
acquiring a first identifier based on the query request, wherein the first identifier is established based on a first-level demand index and a summary algorithm;
acquiring a second identifier based on the first identifier, wherein the second identifier consists of the first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and a summary algorithm;
and acquiring the data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
Acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
acquiring a first identifier based on the query request, wherein the first identifier is established based on a first-level demand index and a summary algorithm;
acquiring a second identifier based on the first identifier, wherein the second identifier consists of the first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and a summary algorithm;
and acquiring the data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
It should be noted that, user information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.

Claims (10)

1. A method of data asset querying, comprising:
acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
acquiring a first identifier based on the query request, wherein the first identifier is established based on the primary demand index and a summary algorithm;
acquiring a second identifier based on the first identifier, wherein the second identifier consists of a first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and the abstract algorithm;
And acquiring a data asset based on the second identifier, and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
2. The data asset querying method according to claim 1, wherein after the obtaining the query request of the user, further comprises:
judging whether the primary demand index exists in a database or not;
if so, acquiring a first identifier based on the query request;
and if the primary requirement index does not exist, storing the primary requirement index into a database.
3. The data asset querying method of claim 2, wherein said saving said primary demand indicators into a database comprises:
processing the first-level demand index based on the abstract algorithm to obtain a first identifier;
and correspondingly storing the first-level demand index and the first identifier into a database.
4. The data asset query method of claim 3, wherein the processing the primary demand index based on the summary algorithm to obtain a first identification comprises:
processing the first-level demand index based on the abstract algorithm to obtain a first initial identifier;
Acquiring a plurality of second initial identifiers based on the first initial identifiers, wherein the hamming distance between each second initial identifier and the first initial identifier is the same;
the first identifier is created based on a plurality of the second initial identifiers.
5. The data asset querying method according to claim 3, wherein after storing the primary demand index and the first identifier in a database, the method further comprises:
establishing the secondary demand index associated with the primary demand index;
processing the secondary demand index based on the abstract algorithm to obtain the second sub-identifier;
splicing the first identifier and the second sub-identifier to obtain the second identifier;
and correspondingly storing the second-level requirement index and the second identifier into a database.
6. The data asset querying method of claim 5, wherein said storing said secondary demand index and said second identifier in a database comprises:
the second identification is added to an associated data model for storing and analyzing the data asset.
7. The data asset querying method as in claim 1, further comprising:
acquiring access heat information of the data asset, wherein the access heat information comprises at least one of searching times and quoting times;
based on the access heat information, a lifecycle of the data asset is determined.
8. A data asset querying device, comprising:
the first acquisition module is used for acquiring a query request of a user, wherein the query request comprises a first-level requirement index;
the second acquisition module is used for acquiring a first identifier based on the query request, and the first identifier is established based on the primary demand index and a summary algorithm;
the third acquisition module is used for acquiring a second identifier based on the first identifier, wherein the second identifier consists of the first identifier and a second sub-identifier, and the second sub-identifier is established based on a second-level requirement index and the abstract algorithm;
and the fourth acquisition module is used for acquiring the data asset based on the second identifier and displaying asset information of the data asset on a display interface, wherein the data asset is associated with the second identifier.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.
CN202310206701.XA 2023-02-28 2023-02-28 Data asset query method, device, computer equipment and storage medium Pending CN116414854A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310206701.XA CN116414854A (en) 2023-02-28 2023-02-28 Data asset query method, device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310206701.XA CN116414854A (en) 2023-02-28 2023-02-28 Data asset query method, device, computer equipment and storage medium

Publications (1)

Publication Number Publication Date
CN116414854A true CN116414854A (en) 2023-07-11

Family

ID=87048879

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310206701.XA Pending CN116414854A (en) 2023-02-28 2023-02-28 Data asset query method, device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN116414854A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116821192A (en) * 2023-08-30 2023-09-29 中国中金财富证券有限公司 Asset data query method and device and computer equipment

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116821192A (en) * 2023-08-30 2023-09-29 中国中金财富证券有限公司 Asset data query method and device and computer equipment
CN116821192B (en) * 2023-08-30 2023-11-24 中国中金财富证券有限公司 Asset data query method and device and computer equipment

Similar Documents

Publication Publication Date Title
US10725981B1 (en) Analyzing big data
US9489119B1 (en) Associative data management system utilizing metadata
US9361320B1 (en) Modeling big data
US9026901B2 (en) Viewing annotations across multiple applications
CN102999561B (en) The context trend of data set and data, services
US8341175B2 (en) Automatically finding contextually related items of a task
US9798813B2 (en) Extensible person container
US20120023109A1 (en) Contextual processing of data objects in a multi-dimensional information space
Bleifuß et al. Exploring change: A new dimension of data analytics
CN105556517A (en) Smart search refinement
CN104750776A (en) Accessing information content in a database platform using metadata
CN110134681B (en) Data storage and query method and device, computer equipment and storage medium
US9208150B2 (en) Automatic association of informational entities
EP3249557B1 (en) Computer implemented and computer controlled method, computer program product and platform for arranging data for processing and storage at a data storage engine
CN116414854A (en) Data asset query method, device, computer equipment and storage medium
CN107291951B (en) Data processing method, device, storage medium and processor
US10885157B2 (en) Determining a database signature
CN112136121A (en) Recommending secure content
US10423629B2 (en) Intelligent tabular big data presentation in search environment based on prior human input configuration
US20130024761A1 (en) Semantic tagging of user-generated content
CN113934729A (en) Data management method based on knowledge graph, related equipment and medium
CN116783587A (en) Data storage for list-based data searching
CN113127574A (en) Service data display method, system, equipment and medium based on knowledge graph
US20140317154A1 (en) Heterogeneous data management methodology and system
US11954223B2 (en) Data record search with field level user access control

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