Machbase DBMS Manual
Machbase DBMS Manual
This manual covers installation, table-type usage, application development, operations, security, and reference information for Machbase 8.7.0.
If you are new to Machbase, work through the SQL exercises in Chapter 1, then learn data models and storage and operational principles in Chapter 2. For system design, review table selection in Chapter 4 before moving to the relevant table chapter. For exact syntax or feature support, use Chapter 16.
Manual Structure
| Chapter | Title | Scope |
|---|---|---|
| 1 | Getting Started | Overview, connection checks, quick start, basic commands |
| 2 | Core Concepts | Table types, time model, ROLLUP, and retention policies |
| 3 | Installation, Deployment, and Upgrade | Preparation, Standard Edition, Cluster Edition, upgrade |
| 4 | Table Type Selection and Schema Design | Type decisions, schema, mutation policy, and patterns |
| 5 | TAG Table Usage | TAG structure, metadata, input, query, correction, operations |
| 6 | ROLLUP for TAG Tables | ROLLUP design, creation, query, rebuild, operations, performance tuning |
| 7 | LOG Table Usage | LOG structure, input, and text search |
| 8 | TRANSACTION Table Usage | TRANSACTION schema, DML, transactions, JOIN, backup and recovery |
| 9 | LOOKUP Table Usage | Reference data, primary keys, JSON, predicate DML, and joins |
| 10 | VOLATILE Table Usage | Memory tables, UPSERT, state cache, restart and data loss |
| 11 | Development and Application Integration | Integration methods, common concepts, and language-specific SDKs/APIs |
| 12 | Performance Tuning | Query, ingestion, and cache tuning |
| 13 | Operations, Configuration, and Recovery | Server operations, backup, and Cluster operations |
| 14 | Accounts, Privileges, and Access Control | Accounts, privileges, AUTH KEY, and access control |
| 15 | Troubleshooting | Diagnostics and resolution guides |
| 16 | Reference | SQL, functions, configuration, and system catalog reference |
Last updated on