Abstract: Provided is a database management apparatus, having a processor, a memory, and a storage device, whereby a database which is stored in the storage device is managed, the database management apparatus further comprising: a query acceptance unit which accepts a query to the database; a query execution plan generating unit which generates a query execution plan which includes a database operation which is necessary for executing the accepted query; and a query execution unit which, in executing the accepted query on the basis of the generated query execution plan, dynamically generates a task for executing the database operation, and executes the dynamically generated task. The query execution unit acquires a resource usage state, and, when executing the next database operation, generates a new task on the basis of the resource usage state, and executes the new task in parallel with the task.

Abstract: 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.

Abstract: The present invention relates to a technology for verifying relevance of data. One object of the present invention is to suppress increase in time required for verifying relevance of data. According to one embodiment of the present invention, a computer system includes: a storage apparatus configured to provide a storage area formed by storage devices; and a computer configured to manage data. The storage area is configured to store a plurality of pieces of data. The plurality of pieces of data include a first piece of data associated with a second piece of data. The computer is configured to: verify whether or not the first piece of data is normally associated with the second piece of data; and start, when the plurality of pieces of data are verified, verification for one piece of data irrespective of whether or not verification for another piece of data is complete.

Abstract: 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.

Abstract: A database management system (DBMS) performs, in response to a conversion request to convert a store format of a table in a database, a process (base type change process) for changing a store format indicated by information (base type) indicating the store format of the table to a store format according to the conversion request, and performs a data conversion process asynchronously with the aforementioned process. In an import process after the base type change process, the DBMS imports, into the table, a chunk in the store format indicated by the base type after change. In the data conversion process, the DBMS converts a chunk in a store format different from the store format indicated by the base type into a chunk in the store format indicated by the base type.

Abstract: There is a storage apparatus which provides a storage area, comprises a cache memory, reads data into the cache memory from the storage area according to a read request and sends the data from the cache memory, and a computer is coupled to the storage apparatus. The computer receives a data processing request, determines an access usage based on the data processing request (or, the information relating to an access usage of the data processing request), selects a logical device corresponding to the determined access usage from a plurality of logical devices which are allocated to the storage area and issues a read request to the selected logical device.

Abstract: A computer system includes: a database server configured to execute a database management system; and a storage apparatus configured to store data. The storage apparatus is configured to have a power saving function for switching between a sleep mode for reducing power consumption of the storage apparatus and an active mode for enabling read and write of the data. The database management system is configured to be executed by the arithmetic device, to thereby: receive a query for reading or writing data; analyze the received query to create an execution plan; identify a volume for reading and writing data; and select an execution plan for which power consumption satisfies a predetermined threshold value based on power consumption information on the identified volume.

Abstract: A database management system generates an execution plan by performing the following (A) and (B): (A) processing of dividing a provisional execution plan that is an access path into one or more query processing blocks that are each a simultaneously executable processing range, the access path being specified on the basis of a received query and indicating an execution order of database operation; and (B) processing of determining, for each of the one or more query processing blocks, whether an execution cost decreases by changing an inner configuration of the query processing block on the basis of at least one of a processing time, performance, and the number of storage devices for one or more processing in the query processing block, and changing the inner configuration of the query processing block when a determination result is true.

Abstract: An acceleration sensor includes a CV conversion circuit, an AD conversion circuit, and first and second registers. The CV conversion circuit outputs a voltage corresponding to the capacitance changes between a movable electrode and each of first and second fixed electrodes disposed to face the movable electrode. The AD conversion circuit is connected to the CV conversion circuit and has a first detection range and a second detection range. The first register is connected to the AD conversion circuit and holds a first value. The second register is connected to the AD conversion circuit and holds a second value. The first value contains information about an acceleration in the first detection range, and the second value contains information about an acceleration in the second detection range. The first and second values indicate accelerations in the same direction.

Abstract: A connection assembly includes a sensor substrate, a layer substrate coupled to the sensor substrate so as to face an upper surface of the sensor substrate, and a wire connected between the sensor substrate and the layer substrate. The sensor substrate includes first and second projections provide on the upper surface of the sensor substrate and extending in an extension direction along the upper surface of the sensor substrate. The wire has a first end sandwiched between the layer substrate and the first projection, and a second end sandwiched between the layer substrate and the second projection. The connection assembly provides reliable connection.

