CA3043001C - TEST DATA FORMATION AND MANIPULATION IN A DATABASE SYSTEM - Google Patents

TEST DATA FORMATION AND MANIPULATION IN A DATABASE SYSTEM

Info

Publication number
CA3043001C
CA3043001C CA3043001A CA3043001A CA3043001C CA 3043001 C CA3043001 C CA 3043001C CA 3043001 A CA3043001 A CA 3043001A CA 3043001 A CA3043001 A CA 3043001A CA 3043001 C CA3043001 C CA 3043001C
Authority
CA
Canada
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
CA3043001A
Other languages
English (en)
French (fr)
Other versions
CA3043001A1 (en
Inventor
Jameison Bear Martin
Subho Sanjay Chatterjee
Patrick James Helland
Nathaniel Wyatt
Thomas Fanghaenel
Terry Chong
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 CA3043001A1 publication Critical patent/CA3043001A1/en
Application granted granted Critical
Publication of CA3043001C publication Critical patent/CA3043001C/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
    • 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)
CA3043001A 2016-11-08 2017-11-07 TEST DATA FORMATION AND MANIPULATION IN A DATABASE SYSTEM Active CA3043001C (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US15/345,914 US10241896B2 (en) 2016-11-08 2016-11-08 Formation and manipulation of test data in a database system
US15/345,914 2016-11-08
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
CA3043001A1 CA3043001A1 (en) 2018-05-17
CA3043001C true CA3043001C (en) 2024-10-01

Family

ID=60473640

Family Applications (1)

Application Number Title Priority Date Filing Date
CA3043001A Active CA3043001C (en) 2016-11-08 2017-11-07 TEST DATA FORMATION AND MANIPULATION IN A DATABASE SYSTEM

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
US10979521B2 (en) 2018-04-12 2021-04-13 Pearson Management Services Limited Systems and methods for stacked-microservice based content provisioning
US11151110B2 (en) * 2018-09-24 2021-10-19 Salesforce.Com, Inc. Identification of records for post-cloning tenant identifier translation
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
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 格物钛(上海)智能科技有限公司 一种基于沙箱环境的机器学习训练平台实现
US10963438B1 (en) 2020-11-17 2021-03-30 Coupang Corp. Systems and methods for database query efficiency improvement
KR102360061B1 (ko) * 2020-11-17 2022-02-09 쿠팡 주식회사 데이터베이스 쿼리 효율 향상을 위한 시스템 및 방법.
US11625386B2 (en) 2021-01-29 2023-04-11 Salesforce.Com, Inc. Fast skip list purge
US11741050B2 (en) 2021-01-29 2023-08-29 Salesforce, Inc. Cloud storage class-based variable cache availability
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
US12182004B2 (en) 2022-03-01 2024-12-31 Microsoft Technology Licensing, Llc Debugging data privacy pipelines using sample data
US11922145B2 (en) 2022-03-01 2024-03-05 Microsoft Technology Licensing, Llc Initiating data privacy pipelines using reusable templates
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

Family Cites Families (21)

* 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
US8150808B2 (en) * 2009-10-21 2012-04-03 Delphix Corp. Virtual database system
US8161077B2 (en) * 2009-10-21 2012-04-17 Delphix Corp. Datacenter workflow automation scenarios using virtual databases
US8479286B2 (en) * 2009-12-15 2013-07-02 Mcafee, Inc. Systems and methods for behavioral sandboxing
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
CN103283209B (zh) * 2011-04-18 2015-12-09 北京新媒传信科技有限公司 一种应用服务平台系统及其实现方法
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
CN106027545B (zh) * 2016-06-27 2019-02-19 西安空间无线电技术研究所 一种基于虚拟数据的鲁棒信息隐藏方法

Also Published As

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

Similar Documents

Publication Publication Date Title
CA3043001C (en) TEST DATA FORMATION AND MANIPULATION IN A DATABASE SYSTEM
US10621071B2 (en) Formation and manipulation of test data in a database system
US11797498B2 (en) Systems and methods of database tenant migration
US20200201745A1 (en) Formation and manipulation of test data in a database system
US10592353B2 (en) Systems and methods of restoring a dataset of a database for a point in time
US11714785B2 (en) Deduplicating extents across systems
CN112889054A (zh) 多租户数据库管理系统中数据库加密的系统和方法
US10083196B2 (en) Creating secure virtual databases storing masked data
US8386445B2 (en) Reorganizing database tables
US9111114B1 (en) Method of transforming database system privileges to object privileges
CA3066254A1 (en) Systems and methods of creation and deletion of tenants within a database
US20180225313A1 (en) Managing a deduplicated data index
US10732840B2 (en) Efficient space accounting mechanisms for tracking unshared pages between a snapshot volume and its parent volume

Legal Events

Date Code Title Description
EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617

EEER Examination request

Effective date: 20220617