 Dual sided photographic album leaf and method of making |
| Referring the FIGS. 1 and 2, there is illustrated a dual sided album leaf 10 made in accordance ... |
|
| Dual sided photographic album leaf and method of making |
| OF THE INVENTION Referring the FIGS. 1 and 2, there is illustrated a dual sided album leaf 10 made ... |
|
| Method and system for producing an internet page description file on a digital imaging device |
| The present invention provides an inexpensive method and system for capturing images and generating ... |
|
| System and method for improved compression of DCT compressed images |
| A system is described that provides methods for improved compression of images that have been ... |
|
| Navigation apparatus using a position index and information representative of roads and institutions |
| It is an object of the present invention to provide a moving object navigation apparatus which can ... |
|
| Method for producing a storage medium with a map |
| it is an object of the invention to provide a method of the kind set forth which produces a storage ... |
|
| Method for organizing map data |
| To address these and other objectives, the present invention comprises a method of organizing map ... |
|
| Method, system and article of manufacture for identifying regularly traveled routes |
| OF THE PRESENTLY PREFERRED EMBODIMENT(S) Referring now to the drawings, and particularly to FIG. 1,... |
|
| Spatial morphing of text to accommodate annotations |
| Footnotes, headnotes, sidenotes, or other margin-borne annotations are widely employed in books and ... |
|
| Category specific sort and display instructions for an electronic device |
| Accordingly, embodiments of the present invention provide an electronic device having a mechanism ... |
|
|
Collecting statistics in a database system
| Details |
Inventors: Brown, Douglas P.; Chaware, Jeetendra;
Assignee: NCR Corporation (Dayton, OH)
Primary Examiner: Choules; Jack
Assistant Examiner:
Attorney, Agent or Firm: Trop, Pruner & Hu, P.C.
Statistics regarding at least one attribute (or column) of a table in a database system are collected using an enhanced mechanism for faster collection. The statistics collection is based on scanning a sample of rows of a given table, with the sample being less than all the rows of the table. The percentage of rows to be read is specified in a statement submitted to the database system. The database system then uses the specified percentage to read the sample rows from the table for collecting statistics on the at least one attribute. |
|
DETAILED DESCRIPTION In the following description, numerous details are set forth to provide an understanding of the present invention.
However, it will be understood by those skilled in the art that the present invention may be practiced without these details and that numerous variations or modifications from the described embodiments are possible.
FIG.
1 shows an example arrangement of several target database systems (14A, 14B), a test system 10, and a client system 20.
In one example, the target database system 14A is located at a first customer site, while the target database system 14B is located at a second customer site.
Essentially, each target database system 14 is a production system that is used by a customer.
The test system 10 is used to test database software before the database software is released for loading on the target database systems 14.
Note that although a separate client system 20 and test system 10 are shown, they can actually be combined into one system.
The client system 20 includes a system emulation tool 22, an index wizard client module 24, a visual explain and compare module 54, and a demography interface 25.
The tasks of each of these modules are described in further detail below.
In some embodiments, the index wizard client module 24, in combination with an index wizard server module 50 executable in the test system 10 or an index wizard server module 53 in a target database system 14, provide an improved mechanism of performing index selection on tables stored in a database system, such as one of the target database systems 14A, 14B.
An index is a structure in a database system that provides relatively rapid access to rows of a table based on the values of one or more columns.
An index stores data values and pointers to rows in the base table where those data values occur.
An index can be arranged in ascending or descending order, so that the database management system can quickly search the index to find the particular value in the base table.
The database management system follows the associated pointer to locate the row in the base table containing the value
|
| Related patents |
|
|
Interaction with query data
OF THE INVENTION In describing the operation of the system, for clarity, reference will be made to the operation of classes whereas it is to be understood that it is ...
|
|
|
Apparatus and method for verifying compatibility of system components
Each component of a plurality of interacting system components is associated with a version identifier, which in the preferred embodiment is an integer value. The ...
|
|
|
Method and computer-readable medium for installing an upgrade to an application program
The present invention is directed to a method, and computer-readable medium for upgrading an application using an installer program. The installer program recognizes ...
|
|
|
Data base duplication method of using remote copy and database duplication storage subsystem thereof
With the intention of reducing the data transfer time based on the copying of DB table data by use of the scheme of automatic prior data duplication, such as the remote ...
|
|
|
Content-addressable (associative) memory devices
According to one aspect of the present invention there is provided a compound associative memory for use with a data-parallel computer, the memory comprising: a bit-...
|
|
|
Tag location monitor
Accordingly, it is an object of the present invention to provide a monitor of a communication network for a tag location system which employs tags that transmit data ...
|
|
|
Multichannel audio distribution system having portable receivers
The present invention therefore provides a system adapted for distribution of differing information to a plurality of mobile users. The distributed information is ...
|
|
|
Synchronization manager for standardized synchronization of separate programs
Briefly, the present invention provides a centralized, standardized mechanism for managing the synchronization of data between local and remote computers according to ...
|
|
|
System, method, and computer program product for workflow processing using internet interoperable electronic messaging with mime multiple content type
The inventors propose transreceiving workflow specifications using electronic messaging with messages having a content type "multipart" in a MIME header and a content ...
|
|
|
Apparatus and system for providing fee-based content
The invention claimed is: 1. An information processing system which includes a server and one or more information processing apparatuses and enables the information ...
|
|
|
Databases 