Abstract: A wiring-buried glass substrate includes a glass substrate and a first wiring. The glass substrate includes a first surface, a second surface perpendicular to the first surface, and a third surface facing the first surface. The first wiring includes a first pillar portion and a first beam portion. The first pillar portion extends in a first direction perpendicular to the first surface of the glass substrate. The first beam portion is connected to a first surface of the first pillar portion and extends to a second direction perpendicular to a second surface of the glass substrate. The first wiring is buried in the glass substrate. The first surface of the first beam portion is exposed from a third surface of the glass substrate.

Abstract: Since storage devices are activated in the issuance order of I/O commands, the time required for processing of a plurality of I/O commands based on one or more I/O requests may become long. When issuance destinations of two or more I/O commands are two or more storage devices in a non-activated state from among a plurality of storage devices, a computer system determines an activation order of the two or more storage devices on the basis of two or more I/O quantities which respectively correspond to the two or more storage devices. Each of the I/O quantities of the two or more storage devices is an I/O quantity in accordance with one or more I/O commands for the relevant storage device from among the two or more I/O commands. The computer system activates the two or more storage devices in the determined activation order.

Abstract: A database management system has a query interface for receiving a query and a query executor for executing the received query. The query executor dynamically generates a task, and executes a plurality of tasks in parallel. In execution of each task, each time data is required to be read from a database, the query executor generates a task for acquiring the data, and in execution of the generated task, issues a data read request for reading the data from the database, to thereby shorten a time taken to execute each task.

Abstract: 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.

Abstract: A database management system (DBMS) generates a query execution plan including information indicating one or more database (DB) operations necessary to execute the query. The DBMS dynamically generates a task for executing the DB operation in execution of the query. The DBMS performs a determination processing of simultaneous-task-generation number when newly creating a task. The determination processing of simultaneous-task-generation number is to calculate the number of simultaneous task generation, which is the number of tasks that can be generated simultaneously, based on the number of tasks which can be newly generated, a first memory resource amount which is the amount of memory resources necessary to be allocated per task newly generated, and a second memory resource amount which is the number of memory resources that can be newly allocated. The number of tasks generated dynamically and simultaneously is equal to or smaller than the calculated number of simultaneously generatable tasks.

Abstract: 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.

Abstract: Provided is a computer system, including: a storage apparatus configured to provide a storage area formed by storage devices; and a computer configured to manage data, in which the storage area is configured to store a plurality of pieces of data, in which the plurality of pieces of data include a piece of data associated with another piece of data, and in which the computer is configured to: verify whether or not the piece of data is normally associated with the another piece of data; and start, when the plurality of pieces of data are verified, verification for one piece of data irrespective of whether or not verification for another piece of data is complete.

Abstract: 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 in accordance with the query execution plan. In the execution of the query, the DBMS dynamically generates tasks for executing the DB operations and executes the dynamically generated tasks. The query execution plan includes a plurality of query blocks, which are sets of one or more DB operations. When newly generating a task, the DBMS executes determination processing of simultaneous-task-generation number. The determination processing of simultaneous-task-generation number is to calculate, targeting each of the query blocks, the number of simultaneous task generation, which is the number of tasks simultaneously generatable as tasks for executing the query block. The number of the dynamically generated tasks is equal to or smaller than the number of simultaneous task generation.

Abstract: A MEMS device includes a movable section, a frame, a beam, and an electrode substrate. The frame surrounds a surrounding of the movable section. The beam extends from at least a part of the frame, and is connected to the movable section. The electrode substrate includes a fixed electrode, an extended electrode, and a substrate section. The fixed electrode is formed on the electrode substrate in at least a part of a region facing a swing section. The extended electrode is connected to the fixed electrode, and is formed on the electrode substrate in at least a part of a region facing the shaft.

Abstract: As an I/O method of issuing an I/O request, there are a synchronous I/O method, in which a task is in a waiting state until an I/O response to the I/O request is returned and an asynchronous I/O method, in which another task can be executed before an I/O response to the I/O request is returned. When issuing an I/O request in execution of a task, a DBMS selects any one of the synchronous I/O method and the asynchronous I/O method, based on an I/O response speed of an I/O destination storage device and issues an I/O request according to the selected I/O method.