DATABASE SYSTEM
First Claim
1. A database system in which a database server executing processing based on a data control request and a storage are connected via a communication line, whereinthe storage includesa data area that stores a database,a transaction information storage area that stores transaction information including a start log or an end log for transaction processing,a journal log storage area that stores a journal log including writing state of the data to the storage based on the data control request, anda first circuit that manages lock state and the writing state of target data in the storage, and records the journal log in the journal log storage area, andthe database server includes a second circuit that, upon receipt of the data control request, determines the transaction information storage area from a combination of the subject database server and a unit of division of processing executing the transaction processing, and writes the transaction information into the determined transaction information storage area.
2 Assignments
0 Petitions
Accused Products
Abstract
According to one embodiment, there is provided a database system in which a database server and a storage are connected via a communication line. The storage includes a data area, a transaction information storage area, a journal log storage area, and a first circuit. The database server includes a second circuit. The second circuit writes transaction information into the transaction information storage area determined from a combination of the subject database server and a unit of division of processing executing transaction processing.
-
Citations
20 Claims
-
1. A database system in which a database server executing processing based on a data control request and a storage are connected via a communication line, wherein
the storage includes a data area that stores a database, a transaction information storage area that stores transaction information including a start log or an end log for transaction processing, a journal log storage area that stores a journal log including writing state of the data to the storage based on the data control request, and a first circuit that manages lock state and the writing state of target data in the storage, and records the journal log in the journal log storage area, and the database server includes a second circuit that, upon receipt of the data control request, determines the transaction information storage area from a combination of the subject database server and a unit of division of processing executing the transaction processing, and writes the transaction information into the determined transaction information storage area.
-
8. A database system in which a storage and a connection circuit are wired under a predetermined standard on a circuit board, the storage including node circuits configured to have non-volatile memory and a node controller controlling the non-volatile memory and to be connected together in a grid pattern, and the connection circuit being connectable to an external device, wherein
the connection circuit has a database server function, the database server function including a circuit that determines position of target data in transaction processing and performs an operation related to the target data based on a data control request, and records transaction information in a transaction information storage area, the transaction information including a start log or an end log for the transaction processing, the non-volatile memory includes a data area that stores a database, and a journal log storage area that stores a journal log for use in a restoration process of the database system, the node controller performs a writing process temporarily writing data to be written into the database and a commitment process confirming the temporarily written writing data, based on an instruction from the database server function, and records procedures of the processes in the journal log, part of the non-volatile memory in the storage has the transaction information storage area that stores the transaction information, and the circuit determines, upon reception of the data control request, the transaction information storage area from a combination of the subject database server and a unit of division of processing executing the transaction processing, and writes the transaction information into the determined transaction information storage area.
-
20. A database system including a database server and a storage storing a database, wherein
the storage includes a first log storage area that stores a first log indicative of start or end of transaction processing, and a second log area that stores writing state of data, and the database server writes the first log into the first log storage area determined by a unit of division of processing for which a data control request is accepted.
Specification