摘要:
A database management system (DBMS) manages a database existing in a second storage device with an access speed lower than that of a first storage device. In an execution of a query, the DBMS dynamically generates tasks two or more executable tasks in parallel. The DBMS generates task start information which is information representing a content of the execution of the task, manages the task start information, and executes a content represented by the task start information by the task. The task start information includes a data address set existing in the second storage device. The DBMS controls movement of the data address sets between the first storage device and the second storage device based on a management state of the task start information. In addition, the DBMS selects the task start information based on whether or not the data address set exists in the first storage device.
摘要:
A database management system (DBMS) generates a query execution plan including information representing one or more database (DB) operations necessary for executing a query and executes the query based on the query execution plan. In the execution of the query, the DBMS dynamically generates a task for executing a DB operation and executes the dynamically generated task. The DBMS executes a task in a plurality of threads executed by a processor core.
摘要:
A parallel data processing system includes a parallel data processing execution unit for reading a data from a data set including a first data set that includes a plurality of first data and a second data set that includes a plurality of second data and executing processing. The parallel data processing execution unit (A) reads the first data from the first data set, and acquires a first value from the first data based on first format information acquired from an application, (B) generates one or more threads for respectively reading one or more second data corresponding to the first value from the second data set based on first reference information acquired from the application, (C) executes (A) and (B) on one or more first data in the first data set, and (D) executes a plurality of the threads in parallel.
摘要:
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.
摘要:
Provided is a database system in which sorting of query results is sped up. The database system stores storage location information in which storage locations of the pieces of data are recorded in a given order. When there is no second task, which is executed based on data that is fetched in a first task, whether every piece of data requested in a third task, which is executed before the first task, has been fetched is determined. In the case where every piece of data requested in the third task has been fetched, data fetched in the first task is output. In the case where some of the data requested in the third task has not been fetched, data fetched in the first task is kept in a temporary buffer until every piece of data requested in the third task is fetched, and then output.
摘要:
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.
摘要:
According to one embodiment, a lighting device includes a light source, and a semi-transmissive reflection layer opposing the light source. The semi-transmissive reflection layer includes a pattern including transmitting portions or reflecting portions. The pattern includes a pattern formed of the transmitting portions each having a hole conformation in a region to which a high volume of light form the light source incident, and a pattern formed of the reflection portions each having a dot conformation in a region to which a low volume of light form the light source incident.
摘要:
A disaster recovery system and a method therefor, having: a function for receiving write requests from a host computer to write log information indicating the contents of a database process executed for a database buffer on a main site, database data updated on the database buffer and status information indicating the position of log information used for disaster recovery; a function for transferring the received write request for log information to a recovery site by a synchronous remote copy process; and a function for transferring the received write request for database data to the recovery site by an asynchronous remote copy process. While remote copy can be executed at a long distance without data loss, the deterioration of the performance of a database process on a main site can be suppressed.
摘要:
The present invention realize a high speed retrieval performance in a document retrieval system referring to partial data of documents including structured data such as XML documents and electric mails, without providing further memory. The present invention includes storage means for storing documents to be retrieved onto a disk device, a calculation means for calculating an allocated capacity of the memory, and storage means for saving, onto the memory, partial data of the documents stored on the disk device by the calculated allocated capacity of the memory. The present invention also includes a first retrieval means for retrieving partial data stored on the memory, determining means for determining whether or not to retrieve the documents stored on the disk device based on the result from the first retrieval, and a second means for retrieving the documents stored on the disk device based on the result from the above determination.