LOB and OLTP

Question

LOB and OLTP

river1

SSC-Insane

Points: 24302
More actions
April 14, 2013 at 8:30 am

#271057

Hi Guys,
I have see people talking about relational databases as OLTP but now I have started to ear people talk about LOB database.
Are they exactly the same thing?
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

river1 (4/14/2013)
Hi Guys,
I have see people talking about relational databases as OLTP but now I have started to ear people talk about LOB database.
Are they exactly the same thing?
Thanks

If by LOB (and this is my interpretation) they mean Line of Business, yes. These can be finance, HR, ERP systems that directly support daily business operations.

Robert-378556 SSCertifiable Points: 5917 More actions · Answer 2

First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an accurate answer immediately.

OLTP = On-line Transaction Processing

OLAP = On-line Analytical Processing, usually takes data from OLTP and aggregates in cubes.

LOB = Large object (=data type). No other meanings known. To me. 🙂

river1 SSC-Insane Points: 24302 More actions · Answer 3

river1

SSC-Insane

Points: 24302

April 15, 2013 at 9:45 am

#1606517

Lynn gave the right answer.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Robert-378556 (4/15/2013)
First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an accurate answer immediately.
OLTP = On-line Transaction Processing
OLAP = On-line Analytical Processing, usually takes data from OLTP and aggregates in cubes.
LOB = Large object (=data type). No other meanings known. To me. 🙂

I think you are thinking of BLOB - Binary Large OBject or CLOB - Complex Large OBject.

I have used the term LOB - Line Of Business for many many years.

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 5

Lynn Pettis (4/15/2013)
Robert-378556 (4/15/2013)
First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an accurate answer immediately.
OLTP = On-line Transaction Processing
OLAP = On-line Analytical Processing, usually takes data from OLTP and aggregates in cubes.
LOB = Large object (=data type). No other meanings known. To me. 🙂
I think you are thinking of BLOB - Binary Large OBject or CLOB - Complex Large OBject.
I have used the term LOB - Line Of Business for many many years.

I agree that Line Of Business is probably the correct answer in this context, but LOB is a term that Microsoft specifically uses in the SQL Server documentation to refer to data contained in data types text, ntext, image, varchar(max), nvarchar(max), varbinary(max)

For example:

http://msdn.microsoft.com/en-us/library/ms184361.aspx

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Michael Valentine Jones (4/15/2013)
Lynn Pettis (4/15/2013)
Robert-378556 (4/15/2013)
First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an accurate answer immediately.
OLTP = On-line Transaction Processing
OLAP = On-line Analytical Processing, usually takes data from OLTP and aggregates in cubes.
LOB = Large object (=data type). No other meanings known. To me. 🙂
I think you are thinking of BLOB - Binary Large OBject or CLOB - Complex Large OBject.
I have used the term LOB - Line Of Business for many many years.
I agree that Line Of Business is probably the correct answer in this context, but LOB is a term that Microsoft specifically uses in the SQL Server documentation to refer to data contained in data types text, ntext, image, varchar(max), nvarchar(max), varbinary(max)
For example:
http://msdn.microsoft.com/en-us/library/ms184361.aspx

Yes, you are correct but in the context provided Large OBject was the last thing I was thinking. I have seen this in MS documentation and in results of queries on t-logs and (iirc) some DMV's.

Robert-378556 SSCertifiable Points: 5917 More actions · Answer 7

Lynn Pettis (4/15/2013)
I think you are thinking of BLOB - Binary Large OBject or CLOB - Complex Large OBject.
I have used the term LOB - Line Of Business for many many years.

Right. A small correction, CLOB is char LOB, like TEXT or varchar(max) in mssql.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 8

Robert-378556 (4/15/2013)
Lynn Pettis (4/15/2013)
I think you are thinking of BLOB - Binary Large OBject or CLOB - Complex Large OBject.
I have used the term LOB - Line Of Business for many many years.
Right. A small correction, CLOB is char LOB, like TEXT or varchar(max) in mssql.

I have seen it both ways actually. I guess it depends on who is writing about what. I just tend use BLOB when talking about either of them. In the end it is all binary anyhow.

Robert-378556 SSCertifiable Points: 5917 More actions · Answer 9

BLOB can store anything, CLOB stores char data, some additional info like charset and supports some char operations like search, so it's subset of BLOB.

I've worked with CLOBs on oracle and db2, both refer to CLOB as char lob. Complex lob would associate to something like structured OLE storage, which fits in blob.