PHILOSOPHICAL AND METHODOLOGICAL REFLECTION ON DATABASE CAPACITY PLANNING : A CONTROLLERSHIP STANDPOINT

This paper analyzes the capacity-planning process of database management systems focusing the theoretical decision models that considers the variables constraints that could be taken slightly and other variable constraints that are indispensable during upgrade. In order to proceed with the aforementioned, we assume that capacity planning decision, which considers the general corporate, technical, users and executive views aiming at prioritizing a measurable relative importance of the planning constraints is capable of giving more economic added-value decision elements to the management. Thus, the optimization multicriteria analysis leads us to infer upon the reasonableness of the decision taken in regard to implementing budgetary planning in moment of business uncertainties. Results of this study indicate that corporate strategic views in decision-taking processes some times override some technical, users and executive views as relating to capacity planning in information technology management environment.


BACKGROUND
As it is incumbent on the controllership department to consolidate operating budgets of an organization and also enhance the monitoring procedures, it is also a concern that the controllers department optimizes the available resources in order to implement the Management Control Systems and the Decision Support Systems (DSS).When we mention management control systems in this study we mean the following three groups of systems: • Value Systems -Mostly used by the to-management to circulate the mission statements and credos to every Dick and Harry in the organization, for instance: Strategic Planning System.• Administrative Systems -They are systems mostly accounted for by the middlelevel managers, committed to attainment of operational, economic & finance and accounting transactions, for instance: Invoicing & Receivable, Purchases & Payable, Inventory, Payroll, Fixed Assets and General Ledger Systems.

138
• Performance Evaluation Systems -They are systems used by the top-management to monitor performance in key strategic areas of an organization, for instance: Balanced Score Card, Budgetary Systems.According to Kimball (1997:58) decision support systems can be used for operational control, management control and strategic planning.In another point of view, one would suggests the application of Executive Information Systems (EIS) which is mentioned in Furlan (1998:98) as a tool to browse database for the presentation of information in a simple and friendly format, by addressing the needs of the higher executives thereby eliminating the need for intermediation.
The capacity planning therefore, being issues raised in a management control process of a database, involves the conjugation of the technical knowledge of the information technology and the financial know-how of the accounting or financial department to prudently stipulate how much it is worth spending, considering current and future operations already budgeted for.
As in Robert (2002:14-51) which analyzes a capacity-planning and pricing problem of a monopolist facing uncertain demand.His study incorporates "soft" and "hard" capacity constraints.In this model, soft constraints could be relaxed at a cost while hard constraints cannot be relaxed.
We do no have a specificity of environment being studied.As in Ahmed & Lochovsky (1998:69) the goal of the study was to explore a macro-level and not to compare specific facilities and functionality of object-oriented and relational 4GL approaches or database systems per se.

Research questions
How does the Controllers and the Chief Information Officers (CIOs) go by the decision processes to upgrade the capacity of the database of their organization?
How does one measure the effectiveness of the existing capacity?

Research Hypothesis
To assist the development of this study the following assumptions were taken: H 1 The capacity planning decision, which considers the general corporate, technical, users and executive views aiming at prioritizing a measurable relative importance of the planning constraints is capable of giving a more economic addedvalue decision elements to the management.
H 2 Capacities planning of a database system should primarily reflect the volumes of transactions processed by the organization, any distance from this definitely would result in over projection and consequentially arriving at a redundant capacity that signifies a tied down capital.
H 3 Even though database dimensions are planned to match the operational activities of any organization, uncertainties that result in cash flow deficiencies may also result in a set back in investment projects that rescinds decision taken before hand.

