EP1721289A1 - Dispositif de traitement de donnees, structure de donnees et procede de distribution d'informations financieres pour une base de donnees d'informations financieres - Google Patents

Dispositif de traitement de donnees, structure de donnees et procede de distribution d'informations financieres pour une base de donnees d'informations financieres

Info

Publication number
EP1721289A1
EP1721289A1 EP04712117A EP04712117A EP1721289A1 EP 1721289 A1 EP1721289 A1 EP 1721289A1 EP 04712117 A EP04712117 A EP 04712117A EP 04712117 A EP04712117 A EP 04712117A EP 1721289 A1 EP1721289 A1 EP 1721289A1
Authority
EP
European Patent Office
Prior art keywords
data
data processing
delta
database
inventory
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Ceased
Application number
EP04712117A
Other languages
German (de)
English (en)
Inventor
Helmut Auer
Eneida Barbosa
Markus BLÄSI
Albert Curiger
Jonny Hollenstein
Hansruedi Jenzer
Marina Kappenthuler
René SARNY
Dominique Tanner
Rudolf Schwob
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Six Financial Information AG
Original Assignee
Telekurs-Holdings AG
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Telekurs-Holdings AG filed Critical Telekurs-Holdings AG
Publication of EP1721289A1 publication Critical patent/EP1721289A1/fr
Ceased legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes

