System and method for performing concurrent database operations on a database record

• US 10,109,015 B2
• Filed: 10/27/2015
• Issued: 10/23/2018
• Est. Priority Date: 10/27/2014
• Status: Active Grant

• Current Assignee: William Sale
• Original Assignee: William Sale
• Inventors: Sale, William
• Primary Examiner(s): Hamilton, Lalita M
• Application Number:
  US14/923,663
• Publication Number:
  US 20160117779A1
• Time in Patent Office: 1,092 Days
• Field of Search: 705 4, 705 35, 705 38
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06Q 40/08 Insurance
• CPC Class Codes: G06Q 50/163 Real estate management

Abstract

A method and system for handling data field tasks, the system comprising a database containing records and data fields associated with real estate ownership expense insurance policies that reimburses for increases in property ownership expenses including increases in maintenance fees and assessments from non-covered losses, an underwriting server communicatively coupled to one or more client devices and data sources over a communications network, the underwriting server comprising a processor that configures processes to the data sources and generates data source connections to receive information from the data sources, and a scheduler that allocates threads within the processes to at least one of the data fields associated with premium for coverage, expenses, and reimbursement of the real estate ownership expense insurance policies, and assigns the threads to tasks for performing operations on the at least one of the data fields based on the information from the data sources.

Claims

1. A system for handling data field tasks, the system comprising:

a database containing records and data fields associated with real estate ownership expense insurance policies that reimburse for increases in property ownership expenses including increases in maintenance fees and assessments from non-covered losses;

an underwriting server communicatively coupled to one or more client devices and data sources over a communications network, the underwriting server comprising;

a processor that;

configures processes to the data sources,

generates data source connections to receive information from the data sources, the data sources including one or more social media servers, and

aggregates social media content that is associated with the real estate ownership expense insurance policies from the one or more social media servers,

analyzes the social media content to determine trends, risk, and behaviors; and

a scheduler in an operating system of the underwriting server that;

allocates threads within the processes to at least one of the data fields in a memory location associated with premium for coverage, expenses, and reimbursement of the real estate ownership expense insurance policies,

schedules the threads to retrieve the information from the data sources; and

assigns the threads to tasks for performing operations on the at least one of the data fields based on the information from the data sources, wherein at least one of the threads performs an operation on the at least one of the data fields using the analysis of the social media content.

2. The system of claim 1 wherein the tasks include database operations.

3. The system of claim 2 wherein the database operations include create, read, update and delete operations.

4. The system of claim 2 wherein the scheduler queues a plurality of the database operations for execution on the at least one of the data fields on a given record.

5. The system of claim 1 wherein the scheduler assigns the threads to tasks for performing operations on two or more data fields of a given record concurrently.

6. The system of claim 1 wherein the processor receives real estate ownership expense insurance policy application information from the one or more client devices and stores the real estate ownership expense insurance policy application information in the database.

7. The system of claim 6 wherein the real estate ownership expense insurance policy application information includes at least one of a duration of coverage, desired deductible, property location, duration of unit ownership, address, property age, property construction class, property amenities, value of property, unit maintenance pricing history, property tax rates and assessed values, property occupancy or vacancy, and whether the property is a primary home, vacation, seasonal residence, or unoccupied.

8. The system of claim 6 wherein the processor analyzes the real estate ownership expense insurance policy application information to generate quotes.

9. The system of claim 8 wherein the processor provides the quotes as alerts identifying non-coverage of assessment risk based on property cost-increase risk events based on the information from the data sources.

10. The system of claim 1 wherein the increases in property ownership expenses include assessments from deferred maintenance, wear and tear, capital expenses, water intrusion, settling, and earth movement.

11. The system of claim 1 wherein the information from the data sources include at least one of duration of unit ownership, property location, susceptibility to storm damage, insurance costs, repair costs, neighborhood and building demographics, average household income within the unit'"'"'s building and neighborhood, property age, property construction class, property amenities, number of units within the building, number of floors, unit pricing history, unit maintenance pricing history, risk exposure, property tax rates and assessed values, property occupancy or vacancy, decision-making authority of applicant in property administration entity, profiles of condo association members, applicant credit score, and claims history.

