DE10109876B4 - Method and device for data management - Google Patents

Abstract

method for data management, in which by at least one electronic Computer (11) from at least one data workbook (12) with a set structured data with dependencies at least between individual data using an extraction method automatically extracts at least one class and at least one instance is where the class structure information in the form of instructions (14) and / or references and / or attribute definitions (15) and the Instance contains data in the form of attribute values (17) in which at least individual structured data of the data workbook (12) be automatically analyzed by the electronic calculator (11) and is detected, whether it is class data (14, 15) or instance data (17), in which at least a subset of the automatically extracted Class data (14, 15) of the at least one data workbook (12) in the electronic computer (11) automatically to at least one class file (13; 20; 25) and at least a subset of the automatically extracted Instance data (17) of the at least one data workbook (12) in the electronic Calculator (11) automatically to at least one instance file ...

Description

The The present invention relates generally to a method and a method Device for data management.

The ever-increasing need for generation, forwarding as well as the handling of information in economic sectors, such as for example, information management, risk management, Accounting and the like, leads to more and more complicated expectant information flows. To such information flows To become master, a variety of computer programs are developed Service.

Classical Computer program development usually starts with an analysis of the general requirements, generate on the basis of this analysis Program means that subsequently adapted to existing, specific needs and possibly existing ones Systems need to be implemented. The mastery of complex information flows with the help of special program means is but associated with a number of disadvantages.

For example can the demands placed on the computer programs in the environment of the program users relatively fast and change frequently so that the programs constantly must be adapted to the new requirements. Furthermore, such Computer programs are usually so complex that they lack profound knowledge in the field of programming can not be changed. Furthermore takes the complexity of programs with increasingly complicated information flows (im further course of the description also called "Work Flow") usually exponential to. After all There are often communication problems between users of programs and their programmers, since both groups in the Usually "one different terminology "speak.

From the DE 199 54 268 A1 For example, a method and system for improving workflow throughput in workflow application systems is known, which identifies areas in a workflow graph that can be edited on a single workstation and that optionally run without a central workflow server can. From the DE 195 35 084 A1 For example, a method and apparatus for dynamically optimizing computer system managed business processes is known, wherein business process instances of a business process are managed by a workflow management computer system. US Pat. No. 6,028,997 A further discloses a method for generating an implementation of reusable components of a workflow process model.

With the advent of software solutions such as for example, spreadsheets and the like the users possible solutions They have helped to create their own information and information flows independently implement and monitor. such software solutions also allow users without special programming skills, relatively complicated information flows comprehend and master. Because with the help of such Programs created solutions generated by the user himself, the solutions are always adapted to the respective requirement and thus highly specialized. Furthermore, such computer programs are relatively easy to learn, so that you can be practically controlled by anyone. However, also point Such computer programs have a number of disadvantages. The more complicated becomes an information flow, the more resources you need for the manual editing of this information flow provided be, mainly for the Updating and maintaining individual datasheets and documents, used in the context of the flow of information and, where appropriate changed become. A representation of complex information structures with different Levels is usually not with such known programs possible. Other disadvantages can for example, risks in terms of reliability, documentation, the user and the like generate.

To today, none of the risks mentioned could be reduced without that this Program was thereby complicated.

Of the The present invention is therefore based on the object, a method and to provide a data management facility with which the disadvantages mentioned in the prior art can be avoided. Especially it should be possible in a simple yet reliable way Information flows, and above all, complicated and extensive information flows easy way to represent and edit.

This object is achieved by the method for data management according to claim 1 and the device for data management according to claim 22. Further advantages, features, details and effects of the invention will become apparent from the dependent claims, the description and the Drawings. Features and details described in connection with the method according to the invention also apply to the device according to the invention and vice versa.

Of the The invention is based on the finding that the object is achieved thereby can that through a special data management existing information flows in particular easy to automatically analyze and automate can, and that information flows particularly simple, error-free and reliable can be changed. In order to the invention is particularly well suited for automatic management or for the automatic creation of such data management.

According to the first Aspect of the invention is provided a method for data management, in which by at least one electronic computer from at least a data workbook with a lot of structured data with dependencies at least between individual data using an extraction method automatically extracts at least one class and at least one instance where the class contains structural information in the form of "instructions" and / or references and / or Attribute definitions and the instance data in the form of attribute values contains in which at least individual structured data of the data workbook of electronic calculator are automatically analyzed and recognized is included, whether it is class data or instance data the at least one subset of the automatically extracted class data of the at least one data workbook in the electronic computer automatically is linked to at least one class file and at least a subset of the automatically extracted instance data of at least a data workbook in the electronic calculator automatically at least linked to an instance file becomes.

By the inventive method it becomes possible in a simple way existing information flows (Work Flows) to analyze and edit. The inventive method of the basic idea that data workbooks, those with a conventional, easy-to-use computer program were made automatically into a process for Be transferred to data management, which runs on at least one electronic computer and the overseeing the administration and change such data workbooks takes over.

