Oracle9i性能评估方法

首先介绍对Oracle9i数据库服务器性能查看结果,确定数据库系统缓存的大小,定位整个系统瓶颈,然后作出详细分析,最后定位数据库系统的问题.     

Exploring public bicycle network structure based on complex network theory and shortest path analysis: the public bicycle system in Yixing,China

A well-functioning public bicycle system relates not only to its mode of operation, vehicle allocation, rental station layout and vehicle leasing configuration, but also the bicycle network structure and its formation. However, the latter aspects have been widely overlooked in China. Here, we help to further attract more researchers to conduct relevant studies and make suggestions for the development of public bicycle transport in many small and medium-sized cities across the world. We demonstrate how to explore the public bicycle network structure of a county-level Chinese city – Yixing – known for its clay ware and tourism. We show that complex network theory and shortest path analysis technology are useful in characterizing the public bicycle network structure, in aspects such as network topology, the spatial distribution of sub-networks and traffic flows. Finally, the paper proposes relevant urban planning strategies.     

同场分站跨场信号设计方案

阳逻电厂工业站与新港铁路香炉山站由于产权原因及不同专用线接轨位置原因,电厂工业站位于香炉山车站车场中间位置,与香炉山站同场分站,香炉山站本站的接发车列调车进路需要穿越电厂站控制区咽喉道岔。因此需要针对此种特殊的站场布局设计满足且利于运营需求的信号联锁方案。本次设计通过三区域联锁条件互送,虚拟信号机协助实现阳逻电厂工业站与香炉山站各自独立联锁,跨站进路分段办理。该信号设计方案可供类似工程参考借鉴。     

基于轨迹数据的共享电动自行车逆行风险行为影响因素研究

为改善电动自行车带来的交通安全问题,研究逆行风险行为与其影响因素间的相关关系。基于长沙市芙蓉区共享电动自行车GPS轨迹数据,实现逆行行为的精准识别,采用机器学习CatBoost模型与SHAP可解释机器学习框架,从道路条件、交通状态、土地利用性质等方面开展逆行行为影响要素挖掘及作用解析。研究结果表明：CatBoost模型能够有效预测路段逆行频次并提取逆行行为的重要影响因素,主要包括出行时段、公共交通设施、土地利用性质、道路条件及交通状态等;从出行时段来看,工作日、早晚高峰时段更容易发生逆行;从公共交通设施与土地利用性质来看,道路周围公交站地铁站出口数量及餐饮、公司、购物等设施数量与逆行频次呈现非线性影响关系,在一定范围内设施数量与逆行行为存在正影响作用;从道路条件来看,过街通道间距在50~400 m时不易发生逆行,在非机动车道无物理隔离设施或过街通道间距在400~600 m时容易发生逆行,间距大于600 m时作用不稳定;从路段机非分隔形式来看,护栏分隔的逆行概率较低,绿化带分隔的逆行概率较高;从交通状态来看,当骑行速度、加速度较低或较高时与逆行行为负相关,当骑行速度在6~16 km·h^-1及加速度在0.3~1.0 m·s^-2时与逆行行为正相关。研究成果可为共享电动自行车风险骑行行为辨识、非机动车交通安全管理提供有效的技术支持。     

学校接送中心配置研究——以常州为例

通过对学校接送中心的作用、设置目的及包含设施内容进行深入阐述,提出了接送中心分两个阶段分析的总体思路,总结了学校出行调查、接送中心配置研究涉及的相关因素和方法、对外交通组织要求、设施布局原则及相关流线和设施的交通组织设计方法等,并通过案例进行了实际阐述。实施结果表明,提出的接送中心配置方法,切实有效,对建设管理起到了积极作用。     

自行车赛场设计研究

以日照自行车赛场工程为例,通过赛车场跑道的形式、跑道的最大坡度、跑道的构造以及跑道面层动摩擦系数、看台视线和跑道曲线控制的分析和阐述,对自行车赛场设计进行探讨。针对日照自行车赛场通过多年承担全国性场地比赛的考验,验证其技术参数取值的正确性,以冀为今后类似工程设计提供技术参考。     

共用站厅换乘车站的设计接口和施工接口

以长沙市轨道交通分期建设的1、3号线共用站厅换乘车站侯家塘站为例,从接口划分原则、设计和施工范围、工程预留接口等方面,对车站土建、机电系统和装修专业的设计接口及施工接口进行分析,梳理出合理的设计和施工方案,减少分期建设的两条线路在设计、施工、运营过程中的相互干扰和影响,最后给出换乘车站建设过程中的注意事项。     

Roll angle estimator based on angular rate measurements for bicycles

ABSTRACT

Measuring the roll angle of single-track vehicles has always been a challenging task; however, accurate and reliable measurements of this magnitude are paramount for controlling the stability of these vehicles, both for autonomous riding and for safety reasons. A roll angle estimation is also useful in other situations, such as tests to perform the identification of the parameters of the rider control. In this work, a new algorithm is presented for estimating the roll angle of bicycles. This estimator, based on the well-known Kalman filter, employs a wheel speed sensor to approximate the speed of the vehicle, and three angular rate sensors, which are currently small and affordable sensors. The proposed method was implemented in a microcontroller and tested in a bicycle and the results were compared with measurements obtained with optical sensors, showing a good correlation. Although it has not been tested in motorcycles, comparable results are expected.     

法国巴黎自行车租赁业务及对我国的启示

自行车因具有节能、环保、灵活等优点在发达国家正越来越受青睐，自行车租赁业务也随之产生．近几年我国对这一问题的研究也在不断深化。本文首先从租赁系统、费用、所产生的问题几方面介绍了巴黎市的自行车租赁业务，并在此基础上就国内开展租赁业务提出了一些见解．     

Prohibited–permitted right-turn phasing strategy based on capacity analysis of right-turn movements

In traffic-crowded metropolitan areas, such as Shanghai and Beijing in China, right-turn vehicles that operate with a permitted phase at signalized intersections are normally permitted to filter through large numbers of pedestrians and bicycles. To alleviate such conflicts and improve safety, traffic engineers in Shanghai introduced a prohibited–permitted right-turn operation, adding a subphase to the permitted phase in which right-turns are prohibited. Unfortunately, the prohibited subphase would reduce the capacity of right-turn movements when it prohibits right turns even if there are few pedestrians and bicycles crossing the street. This paper aims at quantifying the impact of both non-vehicular flows and the prohibited subphase on the right-turn capacity, and then proposes a strategy to determine appropriate prohibited–permitted right-turn operation that minimizes the capacity reduction caused by the prohibited subphase. To achieve this goal, we improved the pedestrian and bicycle adjustment factor described in the Highway Capacity Manual by taking into account: (1) the variety in space competition between pedestrians and bicycles, and (2) the effect of two conflict zones in each phase on right-turn operation. In addition, we revised the capacity estimation model in the Highway Capacity Manual, and developed a model based on bicycle/pedestrian volume fluctuation to describe the capacity reduction due to both non-vehicular flows and the prohibited subphase. Furthermore, we proposed a timing strategy for the onset and duration of appropriate prohibited subphase. When bicycle and pedestrian volumes are low, the actuated strategy turns to the permitted phase. When these volumes are moderate, the strategy turns to the prohibited–permitted operation. With the volumes increasing, the prohibited subphase onset advances and duration increases. In these two scenarios, the new strategy has higher right-turn capacity than the current pretimed prohibited–permitted operation. Unfortunately, when bicycle and pedestrian volumes are high, the strategy yields similar right-turn capacity. However, the new prohibited subphase has less potential vehicle–bicycle and vehicle–pedestrian conflicts.