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

• US 10,438,294 B2
• Filed: 09/19/2018
• Issued: 10/08/2019
• 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:
  US16/135,099
• Publication Number:
  US 20190087907A1
• Time in Patent Office: 384 Days
• 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 expenses;

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 electronically receive information from the data sources, the data sources including one or more data servers,

aggregates electronic content that is associated with the real estate ownership expenses from the one or more data servers,

analyzes the electronic content to determine trends, risk, and behaviors, and

generates quotes for real estate ownership expense insurance policies that reimburse for increases in property ownership expenses based on the analysis of the electronic content, 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,

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 electronic content.

2. The system of claim 1 further comprising receiving application information for the real estate ownership expense insurance policies including 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.

3. The system of claim 1 wherein the processor further assesses the risk based on at least one of:

a credit report and criminal record of the property owner, tax history of the property, building and area demographics, building permits, and maintenance pricing history.

4. The system of claim 1 wherein the processor further retrieves and aggregates secondary information associated with the property including property transaction history, neighborhood demographics, census information, and geological information.

5. The system of claim 1 wherein the processor further assesses the risk based on factors including duration of unit ownership, property location, susceptibility to storm damage, insurance costs, repair costs, neighborhood and building demographics, average household income within the building and neighborhood, property age, property construction class, property amenities, number of units, number of floors, property/unit pricing history, property/unit maintenance pricing history, risk exposure, property tax rates and assessed values, property occupancy or vacancy, primary home, vacation/seasonal residence, unoccupied, position of decision-making authority in property administration entity, profiles of condo association members, co-op board, or homeowners'"'"' association, inbound vs. outbound contact or marketing, response to a solicitation vs. actively seeking protection, applicant credit score, and claims history.

6. The system of claim 1 wherein the processor:

determines expected losses and residual deductibles including expected loss from assessment, expected loss from increased maintenance obligation, expected residual deductible after assessment, and expected residual retained liability; and

calculates reimbursement payment by determining reimbursement for assessment, residual retained liability, and reimbursement for annual increase in maintenance.

7. The system of claim 6 wherein the reimbursement payment includes a residual amount over a given deductible for a duration of a period of an increase in property ownership expenses up to a coverage period.

8. The system of claim 1 wherein the database includes actuarial information or tables and records useful for risk and underwriting evaluation.

9. The system of claim 1 wherein the one or more data servers includes credit agency servers and public records servers.

10. The system of claim 1 wherein the increases in property ownership expenses include increases in assessments, maintenance costs, homeowners'"'"' association fees, and taxes.

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. 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 electronically receive information from the data sources, the data sources including one or more data servers;

aggregate electronic content that is associated with real estate ownership expenses from the one or more data servers;

analyze the electronic content to determine trends, risk, and behaviors;

generate quotes for real estate ownership expense insurance policies that reimburse for increases in property ownership expenses based on the analysis of the electronic content;

allocate, in an operating system, threads within the processes to at least one data field in a memory location;

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 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 electronic content.

13. The system of claim 12 wherein the processor further assesses the risk based on at least one of:

a credit report and criminal record of the property owner, tax history of the property, building and area demographics, building permits, and maintenance pricing history.

14. The system of claim 12 wherein the processor further assesses the risk based on factors including duration of unit ownership, property location, susceptibility to storm damage, insurance costs, repair costs, neighborhood and building demographics, average household income within the building and neighborhood, property age, property construction class, property amenities, number of units, number of floors, property/unit pricing history, property/unit maintenance pricing history, risk exposure, property tax rates and assessed values, property occupancy or vacancy, primary home, vacation/seasonal residence, unoccupied, position of decision-making authority in property administration entity, profiles of condo association members, co-op board, or homeowners'"'"' association, inbound vs. outbound contact or marketing, response to a solicitation vs. actively seeking protection, applicant credit score, and claims history.

15. The system of claim 12 wherein the processor:

determines expected losses and residual deductibles including expected loss from assessment, expected loss from increased maintenance obligation, expected residual deductible after assessment, and expected residual retained liability; and

calculates reimbursement payment by determining reimbursement for assessment, residual retained liability, and reimbursement for annual increase in maintenance.

16. The system of claim 15 wherein the reimbursement payment includes a residual amount over a given deductible for a duration of a period of an increase in property ownership expenses up to a coverage period.

17. 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 electronically receive information from the data sources, the data sources including one or more data servers;

computer program code for aggregating electronic content that is associated with real estate ownership expenses from the one or more data servers;

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

computer program code for generating quotes for real estate ownership expense insurance policies that reimburse for increases in property ownership expenses based on the analysis of the electronic content

computer program code for allocating, in an operating system, threads within the processes to at least one data field in a memory location;

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 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 electronic content.

18. The non-transitory computer-readable media of claim 17 further comprising computer program code for assessing the risk based on at least one of:

a credit report and criminal record of the property owner, tax history of the property, building and area demographics, building permits, and maintenance pricing history.

19. The non-transitory computer-readable media of claim 17 further comprising computer program code for assessing the risk based on factors including duration of unit ownership, property location, susceptibility to storm damage, insurance costs, repair costs, neighborhood and building demographics, average household income within the building and neighborhood, property age, property construction class, property amenities, number of units, number of floors, property/unit pricing history, property/unit maintenance pricing history, risk exposure, property tax rates and assessed values, property occupancy or vacancy, primary home, vacation/seasonal residence, unoccupied, position of decision-making authority in property administration entity, profiles of condo association members, co-op board, or homeowners'"'"' association, inbound vs. outbound contact or marketing, response to a solicitation vs. actively seeking protection, applicant credit score, and claims history.

20. The non-transitory computer-readable media of claim 17 further comprising:

computer program code for determining expected losses and residual deductibles including expected loss from assessment, expected loss from increased maintenance obligation, expected residual deductible after assessment, and expected residual retained liability; and

computer program code for calculating reimbursement payment by determining reimbursement for assessment, residual retained liability, and reimbursement for annual increase in maintenance.