CN109952564B - 数据库系统中测试数据的形成与操纵 - Google Patents

数据库系统中测试数据的形成与操纵 Download PDF

Info

Publication number
CN109952564B
CN109952564B CN201780069069.1A CN201780069069A CN109952564B CN 109952564 B CN109952564 B CN 109952564B CN 201780069069 A CN201780069069 A CN 201780069069A CN 109952564 B CN109952564 B CN 109952564B
Authority
CN
China
Prior art keywords
tenant
data
sandbox
original
key
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
CN201780069069.1A
Other languages
English (en)
Chinese (zh)
Other versions
CN109952564A (zh
Inventor
J·B·马丁
S·S·查特吉
P·J·赫尔兰德
N·怀亚特
T·方哈内尔
T·钟
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.)
Shuo Power Co
Original Assignee
Salesforce com 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 Salesforce com Inc filed Critical Salesforce com Inc
Publication of CN109952564A publication Critical patent/CN109952564A/zh
Application granted granted Critical
Publication of CN109952564B publication Critical patent/CN109952564B/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Prevention of errors by analysis, debugging or testing of software
    • G06F11/3698—Environments for analysis, debugging or testing of software
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Prevention of errors by analysis, debugging or testing of software
    • G06F11/3668—Testing of software
    • G06F11/3696—Methods or tools to render software testable
    • 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/21—Design, administration or maintenance of databases
    • 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/24—Querying
    • G06F16/245—Query processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computer Hardware Design (AREA)
  • Quality & Reliability (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Debugging And Monitoring (AREA)
CN201780069069.1A 2016-11-08 2017-11-07 数据库系统中测试数据的形成与操纵 Active CN109952564B (zh)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US15/345,914 2016-11-08
US15/345,914 US10241896B2 (en) 2016-11-08 2016-11-08 Formation and manipulation of test data in a database system
PCT/US2017/060352 WO2018089344A1 (en) 2016-11-08 2017-11-07 Formation and manipulation of test data in a database system

Publications (2)

Publication Number Publication Date
CN109952564A CN109952564A (zh) 2019-06-28
CN109952564B true CN109952564B (zh) 2022-06-21

Family

ID=60473640

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201780069069.1A Active CN109952564B (zh) 2016-11-08 2017-11-07 数据库系统中测试数据的形成与操纵

Country Status (7)

Country Link
US (2) US10241896B2 (enExample)
EP (1) EP3539021B1 (enExample)
JP (1) JP7090606B2 (enExample)
CN (1) CN109952564B (enExample)
AU (1) AU2017356901B2 (enExample)
CA (1) CA3043001C (enExample)
WO (1) WO2018089344A1 (enExample)

Families Citing this family (25)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10855794B2 (en) 2018-04-12 2020-12-01 Pearson Management Services Limited Systems and method for automated package-data asset generation
US10963454B2 (en) 2018-09-24 2021-03-30 Salesforce.Com, Inc. System and method for bulk removal of records in a database
US11663207B2 (en) * 2018-09-24 2023-05-30 Salesforce, Inc. Translation of tenant identifiers
US11151110B2 (en) * 2018-09-24 2021-10-19 Salesforce.Com, Inc. Identification of records for post-cloning tenant identifier translation
US11238174B2 (en) 2019-01-31 2022-02-01 Salesforce.Com, Inc. Systems and methods of database encryption in a multitenant database management system
US11409904B2 (en) * 2019-04-18 2022-08-09 Microsoft Technology Licensing, Llc User interface for building a data privacy pipeline and contractual agreement to share data
US11321294B2 (en) 2019-09-09 2022-05-03 Salesforce.Com, Inc. Database index repair
US11442960B2 (en) * 2019-12-17 2022-09-13 Verizon Patent And Licensing Inc. Edge key value store for a distributed platform
US11526465B2 (en) * 2019-12-18 2022-12-13 Salesforce.Com, Inc. Generating hash trees for database schemas
US11483150B2 (en) 2020-06-01 2022-10-25 Salesforce.Com, Inc. Private key cache in secure enclave
US11361106B2 (en) 2020-09-01 2022-06-14 Microsoft Technology Licensing, Llc Chaining, triggering, and enforcing entitlements
CN112434284B (zh) * 2020-10-29 2022-05-17 格物钛(上海)智能科技有限公司 一种基于沙箱环境的机器学习训练平台实现
KR102411806B1 (ko) * 2020-11-17 2022-06-23 쿠팡 주식회사 데이터베이스 쿼리 효율 향상을 위한 시스템 및 방법
US10963438B1 (en) 2020-11-17 2021-03-30 Coupang Corp. Systems and methods for database query efficiency improvement
US11741050B2 (en) 2021-01-29 2023-08-29 Salesforce, Inc. Cloud storage class-based variable cache availability
US11625386B2 (en) 2021-01-29 2023-04-11 Salesforce.Com, Inc. Fast skip list purge
US11216322B1 (en) * 2021-06-07 2022-01-04 Snowflake Inc. Stored procedures in a network based database system
CN114238451A (zh) * 2021-11-08 2022-03-25 普强时代(珠海横琴)信息技术有限公司 数据横向扩展分析方法及装置
US12282470B2 (en) 2022-01-31 2025-04-22 Salesforce, Inc. Skip-list checkpoint creation
US11922145B2 (en) 2022-03-01 2024-03-05 Microsoft Technology Licensing, Llc Initiating data privacy pipelines using reusable templates
US12182004B2 (en) 2022-03-01 2024-12-31 Microsoft Technology Licensing, Llc Debugging data privacy pipelines using sample data
CN114595159B (zh) * 2022-05-10 2022-09-02 太平金融科技服务（上海）有限公司 测试数据生成方法、装置、设备及存储介质
US12360759B2 (en) 2023-01-31 2025-07-15 Salesforce, Inc. Downgrading database software via a downgradability test
US12455884B2 (en) 2023-01-31 2025-10-28 Salesforce, Inc. Execution tracing for node cluster
US12450126B2 (en) 2023-02-13 2025-10-21 Pure Storage, Inc. Automated backups in a distributed storage system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103283209A (zh) * 2011-04-18 2013-09-04 北京新媒传信科技有限公司 一种应用服务平台系统及其实现方法
CN105893228A (zh) * 2009-12-15 2016-08-24 迈克菲股份有限公司 用于行为沙箱化的系统和方法
CN106027545A (zh) * 2016-06-27 2016-10-12 西安空间无线电技术研究所 一种基于虚拟数据的鲁棒信息隐藏方法

Family Cites Families (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH05224992A (ja) * 1992-02-13 1993-09-03 Hitachi Ltd プログラムテスト装置
JP3497053B2 (ja) * 1996-11-13 2004-02-16 株式会社日立製作所 オンラインデータベース管理システムにおける処理方法及びオンラインデータベース管理システム
US6038639A (en) * 1997-09-09 2000-03-14 Storage Technology Corporation Data file storage management system for snapshot copy operations
US7101172B2 (en) * 2002-08-30 2006-09-05 Emerson Electric Co. Apparatus and methods for variable furnace control
KR100439675B1 (ko) * 2002-10-24 2004-07-14 한국전자통신연구원 대용량 공유 저장장치를 위한 효율적인 스냅샷 수행방법
US20050091658A1 (en) * 2003-10-24 2005-04-28 Microsoft Corporation Operating system resource protection
US9208188B2 (en) * 2009-02-17 2015-12-08 Microsoft Technology Licensing, Llc Tenant management of a hosted multi-tenant application
US8161077B2 (en) * 2009-10-21 2012-04-17 Delphix Corp. Datacenter workflow automation scenarios using virtual databases
US8150808B2 (en) * 2009-10-21 2012-04-03 Delphix Corp. Virtual database system
US8793291B2 (en) * 2010-03-15 2014-07-29 Salesforce.Com, Inc. System, method and computer program product for deploying an update between environments of a multi-tenant on-demand database system
US8706772B2 (en) * 2010-12-30 2014-04-22 Sap Ag Strict tenant isolation in multi-tenant enabled systems
US9367431B2 (en) * 2011-07-01 2016-06-14 Salesforce.Com, Inc. Testing data silo
US9721116B2 (en) 2013-06-24 2017-08-01 Sap Se Test sandbox in production systems during productive use
US10860237B2 (en) * 2014-06-24 2020-12-08 Oracle International Corporation Storage integrated snapshot cloning for database
US20160048844A1 (en) 2014-08-15 2016-02-18 Salesforce.Com, Inc. Techniques, architectures and mechanisms for management of electronic licensure
WO2016117007A1 (ja) * 2015-01-19 2016-07-28 株式会社日立製作所 データベースシステム及びデータベース管理方法
KR102378367B1 (ko) * 2015-03-20 2022-03-24 한국전자통신연구원 분산 파일 시스템
US9904538B2 (en) * 2015-08-24 2018-02-27 International Business Machines Corporation Maintenance of multi-tenant software programs

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105893228A (zh) * 2009-12-15 2016-08-24 迈克菲股份有限公司 用于行为沙箱化的系统和方法
CN103283209A (zh) * 2011-04-18 2013-09-04 北京新媒传信科技有限公司 一种应用服务平台系统及其实现方法
CN106027545A (zh) * 2016-06-27 2016-10-12 西安空间无线电技术研究所 一种基于虚拟数据的鲁棒信息隐藏方法

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
王衡.PaaS平台上Python沙箱研究.《 中国优秀硕士论文电子期刊（信息科技辑）》.2014, *

Also Published As

Publication number Publication date
JP7090606B2 (ja) 2022-06-24
CA3043001C (en) 2024-10-01
CN109952564A (zh) 2019-06-28
US20180129585A1 (en) 2018-05-10
US10241896B2 (en) 2019-03-26
JP2020502626A (ja) 2020-01-23
EP3539021A1 (en) 2019-09-18
US20190163613A1 (en) 2019-05-30
CA3043001A1 (en) 2018-05-17
AU2017356901B2 (en) 2020-12-24
EP3539021B1 (en) 2022-06-01
WO2018089344A1 (en) 2018-05-17
AU2017356901A1 (en) 2019-05-23

Similar Documents

Publication Publication Date Title
CN109952564B (zh) 数据库系统中测试数据的形成与操纵
US10621071B2 (en) Formation and manipulation of test data in a database system
US11797498B2 (en) Systems and methods of database tenant migration
US10901861B2 (en) Systems and methods of restoring a dataset of a database for a point in time
US20200201745A1 (en) Formation and manipulation of test data in a database system
CN110799961A (zh) 在数据库中创建和删除租户的系统和方法
US10732840B2 (en) Efficient space accounting mechanisms for tracking unshared pages between a snapshot volume and its parent volume
US11556519B2 (en) Ensuring integrity of records in a not only structured query language database
WO2016117007A1 (ja) データベースシステム及びデータベース管理方法
CN119806401A (zh) 一种单机存储引擎及一种数据处理方法、装置

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
GR01 Patent grant
GR01 Patent grant
CP01 Change in the name or title of a patent holder
CP01 Change in the name or title of a patent holder

Address after: California, USA

Patentee after: Shuo Power Co.

Address before: California, USA

Patentee before: SALESFORCE.COM, Inc.