Optimizing tables with too many columns in a database

    公开(公告)号:US10042872B2

    公开(公告)日:2018-08-07

    申请号:US14746465

    申请日:2015-06-22

    Abstract: Methods and systems for database optimization include detecting a plurality of columns in an unoptimized database that co-appear in queries to the database. The plurality of columns are compacted into a single hyper-column to form an optimized database. Each entry in the hyper-column includes data from a corresponding entry in each of the plurality of columns. An interface is generated for the optimized database that accepts queries according to a schema for the unoptimized database and translates the queries into queries according to a schema for the optimized database.

    Monitoring interesting subjects
    66.
    发明授权
    Monitoring interesting subjects 有权
    监测有趣的科目

    公开(公告)号:US09584608B2

    公开(公告)日:2017-02-28

    申请号:US14297770

    申请日:2014-06-06

    Abstract: Methods and systems for monitoring interesting subjects. A method including: selecting, based on a first collection of interesting subjects, a set of critical nodes including at least one critical node which participates in one or more interesting subjects in the first collection; and monitoring contents posted by the one or more critical nodes in the set so as to find a second collection of interesting subjects. The set of critical nodes which participate in one or more interesting subjects in the first collection of interesting subjects is selected based on the first collection, as objects to be monitored, thereby reducing the number of contents posted by the nodes to be monitored as compared with monitoring all the user nodes, so that interesting subjects such as hot news or hot events can be found in real time with high efficiency and low cost.

    Abstract translation: 监测有趣科目的方法和系统。 一种方法,包括:基于感兴趣对象的第一集合来选择一组关键节点,所述关键节点包括参与第一集合中的一个或多个感兴趣对象的至少一个关键节点; 以及监视由集合中的一个或多个关键节点发布的内容,以便找到有趣主体的第二集合。 基于作为要监视的对象的第一集合来选择参与感兴趣对象的第一集合中的一个或多个感兴趣对象的关键节点的集合,从而减少要被监视的节点发布的内容的数量, 监控所有用户节点,从而可以实时,高效率,低成本地查找热点新闻或热点事件等有趣的主题。

    HANDING OFF A TERMINAL AMONG WIRELESS ACCESS POINTS
    67.
    发明申请
    HANDING OFF A TERMINAL AMONG WIRELESS ACCESS POINTS 有权
    在无线接入点处终止终端

    公开(公告)号:US20170006516A1

    公开(公告)日:2017-01-05

    申请号:US15253991

    申请日:2016-09-01

    Abstract: A method and system for handing off a terminal among a plurality of wireless access points (APs) connected to a central management AP. The method comprising: receiving network condition information of a terminal communicatively connected to a first wireless AP among the plurality of wireless APs. Determining a second wireless AP the plurality of wireless APs to which the terminal is to be handed off based on the network condition information of the terminal. The second wireless AP is virtually connected to the terminal. Submitting a handoff request to the second wireless AP. Notifying the terminal to hand off to the second wireless AP in response to receiving a handoff response from the second wireless AP.

    Abstract translation: 一种用于在连接到中央管理AP的多个无线接入点(AP)之间切换终端的方法和系统。 该方法包括:在多个无线AP之间接收与第一无线AP通信连接的终端的网络条件信息。 基于终端的网络状况信息,确定终端要切换到的多个无线AP的第二无线AP。 第二个无线AP虚拟地连接到终端。 向第二无线AP提交切换请求。 响应于从第二无线AP接收到切换响应,通知终端切换到第二无线AP。

    Method and apparatus of estimating wave velocity of negative pressure wave in a fluid transportation pipeline
    68.
    发明授权
    Method and apparatus of estimating wave velocity of negative pressure wave in a fluid transportation pipeline 有权
    估计流体输送管道中负压波的波速的方法和装置

    公开(公告)号:US09534979B2

    公开(公告)日:2017-01-03

    申请号:US14050698

    申请日:2013-10-10

    CPC classification number: G01M3/2815

    Abstract: A method and apparatus for estimating a wave velocity of negative pressure wave in a fluid transportation pipeline. The method including: receiving a plurality of pressure signals from a plurality of sensors; determining time differences produced by the negative pressure wave reaching the adjacent sensors based on the received pressure signals; determining a wave source sensor segment where a wave source of the negative pressure wave is located; and estimating the wave velocities of the negative pressure wave in a non-wave source sensor segment and the wave source sensor segment.

    Abstract translation: 一种用于估计流体输送管线中的负压波的波速的方法和装置。 该方法包括:从多个传感器接收多个压力信号; 基于接收到的压力信号确定由负压波到达相邻传感器产生的时间差; 确定负压波的波源所在的波源传感器段; 并估计非波源传感器段和波源传感器段中负压波的波速。

    TAGGING GEOGRAPHICAL AREAS
    69.
    发明申请

    公开(公告)号:US20160381535A1

    公开(公告)日:2016-12-29

    申请号:US15259727

    申请日:2016-09-08

    Abstract: A method of tagging a geographical area includes obtaining, with a processing device, attribute information and mobile tracking data of a plurality of mobile objects, wherein the mobile tracking data comprises sampling time and corresponding sampling point locations of the mobile objects; converting the mobile tracking data of the plurality of mobile objects into new mobile tracking data according to the correspondence relationship between the sampling time and a time slices, wherein the new mobile tracking data include time slices and corresponding sampling point locations; and obtaining a set of attribute information of at least one geographical area with respect to the time slices based on the new mobile tracking data, wherein the at least one geographical area is obtained by clustering the sampling point locations.

    Tagging geographical areas
    70.
    发明授权

    公开(公告)号:US09483468B2

    公开(公告)日:2016-11-01

    申请号:US14745936

    申请日:2015-06-22

    Abstract: A method of tagging a geographical area includes obtaining, with a processing device, attribute information and mobile tracking data of a plurality of mobile objects, wherein the mobile tracking data comprises sampling time and corresponding sampling point locations of the mobile objects; converting the mobile tracking data of the plurality of mobile objects into new mobile tracking data according to the correspondence relationship between the sampling time and a time slices, wherein the new mobile tracking data include time slices and corresponding sampling point locations; and obtaining a set of attribute information of at least one geographical area with respect to the time slices based on the new mobile tracking data, wherein the at least one geographical area is obtained by clustering the sampling point locations.

Patent Agency Ranking