IP Library Granted Patent US 9,613,116
Granted Patent B2
US 9,613,116 · App. 14/081,118 · Granted Apr 4, 2017

Identifying and formatting data for data migration

Inventors: Wesley Bryan (McKinney, TX); Scott Ingulli (Tampa, FL)
Assignee: Workday, Inc.
G06F17/30569
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,613,116
App. No.
14/081,118
Granted
Apr 4, 2017
Kind
B2
Abstract

Data formatting, migration and corresponding application acceptance for cloud-based applications may include various operations. One example operation may include identifying a data object eligible for migration to a cloud application and identifying a number of field groups linked to the data object, each of the field groups may include at least one data field. The operation may further provide receiving the field groups at a data formatting application operated on a remote cloud application server. Also, a format of the field group may be converted to a format associated with a simple data set of the cloud application for data migration purposes.

Claims (54)

1. A method, comprising:

identifying at least one data object for migration to a remote cloud application server;

identifying a plurality of field groups linked to the at least one data object, each of the plurality of field groups comprising at least one data field, wherein a field group is linked to content of the at least one data object by a pointer;

receiving, via an application programming interface, the plurality of field groups at the remote cloud application server;

identifying at least one of the received plurality of field groups for migration to the remote cloud application server;

generating a simple data set, wherein the simple data set is loadable into the remote cloud application server to migrate content of the identified at least one data object;

converting a format of the identified at least one field group to a format associated with the simple data set, the conversion including translating the linking of (i) the identified field group to the content of the at least one data object to (ii) formatting of the simple data set such that the simple data set includes a subset of data of the at least one data object, the data not included in the subset of data being derivable from the subset of data;

modifying the simple data set to include the at least one data field; and

migrating the modified simple data set to the remote cloud application server.

2. The method of claim 1 , wherein the modifying the simple data set includes modifying the simple data set to include a predefined number of data fields of the at least one field group, wherein the predefined number is at least one.

3. The method of claim 2 , wherein the identified at least one field group includes at least two data fields and the predefined number of data fields is fewer than an original number of data fields of the at least one field group.

4. The method of claim 1 , wherein the at least one field group identifies at least one data column in at least one of a database file and a spreadsheet file.

5. The method of claim 4 , wherein the at least one field group identifies a plurality of data columns from a plurality of different corresponding database files or spreadsheet files.

6. The method of claim 1 , wherein converting a format of the at least one field group to a format associated with a simple data set of the cloud application further comprises

identifying a total number of available data columns; and

reducing a number of actual data columns to a lesser number of actual data columns prior to converting the format of the at least one field group.

7. The method of claim 1 , further comprising upserting the at least one data field of the at least one field group by receiving updated data in a key field after the at least one field group has been received, wherein the key field is a designated field that receives updates automatically as new data is inserted into at least one existing data field.

8. The method of claim 1 , further comprising prior to the identifying the at least one of the plurality of field groups, receiving the plurality of field groups at a data formatting application operated on the remote cloud application server.

9. The method of claim 1 , further comprising converting the simple data set to a complex form for loading into the remote cloud application server.

10. The method of claim 1 , further comprising outputting a query for the at least one data object, wherein the query is based on the simple data set format.

11. The method of claim 1 , wherein the receiving the plurality of field groups via the application programming interface includes determining that the format of data in the received plurality of field groups is compatible with the remote cloud application server.

12. An apparatus, comprising:

a processor configured to:

identify at least one data object for migration to a remote cloud application server;

identify a plurality of field groups linked to the at least one data object, each of the plurality of field groups comprising at least one data field, wherein a field group is linked to content of the at least one data object by a pointer

receive, via an application programming interface, the plurality of field groups at the remote cloud application server;

identify at least one of the received plurality of field groups for migration to the remote cloud application server;

generate a simple data set, wherein the simple data set is loadable into the remote cloud application server to migrate content of the identified at least one data object;

convert a format of the identified at least one field group to a format associated with the simple data set, the conversion including translating the linking of (i) the identified field group to the content of the at least one data object to (ii) formatting of the simple data set such that the simple data set includes a subset of data of the at least one data object, the data not included in the subset of data being derivable from the subset of data;

modify the simple data set to include the at least one data field; and

migrate the modified simple data set to the remote cloud application server.

13. The apparatus of claim 12 , wherein the modifying the simple data set includes modifying the simple data set to include a predefined number of data fields of the at least one field group, wherein the predefined number is at least one.

