Database and Data Management
Data management encompasses the practices and technologies for collecting, storing, organising, and maintaining data.
Database Management Systems
A DBMS manages databases with data independence, concurrent access, security, and integrity. Relational databases use SQL. NoSQL databases handle unstructured data.
Data Warehouse
A data warehouse consolidates data for analysis using ETL. Star schema and snowflake schema organise tables.
Data Mining
Discovers patterns: classification, clustering, association rules, regression. KDD process guides projects.
Big Data
3 Vs: Volume, Velocity, Variety. Technologies: Hadoop, Spark, NoSQL.
Data Quality
Accuracy, completeness, consistency, timeliness. Data governance establishes policies.
Summary
Data management is central to MIS for informed decision-making.