EVENT DETAIL PROCESSING AT RUN-TIME

• US 20180025113A1
• Filed: 07/25/2016
• Published: 01/25/2018
• Est. Priority Date: 07/25/2016
• Status: Abandoned Application

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Torman, Adam, Sreenivasa, Abhishek Bangalore, Pradeep, Aakash, Weiss, Ivan Daya, Bandyopadhyay, Soumen, Warshavsky, Alex, Jain, Samarpan
• Application Number:
  US15/218,468
• Publication Number:
  US 20180025113A1
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G16H 10/60 for patient-specific data, e.g. for electronic patient records

Abstract

Disclosed are some examples of database systems, methods, and computer program products for run-time schema for event records. In some implementations, event records satisfying a query can be identified. Attribute-value pairs of data of those identified event records can be stored in an unstructured data field of an event record.

Claims

1. A database system comprising:

at least one event database storing data objects corresponding to event records;

at least one server capable of executing instructions configurable to cause;

providing a structured data field for event records stored in the event database of the database system;

processing a query;

identifying one or more records stored in one or more databases of the database system as satisfying the query, the one or more databases being different from the event database;

determining attribute-value pairs of data corresponding to data fields and values of the data fields of the identified one or more records stored in the one or more databases; and

storing the determined attribute-value pairs of data in the unstructured data field of one or more of the event records stored in the event database.

2. The database system of claim 1, wherein the unstructured data field is in a JavaScript Object Notation (JSON) format.

3. The database system of claim 1, wherein the one or more records stored in the one or more databases are health-related records of patients.

4. The database system of claim 1, wherein the attribute-value pairs of data stored in the unstructured data field includes a first attribute-value pair having a first data type and a second attribute-value pair having a second data type, the first data type and the second data type being different.

5. The database system of claim 4, wherein the one or more of the event records stored in the event database include a strongly-typed data field, and wherein the database system stores the query used to identify the records in the strong-typed data field.

6. The database system of claim 4, wherein the one or more of the event records stored in the event database include a strongly-typed data field having the first data type.

7. The database system of claim 1, wherein a first event record of the one or more of the event records stored in the event database has a first grouping of attribute-value pairs in the corresponding unstructured data field, a second event record of the one or more of the event records stored in the event database has a second grouping of attribute-value pairs in the corresponding unstructured data field, the first grouping being different than the second grouping.

8. A method for storing unstructured data using a database system, the method comprising:

providing, using a database system, an unstructured data field for event records stored in a event database of the database system;

processing, using the database system, a query;

identifying, using the database system, one or more records stored in one or more databases of the database system as satisfying the query, the one or more databases being different from the event database;

determining, using the database system, attribute-value pairs of data corresponding to data fields and values of the data fields of the identified one or more records stored in the one or more databases; and

storing the determined attribute-value pairs of data in the unstructured data field of one or more of the event records stored in the event database.

9. The method of claim 8, wherein the unstructured data field is in a JavaScript Object Notation (JSON) format.

10. The method of claim 8, wherein the one or more records stored in the one or more databases are health-related records of patients.

11. The method of claim 8, wherein the attribute-value pairs of data stored in the unstructured data field includes a first attribute-value pair having a first data type and a second attribute-value pair having a second data type, the first data type and the second data type being different.

12. The method of claim 11, wherein the one or more of the event records stored in the event database include a strongly-typed data field, and wherein the database system stores the query used to identify the records in the strong-typed data field.

13. The method of claim 11, wherein the one or more of the event records stored in the event database include a strongly-typed data field having the first data type.

14. The method of claim 8, wherein a first event record of the one or more of the event records stored in the event database has a first grouping of attribute-value pairs in the corresponding unstructured data field, a second event record of the one or more of the event records stored in the event database has a second grouping of attribute-value pairs in the corresponding unstructured data field, the first grouping being different than the second grouping.

15. A computer program product comprising program code to be executed by at least one processor when retrieved from a non-transitory computer-readable medium, the program code comprising instructions configurable to cause:

providing an unstructured data field for event records stored in a event database of a database system;

processing a query;

identifying one or more records stored in one or more databases of the database system as satisfying the query, the one or more databases being different from the event database;

determining attribute-value pairs of data corresponding to data fields and values of the data fields of the identified one or more records stored in the one or more databases; and

storing the determined attribute-value pairs of data in the unstructured data field of one or more of the event records stored in the event database.

16. The computer program product of claim 15, wherein the unstructured data field is in a JavaScript Object Notation (JSON) format.

17. The computer program product of claim 15, wherein the one or more records stored in the one or more databases are health-related records of patients.

18. The computer program product of claim 15, wherein the attribute-value pairs of data stored in the unstructured data field includes a first attribute-value pair having a first data type and a second attribute-value pair having a second data type, the first data type and the second data type being different.

19. The computer program product of claim 18, wherein the one or more of the event records stored in the event database include a strongly-typed data field, and wherein the database system stores the query used to identify the records in the strong-typed data field.

20. The computer program product of claim 15, wherein the one or more of the event records stored in the event database include a strongly-typed data field having the first data type.