there is the method of the invention is not on certain types of data workbooks limited. Rather, the method of the invention for every Form of structured data applicable in which dependencies between individual data.

The inventive method is therefore based on the idea that from an existing data workbook automatically using at least one extraction method Class and at least one instance is extracted. It will thus automatically a kind of template (the class) from the data workbook created, which subsequently as a template for each additional instance can serve.

As a "data workbook" is in accordance with the present Invention understood a file with a lot of structured data, being between individual data dependencies and / or dependencies data in other data workbooks. The structured data can in any form. This may be the case with the data workbook for example, one using a spreadsheet method, created using a word processing method or the like Act file. It is also conceivable that the data workbook in the form of an HTML page, an XML page and the like is formed. Of course, the invention is not limited to the examples mentioned, so that other forms of data workbooks possible are.

One such data workbook is inventively by means of an extraction method automatically into at least one class and at least one instance extracted. This extraction method is on or performed with the help of at least one electronic computer. the Extraction method is based on the operation that it is the Data Workbook automatically analyzed and it recognizes whether it is the individual data of the data workbook is class data or instance data. The extraction process can be carried out, for example, with or with the aid of appropriate programs.

at a "class" is generally an abstract representation the structure of a data workbook. A class can thus for example one or more "instructions" and / or one or more have multiple references and / or one or more "attribute definitions".

"References" can be up Data from the same data workbook (internal) and / or data from other data workbooks reference (externally).

Under The term "instruction" is used in the context the present invention, for example, computing conditions, calculation rules, Formulas, procedures, flowcharts and the like understood.

Next or instead of "instructions" the Classes also contain attribute definitions. "Attribute definitions" are usually not changeable (static) data that relates to certain types of data, to specific ones Make labels or other aspects to further Data, that is to certain attributes, such as shapes, Sizes and Units of input values and the like.

at an "attribute" is special information that is in the data workbook. If the data workbook for example, in the form of a spreadsheet file, an attribute is a specific, concrete one Value stored in a specific cell of the file.

at an "instance" is according to the present Invention by a concrete class, that is generally to a more concrete Representation, at the possible Variables take concrete values. An instance thus provides one shaping a class, such as a special kind of form that is on a very specific way has been completed.

One Workbook according to the present Invention may thus include a class and an instance, wherein the class can contain calculation rules and attribute definitions and the attribute values themselves represent instance values.

By the inventive method It is possible in a simple yet reliable way, the disadvantages described in connection with the prior art to avoid, there by means of the method data workbooks be isolated by the user of the process. Furthermore, by the inventive method the possibility created that structural and / or concrete contents of a data workbook only by means of of a defined procedure changed and also clearly analyzed and processed can, as will be explained in more detail later in the description. simultaneously will the flexibility of the method is not restricted. Furthermore, it is possible by the inventive method, more Applications and / or characteristics of a particular data workbook. The way this way generated data workbooks can Easily exchanged between individual users of the process will be explained in more detail later in the description.

at execution the method according to the invention At least individual structured data of the at least one Data workbooks (for example, by means of suitable verification means) in the electronic Calculator automatically checked to see that is called analyzed and recognized whether it was class data (structural Data) or instance data (concrete values). The class data of the at least one data workbook are in the electronic calculator automatically linked to a new file, namely to at least one class file. This class file can then be used as a template Creation of additional files are used, as in the further course the description even closer explained becomes.

Farther becomes at least a subset of the automatically extracted instance data of the at least one data workbook in the electronic computer automatically linked to at least one instance file. That means that like previously described extracted instance data in its own File filed and then stored, output, displayed or the like can be.

Advantageous can two or more instance files in the electronic calculator to one Total instance file combined or bundled. In this way, the individual instance files can be special easy way to check and to compare. Changes can be made particularly easy and fast detected and displayed as desired become. Examples of how such a representation of files occur can be explained in more detail later in the description.

Preferably can the extracted class data and / or the extracted instance data and / or the at least one class file and / or the at least one instance file at least temporarily stored in at least one memory means, wherein the at least one electronic computer access to the at least one storage means takes or can take. The invention is not limited to specific types of storage media. For example It may be in the storage means compared to the electronic Calculator to act an external storage means. In this case can the storage means, for example, as a (magnetic) tape, as a floppy disk, formed as a CD-ROM, as a decentralized database or the like be. It is also conceivable that the Storage means is part of the electronic computer. In this case For example, the storage means may also be a Hard drive or the like act.

Due to the at least temporary storage of data or files, historical developments of individual data or files can be detected particularly easily. Such after This may be necessary, for example, if certain developments are to be pointed out, any errors discovered or other statements made regarding historical developments. For historical information, it may be advantageous, for example, if the individual, stored data are additionally provided with a digital time stamp by the computer during the storage process. On this basis, also higher-valued functions can be realized, such as version management functions.

