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

Definitions

• FIG. 3 A shows an example system and method of storing and retrieving data using a virtualization layer according to an implementation of the disclosed subject matter.
• applications can be run on servers for production systems, and test systems may be separate from the production systems.
• the test systems may be used to test new features and/or versions of the applications.
• the production system applications may be run on a on a company's or an organization's servers (i.e., running an application "on premises"), or by running an application in a cloud-based computing environment (e.g., where the servers are remote from the company's or organization's servers).
• An extent reference may be used as a logical reference to a physical extent that is stored in physical storage (e.g., a storage device), and may be used to virtualize access to the physical storage.
• an authorized user of the database system that is associated with the source tenant may request that a new extent reference may be added for each extent that contains keys for the source tenant, with instructions to translate the tenant IDs in a key range from the source (i.e., an original tenant) to the target (i.e., a new sandbox tenant).
• the translation can map certain read operations issued by requests generated from users associated with the new sandbox tenant onto original tenant data as of a point in time.
• a method for an authorized user of a database system that is associated with an original tenant to create a sandbox for the original tenant at a point in time, the original tenant having original tenant data stored in an immutable storage associated with an original tenant identifier, the original tenant data as of the sandbox creation point in time being a virtual snapshot of the original tenant data accessible by a sandbox tenant, where the sandbox tenant data may be changed without changing the original tenant data, and the original tenant data may be changed without changing the sandbox tenant data.
• the method may include creating a sandbox tenant identifier.
• the original tenant may access original tenant data created both before and after the sandbox creation point in time that is stored in the immutable storage.
• the subsequent immutable original tenant data is written as new original tenant data that does not alter older original tenant data (e.g., the original and the sandbox tenant data) stored in the immutable storage and the original tenant cannot access the data that is created or augmented by the sandbox tenant.
• the method 20 may be used in connection with the method 10 described above and shown in FIG. 1.
• the database system may receive a query including a key indicating the sandbox tenant.
• the database system may be a server, cloud server, and/or database, or the like.
• the database system that receives a query may be system 100 shown in FIGS. 3A-3B, server 502 and/or server 504 shown in FIG. 4A, central component 700 and/or a second computer 800 shown in FIG. 5, and/or database systems 1200a-1200d shown in FIG. 6.
• the query may be generated, by for example, computer 600 shown in FIG. 5.
• the database system may perform an operation on the translated data at operation 28, and may store data resulting from the performed operation in the immutable storage that is associated with the key of the sandbox tenant at operation 30.
• the database system may, in some implementations, store the data in the immutable storage using a LSM tree data structure.
• Operations on the data associated with the sandbox may include, for example, the manipulation of the data based on one or more functions of the application being tested. That is, the data may be manipulated based on the version of the application being tested and/or a new function that has been added to the application to be tested. However, modifications to that data being tested are not accessible to users associated only with the original tenant.
• the extent 511 associated with the server 502 may have a key range of key ([first key], [last key]) of key (10, 98), and the extent 512 associated with the second server 504 may have a key range of key (33, 66).
• the one or more servers of the systems shown in FIGS. 5-6 may operate on data so as to retrieve data from the immutable storage based on the mapped key.
• the servers may translate the data from the immutable storage indicated by the key of the original tenant to data of the key indicating the sandbox tenant and perform an operation on the translated data.
• the data resulting from the performed operation may be in the immutable storage of a device that is associated with the key of the sandbox tenant, such as the storage device associated with central component 700, second computer 800, and/or one or more of the database systems 1200a-1200d.

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)

Priority Applications (5)

Applications Claiming Priority (2)

Publications (1)

Family

ID=60473640

Family Applications (1)

Country Status (7)

Cited By (1)

Families Citing this family (24)

Citations (2)

Family Cites Families (19)

• 2016
  • 2016-11-08 US US15/345,914 patent/US10241896B2/en active Active
• 2017
  • 2017-11-07 WO PCT/US2017/060352 patent/WO2018089344A1/en not_active Ceased
  • 2017-11-07 EP EP17804736.1A patent/EP3539021B1/en active Active
  • 2017-11-07 AU AU2017356901A patent/AU2017356901B2/en active Active
  • 2017-11-07 CA CA3043001A patent/CA3043001C/en active Active
  • 2017-11-07 JP JP2019523038A patent/JP7090606B2/ja active Active
  • 2017-11-07 CN CN201780069069.1A patent/CN109952564B/zh active Active
• 2019
  • 2019-01-31 US US16/263,067 patent/US20190163613A1/en not_active Abandoned

Patent Citations (2)

Also Published As

Similar Documents

Legal Events