Snowflake schema

en

WikiRank.net
ver. 1.6

Snowflake schema

Quality:

Snowflake schema - logical arrangement of computing tables in a multidimensional database. Article "Snowflake schema" in English Wikipedia has 28 points for quality (as of August 1, 2024). The article contains 4 references and 9 sections. The article also contains quality flaw template, which reduce quality score.

This article has the best quality in Czech Wikipedia. However, this article is the most popular in English version.

Since the creation of article "Snowflake schema", its content was written by 77 registered users of English Wikipedia and edited by 182 registered Wikipedia users in all languages.

The article is cited 60 times in English Wikipedia and cited 174 times in all languages.

The highest Authors Interest rank from 2001:

  • Local (English): #62681 in January 2006
  • Global: #55537 in May 2004

The highest popularity rank from 2008:

  • Local (English): #31566 in May 2015
  • Global: #61263 in May 2015

There are 13 language versions for this article in the WikiRank database (of the considered 55 Wikipedia language editions).

The quality and popularity assessment was based on Wikipédia dumps from August 1, 2024 (including revision history and pageviews for previous years).

The table below shows the language versions of the article with the highest quality.

Languages with the highest quality

#LanguageQuality gradeQuality score
1Czech (cs)
Schéma sněhové vločky
32.8038
2Norwegian (no)
Snøflakmodell
29.0597
3English (en)
Snowflake schema
27.9979
4Ukrainian (uk)
Схема сніжинки
18.8371
5German (de)
Schneeflockenschema
14.8566
6Japanese (ja)
スノーフレークスキーマ
13.1506
7Hebrew (he)
סכמת פתית השלג
12.5384
8Polish (pl)
Schemat płatka śniegu
9.9745
9Spanish (es)
Esquema en copo de nieve
6.1616
10Korean (ko)
눈송이 스키마
4.7784
More...

The following table shows the most popular language versions of the article.

Most popular in all the time

The most popular language versions of the article "Snowflake schema" in all the time
#LanguagePopularity awardRelative popularity
1English (en)
Snowflake schema
1 673 123
2Spanish (es)
Esquema en copo de nieve
177 120
3German (de)
Schneeflockenschema
155 238
4Russian (ru)
Схема снежинки
147 635
5Polish (pl)
Schemat płatka śniegu
33 424
6Italian (it)
Schema a fiocco di neve
18 891
7Hebrew (he)
סכמת פתית השלג
12 443
8Korean (ko)
눈송이 스키마
7 963
9Czech (cs)
Schéma sněhové vločky
7 128
10Japanese (ja)
スノーフレークスキーマ
6 361
More...

The following table shows the language versions of the article with the highest popularity in the last month.

Most popular in July 2024

The most popular language versions of the article "Snowflake schema" in July 2024
#LanguagePopularity awardRelative popularity
1English (en)
Snowflake schema
3 303
2Russian (ru)
Схема снежинки
639
3German (de)
Schneeflockenschema
420
4Spanish (es)
Esquema en copo de nieve
363
5Japanese (ja)
スノーフレークスキーマ
86
6Polish (pl)
Schemat płatka śniegu
64
7Hebrew (he)
סכמת פתית השלג
62
8Italian (it)
Schema a fiocco di neve
55
9Korean (ko)
눈송이 스키마
24
10Ukrainian (uk)
Схема сніжинки
22
More...

The following table shows the language versions of the article with the highest Authors’ Interest.

The highest AI

Language versions of the article "Snowflake schema" with the highest Authors Interest (number of authors). Only registered Wikipedia users were taken into account.
#LanguageAI awardRelative AI
1English (en)
Snowflake schema
77
2German (de)
Schneeflockenschema
29
3Russian (ru)
Схема снежинки
13
4Italian (it)
Schema a fiocco di neve
12
5Hebrew (he)
סכמת פתית השלג
11
6Polish (pl)
Schemat płatka śniegu
9
7Spanish (es)
Esquema en copo de nieve
8
8Czech (cs)
Schéma sněhové vločky
6
9Persian (fa)
طرح دانه برفی
4
10Norwegian (no)
Snøflakmodell
4
More...