Also can be with the help of the method data workbooks reconstruct. If initially extracted the class file and the instance file from the data workbook can, can subsequently new instance files are generated which modify data of the class file be and the like. In this way new data workbooks can be created, that is to be "reconstructed", which subsequently in the flow of information (work flow) be incorporated.

In further embodiment can from at least one electronic computer input means automatically be generated with a number of input fields associated with class data connected become.

there can the input means on at least one of the at least one electronic computer assigned display means are at least temporarily displayed. Such a display means may be, for example, a Screen, a display or the like act. Advantageously, in the input fields attribute values are entered by the electronic Calculator automatically be converted into instance data.

at The input means is, for example, a kind of input mask. Depending on the configuration of the device on which the inventive method carried out is, the input means can be displayed in a suitable form become. The input means has a number input fields that are linked to class data. Such an input device is used to create new Instance files and / or for editing existing instance files.

to Generation of such instance files will become corresponding attribute values entered into the respective input fields. Each of the information entered is automatically linked to corresponding class data. On the base of the entered values is thus created a new instance. This instance can be stored at least temporarily, for example become.

As well it is conceivable that the Class data in the input means can be modified. So can For example, the input means are processed such that class data changed and modified, or the new class data, for example due to additional Aspects in the data workbook, about the input means are integrated into the class file.

The Input of the attribute values and / or the editing of the input means For example, by means of a suitable input device, For example, a keyboard, an interactive display or screen or the like, and the invention is not limited to those mentioned Examples limited is.

Based on the extracted class data, in particular the attribute definitions, can therefore automatically from the at least one electronic calculator an input means such as in the form of an input form for the data workbook be created, which may have been read, for example or at least one class file and at least one instance file can be reconstructed. These input means can be used to data to insert into a data workbook. By the generation of the previously described input means, for example in the form of an input mask The data workbook can be achieved that only the in the input means released input fields by the user of the method can be edited so that unintentional changes of files or data is effectively avoided. By typing the Input fields can also be an input control enabled. Furthermore, the user of the method is allowed to stand up to focus on the relevant elements of the data workbook. Furthermore Is it possible, that in the Input means individual input fields can be switched inactive. As well It may be conceivable that the Number of input fields is varied. Also, class data can be determined by means of the Input means added and / or changed become.

In further embodiment can to create a class file two or more instance files, wherein the instance files of the class file by means of the electronic Computer automatically assigned. The instance files differ in such a case, then each of their particular attribute values. The individual statements (formulas), references, and attribute definitions stay for all instance files are constant as they pass through the class file to disposal be put. The different instance files are thus, in each case to different forms of an original first instance file.

Advantageous can the attribute values entered in the input fields automatically linked with class data, in particular with instructions, the calculations given in the instructions are automatic carried out be and in the electronic calculator out of it automatically displayable file is generated. In this way, the Visualize newly created instance files and also in conventional Save form, and this can also happen automatically.

In Another embodiment may be from a class file in the electronic Calculator at least one more, based on this class file class file to be generated. This process step can be used, for example, as a kind of "derivative" (inheritance) called become. In particular, you can this way, for example, new class files are generated, the - to on well-defined changes - the structure can own like the original one Class file. It often happens that smaller changes are made to data workbooks or that data workbooks to be slightly modified to others, easily deviating conditions to be adapted. By the development of the invention of the method, it is now possible in a simple manner, such create new class files without having to recreate them completely would. The possible in this way Reuse of existing class files is similar to known as Object Oriented Programming (OOP) process.

If a data workbook was created in such a way from another data workbook is, contains it usually no functionality, the above the functionality, those in the original data workbook was included, goes out. This way, the newly generated Class file as on the original Class file based on.

Advantageous can Two or more data workbooks may be provided, at least in part linked together and form a work flow (information flow), at least individual instructions of a data workbook References to at least individual instructions of the at least one further data workbook exhibit. These are automatically extracted from the electronic calculator Class data becomes at least one class file in the form of a Linked reference information file. This means that formulas, the covers to define other workbooks, extracted and in a reference information file (also called forest file). The reference information file represents Relationships between individual data workbooks.

As well it is natural possible, that of the electronic Calculator automatically extracted instance data of the data workbooks linked to at least one reference information file.

By The creation of such reference information files will be easy Way possible, too to be able to analyze complex work flows (information flows). These Analysis can assist users of the process to understand how information through different levels of a two or more data workbooks Information flow is processed. In such a "depth analysis" of existing Structures it is important that the Information flow is traceable. As the inventive method the individual dependencies can analyze this between different data workbooks dependencies now also be presented.

