Free Consultation

Publications

KnowTech Solution Inc. All rights Reserved © 2024

Contact

location5

Location

RAC Benchmarks for the rest of us

It is difficult to visualize what Oracle RAC can do when deployed in a small business or government department when all the benchmarks start with nodes having 64 CPU and 128 GB RAM. The promise of RAC is to be able to utilize commodity servers with modest RAM and CPU configurations. The ideal RAC node would require a single Oracle License namely, a dual-core CPU on x86 architecture using either Intel or AMD Chip. A 4-Node RAC was established and the results compared to a 4 CPU Server. The benchmark was performed using Swing Bench, a utility developed by Dominic Giles of Oracle UK and a custom script that simulated extensive write activity. The results suggest that except for very high write activity applications, RAC deployment will provide favourable performance and better management and resource allocation.

To download the file, please enter your email address.

SCM in Full Life Cycle Environment

Oracle Software Configuration Management (SCM) is a versatile tool. It can easily address configuration management in a standard software development life cycle, which progresses in a series of steps through analysis, design, build and implementation, with a feedback loop between each of the phases creating the prototype development environment. This paper presents the use of SCM in such an environment by considering the Analysis and the Design phases of a life cycle.

To download the file, please enter your email address.

Multi-National, Multi-Currency Data Update Dilemma

The implementation of the multiple currency exchange rates in anything other than a single set of books leaves much to be desired from those who have to maintain the exchange rate data. Imagine having to maintain exchange rates for 30 currencies in one set of books and then having to do this 20 times over. Moreover, this data has to be maintained daily. An approach to solving this data entry nightmare is presented based on the actual implementation in a multi-org multi-national environment. The resulting module provides a single data entry point based on the local currency for the set of books used. The inverse rates to all other currencies then become available for update of the appropriate set of books.

To download the file, please enter your email address.

Information Technology Framework

Abstract The paper presents a framework which can be used to identify and to put into perspective the Information Technology components Information, Technology and Interface and, their combinations and interactions for developing an Information Technology Strategy. The Framework addresses and evaluates the issues associated with Data, its storage and source, Information retrieval, its dependence on time frame of the business cycle and aggregation, Technology components and Interface mechanisms all of which make up the Information Technology Architecture. An example of a Decision Support System is used to show how the Information Technology Framework can be used in practice.

To download the file, please enter your email address.

Data Warehouse - Start of BPR?

The need for a Data Warehouse stems from an inability to get the required information to manage the business. Usually the data is in legacy systems where there is very little data independence from the Applications. Consequently it is the Applications that have defined the business processes. The analysis to formulate the information from the existing data sources provides significant insight into the business functions being performed and the data required to provide the information. A Data Warehouse “Request for Information” thus can identify the essential business functions. This paper presents examples showing how Data Warehouse Requests suggest changes in existing Business Processes.

To download the file, please enter your email address.

Design and Implementation of a Data Warehouse

This paper will discuss the methods and approaches to address the following issues in building a Data Warehouse at Health Canada, Laboratory Centre for Disease Control.

  • Determine the scope for the information required by the various users.
  • Formulation of the data model and the transformations of the source data supplied by multiple external organizations.
  • Development of the Information Model and the building of access to various information retrieval tools like SAS, Impromptu, Oracle*Browser and SQL*Plus.
  • Performance tuning and deployment approach.

To download the file, please enter your email address.

Practical Uses of Oracle CASE V5.0

This paper identifies the circumstances and environment necessary for success in utilizing Oracle*CASE so as to obtain the long promised productivity boost from CASE Tools. Practical examples are used to illustrate how CASE was employed in developing Forms that address multiple Surnames, Bilingual Interface and building a usable data dictionary from existing applications. Abstract This paper identifies the circumstances and environment necessary for success in utilizing Oracle*CASE so as to obtain the long promised productivity boost from CASE Tools. Practical examples are used to illustrate how CASE was employed in developing Forms that address multiple Surnames, Bilingual Interface and building a usable data dictionary from existing applications.

To download the file, please enter your email address.

Free Consultation