Research Context
A database is composed of a collection of interrelated data files and joint operating procedures that enhances its maintenance with little of no difficulties.The tasks to retrieve and manipulate such data are being simplified day in day out, and this has resulted to the proposition and commercialization of data warehouse which conjugates methods and technology in a pragmatic, simple and user-friendly load-andaccess environment.Data warehouse is a group of data that is theme-oriented, integrated, however changes with time but not volatile, to support a decision-taking process Inmon (1997:75).
Database management systems have evolved from a simple and specific computer application to a modern and complex technological data processing environment, now it is dynamic, a part and parcel of convergent economic resources of any competitive organization.For that reason, interest in the dispensation of planning techniques to measure its capacity has also grown along side.
A database is considered as a system, which facilitates the storage of a greater volume of information about organizations or business unit having programs, in alliance with its application systems, enables its users to manipulate files, including the following facilities: With the outcome of data warehouse therefore, data manipulation is enhanced.According to Cavalcanti et al (1998:4-45) it is fundamental to create mini-dimensions to ensure performance; the authors mentioned that there are most commonly used attributes for searching, for example, those attributes known as demographics (Marital status, age, and gender, per capita) of a client (dimension).

Capacity of database
Capacity of a database is the maximum amount of the work a controlled database management system can withhold in a manageable unit.
Apart from the capacity of the database, performance indexes that are monitored are: • Turnaround time -time interval between the instant a program is read into the system for processing and the instant the program execution is completed; • Response time -is the time interval from the instant a command inputs to the system (strikes enter) to the instant the corresponding reply appears on the terminal.See graph 1.The X axis normally shows the loading capacity, and the Y with the corresponding response time; 140

Load
Response time • Availability -the percentage of the total time during which the user has access to the system.• Throughput -is the measure of the systems productivity or efficiency as related to the existing backlogs.See graph 2. The X axis normally shows the loading capacity, and the Y with the corresponding throughput;

Graph 2 -System Capacity and Throughput
Normal capacity 0 50 100 Load Throughput

Capacity Limit
Capacity limit refers to the limit (or threshold) of utilizable capacity; is a point at which any additional workload is expected to result in excessive degradation of system performance.Lam & Chan (1990:51).
The question that triggers capacity decisions therefore is what level of utilization will prevent inordinate queuing delay of those resources that may impede the responsiveness of the application systems?
According to the just mentioned authors, a simple methodology based on the capacity limit rules of thumb is quite commonly used for computer performance evaluation and capacity upgrade decisions.They cited that: system is monitored and the utilization tracked; projected utilization levels resulted from an extrapolation of the utilization curve plus utilization estimation for applications are compared.

Capacity Planning
Capacity planning is a whole-brain process and utilizes both subjective and objective dimensions of consciousness, the feelings and the facts.Planning requires judgment and judgmental activities necessarily require both the abilities to analyze components Browning (1994).To illustrate his concept, he associated his words to the diagram shown in Figure 1 -Capacity Planning Modalities.

Figure 1 -Capacity Planning Modalities
In a broader perspective, capacity planning could be four-fold: a) Corporate view b) Technical view c) User view; and Executive view.See Figure 2 below.As demonstrated in the mentioned figure, the corporate view which unites all the subsets of the individual views is concerned with the business optimisation of resources, valueadded and sustainability of the activities; in other words, it is the going-concern view.The technical view is concerned with the usage of the computer resources (hardwares, softwares, material, etc.) with a hope to registering its effectiveness.The user view is related with the availability of the resources when needed to meet his day to day economic transactions, normally this view is concerned with the response time and the throughput.The executive point of view is results oriented, monitors the costeffectiveness of the operating functions and tries to draw a line between the budgeted and the realized values so as to decide about forecast adjustments and better measure returns on investments.Workload forecasting to enhance decision-making Generally, workload forecasting is a most strainous task in information technology management.Some arbitrarily define it to protect personal interest or Systems Analysts define without the clear consent of the user.Saviani (1992:62) user accuses the Systems Analysts for presenting political solutions previously defined by them which are incapable of prioritise their requirements for information, define individual objectives, forget their responsibilities and escape compromise.
For controllership point of view, it is important in order to present a more realistic scenario mainly to portray its financial consequences, since it is a problem worth resolving to avoid processing stagnation that could result in lost of earnings.Evidently, in day to day management control procedures means are being devised to ameliorate critical situations such as the installation of intelligent terminals that shifts the responsibilities from the CPUs.As in Lam & Chan (1990:34) workload forecasting is typically the weakest element in the computer capacity planning process.A common workload measure, CPU hours consumed is too abstract for the user community and cannot be related easily to other business measures (e.g.Invoicing) in the organization.
Normally, workload increases are as a result of: Future applications based on historical data; Latent workload, a portion of the load that increases as a result of malfunctioning or poor performance.
Methods used to forecast a workload ranges from personal judgements and analysis (feeling) or intuitive to the mathematical (scientific) such as the Box-Jenkins method and objective methods (operating figure analysis).
In order to assist decision-making, various methods such as the following are used to forecast workload, they are: Time series, Exponential method, Box-Jenkins, Structural method, Delphi to mention just a few.
Time series regression method -This is based on the premise that forecasted items are directly related to a workload data. Thus: . ˆbt a where t W ˆ represents forecasted workload at a time t. and "a" and "b" are constants estimated by the least squares method utilizing historical workload data.
Exponential smoothing models -This is recommended for the short and medium range forecasting.
It shows that: where N is the number of periods in a cycle and "d" is the smoothing constraint.These constraints could be defined as: Volatile (small) assign weights (light) according to feelings; Stable (large) assign weight (heavy) according to feelings.Box-Jenkins method -This philosophical method postulates a generalized model that explains a large number of time series data.The (B-J) tentative data results are normally analysed for their reasonableness and if found cohesive it is used as a base fore forecasting.