To can those stored in the reference information file (s) Data from the electronic calculator automatically into one or more displayable files are converted to at least one at least associated with the electronic computer display means be shown temporarily. In such a display means can Again, for example, a display, a screen, a printer on which the file is printed or the like. there the invention is not limited to certain types of representation for the individual Data / files limited.

Advantageous can those stored in the reference information file (s) Data from the electronic calculator automatically in nodes and the references be converted between the data in edges between nodes. In doing so, instance files are beneficial in nodes, and references between Data Workbooks and / or instances advantageously converted into edges. To this Way become the dependencies between the individual data workbooks in a particularly simple way comprehensibly.

Around such a network of data workbooks or nodes and to be able to visualize edge structures, the user of the method can For example, specify which data workbook he bases on for his Wants to use analysis. Based on this information can subsequently in the electronic calculator the correct relationship between the individual Nodes and edges are calculated.

When the data stored in the reference information files is converted into nodes and edges, a kind of data tree is created. Such a data tree is general a structure that describes how information flows within a reference information file. Such a data tree does not have to be a tree in the mathematical sense because individual data workbooks can also have relationships with one another.

This should be closer to an example explained become. For example, there may be a data workbook that Scenarios generated, each scenario being in its own data workbook however, all scenarios share some parameters that are in another data workbook are stored. In this case In the mathematical sense, the tree is actually a lattice network. On In any case, it is related to practical considerations the method according to the invention easier and sufficient to speak of a tree because it is about change of each data workbook is only necessary, at the same time only to consider a level of hierarchy.

In further embodiment can Processing means may be provided via the on the display means displayed files interactively edited or edited can be. In such a case, an interactive processing of the at least a reference information file represented flow of information possible.

Advantageous can over the Input means generated or changed Instance data from the electronic computer automatically with all the instance file associated with this instance file be propagated.

There known by the method according to the invention is how individual files or data workbooks interact with each other can be related (mutually referenced), changes within a file or within a data workbook All files, or data workbooks, are forwarded with dependent data become. This process will advantageous in the form of a recursively-updated tree (recursively updated tree).

instance files of data workbooks that are generated in this way can be considered as new instance files of the same Data Workbook class file or as new versions of new instance files are saved. Because in such a case, no changed structural data (instructions and / or references and / or attribute definitions), which have been changed in such an instance file will be the information about the updates are stored in the instance files using the links (Left) for the original Class file are connected. If the automatically modified data workbook then will be published somewhere, the updated version saved. Due to the fact that the references each on the current version of the original Data Workbooks used in this process may, the process to one later Time can be traced, and results can be up to their origin traced back become.

Of the Difference to the known from the prior art solutions now that the Users of the procedure do not resend all affected data workbooks load and then must modify manually. The electronic calculator loads and updates the corresponding data workbooks on the base the previously analyzed information automatically. That means, that no temporary human activity is required to data workbooks, or files, over any size Number of hierarchy levels to update.

Advantageous can two or more data workbooks are provided, whereby from a class file, for example, with at least one instance file, and at least Reference to another class file, for example with at least one Instance file, from the electronic calculator automatically at least a new aggregation class is generated. This aggregation class can then, for example, operations based on data at least of some instance files of the corresponding class file. If the class file contains the at least one instance file Added a new instance file or an existing instance file is changed, this will affect also on the aggregation class.

Advantageous can changes in an instance file associated with a specific class file is over the electronic calculator automatically in at least one referenced with the class file further class file and / or Instance file to be made.

In further embodiment can the extracted and / or generated class files and / or instance files and / or constructed data workbooks from the electronic computer converted into displayable files and / or storable files become. For example, there is the possibility of the individual files to display about in tabular form or the like. It is the Invention is not limited to specific types of presentation.

The class files can also be displayed as a data workbook. This may be done with the inclusion of a particular instance file, but is not mandatory generally prescribed. For example, a class file represented in this manner can be graphically interactively edited, such as to generate new versions of the class file, or to modify a class file and thus create a new class, for example, in the form of a subclass. In this way, it is particularly easy to derive classes (inherit) classes in the manner described above.

Advantageous can be provided more than one electronic computer, wherein the electronic computer at least temporarily to a computer network summarized are, and where individual class files and / or instance files extracted and / or generated on different computers and / or changed and / or can be stored. In this case, you can the users of the method according to the invention in different places of the network, nevertheless the individual data, or files, at each node of the computer network extracted, created or modified become. This reduces the effort and prevents the occurrence from mistakes.

In In such a case, for example, an electronic computer be designed as a central server with which the individual users of the procedure own computers, for example personal computers, laptops or the like, communicate at least temporarily. Of course, there are other design variants the computer and / or the computer network conceivable. The communication can over it a suitable communication network, for example the Internet or the like.

