Study Final contin Flashcards
What is the definition of structured Data, Give an example of where it is used.
This is data that is highly organized, stored in rows and columns and easily searchable using SQL. Think Spreadsheets and Databases with tables.
It is used in relational databases like MySql
What is Semi-Structured Data and give an example of where it is used…
Semi-Structured data is data that has some organization but doesn’t fit neatly into tables: Often stored in formats like JSON and XML.
It is used in nosql databases like MongoDB
Definition of Unstructured Data and give an example of where it is used
This is data without a predefined format which makes it hard to store and analyze.
Eg. Videos, Audio Files, Images, Word Texts likes emails.
It is used in Big Data Systems like Hadoop.
What is a noSQl database
This is a type of database designed to handle unstructured and semi-structured types of data. They provide flexibility in data storage and retrieval, making them ideal for modern applications with varied and rapidly changing data requirements.
What are Column-oriented databases better suited at?
They are better suited for large-scale analytical queries and write-heavy workloads. best used in Real-Time Data Processing
What are Document-oriented databases better suited for?
They are better suited for applications that need flexible data models or store nested, complex data. best used in e-commerce catalogs.
In MongoDB, primary key-foreign key relationships can be achieved by
Manually imbedding or referencing documents
Write A paragraph on how NOSQL and RDBMS differ from each other
NoSQL and RDBMS differ in data structure and scalability. RDBMS uses structured, tabular data with a fixed schema, enforcing relationships through primary and foreign keys, while NoSQL supports flexible schemas, storing data as documents, key-value pairs, columns, or graphs. For scalability, RDBMS primarily scales vertically (adding resources to a single server), whereas NoSQL scales horizontally (distributing data across multiple servers), making it better suited for handling big data and high-velocity workloads.
what are three disadvantages of nosql databases?
Lack of Standardization:
Complexity:
Learning Curve:
What are three advantages of nosql databases?
Scalabilty:
Flexibilty:
Big Data Support:
What are three Advantages of RDBMS?
Data Integrity and Consistency:
Mature Technology:
Structured Query Language (SQL):
What are three Disadvantages of RDBMS?
Scalability Limitations:
Rigid Schema:
Complexity with Big Data:
