Data management tool
AssigneeVerizon Patent and Licensing Inc.
InventorsJerold P. Menezes, Harish D. Korapati
Life of this patent
Estimating the term…
Abstract
A data management system includes a record database, an account database, a scenario database, and a computing device. The computing device includes a data management tool that is configured to identify scenarios based on information stored in the record database and store the identified scenarios in the scenario database. Further, the data management tool may associate identified scenarios with customer records stored in the account database. Upon receipt of a scenario selected by a user, the data management tool may automatically generate a query that identifies at least one customer record associated with the selected scenario, execute the query, and create a sample billing record for each customer record identified.
Claims21
A data management system comprising:
- a record database configured to store a plurality of service records, wherein each service record includes service information;
- an account database configured to store a plurality of customer records, wherein each customer record includes customer information;
- and
- a computing device in communication with the record database and the account database, wherein the computing device includes a data management tool configured to:
- identify at least one scenario based at least in part on the service information included in at least one of the plurality of service records stored in the record database,
- store each of the at least one identified scenario in a scenario database;
- associate each of the at least one identified scenario with the at least one of the plurality of customer records stored in the account database,
- receive a selected scenario from a user, wherein the selected scenario represents a customer record of at least one service,
- automatically generate a query that identifies at least one customer record associated with the selected scenario,
- execute the query,
- mask customer information included in the at least one customer record identified by the query, and
- create a sample billing record for each of the at least one customer record identified by the query, wherein the sample billing record includes at least a subset of the masked customer information.
A method comprising:
- identifying at least one scenario based at least in part on service information included in at least one service record stored in a record database, wherein each of the at least one identified scenario is associated with a unique combination of a plurality of services;
- storing each of the at least one identified scenario in a scenario database;
- associating each of the at least one identified scenario with at least one customer record stored in an account database, wherein the at least one customer record includes customer information;
- prompting a user to select at least one scenario from the scenario database, wherein the selected at least one scenario represents a customer record of at least one service;
- automatically generating a query that identifies at least one of the customer records associated with the at least one selected scenario;
- executing the query;
- masking, via a computing device, customer information included in the at least one of the customer records identified by the query;
- and
- creating a sample billing record for each of the at least one of the customer records identified by the query, wherein the sample billing record includes at least a subset of the masked customer information.
A non-transitory computer-readable medium tangibly embodying computer-executable instructions that cause a processor to execute operations comprising:
- identifying at least one scenario representing a test case associated with a type of customer based at least in part on service information stored in at least one service record stored in a record database, each of the at least one identified scenario being associated with a unique combination of a plurality of services;
- storing each of the at least one identified scenario in a scenario database;
- associating each of the at least one scenario stored in the scenario database with at least one customer record stored in an account database;
- prompting a user to select at least one scenario from the scenario database;
- automatically generating a query that identifies at least one of the customer records associated with the at least one selected scenario, the at least one of the customer records identified by the query falling within the test case identified with the type of customer;
- executing the query;
- masking customer information included in the at least one of the customer records identified by the query;
- creating a sample billing record for each of the at least one of the customer records identified by the query, the sample billing record including at least a subset of the masked customer information;
- presenting the sample billing record to the user;
- and
- receiving an indication from the user that the sample billing record was created correctly given the at least one selected scenario and the customer information associated with the at least one of the customer records identified by the query.
Dependencies are inferred from the claim text.