In further embodiment may be changes data and / or files automatically with at least one service connected become. The invention is not limited to specific types of services. So is for example the link with a version management conceivable in the case of changes automatically printed out a corresponding message and to the corresponding user of the method is sent. It is also conceivable that with changes of data and / or files an automatic backup procedure is performed so that old ones Data, or files, always stored and at later times can still be retrieved. Likewise, a visual display is conceivable that data or files changed have been. By linking of data or file changes with such Service, it will be for everyone Users of the process can easily see what data, or files, when, by whom and in what way has been changed are.

Farther can at least individual class data and / or instances and / or class files and / or instance files as separate functional units in Form of components with one or more other program unit (s) be coupled. In this way, these components can turn into others Program applications, but also in browser applications or the like be included. Especially in the latter case it is especially easy to use the individual data and / or files to visualize the Internet or the inventive method with the help of a browser or the like on the Internet. On In this way, no special local installations are required.

According to the second Aspect of the invention is a device for data management to carry out the provided as above-described method according to the invention, with at least one electronic computer, with extraction means, using at least one data workbook with a lot of structured ones Data with dependencies at least between individual data using an extraction method automatically extracts at least one class and at least one instance is or is extractable, the class being structural information in the form of instructions and / or references and / or attribute definitions and the instance contains data in the form of attribute values, with verification means, by means of which at least individual structured data of the data workbook be automatically analyzed and recognized or analysable are and recognizable, whether it is class data or instance data and means for automatically linking at least a subset the at least one automatically extracted class data of the at least one data workbook a class file and for automatically linking at least a subset of the automatically extracted instance data of the at least one Data workbooks for at least one instance file.

By the device according to the invention is Data management in a particularly simple and reliable way possible, in which even within complicated information flows data safely and error-free generated, displayed and changed can. The benefits, effects, effects and functioning of the inventive device is based on the above statements on the method according to the invention fully incorporated by reference and hereby incorporated by reference.

Preferably can two or more electronic computers are provided, wherein the electronic computer at least temporarily to a computer network summarized are.

A Storage device for Data management programs may be characterized that the Process steps of the inventive method described above in integrated in the memory device stored program resources are. As storage device can for example, conventional Storage media may be provided, however, by the program means, respectively through the software, embody a special functionality that sets them apart from the known storage media in the particular way of the present Distinguish invention.

One Computer program product may be a computer readable program medium include, when the program is loaded, program means for execution having the method according to the invention as described above. One such a computer program product can be used, for example, by a storage device, for example, a storage device according to the invention as described above, from the Internet or the like on or in the computer or the electronic computer are loaded.

In summary can solutions are provided by the present invention that are in the Compared to the known from the prior art solutions a Have a number of advantages. So it is possible, on the one hand, through the generation of the input means an automated input as well to achieve automated further processing of these input values, which minimizes the risk of errors occurring. Furthermore, dependencies can between data and / or files and / or data workbooks and information flows particularly simple and manageable Be analyzed and visualized. The historical process of individual Instance files can be by the method according to the invention also represent. If a file or if certain Data changed will be changed automatically all data that with the changed Data or files are in a certain relationship of dependency. The individual data, files and data workbooks can be up simple and clear Be presented manner. A suitable security management can be effortlessly in the inventive method integrate.

Usually Users tend to get a variety of copies of them for a variety of reasons to make them interesting data workbooks. For example, save she made a copy for every day, for each performed Action, for every version and the like. Furthermore, individual copies, for example often sent, for example via email or the like, resulting in different copies on different Computers of individual users leads. Because of this, had to So far, a consistency between the individual copies has been maintained manually to be obtained. By the method according to the invention it is now possible, To save copies of data workbooks that are only in the instance files distinguish stored instance data. Furthermore, it is only necessary save a single copy, with changes automatically at all Copies executed become. Thus features every user over at any time the current copies of the data workbooks. Finally, one as before required distribution of copies, for example by email or the like, omitted because central to the data workbooks, for example about the Internet, can be accessed.

One The fundamental idea of the invention is that now also dependencies between various data workbooks can be extracted by the individual data within the data workbooks are analyzed. Especially can with instructions, for example in the form of formulas, in individual Classes are analyzed. Such formulas may be used as references, for example lead to a data workbook, which is accessible under a defined name and currently checked in or even to a data workbook that is currently unavailable. The term "name" refers to it not just a data or file name, but for example even on a unique combination that comes from the MAC address (a unique number that a network card from its manufacturer assigned) on a computer, to one of a user assigned name, to a position in a data system and the same. Dependent on of whether the data workbook is available or not will be the For example, reference either to an existing node set in the reference information file if the node is the same Names referenced. If this is not the case, for example, a generated so-called dummy node. If at a later date the data workbook is checked in with the name replaces the correct node the dummy node.

If a data workbook of the same name is referenced by more than one data workbook the same dummy node is used.

following Now the invention with reference to embodiments with reference closer to the enclosed drawing explained. Show it:

1 in a schematic view an invent device according to the invention for data management;

2 a schematic view in which different class files and instance files are linked together;

