AU2019239150B2 - Partitioning data in a clustered database environment - Google Patents

Partitioning data in a clustered database environment Download PDF

Info

Publication number
AU2019239150B2
AU2019239150B2 AU2019239150A AU2019239150A AU2019239150B2 AU 2019239150 B2 AU2019239150 B2 AU 2019239150B2 AU 2019239150 A AU2019239150 A AU 2019239150A AU 2019239150 A AU2019239150 A AU 2019239150A AU 2019239150 B2 AU2019239150 B2 AU 2019239150B2
Authority
AU
Australia
Prior art keywords
data
application server
database
data source
server
Prior art date
Legal status (The legal status 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 status listed.)
Active
Application number
AU2019239150A
Other languages
English (en)
Other versions
AU2019239150A1 (en
Inventor
Siva Suthram
Sachin Vijan
Chet Chan Wong
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Landis and Gyr Technology Inc
Original Assignee
Landis & Gyr Technology Inc
Landis and Gyr Technology Inc
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 Landis & Gyr Technology Inc, Landis and Gyr Technology Inc filed Critical Landis & Gyr Technology Inc
Publication of AU2019239150A1 publication Critical patent/AU2019239150A1/en
Assigned to LANDIS+GYR TECHNOLOGY, INC. reassignment LANDIS+GYR TECHNOLOGY, INC. Amend patent request/document other than specification (104) Assignors: LANDIS+GYR INNOVATIONS, INC.
Application granted granted Critical
Publication of AU2019239150B2 publication Critical patent/AU2019239150B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/278—Data partitioning, e.g. horizontal or vertical partitioning
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/10—Protocols in which an application is distributed across nodes in the network
    • H04L67/1001—Protocols in which an application is distributed across nodes in the network for accessing one among a plurality of replicated servers
    • H04L67/1004—Server selection for load balancing
    • H04L67/1008—Server selection for load balancing based on parameters of servers, e.g. available memory or workload
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2365—Ensuring data consistency and integrity
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G06F16/288—Entity relationship models
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/10—Protocols in which an application is distributed across nodes in the network
    • H04L67/1001—Protocols in which an application is distributed across nodes in the network for accessing one among a plurality of replicated servers

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Computer Hardware Design (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
AU2019239150A 2018-03-19 2019-03-12 Partitioning data in a clustered database environment Active AU2019239150B2 (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US15/925,257 US10860614B2 (en) 2018-03-19 2018-03-19 Partitioning data in a clustered database environment
US15/925,257 2018-03-19
PCT/US2019/021726 WO2019182801A1 (en) 2018-03-19 2019-03-12 Partitioning data in a clustered database environment

Publications (2)

Publication Number Publication Date
AU2019239150A1 AU2019239150A1 (en) 2020-09-24
AU2019239150B2 true AU2019239150B2 (en) 2024-03-28

Family

ID=65904597

Family Applications (1)

Application Number Title Priority Date Filing Date
AU2019239150A Active AU2019239150B2 (en) 2018-03-19 2019-03-12 Partitioning data in a clustered database environment

Country Status (6)

Country Link
US (2) US10860614B2 (https=)
JP (2) JP7102542B2 (https=)
CN (1) CN112106039B (https=)
AU (1) AU2019239150B2 (https=)
NZ (1) NZ767521A (https=)
WO (1) WO2019182801A1 (https=)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11520744B1 (en) * 2019-08-21 2022-12-06 EMC IP Holding Company LLC Utilizing data source identifiers to obtain deduplication efficiency within a clustered storage environment
US11868219B2 (en) * 2022-05-04 2024-01-09 Red Hat, Inc. Data preservation for node evacuation in unstable nodes within a mesh

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170006135A1 (en) * 2015-01-23 2017-01-05 C3, Inc. Systems, methods, and devices for an enterprise internet-of-things application development platform

Family Cites Families (21)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1639751A (zh) 2002-07-16 2005-07-13 Gs管理系统有限公司 地区热监控系统和方法
US8046694B1 (en) * 2007-08-06 2011-10-25 Gogrid, LLC Multi-server control panel
US8458210B2 (en) 2011-05-06 2013-06-04 Verizon Patent And Licensing Inc. Database load balancing through dynamic database routing
US8959222B2 (en) * 2011-05-19 2015-02-17 International Business Machines Corporation Load balancing system for workload groups
US8769105B2 (en) 2012-09-14 2014-07-01 Peaxy, Inc. Software-defined network attachable storage system and method
JP2016519824A (ja) 2013-04-09 2016-07-07 サイトリックス システムズ，インコーポレイテッド クラウド同期型データの使用によるネイティブデスクトップの提供
US20150120224A1 (en) * 2013-10-29 2015-04-30 C3 Energy, Inc. Systems and methods for processing data relating to energy usage
JP6197692B2 (ja) * 2014-02-26 2017-09-20 富士通株式会社 サーバ
US10346897B2 (en) * 2014-05-30 2019-07-09 Walmart Apollo, Llc Method and system for smart order management and application level sharding
US9792315B2 (en) * 2014-08-21 2017-10-17 Dropbox, Inc. Multi-user search system with methodology for bypassing instant indexing
JP6272190B2 (ja) * 2014-09-02 2018-01-31 株式会社日立製作所 計算機システム、計算機、負荷分散方法及びそのプログラム
US10455019B2 (en) * 2014-09-10 2019-10-22 Oracle International Corporation Highly performant reliable message storage using in-memory replication technology
US10579272B2 (en) 2015-04-07 2020-03-03 Telefonaktiebolaget Lm Ericsson (Publ) Workload aware storage platform
US20170046510A1 (en) * 2015-08-14 2017-02-16 Qualcomm Incorporated Methods and Systems of Building Classifier Models in Computing Devices
CN105260136B (zh) * 2015-09-24 2019-04-05 北京百度网讯科技有限公司 数据读写方法及分布式存储系统
CN105447151A (zh) * 2015-11-27 2016-03-30 深圳市金蝶友商电子商务服务有限公司 访问分布式数据库的方法、数据源代理装置及应用服务器
CN107133243A (zh) * 2016-02-29 2017-09-05 华为技术有限公司 一种数据处理方法和服务器
US10530852B2 (en) 2016-05-19 2020-01-07 Level 3 Communications, Llc Network mapping in content delivery network
TWI616906B (zh) 2017-03-01 2018-03-01 Yujing Technology Co Ltd Resonant transformer with leakage inductance adjustment
US11055264B2 (en) * 2017-05-10 2021-07-06 Dropbox, Inc. Automatically coordinating application schema changes in a distributed data storage system
US11044336B2 (en) * 2018-01-29 2021-06-22 Salesforce.Com, Inc. Systems, methods, and apparatuses for capturing data change events in a cloud based computing environment

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20170006135A1 (en) * 2015-01-23 2017-01-05 C3, Inc. Systems, methods, and devices for an enterprise internet-of-things application development platform

Also Published As

Publication number Publication date
JP7220321B2 (ja) 2023-02-09
JP7102542B2 (ja) 2022-07-19
CN112106039A (zh) 2020-12-18
CN112106039B (zh) 2024-08-23
US20190286738A1 (en) 2019-09-19
WO2019182801A1 (en) 2019-09-26
US11416517B2 (en) 2022-08-16
JP2022153422A (ja) 2022-10-12
NZ767521A (en) 2026-03-27
US20210042328A1 (en) 2021-02-11
US10860614B2 (en) 2020-12-08
AU2019239150A1 (en) 2020-09-24
JP2021518604A (ja) 2021-08-02

Similar Documents

Publication Publication Date Title
US9996552B2 (en) Method for generating a dataset structure for location-based services and method and system for providing location-based services to a mobile device
US9152669B2 (en) System and method for distributed SQL join processing in shared-nothing relational database clusters using stationary tables
JP5466257B2 (ja) 表検索方法
CN109196807B (zh) 网络节点以及操作网络节点以进行资源分发的方法
JP7220321B2 (ja) クラスタ化されたデータベース環境でのデータのパーティショニング
US11064022B2 (en) Messaging system failover
US9749219B2 (en) Method of optimizing routing in a cluster comprising static communication links and computer program implementing that method
JP5782937B2 (ja) タグ管理装置、タグ管理システムおよびタグ管理プログラム
CN103136322A (zh) 用于配置查询的装置和方法
US20180189366A1 (en) Data processing method, device and system of query server
CN110837411B (zh) 一种数据服务器端分区内部并发i/o调度方法及系统
US9894012B2 (en) Method and system to improve network connection locality on multicore systems
US20190260645A1 (en) Method for establishing communication routes between nodes of a computer cluster, corresponding computer program and computer cluster
HK40037049A (en) Partitioning data in a clustered database environment
CN117453380B (zh) 集群的容器组调度方法、系统以及计算机设备
HK40037049B (zh) 在集群数据库环境中划分数据
CN113824606B (zh) 一种网络测量方法及装置
JP6155861B2 (ja) データ管理方法、データ管理プログラム、データ管理システム及びデータ管理装置
US20160275191A1 (en) Database system
US20170262316A1 (en) Allocation of resources
Hofmann¹ et al. Exploiting 3D Memory for Accelerated
JPWO2019182801A5 (https=)
EP3893122A1 (en) Network processor and message processing method
CN117931796A (zh) 用于分布式存储的数据处理方法、装置、设备及介质

Legal Events

Date Code Title Description
HB Alteration of name in register

Owner name: LANDIS+GYR TECHNOLOGY, INC.

Free format text: FORMER NAME(S): LANDIS+GYR INNOVATIONS, INC.

FGA Letters patent sealed or granted (standard patent)