摘要:
According to an aspect of an embodiment, a method for managing a database for records of transactions, each of the transaction specifying an order of processing, and being associated with a value related to generation of the transaction, said database comprising a plurality of page data containing a plurality of records, each of the records comprising data and information indicative of the value of one of said transactions, the method comprising the steps of: reading out one of said page data containing a target record of request of a transaction associated with the target record from said database; evaluating each value associated with the transactions in the page data; and invaliding the record associated with a value greater than a predetermined value.
摘要:
Database management involving obtaining a request of update of a record of a database including: (i) pages with records, each including data and transaction identification information (XID) that has a range that is divided by a predetermined range; and (ii) generation identification information (GID) that is increased when the XID's value exceeds the divided range, where the page includes a GID header indicating the earliest GID of the records of the page. Also, reading a page's GID header when switching pages, comparing the GID header with the present GID of the present XID, and performing a freeze process to the record having the XID included in the page's GID header when the GID header's value is less than the difference between the GID's value to which the present XID belongs and a predetermined value.
摘要:
A conductor transmits a commit processing request to directors in response to a commit request received from an application. Upon receipt of a response to the commit processing request from any one of the directors, the conductor notifies the application of a successful commit. If there is a pending transaction due to a failure in a director, the conductor instructs the director to process the pending transaction upon recovery from the failure. If a failure occurs in the conductor during transmission of the commit processing request and the commit processing request is not received by any of the directors, the conductor inquires the director whether there is a pending transaction after recovery from the failure, and instructs the director to process the pending transaction based on a processing result of the pending transaction obtained from another director.
摘要:
A data presentation device with a memory storage area being used without any futility is disclosed. The data presentation device has a function of preparing on a memory and displaying on a display the first through Nth records of presentation target data group in designated sort data that is obtained when sorting all the presentation target data within a database under designated sort conditions in a form that does not store in the memory the presentation target data assured of being the (N+1)th through the last records of data, and a function of preparing on the memory and displaying on the display the ((K+1)·(N+1))th through the ((K+2)·N)th records of presentation sort data group in the designated sort data in a form that limits the processing target presentation sort data within the database by use of a value of a sort key within the ((K+1)·N)th record of presentation sort data displayed on the display when instructed to display the next presentation sort data group and in a form that does not store in the memory the presentation sort data assured of being unrequired.
摘要:
A data presentation device with a memory storage area being used without any futility is disclosed. The data presentation device has a function of preparing on a memory and displaying on a display the first through Nth records of presentation target data group in designated sort data that is obtained when sorting all the presentation target data within a database under designated sort conditions in a form that does not store in the memory the presentation target data assured of being the (N+1)th through the last records of data, and a function of preparing on the memory and displaying on the display the ((K+1)·(N+1))th through the ((K+2)·N)th records of presentation sort data group in the designated sort data in a form that limits the processing target presentation sort data within the database by use of a value of a sort key within the ((K+1)·N)th record of presentation sort data displayed on the display when instructed to display the next presentation sort data group and in a form that does not store in the memory the presentation sort data assured of being unrequired.
摘要:
A conductor transmits a commit processing request to directors in response to a commit request received from an application. Upon receipt of a response to the commit processing request from any one of the directors, the conductor notifies the application of a successful commit. If there is a pending transaction due to a failure in a director, the conductor instructs the director to process the pending transaction upon recovery from the failure. If a failure occurs in the conductor during transmission of the commit processing request and the commit processing request is not received by any of the directors, the conductor inquires the director whether there is a pending transaction after recovery from the failure, and instructs the director to process the pending transaction based on a processing result of the pending transaction obtained from another director.