PetaSQL

What is PetaSQL?

Analytics Database for Big Data

PetaSQL is a general-purpose DBMS that can be used as storage for log data from DBMS security solutions and can be used in multiple solutions. It can be used not only for building large data marts and data warehouses, it can be applied to online transaction processing. PetaSQL uses Oriented Analysis Processing (OLAP) column-based storage instead of the row-based storage used in the existing OLTP DBMS for real-time data analysis and retrieval. It supports the state-of-the-art data processing framework that can be used simultaneously in the OLTP and OLAP business through transaction processing and processing. In addition, a design method that minimizes security vulnerabilities is applied to respond to various security enhancement requirements, such as data spoofing and change prevention and encryption backup required by the Personal Information Protection Act. In addition, it provides several functions to facilitate DBMS management.

Big data

Column-based structure suitable for Data Warehouse and OLAP

Optimized data storage, extraction, analysis, and query

Fast processing speed

Multiprocessor, multi-core system resource balance and maximum efficiency

High-speed data processing framework with optimized memory

Convenience

Convenience with Orange for PetaSQL

Standard SQL-based relational database management system (RDBMS) support

Compatibility

Basic data types such as CHAR, VARCHAR, TEXT, INT, BLOB, CLOB, URL support for user-defined data types

Programming interface support (JDBC, ODBC, C, etc.)

Enhanced security

Counterfeit and data alteration prevention function

Encrypted column type

Access control through process authentication

System Requirements

A processor with 64-bit support (also known as x86-64, x64, x86_64, AMD64, and Intel 64)

2 GB of RAM.

8 GB of disk space.

A screen capable of a resolution of 1024 x 768 or higher.