Optimization of queries on a repository based on constraints on how the data is stored in the repository

A computer-implemented method comprising:nstoring, within database objects managed by a database system, data files contained in a directory of folders, each folder of said directory of folders containing at least one data file of said data files;in said database, storing metadata that, for each folder of said directory of folders, defines one or more constraints, wherein said one or more constraints includes a physical constraint that specifies that storage of any data file in said each folder is restricted to at least one specified database object of said database objects;wherein for at least two of said directory of folders, a first folder includes a first data file that is restricted by said physical constraint to a first database object and a second folder includes a second data file that is restricted by said physical constraint to a second database object;wherein the first database object is different than the second database object;receiving, at the database system, a query that complies with a query language;in response to receiving said query:nbased on (1) said query and (2) the one or more constraints defined by the metadata, said database system making a determination of how data required by the query is stored in said database; andbased on the determination on how data required by the query is stored in said database, rewriting the query to generate a re-written query that specifies a restriction based on a particular database object of said at least one specified database object, wherein the received query did not specify said restriction.

A computer-implemented method comprising:nstoring, within database objects managed by a database system, files contained in a plurality of identifiable groups of one or more files, each identifiable group containing at least one file of said files;in said database, storing metadata that, for each identifiable group of one or more files of said plurality of identifiable groups, defines one or more constraints, wherein said one or more constraints includes a physical constraint that specifies that storage of any file in said each identifiable group of one or more files is restricted to storage in a database in at least one specified database object from a group consisting of (a) a particular one or more database tables, (b) a particular one or more database table partitions, and (c) a particular one or more database views;wherein for at least two of said groups of one or more files, a first group includes a first data file that is restricted to a first database object and a second group includes a second data file that is restricted to a second database object; wherein the first database object is different than the second database object;in response to receiving said query:nbased on (1) said query and (2) the one or more constraints defined by the metadata, said database system making a determination of how data required by the query is stored in said database;based on the determination on how data required by the query is stored in said database, rewriting the query to generate a re-written query that specifies a restriction based on a particular database object of said at least one specified database object, wherein the received query did not specify said group; andexecuting the re-written query that specifies a restriction based on said specified database object.

A non-transitory computer-readable medium storing instructions, which, when executed by one or more processors, cause performance of:nstoring, within database objects managed by a database system, data files contained in a directory of folders, each folder of said directory of folders containing at least one data file of said data files;in said database, storing metadata that, for each folder of said directory of folders, defines one or more constraints, wherein said one or more constraints includes a physical constraint that specifies that storage of any data file in said each folder is restricted to at least one specified database object of said database objects;wherein for at least two of said directory of folders, a first folder includes a first data file that is restricted by said physical constraint to a first database object and a second folder includes a second data file that is restricted by said physical constraint to a second database object;wherein the first database object is different than the second database object;receiving, at the database system, a query that complies with a query language;in response to receiving said query:nbased on (1) said query and (2) the one or more constraints defined by the metadata, said database system making a determination of how data required by the query is stored in said database; andbased on the determination on how data required by the query is stored in said database, rewriting the query to generate a re-written query that specifies a restriction based on a particular database object of said at least one specified database object, wherein the received query did not specify said restriction.

A non-transitory computer-readable medium storing instructions, which, when executed by one or more processors, cause performance of:nstoring, within database objects managed by a database system, files contained in a plurality of identifiable groups of one or more files, each identifiable group containing at least one file of said files;in said database, storing metadata that, for each identifiable group of one or more files of said plurality of identifiable groups, defines one or more constraints, wherein said one or more constraints includes a physical constraint that specifies that storage of any file in said each identifiable group of one or more files is restricted to storage in a database in at least one specified database object from a group consisting of (a) a particular one or more database tables, (b) a particular one or more database table partitions, and (c) a particular one or more database views;wherein for at least two of said groups of one or more files, a first group includes a first data file that is restricted to a first database object and a second group includes a second data file that is restricted to a second database object; wherein the first database object is different than the second database object;in response to receiving said query:nbased on (1) said query and (2) the one or more constraints defined by the metadata, said database system making a determination of how data required by the query is stored in said database;based on the determination on how data required by the query is stored in said database, rewriting the query to generate a re-written query that specifies a restriction based on a particular database object of said at least one specified database object, wherein the received query did not specify said group; andexecuting the re-written query that specifies a restriction based on said specified database object.