Interesting FactsSome interesting facts about Science, some about D|ONE and some "Interesting, but useless information" (IBUI).

Number Category
142857

This number rotates itself:

  142857 X 1 = 142857

  142857 X 2 = 285714

  142857 X 3 = 428571

  142857 X 4 = 571428

  142857 X 5 = 714285

  142857 X 6 = 857142

 

 

Scientific

250

In Mandarin the number 250 (Er Bai Wu) means "moron". Nobody would accept a price or a salary at 250. Explanations about the origin of this expression differ, but a good interpretation seems "on a scale of 1000 you are 250".

Trivia

4

Number of Poker Events per year organized by D|ONE.

D|ONE

4

The great pyramids in Egypt have moved 4 kilometers with the earth's crust since they were built.

Trivia

3

Number of eyes of the Tuatara lizard (lives in in New Zealand).

Interesting but useless info (IBUI)

4

Four colors are needed to color a map so that no two adjacent regions get the same color (four-color theorem).

Scientific

4

Four half-moves are needed for the fastest possible checkmate (known as the Fool's mate).

Trivia

0.89

Schwarzschild radius of the earth. Compacted to 0.89 cm, the earth will become a black hole.

Interesting but useless info (IBUI)

626

Number of compositions by Mozart listed in the Köchel catalogue.

Trivia

1193, 1931, 3119, 9311

First 4 digits Circular Prime Numbers.

Scientific

1729

On top of being the famous Hardy-Ramanujan number, and being a sphenic number, 1729 is also the third Carmichael number, after 561 and 1105. A Carmichael number is an integer n where bn-1 = 1 (mod n) for all b that are prime relative to n. All prime numbers have the Carmichael property.

Scientific

41444351010

Dial this number if you have a need for Data Insight.

D|ONE

9411

Distance in kilometers between both D|ONE offices, San Mateo and Zurich.

D|ONE

19

The G-20 is made up of the finance ministers and central bank governors of 19 countries. www.g20.org

Trivia

7

Number of different countries of origin for D|ONE team members.

D|ONE

36y 130d 3h

Average age of D|ONE team members.

D|ONE

9'721'368

The largest decimal number where you can eliminate any digit, and the number formed by the remaining digits are divisible by the eliminated digit.

Interesting but useless info (IBUI)

4

Number 4 is considered an unlucky number in Chinese, Korean, and Japanese cultures because it is nearly homophonous to the word "death". In order not to take unnecessary risks, in most hotels in Hong Kong or Mainland China there is no fourth floor to choose in elevators (caring also about superstitious Westerners, the 13th floor is usually skipped as well).

Trivia

0

Number of uninteresting natural numbers: If there were uninteresting numbers, there would be a smallest uninteresting number - but the smallest uninteresting number is itself interesting by being so, producing a contradiction.

Trivia

16005

amount of revenue in $ Microsoft made in its first year (D|ONE: 114'000 CHF)

D|ONE

10

Number of clients representing 80% of D|ONE revenues.

D|ONE

111'111'111

First number, consisting only of digits 1, which, squared, does not produce a symmetrical result like 11x11 does.

Interesting but useless info (IBUI)

30

30% Probability that the leading digit in many lists of numbers starts with digit 1 (12.5% that it starts with 3). Called Benford's Law. Detected because some pages in logarithm tables looked used more than others. Used in forensic accounting, specifically in fraud detection.

Scientific

4444

Pragmatic as the Chinese are, if you take the the "4" (see 4) issue head-on you may turn it into a blessing: 4 times 4 i.e. 4444 means: may you be 4 times lucky in all four seasons.

Trivia

1729

Besides being the Hardy-Ramanujan number, 1729 is also a sphenic number because it is the product of three different primes (7*13*19).

Scientific

520

If you re-arrange things just a little bit, fate may change a lot: Swapping 2 and 5 (see 250) means a significant upgrade: In Mandarin Chinese the number 520 means, "I love you". To make an extra you may also say "520 1314": I love you forever... "13" meaning "this life", "14" meaning "until death" (or "until next life? according to religious preferences).

Trivia

2005

Year when D|ONE was established.

D|ONE

0.000154

Probability to get a royal flush in Texas hold 'em Poker.

Trivia

1729

The Hardy-Ramanujan number. The British mathematician G. H. Hardy told this story about the Indian mathematician Srinivasa Ramanujan: "I remember once going to see him when he was ill at Putney. I had ridden in taxi cab number 1729 and remarked that the number seemed to me rather a dull one, and that I hoped it was not an unfavorable omen. "No," he replied, "it is a very interesting number; it is the smallest number expressible as the sum of two cubes in two different ways." This anecdote gave this number its name.


    9^3 + 10^3 = 1729
    1^3 + 12^3 = 1729

Scientific

42

This number comes up in many discussions among certain professional circles (e.g., programmers). We are not sure why but we have our best analysts working to find out ;-)

Trivia

313

Car number plate of Donald Duck.

Trivia

55

55% of human DNA is also found in bananas.

Trivia

8.1

Days per employee per year invested in training.

D|ONE

«D|ONE is a premium consultancy and professional services provider in the exciting world of Business Intelligence.»

Dr. Stamatis Stefanakos, Managing Consultant

Fresh insight brought to you

2016-04 | Dr. Joonas Asikainen, Dr. Simon Hefti, Ruben Wolff, Hans Peter Gränicher

Results of a real-life benchmark at the SQL Server 2016 vs Sybase IQ, SAP Hana and Oracle

Data Driven Value Creation has become a key success factor in all industries; at the same time, it poses many challanges on the data, technology, impact and cultural levels. In this talk, we focus on a technical question: which database to rely on for the next 3 - 5 years in a specific client context. Luckily, data helps for this decision, too.

(PDF, 1.9 MB)

2016-01 | Dr. Joonas Asikainen

Topological sorting and the ETL process

Consider the data warehouse of Figure 1. It consists of a hundred tables with over two hundred relations. The question any ETL developer will ask is, in which order do I load the tables?

(PDF, 716kB)

2016-01 | Dr. Joonas Asikainen

HyperLogLog - Probabilistic cardinality estimation

In this paper we present a summary of the HyperLogLog algorithm, highlight a selection of applications where it proves useful and provide with a Java code implementation. Further, while the full theory behind the algorithm and the proof of the details is beyond the intended scope, we point out a few interesting intuitive considerations by the authors.

(PDF, 895kB)

2015-03 | Catalin Ehrmann

Data modelling patterns used for integration of operational data stores

Modern enterprise software development and data processing approaches have been divided into separate paths in the last decade. Recently, the two communities have realized the benefit of sharing expertise across domains. In this paper, we will explain how a clever mix of data warehouse and OLTP (Online Transaction Processing) patterns create a robust operational system and discuss the advantages and disadvantages of this approach.

(PDF, 982kB)

2014-06-23 l Dr. Asli Yaman

Leistung von modernen Datenbanken

Spaltenbasierte In-Memory Datenbanken haben aufgrund ihrer hervorragenden Abfrageleistung schnell an Boden gewonnen. An der TDWI München 2010 berichteten wir über die Performanz solcher Systeme unter realistischen Bedingungen. Jetzt, 4 Jahre später, ist es Zeit diese Messungen mit einem Standard-Kundendatenmodell und synthetischen Daten zu wiederholen.

In einem Vortrag an der TDWI 2014 präsentierten und diskutierten wir die Performanz-Messergebnisse für einige verbreitete und auch aufkommende Produkte wie Oracle und SQL Server, HANA, Sybase IQ und Pivotal.

 

(PDF, 766kB)

2013-06 l Joël Ineichen

How to understand an existing DWH system; Step 1: Mise en place

In a series of three articles, we would like to explain what you should do in order to obtain a solid overview of an existing DWH system quickly. This first part cares about organizing the mise en place prior to our cooking. Slogan of the day: Get the tools ready. Result of the day: We are ready to cook.

(PDF, 1400kB)