# US 2018/0025113 A1 · Event detail processing at run-time

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2018/0025113 A1
- Document ID: US20180025113A1
- Status: Published application
- Kind: A1
- Application number: 15/218,468
- Filed: 2016-07-25
- Published: 2018-01-25
- Earliest claimed: 2016-07-25
- Assignees: salesforce.com, inc.
- Applicants: salesforce.com, Inc.
- Inventors: Adam Torman; Abhishek Bangalore Sreenivasa; Aakash Pradeep; Ivan Daya Weiss; Soumen Bandyopadhyay; Alex Warshavsky; Samarpan Jain
- Web page: https://patentgrep.com/patent/US20180025113A1

## CPC

- G16H 10/60: for patient-specific data, e.g. for electronic patient records
- G06F 16/211: {Schema design and management}
- G06F 16/2471: {Distributed queries}
- G16H: HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim 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.

### Claim 2 (depends on 1)

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

### Claim 3 (depends on 1)

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.

### Claim 4 (depends on 1)

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.

### Claim 5 (depends on 4)

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.

### Claim 6 (depends on 4)

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.

### Claim 7 (depends on 1)

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.

### Claim 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.

### Claim 9 (depends on 8)

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

### Claim 10 (depends on 8)

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

### Claim 11 (depends on 8)

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.

### Claim 12 (depends on 11)

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.

### Claim 13 (depends on 11)

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.

### Claim 14 (depends on 8)

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.

### Claim 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.

### Claim 16 (depends on 15)

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

### Claim 17 (depends on 15)

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.

### Claim 18 (depends on 15)

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.

### Claim 19 (depends on 18)

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.

### Claim 20 (depends on 15)

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.
