Course4-M1

Question 1

Broadly, we can categorize data into three main types, ____, ____, and ____.

Ref

Answer 1

structured,
unstructured
semi-structured

Question 2

What are some examples of unstructured data?

Ref

Answer 2

unstructured data lacks a specific format or organization. It doesn’t conform to any predefined rules or sequences, making it challenging to process and analyze using traditional methods. Examples of unstructured data include text files contain free-form text documents without a predefined structure. Media files include images, audio, and video. Web pages, main content, such as text, images, and multimedia is often unstructured despite potentially structured elements like HTML tags. Social media content encompasses posts, tweets, and other updates with mixed text, images, and links.

Question 3

What are some examples of semi-structured data?

Ref

Answer 3

This type of data possesses some organizational properties but does not adhere to a strict tabular structure. It often employs hierarchical structure or tags to organize information, providing a balance between flexibility and structure.
Examples of semi-structured data include** JSON files** contain arrays and objects using specific tags or keys to mark different data elements. XML documents define data structure using tags, attributes, and schema. Emails have structured fields; to, from, subject but unstructured message bodies.

Question 4

Data’s varied types and structures demand appropriate storage solutions with relational databases serving ____(OLAP/OLTP) needs, ____(OLAP/OLTP) systems enabling complex analytics, and non-relational databases providing flexibility for diverse data.

Ref

Answer 4

OLTP
OLAP

What is OLAP? OLAP, or online analytical processing, is technology for performing high-speed complex queries or multidimensional analysis on large volumes of data in a data warehouse, data lake or other data repository.

When to use OLAP vs. OLTP. Online analytical processing (OLAP) and online transaction processing (OLTP) are two different data processing systems designed for different purposes. OLAP is optimized for complex data analysis and reporting, while OLTP is optimized for transactional processing and real-time updates