System and method for improved exposure of database schema information
Systems and methods for improved exposure of database schema information are disclosed. Generally, a database driver may retrieve and provide database schema information according to one of two default methods or, also, a third override method. The first default method is to execute a query on the database. The second default method is to retrieve information from a hard-coded collection stored locally at the driver. The third override method is to retrieve information from a designated file that may be updated at any time without having to update the database and/or driver binaries.
1. A method for providing database schema information comprising:
reading, by a database driver, a configuration file having default instructions for retrieving the database schema information, the default instructions being one of instructions to execute a query on a database and instructions to retrieve hard-coded information from within the configuration file;
if the default instructions are overridden, then retrieving, by the database driver, the database schema information from a designated file that is external to the database driver and to the database, whereby the designated file is generated and is updatable without altering the database driver, and whereby the designated file is accessible without accessing the database; and
if the default instructions are not overridden, then retrieving, by the database driver, the database schema information according to the default instructions
wherein retrieving the database schema information according to the default instructions comprises retrieving the database schema information according to a population mechanism node in the configuration file, the population mechanism node having one of a command to execute the query on the database and a command to retrieve the hard-coded information, and
wherein retrieving the database schema information according to the default instructions comprises retrieving the database schema information according to a population string node in the configuration file, the population string node identifying a string with which to retrieve the database schema information.
2. The method of claim 1 , further comprising identifying an override node in the configuration file that indicates that the default instructions are overridden and identifies the designated file.
3. The method of claim 1 , comprising retrieving the database schema information from the designated file that has information about at least one database feature that is unique to a most recent version of the database.
4. The method of claim 1 , wherein retrieving the database schema information according to the default instructions comprises retrieving the database schema information according to a collection name node in the configuration file, the collection name node identifying a data collection from which to retrieve the database schema information.
5. The method of claim 4 , comprising retrieving the database schema information according to the collection name node that identifies the data collection that is one of a database content collection and a database structure collection.
6. A system for providing database schema information, comprising:
a processor;
a memory;
a configuration file having default instructions for retrieving the database schema information, the default instructions being one of instructions to execute a query on a database and instructions to retrieve hard-coded information from within the configuration file; and
a database driver that retrieves the database schema information by:
if the default instructions are overridden, then retrieving the database schema information from a designated file that is external to the database driver and to the database, whereby the designated file is generated and is updatable without altering the database driver, and whereby the designated file is accessible without accessing the database, and
if the default instructions are not overridden, then retrieving the database schema information according to the default instructions
wherein the configuration file comprises a population mechanism node that has one of a command to execute the query on the database and a command to retrieve the hard-coded information, and
wherein the configuration file further comprises a population string node that identifies a string with which to retrieve the database schema information.
7. The system of claim 6 , wherein the configuration file comprises an override node that indicates that the default instructions are overridden and identifies the designated file.
8. The system of claim 6 , wherein the designated file has information about at least one database feature that is unique to a most recent version of the database.
9. The system of claim 6 , wherein the configuration file comprises:
a collection name node that identifies a data collection from which to retrieve the database schema information.
10. The system of claim 9 , wherein the data collection is one of a database content collection and a database structure collection.
11. A computer readable storage medium having stored thereon computer executable instructions for performing the following steps:
reading, by a database driver, a configuration file having default instructions for retrieving database schema information, the default instructions being one of instructions to execute a query on a database and instructions to retrieve hard-coded information from within the configuration file;
if the default instructions are overridden, then retrieving, by the database driver, the database schema information from a designated file that is external to the database driver and to the database, whereby the designated file is generated and is updatable without altering the database driver, and whereby the designated file is accessible without accessing the database; and
if the default instructions are not overridden, then retrieving, by the database driver, the database schema information according to the default instructions
wherein retrieving the database schema information according to the default instructions comprises retrieving the database schema information according to a population mechanism node in the configuration file, the population mechanism node having one of a command to execute the query on the database and a command to retrieve the hard-coded information, and
wherein retrieving the database schema information according to the default instructions comprises retrieving the database schema information according to a population string node in the configuration file, the population string node identifying a string with which to retrieve the database schema information.
12. The computer readable storage medium of claim 11 , wherein the configuration file comprises an override node that indicates that the default instructions are overridden and identifies the designated file.
13. The computer readable storage medium of claim 11 , wherein the designated file has information about at least one database feature that is unique to a most recent version of the database.
14. The computer readable storage medium of claim 11 , wherein the configuration file comprises a collection name node that identifies a data collection from which to retrieve the database schema information.
15. The computer readable storage medium of claim 14 , wherein the data collection is one of a database content collection and a database structure collection.