A-DB

Inspired by the familiarity of nature, Alphagate develops a unique UX-Design.
With A-VIS this is poured into user- and process-oriented software.

Alphagate designs and implements complete operating concepts for
machine builders and manufacturers of medical devices.
The individually created UX-Design reflects the requirements of the process
and the best possible guidance and support for the operator of the device.
Alphagate uses its A-VIS SCADA software to create a unique software framework
based on the operating concept. A-VIS offers connectivity to all major PLCs and data
sources. Alphagate offers many additional enhancements and products that can be used
seamlessly with the Alphagate solution, such as A-MR (Mixed Reality), A-DB (Big Data) and many more.

Big Data

The growing automation increases the possibility and necessity of collecting
large amounts of data. The A-DB database solution integrated into A-VIS offers
extensive and flexible options for storing, distributing of data in the company
network or the cloud.

Overview A-DB

CrateDB is a distributed SQL database that is built on a NoSQL basis.
It combines the familiarity of SQL with the scalability and data flexibility of NoSQL.

Customers often use CrateDB to store and query machine data. This is
because CrateDB makes the handling of speed, volume, and variety of
machine and log data easy and economical. Customers have reported that
CrateDB captures millions of data points per second while querying terabytes
of data in real-time – 20 times faster than their previous database
and with 75% less database hardware.
Growing a database should be easy, just like CrateDB. With the automatic
redistribution of data and a shared-nothing architecture, you can easily
scale. Simply add new machines to create and expand a CrateDB cluster.
You don‘t need to know how to redistribute data in the cluster because
CrateDB does it for you.

Openness and flexibility

Run CrateDB anywhere in your data center or in the cloud
Connect to CrateDB from almost any language, SQL application or
SQL BI tool
Expand the CrateDB functionality by writing your plug-ins
Deploy CrateDB as a container on Docker, Kubernetes or other
systems

Distributed SQL queries

CrateDB‘s distributed SQL query
engine has column field caches and
a more modern query planner.

High availability

Even if something goes wrong in your data center, CrateDB continues to run.
Automatic replication of data in your cluster ensures that errors do not interrupt data access.
Also, CrateDB clusters are self-healing.

Real-time data acquisition

Analytical data is often loaded in batches with transaction locks and other overhead.
In contrast, CrateDB eliminates locking overhead to allow massive write performance.

Backups

CrateDB can store incremental snapshots of your database in memory.
Snapshots contain the status of the tables in a CrateDB cluster at the time the snapshot was taken.

Any data and BLOBs

CrateDB supports both relational data and nested JSON documents.
All nested JSON attributes can be included in any SQL command.
Also, CrateDB offers BLOB storage.

Time Series Analysis

With CrateDB, time series can be analyzed quickly and easily. These are automatic table partitions that
can be queried, moved or deleted like virtual tables.

Spatial data queries

The location is important for many machine data to analyze.
CrateDB can store and query geographic information with the types
of geo_point and geo_shape.

Dynamic schemes

In contrast to many other SQL databases, CrateDB schemes are completely flexible.
You can add columns at any time without affecting performance or downtime.
This is ideal for agile development and rapid deployment.

Transactional

CrateDB is consistent but offers transaction semantics. CrateDB is
consistent at the row level, so each row is either fully written or not.
Thanks to the read-after-write consistency, we enable synchronously
real-time access to individual data records immediately after they have
been written.

What is A-DB?

A-DB is a powerful, distributed database
with great flexibility, ideal for use
in mechanical engineering.

This is A-DB

100% integration with A-VIS
No backup or raid system required
Distributed DB, runs on „light“ hardware
Low maintenance
Simple and transparent license model
Json und Blobs
Real-time SQL
Graphics Manager
Item Manager
Web application

A-DB

The solution is based on the Big Data solution Crate-DB.