Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Hierarchical data verification method and device, equipment and medium

A technology of layered data and verification methods, applied in the field of database management, can solve problems such as waste of computing resources, low efficiency, and low development efficiency, and achieve the effects of optimizing computing tasks, improving execution efficiency, and improving efficiency

Pending Publication Date: 2022-07-08
广州方硅信息技术有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, when the data tables in the existing hierarchical data warehouse refer to other data sources in the warehouse, there are often cases of cross-level references or cross-level references. When the data model obtains data from its data tables with cross-level or cross-level references, it will waste excessive computing resources
[0004] Moreover, when platform developers inquire whether there are cross-layer or cross-layer references in the data model they develop, they can often only check the complicated codes in the calculation tasks of the data model, which is too inefficient to effectively manage the distribution. Layer data warehouse, and developers can only manually query whether there is a data source suitable for reference in the layered data warehouse when developing the data model, and the development efficiency is also very low

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Hierarchical data verification method and device, equipment and medium
  • Hierarchical data verification method and device, equipment and medium
  • Hierarchical data verification method and device, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0082] The following describes in detail the embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein the same or similar reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present application, but not to be construed as a limitation on the present application.

[0083]It will be understood by those skilled in the art that the singular forms "a", "an", "the" and "the" as used herein can include the plural forms as well, unless expressly stated otherwise. It should be further understood that the word "comprising" used in the specification of this application refers to the presence of stated features, integers, steps, operations, elements and / or components, but does not preclude the presence or addition of one or more other features, Inte...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a hierarchical data verification method and device, equipment and a medium, and the method comprises the steps: responding to a data model adding instruction which is pushed by a development end and acts on a hierarchical data warehouse, obtaining a plurality of calculation tasks contained in a new data model, and obtaining a standard table name of a model data table; performing test operation on each calculation task, generating resource consumption data representing calculation resources consumed by the calculation tasks, and determining respective reference data tables of the calculation tasks; performing upstream and downstream traceability on each reference data table based on the data hierarchy of the standard table name of the model data table, and drawing a data table mapping relation graph; and according to the model data table and the standard table name of each reference data table, performing hierarchical verification on the reference data table, and matching a recommendation data table superior to the reference data table referenced in a cross-layer or staggered-layer manner for the data model. The quality of the data table in the hierarchical data warehouse is effectively managed, and the calculation efficiency of the data model in the warehouse is improved.

Description

technical field [0001] The present application relates to the field of database management, and in particular, to a method for verifying hierarchical data, and also relates to apparatuses, devices and non-volatile storage media corresponding to the method. Background technique [0002] Existing Internet platforms will use hierarchical data warehouses to store data and data tables in the platform. For example, Internet live broadcast platforms will usually aggregate the data of live broadcast rooms, anchor users and audience users on the platform into relevant data. The data tables required by the live online service, and the data tables in the hierarchical data warehouse also refer to the data tables stored in the warehouse, by developing the corresponding data model to obtain data from the corresponding data source for the associated data table, and then other Get aggregated data from datasheets and create new datasheets to apply to newly deployed online services on the pla...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/28G06F16/22G06F16/2455G06F16/36G06F11/30
CPCG06F16/283G06F16/2282G06F16/24558G06F16/367G06F11/302G06F11/3051
Inventor 林佳铖
Owner 广州方硅信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com