Web front-end star model layout generation method and device and electronic equipment

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

Active Publication Date: 2021-12-31
GUANGZHOU XUANWU WIRELESS TECH CO LTD
View PDF11 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
  • Web front-end star model layout generation method and device and electronic equipment
  • Web front-end star model layout generation method and device and electronic equipment
  • Web front-end star model layout generation method and device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] In order to make the purpose, technical solutions and advantages of the present application, the following will be further described in detail below with reference to the accompanying drawings.

[0057] It should be clear that the described embodiments are merely the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application embodiment, one of ordinary skill in the art is in the scope of the present application embodiment without creative labor premise.

[0058] The terms used in the present application examples are for purposes of describing particular embodiments, not intended to limit the embodiments of the present application. "One", "one", "one", "" ",", "" "and" "" as used in the present application embodiment and the appended claims, are also intended to include many forms unless the context clearly represents other meanings. It should also be understood that the terms "and / or" as used herein refer to any...

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 relates to a web front-end star model layout generation method and device and electronic equipment. The method specifically comprises the steps of sorting a dimension table, and dividing the sorted dimension table into a left column and a right column; obtaining height and width data of the dimension table in each column, determining the maximum width as the column width of the column, and determining the column height of the column according to the sum of the heights of the dimension tables and preset longitudinal interval data; determining width data and height data of the display area according to the width and height data of the columns, preset longitudinal interval and transverse interval data and width and height data of a fact table; and configuring the fact table in the center of the display area, and generating a dimension table of a left column and a dimension table of a right column according to the sequence. According to the invention, the position of each table arranged according to a star model can be calculated according to the fact table, the dimension table and the incidence relation between the fact table and the dimension table, the layout of the star model is automatically realized, and the development efficiency is improved.

Description

Technical field [0001] The present invention relates to the technical field of data visualization, and more particularly to a method and apparatus for generating a star model layout of a web front end. Background technique [0002] The fact table is a table that records the structured data describing the facts. The full amount of information used to record the contents of the analysis, containing the specific elements of each event, and the specific things, such as bank transaction information, order information, etc .; dimension table The code table referenced by the fact table is the description information of the elements of the event in the fact table, which represents the perspective of the transaction, such as a bank account, order customer, etc. [0003] Star model is the simplest data model, which consists of a fact table (DimensionTable) and a set of dimensions (DimensionTable), with the fact table, all dimension tables directly connected to the fact table, draw it out T...

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 Applications(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