摘要:
A database processing system for analyzing a query issued to a database to generate a corresponding execution procedure for performing database processing in accordance therewith. A plurality of columns for storing data each constituted by a set of instances and conditions concerning the instances constituting the plurality of columns are entered. A query is inputted which contains a predicate for evaluating whether a set of instances which meet the designated conditions and which can be identified with the same subscript exists among the sets of instances stored in the plurality of columns. In response to the query, a decision is made as to whether or not an index has been generated for one or plural columns specified in the query predicate. When the index is generated, the index is accessed to acquire an identifier of table data which is “true” for a predicate. Unless the index is generated, a decision is then made as to whether or not column data acquired by accessing the database meet the conditions specified in the predicate contained in the query.
摘要:
Multiple key ranges are correlated with multiple data storage areas provided in memory. In storing data in a database, the data is stored in the data storage area correlated with the key range containing the data. When the addition of a data storage area as mentioned above is needed, a given volume of data is moved from the multiple data storages to the newly added data storage area and the key ranges for the moved data are correlated with the data storage areas.
摘要:
A database management system for executing database operations in parallel by a plurality of nodes and a query processing method for it are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.
摘要:
This manufacturing method of batteries that comprises the steps of accommodating a battery element 4 in an envelope film body 3 of which one end side is opened to form an opening 3a for injecting an electrolytic solution; and sealing the opening 3a after the electrolytic solution 12 is injected from the opening 3a of the envelope film body 3; wherein an opening 3a side of the envelope film body 3 is made larger than a prescribed shape and dimension to use as a temporary reservoir region 3c of an injected electrolytic solution 12, after injection of a prescribed amount of the electrolytic solution 12 the region 3d of the prescribed shape and dimension being sealed and cut to form a battery. According to the method, a manufacturing method of batteries that can not only make smaller and lighter the batteries but also mass-produce batteries of high quality can be provided.
摘要:
A database management system for executing database operations in parallel by a plurality of nodes and a query processing method are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process, and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.
摘要:
An area in a page for a tuple-oriented file system is exclusively controlled such that a tuple is added to, deleted from or updated in a page including a tuple area in use, a vacant area having a deleted tuple and an unoccupied area. In the case where a transaction is active for increasing the total size of the vacant area in a given page, the particular vacant area is locked to prevent another active parallel transaction from using the same vacant area. During the time when the transaction for increasing the total size of the vacant area remains active, other transactions can add a tuple to the unoccupied area or update a tuple in use in the same page to the extent that the particular page is not compacted. The transaction for increasing the total size of the vacant area can perform a special compaction for collecting a plurality of discrete vacant areas into a continuous vacant area without increasing the unoccupied area in the page. The roll back operation can thus be executed securely.
摘要:
In a data base processing method including a central processing unit for analyzing a plurality of queries made from a plurality of users so as to determine an internal processing procedure with respect to a data base, and for performing the internal processing procedure; a secondary storage for storing data capable of being shared by each user; and, an input/output controlling processing unit including at least one cache storage, for controlling a transfer of a plurality of records which are required for input/output processing operations between the central processing unit and secondary storage. The data base processing method is featured in that a decision is made whether or not a prefetching operation is carried out at a start of an input/output processing operation by judging the internal processing procedure which has been formed by the query; a retrieval range into which a record to be fetched has been stored is formed when the prefetching operation is performed; and, a prefetching record number is determined as an input/output processing demand unit, taking account of an access characteristic of the internal processing procedure and also a system characteristic containing a size of the cache storage, a performance, of the central processing unit, and a traffic of the input/output processing unit.
摘要:
This analysis system analyzes the behavior of a DBMS in a computer system having a computer which executes tasks in parallel and reads data from a database (DB) when executing a query. This analysis system acquires the number of selected rows corresponding to a key value of an index key used in the query, and calculates a model-based predicted degree of processing parallelism of the processing corresponding to the query. The system acquires, from the storage device, event information on an input-output event with respect to the storage medium when the processing corresponding to the query is executed actually, calculates a measured degree of processing parallelism when the processing corresponding to the query is executed actually, based on the event information, and displays information based on the model-based predicted degree of processing parallelism and the measured degree of processing parallelism.
摘要:
According to one embodiment, a lighting device includes a radiation surface, at least one light source provided to face the radiation surface, and an optical control member provided between the radiation surface and the light source and includes optical characteristics of transmission, diffraction, diffusion, and reflection, which vary for regions in the optical control member, a distribution of each of the optical characteristics being determined by positions relative to the at least one light source. The optical control member is formed in a sheet shape which is controlled by at least one of a reflective film having a reflection factor distribution, and a reflective film having a numerical aperture distribution, and lenses.
摘要:
It is provided a database processing method including: a first step of receiving a query request instructing to output the requested data as query results in a designated order; a second step of generating a query execution plan including an order of accessing tables for storing the data based on the received query request; a third step of acquiring the data requested based on the query request from the database based on the generated query execution plan; a fourth step of generating intermediate results including the acquired data; a fifth step of sorting the generated intermediate results in the designated order; a sixth step of judging, for each of the intermediate results, whether an order of the sorted intermediate results has been determined; and a seventh step of outputting the intermediate results whose order has been determined as the query results in order from a head thereof.