US 9,811,863 B1
Database management system
Cristian Marinescu, Lake Forest, CA (US); and Emma Hart, Lake Forest, CA (US)
Assigned to Paulmar Software, Inc., Las Vegas, NV (US)
Filed by Paulmar Software, Inc., Las Vegas, NV (US)
Filed on Oct. 11, 2016, as Appl. No. 15/290,867.
Claims priority of provisional application 62/348,072, filed on Jun. 9, 2016.
Int. Cl. G06Q 40/00 (2012.01); G06Q 40/08 (2012.01); G06F 17/30 (2006.01)
CPC G06Q 40/08 (2013.01) [G06F 17/30312 (2013.01); G06F 17/30522 (2013.01); G06Q 40/12 (2013.12)] 18 Claims
OG exemplary drawing
 
1. A computer-implemented database management method for property and casualty insurance trust financial management to identify account records in response to input received via a personalized interactive user interface to automatically calculate symbolic data based on the account records and to monitor and present the account records in a useful configuration for the management of property and casualty insurance policy premium data, the computer-implemented method running on a computer having a processor and a non-transitory computer readable storage medium, the computer-implemented method comprising:
displaying the personalized interactive user interface that includes functionality for users to interactively provide a plurality of electronic data associated with a first insurance policy and an insurance premium transaction;
receiving, through the interactive user interface by a computer system, the plurality of electronic data associated with the first insurance policy and the insurance premium transaction, the plurality of electronic data comprising one or more account records;
analyzing the plurality of electronic data, by the computer system in response to receipt of the plurality of electronic data, to determine the one or more account records;
applying, by a computer system, a first database identifier to each account record of the one or more account records, wherein the first database identifier comprises a customer number and a policy number associated with the first insurance policy;
storing, by the computer system, each account record of the one or more account records and the first database identifier as a first index of a first database, the storing including writing each account record of the one or more account records within the non-transitory computer readable storage medium, and storing each first database identifier applied to each account record within the non-transitory computer readable storage medium;
wherein the first index includes a plurality of database fields and a plurality of database records, and
wherein a first database record of the plurality of database records corresponds to the first insurance policy;
automatically translating the first database into a second database, wherein the automatic translating further comprises:
accessing, by the computer system, the first index of the first database;
retrieving, by the computer system, each account record of the one or more account records from the first index of the first database;
generating, by the computer system, in response to retrieving each account record associated with the insurance premium transaction, a plurality of symbolic data records based on the one or more account records,
wherein the plurality of symbolic data records includes: a plurality of ledger records comprising:
an insured transacted premium record indicating an amount of money an insured is obligated to pay;
an insurance company net premium record indicating an amount of money an insurance company has a right to receive; and
an agency sales commission record indicating an amount of money an agent has a right to receive; and
a plurality of fiduciary records comprising:
an owner fiduciary record indicating an amount of money an agency owner has a right to receive; and
a custodian fiduciary record indicating an amount of money an agency custodian has an obligation to disburse to the insurance company and the agent, and
 wherein the generating the plurality of symbolic data records includes:
determining, by the computer system, the insured transacted premium record;
calculating, by the computer system, the agency sales commission record, based on the insured transacted premium record and a commission rate of the plurality of electronic data, wherein the agency sales commission record indicates the amount of money the agent has a right to receive;
calculating, by the computer system, the insurance company net premium record, based on the insured transacted premium record and the agency sales commission record;
determining by the computer system, the owner fiduciary record; and
determining, by the computer system, the custodian fiduciary record;
applying, by the computer system, a second database identifier to each symbolic data record of the plurality of symbolic data records,
wherein the second database identifier comprises the first database identifier and a trust ledger account record identifier, the trust ledger account record identifier configured to indicate an instruction for generating a report; and
storing temporarily, by the computer system, the plurality of symbolic data records in the second database according to the second database identifier, wherein storing the plurality of symbolic data records includes recording in the second database, by the computer system, the insured transacted premium record, the agency sales commission record, the insurance company net premium record, the owner fiduciary record, and the custodian fiduciary record;
generating, using the computer system, one or more reports based on at least a first symbolic data record of the plurality of symbolic data records stored in the second database according to the second database identifier applied to the at least a first symbolic data record,
wherein the one or more reports includes:
a trust balance sheet configured to display accounting data associated with trust financial solvency, wherein the trust balance sheet is generated by the computer system based on the plurality of ledger records; and
a statement of receipts and disbursements configured to display accounting data associated with trust fund beneficiaries and trust premium float, wherein the statement of receipts and disbursements is generated by the computer system based on the plurality of fiduciary records,
wherein the trust balance sheet and the statement of receipts and disbursements are configured to be compared to determine whether a trust is financially insolvent and to determine float owners, and
verifying, using the computer system, that no errors have occurred in the generation of the one or more reports, the verifying comprising:
accessing one of the plurality of symbolic data records;
accessing another one of the plurality of symbolic data records using a database link between each of the accessed plurality of symbolic data records; and
comparing a value of each one of the accessed plurality of symbolic data records; and
dynamically causing by the computer system, removal of memory associated with the plurality of symbolic data records from the second data base upon verification of the generation of the one or more reports,
wherein the computer system comprises electronic memory.