VelocityDB Pros/Cons SQL Server Pros/Cons Simple applications perform well but as Capable of unbeatable performance and data model gets more complex and data scalability size grows performance suffer Use inheritance, polymorphism and Hard to mimic all object oriented features composition Limited testing Very well tested Not very many have used Many know how to use Use any data structure Limited to table data structure Standardized Object identifier Each table defines a primary key An object relational mapping tool such as No mapping required or is required Field can store multiple values Limited to single value in each cell Client caching has to be done with Integrated Client Caching Facility separate tool(s) Database Maintenance/Administration No Database Administration Required Required No empty space on pages and Database tables and indexes are usually fragmentation avoided by using variable fragmented with empty/unused space on page size pages. Although BLOB storage is supported, Good for supporting storage of binary data is more difficult to work with and not data such as video & audio easy to segment Low Costs High Costs 22,409 lines of C# code More than lines of C++/C code
VelocityDB Pros/Cons SQL Server Pros/Cons Capable of unbeatable performance and scalability Simple applications perform well but as data model gets more complex and data size grows performance suffer Use inheritance, polymorphism and composition Hard to mimic all object oriented features Limited testing Very well tested Not very many have used Many know how to use Use any data structure Limited to table data structure Standardized Object identifier Each table defines a primary key No mapping required An object relational mapping tool such as or is required Field can store multiple values Limited to single value in each cell Integrated Client Caching Facility Client caching has to be done with separate tool(s) No Database Administration Required Database Maintenance/Administration Required No empty space on pages and fragmentation avoided by using variable page size Database tables and indexes are usually fragmented with empty/unused space on pages. Good for supporting storage of binary data such as video & audio Although BLOB storage is supported, data is more difficult to work with and not easy to segment Low Costs High Costs 22,409 lines of C# code More than lines of C++/C code
Relational%20VS%20Object%20Database.docx