Method and mechanism for implementing and accessing virtual database table structures
AssigneeOracle International Corporation
InventorsRaymond Guzman, Goutam D. Kulkarni, Joydip Kundu
Life of this patent
Estimating the term…
Abstract
The present invention is directed to a method and mechanism for encoding multiple virtual tables into one or more source tables. An aspect of the invention is directed to the access of a virtual table virtual table without requiring separate entries for the virtual table in the meta-data of a database system. Another aspect of the invention is directed to a virtual table that has different column signatures than its underlying source table(s).
Claims34
A computer implemented process for accessing a virtual table comprising:
- identifying a first data source;
- associating a first record within said first data source to a virtual table;
- accessing said first record;
- identifying a second data source;
- associating a second record within said second data source to said virtual table;
- accessing said second record;
- and
- logically populating said virtual table with said first record and said second record, said first record populates a row in said virtual table, said second record also populate said row.
A computer implemented process for accessing a virtual table comprising:
- identifying a data source;
- associating a record within said data source to a virtual table, said record comprises a first column and a second column;
- accessing said record;
- and
- logically populating said virtual table with said record, both said first column and said second column of said record are used to populate a single column in said virtual table.
A computer implemented process for accessing a virtual table comprising:
- identifying a first data source;
- associating a first record within said first data source to a first virtual table;
- accessing said first record;
- logically populating said first virtual table with said first record;
- identifying a second data source;
- associating a second record within said second data source to a second virtual table;
- accessing said second record;
- logically populating said second virtual table with said second record;
- and
- performing a data manipulation operation against both said first virtual table and said second virtual table.
A computer program product that includes a tangible storage medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by said processor, causes said processor to execute a process for accessing a virtual table, said process comprising:
- identifying a first data source;
- associating a first record within said first data source to a virtual table;
- accessing said first record;
- identifying a second data source;
- associating a second record within said second data source to said virtual table;
- accessing said second record;
- and
- logically populating said virtual table with said first record and said second record, said first record populates a row in said virtual table, said second record also populates said row.
A computer program product that includes a tangible storage medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by said processor, causes said processor to execute a process for accessing a virtual table, said process comprising:
- identifying a data source;
- associating a record within said data source to a virtual table, said record comprises a first column and a second column;
- accessing said record;
- and
- logically populating said virtual table with said record, both said first column and said second column of said record are used to populate a single column in said virtual table.
A computer program product that includes a tangible storage medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by said processor, causes said processor to execute a process for accessing a virtual table, said process comprising:
- identifying a first data source;
- associating a first record within said first data source to a first virtual table;
- accessing said first record;
- logically populating said first virtual table with said first record;
- identifying a second data source;
- associating a second record within said second data source to a second virtual table;
- accessing said second record;
- logically populating said second virtual table with said second record;
- and
- performing a data manipulation operation against both said first virtual table and said second virtual table.
A computer implemented system for accessing a virtual table comprising:
- means for identifying a first data source;
- means for associating a first record within said first data source to a virtual table;
- means for accessing said first record;
- means for identifying a second data source;
- means for associating a second record within said second data source to said virtual table;
- means for accessing said second record;
- and
- means for logically populating said virtual table with said first record and said second record, said first record populates a row in said virtual table, said second record also populates said row.
A computer system for accessing a virtual table comprising:
- means for identifying a data source;
- means for associating a record within said data source to a virtual table, said record comprises a first column and a second column;
- means for accessing said record;
- and
- means for logically populating said virtual table with said record, both said first column and said second column of said record are used to populate a single column in said virtual table.
A computer implemented system for accessing a virtual table comprising:
- means for identifying a first data source;
- means for associating a first record within said first data source to a first virtual table;
- means for accessing said first record;
- means for logically populating said first virtual table with said first record;
- means for identifying a second data source;
- means for associating a second record within said second data source to a second virtual table;
- means for accessing said second record;
- means for logically populating said second virtual table with said second record;
- and
- means for performing a data manipulation operation against both said first virtual table and said second virtual table.
A computer implemented method for accessing a virtual table comprising:
- identifying a data source;
- associating a record within said data source to a viral table, wherein said virtual table is not defined with database metadata;
- accessing said record;
- and
- logically populating said virtual table with said record.
A computer program product that includes a tangible storage medium usable by a processor, the medium having stored thereon a sequence of instructions which, when executed by said processor, causes said processor to execute a method for accessing a virtual table, said method comprising:
- identifying a data source;
- associating a record within said data source to a virtual table, wherein said viral table is not defined with database metadata;
- accessing said record;
- and
- logically populating said virtual table with said record.
A computer implemented system for accessing a virtual table comprising:
- means for identifying a data source;
- means for associating a record within said data source to a virtual table, wherein said virtual table is not defined with database metadata;
- means for accessing said record;
- and
- means for logically populating said virtual table with said record.
Dependencies are inferred from the claim text.