The following table shows the language versions of the article with the highest Authors’ Interest in the last month.

The highest AI in July 2024

Language versions of the article "Snowflake schema" with the highest AI in July 2024
#LanguageAI awardRelative AI
1Czech (cs)
Schéma sněhové vločky
0
2German (de)
Schneeflockenschema
0
3English (en)
Snowflake schema
0
4Spanish (es)
Esquema en copo de nieve
0
5Persian (fa)
طرح دانه برفی
0
6Hebrew (he)
סכמת פתית השלג
0
7Italian (it)
Schema a fiocco di neve
0
8Japanese (ja)
スノーフレークスキーマ
0
9Korean (ko)
눈송이 스키마
0
10Norwegian (no)
Snøflakmodell
0
More...

The following table shows the language versions of the article with the highest number of citations.

The highest CI

Language versions of the article "Snowflake schema" with the highest Citation Index (CI)
#LanguageCI awardRelative CI
1English (en)
Snowflake schema
60
2Norwegian (no)
Snøflakmodell
47
3Russian (ru)
Схема снежинки
21
4Spanish (es)
Esquema en copo de nieve
10
5German (de)
Schneeflockenschema
7
6Hebrew (he)
סכמת פתית השלג
6
7Korean (ko)
눈송이 스키마
6
8Ukrainian (uk)
Схема сніжинки
6
9Persian (fa)
طرح دانه برفی
5
10Czech (cs)
Schéma sněhové vločky
4
More...

Scores

Estimated value for Wikipedia:
English:
Global:
Popularity in July 2024:
English:
Global:
Popularity in all years:
English:
Global:
Authors in July 2024:
English:
Global:
Registered authors in all years:
English:
Global:
Citations:
English:
Global:

Quality measures

Interwikis

#LanguageValue
csCzech
Schéma sněhové vločky
deGerman
Schneeflockenschema
enEnglish
Snowflake schema
esSpanish
Esquema en copo de nieve
faPersian
طرح دانه برفی
heHebrew
סכמת פתית השלג
itItalian
Schema a fiocco di neve
jaJapanese
スノーフレークスキーマ
koKorean
눈송이 스키마
noNorwegian
Snøflakmodell
plPolish
Schemat płatka śniegu
ruRussian
Схема снежинки
ukUkrainian
Схема сніжинки

Popularity rank trends

Best Rank English:
#31566
05.2015
Global:
#61263
05.2015

AI rank trends

Best Rank English:
#62681
01.2006
Global:
#55537
05.2004

Languages comparison

Important global interconnections

Wikipedia readers most often find their way to information on Snowflake schema from Wikipedia articles about Star schema, Data mart, Online analytical processing, Fact table and OLAP cube. Whereas reading the article about Snowflake schema people most often go to Wikipedia articles on Star schema, Online analytical processing, Fact table, Database normalisation and Third normal form.

Cumulative results of quality and popularity of the Wikipedia article

List of Wikipedia articles in different languages (starting with the most popular):

News from 12 November 2024

On 12 November 2024 in multilingual Wikipedia, Internet users most often read articles on the following topics: Donald Trump, Marco Rubio, Elon Musk, Song Jae-lim, 2024 United States presidential election, Megan Fox, Melania Trump, Gladiator II, ChatGPT, deaths in 2024.

In English Wikipedia the most popular articles on that day were: Microsoft, 2024 United States presidential election, Marco Rubio, Song Jae-rim, Michael Waltz, Kristi Noem, Donald Trump, 2020 United States presidential election, Kash Patel, Tom Homan.

About WikiRank

The WikiRank project is intended for automatic relative evaluation of the articles in the various language versions of Wikipedia. At the moment the service allows to compare over 44 million Wikipedia articles in 55 languages. Quality scores of articles are based on Wikipedia dumps from August, 2024. When calculating current popularity and AI of articles data from July 2024 was taken into account. For historical values of popularity and AI WikiRank used data from 2001 to 2023... More information