Database-based ultra-width table processing method and device and storage medium

The invention discloses an ultra-width table processing method and device based on a database and a storage medium, and the method comprises the following steps: selecting the maximum field number of a data analysis table according to the maximum field number standard of a single table of the databa...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: JIANG TAILIANG
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention discloses an ultra-width table processing method and device based on a database and a storage medium, and the method comprises the following steps: selecting the maximum field number of a data analysis table according to the maximum field number standard of a single table of the database; counting the field number of the data analysis table; counting the number of basic fields of the data analysis table; calculating the field number of each group of the data analysis table; calculating the number of groups of the data analysis table; redesigning a table structure of the data analysis table based on a field grouping strategy; designing a table structure of a field analysis definition table based on a field grouping strategy; and performing joint association analysis on the grouped data analysis table and the newly designed field analysis definition table, and restoring to obtain all original data dimension fields of the data analysis table. According to the method and the device, the processing c