12. The system of claim 1 wherein the processor calculates reimbursement for assessment=a*x−

(m_c*r), where

a=assessment;

x=assessment term;

m_c=total maintenance obligation in the coverage period; and

r=retained liability.

13. The system of claim 1 wherein the processor calculates reimbursement for annual increase in maintenance=(i−

r_r)*m_c, where

i=increase in maintenance obligation in reimbursement year;

r_r=remaining retained liability; and

m_c=total maintenance obligation in the coverage period.

14. A system for handling data field tasks, the system comprising:

a processor; and

a memory having executable instructions stored thereon that when executed by the processor cause the processor to;

configure processes to data sources over a communications network;

generate data source connections to receive information from the data sources, the data sources including one or more social media servers;

aggregate social media content that is associated with real estate ownership expense insurance policies from the one or more social media servers, wherein the real estate ownership expense insurance policies reimburse for increases in property ownership expenses including increases in maintenance fees and assessments from non-covered losses;

analyze the social media content to determine trends, risk, and behaviors;

allocates threads within the processes to at least one data field in a memory location associated with premium for coverage, expenses, and reimbursement of the real estate ownership expense insurance policies;

schedule the threads to retrieve the information from the data sources; and

assign the threads to tasks for performing operations on the at least one data field based on the information from the data sources, wherein at least one of the threads performs an operation on the at least one of the data field using the analysis of the social media content.

15. The system of claim 14 wherein the processor provides alerts identifying non-coverage of assessment risk based on property cost-increase risk events based on the information from the data sources.

16. The system of claim 14 wherein the increases in property ownership expenses include assessments from deferred maintenance, wear and tear, capital expenses, water intrusion, settling, and earth movement.

17. The system of claim 14 wherein the information from the data sources include at least one of duration of unit ownership, property location, susceptibility to storm damage, insurance costs, repair costs, neighborhood and building demographics, average household income within the unit'"'"'s building and neighborhood, property age, property construction class, property amenities, number of units within the building, number of floors, unit pricing history, unit maintenance pricing history, risk exposure, property tax rates and assessed values, property occupancy or vacancy, decision-making authority of applicant in property administration entity, profiles of condo association members, applicant credit score, and claims history.

18. Non-transitory computer-readable media comprising program code that when executed by a programmable processor causes execution of a method for handling data field tasks, the computer-readable media comprising:

computer program code for configuring processes to data sources over a communications network;

computer program code for generating data source connections to receive information from the data sources, the data sources including one or more social media servers;

computer program code for aggregating social media content that is associated with real estate ownership expense insurance policies from the one or more social media servers, wherein the real estate ownership expense insurance policies reimburse for increases in property ownership expenses including increases in maintenance fees and assessments from non-covered losses;

computer program code for analyzing the social media content to determine trends, risk, and behaviors;

computer program code for allocating threads within the processes to at least one of the data fields in a memory location associated with premium for coverage, expenses, and reimbursement of the real estate ownership expense insurance policies;

computer program code for scheduling the threads to retrieve the information from the data sources; and

computer program code for assigning the threads to tasks for performing operations on the at least one of the data fields based on the information from the data sources, wherein at least one of the threads performs an operation on the at least one of the data fields using the analysis of the social media content.

19. The non-transitory computer-readable media of claim 18 further comprising computer program code for providing alerts identifying non-coverage of assessment risk based on property cost-increase risk events based on the information from the data sources.

20. The non-transitory computer-readable media of claim 18 wherein the information from the data sources include at least one of duration of unit ownership, property location, susceptibility to storm damage, insurance costs, repair costs, neighborhood and building demographics, average household income within the unit'"'"'s building and neighborhood, property age, property construction class, property amenities, number of units within the building, number of floors, unit pricing history, unit maintenance pricing history, risk exposure, property tax rates and assessed values, property occupancy or vacancy, decision-making authority of applicant in property administration entity, profiles of condo association members, applicant credit score, and claims history.