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: 64130
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: 2834
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: 25046
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: 7880
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: Wed Dec 07 10:23:25 CST 2016

Total time taken to generate the page: 0.10974 seconds