surrogate key: interger value randomly assigned to know rows in a table.

olap : here data is stored for analysis or some comparison for the development of business or to know where they stand. here there may be many historical data since its main objective wud b to compare data for deriving some bi.

oltp:these are transaction data for periodiacally running business. these datas are updated everytime and they dont store historical data.

DSS : Decision Support Systems :

In general, we can say that a DSS is a computerized system for helping make decisions. A decision is a choice between alternatives based on estimates of the values of those alternatives. Supporting a decision means helping people working alone or in a group gather intelligence, generate alternatives and make choices. Supporting the choice making process involves supporting the estimation, the evaluation and/or the comparison of alternatives. In practice, references to DSS are usually references to computer applications that perform such a supporting role

Online Transaction Processing : OLTP also refers to computer processing in which the computer responds immediately to user requests. An automatic teller machine for a bank is an example of transaction processing.