14. The apparatus of claim 13 , wherein the identified at least one field group includes at least two data fields and the predefined number of data fields is fewer than an original number of data fields of the at least one field group.

15. The apparatus of claim 12 , wherein the at least one field group identifies at least one data column in at least one of a database file and a spreadsheet file.

16. The apparatus of claim 15 , wherein the at least one field group identifies a plurality of data columns from a plurality of different corresponding database files or spreadsheet files.

17. The apparatus of claim 12 , wherein when the processor converts a format of the at least one field group to a format associated with a simple data set of the cloud application, the processor also identifies a total number of available data columns, and reduces a number of actual data columns to a lesser number of actual data columns prior to the format of the at least one field group being converted.

18. The apparatus of claim 12 , wherein the processor is also configured to upsert the at least one data field of the at least one field group by receiving updated data in a key field after the at least one field group has been received, wherein the key field is a designated field that receives updates automatically as new data is inserted into at least one existing data field.

19. A non-transitory computer readable storage medium configured to store instructions that when executed cause a processor to perform:

identifying at least one data object for migration to a remote cloud application server;

identifying a plurality of field groups linked to the at least one data object, each of the plurality of field groups comprising at least one data field, wherein a field group is linked to content of the at least one data object by a pointer;

receiving, via an application programming interface, the plurality of field groups at the remote cloud application server;

identifying at least one of the received plurality of field groups for migration to the remote cloud application server;

generating a simple data set, wherein the simple data set is loadable into the remote cloud application server to migrate content of the identified at least one data object;

converting a format of the identified at least one field group to a format associated with the simple data set, the conversion including translating the linking of (i) the identified field group to the content of the at least one data object to (ii) formatting of the simple data set such that the simple data set includes a subset of data of the at least one data object, the data not included in the subset of data being derivable from the subset of data;

modifying the simple data set to include the at least one data field; and

migrating the modified simple data set to the remote cloud application server.

20. The non-transitory computer readable storage medium of claim 19 , wherein the modifying the simple data set includes modifying the simple data set to include a predefined number of data fields of the at least one field group, wherein the predefined number is at least one.

21. The non-transitory computer readable storage medium of claim 20 , wherein the identified at least one field group includes at least two data fields and the predefined number of data fields is fewer than an original number of data fields of the at least one field group.

22. The non-transitory computer readable storage medium of claim 19 , wherein the at least one field group identifies at least one data column in at least one of a database file and a spreadsheet file.

23. The non-transitory computer readable storage medium of claim 22 , wherein the at least one field group identifies a plurality of data columns from a plurality of different corresponding database files or spreadsheet files.

24. The non-transitory computer readable storage medium of claim 19 , wherein converting a format of the at least one field group to a format associated with a simple data set of the cloud application further comprises:

identifying a total number of available data columns;

reducing a number of actual data columns to a lesser number of actual data columns prior to converting the format of the at least one field group; and wherein the processor is further configured to perform;

upserting the at least one data field of the at least one field group by receiving updated data in a key field of a data formatting application after the at least one field group has been received, wherein the key field is a designated field in the data formatting application that receives updates automatically as new data is inserted into at least one existing data field.

Assignments (4)
TERMINATION AND RELEASE OF INTELLECTUAL PROPERTY SECURITY AGREEMENT Recorded Jan 24, 2024
From: FIRST-CITIZENS BANK & TRUST COMPANY (FORMERLY SILICON VALLEY BANK)
To: ONE SOURCE VIRTUAL, INC. (F/K/A ONE SOURCE VIRTUAL HR, INC.); ONE SOURCE CANADA HOLDINGS LLC
Reel/Frame 066368/0613 →
SECURITY INTEREST Recorded Jun 26, 2018
From: ONE SOURCE VIRTUAL HR, INC.; ONE SOURCE CANADA HOLDINGS LLC
To: SILICON VALLEY BANK
Reel/Frame 046203/0512 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 28, 2014
From: ONE SOURCE VIRTUAL HR, INC.
To: WORKDAY, INC.
Reel/Frame 034055/0209 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 15, 2013
From: BRYAN, WESLEY; INGULLI, SCOTT
To: ONE SOURCE VIRTUAL HR, INC.
Reel/Frame 031610/0663 →
Continuity (1)
Related Publication 20150142858A1 · May 21, 2015