We will discuss three recent classification results over a commutative Noetherian ring R: the classification of compactly generated t-structures in the unbounded derived category D(Mod-R), the classification of tilting and cotilting classes in the module category Mod-R, and the classification of resolving subcategories of the category P^(