Here are some of the key data management systems and tools organizations use:
- Databases: Relational databases like SQL Server and Oracle as well as NoSQL databases like MongoDB store and organize data.
- Data Warehouses: Central repositories that aggregate structured data from multiple sources for reporting and analysis. Examples include Snowflake and Amazon Redshift.
- Data Lakes: Massive storage pools that hold vast amounts of structured and unstructured data. Options include AWS Lake Formation and Azure Data Lake.
- ETL Tools: Extract, transform, load (ETL) tools like Informatica, Talend and Matillion prepare and move data for business use.
- Data Catalogs: Inventory data assets and attributes. Examples are Alation Data Catalog and Collibra Catalog.
- Master Data Management: Consolidates versions of critical business data into single master datasets. eg Magnitude MDM.
- Data Quality Tools: Validate, cleanse and monitor data integrity. Sisense Data Quality is one example.
- Data Governance Tools: Set data policies, access controls and procedures. Examples include erwin Data Intelligence and IDERA Data Governance.
- Data Privacy/Security: Encrypts data and provides access control like Privitar Data Privacy Platform and Netskope.
