Fully integrated architecture for user-defined search
AssigneeInternational Business Machines Corporation
InventorsGene Y. C. Fuh, Nelson Mendonca Mattos, Brian Thinh-Vinh Tran, Yun Wang
Life of this patent
Estimating the term…
Abstract
A method, apparatus, and article of manufacture for a computer-implemented integrated architecture for user-defined search. A statement is executed in a database stored on a data storage device connected to a computer, and the database contains data. Under control of the database, a statement is received that requests manipulation of the data. The statement includes a user-defined function. An index of a user-defined index type is used to access the data. The user-defined function is processed with the accessed data.
Claims22
A method of executing a statement in a database stored on a data storage device connected to a computer, the database containing data, the method comprising the steps of:
- under control of the database,
- receiving the statement requesting manipulation of the data, wherein the statement includes a user-defined function;
- using an index of a user-defined function index type to access the data, wherein the index of the user-defined function index type is in the database;
- and
- after using the index, processing the user-defined function with the accessed data.
An apparatus for executing a statement, comprising:
- a computer having a data storage device connected thereto, wherein the data storage device stores a database containing data;
- and
- one or more computer programs, performed by the computer, for under control of the database, receiving the statement requesting manipulation of the data, wherein the statement includes a user-defined function, for using an index of a user-defined function index type to access the data, wherein the index of the user-defined function index type is in the database, and, after using the index, processing the user-defined function with the accessed data.
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instruction executable by the computer to perform method steps for executing a statement in a database stored on a data storage device connected to a computer, wherein the database contains data, the method comprising the steps of:
- under control of the database,
- receiving the statement requesting manipulation of the data, wherein the statement includes a user-defined function;
- using an index of a user-defined function index type to access the data, wherein the index of the user-defined function index type is in the database;
- and
- after using the index, processing the user-defined function with the accessed data.
A data storage device for storing a database containing data for access by a computer program being executed by a computer system, comprising:
- a data structure in the data storage device, the data structure including information resident in a database used by the computer program and including:
- user-defined data types for defining data types;
- user-defined functions for manipulating data;
- user-defined index types for creating user-defined indexes to be used to access data that is processed with one or more user-defined functions, wherein the user-defined indexes are in the database;
- and
- at least one table containing at least one column for data of a user-defined data type.
Dependencies are inferred from the claim text.