Oracle V SQL Server Comparison of Core Schema and Data Structures

Oracle V SQL Server Comparison of Core Schema and Data Structures (Objects)

Oracle	SQL Server
Table	Table
Index	Index
View	View
Synonym	Synonym
Sequence	Identity Columns
Procedure	Stored Procedure
Function	Function
Package	N/A
Queue in Streams Advanced Queuing	Service Broker Queue
Object Type	Type
XML DB	XML Schema Collection

                                                                             

Data Blocks, Extents And Segments
                                                                                           

Structure	Oracle	SQL Server 2008
Smallest unit of logical storage	Block	Page
Block size	Variable	8 KB fixed
Storage allocation	Performed in multiple blocks; are ‘extents’	Performed in multiple pages; are ‘extents’
Extent size	Variable	64 KB fixed
Segment	Any logical structure that is allocated storage	No equivalent structure