Dynamic architecture expansion method based on Fibonacci sequence

The invention provides an architecture dynamic expansion method based on a Fibonacci sequence. The expansion method comprises the following steps: S1, estimating a total data volume and a single table data volume; s2, selecting a number n, selecting a numerical value m before the n in the Fibonacci...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZOU PENG, MA QIAN, ZHAO RUILAN
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 provides an architecture dynamic expansion method based on a Fibonacci sequence. The expansion method comprises the following steps: S1, estimating a total data volume and a single table data volume; s2, selecting a number n, selecting a numerical value m before the n in the Fibonacci sequence, and establishing a physical table of the number n-m; s3, performing modulo + 1 on the modulo field according to the selected value, judging whether the modulo field is greater than m, and skipping if the modulo field is greater than the number generated by value selection; and S4, when the business is developed and the data volume is expanded, forward expansion is carried out. The resource investment is saved, the dynamic expansion capability is maintained, and the larger the selected initial data is, the stronger the expansion capability is. 本发明提供的一种基于斐波那契数列的架构动态扩展方法,所述扩展方法包括:步骤S1:估算总数据量和单表数据量;步骤S2:选取数字为n,选取斐波那契数列中,n的前一位的数值m,建立n-m数量的物理表;步骤S3:对取模字段按选取值取模+1,并判断是否大于m,大于取值选取生成的编号,小于等于跳过;步骤S4:业务发展,数据量扩大时,向前扩展