A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is represented as a relational schema in the relational database. The multi-dimensional database has one or more dimensions. Each dimension has one or more members. The relational schema includes a fact table and one or more related dimension tables. Additionally, the fact table has a dimension column for all but o...

The present invention relates to a technique for interfacing a plurality of remote terminals, as, for example, Craft Access Terminals (CATs), directly to a central database in a system, such as, for example, a Craft Access System, without interfacing with an intermediate center such as, for example, a centralized Repair Service Bureau and its personnel. An Applications Processor Microcomputer (APM) module includes a General Data Transport (GDT) to provide a powerful microprocessing environment a...

A "return on investment" digital database usage metering, billing, and security system includes a hardware device which is plugged into a computer system bus (or into a serial or other functionally adequate connector) and a software program system resident in the hardware device. One or more databases are encrypted and stored on a non-volatile mass storage device (e.g., an optical disk). A tamper-proof decrypting device and associated controller decrypts selected portions of the stored database ...

A laser pattern inspection and/or writing system which writes or inspects a pattern on a target on a stage, by raster scanning the target pixels. Inspection can also be done by substage illumination with non-laser light. A database, organized into frames and strips, represents an ideal pattern as one or more polygons. Each polygon's data description is contained within a single data frame. The database is transformed into a turnpoint polygon representation, then a left and right vector represent...

A method is disclosed for enforcing referential constraints on a record-by-record basis, immediately before or after each record is manipulated and while the record is still accessed, significantly improving the system's performance. Each record is visited only once to do both the constraint checking and the manipulation (insert/update/delete). If the constraint checking fails, then the entire relational operation of which the record manipulation is a part is backed out. For insertions, each rec...

A method of operating a computer system to store and retrieve information in a database uses a signature file of the database that is divided into subsets. A word signature is mapped to a particular subset during creation of the file and the same mapping information is used to retrieve the information in response to a query word. Each word signature is a logical word signature and has two components a physical word signature and a subset designation field. In this way, when information is retrie...

In a data-base system including a data-base management system, a dictionary device for managing definition information and generation management information in a data base, and a dictionary file for storing the generation management information, a generation management system is provided between the data-base management system and a data storage file to acquire data in accordance with the generation management information, the dictionary device is made independent of the data-base management sys...

A real-time database management system in which data generated by a producer process is buffered in a plurality of update buffers and transmitted asynchronously into a consumer process, such as a database management system, so that neither the producer process nor the consumer process has to halt operations during I/O requests and data is not lost.

A database or some portion thereof is partitioned into ownership groups. Each ownership group is assigned one or more database servers as owners of the ownership group. The database servers that are assigned as owners of an ownership group are treated as the owners of all data items that belong to the ownership group. That is, they are allowed to directly access the data items within the ownership group, while other database servers are not allowed to directly access those data items. Accordingl...

A system and method for routing database requests from application logic to a cache and a database, including receiving a database request from the application logic, determining whether the database request is informational or transactional, routing the database request to the cache if the database request is informational, and routing the database request to the database if the database request is transactional. A first example embodiment includes a database which is accessed using a first dri...