METHODOLOGY
The rational behind this study is the exploratory nature.It shows how applications systems development and its maintainability is increasingly becoming very important in highly competitive environments.What is alarming is the approximately 50% cost needed to put any hardware into operation, representing the cost of software implementation.Normally, we are conversant with project implementation groups working behind schedule and overrun of budget is not also strange.
It is on this note that The Software Engineering Institute (SEI) in Pittsburgh was asked by the United States Air Force in 1986 to study the systematic way to evaluate software contractors.And as a result of this request, a Capacity Maturity Model (CMM) was invented, see Figure 3.

Figure 3 -Capacity Maturity Model
According to Barkville & Pries-Heje (1999:26) maturity levels are composed of one or more key process areas, if the organizations develop these areas, the software process is known to improve.As a methodological approach to this study therefore, we crave the indulgence of the points of views presented by the mentioned authors thereby expatiating on levels 3, 4 and 5 of the capacity maturity model.

OPTIMIZATION OF THE DATABASE RESOURCES ENVISAGING BUDGETARY CONSTRAINTS
In as much as the operating environment works according to organization policies, files segments describes the space an application is occupying in a database and in terms of optimization it gives a greater concern as regards capacity planning.For instance, if the space extension is arbitrarily used to recharge operating departments, meaning the users, the accounting department that uses more of database to house accounting information systems and financial information that requires retention for several years, should bare the greater part of the cost of database systems.Thus, other criteria proposed for adoption should be unanimously accepted and should also suite the laid down policies of such establishment.
Monitoring of the optimization procedures of the database systems involves the follow-up of the performance through the tools of DMS -Database Management Systems, characterized by: Therefore, the mechanisms or better say major characteristics of capacity planning summarized in the views shown in figure 3, are eminently qualitative variables and in order to be controllable certain elements of measurability has to be established, thus, for decision-taking process, multicriteria methods could assist in this process.
For this reason, we revive the premise that capacity upgrade go-ahead signal depends on the sum of the relative importance and the associated value functions of the corporate view, technical, users and the executive views.
Thus, as already mentioned in the literatures the perception of capacity is subjective, and so there is a need to stipulate a level of importance which the planners in the assessment process could define by attributing relative importance to the general views: , and w j is the relative importance (weight) of the general views.
The capacity upgrade go-ahead signal cus is a function of the criteria values of corporate views cv, technical view tv, users view uv, executive views ev, and relative weights w j i of each view, such as: that can assume the aggregate form: and 0 <w j i <1, where cpc is the capacity planning criteria for updating database of the planning general views j.

