SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification

Remote BLOB Store Provider Library Implementation Specification
logo-sql08.gif
SQL Server Technical Article
Writers: Kevin Farlee, Pradeep Madhavarapu
Technical Reviewer: Pradeep Madhavarapu, Michael Warmington
Published: August 2008

Remote BLOB Store (RBS) is designed to move the storage of large binary data (BLOBs) from database servers to commodity storage solutions.

With RBS, BLOB data is stored in storage solutions such as Content Addressable Stores (CAS), commodity hardware with data integrity and fault-tolerance systems, or mega service storage solutions like MSN Blue. A reference to the BLOB is stored in the database. An application stores and accesses BLOB data by calling into the RBS client library. RBS manages the life cycle of the BLOB, such as doing garbage collection as and when needed.

RBS is an add-on that can be applied to Microsoft SQL Server 2008 and later. It uses auxiliary tables, stored procedures, and an executable to provide its services. A reference to the BLOB (provided by the BLOB Store) is stored in RBS auxiliary tables and an RBS BLOB ID is generated. Applications store this RBS BLOB ID in a column in application tables. These columns in application tables are called RBS Columns in this specification. The RBS Column is not a new data type; it is just a simple binary(20).

Above words are quoted from original Microsoft White Paper Please read complete white paper for excellent notes on what are exact specification for Remote BLOB Store Provider Library.

Abstract courtesy : Microsoft

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQLAuthority News – Community Tech Days – Jan 30, 2010 – Event Announcement
Next Post
SQLAuthority News – Download Sample Database for Microsoft SQL Server

Related Posts

2 Comments. Leave new

  • How we can get the data in resultset from two different database server(SQL Server) having same table structure on both table into these two servers…?

    Reply
  • @Rajesh,

    Why don’t you try using fully qualified name?

    Reply

Leave a Reply

Menu