Create Data Set > SQL Data Set

Various entities and the relationships between various entities can be represented by the relational model. The relationship model is a two-dimensional table model. A relationship database is a data organization formed by a two-dimensional table and the connections between them. A relational database is a database based on a relational model. The use of mathematical concepts and methods such as collection algebra to process data in a database is a common type in database storage types. The current mainstream relational databases are ORACLE, DB2，SQLSERVER，MYSQL，DERBY，INFOMIX，SYBASE，ACCESS，POSTGRESQL.

The standard data query language SQL is a structured query language between relational algebra and relational calculus. It is a generic and robust relational database language that consists of the sublanguages of query, manipulation, definition, and control. It is also a non-procedural language that only asks users to state what to do rather than how to do. SQL integration implements all operations in the life cycle of the database and provides an approach for interacting with the relational database. It can work with a standard programming language.

SQL Data Set contacts with current mainstream databases mainly over JDBC and ODBC. JDBC and ODBC provide a group of API for accessing databases and sets up specifications for database access. They support the implementation of SQL statements and also function as the main interface between Yonghong Z-Suite and data sources. Yonghong Z-Suite operates databases not relying on any DBMS. All the operations on databases are performed by the database driver of the corresponding DBMS.

In addition to mainstream relational databases, you can link to other types of databases, like some non-relational databases such as VERTICA, EXADATA, NETEZZA, TERADATA, SYBASE, GREENPLUM by selecting the GENERIC type or entering a correct data drive interface.