System for customizing specific database models using specific database views
View Patent ↗A computer system is operable to receive a plurality of database tables from a plurality of clients, and store the database tables. The system permits a user to create a plurality of views for the database tables. Each of the plurality of views includes a plurality of fields. The system associates the plurality of views with a generic application, and presents to a user one or more configuration options. The configuration options include the plurality of fields. The system permits a user to define a generic field role for one or more of the plurality of fields. Finally, the system executes the generic application using the configuration options selected by the user and the defined generic field roles to create a user interface for a particular client.
1. A system comprising:
a computer processor operable to:
receive a plurality of database tables from a plurality of different, independent third-party clients in different industries, wherein each of the database tables comprises a database model;
store the database tables in a computer storage device of a software vendor who services the plurality of clients using the plurality of database tables and who maintains the database tables in the computer storage device for the plurality of clients, such that the database tables of the plurality of clients are replicated into the computer storage device of the software vendor;
create a plurality of views for the database tables, the plurality of views each comprising a plurality of fields;
associate the plurality of views with a generic application of the software vendor, wherein the generic application is used by the plurality of clients, and wherein each of the plurality of views serves as a connection between the generic application of the software vendor and a particular database model of a particular client;
present to a user one or more configuration options, the configuration options comprising the plurality of fields;
define a generic field role for one or more of the plurality of fields; and
execute the generic application using the configuration options selected by the user and the defined generic field roles to create a user interface for the particular client.
2. The system of claim 1 , wherein the plurality of clients represent a plurality of industries.
3. The system of claim 1 , wherein the computer storage device comprises an in-memory database.
4. The system of claim 3 , wherein the in-memory database is associated with a software vendor and maintained by the software vendor for the plurality of clients.
5. The system of claim 1 , wherein the generic field role comprises one or more of a selection field, a key field, and a data enrichment field.
6. The system of claim 5 , wherein the selection field comprises a column in a client database, and wherein the selection field is operable to function as a filter to limit a number of rows of the client database that are processed.
7. The system of claim 5 , wherein the computer processor is operable to map the key field such that data from the plurality of database tables is available for use in a user interface and the data enrichment field.
8. The system of claim 1 , wherein the system comprises a fraud management system.
9. A method comprising:
receiving a plurality of database tables from a plurality of different, independent third-party clients in different industries, wherein each of the database tables comprises a database model;
storing the database tables in a computer storage device of a software vendor who services the plurality of clients using the plurality of database tables and who maintains the database tables in the computer storage device for the plurality of clients, such that the database tables of the plurality of clients are replicated into the computer storage device of the software vendor;
creating a plurality of views for the database tables, the plurality of views each comprising a plurality of fields;
associating the plurality of views with a generic application of the software vendor, wherein the generic application is used by the plurality of clients, and wherein each of the plurality of views serves as a connection between the generic application of the software vendor and a particular database model of a particular client;
presenting to a user one or more configuration options, the configuration options comprising the plurality of fields;
defining a generic field role for one or more of the plurality of fields; and
executing the generic application using the configuration options selected by the user and the defined generic field roles to create a user interface for a particular client.
10. The method of claim 9 , wherein the plurality of clients represent a plurality of industries.
11. The method of claim 9 , wherein the computer storage device comprises an in-memory database.
12. The method of claim 11 , wherein the in-memory database is associated with a software vendor and maintained by the software vendor for the plurality of clients.
13. The method of claim 9 , wherein the generic field role comprises one or more of a selection field, a key field, and a data enrichment field.
14. The method of claim 13 , wherein the selection field comprises a column in a client database, and wherein the selection field is operable to function as a filter to limit a number of rows of the client database that are processed.
15. The method of claim 13 , comprising mapping the key field such that data from the plurality of database tables is available for use in a user interface and the data enrichment field.
16. A computer readable medium comprising instructions that when executed by a processor execute a process comprising:
receiving a plurality of database tables from a plurality of different, independent third-party clients in different industries, wherein each of the database tables comprises a database model;
storing the database tables in a computer storage device of a software vendor who services the plurality of clients using the plurality of database tables and who maintains the database tables in the computer storage device for the plurality of clients, such that the database tables of the plurality of clients are replicated into the computer storage device of the software vendor;
creating a plurality of views for the database tables, the plurality of views each comprising a plurality of fields;
associating the plurality of views with a generic application of the software vendor, wherein the generic application is used by the plurality of clients, and wherein each of the plurality of views serves as a connection between the generic application of the software vendor and a particular database model of a particular client;
presenting to a user one or more configuration options, the configuration options comprising the plurality of fields;
defining a generic field role for one or more of the plurality of fields; and
executing the generic application using the configuration options selected by the user and the defined generic field roles to create a user interface for a particular client.
17. The computer readable medium of claim 16 , wherein the computer storage device comprises an in-memory database; and
wherein the in-memory database is associated with a software vendor and maintained by the software vendor for the plurality of clients.
18. The computer readable medium of claim 16 , wherein the generic field role comprises one or more of a selection field, a key field, and a data enrichment field.
19. The computer readable medium of claim 18 , wherein the selection field comprises a column in a client database, and wherein the selection field is operable to function as a filter to limit a number of rows of the client database that are processed.
20. The computer readable medium of claim 18 , comprising instructions for mapping the key field such that data from the plurality of database tables is available for use in a user interface and the data enrichment field.