US7849108B1 - Methods and systems for establishing a database - Google Patents
Methods and systems for establishing a database Download PDFInfo
- Publication number
- US7849108B1 US7849108B1 US12/047,737 US4773708A US7849108B1 US 7849108 B1 US7849108 B1 US 7849108B1 US 4773708 A US4773708 A US 4773708A US 7849108 B1 US7849108 B1 US 7849108B1
- Authority
- US
- United States
- Prior art keywords
- data
- import
- endowment
- pooled
- fund
- 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.)
- Active, expires
Links
Images
Classifications
-
- 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
- G06F16/258—Data format conversion from or to a database
Definitions
- the present invention relates generally to methods and systems for establishing a database, such as for an endowment or pooled fund management system, and in one embodiment to a method and system whereby pooled endowment fund information can be imported from a flat-file format into a relational database utilizing a standardized spreadsheet template.
- Non-profit organizations Many charitable, non-profit and educational organizations (collectively “non-profit organizations”) are funded by endowment funds from various donors and sources. Endowment funds are those of which that are received from a donor with the restriction that the principal is not expendable. Most commonly, endowment funds are pooled together when the organization has discretion as to how the funds are invested, and when the funds have similar investment objectives.
- a unitized accounting system is an accounting system commonly used by non-profit organizations that accounts for a fund's interest in an investment pool on the basis of units. Each individual fund receives units that are proportional to the fund's share in the investment pool. A donor receives units when money is deposited into the pool. Alternately, units are reduced when money is removed.
- Non-profit organizations use unitization to accurately distribute cash income earned between the participating funds in the pool, accurately distribute changes in investment market values between the participating funds in the pool, and accurately compute the pool's investment performance. Although advantageous, unitization requires complex and burdensome calculations to very large amounts of financial data. Currently, many organizations use tedious spreadsheets to perform the unitization of pooled investment funds. The use of spreadsheets can be time-consuming and highly prone to human error.
- the unitization calculations can require processing power that will likely over-burden a non-profit organization's computing system. Accordingly, it can be very advantageous to monitor the funds, perform the calculations, and run reports using a pooled endowment management system. However, conversion from existing spreadsheet systems to the management system can be required to allow for use of such a system.
- a pooled endowment fund is comprised of vast amounts of critical data. It may comprise many funds, each with its own transaction and distribution history, balances and historical data. Manual entry of the data into a database of the management system can often lead to serious errors and may create significant problems for the pooled endowment fund. Therefore, a system and method to import pooled endowment fund data into a database that is automated and efficient is desired.
- spreadsheets many organizations use flat-files, such as spreadsheets, to perform subaccounting and administrative functions.
- the use of spreadsheets is inefficient because many records are required, and the ability to query and report data is extremely limited.
- Spreadsheets require either manual selection of the records to be reported on, or the development of individual macros for each query or report.
- Non-profit organizations differ from commercial enterprises in the types of financial reporting they are required to submit. In addition to standard financial reporting required of commercial enterprises, non-profit organizations are further burdened by strict Financial Accounting Standards Board (“FASB”) requirements that require non-profit organizations to show that they are good stewards of their endowment funds. More specifically, non-profit organizations must show that they are spending money in accordance with their own distribution rules, and also in accordance with distribution and investing rules set by individual donors. Additionally, users are required to track the financial growth of the pooled endowment funds. Spreadsheets can be difficult to use for such tracking and reporting purposes.
- FISB Financial Accounting Standards Board
- a system for establishing a database for a pooled endowment fund system includes an import template provided in a web browser program comprising a plurality of column headers, residing in a client computer and configured to accept pooled endowment data from a flat file source, a server coupled to the client computer, an import utility configured to receive the pooled endowment data from the import template, a plurality of holding tables comprising names corresponding to the plurality of column headers and a relational database.
- the import utility reads the column header in the import template and parses the pooled endowment data received from the import template according the column header by placing the pooled endowment data corresponding to an individual column into an matching holding table.
- the import utility also relates the pooled endowment data by assigning a key number to individual categories in the holding tables, eliminating duplicated categories in the holding tables and linking the key number to an endowment fund record within the relational database.
- the system allows a user to create a relational database from a flat-file, such as a spreadsheet.
- the import template is a formatted Excel spreadsheet.
- the import template may be a Lotus spreadsheet or the like.
- the template may comprise various tabs for different categorical information, such as fund, investment pool, income account, historical data gift history, and distribution data, for example. In other embodiments, all required data may reside on one tab of the spreadsheet.
- the import utility is a manual utility in which a server administrator receives and loads the import template data into the import utility.
- the import utility is automated, wherein import template data is automatically loaded into the import utility.
- a method for establishing a database for a pooled endowment fund system includes importing pooled endowment data from a flat file source into an import template provided in a web browser comprising a plurality of column headers, wherein the pooled endowment data corresponds to a plurality of endowment funds that form an endowment pool.
- the method further includes creating a plurality holding tables that correspond to the plurality of column headers of the import template and parsing the imported pooled endowment data into corresponding holding tables.
- Keys are assigned to each of a plurality of unique categories within the pooled endowment data located in the plurality of holding tables, and duplicate categories within the pooled endowment data located in the plurality of holding tables are deleted.
- the method further includes linking the keys to a pooled endowment fund record in a relational database and appending the relational database with seed data.
- FIG. 1 is a schematic illustration of an example of a flat-file to relational database conversion system for pooled endowment fund data according to one or more aspects of the present inventions
- FIG. 2 is a flow diagram illustrating an example of a method for loading pooled endowment fund data into a template, sending the template to an import utility and creating a relational database, according to one or more aspects of the present inventions;
- FIG. 3 illustrates an example of an import template, according to one or more aspects of the present inventions
- FIG. 4 is an example of a table that describes column information that may be provided in an import template, according to one or more aspects of the present inventions
- FIG. 5 is a flow diagram illustrating an example of a process in which an investment pool database is created and data is extracted, according to one or more aspects of the present inventions
- FIG. 6 is a flow diagram illustrating an example of a process in which unit values are loaded and appended to a database, according to one or more aspects of the present inventions
- FIG. 7 is a flow diagram illustrating an example of a process in which dollar values are loaded and appended to a database, according to one or more aspects of the present inventions
- FIG. 8 is a flow diagram illustrating an example of a process in which a database is configured according to one or more aspects of the present inventions
- FIG. 9 illustrates an example of an import utility user interface, according to one or more aspects of the present inventions.
- FIG. 10 illustrates an example of an import utility user interface, according to one or more aspects of the present inventions
- FIG. 11 illustrates an example of use of a mapping table for data conversion, according to one or more aspects of the present inventions.
- FIG. 12 illustrates an example of a status tab, according to one or more aspects of the present inventions.
- the system comprises a client computer 12 , which holds endowment fund data from a previous source 14 and an import template 16 .
- the system also comprises a server 20 , which is connected to the client computer 12 through the Internet or other network via a communication link 18 .
- the communication link 40 is a wired connection, such as Ethernet, for example.
- the communication link may be a wire-less technology such as Wi-Fi, Bluetooth, RF, IR, or the like.
- the network connection 60 is a wired connection, such as Ethernet.
- the server 20 further comprises an import utility 22 and a relational database 24 , which is created after running the import utility 22 .
- FIG. 2 is a flow chart providing a schematic illustration of an example of a process for loading pooled endowment fund data into a template, sending the template to an import utility and creating a relational database, according to aspects of the present inventions.
- the import template 16 in this example is a formatted spreadsheet design to be read by the import utility 22 .
- the process starts at block 32 where a user downloads the import template 16 . Downloading the import template 16 maybe effectuated using any means, including for example, e-mail, CD-ROM or Internet download.
- data is entered into the import template 16 by copying and pasting from previous source 14 , such as a flat-file spreadsheet, to the clipboard or moving data from the previous source 14 to the import template 16 . It is contemplated that other methods of entering data into the import template 16 are possible.
- FIG. 3 is a screen shot displaying an example of an import template, according to some aspects of one embodiment of the present inventions.
- the template may comprise various tabs for different categorical information, such as fund, investment pool, income account, historical data gift history, and distribution data.
- the main page of the import template 16 which may be located in the Funds tab 62 , comprises column headers such as seed data 61 , category information 63 , and account numbers 60 .
- FIG. 4 displays and describes various columns headers that may be provided in the import template 16 . In the example of FIG. 4 , the column headers are Account Number, Fund Name, and Market Value or Units.
- Seed data 61 can represent the base numerical information (market values, book values, units, and share balances) that is to be imported in the database. Descriptions of the various seed data types may be found in FIG. 4 . Seed data 61 may be used by a subaccounting application that is accessing the database as the beginning balances.
- Category information 63 can represent a group of text columns that allow the user to categorize each fund represented in the import template 16 . The user can enter the category in the appropriate cell for each fund.
- Account numbers 60 can allow the subaccounting application to read information exported from the user's general ledger system.
- Historical information, located in tab 68 can comprise a portion of the import template 16 that allows the user to import historical fund balances and transactional activity.
- the import utility 22 parses the import template data into temporary holding tables.
- the import utility 22 uses the column headers and worksheet tabs in the import template and a table map in the target database to parse the information into map information from the template into the appropriate table.
- the mapping table contains database column names and spreadsheet column named and is used to help the software map data from the spreadsheet to the appropriate place in the database. More specifically, the import utility 22 reads the column header in the import template. It then looks up the column name in the mapping table to get the appropriate table and database column to copy the information from the cell in the import template 16 to the database.
- mapping table 11 illustrates an example of use of such a mapping table according to one or more embodiments.
- the setup application reads spreadsheet columns, and the application uses the mapping table to identify the proper corresponding database column.
- the application reads a cell in the spreadsheet and writes information from the cell to the database.
- FIG. 5 is a schematic illustration of an example of how block 36 of FIG. 2 can be carried out, such as by using various SQL scripts or other programmed methods in which an investment pool database is created and data is extracted, according to one or more aspects of the present inventions.
- the data tables are cleared at block 72 , and a new investment pool relational database file is created 74 on the server at block 74 .
- the purpose of the pool, the foundation, and the endowment is extracted from the imported endowment pool data as shown at blocks 76 - 80 .
- the endowment is then appended to the new file as shown at block 82 , and the inception date entered as shown at block 84 .
- block 38 of FIG. 2 describes the step creating relational data.
- duplicated categories in the holding table are eliminated, copied to a new table, and assigned a key number.
- the category key number is linked back to the fund record.
- the import utility 22 or conversion application reads the populated import template 16 , it groups the entries into categories and makes the data relational. For example, if the word “scholarship” was listed 20 times, the import utility 22 can make one entry.
- a relational database is a database that comprises multiple tables that share a relational link with one another. Relational database are desired for large amounts of data because it is easy to query data and to generate reports based on those queries.
- database code residing on the database assists in creating new records in the database, entering data into the database, providing data upon request, and generating reports.
- Use of a relational database in such a system provides the ability to look up data and generate reports quickly and efficiently.
- seed balance entries are made.
- the user may have populated the import template with one of two forms of seed data 61 , unit balances or market values.
- unit balances or market values In certain circumstances it is preferable to import unit (or share) balances or market values.
- Shares represent proportional ownership in a pool of invested assets. Each share has a market value. The value of a fund in a pool with invested assets is the share price times the number of shares.
- Unitized accounting systems typically keep track of both dollar and share balances and maintain the relationship between the two balances.
- the import utility 22 can import shares and calculate the dollar balance or import dollar balances and calculate shares. As shown in blocks 44 and 42 of FIG.
- FIGS. 6 and 7 are schematic illustrations of SQL scripts or other programmed methods to derive either units or market values, respectively, according to one or more aspects of the present inventions.
- the example of FIG. 6 can allow for the loading of unit values.
- the method can be executed.
- the endowment history data in units is loaded into memory on the server from the import template on the client, as is the endowment investment pool data in units, as shown at blocks 92 and 94 .
- the endowment history and investment pool unit data are then appended to the relational database file on the server, as shown at blocks 96 and 98 .
- the example of FIG. 7 can allow for the loading of dollar values.
- the method can be executed.
- the endowment history data in dollars is loaded into memory on the server from the import template on the client, as is the endowment investment pool data in dollars, as shown at blocks 102 and 104 .
- the endowment history and investment pool dollar data are then appended to the relational database file on the server, as shown at blocks 106 and 108 .
- FIG. 2 block 46 , historical data such as historical fund balances and historical transactional data are loaded into the import utility 22 .
- a user may wish to add not only the seed data 61 , but also past transactions and balances.
- Historical information is loaded into the import template by selecting the Historical Data tab 68 ( FIG. 3 ) and entering in the historical data.
- the import utility then links the information back to the fund records or the newly created database.
- final configurations are made to the relational database based on the setup profile settings entered in the import utility 22 .
- FIG. 8 is a schematic illustrating scripts or other programmed code that can be utilized in loading a configuring historical data entered into the import template and profile settings selected in the import utility.
- the gift history fields are established in the relational database, and the gift data is appended to the database from the import template, as shown at blocks 112 - 114 .
- the distribution history fields are established in the relational database, and the distribution data is appended to the database from the import template, a shown at blocks 116 - 117 .
- Investment pool history fields, accounting settings and posting options can then be established in the relational database as shown at blocks 118 - 122 . Defaults can be provided for these entries.
- System settings are then updated at block 124 and the destination ID is then set in the database, as are automated distributions, as shown at blocks 126 - 128 .
- Reinvestment data is then provided from the import template to the relational database, at block 130 , and the benefactor data is extracted from the import template and linked to the corresponding data in the relational database, as shown at blocks 132 - 133 .
- Client specific reports are then cleared from the database, as shown at block 134 .
- FIG. 9 is a screen shot displaying an example of an setup utility user interface, operating according to one or more aspects of the present inventions.
- the import utility user interface allows a user to select pooled endowment attributes, such has the type of seed data (dollar or units), the start date, the fiscal year end, the posting frequency, the pricing date, the distribution model, the GL interface, when to distribute the assets and the location of the spreadsheet data file.
- the client name is entered into the client name field 140 .
- the configuration setting may be selected.
- To load dollar amounts “Dollar” is selected from the load type drop-down box 143 . If units are desired, “Units” is selected from drop-down box 143 .
- the start date of the database is entered into start date field 144 , and the fiscal year end date is entered into field 145 .
- the posting frequency which may include “Monthly,” “Quarterly” or “Yearly,” for example, is selected from posting frequency drop-down box 146 .
- the pricing date preference is selected in drop-down box 147 .
- the database version may be entered into the database version field 148 and the distribution model is selected from drop-down box 149 .
- GL interface and immediate distributions preferences are selected from check boxes 150 and 151 , respectively.
- the GL interface is used to determine whether the user interface will display the screens related to supporting custom general ledger imports and exports, and the immediate distribution check box determines whether distributable income allocations are distributed immediately or held until requested.
- the populated import template 16 is selected in file field 152 , and the template 16 is loaded by clicking the save button 153 . Clicking the close button 154 closes the import utility 22 .
- FIG. 10 is a screen shot displaying an example of an import utility user interface, operating according to one or more aspects of the present inventions.
- the information entered into the import template 16 and the import utility may be linked to a manager data file.
- the manager data file contains market value balances and profile information about the investment managers that comprise the investment pool.
- the file is selected from the manager data file field 162 , and the post date is entered into post date field 164 .
- An example user interface screen for a status tab is illustrated in FIG. 12 .
- the functionality of the routine and the other functionalities described herein can be implemented using software, firmware, and/or associated hardware for carrying out the desired tasks.
- the various functionalities described can be programmed as a series of instructions, code, files, or commands using general purpose or special purpose programming languages or programs, and can be executed on one or more general purpose or special purpose computers, processors, other control circuitry, or networks.
- the functionalities of FIGS. 5-8 could be carried out using programmed SQL scripts, for instance. Examples of such scripts that can be used to carry out such functionality are shown below, with section 1 relating to FIG. 5 , section 2 a relating to FIG. 6 , section 2 b relating to FIG. 7 , and section 3 relating to FIG. 8 .
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
Claims (16)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US12/047,737 US7849108B1 (en) | 2007-03-13 | 2008-03-13 | Methods and systems for establishing a database |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US89467807P | 2007-03-13 | 2007-03-13 | |
US12/047,737 US7849108B1 (en) | 2007-03-13 | 2008-03-13 | Methods and systems for establishing a database |
Publications (1)
Publication Number | Publication Date |
---|---|
US7849108B1 true US7849108B1 (en) | 2010-12-07 |
Family
ID=43244194
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US12/047,737 Active 2029-03-12 US7849108B1 (en) | 2007-03-13 | 2008-03-13 | Methods and systems for establishing a database |
Country Status (1)
Country | Link |
---|---|
US (1) | US7849108B1 (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120078967A1 (en) * | 2010-09-24 | 2012-03-29 | Bank Of America Corporation | Integration of a Framework Application and a Task Database |
CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件(中国)有限公司 | Method and system for data inputting |
CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
CN107436917A (en) * | 2017-06-16 | 2017-12-05 | 浙江百世技术有限公司 | One kind imports template configuration method, batch data introduction method and system |
US20190066215A1 (en) * | 2017-08-31 | 2019-02-28 | FlexFunds Ltd. | System for controlling data and issuing client reports on exchange traded products and associated method |
US11475036B1 (en) * | 2021-06-22 | 2022-10-18 | Bank Of America Corporation | Streamlined data engineering |
Citations (32)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO1993000642A1 (en) * | 1991-06-21 | 1993-01-07 | Ambit Research Limited | Data transfer and storage means |
US5293615A (en) * | 1990-11-16 | 1994-03-08 | Amada Carlos A | Point and shoot interface for linking database records to spreadsheets whereby data of a record is automatically reformatted and loaded upon issuance of a recalculation command |
US5765156A (en) | 1994-12-13 | 1998-06-09 | Microsoft Corporation | Data transfer with expanded clipboard formats |
US5819293A (en) | 1996-06-06 | 1998-10-06 | Microsoft Corporation | Automatic Spreadsheet forms |
US5819238A (en) | 1996-12-13 | 1998-10-06 | Enhanced Investment Technologies, Inc. | Apparatus and accompanying methods for automatically modifying a financial portfolio through dynamic re-weighting based on a non-constant function of current capitalization weights |
US6055541A (en) | 1997-09-19 | 2000-04-25 | Sas Ip, Inc. | Automatic report generating system |
US6161098A (en) | 1998-09-14 | 2000-12-12 | Folio (Fn), Inc. | Method and apparatus for enabling small investors with a portfolio of securities to manage taxable events within the portfolio |
US6275807B1 (en) | 1998-08-26 | 2001-08-14 | Metropolitan Life Insurance Company | Computer system and methods for management, and control of annuities and distribution of annuity payments |
US6360246B1 (en) | 1998-11-13 | 2002-03-19 | The Nasdaq Stock Market, Inc. | Report generation architecture for remotely generated data |
US6360210B1 (en) | 1999-02-12 | 2002-03-19 | Folio Trade Llc | Method and system for enabling smaller investors to manage risk in a self-managed portfolio of assets/liabilities |
US6502098B2 (en) * | 1999-09-22 | 2002-12-31 | International Business Machines Corporation | Exporting and importing of data in object-relational databases |
US6539370B1 (en) | 1998-11-13 | 2003-03-25 | International Business Machines Corporation | Dynamically generated HTML formatted reports |
US20030188256A1 (en) | 2002-03-28 | 2003-10-02 | International Business Machines Corporation | System and method in an electronic spreadsheet for copying and posting displayed elements of a range of cells |
US6631497B1 (en) * | 1999-07-19 | 2003-10-07 | International Business Machines Corporation | Binding data from data source to cells in a spreadsheet |
US20040044679A1 (en) | 2002-08-30 | 2004-03-04 | Kuo-Chin Chang | System and method for remotely generating reports |
US6721722B1 (en) | 1999-11-24 | 2004-04-13 | Unisys Corporation | Cool ice data wizard calculation service |
US20040088232A1 (en) | 2002-10-29 | 2004-05-06 | Minnis Raymond A. | Method for tracking transactions in a not-for-profit accounting system |
US20040133489A1 (en) | 2001-11-08 | 2004-07-08 | Stremler Troy D. | Philanthropy management apparatus, system, and methods of use and doing business |
US20040162775A1 (en) | 2003-02-14 | 2004-08-19 | Winklevoss Howard E. | System and method for donor-directed asset management |
US20040172584A1 (en) | 2003-02-28 | 2004-09-02 | Microsoft Corporation | Method and system for enhancing paste functionality of a computer software application |
US20050055626A1 (en) | 2000-06-21 | 2005-03-10 | Microsoft Corporation | System and method for integrated spreadsheets and word processing tables |
WO2005033980A1 (en) * | 2003-10-01 | 2005-04-14 | Schlumberger Holdings Limited | A system, a method and an apparatus for importing text data in a database |
US6898599B2 (en) | 2001-10-26 | 2005-05-24 | Sun Microsystems, Inc. | Method and system for automated web reports |
US20050114146A1 (en) | 2000-11-23 | 2005-05-26 | Joan Barkley | Commemorative donation system and method |
US20050125245A1 (en) | 2003-12-09 | 2005-06-09 | Paula Kitt | Method and system for accessing, managing and developing information regarding philanthropic organizations and donations |
WO2005065278A2 (en) * | 2003-12-24 | 2005-07-21 | Morgan Stanley | Investment database application |
US20050172241A1 (en) | 2004-01-08 | 2005-08-04 | International Business Machines Corporation | System and method for improved direct system clipboard |
US20050256791A1 (en) | 2004-05-14 | 2005-11-17 | Schaub Benson L | System and method for administering charitable funds through affiliations of professionals |
US6996589B1 (en) * | 2002-01-16 | 2006-02-07 | Convergys Cmg Utah, Inc. | System and method for database conversion |
US7194490B2 (en) * | 2001-05-22 | 2007-03-20 | Christopher Zee | Method for the assured and enduring archival of intellectual property |
US20080209444A1 (en) * | 2007-02-27 | 2008-08-28 | Garrett Andrew J | Method, system and program product for defining imports into and exports out from a database system using spread sheets by use of a control language |
US7457819B2 (en) * | 2003-10-17 | 2008-11-25 | International Business Machines Corporation | Configurable flat file data mapping to a database |
-
2008
- 2008-03-13 US US12/047,737 patent/US7849108B1/en active Active
Patent Citations (32)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5293615A (en) * | 1990-11-16 | 1994-03-08 | Amada Carlos A | Point and shoot interface for linking database records to spreadsheets whereby data of a record is automatically reformatted and loaded upon issuance of a recalculation command |
WO1993000642A1 (en) * | 1991-06-21 | 1993-01-07 | Ambit Research Limited | Data transfer and storage means |
US5765156A (en) | 1994-12-13 | 1998-06-09 | Microsoft Corporation | Data transfer with expanded clipboard formats |
US5819293A (en) | 1996-06-06 | 1998-10-06 | Microsoft Corporation | Automatic Spreadsheet forms |
US5819238A (en) | 1996-12-13 | 1998-10-06 | Enhanced Investment Technologies, Inc. | Apparatus and accompanying methods for automatically modifying a financial portfolio through dynamic re-weighting based on a non-constant function of current capitalization weights |
US6055541A (en) | 1997-09-19 | 2000-04-25 | Sas Ip, Inc. | Automatic report generating system |
US6275807B1 (en) | 1998-08-26 | 2001-08-14 | Metropolitan Life Insurance Company | Computer system and methods for management, and control of annuities and distribution of annuity payments |
US6161098A (en) | 1998-09-14 | 2000-12-12 | Folio (Fn), Inc. | Method and apparatus for enabling small investors with a portfolio of securities to manage taxable events within the portfolio |
US6360246B1 (en) | 1998-11-13 | 2002-03-19 | The Nasdaq Stock Market, Inc. | Report generation architecture for remotely generated data |
US6539370B1 (en) | 1998-11-13 | 2003-03-25 | International Business Machines Corporation | Dynamically generated HTML formatted reports |
US6360210B1 (en) | 1999-02-12 | 2002-03-19 | Folio Trade Llc | Method and system for enabling smaller investors to manage risk in a self-managed portfolio of assets/liabilities |
US6631497B1 (en) * | 1999-07-19 | 2003-10-07 | International Business Machines Corporation | Binding data from data source to cells in a spreadsheet |
US6502098B2 (en) * | 1999-09-22 | 2002-12-31 | International Business Machines Corporation | Exporting and importing of data in object-relational databases |
US6721722B1 (en) | 1999-11-24 | 2004-04-13 | Unisys Corporation | Cool ice data wizard calculation service |
US20050055626A1 (en) | 2000-06-21 | 2005-03-10 | Microsoft Corporation | System and method for integrated spreadsheets and word processing tables |
US20050114146A1 (en) | 2000-11-23 | 2005-05-26 | Joan Barkley | Commemorative donation system and method |
US7194490B2 (en) * | 2001-05-22 | 2007-03-20 | Christopher Zee | Method for the assured and enduring archival of intellectual property |
US6898599B2 (en) | 2001-10-26 | 2005-05-24 | Sun Microsystems, Inc. | Method and system for automated web reports |
US20040133489A1 (en) | 2001-11-08 | 2004-07-08 | Stremler Troy D. | Philanthropy management apparatus, system, and methods of use and doing business |
US6996589B1 (en) * | 2002-01-16 | 2006-02-07 | Convergys Cmg Utah, Inc. | System and method for database conversion |
US20030188256A1 (en) | 2002-03-28 | 2003-10-02 | International Business Machines Corporation | System and method in an electronic spreadsheet for copying and posting displayed elements of a range of cells |
US20040044679A1 (en) | 2002-08-30 | 2004-03-04 | Kuo-Chin Chang | System and method for remotely generating reports |
US20040088232A1 (en) | 2002-10-29 | 2004-05-06 | Minnis Raymond A. | Method for tracking transactions in a not-for-profit accounting system |
US20040162775A1 (en) | 2003-02-14 | 2004-08-19 | Winklevoss Howard E. | System and method for donor-directed asset management |
US20040172584A1 (en) | 2003-02-28 | 2004-09-02 | Microsoft Corporation | Method and system for enhancing paste functionality of a computer software application |
WO2005033980A1 (en) * | 2003-10-01 | 2005-04-14 | Schlumberger Holdings Limited | A system, a method and an apparatus for importing text data in a database |
US7457819B2 (en) * | 2003-10-17 | 2008-11-25 | International Business Machines Corporation | Configurable flat file data mapping to a database |
US20050125245A1 (en) | 2003-12-09 | 2005-06-09 | Paula Kitt | Method and system for accessing, managing and developing information regarding philanthropic organizations and donations |
WO2005065278A2 (en) * | 2003-12-24 | 2005-07-21 | Morgan Stanley | Investment database application |
US20050172241A1 (en) | 2004-01-08 | 2005-08-04 | International Business Machines Corporation | System and method for improved direct system clipboard |
US20050256791A1 (en) | 2004-05-14 | 2005-11-17 | Schaub Benson L | System and method for administering charitable funds through affiliations of professionals |
US20080209444A1 (en) * | 2007-02-27 | 2008-08-28 | Garrett Andrew J | Method, system and program product for defining imports into and exports out from a database system using spread sheets by use of a control language |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120078967A1 (en) * | 2010-09-24 | 2012-03-29 | Bank Of America Corporation | Integration of a Framework Application and a Task Database |
CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件(中国)有限公司 | Method and system for data inputting |
CN103995908A (en) * | 2014-06-17 | 2014-08-20 | 山东中创软件工程股份有限公司 | Method and device for importing data |
CN107436917A (en) * | 2017-06-16 | 2017-12-05 | 浙江百世技术有限公司 | One kind imports template configuration method, batch data introduction method and system |
US20190066215A1 (en) * | 2017-08-31 | 2019-02-28 | FlexFunds Ltd. | System for controlling data and issuing client reports on exchange traded products and associated method |
US11475036B1 (en) * | 2021-06-22 | 2022-10-18 | Bank Of America Corporation | Streamlined data engineering |
US11755613B2 (en) | 2021-06-22 | 2023-09-12 | Bank Of America Corporation | Streamlined data engineering |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8788412B1 (en) | System and method for tax filing, data processing, data verification and reconciliation | |
US8065219B2 (en) | System architecture and method for energy industry trading and transaction management | |
US20070239508A1 (en) | Report management system | |
US11587185B2 (en) | Accounting platform functionalities | |
US7849108B1 (en) | Methods and systems for establishing a database | |
US20020184133A1 (en) | Method and system for verifying the integrity of data in a data warehouse and applying warehoused data to a plurality of predefined analysis models | |
AU2003208845B2 (en) | Method, software application and system for exchanging benchmark data | |
US7987209B2 (en) | Enhanced trade compliance system: mass amendment | |
CN109785106A (en) | A kind of ERP system account checking method | |
CN110046337A (en) | A kind of financial data acquisition method and its system | |
US20050240630A1 (en) | System and method for exporting formatted transactional data from a database system | |
US20090187496A1 (en) | Data workbench for accounting data management | |
CN107316245A (en) | Expense adjusts method and system | |
US20230418563A1 (en) | Dynamic application builder for multidimensional database environments | |
US20140052653A1 (en) | System And Method For Completing, Validating And Submitting Regulatory Forms | |
CN112581266A (en) | Bank liquidity index determining method and device, electronic equipment and storage medium | |
US20050010575A1 (en) | Transactional processing system | |
US9286567B1 (en) | Systems, methods and articles for providing support information for a software application | |
US7653587B2 (en) | Automated account statement generation process | |
WO1996030850A1 (en) | Method of and system for determining and assessing credit risks | |
US12039614B2 (en) | Generic configuration platform for generating electronic reports | |
US8386372B2 (en) | System, method and computer program product for compiling golden copy of securities pricing | |
KR102021012B1 (en) | Method for providing transfer income tax auto calculating service for tax payement of major shareholder's stock trading | |
Iordache et al. | USING THE ENTERPRISE RESOURCES PLANNING SOFTWARE AS A SAAS IN THE DIGITAL ECONOMY-A CASE STUDY ON ODOO SOFTWARE | |
REDDY et al. | Development of an SAP-based business warehouse |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: FUNDRIVER, INC., OHIO Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:KAPOR, STEVEN;REEL/FRAME:020970/0860 Effective date: 20080321 |
|
STCF | Information on status: patent grant |
Free format text: PATENTED CASE |
|
FPAY | Fee payment |
Year of fee payment: 4 |
|
MAFP | Maintenance fee payment |
Free format text: PAYMENT OF MAINTENANCE FEE, 8TH YR, SMALL ENTITY (ORIGINAL EVENT CODE: M2552) Year of fee payment: 8 |
|
FEPP | Fee payment procedure |
Free format text: 11.5 YR SURCHARGE- LATE PMT W/IN 6 MO, SMALL ENTITY (ORIGINAL EVENT CODE: M2556); ENTITY STATUS OF PATENT OWNER: SMALL ENTITY |
|
MAFP | Maintenance fee payment |
Free format text: PAYMENT OF MAINTENANCE FEE, 12TH YR, SMALL ENTITY (ORIGINAL EVENT CODE: M2553); ENTITY STATUS OF PATENT OWNER: SMALL ENTITY Year of fee payment: 12 |
|
AS | Assignment |
Owner name: WEBSTER BANK, NATIONAL ASSOCIATION, CONNECTICUT Free format text: SECURITY INTEREST;ASSIGNOR:FUNDRIVER, LLC;REEL/FRAME:061805/0427 Effective date: 20221116 |