Patent attributes
An approach is provided for optimizing a system resource of a cloud database. Components of a database system are divided into micro-systems according to functions and execution levels. A cluster analysis of the micro-systems and an analysis of workload patterns are performed. Different combinations of the micro-systems are generated. Images of the micro-systems and of the different combinations of the micro-systems are generated. A query is received and analyzed at a current layer specifying a set of micro-systems specified by a function of the database system. Service(s) associated with micro-system(s) specified by next layer(s) are pre-loaded and activated. A partial execution of the query is performed and a result of the query is generated at a selected edge or client side, where the selection is based on the analysis of the workload patterns.
