1 / 7

Calpont InfiniDB Speeds Web Analytics Performance For Cognitive Match

Calpont InfiniDB Speeds Web Analytics Performance For Cognitive Match . Group 8 Niveditha Baskar – 4221457 Sowmya Kota Ramesh – 4317234. InfiniDB. Cognitive Match : a global leader in hosted on-site predictive targeting and dynamic ad retargeting Upgrades to Calpont’s InfiniDB from MySQL

azure
Download Presentation

Calpont InfiniDB Speeds Web Analytics Performance For Cognitive Match

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Calpont InfiniDB Speeds Web Analytics Performance For Cognitive Match Group 8 Niveditha Baskar – 4221457 Sowmya Kota Ramesh – 4317234

  2. InfiniDB • Cognitive Match : a global leader in hosted on-site predictive targeting and dynamic ad retargeting • Upgrades to Calpont’s InfiniDB from MySQL • What is InfiniDB? Column-oriented RDBMS which supports • Data warehouses, data marts, and other business intelligence (BI) / analytic databases • General purpose reporting databases • Read-intensive segments of an overall application where read/search/lookup portions of the application are served by an analytic/query database and the transactional segments (e.g. order entry, etc.) are managed by a traditional relational database

  3. Column Oriented Architecture Image Source: http://www.calpont.com/column-oriented-database-bi

  4. Features of InfiniDB • Column-oriented architecture • Multi-threaded design. • Automatic vertical and horizontal partitioning • High concurrency • High-speed data loader • DML support • Transactional support: ACID-compliant transactional support is provided along with deadlock detection

  5. Features of InfiniDB • Crash recovery: InfiniDB provides full crash recovery capabilities • MVCC design • No need for indexing • Low Maintenance • ALTER TABLE is supported (add, drop) • Platform Portability • Logical Data compression

  6. Automatic Partitioning • InfiniDB uses both horizontal and vertical partitioning • No special storage needs for horizontal partitioning • Use of both partitioning reduces IO cost in both directions • No user intervention • Automatic partition drop

  7. MVCC • Multi Version Concurrency Control • Concurrency control method commonly used by database management systems to provide concurrent access to the database • Multiple versions stored, but only one is the latest • Query operations are never blocked on a table • Query will always see the data as it existed at the time the query was issued. Links: News: http://www.sfgate.com/cgi-bin/article.cgi?f=/g/a/2011/01/05/prweb4921124.DTL InfiniDB: http://www.calpont.com/overview

More Related