Get Database Insight 💡
Learn product updates and everything about database.
📕 What is B+ tree?
The fundamental data structure used in all major database systems storing the data. B+ tree is a variation of B tree, both have a very large fanout to store indexes to the data page, which greatly reduces the number of I/O operations to find the desired data. Unlike B tree which stores data on both leaf and non-leaf node. B+ tree only stores data on the leaf node and index data on the non-leaf node, which gives B+ tree a even large fanout on the intermediate non-leaf index node.
Safer and faster database change and version control for DBAs and Developers
Bytebase is an open source, web-based database schema change and version control tool for teams. It offers a web-based collaboration workspace to help DBAs and Developers manage the lifecycle of application database schemas.
Features
SQL Review
A dedicated review workflow and UI for Developers and DBAs to collaborate on schema changes. Assisted by built-in advisor such as backward compatibility checks.
Database-as-Code
Integrate with VCS hosting the migration scripts. Migration pipeline is triggered on observing new script push event.
Streamlined Deployment
Support multi-tenant (M), multi-environment (N) schema change in a single M*N change matrix pipeline.
SQL Editor
Easy-to-use query interface to SELECT database records.
Migration History
Record the full migration history with side-by-side diff comparison between versions.
Anomaly Center
Periodically scan all managed instances and databases and provide user a holistic view to see all anomalies.
Drift Detection
Periodically scan all managed instances and databases and provide user a holistic view to see all anomalies.
Backup and Restore
Per-database automatic and manual backup. Environment specific backup schedule policy. Restore to new database with the entire restored migration history chain.
Role-based Access Control
Two role set. Owner, DBA, Developer for workspace. Owner, Developer for project.