Enscribe is one of the database for HP Non Stop Tandem, it is a file system database which has. High Level Access to Database. Ensures Data Integrity. Partitioned Files. Five disk file structures. Transaction auditing through TMF. Some of the features & terminology used for Ensribe file systems: File – Collection of records. Format 1 and Format 2 – It’s a static attribute and is established when the file is created. If the size of the file is less then 2GB-1MB then its format 1 file else Format 2 file. Cache buffering. Record locking and file locking. Sector – The smallest unit of disk I/O.
The NonStop SQL/MP relational database management system combines the standard features of a relational database with additional features that provide data integrity,high availability, high performance, and excellent scalability. NonStop SQL/MP is specifically designed for large data processing environments that maintain a variety of applications performing critical business tasks. RDBS Relational Data Base Management System. Used for storage and retrieval of data. Data can be treated as 2-dimensional tables “Relations”. Data can be combined from multiple tables. Complex data access can be achieved using only a single command. SQLCI NonStop SQL/MP Conversational Interface Command. SQLCI [/ [IN <in-file>] [, OUT <list-file>] , [, NOWAIT] [, <run-option>]
Enform is a part of ENCOMPASS Distributed Data Base Management System. It is primarily used to retrieve data from Enscribe database, perform calculations, sort and group the retrieved database. Enform can return the data in form of a file, on the screen or to the spooler. Important terms: Database – It consists of the physical files which actually contains the data on which one needs to perform query. Dictionary – It is a collection of description of the structure of each record in the database. Enform accesses the dictionary obtains information about the record descriptions and stores that information in the internal table of the