Search PPTs

Sunday, September 27, 2009

PowerPoint Presentation On 4G

4G wireless Technology PPT
4G technology is the next step of 3G technology.In this PPT you get the whole idea about 4G technology,For more information Click Here (PPT)

4G Technology(Cell Phone)
How 4G technology work with cell phone technology,Here you get your all answers.For more information Click Here (PPT)



4G Presentation


PPT On 4G Technology


PowerPoint Presentation On DSA



 Pattern Matching PPT


PowerPoint Presentation On IBM AS/400

 PPT On IBM AS/400


IBM AS/400 Presentation Transcript:
1. KSFL is a joint venture of Krishk Bharti Cooperative (Kribhco) Fertilizers & Shyam Telecommunications Limited. It is one of the major eminent fertilizer projects in the country, which encounters the scarcity of fertilizer in India. It is spelled over an area of about 1150 acres of lush green land and the whole project values at around Rs. 2,200 Crores INR. Urea is the primary product of the company along with Ammonia as the secondary product. Output 7, 26,000 MTPA (Urea). 3, 34,000 MTPA (Ammonia). Rs. 800 Crores/Year.

2. What is IBM AS/400 ???
 IBM AS/400 stands for “IBM Application System/400”. IBM AS/400 is a versatile all purpose midrange server (Midframe) designed for small businesses and departments in large enterprises to work in distributed environment.

3. Five Sacred Principles Of AS/400
Technology Independance Object-based Design Hardware Integration Software Integration Single-Level Store

4. Began at IBM Rochester Introduced in 1988 Initially was named System 35. AS/400 design was based on customer needs. Immediately successful. IBM Rochester became second biggest computer company . (behind rest of IBM)

5. Capacity on demand Dynamic Logical Partitioning Shared resources Moveable resources Manual Automatic Uncapped partitions

6. Choice of operating systems Native:
OS/400 Linux AIX Hosted: Windows Linux

7. Programming Languages Available RPG ILE COBOL ILE C ILE C++ Java SQL XML PHP

8. Object Oriented Operating System File can’t become a program Program can’t be created without authenticating user Security Written into microcode Can’t be circumvented Superior backup and recovery

9. The Program Development Manager (PDM) is a set of utilities under OS/400 designed to simplify the creation and development of software. It automates file and member creation, editing, compilation and program execution, and allows the programmer to manage their environment from a set of standard menus.

10. For more info. please refer our PPT. Thanks.

PowerPoint Presentation On IBM



1. IBM DB2

2. Introduction
First Release in 1982
DB2 is Relational DBMS (R-DBMS)
Relational Data or Binary Data
Support Pure XML for Easy Storage and Retrieval
Support Both GUI and CLI

3. DB2 Instance
A DB2 instance is a logical database server environment. There can be multiple DB2 instances on a server. Multiple Databases can be created within a DB2 instance.
The default instance for a particular system is defined by the ‘DB2INSTANCE’ environment variable. Initially for Windows default is ‘DB2’ and for Linux/Unix it is ‘db2inst1’.

4. DB2 tablespace

A tablespace is a logical layer between data and storage space.
Tables, regular data, indexes and long data reside in tablespace.

SYSCATSPACE: where the DB2 system kept tracks of all of the metadata associated with DB2 objects .

TEMPSPACE1: A temporary work area where DB2 can place intermediate results.

USERSPACE1: A place where all user objects (tables, indexes) reside by default.

5. Constraints

Primary Keys: Used to enforce uniqueness on one or set of column values.
Foreign Keys: Used to establish a referential relationship b/w two tables, can be referred as Child and Parent.
Unique Keys: Used to enforce on one or set of column values. A table can have multiple unique keys.
Checked Constraints: They are used to enforce rules for those table column so that data inserted or updated in those columns meets the conditions predefined in the check constraints.

6. DB2 Object: Table

All data is stored in tables in the database. A table consists of one or more columns of various data types. The data is stored in rows or records.
May be defined using:
The CREATE TABLE SQL statement
A GUI tool, the DB2 Control Center

7. DB2 Object: view

A view provides a transparent view of the data in underlying tables. Contains no data itself. Appears just like a table to the user. Can also be used to restrict which rows and columns can be viewed or updated.
You can create a view on an existing table (or tables) or on another view or any combination. A view defined on another view is called a nested view.
CREATE VIEW nonfictionbooks AS
SELECT * FROM books WHERE booktype = 'N‘

8. DB2 Object: Triggers

A trigger is used to define a set of actions that are to be executed whenever an insert, update, or delete operation is performed against a table or updatable view.
Like constraints, triggers are often used to enforce data integrity and business rules.
Unlike constraints, triggers can also be used to update other tables, automatically generate or transform values for inserted or updated rows, and invoke functions to perform tasks such as issuing errors or alerts.

9. Thank You

PowerPoint Presentation On NTPC

Training At NTPC






National Thermal Power Station

Related Posts Plugin for WordPress, Blogger...

Blog Archive