SG11201908969WA - Systems and methods for performing data processing operations using variable level parallelism - Google Patents

Systems and methods for performing data processing operations using variable level parallelism

Info

Publication number
SG11201908969WA
SG11201908969WA SG11201908969WA SG11201908969WA SG 11201908969W A SG11201908969W A SG 11201908969WA SG 11201908969W A SG11201908969W A SG 11201908969WA SG 11201908969W A SG11201908969W A SG 11201908969WA
Authority
SG
Singapore
Prior art keywords
nodes
layouts
international
processing
layout
Prior art date
Application number
Inventor
Garth Dickie
Original Assignee
Ab Initio Technology Llc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ab Initio Technology Llc filed Critical Ab Initio Technology Llc
Publication of SG11201908969WA publication Critical patent/SG11201908969WA/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46Multiprogramming arrangements
    • G06F9/50Allocation of resources, e.g. of the central processing unit [CPU]
    • G06F9/5061Partitioning or combining of resources
    • G06F9/5066Algorithms for mapping a plurality of inter-dependent sub-tasks onto a plurality of physical CPUs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2379Updates performed during online database operations; commit processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Design And Manufacture Of Integrated Circuits (AREA)
  • Image Generation (AREA)
  • Processing Or Creating Images (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

FIGBEGIN ACCESS INFORMATION SPECIFYINGA DATAFLOW GRAPI- h-202 —204 OBTAIN LAYOUT(S) FOR INPUT NODES OBTAIN LAYOUT(SIFOR OUTPLT NODE;S) L-206 1 ,-- 208 ASSIGN LAYOUTS \"0 INTERMEDIATE NODES OF \"FE DA - WOW GRAPH ____\"..-208a PROPAGATE LAYOUTS FRCM OUTPUT NODE(S) TO INPUT NODE(S 210 ADJACENT NODES NO HAVE MISIXCHED LAYOUTS? YES INSERT REPARTIONING OPERATION r 212 C END W O 20 18/ 18367 6 Al PROPAGATE LAYOUTS FROM INPUT NODE1S) TO OUTPUT NODES (12) INTERNATIONAL APPLICATION PUBLISHED UNDER THE PATENT COOPERATION TREATY (PCT) (19) World Intellectual Property Organization International Bureau (43) International Publication Date 04 October 2018 (04.10.2018) W I PO I PCT ill Hu omits °nolo HE mil moo mil iflo oimIE (10) International Publication Number WO 2018/183676 Al (51) International Patent Classification: GOOF 9 / 50 (2006.01) (21) International Application Number: PCT/US2018/025144 (22) International Filing Date: 29 March 2018 (29.03.2018) (25) Filing Language: English (26) Publication Language: English (30) Priority Data: 62/478,390 29 March 2017 (29.03.2017) US (71) Applicant: AB INITIO TECHNOLOGY LLC [US/US]; 201 Spring Street, Lexington, MA 02421 (US). (72) Inventor: DICKIE, Garth, Allen; 161 Parker Road, Fram- ingham, MA 01702 (US). (74) Agent: RUDOY, Daniel, G.; Wo1f, Greenfield & Sacks, P.C., 600 Atlanitc Avenue, Boston, MA 02210-2206 (US). (81) Designated States (unless otherwise indicated, for every kind of national protection available): AE, AG, AL, AM, AO, AT, AU, AZ, BA, BB, BG, BH, BN, BR, BW, BY, BZ, CA, CH, CL, CN, CO, CR, CU, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, ES, FI, GB, GD, GE, GH, GM, GT, HN, HR, HU, ID, IL, IN, IR, IS, JO, JP, KE, KG, KH, KN, KP, KR, KW, KZ, LA, LC, LK, LR, LS, LU, LY, MA, MD, ME, MG, MK, MN, MW, MX, MY, MZ, NA, NG, NI, NO, NZ, OM, PA, PE, PG, PH, PL, PT, QA, RO, RS, RU, RW, SA, SC, SD, SE, SG, SK, SL, SM, ST, SV, SY, TH, TJ, TM, TN, TR, TT, TZ, UA, UG, US, UZ, VC, VN, ZA, ZM, ZW. (84) Designated States (unless otherwise indicated, for every kind of regional protection available): ARIPO (BW, GH, GM, KE, LR, LS, MW, MZ, NA, RW, SD, SL, ST, SZ, TZ, UG, ZM, ZW), Eurasian (AM, AZ, BY, KG, KZ, RU, TJ, TM), European (AL, AT, BE, BG, CH, CY, CZ, DE, DK, EE, ES, FI, FR, GB, GR, HR, HU, IE, IS, IT, LT, LU, LV, MC, MK, MT, NL, NO, PL, PT, RO, RS, SE, SI, SK, SM, TR), OAPI (BF, BJ, CF, CG, CI, CM, GA, GN, GQ, GW, KM, ML, MR, NE, SN, TD, TG). Published: with international search report (Art. 21(3)) (54) Title: SYSTEMS AND METHODS FOR PERFORMING DATA PROCESSING OPERATIONS USING VARIABLE LEVEL PARALLELISM (57) : Techniques for determining processing layouts to nodes of a dataflow graph. The techniques include: obtaining information specifying a 200 dataflow graph, the dataflow graph comprising a plurality of nodes and a plural- ity of edges connecting the plurality nodes, the plurality of edges representing flows of data among nodes in the plurality of nodes, the plurality of nodes com- prising: a first set of one or more nodes; and a second set of one or more nodes disjoint from the first set of nodes; obtaining a first set of one or more processing layouts for the first set of nodes; and determining a processing layout for each node in the second set of nodes based on the first set of processing layouts and one or more layout determination rules, the one or more layout determination rules including at least one rule for selecting among processing layouts having different degrees of parallelism.
SG11201908969W 2017-03-29 2018-03-29 Systems and methods for performing data processing operations using variable level parallelism SG11201908969WA (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US201762478390P 2017-03-29 2017-03-29
PCT/US2018/025144 WO2018183676A1 (en) 2017-03-29 2018-03-29 Systems and methods for performing data processing operations using variable level parallelism

Publications (1)

Publication Number Publication Date
SG11201908969WA true SG11201908969WA (en) 2019-10-30

Family

ID=62063179

Family Applications (1)

Application Number Title Priority Date Filing Date
SG11201908969W SG11201908969WA (en) 2017-03-29 2018-03-29 Systems and methods for performing data processing operations using variable level parallelism

Country Status (11)

Country Link
US (2) US10817495B2 (en)
EP (2) EP4198731A1 (en)
JP (1) JP7216654B2 (en)
KR (1) KR102549994B1 (en)
CN (1) CN110612513B (en)
AU (2) AU2018243278B2 (en)
CA (1) CA3058223A1 (en)
DE (1) DE112018001789T5 (en)
SG (1) SG11201908969WA (en)
WO (1) WO2018183676A1 (en)
ZA (1) ZA201906585B (en)

Families Citing this family (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP4198731A1 (en) * 2017-03-29 2023-06-21 Ab Initio Technology LLC Systems and methods for performing data processing operations using variable level parallelism
US11188434B2 (en) 2017-12-08 2021-11-30 Ab Initio Technology Llc Systems and methods for monitoring execution of structured query language (SQL) queries
US10990595B2 (en) * 2018-05-18 2021-04-27 Oracle International Corporation Fast distributed graph query engine
CN111209309B (en) * 2020-01-13 2023-03-10 腾讯科技(深圳)有限公司 Method, device and equipment for determining processing result of data flow graph and storage medium
US11675785B2 (en) 2020-01-31 2023-06-13 Oracle International Corporation Dynamic asynchronous traversals for distributed graph queries
CN111737371B (en) * 2020-08-24 2020-11-13 上海飞旗网络技术股份有限公司 Data flow detection classification method and device capable of dynamically predicting
CA3209125A1 (en) 2021-01-31 2022-08-04 Ab Initio Technology Llc Data processing system with manipulation of logical dataset groups
US11461297B1 (en) 2021-06-09 2022-10-04 T-Mobile Usa, Inc. Ensuring database integrity using a data flow in a graph, such as for use by a wireless telecommunications service provider
US20230093911A1 (en) * 2021-09-30 2023-03-30 Ab Initio Technology Llc Systems and methods for performing data processing operations using variable level parallelism

Family Cites Families (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5966072A (en) 1996-07-02 1999-10-12 Ab Initio Software Corporation Executing computations expressed as graphs
US7047232B1 (en) * 1999-01-13 2006-05-16 Ab Initio Software Corporation Parallelizing applications of script-driven tools
JP2003256221A (en) * 2002-02-28 2003-09-10 Fujitsu Ltd Parallel process executing method and multi-processor type computer
US7249141B2 (en) * 2003-04-30 2007-07-24 Microsoft Corporation Automated layout of relational databases
US7155612B2 (en) 2003-04-30 2006-12-26 International Business Machines Corporation Desktop database data administration tool with row level security
CN101165650B (en) * 2003-06-25 2012-10-10 起元科技有限公司 Computer-aided parallelizing of computation graphs
US7716630B2 (en) 2005-06-27 2010-05-11 Ab Initio Technology Llc Managing parameters for graph-based computations
US7870556B2 (en) * 2006-05-16 2011-01-11 Ab Initio Technology Llc Managing computing resources in graph-based computations
US20080140622A1 (en) 2006-12-12 2008-06-12 Bestgen Robert J Displaying Explain Data for a SQL Query of a Database
US7979578B2 (en) * 2009-09-02 2011-07-12 International Business Machines Corporation Dynamic and evolutionary placement in an event-driven component-oriented network data processing system
US9665620B2 (en) * 2010-01-15 2017-05-30 Ab Initio Technology Llc Managing data queries
US9208141B2 (en) 2010-02-05 2015-12-08 Oracle International Corporation Generating and displaying active reports
US8356027B2 (en) * 2010-10-07 2013-01-15 Sap Ag Hybrid query execution plan generation and cost model evaluation
EP2633398B1 (en) * 2010-10-25 2020-05-27 Ab Initio Technology LLC Managing data set objects in a dataflow graph that represents a computer program
US8195643B2 (en) 2010-10-28 2012-06-05 Sap Ag Database calculation engine
US9116955B2 (en) * 2011-05-02 2015-08-25 Ab Initio Technology Llc Managing data queries
US8838579B2 (en) 2012-04-26 2014-09-16 Sap Ag Data flow graph optimization using adaptive rule chaining
US8856766B2 (en) * 2012-05-11 2014-10-07 International Business Machines Corporation Generating layouts for graphs of data flow applications
CN105683940A (en) 2013-06-24 2016-06-15 惠普发展公司,有限责任合伙企业 Processing a data flow graph of a hybrid flow
CN103699515B (en) * 2013-12-27 2017-01-18 中国科学院计算技术研究所 FFT (fast Fourier transform) parallel processing device and FFT parallel processing method
CN107111505B (en) * 2015-01-19 2020-07-14 华为技术有限公司 System and method for executing algorithms on parallel heterogeneous systems
EP3106982B1 (en) * 2015-06-18 2021-03-10 ARM Limited Determination of branch convergence in a sequence of program instructions
US10657134B2 (en) 2015-08-05 2020-05-19 Ab Initio Technology Llc Selecting queries for execution on a stream of real-time data
US9798527B1 (en) 2017-01-06 2017-10-24 Google Inc. Loop and library fusion
EP4198731A1 (en) * 2017-03-29 2023-06-21 Ab Initio Technology LLC Systems and methods for performing data processing operations using variable level parallelism
US11188434B2 (en) 2017-12-08 2021-11-30 Ab Initio Technology Llc Systems and methods for monitoring execution of structured query language (SQL) queries

Also Published As

Publication number Publication date
US20180285401A1 (en) 2018-10-04
EP3602297B1 (en) 2023-03-22
ZA201906585B (en) 2024-02-28
EP4198731A1 (en) 2023-06-21
EP3602297A1 (en) 2020-02-05
CA3058223A1 (en) 2018-10-04
KR102549994B1 (en) 2023-06-29
AU2018243278A1 (en) 2019-10-17
AU2023201414A1 (en) 2023-04-06
WO2018183676A1 (en) 2018-10-04
US10817495B2 (en) 2020-10-27
DE112018001789T5 (en) 2019-12-19
US20210182263A1 (en) 2021-06-17
AU2018243278B2 (en) 2022-12-15
JP2020512643A (en) 2020-04-23
CN110612513A (en) 2019-12-24
CN110612513B (en) 2024-01-30
JP7216654B2 (en) 2023-02-01
KR20190131557A (en) 2019-11-26

Similar Documents

Publication Publication Date Title
SG11201908969WA (en) Systems and methods for performing data processing operations using variable level parallelism
SG11201807387YA (en) System and method for beam management
SG11201808968WA (en) Time division multiplexing of synchronization channels
SG11201901834WA (en) Micrornas as biomarkers for endometriosis
SG11201910212WA (en) Integrated system for rule editing, simulation, version control, and business process management
SG11201807307VA (en) System and method for aerial system discrimination and action
SG11201900116RA (en) Communication flow for verification and identification check
SG11201808494TA (en) Signal light detection
SG11201903141QA (en) Business processing method and apparatus
SG11201908890XA (en) System and method for implementing different types of blockchain contracts
SG11201908336XA (en) Smart plans
SG11201903527QA (en) Platform for atomic transfer of smart assets within blockchain networks
SG11201903584YA (en) Traversing smart contract database through logic map
SG11201903425PA (en) System and method for information protection
SG11201906835VA (en) Event-driven blockchain workflow processing
SG11201805906WA (en) Diagnostic and prognostic methods for cardiovascular diseases and events
SG11201900146VA (en) Tool health monitoring and matching
SG11201804482UA (en) Search and retrieval data processing system for computing near real-time data aggregations
SG11201809097WA (en) Reconfigurable distributed processing
SG11201807164XA (en) Circuit arrangement, method of forming and operating the same
SG11201903488UA (en) System and method for obstacle detection
SG11201811425TA (en) Techniques for in-memory key range searches
SG11201907155UA (en) Smart contract whitelists
SG11201803928UA (en) Processing data using dynamic partitioning
SG11201903139SA (en) Methods for expression profile classification