Definitions

  • Data processing device data structure and method for the delivery of financial information for a financial information database.
  • the presented invention comprises a data processing device programmed for the creation and distribution of financial information according to the features of the preamble of claim 1 as well as a hierarchical data structure for messages for the financial area and a method for the creation and delivery of financial information for the finance area according to the features of the preamble of Claims 8 and 13.
  • Known data processing devices, data structures and methods for the delivery of financial information are limited to a piecewise formalization of the financial information.
  • Many data structures are primarily designed for a specific processing purpose.
  • known data structures and processes are designed to cover individual areas such as stock exchanges, securities trading, asset management, securities valuation, securities settlement, securities currency or tax returns.
  • the known data processing devices, data structures and methods therefore do not allow complete or automated processing and storage of financial data in a database while maintaining referential integrity.
  • a customer such as an asset manager, manages a particular share, for example.
  • the data provider provides him with basic data, price data, data on dividend payments and other data directly related to the share.
  • basic data which is distributed in the form of a right to a new share
  • it is now necessary that the basic data of the right and the new share are also delivered. Otherwise, automatic processing in the context of custody account management or asset management is not possible.
  • the customer today usually has to obtain the data on the rights and the new shares manually from the data supplier. This manual activity makes it difficult or impossible to react quickly to assets and to efficiently create portfolio information, such as statements of deposits, statements of assets for tax returns, etc.
  • the fragmentation into many data structures in accordance with the areas mentioned above, as is carried out by the known data processing devices and methods, does not take into account the fact that a semantically sensible and technically correct sequence of the data elements which are delivered as messages is maintained. For systematic and efficient processing, however, it is necessary that the data can be recognized and processed directly as new data, change data or deletion data.
  • the known data processing devices do not offer a data structure from which this can be recognized for each individual data field. It is, as described above, in known data processing devices e.g. It is necessary to manually order basic data on new instruments, for example those resulting from a distribution, from a data supplier in a separate work step. It is therefore not possible with the known data processing devices to automatically guarantee the referential integrity without manual intervention by the customer or supplier.
  • a subset is usually defined as a list of financial instruments, a list of companies, a list of stock exchanges and markets, or a type of financial instrument or a combination thereof.
  • No data processing device, no data structure and no method is known which, based on such a partial quantity definition, can automatically create a completion from which a minimal but complete amount of financial information data results.
  • the data processing device for the delivery of financial information for a financial information database enables the various types of financial information to be processed in a novel and simple manner using commercially available computer and programming systems.
  • the inventive data structure supports systematic, mechanical processing by standardizing all data elements from financial information to a generic data type. Customers and consumers of financial information usually differ considerably due to their different needs for data width and data depth.
  • the method according to the invention which processes the data, enables the creation of individual amounts of data in a simple manner. The process guarantees that the data are complete and correct. By completeness it is meant that no data is missing which is necessary for automatic processing and / or the lack of which would result in an information gap. The above-mentioned completeness is also referred to as semantically complete or as semantically meaningful.
  • a semantically sensible sequence of messages is given if each subset of messages that was delivered at a certain point in time represents a complete amount of data.
  • the invention provides a data structure for the reports, which summarizes business-relevant aspects of financial information such as basic data from institutions, basic data from financial instruments, payments from financial instruments, etc. in one or more data substructures, so-called data elements.
  • the data structure is designed in such a way that it represents a complete formalization of all available and conceivable information. This means that the existing data units and data fields of the data elements cannot be meaningfully broken down or formalized.
  • the data elements contain so-called key values, which consist of one or more data fields. With these key values, technical and technical entities can be clearly identified.
  • the data elements are linked to one another by key values, which are part of the data elements, in such a way that each data element has a specific set of dependent data elements in accordance with a defined method logic.
  • key values which are part of the data elements, in such a way that each data element has a specific set of dependent data elements in accordance with a defined method logic.
  • This allows all real-worldly, that is, semantically meaningful, connections between two data elements to be recorded. For example, with a key value that occurs in the data element in which an option is mapped, the link between the data element of the option and the data element of the issuer is recorded for a particular issuer, the corporate form as the issuer being recorded in the data element of the issuer. This means that there is a continuous concept of technical and non-technical keys, which enables all real-world connections between the data elements.
  • the inventive method enables the production of initial, so-called stock data elements on the one hand and mutation-oriented so-called "delta" data elements on the other hand.
  • An associated data processing device which was programmed in such a way that the inventive method can run on it, generates one from a source database or several files and / or a data stream of inventory data elements and / or delta data elements that are transmitted to the customer.
  • the data elements that appear in the generated files or in the data stream are prepared in such a way that they can be recognized as inventory data elements or delta elements. are fully keyed and organized.
  • the order of the data elements generated by the method guarantees that dependent data elements always appear after the data elements on which they depend. This ensures that after delivery of the inventory and / or delta data elements in the form of files and / or in the form of a data stream to customers, linear, mechanical processing on a computer never encounters key values that point to unprocessed data elements ,
  • the special feature of the delta data elements is the marking deletion, mutation or new.
  • deletion and mutation both the updated and the old, no longer up-to-date data are supplied in full, so that the changes in content can be identified without accessing a database
  • the inventive data structure is further distinguished by the fact that it can contain so-called informative data, which are not taken into account by the machine-based, computer-assisted processing, but improve the readability for humans.
  • informative data For example, in the case of data elements for a share belonging to the area of financial instruments, the key value of the company for which the company is the issuer of the share is given. So that the data element is easier to read for the share, the company name is included as an informative segment. The company name is supplied with a data element from the institutional area for mechanical, computer-assisted processing.
  • the method enables the creation of inventory and delta data elements on the basis of a partial quantity definition which contains a list of key values.
  • the subset definition contains, for example, a list of instrument identifications (key values for financial instruments), a list of markets or a list of financial instrument types or combinations thereof.
  • parameters for the key values can be specified in the lists, which enables a further specification of the data belonging to the subset.
  • the data processing device can for each such Subset definition by means of a procedural programming at any time create data element subsets with inventory and / or delta data elements that have the above-mentioned property of completeness.
  • the data element subset created is minimal, so that no data element can be removed 5 without losing essential information about an element from the subset definition or the completeness property still being valid.
  • the minimal property enables the processing effort for the data to be kept to a minimum.
  • the order of the data elements in the files and / or in the data stream also enables linear, direct processing for this subset of data elements, as described above, without manual intervention while maintaining IO of referential integrity.
  • the invention comprises a data processing device that is programmed to create and distribute financial information and that has at least one network-compatible interface.
  • the data processing device can be connected via the at least one interface to a dynamic number of customer systems such that the at least one
  • the 15 interface to the customer systems financial information can be transmitted from the data processing device at any time.
  • the at least one interface is designed such that, conversely, lists of key values and parameters, such as e.g. Exchange, among other things, can be transmitted to the data processing device, with the delivery files and / or delivery data streams created, inventory and / or
  • the at least one interface is designed as a secured interface.
  • the data can be actively fetched from the customer systems via the at least one interface, the so-called pull service, and / or can also be sent, the so-called push service, without active action on the part of the customer systems, for example by means of a time-controlled delivery of the data, so a higher flexibility of the data delivery and a better answer to the needs of the customers is possible.
  • the data processing device is designed in such a way that three data processing systems are recognizable, each of which is preferably equipped with a computing unit and a data memory.
  • These data processing systems are connected to each other by means of a network and programmed in such a way that a data collection system with its own database, an inventory data generation system with an inventory database and, depending on the embodiment, possibly also with a delta database, and a customer distribution system with at least one interface and possibly ( see above) of a delta database.
  • a data processing device is preferably developed in such a way that the customer distribution system can semantically create complete delivery files and / or delivery data streams with inventory and / or delta data elements for an unlimited number of lists with primary keys and parameters from the areas of institutions and financial instruments.
  • the inventory data generation system of such a data processing device creates inventory data elements from the database provided by the data collection system when it is called up or time-controlled and stores them in the inventory database provided for this purpose.
  • the associated delta data elements are either created immediately when the inventory data elements are saved and stored in a further so-called delta database, and the data elements requested by the customer are then delivered to the customer.
  • Another possibility is to only generate and send the delta data elements to the customer upon delivery.
  • These delta data elements can then be stored in a delta database, but this is not absolutely necessary. If the delta data is not saved, storage space is advantageously also not required. In this case, the data is processed dynamically. Regardless of whether the delta data is stored or not, the inventory data elements and / or delta data elements prepared in this way are transmitted to the customer via the at least one interface, preferably at specific times.
  • a second interface can e.g. be sensible, which allows direct access of the customer systems to certain data of the data collection system, in order to give the customers real-time access to new data recorded in the data collection system if the processed data is transmitted periodically.
  • each data processing system has its own computing unit and its own data memory. It is also conceivable that two data processing systems are placed spatially next to one another but separately from the third data processing system, with the corresponding configuration options with regard to data storage and computing unit.
  • the data processing device is operated particularly advantageously with a method in which inventory and delta data elements are delivered in a specific message sequence.
  • the message sequence supports data storage with referential integrity in such a way that each data element is processed according to its position in the message sequence, thus ensuring the referential integrity of the data storage.
  • the method is particularly advantageous when it is applied to a data structure as described below. It is then possible to form stock and / or delta reports from any subset of primary keys from the areas of institutions and financial instruments using predetermined procedural steps, the property of referential integrity being guaranteed and the number of reports remaining minimal.
  • the data structure according to the invention has the following message identifiers: inventory and delta.
  • the order of reporting corresponds to the five areas consisting of the areas of metadata, institutions, financial instruments, events and prices.
  • the areas or keys of the data elements of this data structure can be described as follows:
  • the foreign keys available in the institutional area that cannot be resolved locally can be resolved in the metadata area.
  • the foreign keys that exist in the area of financial instruments and cannot be resolved locally can be resolved through the areas of metadata and institutions.
  • the foreign keys that exist in the area of events and cannot be resolved locally can be resolved through the areas of metadata, institutions and financial instruments.
  • the foreign keys available in the area of prices, which cannot be resolved locally, can be resolved through the areas of metadata, institutions, financial instruments and events.
  • a computer program with a program code which, when executed on a data processing system, leads to the execution of the above-described method for creating and delivering financial information can advantageously be used in the financial field.
  • Such a computer program or program code can be stored on any data carrier.
  • FIG. 1 a and 1 c an overview of the data processing device for the creation and delivery of inventory and delta data elements
  • Fig.lb a second embodiment of the data processing device for the creation and delivery of inventory and delta data elements
  • 2 shows the inventive data structure for messages with financial information.
  • FIG. 3 four structural areas of the messages.
  • FIG. 4 shows an indirect relationship between two data elements.
  • FIG. 5 shows a schematic representation of the completeness formation with primary keys from an area B2.
  • FIG. 6 shows a schematic representation of the completeness formation Primary keys from an area B3.
  • FIG. 7 shows a schematic illustration of the combination of the completeness formations with primary keys from the areas B2 and B3.
  • FIG. 8 shows a schematic illustration of the mechanical key addition through the interactive selection of data element types
  • 1 a and 1 c show an example of an overview of a data processing device 10 according to the invention for the creation and delivery of financial data.
  • 1b also shows a variant of the data processing device 10 according to the invention for the creation and delivery of financial data.
  • common to the two variants is that in a first step of electronic data sources not described in more detail, two sources SYS! and SYS2, financial data are delivered in different, non-uniform formats via a commercially available data network NET to a data collection system HPS of the data processing device 10.
  • the data processing device 10 with the data collection system HPS is equipped with a database HPSDB and programmed in such a way that a complete set of data elements can be created at any time.
  • the data collection system HPS can be a central data processing station which, among other things, formats the incoming data for the database HPSDB or it can comprise on-site formatting stations which format incoming data and deliver them to the database HPSDB for processing and forwarding.
  • the amount of data elements is preferably divided into 5 areas B1 to B5 of a data structure according to the invention, as is shown below with reference to FIG. 2. With the help of a log file, it is possible at any time to filter out the data changed during a certain period from the total amount of data stored in the HPSDB database.
  • a stock data generation system as part of the HPS creates complete, new, stocked data items from the data elements stored in the HPSDB database on request or by scheduling and preferably taking into account the log file.
  • the new inventory data elements are stored in the inventory database SupplyDB.
  • a renewal process is used to check whether an inventory data element already exists in the SupplyDB inventory database. If this is the case, each segment of the new data element is compared with the segments of the existing one and a delta data element is generated when differences are found.
  • a delta Data element contains all new, changed, deleted and informative data segments as well as all unchanged data segments and the data segments that are no longer current and marked as old.
  • delta database DeltaDB cf. Fig. I b.
  • the check can also only be carried out when the inventory data elements are delivered, the delta data elements then preferably also being stored in a delta database DeltaDB for complete documentation, cf. 1 a and 1 c.
  • it is periodically checked whether data elements are also available in the HPSDB database for all data elements in the SupplyDB inventory database. If a data element existing in the SupplyDB database does not exist in the HPSDB database, a deletion delta data element is created. The existing data element in the supply database SupplyDB is deleted.
  • the inventory data elements are delivered with the associated delta data elements via a customer distribution system VDFS.
  • the customer distribution system VDFS can be connected via an interface S to a commercially available data network NET.
  • the customer distribution system is connected to three customer systems CS1 to CS3 via its interface S and via the data network NET.
  • any number of customer systems CS1 to CSn can of course be connected to the customer distribution system VDFS and there can also be more than one interface.
  • the customer systems CS1 to CS3 transmit lists Cifpsl, Cifps2, Cifps3 with the desired key values and parameters to the data processing device 10.
  • the customer distribution system VDFS uses the total amount of data elements generated by the delta data generation system VSS for each customer-specific key list Cifpsl to Cifps3 primary keys and Delivery files or delivery data streams CL1 to CL3, which contain inventory and / or delta data elements. This is done, as described below, for example with the help of six procedural steps for institutions Si1-Si6, for example with the help of five procedural steps for financial instruments Sf1 -Sf5 and, for example, using a combining method step.
  • the delivery data or delivery data streams CL1 to CL3 created according to the customer-specific lists Cifpsl to Cifps3 are delivered to the customer systems CS1 to CS3 via the interface S and the data network NET.
  • the customer systems CS1 to CS3 are now able to feed their database systems CDB1 to CDB3 directly, mechanically and without manual intervention, with inventory or delta data elements while maintaining referential integrity.
  • the data status in the customer databases is therefore such that all data elements on which they depend are available for all dependent data elements. This ensures, for example, that in the event of a company merger, the data on all companies involved, on the financial instruments relevant to the event and on the payments relevant to the event are selected and delivered by the data processing device with the customer distribution system VDFS and that the processing is carried out on the Customer systems CS1 to CS3 can be done automatically and without manual intervention.
  • the data processing device can be divided schematically into three data processing systems AI to A3: the first data processing system AI with the data collection system HPS, the own database HPSDB; the second data processing system A2, which in a first variant has the delta data generation system VSS with the inventory database SupplyDB and the delta database DeltaDB, cf. Fig. 1 b; and in a second variant only the delta data generation system VSS with the inventory database SupplyDB and includes, cf. 1 a and 1 c; and the third data processing system A3, which includes a customer distribution system VDFS with at least one interface S and, depending on whether the second data processing system comprises the delta database DeltaDB or not, also a delta database DeltaDB.
  • the data processing systems AI to A3 preferably each themselves have a computing unit and a data memory and are connected to one another by means of a network, as shown in FIG. 1 a.
  • the network can be an internal or an external network. If the data processing systems AI, A2, A3 are provided together locally, they can also share data storage and / or computing unit (s).
  • the amount of data elements is preferably divided into five areas B1 to B5 of a data structure according to the invention.
  • Figure 2 now shows the five areas within the inventive data structure.
  • the area metadata B1 contains structural and reference data for all financial information entities.
  • the metadata determine the tree structure for all data element types and indicate which keys are primary or foreign.
  • the reference data contain value ranges relevant to all data elements, such as country codes and language codes.
  • the Institutions B2 area includes financial information on companies of all kinds. This financial information contains, among other things, basic company data on public limited companies, basic data on countries, international organizations, data on corporate relationships, such as holding structures and data on rating information.
  • Financial instruments B3 includes financial information on financial instruments.
  • This information includes, among other things, basic data on shares, bonds, interest, options, futures, funds and stock exchange indices, data on financial instrument company relationships, data on issues and their terms, data on financial instrument structures and dependencies, data on coupon definitions, Data on the capital structure of financial instruments, data on guarantee and delivery provisions, data on ratings and oppositions.
  • Events B4 includes financial information about financial events. These events include basic information about company events, payment events, and trade events.
  • Company event data includes data on changes in capital, mergers and acquisitions, financial instrument transformations, and legal events.
  • Payment event data includes data on payments, repayments, amortization, taxes related to financial instruments and national and international tax laws, distributions and subscription rights.
  • the data on trading events include data on Quotations, delisting and trade-related information.
  • the area prices B5 includes valuation rates and tax rates (relevant rates for tax returns), stock market prices, valuations, prices, etc.
  • the lists for the individual areas B1 to B5 are not exhaustive and can also be expanded to suit the current situation. For example, it is possible at any time when a new financial instrument is introduced to include it in the area of financial instruments B3.
  • a BY area is dependent on a BX area if there is at least one data element in the BY area that contains one or more foreign keys whose associated primary key occurs in one or more data elements of the BX area.
  • the result of the area formation thus defined is now, according to the invention, a non-circular dependency (AI-AI 0) of the five areas B1 to B5. This means that none of the areas is dependent on itself via other areas.
  • FIG. 3 shows an example of two data elements DE1, DE2 from the data structure according to the invention.
  • Each data element DE1 to DEn has a data element name.
  • TKFAD basic data for institutions are held together in a data element "TKFAD" and basic information for a financial instrument in a data element with the name "TKFAD”.
  • Each data element also contains a tree-shaped hierarchy of different data segments SEG_H, SEGJ and SEG1 to SEGn.
  • the first data segment SEG_H called the header segment, contains comprehensive information for the entire data element.
  • the wide data segment SEGJ called the key segment, contains a unique identification of the data element. From the data segments SEG1 to SEGn, each higher-level segment contains information, in particular key values, for the segments that are directly or indirectly dependent on it.
  • the first data element DE1 shown in FIG. 3 has a header segment SEG_H, a key segment SEGJ and, by way of example, further data segments SEG1 to SEG7.
  • the data element DE2 has only one header segment SEG_H, one key segment SEGJ and two further segments SEG8, SEG9.
  • the header segment SEG_H contains the data fields data element type, creation date, generation number and a label for inventory or delta data element SD-FLAG (not explicitly shown).
  • the data element type identifies the type to which the data element belongs.
  • the metadata also a set of data elements, determine the tree structure, the position and the number of data segments and the structure of the data segments for each type of data element.
  • the generation number is a version identifier that serves to identify data elements from different production runs.
  • the key segment SEGJ comprises an identification number which uniquely identifies the data element together with the generation number and the creation date.
  • Each further data segment after the header segment SEG_H and the key segment SEGJ contains a segment name SN, a processing instruction VA and a list of data fields.
  • the segment name uniquely identifies the segment type.
  • the number and type of fields are thus defined using the metadata.
  • the data fields can be divided into simple and compound data fields.
  • Simple data fields SF contain a single value such as company names.
  • Compound data fields CF comprise at least two values, which can be a currency and a numerical amount value, for example in the case of a cash payment.
  • the processing instructions VA is a list of labels which can contain a label "key”, “stock”, “deletion”, “mutation”, "new", “old”, “unchanged” or “informative” for each value of a data field ,
  • the identification "key” means that the field value belongs to a primary or foreign key.
  • the identification “deletion” means that the field value no longer exists.
  • the labeling “Mutation” means that the field value has been changed.
  • the label “new” means that the field value is a new, not yet delivered value.
  • the label “old” means that the field value is no longer current.
  • the label “unchanged” means that the field value is unchanged.
  • the label “informative” means that the field value is redundant and not intended for electronic processing. In its processing instructions, inventory data elements only have the labels "key”, “inventory”, “new” and “informative”. Delta data elements use in the processing instructions, however, all the above-mentioned labels.
  • SB represents a key dependency from data element DE2 to data element DE1.
  • the dependency exists because segment SEG3 with its dependent segments SEG5, SEG6 and SEG7 contains key values and data from an information entity such as, for example, a public limited company .
  • the data element DE2 uses the key values contained in SEG8 to link this information entity.
  • the key values of the information entity are called primary keys in SEG3.
  • the metadata can be used to differentiate between primary and foreign keys. If the key values are used in a dependent data element to link information entities, the key values are called foreign keys.
  • a foreign key in a data element can be resolved if the primary key occurs further up in the segment hierarchy of the data element itself or in another existing data element as the primary key.
  • the referential integrity is maintained in electronic processing of a list of data elements if and only if any foreign key occurring in the data elements can be resolved by the own data element or by at least one data element preceding the list or by a data element from a database available for this purpose ,
  • a foreign key is resolved within the data element in which it occurs or by a data element from the area of the data element carrying the foreign key, then the foreign key is called locally resolvable.
  • a data element from the area Events B4 which represents the payment of a dividend, contains a segment with a foreign key from a share.
  • TKFAD instrument base element
  • the data element with the dividend payment is dependent on the data element "TKFAD”.
  • Figure 4 illustrates the relationship directly and indirectly dependent between two data elements.
  • a data element DEy is directly dependent on a data element DEx (dir) if DEy has a foreign key that appears in DEx as the primary key.
  • DEz is indirectly dependent on DEx if DEz is directly dependent on DEy and DEy is dependent on DEx.
  • completeness formation is meant a method which forms an extension set from a specified specification of a subset, so that no data are missing which are necessary for automatic processing and / or if there were no information gap. For example, a dividend payment in the form of a right always includes the basic data about the right. Otherwise, the data for the dividend payment is not complete and cannot be processed correctly and is therefore of no use for business use.
  • the completeness formation is particularly intended for delivery to customers who have different needs for data depth.
  • FIG. 5 schematically shows the completeness formation of inventory data elements in the case of a predetermined list of primary keys lps (institutional primary key) from the area of institutions B2.
  • the inventory areas Supplyl to Supply4 represent the inventory data sets that contain the data elements that belong to the areas B1 to B4.
  • a first step Sil the inventory data elements from the inventory area Supply2 of the area Institutions B2 are selected which contain one or more of the keys from the list lps as the primary key.
  • Sil become directly and indirectly dependent inventory data elements from the inventory area Supply2 are added to these inventory data elements, so that the subset T2Si1 is created.
  • the inventory data elements directly or indirectly dependent on T2Sil are determined from the inventory area Supply3.
  • T4Si3 inventory data elements from the inventory area Supply4 are compiled, which depend directly or indirectly on data elements of T3Si2 and T2Si1.
  • step Si4 a further subset T3Si4 is formed in Supply3, which contains data elements that have at least one directly or indirectly dependent data element in T4S ⁇ 3.
  • T3S14 is in turn completed so that directly and indirectly dependent elements from Supply3 are also contained in T3Si4.
  • a subset T2Si5 of Supply2 is formed.
  • T2Si5 contains data elements that contain at least one directly or indirectly dependent data element in T3Si4 or T4Si3.
  • T2Si5 is also completed so that directly and indirectly dependent elements from Supply2 are also contained in T2Si5.
  • No subset is created for the quantity Supplyl, which contains all data elements for the reference and metadata.
  • steps Si2 to S ⁇ ' 5 are repeated in an iterative process until new, dependent data from the supply data stocks can no longer be assigned to the subsets.
  • the last step Si6 contains the creation of the delivery file and / or the delivery data stream.
  • the subsets T2SÜ and T2Si5 are combined, sorted according to their internal dependency and stored as a file or data stream T2SM 5-F.
  • the subsets T3i and T3e are also combined, sorted according to their internal dependency and stored as a file or data stream T3Si24-F.
  • the subset T4i is also sorted according to the internal dependency and saved as a file or data stream T4Si3-F.
  • the quantity Supplyl is saved as a file or data stream Supplyl -F.
  • the delivery file or the delivery data stream IpsSupplyOut now contains the parts Supplyl -F, T2Si 1 5-F, T3S ⁇ 24-F and T4SJ3-F in this order.
  • FIG. 6 shows how completeness formation is carried out by means of financial instrument identification.
  • FIG. 6 schematically shows the completeness formation of inventory data elements in the case of a predetermined list of primary keys Fps from the area of financial instruments B3.
  • a first step Sfl the data elements from the stock area Supply3 from the area financial instruments B3 are selected which contain one or more of the keys from the list Fps as the primary key.
  • directly and indirectly dependent data elements from the stock area Supply3 are added to these data elements, so that the subset T3Sf1 is created.
  • the data elements directly or indirectly dependent on T3Sfl are determined from the stock area Supply4 area B4 (events). This results in the subset T4Sf2.
  • step Sf3 a further subset T3Sf3 is formed from the stock area Supply3, which contains data elements that have at least one directly or indirectly dependent data element in T4Sf2.
  • T3Sf3 is in turn completed so that directly and indirectly dependent elements from the supply area Supply3 are also included in T3Sf3.
  • a subset T2Sf4 of Supply2 is formed.
  • T2Sf4 contains data elements that contain at least one directly or indirectly dependent data element in T3Sf3 or T4Sf2.
  • T2Sf4 is also completed so that directly and indirectly dependent elements from the Supply2 inventory area are also included in T2Sf4.
  • the various steps are repeated iteratively until no new data elements can be assigned to the subsets.
  • the last step Sf5 contains the creation of the delivery file and / or the delivery data stream.
  • the subset T2Sf4 is sorted according to the internal dependency and saved as a file or data stream T2Sf4-F.
  • the subsets T3 and T3Sf3 are combined, sorted according to the internal dependency and saved as a file or data stream T3SH 3-F.
  • the subset T4Sf2 is sorted according to the internal dependency and as a file or data stream T4Sf2-F saved.
  • the amount of Supplyl is saved as a file or data stream Supplyl -F according to the internal dependency.
  • the delivery file or the delivery data stream IpsSupplyOut now contains the parts Supplyl -F, T2Sf4-F, T3Sfl 3-F and T4Sf2-F in this order.
  • FIG. 5 and FIG. 6 can be combined in such a way that the completion can be formed by means of a list of institutional identifications (keys of institutions) and a list of financial instrument identifications (keys of financial instruments).
  • the area prices B5 was not taken into account in the examples which were explained with reference to FIGS. 5 and 6.
  • the methods explained can be extended analogously to an additional area 5.
  • FIG. 7 shows a schematic representation of the combination of the completeness formations with primary keys from the areas B2 and B3.
  • the delivery files or delivery data streams IpsSupplyOut and FpsSupplyOut can be created with a set of primary keys from the areas B2 and B3.
  • the two methods can be combined using the additional step Si e, so that a delivery file or a delivery data stream IfpsSupplyOut can be created for a set of primary keys from the areas B2 and B3.
  • the subsets T2SÜ 5-F with T2Sf4-F, T3Si24-F with T3Sfl 3-F and T4Si3-F with T4Sf2-F are combined and sorted according to the internal dependency and as files T2-T2e-T2f-F, T3-T3i -T3e-T3f-F and T4i-T4Sf2-F saved.
  • the delivery file or the delivery data stream IfpsSupplyOut now contains the parts Supplyl -F, T2-T2e-T2f-F, T3-T3i-T3e-T3f-F and T4i-T4Sf2-F in this order.
  • IfpsSupplyOut is now the amount of inventory data that can be delivered to a customer, prepared according to his needs using the method shown. Delta data elements are prepared and delivered to customers in the same way. In order to keep the amount of data delivered as small as possible, only data that has undergone a change, is new or has been requested for the first time is delivered.
  • the delivery of the data sorted by "deletion" and "mutation / new", ensures referential integrity.
  • FIG. 8 shows, by way of example, that the use of data elements with payment events as a source for expanding the lists Fps with a financial instrument key makes it possible to create portfolio information automatically.
  • the customer can select according to the invention parameters which, in the data processing device 10 according to the invention, lead to the selection of data element types which serve as sources for the extension described below.
  • a file F1 with a single share key fl is shown as an example.
  • the completeness formation, as shown in FIG. 6, is carried out for the share key fl in accordance with the steps Sfl, Sf2, Sf3. Also for the sake of simplicity, only individual data elements of interest in this example are shown.
  • the data element TKFAD1 contains the basic data for the share with key fl.
  • TKXCD1 is an event data element in the form of a rights distribution. This means that TKXCD1 contains a foreign key, which is resolved using the basic data element of the right, TKFAD2.
  • the data element TKXRD2 represents the payment event for the purchase of new shares by means of rights. According to FIGS. 4 to 6, this element is now not necessary for the processing maintaining referential integrity and therefore not in the amount of data which is formed on the basis of the key amount F1.
  • the data processing device now enables by means of an initial command, which is carried out by each customer can be that foreign keys of financial instruments that occur in certain event data element types are automatically written to a second, further key list S1 during each completeness formation.
  • the processes from FIGS. 5 to 7 are applied to S1 or a further, newly created key list and the resulting amount of data is delivered to the customer.
  • the second list S1 is created in step Sf2, and the foreign key of rights f2 is written in the list S2.
  • the subsequent, second execution of the process of FIG. 5 will include an exercise event TKXRD and an underlying TKXUD for the entitlement.
  • the underlying and the exercise event contain a foreign key of the financial instrument to be obtained.
  • the basic element TKFAD3 is also included in the delivery quantity for the new share.

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Finance (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
EP04712117A 2004-02-18 2004-02-18 Dispositif de traitement de donnees, structure de donnees et procede de distribution d'informations financieres pour une base de donnees d'informations financieres Ceased EP1721289A1 (fr)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/IB2004/000428 WO2005088497A2 (fr) 2004-02-18 2004-02-18 Dispositif de traitement de donnees, structure de donnees et procede de distribution d'informations financieres pour une base de donnees d'informations financieres

Publications (1)

Publication Number Publication Date
EP1721289A1 true EP1721289A1 (fr) 2006-11-15

Family

ID=34957057

Family Applications (1)

Application Number Title Priority Date Filing Date
EP04712117A Ceased EP1721289A1 (fr) 2004-02-18 2004-02-18 Dispositif de traitement de donnees, structure de donnees et procede de distribution d'informations financieres pour une base de donnees d'informations financieres

Country Status (3)

Country Link
EP (1) EP1721289A1 (fr)
JP (1) JP2007523422A (fr)
WO (1) WO2005088497A2 (fr)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1828658A (zh) * 2005-03-31 2006-09-06 阿里巴巴公司 自有资源的交互方法以及电子交易信息的处理方法
WO2011109911A2 (fr) 2010-03-08 2011-09-15 Six Telekurs Ag Système et procédé de fourniture de données financières

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020073236A1 (en) * 2000-01-14 2002-06-13 Helgeson Christopher S. Method and apparatus for managing data exchange among systems in a network

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH10187521A (ja) * 1996-12-20 1998-07-21 Nippon Telegr & Teleph Corp <Ntt> 流通データ作成方法及び装置
JP2002073385A (ja) * 2000-08-30 2002-03-12 Fujitsu Ltd データベース管理装置及び管理テーブル作成方法
JP2002157161A (ja) * 2000-09-11 2002-05-31 Ntt Docomo Inc データ転送方法およびデータ転送システムならびに記録媒体およびプログラム
JP2002109217A (ja) * 2000-09-29 2002-04-12 Hitachi Kokusai Electric Inc 携帯端末を用いた情報提供システム
JP2002230300A (ja) * 2001-02-02 2002-08-16 Takashi Sakurai 証券取引システム
JP2002351892A (ja) * 2001-05-30 2002-12-06 A & D:Kk 商標検索システム及び商標出願支援システム
WO2004010359A1 (fr) * 2002-07-23 2004-01-29 Tamaru International Inc. Dispositif et systeme d'appoint pour activites boursieres

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020073236A1 (en) * 2000-01-14 2002-06-13 Helgeson Christopher S. Method and apparatus for managing data exchange among systems in a network

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
DON BOX; AARON SKONNARD; JOHN LAM: "Essential XML: Beyond Markup", 13 July 2000 (2000-07-13), XP055034559, ISBN: 978-0-201-70914-8, [retrieved on 20120802] *

Also Published As

Publication number Publication date
JP2007523422A (ja) 2007-08-16
WO2005088497A2 (fr) 2005-09-22

Similar Documents

Publication Publication Date Title
DE3855468T2 (de) Rechnersystem für fortschrittliche finanzielle Anwendungen
DE60306663T2 (de) Verfahren, Vorrichtungen und Programme zur Regelung des Zugriffs auf Datenobjekte unter Verwendung von Sperren
WO1999067749A1 (fr) Releve de temps de travail pour differentes applications
EP1403793A1 (fr) Procédé pour la consignation intégrée et automatique des documents dans l&#39;enregistrement des transactions commerciales
DE10240117A1 (de) Netzwerkbasiertes Informationsmanagement
EP1758051A1 (fr) Système, méthode et logiciel pour le traitement de données basées sur la séquence de travail
DE10017710A1 (de) Verfahren zum Erfassen und Verarbeiten von Daten von Geschäftsvorfällen
WO2002078050A2 (fr) Procede et dispositif pour produire une image d&#39;un processus de fabrication de type reseau
EP1637956A1 (fr) Génération d&#39;ensembles de données anonymisées et actualisables destinés aux tests et dévéloppement
WO2007059978A1 (fr) Systeme implemente sur ordinateur pour produire, traiter et gerer des ensembles de donnees structures
DE102007013340A1 (de) System und Verfahren zum Verwalten von Umwelteinwirkungen von Unternehmen
WO2006063679A1 (fr) Gestion de versions de donnees au moyen d&#39;horodateurs
EP1721289A1 (fr) Dispositif de traitement de donnees, structure de donnees et procede de distribution d&#39;informations financieres pour une base de donnees d&#39;informations financieres
EP1239375B1 (fr) Procédé de conversion de documents
WO2009012802A1 (fr) Système et procédé de gestion de la génération et de la répartition de publications
EP1414591B1 (fr) Procede de production automatique de donnees en sequences reparties actuelles
EP1403794A1 (fr) Procédé et système de mémorisation automatique de données relatives à la gestion d&#39;entreprise
CH712796B1 (de) Einrichtung zur Datenverarbeitung für ein Verfahren zur Ermittlung der Gewichte von Konstituenten eines Zielportfolios.
WO2005006224A2 (fr) Structure de donnees financieres, systeme d&#39;ordinateur et procede de definition d&#39;une structure de donnees financieres
DE202022104317U1 (de) System zum Verwalten und Nachverfolgen eines wiederverwertbaren Rohstoffs
Lundstrom The Development of Small and Medium-sized Enterprises-Some Empirical Findings (Sweden)
DE10220942A1 (de) Verfahren und Anordnung zur automatischen Vermittlung zwischen Anbietern und Nachfragenden, insbesondere zur (Vertrags-)Vermittlung zwischen Immobilienanbietern und -suchenden sowie ein entsprechendes Computerprogramm-Erzeugnis und ein entsprechendes computerlesbares Speichermedium
JP2001306935A (ja) Ir等情報専門サイトの運営システム
EP1212715A2 (fr) Systeme de traitement electronique de donnees pour la gestion d&#39;entreprises
DE19911373A1 (de) Einrichtung und Verfahren zum Betrieb von Geschäftsprozessen in einem verteilten Informationsnetz

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20060918

AK Designated contracting states

Kind code of ref document: A1

Designated state(s): AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LI LU MC NL PT RO SE SI SK TR

RIN1 Information on inventor provided before grant (corrected)

Inventor name: SCHWOB, RUDOLF

Inventor name: BARBOSA, ENEIDA

Inventor name: KAPPENTHULER, MARINA

Inventor name: AUER, HELMUT

Inventor name: BLAESI, MARKUS

Inventor name: SARNY, RENE

Inventor name: TANNER, DOMINIQUE

Inventor name: CURIGER, ALBERT

Inventor name: JENZER, HANSRUEDI

Inventor name: HOLLENSTEIN, JONNY

RIN1 Information on inventor provided before grant (corrected)

Inventor name: BARBOSA, ENEIDA

Inventor name: JENZER, HANSRUEDI

Inventor name: TANNER, DOMINIQUE

Inventor name: BLAESI, MARKUS

Inventor name: HOLLENSTEIN, JONNY

Inventor name: KAPPENTHULER, MARINA

Inventor name: CURIGER, ALBERT

Inventor name: AUER, HELMUT

Inventor name: SCHWOB, RUDOLF

Inventor name: SARNY, RENE

17Q First examination report despatched

Effective date: 20070423

DAX Request for extension of the european patent (deleted)
RAP1 Party data changed (applicant data changed or rights of an application transferred)

Owner name: SIX TELEKURS AG

RAP1 Party data changed (applicant data changed or rights of an application transferred)

Owner name: SIX FINANCIAL INFORMATION AG

APBK Appeal reference recorded

Free format text: ORIGINAL CODE: EPIDOSNREFNE

APBN Date of receipt of notice of appeal recorded

Free format text: ORIGINAL CODE: EPIDOSNNOA2E

APBR Date of receipt of statement of grounds of appeal recorded

Free format text: ORIGINAL CODE: EPIDOSNNOA3E

APAF Appeal reference modified

Free format text: ORIGINAL CODE: EPIDOSCREFNE

APBT Appeal procedure closed

Free format text: ORIGINAL CODE: EPIDOSNNOA9E

REG Reference to a national code

Ref country code: DE

Ref legal event code: R003

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION HAS BEEN REFUSED

18R Application refused

Effective date: 20190122