Abstract

Abstract
Databases provide an efficient way to store, retrieve and analyze data. Oracle relational database is one of the most popular database management systems that is widely used in a different variety of industries and businesses. Therefore, it is important to guarantee that the database access and data manipulation is optimized for reducing database system response time. This paper intends to analyze the performance and the main optimization techniques (Forall, Returning, and Bulk Collect) that can be adopted for Oracle Relational Databases. The results have shown that the adoption of Forall and Bulk Collect approaches bring significant benefits in terms of execution time. Furthermore, the growth rate of the average execution time is lower for Bulk Collect than Forall. However, adoption of Returning approach doesn't bring significant statistical benefits.

Abstract
The increase of variable renewable energy generation has brought several new challenges to power and energy systems. Solutions based on storage systems and consumption flexibility are being proposed to balance the variability from generation sources that depend directly on environmental conditions. The widespread use of electric vehicles is seen as a resource that includes both distributed storage capabilities and the potential for consumption (charging) flexibility. However, to take advantage of the full potential of electric vehicles' flexibility, it is essential that proper incentives are provided and that the management is performed with the variation of generation. This paper presents a research study on the impact of the variation of the electricity prices on the behavior of electric vehicle's users. This study compared the benefits when using the variable and fixed charging prices. The variable prices are determined based on the calculation of distribution locational marginal pricing, which are recalculated and adapted continuously accordingly to the users' trips and behavior. A travel simulation tool was developed for simulating real environments taking into account the behavior of real users. Results show that variable-rate of electricity prices demonstrate to be more advantageous to the users, enabling them to reduce charging costs while contributing to the required flexibility for the system.

Abstract
Transmission Expansion Planning (TEP) problem aims at identifying when and where new equipment as transmission lines, cables and transformers should be inserted on the grid. The transmission upgrade capacity is motivated by several factors as meeting the increasing electricity demand, increasing the reliability of the system and providing non-discriminatory access to cheap generation for consumers. However, TEP problems have been changing over the years as the electrical system evolves. In this way, this paper provides a detailed historical analysis of the evolution of the TEP over the years and the prospects for this challenging task. Furthermore, this study presents an outline review of more than 140 recent articles about TEP problems, literature insights and identified gaps as a critical thinking in how new tools and approaches on TEP can contribute for the new era of renewable and distributed electricity markets.

Abstract
This Letter discusses the benefits of introducing Machine Learning techniques in multi-view streaming applications. Widespread use of machine learning techniques has contributed to significant gains in numerous scientific and industry fields. Nonetheless, these have not yet been specifically applied to adaptive interactive multimedia streaming systems where, typically, the encoding bit rate is adapted based on resources availability, targeting the efficient use of network resources whilst offering the best possible user quality of experience (QoE). Intrinsic user data could be coupled with such existing quality adaptation mechanisms to derive better results, driven also by the preferences of the user. Head-tracking data, captured from camera feeds available at the user side, is an example of such data to which Recurrent Attention Models could be applied to accurately predict the focus of attention of users within videos frames. Information obtained from such models could be used to assist a preemptive buffering approach of specific viewing angles, contributing to the joint goal of maximising QoE. Based on these assumptions, a research line is presented, focusing on obtaining better QoE in an already existing multi-view streaming system

Abstract
Wind energy sources have created new challenges in power system scheduling to follow the network load. Gas fired units with high ramping could better deal with inherent uncertainties of wind power compared to other power generation sources. The natural gas system constraints affect the flexibility of natural gas- fired power plants in the electrical market. In this paper, three solutions have been proposed to cover the challenges of gas system constraints and the uncertainty of wind power: 1) using information-gap decision theory (IGDT) based robust approach to address the uncertainty caused by the intrinsic nature of wind power, 2) Integration of compressed air energy storage (CAES), and demand response (DR) in day-ahead scheduling and 3) considering flexible ramping products in order to ensure reliable operations, there must be enough ramp to eliminate the variability of wind power in real-time dispatch stage. This paper proposes an IGDT-based robust security constrained unit commitment (SCUC) model for coordinated electricity and natural gas systems with the integration of wind power and emerging flexible resources while taking the flexible ramping products into account. Numerical tests demonstrate the effect of emerging flexible resources on a reduction of system operation cost and the uncertainty of predicted wind power.