A database machines or back end processor is a computer or special hardware that stores and retrieves data from a database. It is specially designed for database access and is coupled to the main (front-end) computer(s) by a high-speed channel. The database machine is tightly coupled to the main CPU, whereas the database server is loosely coupled via the network. Database machines can transfer large packets of data to the mainframe using hundreds to thousands of microprocessors with database software. The front end processor receives the data and displays it. The back end processor on the other hand analyzes and stores the data from the front end processor. Back end processors result in higher performance, increasing host main memory, increasing database recovery and security, and decrease of cost to manufacture. The database machine contrasts with a database server, which is a computer in a local area network that holds a database.

The Database Machine

The Database machine has the following characteristics:

• The operating system can be any supported Windows, UNIX (AIX or Solaris), or z/OS operating system. For this sample installation an AIX operating system is used. See the Release Notes for the list of supported operating systems that you can use for this installation.
• The machine is set up as a DB2 server machine, because the databases require the DB2 server function.
• An ODBC connection is established between the Crystal machine and this machine to enable Crystal Enterprise to communicate with the data mart as part of the reporting function for Tivoli Data Warehouse. This is not used by IBM Tivoli Service Level Advisor, but might be used by other applications in your enterprise that get reports from Crystal Enterprise.
• The central data warehouse and data mart databases for Tivoli Data Warehouse are installed on this machine. You create these when you run the installation program for Tivoli Data Warehouse on the Warehouse machine. As part of that procedure, you specify the hostname of this Database machine where the central data warehouse and data mart is to be located, and the installation program creates the databases on this machine.
• The SLM Database and SLM Measurement Data Mart for IBM Tivoli Service Level Advisor are also installed on this machine. You create these as remote databases (from the perspective of the SLM Server on the SLM machine) when you run the installation program for IBM Tivoli Service Level Advisor on the SLM machine. During the installation of the SLM Server, the connection between the SLM Server on the SLM machine and these databases on the Database machine is verified.
• You need to create ODBC data sources for the SLM Database and the SLM Measurement Data Mart on the Warehouse machine.
• Because both the central data warehouse and the data marts will all be located on this Database machine, you do not need to create an agent site to manage the data. Special programs in Tivoli Data Warehouse recognize that the data is on the same computer, and transfer the data from the central data warehouse to the data marts without the use of a warehouse agent.

American Journal of Computer Science and Engineering Survey (IPACSES) is a peer review open access journal publishing the research in computer science and engineering survey. Journal announces papers for the upcoming issue release. Interested can submit your manuscripts through online portal or trough email at computersci@scholarlymed.com

Media contact:

Maegan Smith

Managing Editor

American Journal of Computer Science and Engineering Survey (IPACSES)

Mail ID: computersci@scholarlymed.com

WhatsApp +1 504 6082390