A method and device for generating a web front-end star schema layout, and electronic equipment

A star model and layout technology, applied in the field of data visualization, can solve problems such as no automatic implementation, low efficiency, and affecting the development progress and user experience, and achieve the effect of avoiding overlap

Active Publication Date: 2022-02-25
GUANGZHOU XUANWU WIRELESS TECH CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, none of the visual data warehouse modeling platforms currently on the market can automatically realize such figure 1 The layout method for the star schema shown
In actual development, a fact table is often associated with many dimension tables, which makes the number of dimension tables often exceed 10; therefore, when the number of dimension tables is large, if the layout can only be adjusted manually If not, the efficiency is very low, which greatly affects the development progress and user experience

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
  • A method and device for generating a web front-end star schema layout, and electronic equipment
  • A method and device for generating a web front-end star schema layout, and electronic equipment
  • A method and device for generating a web front-end star schema layout, and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] In order to make the purpose, technical solution and advantages of the present application clearer, the embodiments of the present application will be further described in detail below in conjunction with the accompanying drawings.

[0057] It should be clear that the described embodiments are only some of the embodiments of the present application, rather than all of the embodiments. Based on the embodiments in the embodiments of the present application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the embodiments of the present application.

[0058] The terms used in the embodiments of the present application are only for the purpose of describing specific embodiments, and are not intended to limit the embodiments of the present application. The singular forms "a", "said" and "the" used in the embodiments of this application and the appended claims are also intended to include ...

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 present invention relates to a method and device for generating a web front-end star model layout, and an electronic device. The specific method includes: sorting the dimension table, dividing the sorted dimension table into a left column and a right column; obtaining The height and width data of the dimension table determine the maximum width as the column width of the column, and determine the column height of the column according to the sum of the heights of each dimension table and the preset vertical interval data; according to the width and height data of the column , the preset vertical interval and horizontal interval data, as well as the width and height data of the fact table, determine the width data and height data of the display area; arrange the fact table in the center of the display area, and generate the dimension table and the left column according to the sorting Dimension table for the right column. The present invention can calculate the position of each table when arranged according to the star model according to the association relationship between the fact table and the dimension table and the fact table and the dimension table, automatically realize the layout of the star model, and improve the development efficiency.

Description

technical field [0001] The present invention relates to the technical field of data visualization, in particular to a method and device for generating a web front-end star model layout, and electronic equipment. Background technique [0002] The fact table is a table that records structured data that describes facts. It is used to record the full amount of information on the content of the analysis, including the specific elements of each event, as well as specific events, such as bank transaction information, order information, etc.; dimension table It is the code table referenced by the fact table, which is the description information of the elements of the event in the fact table, and represents the angle from which the user observes the transaction, such as bank account, order customer, etc. [0003] The star schema is the simplest and most commonly used data model. It consists of a fact table (FactTable) and a set of dimension tables (DimensionTable). The fact table is ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/26
CPCG06F16/2282G06F16/26
Inventor 潘健林沛欣黄应棣卢超许洁斌
Owner GUANGZHOU XUANWU WIRELESS TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap