摘要:
The present invention relates to collecting statistics automatically for data in a database. There is provided a method for automated statistics collection comprising determining a likelihood that statistics for data have changed; and collecting statistics for data in response to the likelihood. Indicators of the likelihood that statistics have changed may be useful to trigger automated statistics collection. Tables having statistics that change significantly may be collected more often than statistics of tables that are stable. A preferred model is provided to facilitate the collection of statistics that are more relevant: a table is scheduled for collection in accordance with observed patterns of table activity; a table is considered for collection if it meets a threshold level of activity; and a table is sampled to predict whether the statistics to be collected have changed. When collecting statistics, throttling and lock contention can minimize impact on a database user's response experience.
摘要:
An adaptive throttling system for minimizing the impact of non-production work on production work in a computer system is provided. The adaptive throttling system throttles production work and non-production work to optimize production. The adaptive throttling system allows system administrators to specify a quantified limit on the performance impact of non-production or utility work on production work. The throttling rate of the utility is then automatically determined by a supervisory agent, so that the utilities' impact is kept within the specified limit. The adaptive throttling system adapts dynamically to changes in workloads so as to ensure that valuable system resources are well utilized and utility work is not delayed unnecessarily.
摘要:
Regulating the execution of software execution units to manage the performance impact of administrative utilities is disclosed. Administrative utilities (e.g., filesystem and database backups, garbage collection in the Java Virtual Machines, etc.) are an essential part of the operation of production systems. Performance impact is managed through the use of throttling, either external or internal, which forces utilities to slow down their processing by a configurable amount. While a variety of criteria may be used for throttling, a self-induced sleep in preferred for internal throttling.
摘要:
Systems and methods for seismic data acquisition employing a dynamic multiplexing technique. The dynamic multiplexing technique may include advancing one or more modules in a seismic array through a multiplexing signature sequence in successive transmission periods. The multiplexing signature sequence may be random or pseudo-random. A shared multiplexing signature sequence may be used at all the modules in the seismic array. As such, modules belonging to a common collision domain may operate out of phase with respect to the shared multiplexing signature sequence.
摘要:
Presented are systems and methods for wireless data acquisition. The wireless data acquisition may involve synchronizing modules within a data acquisition array. The synchronized data acquisition array may be used to facilitate a seismic survey. Synchronization may be facilitated by receipt of a reference time event such that a clock is synchronized based on the reference time event.
摘要:
Systems and methods for seismic data acquisition employing a dynamic multiplexing technique. The dynamic multiplexing technique may include advancing one or more modules in a seismic array through a multiplexing signature sequence in successive transmission periods. The multiplexing signature sequence may be random or pseudo-random. A shared multiplexing signature sequence may be used at all the modules in the seismic array. As such, modules belonging to a common collision domain may operate out of phase with respect to the shared multiplexing signature sequence.
摘要:
A method and system for improving memory access patterns of software systems on NUMA systems discovers NUMA system resources, where the NUMA system resources comprises a plurality of NUMA nodes; determines a plurality of database threads, processes, and objects for a database configuration; and generates a policy which assigns the plurality of database threads, processes, and objects to the plurality of NUMA nodes, wherein the generating is performed prior to initialization of the plurality of database threads, processes, and objects. The assignment of the database threads, processes, or objects to NUMA nodes is such that the amount of remote memory accesses is reduced. When the database thread, process, or object initializes, the database server queries the policy for its assigned NUMA node(s). The database thread, process, or object is then bound to the assigned NUMA node(s). In this manner, the costs from remote memory accesses are significantly reduced.
摘要:
Systems and methods for seismic data acquisition employing a dynamic multiplexing technique. The dynamic multiplexing technique may include advancing one or more modules in a seismic array through a multiplexing signature sequence in successive transmission periods. The multiplexing signature sequence may be random or pseudo-random. A shared multiplexing signature sequence may be used at all the modules in the seismic array. As such, modules belonging to a common collision domain may operate out of phase with respect to the shared multiplexing signature sequence.
摘要:
Presented are systems and methods for wireless data acquisition. The wireless data acquisition may involve synchronizing modules within a data acquisition array. The synchronized data acquisition array may be used to facilitate a seismic survey. Synchronization may be facilitated by receipt of a reference time event such that a clock is synchronized based on the reference time event.
摘要:
Presented are systems and methods for wireless data acquisition. The wireless data acquisition may involve synchronizing modules within a data acquisition array. The synchronized data acquisition array may be used to facilitate a seismic survey. Synchronization may be facilitated by receipt of a reference time event such that a clock is synchronized based on the reference time event.