← All topics

Learn free · topic 288

Data Sources

Data Source is essentially where information comes from. It can be anything like a list of customer names in a spreadsheet, sales details in a company's database, or even tweets on social media. These sources can vary in size and complexity, ranging from simple text files to complex, large-scale databases.

In Information Systems, Data Sources can vary. Here are some examples:

  • Databases: This is one of the most common data sources. It can be a relational database like MySQL, PostgreSQL, or Oracle, where data is organized in tables, or a NoSQL database like MongoDB or Cassandra, which may store data in more flexible formats.
  • Business or Enterprise Applications like CRM and ERP Systems: Systems like Salesforce, SAP, or Oracle ERP are used by organizations to manage customer and business operations data. They serve as rich data sources for analytics and business intelligence.
  • Spreadsheet Files: Files like Microsoft Excel or Google Sheets are common sources of data, especially in smaller scale or less technical environments. They store data in tabular form and are widely used for various analytical purposes.
  • Flat Files: These include CSV (Comma Separated Values) or Text files etc. They are simple text files used to store data in a structured format and are commonly used for data exchange and storage.
  • Cloud Storage: Services like Amazon S3, Google Cloud Storage, or Microsoft Azure Blob Storage. These platforms are used to store large amounts of data in the cloud and are accessible from anywhere.
  • Logs: System logs, application logs, web server logs, etc., are used for monitoring, debugging, and security analysis. They provide raw data about the usage and performance of various systems. They can serve as a Data Source for monitoring applications.

In summary, a data source is where your information comes from. It is an important concept in many activities like Data Integration, Data Analytics or Data Science (but not only). Data integration brings together your different sources. Data analytics helps you understand what your data is telling you, and data science uses more complex methods to uncover deeper insights and make predictions based on the data coming from your Data Sources.

Finished reading? Test yourself with 10 questions on this topic.

Go to the questions →

From I Am Datapedia! by Mustafa Qizilbash, published here free by the author. Nothing about your reading is stored.