Computer Implemented System For Producing, Processing And Managing Structured Data Sets

Ubs Ag
Withdrawn App No 2470/KOLNP/2008 Computer Science

Patent information

IP India · live record
Application number
2470/KOLNP/2008
Filing date
19 June 2008
Status
Withdrawn
Publication number
04/2009
Publication type
INA
Invention field
Computer Science

Abstract

A data management system has a basic function configurator to define a generic basic function, whereby the function to be performed is to be depicted in a basic function by means of descriptive attributes and associated values or value ranges necessary for processing the basic function. The function is to be depicted on a data set to which a distribution rule is allocated. A data set, with its associated distribution rules, defines a generic basic function. The data sets which define the generic basic functions, together with their distribution rules for access by a product template configurator, are contained in a basic function list. The product template configurator combines one or several basic functions and transfers these to a product template, in that the generic basic functions are mutated into specific basic functions for the product template concerned by transferring or restricting the values. A product template comprises one or more basic functions belonging to a product. A product template with specific basic functions serves as a basis for a contractual relationship with a partner. The structure of the product template is stored in a product template list for access by a contract manager.

Applicants

1
Switzerland
UBS AG BAHNHOFSTRASSE 45, CH-8001 ZÜRICH, SWITZERLAND

Inventors

2
Switzerland
BANK, MARCELBUACHERSTRASSE 20, CH-5452 OBERROHRDORF, SWITZERLAND
Switzerland
ENGEL, MICHAELIM TIERGARTEN 56, CH-8055 ZÜRICH

Claims

17
1 Computer-implemented system for production, processing and management of structured data sets, wherein in this system: - a computer software program component basic function configurator is provided to define at least one generic basic function, wherein at least one service performed or to be performed in a basic function is to be depicted according to a model organised preferably at least partly hierarchically by means of descriptive attributes and associated values or value ranges necessary for processing the basic function, and wherein the service performed or to be performed is to be depicted on one or more data sets to each of which is allocated at least one distribution rule, and wherein one or more data sets together with the allocated distribution rules define a generic basic function, - a basic function directory is provided in which the data sets defining the generic basic functions are stored as a database together with their allocated distribution rules in a structured manner for access by a computer software program component product template configurator, wherein in the basic function directory, each basic function has one of the following states: - basis function released and active for product configuration - basic function released and inactive for product configuration - basic function not released and inactive for product configuration; and - the product template configurator is provided to combine from the database one or more basic functions and transfer these to a product template, in that the generic basic functions are mutated by transfer or restriction of the value and/or value ranges for the attributes and definition of default values of the attributes into specific basic functions for the product template concerned, wherein - a product template comprises one or more basic functions which compulsorily belong to a product, and can comprise one or more basic functions to be expressly added to or deselected from a product, and referenced conditions are provided such as central instructions, price data, interest conditions, with which a product template can be supplemented and wherein a referenced condition overrules values and/or value ranges for the attributes, and on creation of a product template from one or more basic functions, the state of the basic functions included is fixed as that which was productive at the time of production of the product template, and - a product template with specific basic functions serves as the basis for a contract relationship with a customer/partner, and - a product template directory is provided in which the complete structure of the product templates is stored in a structured manner for access by a computer software program component contract manager and for representation on a graphic or alphanumeric user interface, wherein the contract manager is designed to individualise a product template in that attributes are adapted within the framework of the possible value ranges, and on formation of a contract, metadata of the basic functions and product templates are accessed which indicate which software program components or business subsystems are involved in the contract concerned and by means of which attributes data are exchanged with the corresponding component, wherein - the metadata of the basic function comprise structure data and the permitted value ranges of the basic function attributes comprise the permitted business case types (BD-Type) which are established by the corresponding software program component.
2 Computer-implemented system for production, processing and management of structured data sets according to claim 1, in which the distribution rules comprise static distribution rules and/or dynamic distribution rules.
3 Computer-implemented system for production, processing and management of structured data sets according to claim 1 and 2, in which the distribution rules are defined by a rule identification number, a brief description, a long description, a rule class code and/or a rule type code.
4 Computer-implemented system for production, processing and management of structured data sets according to claim 2 and 3, in which the static distribution rules are implemented as a computer program with standardised data input and/or output interfaces.
5 Computer-implemented system for production, processing and management of structured data sets according to claim 2 and 3, in which the dynamic distribution rules are implemented as a computer program with description and implementation of the dynamic rules and/or at least one dynamic variable as a computer program.
6 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which an extension of the attributes by addition or expansion of the value ranges is excluded.
7 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules determine which conditions are to be fulfilled so that a customer/partner has access to a product with the respective basic function.
8 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules comprise age, domicile, customer segment and/or legal restrictions.
9 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules cannot be overruled.
10 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules with legal restrictions must compulsorily be transferred on product configuration.
11 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which an identification number characteristic of the distribution rule is allocated to the product template.
12 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which validation rules are provided to check whether values or ranges of attributes are observed or whether inputs in fields are correct in relation to the respective field formats.
13 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the validation rules, on checking whether values or ranges of attributes are observed or field formats are correct, return as a result "OK/NOK".
14 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which one or more validation rules are provided which perform a pre-selection and checking of product templates for which a contractual relation must be opened/modified for a customer/partner, and which on checking return a result set.
15 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which one or more validation rules are provided to determine a customer-/partner- specific preset (default) before or during representation on a graphic or alphanumeric user interface.
16 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which one or more validation rules are provided for checking observation of a value or value range or a data set to ensure processability of a basic function, wherein the values/value ranges/data sets to be checked are pre-specified in the product template concerned.
17 Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the segmenting of the service into several basic functions takes place on the basis of delimitable functions in the service to be performed. A data management system has a basic function configurator to define a generic basic function, whereby the function to be performed is to be depicted in a basic function by means of descriptive attributes and associated values or value ranges necessary for processing the basic function. The function is to be depicted on a data set to which a distribution rule is allocated. A data set, with its associated distribution rules, defines a generic basic function. The data sets which define the generic basic functions, together with their distribution rules for access by a product template configurator, are contained in a basic function list. The product template configurator combines one or several basic functions and transfers these to a product template, in that the generic basic functions are mutated into specific basic functions for the product template concerned by transferring or restricting the values. A product template comprises one or more basic functions belonging to a product. A product template with specific basic functions serves as a basis for a contractual relationship with a partner. The structure of the product template is stored in a product template list for access by a contract manager.

