Exam (elaborations)
Structured and Unstructured Data and NoSQL Databases 100% Verified
- Course
- Institution
Structured and Unstructured Data and NoSQL Databases 100% Verified...
[Show more]
Content preview
Structured and Unstructured Data and NoSQLDatabases 100% Verified
Structured data (also called relational data)
has a predefined data model. It can be mapped into prenamed fields. A US ZIP code can
be stored as a five digit string (example: 90210), a State as a two-character
abbreviation, such as CA, and so on.
Structured definition 2
Data that is the easiest to search and organize, since it is normally confined in rows and
columns, and its elements can be mapped into fixed pre-defined fields, is called
structured data. can follow a data model a database designer creates; entities can be
grouped together to form relations, and this makes structure databases easy to store,
analyze, and search; until recently, it was the only data easily usable for businesses.
Structured data is easily _______________________ and
_________________________________________.
easily stored and retrieved in a traditional relational database where the management
system applies logic to ensure information is in the correct format as it is written to disk.
structure data examples
Examples of structured data include financial data such as accounting transactions,
address details, demographic information, star ratings by customers, machines logs,
location data from smart phones and smart devices, etc.
Unstructured data
does not have a pre-defined data model. Thus, it cannot easily be categorized into the
pre-defined tables and rows of a relational database.
Satellite imagery, audio files, video files, or even emails may share common
characteristics, but these rich data types are not easily ingested, processed, or
analyzed with conventional database-related systems.
,Unstructured data defines 2
is information that cannot be stored in a row-column database and doesn't have an
associated data model. For instance, the text of an email message. The fact that it
wasn't structured made unstructured data more complicated to search, manage and
analyse, which became the reason companies widely rejected unstructured data until
recently when the recent proliferation of artificial intelligence and machine learning
algorithms made this a little easier to process.
Examples of unstructured data
Other examples of unstructured data include photos, video and audio files, text files,
social media content, satellite imagery, presentations, PDFs, open-ended survey
responses, websites and call center transcripts/recordings.
unstructured data is stored where?
usually in data lakes, NOSQL databases, application and date warehouse
difference b/t structured and unstructured.
start with structured
every record conforms to a pre-defined data model; if the arriving data does not meet
those definitions, then it cannot be stored without correction or truncation. Because of
this, structured data is often very verbose. This does have the advantage of being
extremely easy to parse and search using traditional software.
difference b/t structured and unstructured.
start with unstructured
is more ambiguous. Without a predefined data model, you can store a far broader range
of rich data including images, sound, video, and text. As the scope for storage increases
and as data becomes more complex and dynamic, so too does the difficulty with which
you can search and analyze that information. Thankfully, modern data management
platforms like MongoDB Atlas exist that make storing and processing large volumes of
unstructured data easier than ever.
, Because of its relative simplicity, structured data is well suited to the
______________________________________________.
Because of its relative simplicity, structured data is well suited to the relative limitations
of relational database systems.
Large data estates can be housed in a ______________?
data warehouse - as long as the information continues to meet the inflexible database
schema
Unstructured data can be, and is, stored in a _________________________.
Unstructured data can be, and is, stored in a number of places
Data warehouses and data lakes have become key for .
to big data analytics, allowing a way to scale overall capacity by using inexpensive
commodity storage.
For analyzing complex data types, or for advanced data analysis, .
NoSQL databases offer a way to more efficiently manage and search across disparate
data sets.
Structured data is best suited to ______________________________ that rely on
_______________________________________.
Structured data is best suited to process-driven applications that rely on specific
information presented in a known, consistent format
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $24.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75057 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now