3 a schematic view in which an aggregate class is generated from two class files; and

4 a schematic view in which various class files and instance files are summarized in a displayable file.

In 1 is a facility 10 presented for data management, the at least one electronic computer 11 having. In 1 is for better clarity, only a single electronic calculator 11 shown. Of course, several electronic computers can be present, which are interconnected in the form of a network, at least temporarily. Such a network can, for example, have a central server which the individual users at least temporarily access, for example via the Internet.

With the device 10 For data management, the inventive method for data management can be carried out, which will be explained in more detail below. In the method according to the invention by the at least one electronic computer 11 from at least one data workbook 12 with a set of structured data with dependencies at least between individual data using an extraction method automatically extracts at least one class and one instance. In the present embodiment, the data workbook 12 structural and functional elements 13 as well as values 16 on, as shown in the top-left section of 1 is shown. The structural and functional elements 13 have, for example, a number of formulas 14 on, which are designated I, II and III. Furthermore, they have a number of attribute definitions 15 , which are designated A, B, C. With the formulas 14 these are statements while the attribute definitions 15 Statements about individual attributes 17 the instance file 16 represent. The different attributes 17 are in the embodiment with "a cross", "a triangle" and "a circle" marked.

In a first step of the procedure, indicated by the arrow with reference numeral 1 First, all the components of the data workbook 12 in the electronic calculator 11 automatically analyzed by the extraction method and recognized, whether it is in the data workbook 12 data around formulas 14 and attribute definitions 15 that is, data from a class file 13 or attribute values 17 , ie data of the instance file 16 is.

The formulas extracted in this way 14 be in a with reference number 2 linked second step to a new file, namely the class file 13 , The class file 13 can at least temporarily be stored in a storage means not shown.

In addition, in a by the reference numeral 3 marked further method step in the class file 13 stored such data containing statements on the data type, the data label and other aspects of the attribute values, such as shapes, dimensions, units of input values and the like. This information is the attribute definitions 15 ,

In a subsequent next step, the reference numeral 4 is marked, the data of the instance file 16 stored in a file. You can have multiple instance files in a single upper-instance file 18 be summarized. In the embodiment according to 1 will be in step 4 first an instance file 16 in the whole instance file 18 stored. This instance file 16 is the original instance file from the data workbook and includes the attribute values "cross", "triangle" and "circle".

In a further process step, the reference numeral 5 provided procedural step, is from the electronic calculator 11 automatically an input device 30 generated in the form of an input mask. This input device 30 can be at a suitable location of the facility 10 be displayed, for example, on a display, a screen or the like.

The input device 30 has a number of input fields 31 , in turn, with class data, for example, attribute definitions 15 from the class file 13 be automatically linked. In the present embodiment, each one of the attribute definitions 15A , B and C and, if necessary, a matching statement automatically with an input field 31 connected. In the input field 31 can be a user of the device 10 Now enter the desired attribute values. On the basis of these entered values, a new instance is then created, which is indicated by the reference numeral 6 provided arrow is shown.

In the present embodiment, this new instance file becomes 16 ' also in the whole instance file 18 stored. The instance file 16 ' shows in comparison to the original instance file 16 changed attribute values 17 ' which are represented in the present embodiment as "two crosses", "two triangles" and "two circles".

Both instance files 16 and 16 ' are based on the same class file 13 , thus differ only in the specific attribute values 17 . 17 ' ,

When the over the input means 30 inputted new instance values, the entered values are automatically updated with the class file 13 linked, which is indicated by the arrow with the reference number 7 is clarified. In this way, a displayable file, which results in a suitable display means of the device 10 For example, a display or a screen can be displayed. It is also conceivable that the file is printed on a printer or printed on other media and / or stored.

In 2 schematically illustrates a situation in which different class files with different instances are linked together. First, a first class file is shown 13 containing a number of instance files 16 , in the present case, three instance files 16 , assigned. There is also a second class file 20 with a total of three instance files 21 shown. The data workbooks with the respective class files 13 and 20 that are at least partially linked together form a work flow, whereby at least individual formulas of the class file 13 References to at least individual formulas of the at least one further data workbook or its class file 20 , exhibit. This relationship between each class file 13 . 20 is marked by a corresponding arrow. Of course, there are also relationships between individual instance files 16 . 21 , which in turn is represented by corresponding arrows between the instance files.

For example, if a particular instance file 16 leading to the class file 13 heard and in 2 with the reference number 70 is provided with an instance file 21 the class file 20 , which in the present embodiment by the reference numeral 80 is attached, when changing the instance file 70 automatically also the instance file 80 changed. In this way, when changing an instance file, it is no longer necessary to manually change each instance file referenced.

Advantageously, the user of the instance 80 automatically display which user when and in what form the instance file 70 has changed.