Specification

Show full textCollapse

Description Background of the Invention In many companies but also in authorities, today in connection with the performance of services, the establishment and performance of business relations or the performance of State tasks, huge quantities of data occur. A structured and systematic technical definition, production, processing, administration and presentation of the services performed, relationships concluded or similar are required. Only in this way can the backgrounds and details of the procedures connected with the data be reviewed at any time. One example of a service provider are banks. In banking in recent years or even decades, there has been increasing differentiation of services and prices offered. Formerly uniform services (current account, deposit etc.) with few variants have been replaced by an ever increasing number of different services and price alternatives. The range of financial instruments offered becomes ever wider and the individual financing instruments are more customer-orientated and complex. At the same time, the customer/partners on one side and the internal auditors and official authorities (supervisory authorities etc.) on the other, impose ever higher demands on the service provider in relation to transparency, consistency and completeness of data/information provided to the customer/partner by the service provider and which are produced and archived in connection with the business relationship. When for example in a bank a 'product' is sold to a customer/partner, a contract is concluded. The contract establishes the agreements between bank and customer/partner, i.e. which rights and obligations are incumbent firstly on the bank and secondly on the customer/partner. As well as basic information, above all the individual features of the product are included. Problem on which the Invention is Based One problem with the production, processing and administration of structured data sets, such as for example those which form contracts between bank customers and a bank, lies in that

the bank firstly needs as many similarly structured products in its range as possible but secondly wants/needs to meet customer/partner wishes. More and more, the circumstance must be taken into account that customer advisors are not always informed of all possibilities and also restrictions which could be important in connection with a product. In addition, the bank's professional check of 'individually' agreed contracts can be extremely costly. A second problem is that with conventional definition, production, processing and administration of products/contracts/services, the data maintenance cost incurred rises substantially as the individual agreements are difficult to store in comprehensible but simultaneously compact form. Furthermore the typifying of products/contracts/services and their processing in conventional procedures is very difficult, which is reflected in rising data traffic and increased susceptibility to error with associated extra costs. Finally the development of new products takes a relatively long time in conventional procedures. This is due in particular to rising standards of compliance with legal requirements, and the increased cost of implementation and testing in the complex IT environment of such service providers today, for example the bank or other organisation. WO 03/042861 A2 - D1 discloses a method and a device for computer-implemented production and administration of contracts. In particular a method and a device are known for computer-implemented administration of financing processes and in particular for production and administration of contracts in connection with financial services. This publication describes the computer-supported production and administration of contracts between a supplier and a customer. The contracts comprise key data in a contract object product and one or more contract modules. To structure a contract, a selection is made of key data and contract modules, and the contract is produced on the basis of the selection made by generation and storage of so-called pointers to the selected key data and contract modules. First a selection of key data is made and then a selection of contract modules. On the basis of these selected key data, which contain information and rules on the product which is the

