DBMS Data Types

What are the differencess between: structured, unstrcutured, transactional and relational data

Posted by Eirik on 4 Mar, 2024
  1. 結構化數據 (Structured Data):

    • 結構化數據是以固定格式和結構存儲的數據。通常,結構化數據可以使用表格或者數據庫中的行和列來表示。
    • 例子:關係型數據庫中的表格、Excel 試算表等都是結構化數據的示例。例如,一個包含員工姓名、部門和工資的表格就是結構化數據。
  2. 非結構化數據 (Unstructured Data):

    • 非結構化數據沒有固定的格式,也沒有預定的結構,它以自然的、無結構的形式存在。
    • 例子:電子郵件、社交媒體帖子、圖像、音頻和視頻文件都是非結構化數據的示例。例如,一篇部落格文章或一段影片中的文字就是非結構化數據。
  3. 交易數據 (Transactional Data):

    • 交易數據是記錄交易或事件發生的數據,通常包括日期、時間、金額等信息。這些數據用於跟蹤和分析業務或組織的交易活動。
    • 例子:在零售業中,每一次銷售交易的記錄都是交易數據。每筆訂單的日期、客戶信息、購買商品以及支付金額等都可以作為交易數據。
  4. 關聯數據 (Relational Data):

    • 關聯數據是指數據之間存在著明確的關係或連接,這些關係通常可以通過鍵值或共同特徵來確定。
    • 例子:在關聯型數據庫中,不同表格之間的關聯就是一種關聯數據。例如,一個包含員工信息的表格和一個包含部門信息的表格可以通過員工所在部門的鍵值來關聯。

總結來說:

  • 結構化數據具有明確的格式和組織
  • 非結構化數據則沒有固定的結構
  • 而交易數據則是關於事件或交易的記錄
  • 關聯數據則描述了數據之間的連接和關係

  1. Structured Data: Structured data is data stored in a fixed format and structure. Typically, structured data can be represented using tables or rows and columns in a database. Example: Tables in a relational database, Excel spreadsheets, etc., are examples of structured data. For instance, a table containing employee names, departments, and salaries is structured data.

  2. Unstructured Data: Unstructured data lacks a fixed format and structure; it exists in a natural, unorganized form. Example: Emails, social media posts, images, audio, and video files are examples of unstructured data. For example, the text within a blog post or a segment of text within a video constitutes unstructured data.

  3. Transactional Data: Transactional data records transactions or events occurring, typically including date, time, amount, etc. This data is used to track and analyze business or organizational transaction activities. Example: In retail, records of each sales transaction are transactional data. Details like the date, customer information, purchased items, and payment amount are examples of transactional data.

  4. Relational Data: Relational data refers to data with explicit relationships or connections between them, often identified through keys or common attributes. Example: In a relational database, relationships between different tables constitute relational data. For instance, a table containing employee information and another table containing department information can be related through the key value representing the employee’s department.

In summary,

  • Structured data has a clear format and organization.
  • Unstructured data lacks a fixed structure.
  • Transactional data pertains to records of events or transactions.
  • Relational data describes connections and relationships between data.