Home » Other » Training & Certification » OLTP,OLAP,ETL and production database
OLTP,OLAP,ETL and production database [message #302015] Fri, 22 February 2008 12:54 Go to next message
krishnakanth
Messages: 4
Registered: January 2008
Location: INDIA
Junior Member

what is OLTP,OLAP,ETL and production database?explain in detail i am new to DBA

[Updated on: Fri, 22 February 2008 13:01]

Report message to a moderator

Re: OLTP,OLAP,ETL and production database [message #302024 is a reply to message #302015] Fri, 22 February 2008 13:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First try google and wikipedia, then come back if you have more questions.

Regards
Michel
Re: OLTP,OLAP,ETL and production database [message #302053 is a reply to message #302024] Fri, 22 February 2008 16:36 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
OLTP stands for Optical Lunar Transfer Protocol. This is when we need to store and transport information about things to do with the universe (and everything in it)
OLAP is similar Optical Lunar Assertion Protocol. This is used when we need to confirm the validity of our OLTP transfers.

ETL is obviously Extra Terrestrial Lifeform (not quite sure the relevance to the thread) but that is an 'alien' to the layman. (also sometimes referred to as a 'consultant')

Production Database is where you keep track of things that you produce.
But don't take my word for it, search the internet (you've probably got one on your PC but if you don't you can probably get the Internet on disk from your local PC shop)
HTH
Re: OLTP,OLAP,ETL and production database [message #302057 is a reply to message #302015] Fri, 22 February 2008 17:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
krishnakanth,
>i am new to DBA
What is DBA?

[Updated on: Fri, 22 February 2008 17:09] by Moderator

Report message to a moderator

Re: OLTP,OLAP,ETL and production database [message #302070 is a reply to message #302015] Fri, 22 February 2008 23:59 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
If you are a DBA, you don't know what a production database is and you want to stay a DBA for longer than next week, there is only one advice: stay away from your keyboard.
Previous Topic: Interview Question
Next Topic: Basic SQL statement , Finding Repeated Values
Goto Forum:
  


Current Time: Thu Mar 28 10:35:34 CDT 2024