object of the contract, the reliability of the selection of individual contract modules is checked. This publication arose from the early evaluation phase of collaboration of the applicant of this document with international banks, including the applicant of the present invention. Consequently the information in this publication on how technical implementation could take place is vague and unspecified. The document explains namely at one point only that a selection of key data and a selection of contract modules is made, and that on the basis of the selection made the contract is generated by production and storage of so-called pointers to the selected key data and contract modules. Document EP 1 286 283 A2 describes interface modules for performance of document-based electronic business processes on a transaction basis and a system for performance of electronic business processes, on a transaction basis. Thus the performance of document-based electronic transactions between heterogenic systems is facilitated. An interface module comprises a module for display and monitoring of the useful data flow. This display and monitoring take place on a document basis. The transfer of the displayed useful data to and from a terminal can take place manually or automatically. The document templates can be entered into or modified in the file system of the interface module from a master server in the data network. On a change in configuration of interface module, parameters of processes concerned of work flows formed by means of document templates can be adapted automatically. The document templates and/or a complete workflow can be coupled by means of a mapping unit into a database with predetermined destinations in the data network. Object of the Invention The object of the invention is to indicate a way of allowing, for a multiplicity of different types of products of a service provider for example a bank or other organisation, a structured and systematic definition, production, processing and administration of structured data sets such as those which describe the services and 'products' of a bank, at the level of electronic data.

Solution According to the Invention To achieve this object according to the invention a computer-implemented system for data administration is provided, a computer-implemented system for production, processing and administration of structured data sets, where in this system is provided a basic function configurator in order to define at least one generic basic function, wherein at least one function performed or to be performed is to be depicted in a basic function according to a model organised preferably at least partly hierarchically by means of descriptive attributes and associated values or value ranges necessary for processing the basic function, and wherein the function performed or to be performed is depicted on one or more data sets, to each of which is allocated at least one distribution rule, and wherein one or more data sets together with the allocated distribution rules each define a generic basic function. A list of basic functions is provided in which the data sets defining the generic basic functions together with their allocated distribution rules are stored in a structured manner as a database for access by a product template configurator. The product template configurator is preferably intended to combine one or more basic functions from the database and transfer these to a product template, where the generic basic functions are mutated by transfer or restriction of values and/or value ranges for the attributes into specific basic functions for the product template concerned. A product template comprises one or more basic functions which must compulsorily belong to a product and can comprise one or more basic functions which are to be expressly added to or deselected from a product. A product template with specific basic functions serves as the basis for a contractual relationship with a customer/partner. Also a product template list is provided in which the complete structure of the product templates is stored in a structured manner for access by a contract manager and for depiction on a graphic or alphanumeric user interface. Advantages and Effects of the Solution According to the Invention As different basic functions are defined in the computer system, with which a service (or a product) provided or to be provided can be depicted as whole, there is a high flexibility,

countless different types of products/services can be depicted and implemented in a manner efficient for storage and programming in the IT system of the service provider, bank or other organisation. For example a basic function can define the service in its outer periphery while other basic functions can depict individual part aspects of the service. Furthermore all basic functions already available and the products formed therefrom are available in the basic function list or product template list. This helps find existing basic functions/products and use or modify these as required instead of producing them again. Also by the method according to the invention, the use of standardised interfaces by the basic function supplier is required. This too simplifies programming and reduces the susceptibility to error. The clearly structured definition of the product templates and basic functions and the clear interface definition by the basic function producer, also reduce programming complexity and susceptibility to error. Also explicitly formulated distribution rules provide better checkability, not least by internal auditors or (internal or external) supervisory authorities. Also (re-)use of basic functions and product templates already defined allows a shortening of the product development cycle for future basic functions and product templates. This is due not least to the technical consideration that the (re-)use of already tested (computer program) components with confirmed suitability in operation requires less cost in production and testing of new products when these available components are used. Also redundancies in new product definitions and rules are reduced. In other words the invention is based on the concept of using in the computer system an originating database machine which provides certain functionalities (for example account management, data processing functions) and data space (permitted value ranges of data) in order to produce and manage databases and their contents. The functionalities and data spaces of the originating database machine are set relatively wide in order to be adaptable to widely varying application situations and requirements in any destination IT landscapes. From these functionalities, basic functions are produced adapted to a particular destination IT landscape and corresponding to the concrete circumstances in each case, in that data spaces

and/or functionalities are restricted. The technical objective is to achieve a faster provision of new products but also to increase the later operating reliability of the databases and efficiency in processing their content. The basic functions contain control information for bank-internal processing (for example cost calculation, reporting etc.). The functions of the basic functions are divided into part functions. Basic functions are defined by their properties, functions and value ranges. A basic function contains no information on the bank-internal use and links to other basic functions and their functions; this use is defined by the linking of basic functions in the product template. All basic functions enriched in this way are set up in a common database (repository) and thus made available. For product definition of a bank product, structural links or dependencies between such enriched basic functions are taken from the common database. Further restrictions of data space are made as specifically as possible for the desired bank product. These are product-specific usage rules of the product basic function included in the product definition of a bank product. By proceeding in this way according to the invention, financing products such as current accounts, deposits, safes and cards, but also other services can be depicted. Furthermore rights to use a particular communication channel such as E-banking can be established and controlled as service products provided by the bank. The time from the product idea to the finished product can be shortened substantially. This is possible thanks to the modules of "basic functions" and the modular product structure. Adaptations/modifications to existing products (for example new distribution rules, new interest conditions etc.) can be implemented quickly and easily. So-called "package" products, e.g. product definitions tailored to young bank customers or products with two accounts, or products in which one customer/partner retains his account for his "customer" life while prices and services are automatically controlled/defined depending on age and requirements of the customer/partner or further information, are easier to manage.

