What is claimed is:
1. A computer system comprising:
initialization memory containing initialization code,
a processor coupled to said initialization memory for executing said initialization code,
a static random access memory coupled to said processor for use in executing said initialization code.
2. The apparatus of claim 1 wherein said static random access memory is assigned addresses overlaying a portion of the addresses assigned to said initialization memory.
3. The apparatus of claim 2 further including logic for selecting the initialization memory when the processor needs to read initialization code and for selecting the static random access memory when the processor needs to read or write to random access memory.
4. The apparatus of claim 1 further including dynamic random access memory coupled to said processor, wherein said initialization code is for initializing said dynamic random access memory.
5. The apparatus of claim 4 wherein said processor uses primarily only said dynamic random access memory when executing application code.
6. A method for operating a computer system comprising;
providing initialization software in a initialization memory coupled to a processor,
providing static random access memory coupled to the processor,
executing the initialization code in the processor while using the static random access memory to store and retrieve variables needed by the code.
7. The method of claim 6 wherein said computer system includes dynamic random access memory and said initialization code is for initializing said dynamic random access memory.
8. The method of claim 7 further including using primarily only said dynamic random access memory when executing application code in said processor.
9. A computer system comprising:
dynamic random access memory,
initialization memory containing initialization code for initializing the dynamic random access memory at system startup, and
a static random access memory functional at system startup.
10. Th e system of claim 9, further including:
a processor coupled to said initialization memory for executing said initialization code upon system startup and coupled to said static random access memory for use in executing said code.
11. The system of claim 10 wherein said processor is coupled to said static random access memory after system startup for use in executing system code other than said initialization code.
12. The system of claim 9 wherein said static random access memory is assigned addresses overlaying a portion of the address space assigned to said initialization memory.
13. The system of claim 12 further including means for selecting said static random access memory when said processor is executing said initialization code.
14. A computer system comprising:
dynamic random access memory,
initialization memory containing initialization code for initializing the dynamic random access memory at system startup,
a processor coupled to said initialization memory for executing said initialization code,
a static random access memory coupled to said processor for use in executing said initialization code, said static random access memory connected to and powered by a system power supply which remains active whenever AC power is supplied to the computer system.
The claims below are in addition to those above.
All refrences to claim(s) which appear below refer to the numbering after this setence.
1. A method for querying a database, the method comprising:
classifying records in a database, including queries stored as records, into one or more categories specified in a multidimensional categorization scheme, each category having one or more category dimensions, each category dimension providing an access path to records in the database, wherein classifying records into the one or more categories is based on any one of a content of the record and metadata generated for the record;
generating relationship metadata for the record in the database, the relationship metadata including:
category relationship metadata identifying relationships among the one or more categories into which the record was classified and other categories specified in the multidimensional categorization scheme, and
record relationship metadata identifying relationships between the record and other records in the database, including other records classified as belonging to a same one or more categories into which the record was classified;
responsive to the query retrieving:
all records related to any category into which the query is classified, and
all records related to the retrieved records; and
responsive to the query returning a subset of the retrieved records remaining after excluding those records determined not likely to successfully answer the query based on the relationship metadata generated for the retrieved records.
2. The method of claim 1, further comprising:
accumulating usage statistics for a retrieved record based on user actions associated with the retrieved record in response to the query, including determining whether the retrieved record successfully or unsuccessfully answered the query; and
updating the relationship metadata generated for the retrieved record based on the accumulated usage statistics.
3. The method of claim 2, wherein determining those records not likely to successfully answer the query based on the relationship metadata includes computing a statistical likelihood that a record retrieved in response to the query would successfully answer the query based on the accumulated usage statistics.
4. The method of claim 1, further comprising:
accessing a cluster group identifying additional relationships between the record and other records in the database, the additional relationships based on relationship metadata identifying a category or record as having related items, each related item representing data that can be related to data contained in the records; and
responsive to the query retrieving records identified as having relationships to the retrieved records based on accessing the cluster group.
5. The method of claim 4, wherein the related items can be any one or more of data identifying a product, feature, solution, and problem in a knowledge base associated with the database.
6. The method of claim 4, wherein returning the subset of the retrieved records includes returning the subset of the retrieved records remaining after excluding those records determined not likely to successfully answer the query based the relationship metadata accessed in the cluster group.
7. The method of claim 1 wherein the database is hosted by a multitenant database system (MTS), the MTS storing data in the database for multiple tenants, each tenant’s data segregated from other tenants’ data using a unique tenant identifier (ID), and further wherein the relationship metadata generated for records of a tenant is stored in a user defined database (UDD) associated with the unique tenant ID.
8. A computer-implemented system for querying a database, the system comprising:
a server configured to receive queries against a database, the database containing records, including queries stored as records, classified into one or more categories specified in a multidimensional categorization scheme, each category having one or more category dimensions, each category dimension providing an access path to records in the database, wherein classifying records into the one or more categories is based on any one of a content of the record and metadata generated for the record;
a processor in communication with the server and the database, the processor having instructions for generating relationship metadata for the record in the database, the relationship metadata including:
category relationship metadata identifying relationships among the one or more categories into which the record was classified and other categories specified in the multidimensional categorization scheme, and
record relationship metadata identifying relationships between the record and other records in the database, including other records classified as belonging to a same one or more categories into which the record was classified; and
wherein responsive to the query, the processor carries out instructions for processing the query based on the relationship metadata, including instructions to:
retrieve all records related to any category into which the query is classified and all records related to the retrieved records,
exclude from the retrieved records those records determined not likely to successfully answer the query based on the relationship metadata generated for the retrieved records, and
return to the server the retrieved records not so excluded.
9. The computer-implemented system of claim 8, wherein the instructions for generating relationship metadata for the record in the database, further includes instructions for:
accumulating usage statistics for a retrieved record based on user actions associated with the retrieved record in response to the query, including determining whether the retrieved record successfully or unsuccessfully answered the query; and
updating the relationship metadata generated for the retrieved record based on the accumulated usage statistics.
10. The computer-implemented system of claim 9, wherein the instructions for processing the query based on the relationship metadata, further includes instructions to:
compute a statistical likelihood that a record retrieved in response to the query would successfully answer the query based on the accumulated usage statistics; and
determining those records not likely to successfully answer the query based on whether the computed statistical likelihood fails to meet a predetermined threshold for records likely to successfully answer the query.
11. The computer-implemented system of claim 9, wherein responsive to the query, the processor carries out further instructions for processing the query based on the relationship metadata, including further instructions to:
access a cluster group identifying additional relationships between the record and other records in the database, the additional relationships based on relationship metadata identifying a category or record as having related items, each related item representing data that can be related to data contained in the records; and
retrieve all records identified as having relationships to the retrieved records based on accessing the cluster group.
12. The computer-implemented system of claim 11, wherein the related items can be any one or more of data identifying a product, feature, solution, and problem in a knowledge base associated with the database.
13. The computer-implemented system of claim 11, wherein responsive to the query, the processor carries out the instructions to return to the server the retrieved records not so excluded based on the relationship metadata of records retrieved based on accessing the cluster group.
14. The computer-implemented system of claim 8, wherein the database is hosted by a multitenant database system (MTS), the MTS storing data in the database for multiple tenants, each tenant’s data segregated from other tenants’ data using a unique tenant identifier (ID), and further wherein the relationship metadata generated for records of a tenant is stored in a user defined database (UDD) associated with the unique tenant ID.
15. An article of manufacture comprising a computer readable storage medium having content stored thereon, which when executed, cause a machine to perform operations including:
classifying records in a database, including queries stored as records, into one or more categories specified in a multidimensional categorization scheme, each category having one or more category dimensions, each category dimension providing an access path to records in the database, wherein classifying records into the one or more categories is based on any one of a content of the record and metadata generated for the record;
generating relationship metadata for the record in the database, the relationship metadata including:
category relationship metadata identifying relationships among the one or more categories into which the record was classified and other categories specified in the multidimensional categorization scheme, and
record relationship metadata identifying relationships between the record and other records in the database, including other records classified as belonging to a same one or more categories into which the record was classified;
responsive to the query retrieving:
all records related to any category into which the query is classified, and
all records related to the retrieved records; and
responsive to the query returning a subset of the retrieved records remaining after excluding those records determined not likely to successfully answer the query based on the relationship metadata generated for the retrieved records.
16. The article of manufacture of claim 15, wherein the operations performed by the machine further include:
accumulating usage statistics for a retrieved record based on user actions associated with the retrieved record in response to the query, including determining whether the retrieved record successfully or unsuccessfully answered the query; and
updating the relationship metadata generated for the retrieved record based on the accumulated usage statistics.
17. The article of manufacture of claim 16, wherein determining those records not likely to successfully answer the query based on the relationship metadata includes computing a statistical likelihood that a record retrieved in response to the query would successfully answer the query based on the accumulated usage statistics.
18. The article of manufacture of claim 15, wherein the operations performed by the machine further include:
accessing a cluster group identifying additional relationships between the record and other records in the database, the additional relationships based on relationship metadata identifying a category or record as having related items, each related item representing data that can be related to data contained in the records; and
responsive to the query retrieving records identified as having relationships to the retrieved records based on accessing the cluster group.
19. The article of manufacture of claim 18, wherein the related items can be any one or more of data identifying a product, feature, solution, and problem in a knowledge base associated with the database.
20. The article of manufacture of claim 18, wherein returning the subset of the retrieved records includes returning the subset of the retrieved records remaining after excluding those records determined not likely to successfully answer the query based the relationship metadata accessed in the cluster group.
21. The article of manufacture of claim 15, wherein the database is hosted by a multitenant database system (MTS), the MTS storing data in the database for multiple tenants, each tenant’s data segregated from other tenants’ data using a unique tenant identifier (ID), and further wherein the relationship metadata generated for records of a tenant is stored in a user defined database (UDD) associated with the unique tenant ID.