BaSit RaZa - Academia.edu (original) (raw)
Papers by BaSit RaZa
One of the primary uses of computer is to reduce cost and manage complexity with increase in effi... more One of the primary uses of computer is to reduce cost and manage complexity with increase in efficiency and performance. Now system complexity is reaching a level that is beyond human ability. With the development of technology, people want to manage complex systems in an efficient and reliable manner. Development of raw computing power and proliferation of computer devices and usage of internet has grown up to exponential rates. This growth and unprecedented levels of complexity is leading towards new direction - autonomic computing. Autonomic features in system increase speed, efficiency, reliability and accuracy with less or no human interaction, ultimately providing error free environment. These autonomic capabilities are important in database management systems (DBMSs). The DBMSs which have the capability to manage and maintain themselves are called autonomic database management systems (ADBMS). The ADBMSs are evolving from last many years. At present most of the activities in DBMS are performed autonomically and have achieved certain level of autonomicity. The paper identified some autonomic shortcomings in commercial DBMSs up to 2002. We made a survey on achievements of autonomic computing against these shortcomings in current DBMSs. For this purpose, we have studied and analyzed IBM DB2, Oracle and Microsoft SQL Server.
The growing complexity of applications, huge data volume and the data structures to process massi... more The growing complexity of applications, huge data volume and the data structures to process massive data are becoming challenging issue. Query optimizer is a major component of a Database Management System (DBMS) that executes queries through different strategies and techniques efficiently. These techniques select the best optimal execution plan from the candidate plans according to the available resources and environment. Traditionally, skilled database administrators are required to tune DBMS for efficient query processing. Recently it has been realized to develop DBMSs having autonomic capabilities. Autonomic DBMS (ADBMS) are now being developed to reduce this dependency on an expensive skilled human resource. The paper analyzes the autonomic capabilities of query optimizers in three wellknown DBMSs -DB2, Oracle and SQL Server being used in the industry. The research is focused to find and earmark those areas in query optimizers where the human intervention is required. Query Optimizers are compares with their autonomic capabilities; explores their strengths and weaknesses; and provides the basis for improving the current state of autonomic computing in query optimizers. The autonomic behavior of query optimizers is observed by designing and executing different queries through experiments and some recommendations are given.
The evolution of computer is started from human dependent to self-management. With the developmen... more The evolution of computer is started from human dependent to self-management. With the development of technology, people want to manage the complex systems in an efficient and reliable manner. Database Management Systems (DBMSs) started from the single user with limited operations; and with the passage of time more functionality is added to meet the need of the users. Maximum number of operations, huge volume and multi-user environment also increased the complexity. Due to complexity and heterogeneity, job of DBAs become difficult and laborious. The solution to these DBMS's problems is self-managing or autonomic DBMS (ADBMS). An ADBMS have the ability to adopt changes according to the environment and available resources without or with less human intervention. This paper examines the three commercial leading DBMSs, IBM's DB2, Oracle by Oracle Corporation and Microsoft SQL Server with respect to autonomic characteristics. On the basis of analysis and other parameters autonomic computing (AC) maturity value is assigned to each autonomic component of three DBMSs. At the end, the evolving status of AC in DBMSs is presented.
Functionality, complexity, heterogeneity and dynamism in computing environment are increasing day... more Functionality, complexity, heterogeneity and dynamism in computing environment are increasing day by day. This enhanced utility of computers has a profound impact on the systempsilas brittleness, manageability and security. Self-management is important in systems, networks, communication as well as in Database Management Systems (DBMSs). Autonomic computing reduces the problems and increases accuracy and efficiency of the DBMSs. Recent years have seen an upsurge in research related to incorporation of autonomic computing within the computing systems. IBM is working on autonomic computing in systems and DBMSs from last many years. The paper discussed the autonomic features and tools in DB2 from the literature available up to 2002. Our paper presents an extension of that paper which covers available autonomic features, components, utilities and tools up till now. A comparison of DB2 with Oracle is presented w.r.t autonomic computing. We have also identified the optional and essential human intervention (HI) in autonomic components, utilities and tools of IBM Universal Database DB2 that reveals the degree of autonomic computing in these.
Human world is becoming more and more dependent on computers and information technology (IT). The... more Human world is becoming more and more dependent on computers and information technology (IT). The autonomic capabilities in computers and IT have become the need of the day. These capabilities in software and systems increase performance, accuracy, availability and reliability with less or no human intervention (HI). Database has become the integral part of information system in most of the organizations. Databases are growing w.r.t size, functionality, heterogeneity and due to this their manageability needs more attention. Autonomic capabilities in Database Management Systems (DBMSs) are also essential for ease of management, cost of maintenance and hide the low level complexities from end users. With autonomic capabilities administrators can perform higher-level tasks. The DBMS that has the ability to manage itself according to the environment and resources without any human intervention is known as Autonomic DBMS (ADBMS). The paper explores and analyzes the autonomic components of Oracle by considering autonomic characteristics. This analysis illustrates how different components of Oracle manage itself autonomically. The research is focused to find and earmark those areas in Oracle where the human intervention is required. We have performed the same type of research over Microsoft SQL Server and DB2. A comparison of autonomic components of Oracle with SQL Server is provided to show their autonomic status.
One of the primary uses of computer is to reduce cost and manage complexity with increase in effi... more One of the primary uses of computer is to reduce cost and manage complexity with increase in efficiency and performance. Now system complexity is reaching a level that is beyond human ability. With the development of technology, people want to manage complex systems in an efficient and reliable manner. Development of raw computing power and proliferation of computer devices and usage of internet has grown up to exponential rates. This growth and unprecedented levels of complexity is leading towards new direction - autonomic computing. Autonomic features in system increase speed, efficiency, reliability and accuracy with less or no human interaction, ultimately providing error free environment. These autonomic capabilities are important in database management systems (DBMSs). The DBMSs which have the capability to manage and maintain themselves are called autonomic database management systems (ADBMS). The ADBMSs are evolving from last many years. At present most of the activities in DBMS are performed autonomically and have achieved certain level of autonomicity. The paper identified some autonomic shortcomings in commercial DBMSs up to 2002. We made a survey on achievements of autonomic computing against these shortcomings in current DBMSs. For this purpose, we have studied and analyzed IBM DB2, Oracle and Microsoft SQL Server.
The growing complexity of applications, huge data volume and the data structures to process massi... more The growing complexity of applications, huge data volume and the data structures to process massive data are becoming challenging issue. Query optimizer is a major component of a Database Management System (DBMS) that executes queries through different strategies and techniques efficiently. These techniques select the best optimal execution plan from the candidate plans according to the available resources and environment. Traditionally, skilled database administrators are required to tune DBMS for efficient query processing. Recently it has been realized to develop DBMSs having autonomic capabilities. Autonomic DBMS (ADBMS) are now being developed to reduce this dependency on an expensive skilled human resource. The paper analyzes the autonomic capabilities of query optimizers in three wellknown DBMSs -DB2, Oracle and SQL Server being used in the industry. The research is focused to find and earmark those areas in query optimizers where the human intervention is required. Query Optimizers are compares with their autonomic capabilities; explores their strengths and weaknesses; and provides the basis for improving the current state of autonomic computing in query optimizers. The autonomic behavior of query optimizers is observed by designing and executing different queries through experiments and some recommendations are given.
The evolution of computer is started from human dependent to self-management. With the developmen... more The evolution of computer is started from human dependent to self-management. With the development of technology, people want to manage the complex systems in an efficient and reliable manner. Database Management Systems (DBMSs) started from the single user with limited operations; and with the passage of time more functionality is added to meet the need of the users. Maximum number of operations, huge volume and multi-user environment also increased the complexity. Due to complexity and heterogeneity, job of DBAs become difficult and laborious. The solution to these DBMS's problems is self-managing or autonomic DBMS (ADBMS). An ADBMS have the ability to adopt changes according to the environment and available resources without or with less human intervention. This paper examines the three commercial leading DBMSs, IBM's DB2, Oracle by Oracle Corporation and Microsoft SQL Server with respect to autonomic characteristics. On the basis of analysis and other parameters autonomic computing (AC) maturity value is assigned to each autonomic component of three DBMSs. At the end, the evolving status of AC in DBMSs is presented.
Functionality, complexity, heterogeneity and dynamism in computing environment are increasing day... more Functionality, complexity, heterogeneity and dynamism in computing environment are increasing day by day. This enhanced utility of computers has a profound impact on the systempsilas brittleness, manageability and security. Self-management is important in systems, networks, communication as well as in Database Management Systems (DBMSs). Autonomic computing reduces the problems and increases accuracy and efficiency of the DBMSs. Recent years have seen an upsurge in research related to incorporation of autonomic computing within the computing systems. IBM is working on autonomic computing in systems and DBMSs from last many years. The paper discussed the autonomic features and tools in DB2 from the literature available up to 2002. Our paper presents an extension of that paper which covers available autonomic features, components, utilities and tools up till now. A comparison of DB2 with Oracle is presented w.r.t autonomic computing. We have also identified the optional and essential human intervention (HI) in autonomic components, utilities and tools of IBM Universal Database DB2 that reveals the degree of autonomic computing in these.
Human world is becoming more and more dependent on computers and information technology (IT). The... more Human world is becoming more and more dependent on computers and information technology (IT). The autonomic capabilities in computers and IT have become the need of the day. These capabilities in software and systems increase performance, accuracy, availability and reliability with less or no human intervention (HI). Database has become the integral part of information system in most of the organizations. Databases are growing w.r.t size, functionality, heterogeneity and due to this their manageability needs more attention. Autonomic capabilities in Database Management Systems (DBMSs) are also essential for ease of management, cost of maintenance and hide the low level complexities from end users. With autonomic capabilities administrators can perform higher-level tasks. The DBMS that has the ability to manage itself according to the environment and resources without any human intervention is known as Autonomic DBMS (ADBMS). The paper explores and analyzes the autonomic components of Oracle by considering autonomic characteristics. This analysis illustrates how different components of Oracle manage itself autonomically. The research is focused to find and earmark those areas in Oracle where the human intervention is required. We have performed the same type of research over Microsoft SQL Server and DB2. A comparison of autonomic components of Oracle with SQL Server is provided to show their autonomic status.