The distribution rules can comprise both static distribution rules and dynamic distribution rules. The use of dynamic distribution rules is advantageous for test or trial purposes. The distribution rules can be defined by a rule identification number, a brief description, a long description, a rule class code and/or a rule type code. The static distribution rules can be implemented as a computer program with standardised data input and/or output interfaces. The dynamic distribution rules can be implemented as a computer program with description and implementation of the dynamic rules and/or at least one dynamic variable as a computer program. An expansion of the attributes by adding or expanding the value ranges is excluded. Thus in each case it can be ensured that always basic functions or products are defined which can be processed by the system according to the invention without errors for example due to exceeding of ranges or other conflict situations. Furthermore referenced conditions can be provided such as central instructions, price specifications, interest terms, which supplement a product template. A referenced condition can overrule values and/or value ranges for the attributes, wherein each referenced condition has its own rule set and its own class code. The distribution rules determine which conditions must be fulfilled in order for a customer/partner to be given access to a product with the basic function concerned. The distribution rules can comprise age, domicile, customer segment and/or legal restrictions. The distribution rules cannot be overwritten. The distribution rules with legal restrictions must compulsorily be included in the product configuration. An identification number characterising the distribution rule can be allocated to the product template.

To check whether values or ranges of attributes are observed or whether inputs in the fields are correct in relation to the field format concerned, validation rules can be provided. The validation rules can indicate on checking whether values or ranges of attributes are observed or whether field formats are correct, giving as a result "OK/NOK". To make a pre-selection and check of product templates for which a contract relationship is to be opened/modified for a customer/partner, and which when checked return a result set, one or more validation rules can be provided. One or more validation rules can be provided to determine a customer-/partner- specific setting before or during depiction on a graphic or alphanumeric user interface. One or more validation rules can be provided to check observation of a value or value range or a data set to ensure the processability of a basic function, wherein the values/value ranges/data sets to be checked are specified in the product template concerned. The segmenting of the service into several basic functions can take place on the basis of delimitable functions in the service to be performed. Starting from the "generic" product or service thus provided, in contract conclusion a concrete and individualised agreement is reached between the service provider (for example the bank) and the customer/partner. For this a computer software program component contract manager is provided in order to retrieve from a product template list, in which the structures of the product templates are stored in a structured manner, a product template for individualisation and supplement this specifically in that either at least one preset value is transferred or a value within a permitted range is selected in order to produce an individualised contract document reflecting the contract and trigger the saving of this contract in a database and its technical processing. Thus the contract has a contract header and at least one basic function derived from the product template. From each basic function included in the contract, a basic function contract is

derived from which for each basic function producer pre-determined basic function contract data are transferred. For producers with their own data management, in the contract the basic function contract data are shown as a key and for producers without their own data management, these basic function contract data are stored in the contract. The software program component contract provides functionalities for managing the contract data available and manages all customer-/partner-relevant customer contracts. In other words the invention provides that a contract is based on a product template which the customer advisor specifically supplements in consultation with the customer/partner. Here either the pre-set value (default) is used or a value within the permitted range is selected individually for the customer/partner. Conclusion of the contract, i.e. the sale of a product, triggers two main activities on the side of the service provider (bank). Firstly a physical contract document is produced which is usually signed by both parties and given to the customer/partner. Secondly storage of a contract in the (bank) internal data processing and the technical processing of the contract are triggered. According to the invention the contract consists of a contract header and at least one basic function. The basis for the contract is the completed product template i.e. the product sold. From the product template the contract header is derived and from each basic function included in the contract, a basic function contract is produced. The basic functions can have different origins. Depending on origin of the basic function i.e. depending on the identity of the basic function producer, different basic function contract data are contained in the contract. Basic functions from particular producers with their own data management are shown in the contract merely as a key. The actual basic function contract is passed onto the producer of the basic function. Producers without their own data management simply store their basic function in a separate database. This basic function contract data are stored in the contract. Information on pricing, instructions and even interest do not appear in the contract. Storage and retrieval take place directly via the corresponding software program component. An extract from the most important contract data is replicated in a contract directory which is available as a reference directory.

