In the case of passengers taking the subway many times in a short time, missing cards in and out of the station, and staying in the subway station for a long time, the previous table join method cannot accurately set the time threshold parameters and correctly match the OD pairs of passengers. In order to solve these problems, an OD matching method based on analysis function is proposed in this paper. LAG () is an analytic function in Oracle which allows you to access the row at a given offset prior to the current row without using a self-join. Metro IC card dataset stores the card swiping records of passengers entering and leaving the subway station every time. In this method, the dataset is sorted in ascending order according to the card number and card swiping time, and then, the lag function of Oracle is used to take the offset of the upper line of card ID, transaction date, transaction time, in and out sign, and station ID. Finally, the matching process is completed according to the OD conditions of card number, time, and inbound and outbound sign fields. This method does not need to set a time threshold and so as to deal with the situation where passengers stay too long in the subway station. The OD matching results on in and out IC swiping cards dataset in April and May 2019 of passengers of Xiamen Metro Line verify that analysis function method has better OD matching, missing swiping identification accuracy, and effect compared to the table join method.

中文翻译：

---

基于分析函数的地铁IC卡数据OD匹配

在乘客短时间内多次乘坐地铁、进出站漏卡、长时间停留在地铁站的情况下，之前的表格join方法无法准确设置时间阈值参数并正确匹配OD 对乘客。为了解决这些问题，本文提出了一种基于分析函数的OD匹配方法。滞后 ()是 Oracle 中的一个分析函数，它允许您在不使用自联接的情况下访问当前行之前给定偏移处的行。地铁IC卡数据集存储了乘客每次进出地铁站的刷卡记录。该方法根据卡号和刷卡时间对数据集进行升序排序，然后利用Oracle的滞后函数取卡ID、交易日期、交易时间的上一行的偏移量，在和出站标志，以及站号。最后根据卡号、时间、出入境标志字段的OD条件完成匹配过程。该方法不需要设置时间阈值，以应对乘客在地铁站停留时间过长的情况。