FLEXIBLE DATA FORMAT FOR DATABASE MANAGEMENT SYSTEMS

摘要

Example embodiments relate to providing a flexible data format for database management systems. In example embodiments, a query command to access a plastic table in a database is received, where the plastic table is a combination of at least two component sub-tables. The query command is executed to join the component sub-tables in the plastic table by using an AScan operator to obtain datarows from each of the component sub-tables, where the AScan operator converts an end of file (EOF) value to a null datarow that comprises null values, and joining the datarows obtained from the AScan operator to create query results for the query command.

主权项

1. A system for providing a flexible data format for database management systems (DBMS), the system comprising of:
a database management system executed by a processor to manage a database; and the processor to:
receive a query command to access a plastic table in the database, wherein the plastic table is a combination of at least two component sub-tables;execute the query command to join the component sub-tables in the plastic table by:
using an AScan operator to obtain datarows from each of the component sub-tables, wherein the AScan operator converts an end of file (EOF) value to a null datarow that comprises null values; andjoining the datarows obtained from the AScan operator to create query results for the query command.