Structured

Structured data, as the name implies, indicates datasets that have a defined organizational structure such as Microsoft Excel or CSV files. In pure database terms, the data should be representable using a schema. As an example, the following table representing the top five happiest countries in the world published by the United Nations in its 2017 World Happiness Index ranking would be an atypical representation of structured data.

We can clearly define the data types of the columns--Rank, Score, GDP per capita, Social support, Healthy life expectancy, Trust, Generosity, and Dystopia are numerical columns, whereas Country is represented using letters, or more specifically, strings.

Refer to the following table for a little more clarity:

Rank Country Score GDP per capita Social support Healthy life expectancy Generosity Trust Dystopia
1 Norway 7.537 1.616 1.534 0.797 0.362 0.316 2.277
2 Denmark 7.522 1.482 1.551 0.793 0.355 0.401 2.314
3 Iceland 7.504 1.481 1.611 0.834 0.476 0.154 2.323
4 Switzerland 7.494 1.565 1.517 0.858 0.291 0.367 2.277
5 Finland 7.469 1.444 1.54 0.809 0.245 0.383 2.43

 

World Happiness Report, 2017 [Source: https://en.wikipedia.org/wiki/World_Happiness_Report#cite_note-4]

Commercial databases such as Teradata, Greenplum as well as Redis, Cassandra, and Hive in the open source domain are examples of technologies that provide the ability to manage and query structured data.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.144.65