CN112106039B - 在集群数据库环境中划分数据 - Google Patents

在集群数据库环境中划分数据 Download PDF

Info

Publication number
CN112106039B
CN112106039B CN201980033441.2A CN201980033441A CN112106039B CN 112106039 B CN112106039 B CN 112106039B CN 201980033441 A CN201980033441 A CN 201980033441A CN 112106039 B CN112106039 B CN 112106039B
Authority
CN
China
Prior art keywords
data
database
application server
server
data source
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
CN201980033441.2A
Other languages
English (en)
Chinese (zh)
Other versions
CN112106039A (zh
Inventor
C·C·黄
S·萨斯拉姆
S·伟简
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+gail Technology Co ltd
Original Assignee
Landis+gail Technology Co ltd
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+gail Technology Co ltd filed Critical Landis+gail Technology Co ltd
Publication of CN112106039A publication Critical patent/CN112106039A/zh
Application granted granted Critical
Publication of CN112106039B publication Critical patent/CN112106039B/zh
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)
CN201980033441.2A 2018-03-19 2019-03-12 在集群数据库环境中划分数据 Active CN112106039B (zh)

Applications Claiming Priority (3)

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

Publications (2)

Publication Number Publication Date
CN112106039A CN112106039A (zh) 2020-12-18
CN112106039B true CN112106039B (zh) 2024-08-23

Family

ID=65904597

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201980033441.2A Active CN112106039B (zh) 2018-03-19 2019-03-12 在集群数据库环境中划分数据

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
US20120284296A1 (en) * 2011-05-06 2012-11-08 Verizon Patent And Licensing Inc. Database load balancing through dynamic database routing

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
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
WO2016118979A2 (en) * 2015-01-23 2016-07-28 C3, Inc. Systems, methods, and devices for an enterprise internet-of-things application development platform
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
US20120284296A1 (en) * 2011-05-06 2012-11-08 Verizon Patent And Licensing Inc. Database load balancing through dynamic database routing

Also Published As

Publication number Publication date
JP7220321B2 (ja) 2023-02-09
JP7102542B2 (ja) 2022-07-19
CN112106039A (zh) 2020-12-18
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
AU2019239150B2 (en) 2024-03-28
US10860614B2 (en) 2020-12-08
AU2019239150A1 (en) 2020-09-24
JP2021518604A (ja) 2021-08-02

Similar Documents

Publication Publication Date Title
US8762534B1 (en) Server load balancing using a fair weighted hashing technique
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
CN103227754B (zh) 一种高可用集群系统负载动态均衡方法及节点设备
CN109196807B (zh) 网络节点以及操作网络节点以进行资源分发的方法
JP2018190450A (ja) 基数推定を介した結合パスの効率的な判定
JP2010140134A (ja) 仮想マシン管理方法、プログラムおよび管理サーバ
US9749219B2 (en) Method of optimizing routing in a cluster comprising static communication links and computer program implementing that method
JP7220321B2 (ja) クラスタ化されたデータベース環境でのデータのパーティショニング
US20130070647A1 (en) Method of pseudo-dynamic routing in a cluster comprising static communication links and computer program implementing that method
CN103414756B (zh) 一种任务分发方法、分发节点及系统
CN117453380B (zh) 集群的容器组调度方法、系统以及计算机设备
HK40037049A (en) Partitioning data in a clustered database environment
HK40037049B (zh) 在集群数据库环境中划分数据
US20190158585A1 (en) Systems and Methods for Server Failover and Load Balancing
JP6155861B2 (ja) データ管理方法、データ管理プログラム、データ管理システム及びデータ管理装置
WO2021072574A1 (en) Load balancing
CN111506658B (zh) 数据处理方法、装置、第一设备及存储介质
CN112988739B (zh) 数据管理和处理方法、装置、计算机系统及可读存储介质
CN116302547A (zh) 负载均衡处理方法、装置、设备、介质和计算机程序产品
JPWO2019182801A5 (https=)
HK40027379B (en) Data processing method and device, first apparatus and storage medium
HK40027379A (en) Data processing method and device, first apparatus and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
REG Reference to a national code

Ref country code: HK

Ref legal event code: DE

Ref document number: 40037049

Country of ref document: HK

TA01 Transfer of patent application right
TA01 Transfer of patent application right

Effective date of registration: 20240130

Address after: Georgia, USA

Applicant after: Landis+Gail Technology Co.,Ltd.

Country or region after: U.S.A.

Address before: American Georgia

Applicant before: LANDIS+GYR INNOVATIONS, Inc.

Country or region before: U.S.A.

GR01 Patent grant
GR01 Patent grant