Hi All,
Appliances are software running on a certified hardware like SAP Hanna , Teradata 5600 . Teradata has its own set of hardware on which connecting cables LAN and everything is designed and tested by teradata so they sell the entire big rack to you instead of software. Teradata best runs on its own rack because they have taken care of optimization to last detail . SAP Hanna is also run on its own certified hardware
SAP Hanna is a database ( like oracle , mysql ) but it has very High RAM 1 TB and multiple CPU also insted of disk drives with moving parts it used solid state drives . Disk is approximately million times slower than RAM , So with Hanna user can expect high speed querying
1 TB of ram in Hanna can accompodate 40 TB of uncompressed data
100 TB of RAM can accomoadate 500 TB of uncompressed data . Note one machine does not have this 100TB ram it is distributed across CPU in server . Each CPU will be in its own U case and with certain CPU when all are added up it becomes 100TB
Below all the databases are competitors of each other in offering similar speeds . Some are using in memory database and some are using other ways but they offer similar query speeds and similar costs
Netezza , Teradata , Oracle Exadata ( to some extent ). SQL Server parallel DW Are MPP system (Share nothing ) that is each processor has it dedicated main memory (RAM) . In SMP like your i5 processor on you laptop .There is a single RAM for all the 4 processors inside.
Appliances are software running on a certified hardware like SAP Hanna , Teradata 5600 . Teradata has its own set of hardware on which connecting cables LAN and everything is designed and tested by teradata so they sell the entire big rack to you instead of software. Teradata best runs on its own rack because they have taken care of optimization to last detail . SAP Hanna is also run on its own certified hardware
SAP Hanna is a database ( like oracle , mysql ) but it has very High RAM 1 TB and multiple CPU also insted of disk drives with moving parts it used solid state drives . Disk is approximately million times slower than RAM , So with Hanna user can expect high speed querying
1 TB of ram in Hanna can accompodate 40 TB of uncompressed data
100 TB of RAM can accomoadate 500 TB of uncompressed data . Note one machine does not have this 100TB ram it is distributed across CPU in server . Each CPU will be in its own U case and with certain CPU when all are added up it becomes 100TB
Below all the databases are competitors of each other in offering similar speeds . Some are using in memory database and some are using other ways but they offer similar query speeds and similar costs
Netezza , Teradata , Oracle Exadata ( to some extent ). SQL Server parallel DW Are MPP system (Share nothing ) that is each processor has it dedicated main memory (RAM) . In SMP like your i5 processor on you laptop .There is a single RAM for all the 4 processors inside.
No comments:
Post a Comment