Database system with user-directed application-side control of data movement among storage tiers

A method comprising:

• configuring a daemon on a database node to communicate with a plurality of storage devices on a plurality of storage tiers of a database system;
• and
• further configuring the daemon to implement storage tiering control functionality in response to a command-based user-specified dynamic data selection of at least one database object subset and a tier imperative for at least first and second storage tiers comprising respective disjoint subsets of the plurality of storage tiers based on said user-specified data selection and tier imperative, wherein said command-based user-specified dynamic data selection comprises one or more verb phrases to dynamically generate said at least one database object subset from data in an active memory of said database node, wherein said daemon executes in said active memory;
• the daemon thereby being configured to dynamically control movement of said at least one dynamically generated database object subset between the at least first and second storage tiers in response to said command-based user-specified dynamic data selection and tier imperative.

A database system comprising:

• a database node;
• a plurality of storage tiers having at least first and second storage tiers comprising respective disjoint subsets of the plurality of storage tiers;
• and
• a daemon on said database node to communicate with a plurality of storage devices on said plurality of storage tiers;
• the daemon further configured to implement storage tiering control functionality in response to a command-based user-specified dynamic data selection of at least one database object subset and a tier imperative for said at least first and second storage tiers, wherein said command-based user-specified dynamic data selection comprises one or more verb phrases to dynamically generate said at least one database object subset from data in an active memory of said database node, wherein said daemon executes in said active memory;
• and
• the daemon thereby being configured to dynamically control movement of said at least one dynamically generated database object subset between the at least first and second storage tiers in response to said command-based user-specified dynamic data selection and tier imperative.