会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 2. 发明授权
    • Data ETL method applied to real-time data ETL system
    • 数据ETL方法应用于实时数据ETL系统
    • US08335758B2
    • 2012-12-18
    • US12644871
    • 2009-12-22
    • Wei ChangZhigang YuShuquan LiuGuoxiang LiuPengcheng ShenQing LanGuozhen BianFeng Zhang
    • Wei ChangZhigang YuShuquan LiuGuoxiang LiuPengcheng ShenQing LanGuozhen BianFeng Zhang
    • G06F9/46G06F7/00
    • G06F17/30563
    • The data ETL (Extraction-Transformation-Loading) dispatching method of the present invention is applied to a real-time data ETL system, wherein a main ETL dispatching engine executes tasks according to preset sequence. In the execution, some key information are memorized by the main ETL dispatching engine, such as lscycle (latest successful data cycle), curcycle (current processing data cycle), and endcycle (processing end data cycle), etc., and are transferred to called programs. After the execution of the called programs, the main ETL dispatching engine records and keeps the updated dispatching information. In the data re-extraction, the data ETL dispatching method is adopted for the automatic re-extraction of some tasks and some cycles therein. The data ETL dispatching method, solves the problem caused by cyclic closed-loop extraction in traditional ETL dispatching programs according to timestamps in the real-time data ETL system, simplifies the tasks of the called program by allowing the called programs to focus on its own business logic, thereby giving sufficient development time for the real-time data ETL field, resulting in greatly enhancing the efficiency of project implementation.
    • 本发明的数据ETL(提取 - 转换 - 加载)调度方法应用于实时数据ETL系统,其中主ETL调度引擎根据预设顺序执行任务。 在执行中,主要的ETL调度引擎记录了一些关键信息,如lscycle(最新成功数据周期),curcycle(当前处理数据周期)和endcycle(处理结束数据周期)等,并转移到 称为程序。 执行被调用程序后,主ETL调度引擎记录并保存更新的调度信息。 在数据重新提取中,采用数据ETL调度方式自动重新提取一些任务及其中的一些周期。 数据ETL调度方法根据实时数据ETL系统中的时间戳解决了传统ETL调度程序中循环闭环提取引起的问题,简化了被调用程序的任务,允许被调用的程序集中在自己的 业务逻辑,从而为实时数据ETL领域提供充足的开发时间,大大提高了项目实施的效率。
    • 3. 发明申请
    • Polling Method of Switch Status Based on Timer-triggered Scheduler of Stored Procedures
    • 基于定时触发调度器存储过程的开关状态轮询方法
    • US20100179957A1
    • 2010-07-15
    • US12645048
    • 2009-12-22
    • JUNHUA ZHOUHAIHUA SONGLIBIN SUNXIWEI HUANGGUOXIANG LIU
    • JUNHUA ZHOUHAIHUA SONGLIBIN SUNXIWEI HUANGGUOXIANG LIU
    • G06F17/30
    • H04L43/10H04L41/024H04L43/0817
    • The polling method of switch status based on Timer-triggered Scheduler of Stored Procedures is to create interface tables related with switch status in the database including switch object table, switch type table, alarms information table which are used to store meta-information and switch status values. Then, create stored procedure of acquiring relevant switch status for each kind of switch needed for polling of switch status, and data will be filtered out and switch status will be judged via the related stored procedures, and write the status values into relevant switch status interface table; finally create regularly-executed tasks to regularly schedule each stored procedure required to poll switch status. The whole process is composed of three parts: i.e., create relevant switch status interface table; create stored procedure of acquiring switch status and setting status value; regularly-executed tasks.
    • 基于定时触发的存储过程调度器的交换机状态轮询方法是创建与数据库中交换机状态相关的接口表,包括交换机对象表,交换机类型表,用于存储元信息和交换状态的报警信息表 价值观。 然后,创建为交换机状态轮询所需的各种交换机获取相关切换状态的存储过程,并将过滤掉数据,并通过相关的存储过程判断交换机的状态,并将状态值写入相关的交换机状态界面 表; 最后创建定期执行的任务,以定期调度轮询切换状态所需的每个存储过程。 整个过程由三部分组成:即创建相关的开关状态界面表; 创建获取交换机状态和设置状态值的存储过程; 定期执行的任务。
    • 8. 发明申请
    • Memory Dispatching Method Applied to Real-time Data ETL System
    • 内存调度方法应用于实时数据ETL系统
    • US20100180088A1
    • 2010-07-15
    • US12644871
    • 2009-12-22
    • WEI CHANGZHIGANG YUSHUQUAN LIUGUOXIANG LIUPENGCHENG SHENQING LANGUOZHEN BIANFENG ZHANG
    • WEI CHANGZHIGANG YUSHUQUAN LIUGUOXIANG LIUPENGCHENG SHENQING LANGUOZHEN BIANFENG ZHANG
    • G06F12/00
    • G06F17/30563
    • As for the memory dispatching method applied to real-time data ETL system, the main ETL dispatching program executes one task according to preset sequence. In the execution, some key information are memorized by dispatching engine, such as lscycle (latest successful data cycle), curcycle (current processing data cycle), and endcycle (processing end data cycle), etc., are transferred to the called program. After the execution of the called program, the dispatching engine records and keeps the updated dispatching information; in the data re-extraction, memory dispatching method is adopted for the automatic re-extraction of some tasks and some cycles therein. Memory dispatching method (state-based dispatching method) solves the defect in stateless of traditional ETL dispatching program, simplifies the tasks of the called program, makes the called program focus on its own business logic through the memory state, wins plentiful development time for the real-time data ETL field, and greatly enhances the efficiency of project implementation.
    • 对于应用于实时数据ETL系统的内存调度方法,主ETL调度程序按照预设顺序执行一个任务。 在执行中,通过调度引擎记录一些关键信息,如lscycle(最新成功数据周期),curcycle(当前处理数据周期)和endcycle(处理结束数据周期)等都被传送到被叫程序。 执行被调用程序后,调度引擎记录并保存更新的调度信息; 在数据重新提取中,采用内存调度方式自动重新提取一些任务及其中的一些周期。 内存调度方法(基于状态的调度方法)解决了传统ETL调度程序的无状态缺陷,简化了被调用程序的任务,使被调用程序通过内存状态集中在自己的业务逻辑上,获得了丰富的开发时间 实时数据ETL领域,大大提高了项目实施效率。