WO2000010097A9 - Universal business management system and method - Google Patents
Universal business management system and methodInfo
- Publication number
- WO2000010097A9 WO2000010097A9 PCT/US1999/018679 US9918679W WO0010097A9 WO 2000010097 A9 WO2000010097 A9 WO 2000010097A9 US 9918679 W US9918679 W US 9918679W WO 0010097 A9 WO0010097 A9 WO 0010097A9
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- database
- data
- business
- user
- business language
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q10/00—Administration; Management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Definitions
- This invention relates to the field of business management systems, more particularly, to a computer system which enables business executives and managers to obtain business information, analyze business strategies, simulate business scenarios, monitor risks and forecast trends without writing any specific database or computer programs to retrieve the information in the database.
- nontechnical users were unable to structure and compose computer or database programs needed to query and analyze information stored in system databases. Instead, nontechnical users were required to communicate their requirements to technical staff, who in turn wrote database and computer programs to extract, summarize, compile, analyze and perform simulations with the requested data and format it in such a way as to be meaningful to the nontechnical user.
- Writing database or computer programs is a difficult and time intensive task which requires familiarity with database structures, mathematical functions, computer programming languages and logical operations. It also requires a detailed understanding of how data is stored in the particular database or databases being used and how this data is or can be correlated to labels and classifications understood by the nontechnical user.
- nontechnical user 15 would make a request, either verbally or in writing, to database programmer 20, that a report with certain data, analysis or simulation organized in a certain manner be generated.
- the request often identifies data needed for the report using specialized terms.
- These specialized terms are generally not the same as the terms used by the database to refer to the data. Further, the specialized terms often relate to a number of different database fields and thus a number of different database terms as well as ranges within such database fields.
- Database programmer 20 would then prepare specialized computer code 25 that would enable computer 30 to extract and analyze the correct information in an acceptable report format.
- the specialized computer code is then executed by computer 30 that generates a written (paper or electronic) report 35, using the data in the specialized databases 10, that is then delivered to the nontechnical user 15. If the report 35 requires modification or if the nontechnical user 15 requires a follow up report, the whole process is repeated.
- the present invention is a computer software and hardware system which enables nontechnical users to extract, summarize, compile, format data from a database, without writing database or computer programs. It further allows analysis and monitoring of the data and forecasting and simulation based on the data extracted from the database by the system, again without writing database or computer programs.
- data from a legacy database or databases is mapped and imported into a well structured database.
- a system template allows users to construct database and computer programs using esoteric terms and esoteric functions common in their particular industry.
- a knowledge based translator correlates the esoteric terms with the appropriate database fields, and the esoteric functions with the appropriate mathematical functions needed to perform the analysis.
- the database program generator then creates the database program for execution. Once the database program is created, it is passed to a system processor for execution.
- the system processor passes the data from the database to the template, which generates and output to the user. The user is then allowed to use programmed business tools to modify, analyze, forecast, monitor and perform simulations on the data.
- FIG. 1 is a block diagram of a prior art database system
- FIG. 2 is a block diagram showing connections of departments to databases in a prior art system
- FIG. 3 is a block diagram of a system of an embodiment of the invention.
- FIG. 4 is a diagram of a possible database structure according to an embodiment of the invention.
- FIG. 3 A system according to a preferred embodiment of the invention is shown in FIG. 3.
- the system includes one or more legacy databases 10. Data from the legacy databases is imported into a well-structured database 100 using an importation mapping 110.
- a nontechnical user inputs business data identifications 120 and one or more business functions 130 into the system using a template 140.
- the user inputs are processed by a knowledge based translator 150 which converts the business data identifications 120 and business functions into database fields and mathematical formulas. These are passed to an automated database program generator 160.
- Database program generator 160 creates an executable application that, when executed, makes database calls to well structured database 100, receives data in return and generates a report for the nontechnical user.
- the data is passed to an output generator 180, of template 140, that generates a user output from the data and from mathematical formulas from the knowledge based translator.
- Business tools 190. are provided, using specialized business language that allow the user to modify the output, perform additional analysis on the output, reformat the output, generate forecast outputs and simulations based upon the data, monitor future data appearing in the output. Since all of the business data, business functions and business tools are defined in manner understood by nontechnical users and using terms understood by the nontechnical users, the generation and modification of reports, analysis of data, monitoring of data and forecasting and simulations based on data in the database is all performed without the intervention of additional users, programmers, technicians or other people.
- the report is generated from the nontechnical business data identifications, the data in the report can be presented using these nontechnical business data identifications. This allows for modifications of the reports by the nontechnical user by manipulating the data labels or formatting, detail or other modification options.
- the legacy database contains the information which will be used in the present system.
- legacy databases are merely large data repositories.
- a single legacy database or multiple legacy databases may be employed.
- information is extracted from the legacy database or databases using flat file or database conversion transfer mechanisms, which are known in the art. However, other known methods of data transfer may be employed.
- the import mapping function is used to import data from legacy database for storage in the well structured database.
- a mapping table is first constructed correlating fields in the legacy database system with fields in the well structured database. During the importation of data some fields in the legacy database may be omitted in the well structured database. Additionally some fields in the legacy database may be duplicated in the well structured database.
- the well structured database stores the data used in the system.
- Each element of data may have numerous additional attributes, or modifying elements, called dimensions.
- an physical asset may have additional dimensions, such as: the division owning the asset (branch/department), the type of asset (home loan, construction loan, auto loan), the authority level indicating which employees may modify the record, interest sensitivity (the asset value as a function of interest fluctuation), data maturity, prepayment rate (discount or markup), and the like.
- each of the additional attributes adds a new dimension to the data element.
- the design of the well structured database is crucial to the operation of the system. In designing the database particular care must be given to various dimensions that each data element may have. As can be seen in FIG. 4, care has been given to place interest sensitive dimensions in the same columns of the database thereby allowing a set of indices to address all interest sensitive assets.
- Well structured database design is well known in the art. Two such examples include products by Oracle Corporation and Sybase. Inc.
- An additional consideration in designing the database is the granularity of the data. It is generally desirable to have the data stored in as small pieces as possible. Fore example, in the banking industry, it is usually desirable to break down balances of various accounts, interest rates, cash flows and other information on a daily basis.
- the user's input to system includes the type of data the user wishes to work with, and the function the user wishes to perform on the data.
- the user communicates using esoteric terms.
- the function When providing the function to the system the user communicates using esoteric functions.
- esoteric it is meant that the term used for the function may not be one that is conventionally understood by the general public, but is a term that is has at least a fairly well known meaning within a particular industry, business or company. This method allows users to interface with the system using language with which they are most familiar.
- the template stores the set of esoteric terms and the set of esoteric formula which the user may select for analysis.
- selection methods may be employed, such as a voice based interfaces, point-and-click graphic interface, a command line interface or any other user/computer interface that is known or is developed later.
- the user may select a single term or multiple terms as appropriate for the analysis.
- the terms vary by industry as each unique industry, such as the banking industry, has a set of esoteric terms. In the banking industry, for example, terms such as interest, assets, return on investment, and the like, may be stored. These terms, within the banking industry, have a unique meaning. Many terms also have multiple dimensions The user may then select a single formula or multiple formulas as appropriate for analysis.
- the formula vary by industry as each unique industry, such as the banking industry, has a set of esoteric formula.
- formula such as present value of money, compounding interest, early pay-off, and the like, may be stored.
- These formulas, within the banking industry have a unique meaning. Any combination of terms and formula may also be saved and retrieved by the user. This permits the user to recall past work and frequent combinations of terms and formula.
- the knowledge based translator translates the esoteric terms and esoteric functions received from the template into the appropriate database fields and mathematical formula.
- the knowledge based translator contains a translation map which correlates esoteric terms with database fields. This correlation is more then a mere one-to-one mapping, because an esoteric term may translate into several different database fields.
- the knowledge based translator contains translation maps which correlates esoteric functions into mathematical formula. This correlation is more then a mere one-to-one mapping, because an esoteric function may translate into several different mathematical formulas.
- the database program generator receives input from the knowledge based translator and creates the database program for execution.
- the database program generator determines from the database fields and mathematical formulas which data elements and dimensions are required for program generation, as well as their storage location in the well structured database.
- the database program generator then creates the database program for execution, including the instructions for retrieving the needed data from the well structured database, the operations to perform on the data, the sequence in which to perform each step of the program, and the method and manner to represent the results.
- the program requires a periodic acquisition of data from the well structured database for a monitoring function, appropriate execution loops and calls are created.
- the database program generator determines which specific elements are required, and the appropriate mathematical formulas to apply to each, the database program generator generates the program for execution.
- the actual program includes the database calls to the database and the machine code for the CPU. The program is then passed to the CPU and executed in block 170.
- the executable database application is executed in block 170.
- the data requested from the Database now associated with the esoteric, business language terms is returned to output generator 180 in template 140.
- the output generator which receives the appropriate mathematical formulas and formatting instructions according to the user Inputs of business data and business function requirements, then prepare an output to the user according to the user's request.
- the output can be presented on a display, printed or stored or transmitted in electronic form.
- Forecasts are generated by allowing the user to modify one or more variables or functions that were used to create the original output and comparing the new output with the original output. In some cases, the modification of variables or functions will result in the need to obtain more information from the database. In such cases, the additional database calls are accomplished using the same knowledge based translator system to translate between business specific terms and the structure of the well structured database.
- the monitoring function begins with a the user requesting information from the database using the template and knowledge based translator as described above. After receiving the output of the output generator, the user can then establish thresholds on any of the results of the output or any of the underlying data. The user also sets how often the threshold is checked against the database. The period between threshold checks may be any length of time, from fractions of seconds to days, weeks, months, quarters, years and beyond. Of course, since the template and knowledge based translator are used to set and execute the monitoring function, the user sets the thresholds using the same business specific terms used to create the original report.
- signals are sent out by the computer as visual, audio or electronic messages to alert the users of abnormal business activities, such as large amounts of cash being transferred, huge purchase orders placed, tremendous drops in revenue and cash reserves falling below a set requirement.
- Another feature of the output generated by the output generator is that all of the underlying granularity of the well structured database is maintained. For example, where one of the variables is time, the original report may be separated by month. But in a case where the underlying data in the well structured database is stored with daily granularity, selecting a particular month entry of item on a graph from the output generator allows the user to have the system break down the information by day or week, rather than month. Of course, granularity may be used in the other direction, such as merging months into quarters or years.
- a data map Prior to the system's operation a data map must be created by database engineers using any one of several tools which are well known in the art.
- the data map allows meaningful data to be imported into the well structured database. Once the map is created, data may be imported at regular intervals. For example, at ABC Bank, new data is imported each minute from several of the bank's legacy main frame systems and stored into the well structured database.
- a data template may be built, containing pre-determined data fields and formulas. Of course, as users create new formulas and terms, these may be saved in the template for future use also.
- a basic template is created.
- each esoteric term may actually refer to several data elements, and several dimensions of each element in combination with the selected formula.
- An increase in the Prime Rate Index for example, will only effect those assets and liabilities that are tied to that index.
- the time planning horizon i.e.
- each element may have multiple interest rate dimensions.
- the bank is only concerned about the effect the increase in the Prime Rate will have on the bank's profit in the next 30 days. Consequently, only loans, for example, whose remaining time to repricing falls within the next 30 days are interest rate sensitive.
- Each data element that has an interest rate sensitive dimension will be retrieved during the program execution. All of this information was extracted from the user by using esoteric terms which users understand.
- the user also specifies the formula to be applied to the data. In this case, the likely formula would be one of several standard "change in interest rate" formulas.
- the user would, depending on the selected formula, be prompted to input the change, which in this case would be a rise of 30 basis points. Further, the user would likely, depending again on the selected formula, be prompted to specify the number of days in which the change will occur.
- the user may be able to specify whether or not he wishes to forecast additional data, such as the rate of change (i.e. 2 basis points per day for 10 days, then 0.5 for the next 20 days).
- additional data such as the rate of change (i.e. 2 basis points per day for 10 days, then 0.5 for the next 20 days).
- Some functions utilize periodic updates of data from the well structured database for monitoring functions.
- the user selects the method of presenting the information, such as one of several predetermined graphs or the like.
- this information is passed to the knowledge based translator which begins translating the esoteric terms and esoteric functions received from the template into the appropriate database fields and mathematical formula.
- the knowledge based translator would, knowing that several other interest rates are dependent on the Prime Rate, would determine which interest rates to select. Accordingly, the knowledge based translator would use the translation map to first correlate the esoteric term "Prime Rate” with the several other dependent interest rates, and next translate those rates into the appropriate database fields.
- the formula for "change in interest rate” is first correlated to the general formula, and then converted into the actual mathematical formula.
- the database program generator receives the database fields for each of the interest rates determined and appropriate mathematical formula to apply, which includes the orders of each operation. In forming the database program, the database program generator determines which data elements need to be included. For example, a certificate of deposit (CD) may be an interest rate sensitive asset, but since the dimension is 30 days time only those CD's with a maturity data that falls within the 30 day time horizon will be included.
- CD certificate of deposit
- the banking example is also helpful in illustrating the granularity of the well-structure database.
- the report for the interest rate sensitivity problem may include entries or graph components that represent interest rate sensitive and non interest rate sensitive assets as they fluctuate over time.
- the template allow a user to select a category or item, such as interest rate sensitive assets and be presented with a list of subclasses of interest rate sensitive assets.
- the list may include short term interest rate sensitive, middle term interest rate sensitive and long term interest rate sensitive subclasses of interest rate sensitive assets.
- selecting a category like interest rate sensitive assets automatically modifies the report or graph to separate this larger class into subclasses.
- interest rate sensitive assets may have short, middle and long term interest rate sensitivity as subclasses
- long term interest rate sensitivity may have 10 year, 20 year, and 30 year term assets as sub-subclasses.
- Each of these sub-subclasses may contain further subclasses, such as branch, geographic location of the account holder, maturity date ranges, even going as far as an account by account granularity.
- embodiments of the present invention provide a database system which enables business executives and managers to obtain business information, analyze business strategies, simulate business scenarios, monitor risks and forecast trends without writing any specific database or computer programs to retrieve the information in the database or implement the analysis, simulation, forecasting and modification functions.
- the present invention may be embodied in other specific forms without departing from the spirit or attributes of the present invention.
- the invention could be implemented on a worldwide public network such as the Internet or any other network or computer system without departing from the spirit or attributes of the present invention. It is therefore desired that the described embodiments be considered in all respects as illustrative and not restrictive, reference being made to the appended claims and their equivalents rather than the foregoing description to indicate the scope of the invention.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
AU55676/99A AU5567699A (en) | 1998-08-14 | 1999-08-16 | Universal business management system and method |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US9646898P | 1998-08-14 | 1998-08-14 | |
US60/096,468 | 1998-08-14 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2000010097A1 WO2000010097A1 (en) | 2000-02-24 |
WO2000010097A9 true WO2000010097A9 (en) | 2000-07-13 |
Family
ID=22257476
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US1999/018679 WO2000010097A1 (en) | 1998-08-14 | 1999-08-16 | Universal business management system and method |
Country Status (2)
Country | Link |
---|---|
AU (1) | AU5567699A (en) |
WO (1) | WO2000010097A1 (en) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU2003240032A1 (en) | 2002-06-19 | 2004-01-06 | Goodmansoft Co., Ltd. | Automatic journalizing method and system |
GB2458309A (en) * | 2008-03-13 | 2009-09-16 | Business Partners Ltd | Search engine |
US8725487B2 (en) | 2009-08-07 | 2014-05-13 | Sas Institute, Inc. | Techniques to automatically generate simulated information |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5265244A (en) * | 1986-02-14 | 1993-11-23 | International Business Machines Corporation | Method and system for facilitating processing of statistical inquires on stored data accessible through a data access structure |
US5189608A (en) * | 1987-06-01 | 1993-02-23 | Imrs Operations, Inc. | Method and apparatus for storing and generating financial information employing user specified input and output formats |
US5544355A (en) * | 1993-06-14 | 1996-08-06 | Hewlett-Packard Company | Method and apparatus for query optimization in a relational database system having foreign functions |
US5701400A (en) * | 1995-03-08 | 1997-12-23 | Amado; Carlos Armando | Method and apparatus for applying if-then-else rules to data sets in a relational data base and generating from the results of application of said rules a database of diagnostics linked to said data sets to aid executive analysis of financial data |
-
1999
- 1999-08-16 WO PCT/US1999/018679 patent/WO2000010097A1/en active Application Filing
- 1999-08-16 AU AU55676/99A patent/AU5567699A/en not_active Abandoned
Also Published As
Publication number | Publication date |
---|---|
AU5567699A (en) | 2000-03-06 |
WO2000010097A1 (en) | 2000-02-24 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9798781B2 (en) | Strategy trees for data mining | |
US8346683B2 (en) | System, program, and method for representation, utilization, and maintenance of regulatory knowledge | |
US5414838A (en) | System for extracting historical market information with condition and attributed windows | |
CN101111835B (en) | Automated default dimension selection method within a multidimensional enterprise software system | |
US7302444B1 (en) | System for designating grid-based database reports | |
US5802493A (en) | Method and apparatus for generating a proposal response | |
DE112018002872T5 (en) | INTEGRATED SYSTEM FOR RULING, SIMULATION, VERSION CONTROL AND BUSINESS PROCESS MANAGEMENT | |
US20050055289A1 (en) | Multi-dimensional business information accounting software engine | |
KR20060122756A (en) | An intellectual property analysis and report generating system and method | |
US6959429B1 (en) | System for developing data collection software applications | |
CA2341709A1 (en) | Computer-implemented program for financial planning and advice system | |
CN114547170A (en) | Method for standardized extraction and modeling of unstructured financial statement data | |
Azis et al. | ‘Monte Carlo’Simulation Predicting on the Movement of Investments–During the Covid Pandemic in Indonesia | |
US7571107B1 (en) | System and method for externalization of rules for assessing damages | |
US7418418B2 (en) | System and method for pricing fixed income securities | |
WO2000010097A9 (en) | Universal business management system and method | |
Sakamoto et al. | Supporting business systems planning studies with the DB/DC data dictionary | |
CN112527609A (en) | Early warning information pushing method and device, electronic equipment and storage medium | |
US20050055194A1 (en) | Migration model | |
Kleijnen | Quantifying the benefits of information systems | |
CA2361206C (en) | Automated financial scenario modeling and analysis tool having an intelligent graphical user interface | |
Paul et al. | Preparing and Mining Data with Microsoft SQL Server 2000 and Analysis Services | |
SIMION et al. | APPLICATIONS FOR BUSINESSES THAT USES RELATIONAL DATABASES. | |
WO2002001393A2 (en) | Dynamic enterprise resource planning chart of accounts and methods for implementing the same | |
Royhan et al. | Systematic Literature Review Impact of RPA Implementation on Company Performance |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A1 Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A1 Designated state(s): GH GM KE LS MW SD SL SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
AK | Designated states |
Kind code of ref document: C2 Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: C2 Designated state(s): GH GM KE LS MW SD SL SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
COP | Corrected version of pamphlet |
Free format text: PAGES 1/4-4/4, DRAWINGS, REPLACED BY NEW PAGES 1/4-4/4; DUE TO LATE TRANSMITTAL BY THE RECEIVING OFFICE |
|
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
122 | Ep: pct application non-entry in european phase |