Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
InfiniDB is a column-oriented database management system specifically designed for online analytical processing (OLAP) workloads, featuring a distributed architecture that facilitates Massive Parallel Processing (MPP). Its integration with MySQL allows users who are accustomed to MySQL to transition smoothly to InfiniDB, as they can connect using any MySQL-compatible connector. To manage concurrency, InfiniDB employs Multi-Version Concurrency Control (MVCC) and utilizes a System Change Number (SCN) to represent the system's versioning. In the Block Resolution Manager (BRM), it effectively organizes three key structures: the version buffer, the version substitution structure, and the version buffer block manager, which all work together to handle multiple data versions. Additionally, InfiniDB implements deadlock detection mechanisms to address conflicts that arise during data transactions. Notably, it supports all MySQL syntax, including features like foreign keys, making it versatile for users. Moreover, it employs range partitioning for each column, maintaining the minimum and maximum values of each partition in a compact structure known as the extent map, ensuring efficient data retrieval and organization. This unique approach to data management enhances both performance and scalability for complex analytical queries.
Description
instantOLAP is a versatile and efficient Reporting and OLAP system that integrates a contemporary Web 2.0 interface known as the instantOLAP Portal with a robust built-in OLAP engine. Starting from version 2.5, the system features this modern front end, enabling users to not only access pre-established reports but also to generate their own Pivot-Tables and reports through a user-friendly drag-and-drop interface within their browsers. Additionally, users can share their created Pivot-Tables, reports, and other documents, as well as personalize the interface by creating bookmarks or automating emails according to their preferences. In the instantOLAP environment, reports transcend the limitations of basic tables; the reporting engine presents a wide array of components that can be merged to create engaging and dynamic reports. These reports can incorporate various interactive and customizable selectors, stylish Pivot-Tables with drill-down capabilities, numerous chart types, geo-charts, and more, allowing for a high degree of flexibility in presentation. Users can arrange these elements side by side, in vertical stacks, as part of a tabular layout, or even as animated displays, providing a rich and interactive data experience. This level of customization empowers users to tailor their reporting experience to meet their specific needs and preferences.
API Access
Has API
API Access
Has API
Integrations
MySQL
Pricing Details
No price information available.
Free Trial
Free Version
Pricing Details
No price information available.
Free Trial
Free Version
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Vendor Details
Company Name
Database of Databases
Founded
2000
Country
United States
Website
dbdb.io/db/infinidb
Vendor Details
Company Name
instantOLAP
Country
Germany
Website
www.instantolap.com
Product Features
Database
Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization
Product Features
Business Intelligence
Ad Hoc Reports
Benchmarking
Budgeting & Forecasting
Dashboard
Data Analysis
Key Performance Indicators
Natural Language Generation (NLG)
Performance Metrics
Predictive Analytics
Profitability Analysis
Strategic Planning
Trend / Problem Indicators
Visual Analytics
Reporting
Customizable Dashboard
Data Source Connectors
Drag & Drop
Drill Down
Email Reports
Financial Reports
Forecasting
Marketing Reports
OLAP
Report Export
Sales Reports
Scheduled / Automated Reports