The software program component contract manages and administers all customer-/partner-relevant customer contracts. The software program component contract provides services for definition of the contract data. In relation to third party software program components, the contract-specific functionalities/services are always retrieved by a software program component contract manager and never directly. One condition for opening a contract is the presence of a partner or corresponding business relationship. Each contract must consequently be able to be allocated directly to a business relationship or a partner. The contracts are always defined by the software program component contract manager. The basis for opening a contract is the product template. The product template specifies all necessary information such as value ranges, defaults, compulsory and optional fields for conclusion of a contract. The individual features of a sold product, defined on the basis of the defaults in the product template, are depicted in the contract. The contract consequently is based in structure and content on the product template i.e. each contract refers to a corresponding product template. The contract header is derived from the product template and forms the envelope for the basic function contracts belonging to the contract. The contract header contains different keys (product template ID and contract header ID). In addition further information such as for example lifecycle information (status, opening date etc.) are contained in the contract header. The basic function contract is based on the basic functions defined in the product template. On the basis of the different basic function types or producers, the basic function contracts differ in scope of information contained in the contract. Basic function producers with their own data management, to process their transactions, have their own physical data representation (i.e. table/data model) of their basic functions. In this case the contract data of the basic function contract is fully contained in the data records of the basic function producer. On contract conclusion the complete basic function contract is transmitted via an interface to the corresponding basic function producer who stores the data accordingly in his database component.

The contract itself contains only references (keys) which point to the corresponding basic function producer or holder of the basic function contract. For basic function producers with separate data management, software program components are used which do not contain their own physical representation of the basic function but store this completely in the product. On contract conclusion the complete basic function contract is stored in the contract; depending on origin of the basic function, the basic function contract may be only partially depicted. 'References' are for example prices, instructions and interest. These are not stored in the contract even as references (keys). The prices, instructions and interests belonging to a contract must be determined by corresponding querying of the software program component containing the data. The invention furthermore concerns a computer program product which is designed to implement a system defined in any of the preceding claims when processed by a computer or computer network. The computer program product can for example be stored on a computer-legible magnetic or optical information carrier (such as a CD ROM). Brief Description of the Drawings The invention is explained in more detail below with reference to the enclosed drawings. Fig. 1 shows diagrammatically a computer system and the computer program components present in the computer system and their interaction. Fig. 2 shows diagrammatically the correlation between basic function, product template and contract. Fig. 3 shows diagrammatically the processing of rules by the software program component contract manager.

Fig. 4 shows diagrammatically how a contract is produced from a product template. Fig. 5 shows diagrammatically the structure of rules and their interaction with the basic functions and product templates. Fig. 6 shows diagrammatically the retrieval of rules by the software program component contract manager. Detailed Description of Embodiment Example Fig. 1 shows a computer-implemented system for producing, processing and managing structured data sets. This system has one or more servers for data and/or program management and a multiplicity of workstations which are connected with the server for data or program exchange. In this system a computer software program component basic function configurator BLK is provided. The basic function configurator BLK serves to define a generic basic function. A generic basic function depicts at least one function performed or to be performed according to a hierarchical organised model. For this by means of descriptive attributes and associated values or value ranges necessary for processing the basic function, the generic basic function is structured and depicted on one or more data sets, to each of which is allocated at least one distribution rule. The data sets together with the allocated distribution rules each define a generic basic function. Furthermore a basic function directory BL-DICT is provided in which the data sets defining the generic basic functions together with their associated distribution rules are stored in a structured manner as a database for access by a computer software program component product template configurator. The product template configurator PVK is intended to combine one or more basic functions from the database in the basic function directory and transfer these into a product template POT, in that the generic basic functions are mutated into specific basic functions for the product template concerned by transfer or restriction of values and/or value ranges for the attributes. For this a product template POT comprises one or more basic functions which

A product is produced from one or more basic functions. For this a basic function directory (BL-DICT) contains basic functions (BL) from providers/business areas with the following states: - Basic function released and active for product configuration - Basic function released and inactive for product configuration - Basic function not released and inactive for product configuration (no more contracts may be issued). The steps are described below with which a product is configured, in that a product template (POT) is produced (or an existing product template (POT) re-used in the manner of a template): - Define product template (short text, long text, identifier, status etc) - Import one or more basic functions from the basic function directory (BL-DICT) - Basic function must be released and active

• Basic function is instanced as a product template basic function • On the product template basic function (POT-BL) the following actions are performed:

■ Its status is changed to "in processing" ■ Rules are defined for the product template basic function ■ Define permitted business case types (a basic function can have several business cases, for example basic function Account has business case types Monthly statement, Intermediate statement or Annual statement) ■ Establish or restrict attribute value ranges (within the permitted values of the basic function) ■ Establish default values of the attributes. When creating a product template from one or more basic functions, the status of the basic functions included is set at that which is productive at the time of production of the product template. This is irrespective of whether or not adaptations are made to the basic functions in the product template. This referencing applies until the next explicit mutation of the product template. Consequently there are no "sliding" or automatic updates of product templates.

