Check patentability & draft patents in minutes with Patsnap Eureka AI!

A method and device for determining time dimension table data

A time dimension and dimension table technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of large amount of report data, no algorithm for calculating the lunar calendar, and no lunar calendar fields, etc., to improve query efficiency, The effect of fast filling

Inactive Publication Date: 2018-08-07
PEKING UNIV FOUNDER GRP CO LTD +1
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a method and device for determining time dimension table data, which is used to solve the problem of incomplete time setting and no lunar calendar field in the prior art, and there is no algorithm for calculating the lunar calendar in the prior art, resulting in a large amount of report data and difficult query. inefficient technical issues

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 determining time dimension table data
  • A method and device for determining time dimension table data
  • A method and device for determining time dimension table data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] An embodiment of the present invention provides a method for determining the time dimension table data, please refer to figure 1 , figure 1 The flow chart of the method for determining the time dimension table data, such as figure 1 As shown, the method includes:

[0032] Step 101: Create a time dimension table, the dimension table includes a field of the Western calendar date and a field of the lunar calendar date corresponding to the Western calendar date;

[0033] Step 102: Using a date function to write all Western calendar date data from the start date to the end date and their respective corresponding lunar calendar date data into the time dimension table.

[0034] In step 101, create a time dimension table, define multiple time and date fields, in figure 1 The fields of the dimension table in the method embodiment only show the field of the Western calendar date and the field of the lunar calendar date corresponding to the Western calendar date, but in practic...

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 provides a method and device for determining time dimension table data. The method comprises the steps that a time dimension table is created, wherein the time dimension table includes fields of western calendar dates and fields of lunar calendar dates corresponding to the western calendar dates; data of all western calendar dates from the start date to the end date, and data of the lunar calendar dates corresponding to the western calendar dates are written to the time dimension table through date functions.

Description

technical field [0001] The invention relates to the field of business intelligence analysis services, in particular to a method and device for determining time dimension table data. Background technique [0002] In the existing business intelligence analysis service project, there is no hierarchical structure when adding the time dimension table, and only the year, month or week can be queried separately. When generating report queries, multiple drop-down list conditions are used to select time. [0003] In addition, in the time dimension table of the prior art, the time setting is not comprehensive, there are no fields such as the lunar calendar, ten days, etc., the report data volume is large, the query efficiency is low, the date and time parameter settings are not detailed enough, and the program expansion is difficult, so when using it, the efficiency is low. Very low, it is necessary to add an algorithm to obtain time periods such as ten days, and there is no algorithm...

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): G06F17/30
CPCG06F16/248
Inventor 任艳方
Owner PEKING UNIV FOUNDER GRP CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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