The individual class files 13 . 20 and / or the individual instance files 16 . 21 as well as their links among themselves can be linked to a reference information file and then displayed in a suitable manner. For example, the reference information file may be in the form of a so-called forest file, wherein the individual instance files 16 . 21 and / or class files 13 . 20 in the form of nodes and the relationships between each other in the form of edges between nodes are shown. This creates a data tree structure through which the user of the method can conveniently navigate through.

Due to the inventive design of the device 10 need the individual instance files 16 respectively 21 as well as the individual class files 13 respectively 20 not on the same electronic calculator 11 are located. For example, if the instance file is 70 and the instance file 80 on different machines, and the instance file 70 is changed, this change is automatically reflected in the instance file 80 performed. If now the calculator with the instance file 80 is not activated at the time of change, this change in the instance file 70 in the instance file 80 automatically done when the instance file 80 containing computer will be activated the next time.

In 3 is shown schematically how an aggregation class file can be created. This can be done by selecting from a class file 20 with an external reference 22 to another class file 13 , the different instance files 16 are assigned, by means of the electronic computer automatically a new aggregation class file 25 can be generated which operations based on the data of at least some instance files 16 represents. If the class file 13 for example, another instance file 16 or an existing instance file 16 is changed, this now also affects the aggregation class file 25 out. The same applies of course to instance files, the class file 20 assigned.

In 4 Finally, it shows schematically how individual instance files, which are assigned to different class files, are stored in a single overall instance file 18 can be represented. At the in 4 illustrated embodiment are again two referenced class files 13 . 20 provided, taking the class file 13 a total of three instance files 16 are assigned during the class file 20 an instance file 21 assigned. The different instance files 16 have the identification numbers (ID) a, b, c and the attributes in the form of "a cross,""atriangle," and "a circle." The instance file 21 has the Identification number (ID) d and an attribute value denoted by "two crosses".

The individual extracted and / or created instance files 16 . 21 can be converted from the electronic calculator into displayable files. In the present case, the individual instance files become 16 . 21 , or their identification numbers (ID) and contents in tabular form 40 within a single overall instance file 18 displayed. This simplifies and improves the representation of the individual instance files 16 . 21 or their identification numbers and content, as well as the traceability of dependencies considerably.

The present invention makes it possible in a simple manner, existing information flows (work flows), consisting of one or more data workbooks 12 to be able to analyze and automate. Furthermore, individual files can be easily modified, minimizing the occurrence of errors, in particular because changes to files are automatically made in those files that are referenced with the changed file. With the present invention, it is thus possible in a simple manner to manage data, or to create a data management.

1

first step

2

second step

3

third step

4

fourth step

5

fifth process step

6

sixth step

7

seventh step

10

Facility for data management

11

electronic computer

12

Data Workbook

13

class file

14

"Statement" (for example Formula)

15

attribute definition

16

instance file

17

attribute value

18

Total instance file

20

class file

21

instance file

22

external reference

25

(Aggregation) class file

30

input means

31

input box

40

displayable file

70

certain instance

80

certain instance

Claims (23)

