Oracle Database In-Memory (DBIM) provides orders of magnitude speedup for analytic queries with its highly compressed, transactionally consistent, memory-optimized Column Store. Customers can use Oracle DBIM for making real-time decisions by analyzing vast amounts of data at blazingly fast speeds. Active Data Guard (ADG) is Oracle's comprehensive solution for high-availability and disaster recovery for the Oracle Database. Oracle ADG eliminates the high cost of idle redundancy by allowing reporting applications, ad-hoc queries and data extracts to be offloaded to the synchronized, physical Standby database replicated using Oracle ADG. In Oracle 12.2, we extended the DBIM advantage to Oracle ADG architecture. DBIM-on-ADG significantly boosts the performance of analytic, read-only workloads running on the physical Standby database, while the Primary database continues to process high-speed OLTP workloads. Customers can partition their data across the In-Memory Column Stores on the Primary and Standby databases based on access patterns, and reap the benefits of fault-tolerance as well as workload isolation without compromising on critical performance SLAs. In this paper, we explore and address the key challenges involved in building the DBIM-on-ADG infrastructure, including synchronized maintenance of the In-Memory Column Store on the Standby database, with high-speed OLTP activity continuously modifying data on the Primary database.

This study presents a testbed for the emergency call (eCall) system satisfying the 3GPP TS 26.267/268/269 standard. Experiments are performed with the in‐vehicle system testbed in a laboratory or a car travelling in city, suburb, countryside or freeway. Sufficient data of the emergency communication signal is recorded and processed. Fading statistics of the received signal after power control are found and discussed with cumulative distribution function of the received signal power, level crossing rate and average fade duration. It is found that with probability less or equal to , fading and attenuation can vary from dB for the continuous wave (CW) signal at 500 Hz to dB for the CW signal at 2000 Hz. It is recommended to move the CW signals at 500 and 800 Hz for detection and synchronisation in the 3GPP standard to be at 1500 and 2000 Hz, respectively. This will give 9.5 dB improvement in detection and synchronisation. The longest fade duration observed is 540 ms. The 64 ms synchronisation signal in the current standard is insufficient to handle the fading. It is shown that fading is minimised in the frequency range [1000, 2500] Hz for the 3GPP TS 26.267 system.

Oracle's Real Application Cluster (RAC) allows multiple database instances to run on different server nodes in a cluster against a shared set of data files. A critical aspect of an Oracle RAC system is that of instance recovery. When a node suffers from a hardware failure, or a database instance suffers from a software failure, instance recovery is performed by a surviving instance to ensure that the database remains in a consistent state. High-availability comes from the surviving database instances, each running on a surviving node, that are still able to provide database services. During instance recovery, the set of database resources that are in need of recovery must be identified, locked and then repaired. Until such time as the identification and locking of these resources has been done, Oracle needs to block any requests by database clients to all database resources. The whole database appears to be frozen during this time, a period that is called application brown-out. In the interests of availability it is therefore important that instance recovery endeavors to keep this period of identification and locking as short as possible. In doing so, not only is the brown-out period reduced, but also the overall time to make available those resources that need repair, is reduced. This paper describes the use of a Buddy Instance, a mechanism that significantly reduces the brown-out time and therefore also, the duration of instance recovery. Each database instance has a buddy database instance whose purpose is to construct in-memory metadata that describes the resources needing recovery, on a continuous basis at run-time. In the event of node or instance failure, the buddy instance for the failed instance uses the in-memory metadata in performing instance recovery. The buddy instance mechanism was introduced in the 12.2.0.1 release of Oracle Database to minimize and potentially eliminate the period of identification of resources needing recovery. This mechanism was enhanced in the 12.2.0.2 release of Oracle Database by the construction of a Bloom filter that temporarily serves the purpose of locking the identified resources, thereby enabling the database to be made available sooner than was previously the case.

The European Union (EU) emergency call (eCall) employs the GSM voice channel for vehicle emergency data transmission. However, fading statistics of the GSM voice channel after power control has not been discussed previously. This paper reports the power measurements for the end-to-end GSM voice channel with an in-vehicle system (IVS) transmitter in laboratory or on freeway. The data reveals that strong fading still exists in the GSMvoice channel after power control, which can cause severe packet loss and delay in the emergency call.

In traditional manufacture enterprises, a popular production mode is parallel lines within a department and sequential between departments. Such production mode may cause a large buffer between departments, long and complex transportation routes, and components mismatched at the assembly department. Based on the concept of collaborative production, this paper proposes a mathematical model and relative algorithm for collaborative production of products with components of different colors. A case study has been used to validate the proposed model, and the related future value stream mapping has been reached, compared with the current value stream mapping. The analysis results show that the proposed approach is promising.