DEFINITION OF RELATIVE IMPORTANCE OF PLANNING VIEW W J AND CAPACITY PLANNING CRITERIA W J I
The estimation of weights or relative importance of planning view and capacity planning criteria is formulated through the Analytic Hierarchy Process (AHP), as in Saaty (1990Saaty ( , 1991)).The process is initialized with parity comparison between planning view w j and capacity planning criteria w j i , according to the relative importance judgment scale of values shown in table 1.The evidence favouring a over b is the highest possible.
When compromise is needed.

Reciprocals
If activity a has one of the above numbers assigned to it when compared with activity b, then b has the reciprocal value when compared to a. Source: Adapted from Saaty (1990Saaty ( , 1991) Definition of value function of capacity planning criteria v(cpc j i ) The value function of capacity planning criteria is established through cardinal values attributed to standard view.In tables 2 below are shown standard situations of the optimization criteria, defined for the study with their respective value functions and the decision attributes.

SIMULATION AND COMMENTS
In order to explain the exercises performed to test the assumptions of this research, the following additional methodological steps were reiterated: Comparison of the relative importance of planning view w j and capacity planning criteria w j i are essential to enhance a conclusion about the necessity to upgrade a data base.
Definition of value functions v(rc j i ) of the views raised concerning the four dimensions of capacity planning is important to give a score even though subjective, to a decision process that needs quantitative results.
An association of decision attributes and the reasonableness of the rules of thumb should be highlighted.
In the day to day activities of an organization note that steps a and b are standardized to enhance the assessment of capacity planning decision.Thus, standard information should be constantly reviewed because of the periodical mutation of business environment, internal or external to the organization and value references of the decision taker.And steps c should be developed for every specific controllership optimization processes.
Upon application of the approach therefore, see Table 3 a go-ahead or not decision was reached as we sum up the relative importance of the views raised as the supporting points for the database capacity upgrade.Taking an organization per se, where its decision takers are trying to reach a consensus as regards a capacity upgrade of its database systems have to do a lot of brain storming exercises.In the aforementioned case, having raised the issues, and various views collected, a homogenous view for the need to upgrade the management control systems data base was pinpointed.This as a result of the relative importance corporate view (0,545) relating to business continuity and assurance strategy issue, technical view (0,258) relating to human resources usage and its efficiency, users view (0,105) relating to systems usage and recharge to users enhance, and the executive view (0,082) management control systems cost-effectiveness.These relative scores, as one could name them, when summed up (1,0) shows a high priority capacity upgrade signal.Thus, it looks very evident that the business continuity and its assurance strategies that affect the going-concern issues have been considered.If the scores had been less, it would have shown either a medium or less priority capacity upgrade decisions.

CONCLUSION
It is clear that this study suggests that a focus on capacity planning of database management systems could be of importance for organizations not just as a tool for resources optimization but avoids an arbitrary decision-taking processes concerning issues that have a more subjective measurement criteria.
Even though cautions should be taken with regards to interpretation of findings arising from exploratory study of this nature, results makes us to infer that some corporate view in decision taken processes some times override some technical, users and executive views as relating to capacity planning in information technology management environment.
Therefore, we confirm the assumption that capacity planning decision models, which considers the general corporate, technical, users and executive views aiming at prioritizing a measurable relative importance of the planning constraints is capable of giving a more economic added-value decision element to the management.
This study sparks interest into issues that pose problems to the controllership department and the information technology management during budgetary planning and the monitoring procedures; nevertheless, it abridges the existing distance between the day to day treatment of the issue in the organizations and the scientific proofs.

•
Coordination of the maintenance of database architecture (definition, creation, exclusion and classification of data that would be stored in it); • Definition of access policies, confidentiality, and data integrity (description of data elements, access keys, etc.); • Maintenance (physical reorganization and routine backup) and documentation of databases; • Coordination of data administration activities, users and systems programming;• Development and maintenance of standards

Explanationa
to b = 1 Two activities contribute equally to the objective and are of the highest importance.a to b =3 Experience and judgement moderately favours a over b. a to b = 5 Experience and judgement strongly favours a over b. a to b = 7 a is strongly favoured over b and its dominance is demonstrated in practice.a to b = 9

Table 3 -
Comparison of relative importance of planning view and capacity optimization criteria