A check function is provided in order if necessary to detect those product templates which use basic functions that are mutated after production or the last mutation of the product template. On the basis of this it must be checked whether the product template concerned can continue to be used sensibly. In particular individualisation of basic functions in a product template and the allocation of rules to a product template must be checked. If a product template is brought to the latest state of the basic functions contained therein, an explicit mutation to the header data of the product template is required. For this an entry is made on the existing product template ID with the current time stamp. From a product template a contract is produced by the following actions being performed (see Fig. 5): • The master data of a customer/partner are read from the corresponding database. - Check for products suitable or permitted for the customer/partner - Issue of the product list of all suitable/permitted products • The associated product template is read. - Input: product template ID and partner ID - Checking of distribution rules - Output of product or product template on the graphic/alphanumeric user interface • Individualisation of product template in that - Attributes are adapted within the possible value ranges • Open contract by - Checking distribution rules - Creating the business case "Open contract" in the database of the bank - The contract is entered in the software program component "Contract" and in the contract directory

- Any instructions and redemptions are applied - Corresponding software program components are added - The software program components "Price structure" and the attribute derivation (for account products) receive messages with partial or complete data on the contract In the formation of a contract, the metadata of the basic functions and product templates are accessed. On the basis of this information it is known which software program components or business subsystems/solution areas can or must be involved in the contract concerned. It is also known by means of which attributes/ interfaces data can be exchanged by the corresponding components. The metadata of the basic function, in particular the basic function contained in a product template, contains in addition to the structural data also permitted value ranges of the basic function attributes. These value ranges are usually established by the corresponding software program components and describe the permitted values. The value ranges can be quite complex even in basic function definition e.g. combinations from lists of individual values and value ranges can be depicted. This also applies to references to other tables e.g. reference data. From the aspect of the individual attribute they are static value ranges which may not be adequate, for example if a value range is given for an attribute which is defined by means of a data-dependent formula. For such certainly less common cases, the rule basis can be used as a solution in that for the attribute of the basic function as a value the key of the rule is given which performs the complex validation. Also with regard to a basic function a value range definition per attribute may not be adequate. A definition of value ranges across attributes is possible. For example if attribute A assumes value A1, attribute B may only assume values Bl, B2 and B3; in all other cases the value range BIO to B100 is permissible for attribute B. Also with regard to a product template the attribute-specific definition of value ranges may not be sufficient. For the above cases i.e. for dynamic value ranges of individual attributes

and for all value range checks across attributes, corresponding rules are made available via the rule basis. The rules contained therein are formulated for reusability so that as many checks as possible on different attributes, basic functions and product templates can be performed with as few rules as possible. To allow this reusability, a relationship is explicitly created between a rule and its allocated object (attribute, basic function, product template). Although a relationship can be created between each object and each rule, the following precondition applies: For rules there is no lifecycle in the rule base. Static and dynamic rules differ. In the rule base for static rules, only the information Program name, Input/output copybook name is contained. Content mutations of rules are therefore not included in the rule basis but in the reference to program. Dynamic rules are functionally limited and only provided for prototyping purposes. The relationship between rule and product template is provided in the model as a relationship entity. Here it is possible to add or remove rules subsequently during the lifecycle of a product template without the product template itself having to be altered. To correctly depict a product template, a lifecycle is managed for this relationship so that at each time in the contract the correct i.e. current valid rule is used and processed. Dynamic rules usually consist of an SQL statement and are prepared and executed by a driver program available for this. The convention is that for SQLCODE 0 (zero) the value OK is used and for SQLCODE 100 the value NOK, and for all other SQLCODES the value DB- ERROR (this is a special case for NOK) is returned. The rule base contains, as well as the SQL statement text, also descriptive information on the variables which must be provided for performance of the rule. In production because of the greater stability and speed, only static rules are executed. As the rule base for a rule contains the program name and input and output copybooks, for performance of static rules a general driver program can also be provided. For validation rules the dynamic value range of an attribute should not be structured across attributes. Instead of the static value of an attribute the key of the rule is entered. This means at the same time that in this case precisely one rule is allocated to the attribute. For value range checking across attributes, for attributes of a basic function or a basic function in a

