公开(公告)号：CA2167793A1

公开(公告)日：1996-07-24

申请号：CA2167793

申请日：1996-01-22

Applicant: TANDEM COMPUTERS INC

Inventor： MADRID LOUISE M ,  MEIER RICHARD A ,  PUTZOLU FRANCO ,  SHARMA SUNIL ,  O'SHEA THOMAS J ,  TROISI JAMES H ,  ZELLER HANSJORG ,  GILBERT GARY M

IPC: G06F12/00 ,  G06F17/30 ,  G06F9/45

Abstract: An SQL program executor and an SQL compiler both include options for avoiding recompilations of execution plans whenever the runtime object and the compile time object referenced by an execution plan meet predefined schema similarity criteria. Thus, recompilation is sometimes avoided even though the compile time object has been altered or the run time object is not the same object as the compile time object. To enable late binding, schema information is stored in each execution plan for each object to be accessed by the execution plan. The stored schema information is a subset of the full object schema, and includes information about all the aspects of the objects to be accessed which must remain unchanged in order for the execution plan to be operable. While executing a compiled program, the SQL executor avoids recompilations of execution plans whenever the runtime object and the compile time object referenced by an execution plan meet predefined schema similarity criteria. When a recompilation of an SQL program is required, only the execution plans which do not meet the schema similarity criteria are recompiled if the compiled program has been assigned appropriate runtime parameters. The late binding features of the SQL executor also enable a compiled program to access objects distinct from the objects referenced by the program at compile time. Similarly, the SQL compiler includes the ability to recompile only those execution plans which do not meet the schema similarity criteria and thus are inoperable.

公开(公告)号：CA2210147A1

公开(公告)日：1996-08-01

申请号：CA2210147

申请日：1996-01-23

Applicant: TANDEM COMPUTERS INC

Inventor： USAS ALAN M ,  MURTHY SRINIVASA ,  GUPTA MINOO ,  PUTZOLU FRANCO ,  TOM GARY F ,  STRELLIS ERIC G

IPC: G06F12/00 ,  G06F9/46 ,  G06F9/54 ,  G06F17/30 ,  G06F15/163

Abstract: A multiprocessor that includes a virtual file system providing a file system interface to user application code. This interface allows users to access files in many types of file systems in a consistent, file system-independent manner. In a preferred embodiment, the higher interface of the file system is the Posix file system interface, though it can be any file system interface supporting the capabilities required by a user process. The Posix file system supports regular files, pipes, fifos and special files. A pipe server, a pipe library and a name server together implement the fifo semantics required by the Posix standard for Posix processes. The present invention provides these fifo capabilities to any process which uses the Posix interfaces.

公开(公告)号：CA2167794A1

公开(公告)日：1996-07-24

申请号：CA2167794

申请日：1996-01-22

Applicant: TANDEM COMPUTERS INC

Inventor： LYON JAMES M ,  PEARSON STEVEN R ,  PUTZOLU FRANCO ,  MOSHER MALCOLM JR

IPC: G06F11/14 ,  G06F17/30

Abstract: An improved recovery method utilizes sequence numbers to order log records and reduce the excess compensating actions due to a failure during recovery. Next undo records are written to the log after a preset number of compensating actions which include the sequence number of the record currently being scanned. After a failure, all records between the next undo record and the record having the sequence number included in the next undo record are ignored during when the log is scanned backwards.

公开(公告)号：CA2167780A1

公开(公告)日：1996-07-24

申请号：CA2167780

申请日：1996-01-22

Applicant: TANDEM COMPUTERS INC

Inventor： PUTZOLU FRANCO

IPC: G06F12/00 ,  G06F12/08 ,  G06F13/20 ,  G06F15/163

Abstract: A cache is distributed among processors in a multiple processor system with no shared memory to maintain the cached data. Each processor maintains a cache which identifies the opened files being cached, the blocks of each file which are cached and the state of caching for each file. The state of each opened file is one of "no-caching", "read-caching" and "read/write caching". So long as only one processor opens a file, and opens it for read/write access, that processor is allowed to do read/write caching on the file. When a processor opens a file for read access, that processor is allowed to do read caching, unless another processor has the file open for read/write access. After the last processor having read/write access to a file closes the file, the disk system upgrades the cache state for the file. The downgrading of the caching state is communicated via an asynchronous cache callback signal, while the upgrading of a cache is not indicated to a processor until the processor sends a disk request for the file. The replay to the request contains the new cache state.