Difference between revisions of "Category:Databases"
From Lianjapedia
Barrymavin (Talk | contribs) (→Lianja SQL) |
Barrymavin (Talk | contribs) (→Key features) |
||
| (29 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
It is used in many business critical installations worldwide including banking, defense and logistics. | It is used in many business critical installations worldwide including banking, defense and logistics. | ||
| + | |||
| + | A Lianja database is a container holding a collection of tables, views, and their associated constraints and business rules. Tables consist of rows and columns, also referred to as records and fields. Each column or field has a name, a data type and a width. It can optionally have decimal places, a description and data validation rules. Data is added to the table by adding rows or records. | ||
==Key features== | ==Key features== | ||
| Line 10: | Line 12: | ||
* Embedded in Lianja App Builder, Lianja App Center, Lianja Cloud Server and Lianja SQL Server | * Embedded in Lianja App Builder, Lianja App Center, Lianja Cloud Server and Lianja SQL Server | ||
* Incorporates a local cursor engine | * Incorporates a local cursor engine | ||
| − | * Tight coupling between language ( | + | * Tight coupling between language (LianjaScript/VFP) and data |
| + | * Native access from LianjaScript/VFP, Python, PHP, javaScript and TypeScript | ||
* High concurrent throughput incorporating row level locking | * High concurrent throughput incorporating row level locking | ||
* Fast and reliable with a small footprint | * Fast and reliable with a small footprint | ||
| Line 16: | Line 19: | ||
* Very large file support (2^64) for the most demanding storage requirements | * Very large file support (2^64) for the most demanding storage requirements | ||
* Supports storage of documents, images, video and other binary content | * Supports storage of documents, images, video and other binary content | ||
| − | * Supports | + | * Supports Hot backup |
* Cluster ready, highly scalable, with self-healing indexes | * Cluster ready, highly scalable, with self-healing indexes | ||
* Incorporates cost-based query optimization using indexes | * Incorporates cost-based query optimization using indexes | ||
* Incorporates SmartQuery™ technology with intelligent query caching | * Incorporates SmartQuery™ technology with intelligent query caching | ||
| − | * Write stored procedures in | + | * Write stored procedures in LianjaScript/VFP scripting |
| − | * Write triggers in | + | * Write triggers in LianjaScript/VFP scripting |
* Supports integration with third party SQL databases using virtual tables | * Supports integration with third party SQL databases using virtual tables | ||
* Supports row level security (RLS) | * Supports row level security (RLS) | ||
| Line 30: | Line 33: | ||
* Supports full JSON CRUD operations; INSERT, SELECT, UPDATE and DELETE of JSON | * Supports full JSON CRUD operations; INSERT, SELECT, UPDATE and DELETE of JSON | ||
* Can be used as high performance key/value table storage | * Can be used as high performance key/value table storage | ||
| + | * Supports encryption of tables | ||
* Available for Windows, Linux and macOS | * Available for Windows, Linux and macOS | ||
* Provides drivers for ODBC data access | * Provides drivers for ODBC data access | ||
| + | * Provides a Node.js module for access using Lianja Cloud Server | ||
| + | * Provides a Python module for access using Lianja Cloud Server | ||
| + | * Includes a native Key Value Store (KVS) | ||
| + | |||
| + | ==Lianja SQL== | ||
| + | |||
| + | Documentation can be found [[:Category:Lianja_SQL|here]]. | ||
| + | |||
| + | ==Lianja Database Events== | ||
| + | |||
| + | Documentation can be found [[Database_Events|here]]. | ||
| + | |||
| + | ==Lianja Database Triggers== | ||
| + | |||
| + | Documentation can be found [[:Category:Database Triggers|here]]. | ||
| + | |||
| + | ==Virtual Tables== | ||
| + | |||
| + | Documentation can be found [[Virtual_Tables|here]]. | ||
| + | |||
| + | ==Row Level Security== | ||
| + | |||
| + | Documentation can be found [[:Category:Row_Level_Security|here]]. | ||
| + | |||
| + | ==Dynamic Data Masking== | ||
| + | |||
| + | Documentation can be found [[Understanding_Dynamic_Data_Masking_in_Lianja|here]]. | ||
| + | |||
| + | ==Working with MetaData== | ||
| + | |||
| + | Documentation can be found [[MetaData_Editor|here]]. | ||
| + | |||
| + | ==Chronological Data Versioning== | ||
| + | |||
| + | Documentation can be found [[:Category:Database_Timelines|here]]. | ||
| + | |||
| + | ==Working with JSON== | ||
| + | |||
| + | Documentation can be found [[Working_with_JSON_and_JQL|here]]. | ||
| + | |||
| + | ==Stored Procedures== | ||
| + | |||
| + | Documentation can be found [[:Category:Database Stored Procedures|here]]. | ||
| − | == | + | ==Backup and Restore== |
| − | + | Documentation can be found [[Hot_Backup_and_Restore|here]]. | |
==Creating a database and its tables== | ==Creating a database and its tables== | ||
| − | + | Documentation can be found [[Creating_a_database_and_its_tables|here]]. | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Lianja SQL]] | [[Category:Lianja SQL]] | ||
Latest revision as of 07:55, 2 May 2024
The Lianja database is a high performance SQL and NoSQL (Navigational data access) database.
Despite its powerful features the Lianja database is simple to set up and easy to use.
It is used in many business critical installations worldwide including banking, defense and logistics.
A Lianja database is a container holding a collection of tables, views, and their associated constraints and business rules. Tables consist of rows and columns, also referred to as records and fields. Each column or field has a name, a data type and a width. It can optionally have decimal places, a description and data validation rules. Data is added to the table by adding rows or records.
Contents
Key features
- Embedded in Lianja App Builder, Lianja App Center, Lianja Cloud Server and Lianja SQL Server
- Incorporates a local cursor engine
- Tight coupling between language (LianjaScript/VFP) and data
- Native access from LianjaScript/VFP, Python, PHP, javaScript and TypeScript
- High concurrent throughput incorporating row level locking
- Fast and reliable with a small footprint
- Chronological Data Versioning and audit trails to satisfy regulatory requirements
- Very large file support (2^64) for the most demanding storage requirements
- Supports storage of documents, images, video and other binary content
- Supports Hot backup
- Cluster ready, highly scalable, with self-healing indexes
- Incorporates cost-based query optimization using indexes
- Incorporates SmartQuery™ technology with intelligent query caching
- Write stored procedures in LianjaScript/VFP scripting
- Write triggers in LianjaScript/VFP scripting
- Supports integration with third party SQL databases using virtual tables
- Supports row level security (RLS)
- Supports dynamic data masking (DDM)
- Has integrated support for metadata at the database, table and column level
- Many productivity extensions to standard SQL e.g. SELECT data and save as XML, JSON, HTML in one statement
- Supports JSON with a native JSON data type and the ability to query on JSON members using SQL SELECT with fully optimized queries
- Supports full JSON CRUD operations; INSERT, SELECT, UPDATE and DELETE of JSON
- Can be used as high performance key/value table storage
- Supports encryption of tables
- Available for Windows, Linux and macOS
- Provides drivers for ODBC data access
- Provides a Node.js module for access using Lianja Cloud Server
- Provides a Python module for access using Lianja Cloud Server
- Includes a native Key Value Store (KVS)
Lianja SQL
Documentation can be found here.
Lianja Database Events
Documentation can be found here.
Lianja Database Triggers
Documentation can be found here.
Virtual Tables
Documentation can be found here.
Row Level Security
Documentation can be found here.
Dynamic Data Masking
Documentation can be found here.
Working with MetaData
Documentation can be found here.
Chronological Data Versioning
Documentation can be found here.
Working with JSON
Documentation can be found here.
Stored Procedures
Documentation can be found here.
Backup and Restore
Documentation can be found here.
Creating a database and its tables
Documentation can be found here.
Subcategories
This category has the following 3 subcategories, out of 3 total.
Pages in category "Databases"
The following 108 pages are in this category, out of 108 total.