product template, an explicit (n:m) relationship is generated between a basic function or a basic function in a product template and a rule of the rule base. Thus a basic function can have relationships with several rules and a rule can be used in several basic functions. Distribution rules can be used across several attributes of a product template i.e. also across several basic functions of this product template. Thus rules can assume considerable complexity. All the above rule types are "hard" rules i.e. they indicate whether a particular data combination can or cannot lead to a contract. Thus it is recommended to implement distribution rules only at product template level. The definition of distribution rules at the level of the basic function greatly restricts the reusability of the basic function. A rule is an independent object with its own identification (STID) and a descriptive text of 160 Bytes. The argument of a rule is a list of parameter values. The return values of a rule are usually OK or NOK. In processing types of a rule we distinguish between static (which integrates a program with fixed input and output interface (copybook)) and dynamic (integrated statement text of an SQL statement with parameter markers in which the WHERE condition result are divided into SQLCODE 0 = OK, SQLCODE 100 = NOK and other codes = ERROR. As Fig. 6 shows, a rule is retrieved such that the software program component contract manager can receive the rule ID and the input values for the rule e.g. from the GUI. Thus a generic rule driver is retrieved which reads the rule table. The rule is then executed statically or dynamically (static for production mode, dynamic for prototyping in development). The information on the rules in the rule table in the static case is the program name and input/output interface (= copybooks) and in the dynamic case an SQL statement text with parameter markers (spacers for variables) with for example around twenty variables, information on name, format of variables.

In a static rule all copybooks of all static rules are known to the rule driver. The transferred parameter values are transferred in the fields of the copybook. Then a retrieval takes place of the type "CALL program USING copybook-in, copybook-out". An OK or NOK is returned from the rule driver. In a dynamic rule the parameter markers are replaced in the statement text by transmitted values. The parameter formats are known from the rule table (numeric, character, date-time, ...). The rule is then processed by PREPARE and EXECUTE the statement text. SQLCODE 0 gives OK, SQLCODE 100 gives NOK, otherwise DB-Error. The distribution rules are retrieved for example if a customer/partner wishes to receive a particular service. Based on a search function, the program component contract manager has a list of POT's which contain relevant basic functions. The program component contract manager for each of these POT's retrieves a rule driver which checks the distribution suitability of the POT for the customer concerned. For this the rule driver inputs the business relationship ID and the POT ID. The output from the rule driver is then OK/NOK. The rule driver executes the following activities: read data on business relationship ID and read rule use with POT ID. Then each rule program is retrieved with the following interface: attribute to business relationship ID, POT ID and return of rule program OK/NOK. On the first NOK the retrieve of the rule program is interrupted and the contract manager receives NOK. To ensure a static value range (including reference tables) no rules are required in the rule base as these have already been provided by tables for the attribute values. The data on basic functions (BL) and product templates (POT) are managed so that each mutation of these objects can be clarified and reconstructed at any time. Mutations can have ad hoc validity in online operation. Mutations are also permitted in the future. For stability

and handling considerations the current valid state of a basic function or product template is defined by convention (recommendation) as the state valid for the current date at zero hours. As well as this principle there are the following conventions and application processes which are provided for managing basic functions and product templates: A basic function can be mutated as follows: - Addition/removal of attributes - Change of permitted value range of attributes These mutations are triggered by the processing of software program component (basic function producer). The addition or removal of attributes is a massive intervention which occurs relatively rarely. In the same way as a change to basic function, the interface must also be adapted.

We Claim : 1. Computer-implemented system for production, processing and management of structured data sets, wherein in this system: - a computer software program component basic function configurator is provided to define at least one generic basic function, wherein at least one service performed or to be performed in a basic function is to be depicted according to a model organised preferably at least partly hierarchically by means of descriptive attributes and associated values or value ranges necessary for processing the basic function, and wherein the service performed or to be performed is to be depicted on one or more data sets to each of which is allocated at least one distribution rule, and wherein one or more data sets together with the allocated distribution rules define a generic basic function, - a basic function directory is provided in which the data sets defining the generic basic functions are stored as a database together with their allocated distribution rules in a structured manner for access by a computer software program component product template configurator, wherein in the basic function directory, each basic function has one of the following states: - basis function released and active for product configuration - basic function released and inactive for product configuration - basic function not released and inactive for product configuration; and - the product template configurator is provided to combine from the database one or more basic functions and transfer these to a product template, in that the generic basic functions are mutated by transfer or restriction of the value and/or value ranges for the attributes and definition of default values of the attributes into specific basic functions for the product template concerned, wherein - a product template comprises one or more basic functions which compulsorily belong to a product, and can comprise one or more basic functions to be expressly added to or deselected from a product, and

referenced conditions are provided such as central instructions, price data, interest conditions, with which a product template can be supplemented and wherein a referenced condition overrules values and/or value ranges for the attributes, and on creation of a product template from one or more basic functions, the state of the basic functions included is fixed as that which was productive at the time of production of the product template, and - a product template with specific basic functions serves as the basis for a contract relationship with a customer/partner, and - a product template directory is provided in which the complete structure of the product templates is stored in a structured manner for access by a computer software program component contract manager and for representation on a graphic or alphanumeric user interface, wherein the contract manager is designed to individualise a product template in that attributes are adapted within the framework of the possible value ranges, and on formation of a contract, metadata of the basic functions and product templates are accessed which indicate which software program components or business subsystems are involved in the contract concerned and by means of which attributes data are exchanged with the corresponding component, wherein - the metadata of the basic function comprise structure data and the permitted value ranges of the basic function attributes comprise the permitted business case types (BD-Type) which are established by the corresponding software program component. 2. Computer-implemented system for production, processing and management of structured data sets according to claim 1, in which the distribution rules comprise static distribution rules and/or dynamic distribution rules. 3. Computer-implemented system for production, processing and management of structured data sets according to claim 1 and 2, in which the distribution rules are defined by a rule identification number, a brief description, a long description, a rule class code and/or a rule type code.

4. Computer-implemented system for production, processing and management of structured data sets according to claim 2 and 3, in which the static distribution rules are implemented as a computer program with standardised data input and/or output interfaces. 5. Computer-implemented system for production, processing and management of structured data sets according to claim 2 and 3, in which the dynamic distribution rules are implemented as a computer program with description and implementation of the dynamic rules and/or at least one dynamic variable as a computer program. 6. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which an extension of the attributes by addition or expansion of the value ranges is excluded. 7. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules determine which conditions are to be fulfilled so that a customer/partner has access to a product with the respective basic function. 8. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules comprise age, domicile, customer segment and/or legal restrictions. 9. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules cannot be overruled. 10. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the distribution rules with legal restrictions must compulsorily be transferred on product configuration.

11. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which an identification number characteristic of the distribution rule is allocated to the product template. 12. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which validation rules are provided to check whether values or ranges of attributes are observed or whether inputs in fields are correct in relation to the respective field formats. 13. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the validation rules, on checking whether values or ranges of attributes are observed or field formats are correct, return as a result "OK/NOK". 14. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which one or more validation rules are provided which perform a pre-selection and checking of product templates for which a contractual relation must be opened/modified for a customer/partner, and which on checking return a result set. 15. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which one or more validation rules are provided to determine a customer-/partner- specific preset (default) before or during representation on a graphic or alphanumeric user interface. 16. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which one or more validation rules are provided for checking observation of a value or value range or a data set to ensure processability of a basic function, wherein the values/value ranges/data sets to be checked are pre-specified in the product template concerned.

17. Computer-implemented system for production, processing and management of structured data sets according to any of the preceding claims, in which the segmenting of the service into several basic functions takes place on the basis of delimitable functions in the service to be performed.

A data management system has a basic function configurator to define a generic basic function, whereby the function to be performed is to be depicted in a basic function by means of descriptive attributes and associated values or value ranges necessary for processing the basic function. The function is to be depicted on a data set to which a distribution rule is allocated. A data set, with its associated distribution rules, defines a generic basic function. The data sets which define the generic basic functions, together with their distribution rules for access by a product template configurator, are contained in a basic function list. The product template configurator combines one or several basic functions and transfers these to a product template, in that the generic basic functions are mutated into specific basic functions for the product template concerned by transferring or restricting the values. A product template comprises one or more basic functions belonging to a product. A product template with specific basic functions serves as a basis for a contractual relationship with a partner. The structure of the product template is stored in a product template list for access by a contract manager.

Documents

Sign in to open
Application documents
1 abstract-02470-kolnp-2008.jpg 07 Oct 2011
2 2470-KOLNP-2008-TRANSLATED COPY OF PRIORITY DOCUMENT.pdf 07 Oct 2011
3 2470-KOLNP-2008-PA.pdf 07 Oct 2011
4 2470-KOLNP-2008-CORRESPONDENCE-1.3.pdf 07 Oct 2011
5 2470-KOLNP-2008-CORRESPONDENCE OTHERS 1.2.pdf 07 Oct 2011
6 2470-KOLNP-2008-CORRESPONDENCE OTHERS 1.1.pdf 07 Oct 2011
7 02470-kolnp-2008-translated copy of priority document.pdf 07 Oct 2011
8 02470-kolnp-2008-sequence listing.pdf 07 Oct 2011
9 02470-kolnp-2008-priority document.pdf 07 Oct 2011
10 02470-kolnp-2008-pct request form.pdf 07 Oct 2011
11 02470-kolnp-2008-pct priority document notification.pdf 07 Oct 2011
12 02470-kolnp-2008-international search report.pdf 07 Oct 2011
13 02470-kolnp-2008-international publication.pdf 07 Oct 2011
14 02470-kolnp-2008-form 5.pdf 07 Oct 2011
15 02470-kolnp-2008-form 3.pdf 07 Oct 2011
16 02470-kolnp-2008-form 2.pdf 07 Oct 2011
17 02470-kolnp-2008-form 1.pdf 07 Oct 2011
18 02470-kolnp-2008-drawings.pdf 07 Oct 2011
19 02470-kolnp-2008-description complete.pdf 07 Oct 2011
20 02470-kolnp-2008-correspondence others.pdf 07 Oct 2011
21 02470-kolnp-2008-claims.pdf 07 Oct 2011
22 02470-kolnp-2008-abstract.pdf 07 Oct 2011