Indexing of database queries
View Patent ↗Making data available from a database is disclosed. Making data available includes specifying a query function having a query function name, wherein the query function includes a structure and a member, determining the structure and the member included in the query function, wherein the query function has a query function name and includes the structure and the member, creating an index for the structure on the member, and compiling the query function to be available to a user by invoking the query function name without the user having to specify the structure and the member. Retrieving data from a database is disclosed. Retrieving includes invoking a query function that specifies a plurality of structures and a value, accessing a cross index of the plurality of structures, and using the cross index to access the data.
1. A method of making data available from a DNS database, including:
specifying a query function for querying the DNS database, wherein the query function has a query function name and includes a structure and a member;
creating an index for the structure on the member;
compiling the query function to be available to a user by invoking the query function name without the user having to specify the structure and the member, wherein compiling the query function includes automatically generating and storing the index for the structure on the member when the query function is compiled, and wherein the query to the DNS database for the member in the structure can be satisfied by accessing the generated index; and
automatically updating the index each time a write operation performed on the DNS database affects the index.
2. A method as recited in claim 1 , wherein the query function is specified in a cross index structure.
3. A method as recited in claim 1 , wherein the member is a key that uniquely identifies an object.
4. A method as recited in claim 1 , wherein the index includes a list of objects.
5. A method as recited in claim 1 , wherein the index includes a plurality of lists corresponding to each of the possible values of the member.
6. A method as recited in claim 1 , wherein the index includes a list of keys wherein each key uniquely identifies an object.
7. A method as recited in claim 1 , wherein the query function is specified in a markup language.
8. A method as recited in claim 1 , wherein the structure and the member are specified in a markup language.
9. A method as recited in claim 1 , wherein the query function, the structure, or the member is specified in Extensible Markup Language (XML).
10. A computer program product embodied in a non-transitory computer readable medium and comprising computer instructions for:
specifying a query function for querying the DNS database, wherein the query function has a query function name and includes a structure and a member;
creating an index for the structure on the member;
compiling the query function to be available to a user by invoking the query function name without the user having to specify the structure and the member, wherein compiling the query function includes automatically generating and storing the index for the structure on the member when the query function is compiled, and wherein the query to the DNS database for the member in the structure can be satisfied by accessing the generated index; and
automatically updating the index each time a write operation performed on the DNS database affects the index.
11. A computer program product as recited in claim 10 , wherein the query function is specified in a cross index structure.
12. A computer program product as recited in claim 10 , wherein the query function is specified in a markup language.
13. A computer program product as recited in claim 10 , wherein the structure and the member are specified in a markup language.
14. A system for making data available from a DNS database, including:
a computer processor configured to:
specify a query function for querying the DNS database, wherein the query function has a query function name and includes a structure and a member;
create an index for the structure on the member;
compile the query function to be available to a user by invoking the query function name without the user having to specify the structure and the member, wherein to compile the query function includes automatically generating and storing the index for the structure on the member when the query function is compiled, and wherein the query to the DNS database for the member in the structure can be satisfied by accessing the generated index;
automatically update the index each time a write operation performed on the DNS database affects the index; and
a memory coupled with the computer processor, wherein the memory provides the computer processor with instructions.