Menu
I am confused between csv is structured data or a semi-structured data. Like RDBMS is a structured data with relation but csv doesnt have relations. I am not able to find exact answer.
915
CSV, XML and JSON documents are semi-structured documents. NoSQL databases are considered as popular to handle semi-structured data.
A CSV file, for example, is a text file, which is not structured data. But it's a trivial task to import a CSV file into a relational database, at which point the values in the file become suitable for queries in SQL. Everything else is unstructured data.
Unstructured data is a collection of different types of data that are stored in the file format they were created in and not organized into a well-defined schema. Usually text-heavy, unstructured data cannot be stored in cells or in a file structure, such as a CSV (comma separated value) or a tab-delimited text file.
A CSV is a comma-separated values file, which allows data to be saved in a tabular format. CSVs look like a garden-variety spreadsheet but with a . csv extension. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets.
As far I can say, CSV with constant columns and rows (two dimensions)can be mentioned as structured data as it can be easily queried. But when there are multi-dimensional columns and rows, then it can be considered as semi-structured data.
200
CSV files are Semi- Structured files. Semi structured data does not have the same level of organization as structured data like relational database. Here the data contain elements that can separate the data into various hierarchies.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