Method for data management, in which by at least one electronic computer ( 11 ) from at least one data workbook ( 12 ) is extracted with a set of structured data with dependencies at least between individual data using an extraction method automatically at least one class and at least one instance, the class structure information in the form of instructions ( 14 ) and / or references and / or attribute definitions ( 15 ) and the instance data in the form of attribute values ( 17 ), in which at least individual structured data of the data workbook ( 12 ) from the electronic computer ( 11 ) are automatically analyzed and it is recognized whether they are class data ( 14 . 15 ) or instance data ( 17 ), in which at least a subset of the automatically extracted class data ( 14 . 15 ) of the at least one data workbook ( 12 ) in the electronic computer ( 11 ) automatically to at least one class file ( 13 ; 20 ; 25 ) and at least a subset of the automatically extracted instance data ( 17 ) of the at least one data workbook ( 12 ) in the electronic computer ( 11 ) automatically to at least one instance file ( 16 ; 21 ) is linked. Method according to Claim 1, characterized in that two or more instance files ( 16 . 21 ) in the electronic computer ( 11 ) to an overall instance file ( 18 ). Method according to Claim 1 or 2, characterized in that the extracted class data ( 14 . 15 ) and / or the extracted instance data ( 17 ) and / or the at least one class file ( 13 ; 20 ; 25 ) and / or the at least one instance file ( 16 ; 21 ) is at least temporarily stored in at least one memory means / and that the at least one electronic computer ( 11 ) Can access the at least one storage means. Method according to one of Claims 1 to 3, characterized in that at least one electronic computer ( 11 ) Input means ( 30 ) are generated automatically, with a number of input fields ( 31 ) with class data ( 14 . 15 ). Method according to Claim 4, characterized in that the input means ( 30 ) on at least one of the at least one electronic computer ( 11 ) associated with display means are at least temporarily displayed. Method according to claim 4 or 5, characterized in that in the input fields ( 31 ) Attribute values ( 17 ) entered by the electroni computer ( 11 ) are automatically converted into instance data. Method according to one of Claims 1 to 6, characterized in that a class file ( 13 ; 20 ; 25 ) two or more instance files ( 16 ; 21 ) and that the instance files ( 16 ; 21 ) of the class file ( 13 ; 20 ; 25 ) by means of the electronic computer ( 11 ) are assigned automatically. Method according to one of claims 4 to 7, characterized in that in the input fields ( 31 ) entered attribute values ( 17 ) automatically with class data ( 14 . 15 ), in particular with instructions ( 14 ), that in the instructions given calculations are performed automatically and that in the electronic computer ( 11 ) it is automatically generated a displayable and / or storable file. Method according to one of Claims 1 to 8, characterized in that from a class file ( 13 ; 20 ; 25 ) in the electronic computer ( 11 ) at least one more, on this class file ( 13 ; 20 ; 25 ) based class file is generated. Method according to one of Claims 1 to 9, characterized in that two or more data workbooks ( 12 ), which are at least partially linked to each other and which form a work flow, whereby at least individual instructions ( 14 ) of a data workbook ( 12 ) References to at least individual instructions ( 14 ) of the at least one further data workbook ( 12 ) and that these, from the electronic computer ( 11 ) automatically extracted class data ( 14 . 15 ) are linked to at least one class file in the form of a reference information file. Method according to claim 10, characterized in that the electronic computer ( 11 ) automatically extracted instance data of the workbooks ( 12 ) are linked to at least one reference information file. Method according to one of claims 10 or 11, characterized in that the data stored in the reference information file (s) is stored by the electronic computer ( 11 ) are automatically converted into one or more displayable files that are stored on at least one of the electronic computers ( 11 ) associated with display means are at least temporarily displayed. Method according to Claim 12, characterized in that the data stored in the reference information file (s) is stored by the electronic computer ( 11 ) are automatically converted into nodes and the references between the data in edges between nodes. Method according to claim 12 or 13, characterized that processing means are provided over interactively manipulates the files displayed on the display means be or can become. Method according to one of claims 10 to 14, characterized in that via the input means ( 30 ) generated or changed instance data from the electronic computer ( 11 ) are automatically propagated to all instance files associated with the resulting instance file. Method according to one of Claims 1 to 15, characterized in that two or more data workbooks ( 12 ) and that from a class file ( 20 ) with at least one reference ( 22 ) to another class file ( 13 ) from the electronic computer ( 11 ) at least one new aggregation class ( 25 ) is generated. Method according to one of Claims 1 to 16, characterized in that changes in an instance file ( 16 ) of a particular class file ( 13 ), via the electronic computer ( 11 ) automatically in at least one of the class files ( 13 ), another class file ( 20 ) and / or instance file ( 21 ). Method according to one of Claims 1 to 17, characterized in that the extracted and / or generated class files ( 13 ; 20 ; 25 ) and / or instance files ( 16 ; 21 ) and / or data workbooks constructed thereof ( 12 ) from the electronic computer ( 11 ) are converted into displayable and / or storable files. Method according to one of Claims 1 to 18, characterized in that more than one electronic computer ( 11 ) is provided that the electronic computers are at least temporarily combined to form a computer network and that individual class files ( 13 ; 20 ; 25 ) and / or instance files ( 16 ; 21 ) can be extracted and / or created and / or changed and / or stored on different computers. Method according to one of claims 1 to 19, characterized that changes data and / or files automatically with at least one service connected become. Method according to one of Claims 1 to 20, characterized in that at least individual class data and / or instances and / or class files and / or instance files are used as independent functional units in the form of components one or more other program unit (s) are coupled. Facility ( 10 ) for data management for carrying out the method according to one of claims 1 to 21, with at least one electronic computer ( 11 ), with extraction means, by means of which at least one data workbook ( 12 ) with a set of structured data with dependencies between at least individual data by means of an extraction method automatically at least one class and at least one instance is extractable, the class structure information in the form of instructions ( 14 ) and / or references and / or attribute definitions ( 15 ) and the instance data in the form of attribute values ( 17 ) contains, with checking means, by means of which at least individual structured data of the data workbook ( 12 ) are automatically analyzable and it can be determined whether they are class data ( 14 . 15 ) or instance data ( 17 ) and means for automatically associating at least a subset of the automatically extracted class data ( 14 . 15 ) of the at least one data workbook ( 12 ) to at least one class file ( 13 ; 20 ; 25 ) and at least a subset of the automatically extracted instance data ( 17 ) of the at least one data workbook ( 12 ) to at least one instance file ( 16 ; 21 ). Device according to Claim 22, characterized in that two or more electronic computers ( 11 ) and that the electronic computers ( 11 ) are at least temporarily combined to form a computer network.