Explain the concept of table partitioning in databases and its advantages.

Partitioning tables in databases is a method of dividing a large table into smaller, logically related parts (partitions), which are stored separately but perceived as a single entity.

Advantages of partitioning:

• Improved performance: queries that only involve a part of the data are processed faster because a smaller volume is scanned.
• Simplified data management: old partitions can be easily archived or deleted without affecting other data.
• Increased availability: if one partition fails, others remain accessible.
• Storage optimization: different partitions can be stored on different media considering speed and cost requirements.

Example: a log table can be partitioned by months — each partition stores data for one month.