Query-based isolator
A query-based isolator comprising an observer, a collator and an extractor. The isolator reduces the database on which the query is run, to a new smaller, database on which the query can be performed, with the same result obtained on the smaller database, as that obtained on the original database.
1. A computing system comprising:
a storage device storing an original database, the original database having a structure and schema;
a memory storing processor-executable program code;
a query engine; and
a processor to execute the processor-executable program code in order to cause the computing system to:
execute a query on the original database, thereby obtaining a query result;
track:
all query records that are touched while the query is executed; and
one or more records that are linked to the query records; and
produce a stand-alone subset database consisting of the query records and the one or more records that are linked to the query records;
wherein:
the stand-alone subset database has a schema that is identical to the schema of the original database: and
the stand-alone subset database has fewer records than the original database.
2. A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:
execute a query on an original database, thereby obtaining a query result;
track:
all query records that are touched while the query is executed; and
one or more records that are linked to the query records; and
produce a stand-alone subset database consisting of the query records and the one or more records that are linked to the query records;
wherein:
the stand-alone subset database has a schema that is identical to a schema of the original database; and
the stand-alone subset database has fewer records than the original database.
3. The computing system of claim 1 , wherein when tracking the query records and the one or more records that are linked to the query records, the processor executes the processor-executable program code in order to cause the computing system to:
create a listener object;
register the listener object with a record fetcher;
record a record handle of each tracked record by the listener object; and
store the record handles in a collection.
4. The computing system of claim 1 , wherein the original database is a relational database.
5. The computing system of claim 1 , wherein the stand-alone subset database is produced by removing all records that are untracked.
6. The computing system of claim 1 , wherein the stand-alone subset database is produced by extracting the query records and the one or more records that are linked to the query records into a new database.
7. The non-transitory computer-readable medium storing program code of claim 2 , wherein when tracking the query records and the one or more records that are linked to the query records, the program code executable by the processor causes the computing system to:
create a listener object;
register the listener object with a record fetcher;
record a record handle of each tracked record by the listener object; and
store the record handles in a collection.
8. The non-transitory computer-readable medium storing program code of claim 2 , wherein the original database is a relational database.
9. The non-transitory computer-readable medium storing program code of claim 2 , wherein the stand-alone subset database is produced by removing all records that are untracked.
10. The non-transitory computer-readable medium storing program code of claim 2 , wherein the stand-alone subset database is produced by extracting the query records and the one or more records that are linked to the query records into a new database.