AU2006201140A1 - Apparatus and methods for interactive rental information retrieval and management - Google Patents

Description

AUSTRALIA

Patents Act 1990 COMPLETE SPECIFICATION STANDARD PATENT Applicant: ARAC MANAGEMENT SERVICES, INC Invention Title: APPARATUS AND METHODS FOR INTERACTIVE RENTAL INFORMATION RETRIEVAL AND MANAGEMENT The following statement is a full description of this invention, including the best method of performing it known to me/us: -2- APPARATUS AND METHODS FOR INTERACTIVE RENTAL INFORMATION RETRIEVAL AND MANAGEMENT Related Application This application is divided from and claims the priority of Australian application no.

2001243478 filed 7 March 2001, the content of which is incorporated herein by reference in its entirety.

Field of the Invention This invention relates to rental data analysis and more specifically to extracting and analyzing rental information at various levels of detail.

Background of the Invention In the vehicle rental industry, most if not all of the companies, particularly the larger companies, have databases for taking and storing reservations and rentals, as well as the other parameters associated with a vehicle rental transaction. Typically, these parameters would include among others: 1) the name of the vehicle renter, as well as home and business addresses to complete a profile on each vehicle renter; 2) an unique identification of the rented vehicle; 3) the rental charge; 4) the beginning and ending dates of a vehicle rental in terms of the day in the month and the week day that a particular vehicle was rented; 5) the miles that a rental vehicle was driven; 6) the location from which the vehicle was rented in terms of street address, city, state or province and country; 7) the location to which the vehicle was returned; and 8) any upgrade that was given and the kind. These parameters would be kept for all vehicle rentals. If the vehicle renter is an employee of a company, the retained parameters may also include the name and address of the employer/company.

Such reservation and rental databases have been maintained and used by the vehicle rental companies for servicing and tracking vehicle rental transactions. Access to such databases has typically been limited to the vehicle rental company employees. The potential use of this data as a management tool by vehicle renters and their employers, travel agencies, consortiums, tour operators and associations has been ignored. The vehicle renter and their employers receive documents and are aware of the charges they have paid, but are not aware of how their companies, employees, or customers have used these vehicle rental services. It would be of significant benefit to the companies if they had a management tool that would facilitate its analysis of this data and generate a variety of reports that would indicate whether their vehicle rental expenditures were -3well used. Often there are problems of personal use or misuse of vehicle rentals, or perhaps even fraud on the company. Large companies have travel managers whose job it is to keep track and analyze their company's use of vehicle rentals to ensure that there is no fraud on the company, to minimize such cost to the company, and to ensure the most efficient use of vehicle rentals to meet the goals of the company. No one report or even a small number of reports can meet these needs of a company's vehicle rental manager. Further, these needs change as the business of a company changes and grows.

A travel manager may need a certain set of reports for a period of time, and then as the business changes or a new need is recognized, will want to secure a different set of reports.

Any system developed to store and to process the above described vehicle rental data would need to be flexible. As noted, the real and perceived needs of one company will change over time, thereby requiring that a database management system be flexible, particularly in terms of the parameters to be collected and the reports it can generate.

Further, the needs of one company in terms of the reports needed will differ from those of another company. Therefore, a vehicle rental database system must be able to provide data in a format or a report that will meet the needs of a wide variety of users, whether large companies, private individuals, or associations.

In the advent of wide area networks (WANS) such as the Internet, databases including those dedicated to storing vehicle rental data may be readily and inexpensively accessed from any place in the world. These databases may be accessed not only by the travel managers of large and small companies as suggested above, but also by a wide variety of other people. Individual vehicle renters would have the need to access data from such databases. Employees of the vehicle rental companies would need to use such databases for a wide variety of purposes. Data could be gathered about one or a selected number of companies, about rentals at selected vehicle locations within one geographic unit, the United States, or a number of selected geographic units, the United States, Canada and Mexico, or about selected of their customers, whether companies or individuals. In addition to vehicle rental companies and their corporate customers, other users such as travel agents could access the contemplated database system and obtain needed information. Available WANS can readily facilitate access by the people noted above and others to access the flexible vehicle rental database system of this invention.

Summary of the Invention In a first broad aspect, there is provided a method of extracting rental information from -4a database and analyzing the extracted rental information, said rental information relating to at least first and second parameters, said first parameter including at least first and second levels of detail, said first level of detail corresponding to the finest level of detail, said method comprising the steps of: a) constructing at least first and second tables, said first and second tables including pluralities of first and second rows respectively, each first row comprises at least a first parameter and each second row comprises a second parameter, said first and second parameters defining different attributes of the rental transaction; b) combining one of said plurality of first rows and one of said plurality of second rows to form a summary record; c) accessing each of said summary records with said first parameter to a selected one of said first and second levels of detail; and d) summing said second parameters of said accessed summary records to provide a summed indication of said second parameter to said first level of detail.

In an illustrated embodiment of this invention, the first parameter defines the geographic division of the rental location, and the second parameter defines the expenditure involved in the rental transaction. The geographic division of said first level is relatively smaller than the geographic division of the second level. The geographic divisions include selected of street addresses, cities, states, provinces, countries and combinations of countries. The second parameter may comprise selected of expenditures involved in the rental transaction, the method of payment, the duration of the rental, the date of the rental and the employer of the renter.

In a further aspect of this invention, each of the first and second files are constructed with a third parameter. Then, the third parameter of one of the first files is compared with the third parameter of one of the second files. If there is a match, the first and second files are combined to form the summary record. The third parameter comprises an ID uniquely identifying one of the plurality of the rental locations.

In a further aspect of this invention, a method of constructing and managing a database is described to permit an employer of employee renters, travel agents, associations of members or travel agency or tour operators of customers to analyze vehicle transaction information. The method comprises the steps of inputting to the database a plurality of files. Each file defines a vehicle rental transaction and includes a parameter indicative of the vehicle rental location in terms of a plurality of geographical divisions of different granularity and a parameter indicative of an attribute of its vehicle rental transaction. Next, the organization is permitted to select the granularity of the geographic division and to identify the vehicle rental transactions originating from the geographic division of selected granularity. The parameter is collected from all of the identified vehicle rental transactions to provide an indication of the collected parameter from all of the rental locations within the geographic divisions of the selected granularity.

In a further aspect of this invention, the organization selects a geographic division of a different granularity, before the parameter is collected from all of the identified vehicle transactions with the geographic division of the different granularity. The parameter may be selected from a group comprising expenditures, the day of the vehicle rental, the manner of payment and the miles that the vehicle was driven diing the vehicle rental.

In a further feature of this invention, each file includes a second parameter that indicates the date of the vehicle rental transaction. Further, a period to time is set as to the vehicle rental transactions of interest. The identified vehicle rental transactions are collected from those files with a second parameter that falls within the set period of time.

In a still further aspect of this invention, there is disclosed a method of constructing and accessing a database of vehicle rental information related to a plurality of employers and their employees, association of their members or travel agencies/tour operators of their customers, wherein at least one organization has an organization comprised of a plurality of divisions. The method comprises the steps of assigning to each vehicle renter an ID indicating the renter's affiliated organization and division, and constructing and inputting into a database a file for each vehicle rental transaction. Each file comprises the assigned ID of the vehicle renter involved in the vehicle rental transaction. Each organization is permissioned to access the database for only those files that includes an ID that matches the organization seeking access. Then, each permissioned organization selects the entire organization or division of interest, whereby data is collected from the files of the employees or customers assigned to the selected entire organization or division. Each file is constructed to include at least one parameter indicative of an attribute of the file's vehicle rental transaction, before the permissioned organization is permitted to select a different division or entire organization and collect the parameter from each of the files of the employee or customer assigned to the different division or entire organization. The parameter may be selected from a group comprising expenditures, the day of the vehicle rental, the manner of payment, and the miles that the vehicle was driven during the vehicle rental.

-6- In a still further aspect of this invention, each file is constructed to include a plurality of parameters, which are indicative of different attributes of the file's vehicle rental transaction. The organization is enabled to select any combination of the plurality of the parameters and to generate a report of the data corresponding to the selected combination of parameters from the files of the employees or customers assigned to the selected division or entire organization.

In a further embodiment of this invention, at least one organization has an organization comprised further of a plurality of subdivisions. The organization is permitted to select a different one of the entire organization, division or subdivision, and collect the parameters from the files of the employee or customer assigned to the different entire organization, division or subdivision.

In a further aspect, there is provided a method of managing data related to transactions, wherein a single supplier is a party to each of the transactions, said method comprising the steps of: a) inputting a plurality of files of the data related to transactions involving the single supplier, the inputted data having field names and characteristics define by parameters; b) storing the inputted data files without substantial transformation into a first set of tables, the tables of the first set having the field names that match the field names of the inputted data files; and c) mapping the inputted data to be stored in a second set of tables, whereby the second set of table are structured in a manner to store the mapped data such that it may be accessed by one or more parameters which relate to a corresponding characteristic of the inputted data of the single supplier.

In a further aspect, there is provided a system for managing data related to transactions and facilitating at least one user to access data, wherein the data has one or more characteristics defined by corresponding parameters and a single supplier is a party to each of the transactions, said system comprising: a) a memory structured to store the data in a format adapted to be accessed and searched by the one user; b) a server memory programmed to receive and to map files of data of different formats into a common format compatible with the data format of the memory; and -7c) a network server coupled to a network to permit the one user to select and use one or more of the plurality of parameters to search the memory and to access its data that corresponds to the selected one or more parameters, each of which defines at least one characteristic of the transactions.

Brief Description of the Drawing In order that the invention may be more clearly ascertained, preferred embodiments will now be described, by way of example, with reference to the accompanying drawing, in which: Figure 1 is a network topology diagram showing how the various physical parts of a system according to an embodiment of the present invention are interconnected with each other; Figure 2 is a diagram showing how the various internal components of the computing device of the system of figure 1 are interconnected with each other; Figure 3 is a data flow diagram, showing progression of data updates from an external source to the central database of the system of figure 1; Figures 4a to 4f are data layout diagrams showing fields comprising external source files entering the system of figure 1; Figures 5a to 5e are data layout diagrams showing fields comprising four component groupings of the data of the central database of the system of figure 1; Figure 6 is a list of records of exemplary data of some components of the central database of the system of figure 1; Figures 7a and 7b are a flow diagram of a key setting component of the data management process of an embodiment of the present invention, which determines the granularity of information displayed; Figure 8 is a flow diagram of logical steps undertaken according to an embodiment of the present invention to generate a selected one of a plurality of reports; and Figures 9a to 9i illustrate variously the screens that are displayed to an user in the course of effecting the report generation processes shown in Figures 7a, 7b and 8.

Detailed Description of Preferred Embodiments The present invention provides apparatus and a method for managing rental information received from any outside source. The data received is diverse raw data conforming to the formats which will be described below. Even if these incoming sources and their formats may change, the historical information collected and managed on the inventive -8apparatus will not be affected.

The inventive system may utilize in one illustrative embodiment of this invention the components shown in Figure 1 to enable users of the invention to access information related to rentals and, in particular to vehicle rentals, via a network, which in the preferred embodiment of this invention is the Internet. However other connectivity, e.g., via a modem in a point to point connection or networks other than Internet are within the contemplation of this invention. The system comprises one or more computing devices 12, which are used as a database server for managing data storage and retrieval for reporting database 13, one or more computing devices 14 for executing report generating and analysis processing, one or more computing devices 16 used for scalability and redundancy in connecting to the Internet 10, and one or more computing devices 18 used for load balancing to insure scalability of the inventive apparatus. A plurality of firewalls 20 to protect the infrastructure from unauthorized access may also be included. Further, a plurality of user terminals 22a-n are connected throughout the Internet 10 to permit users to access the reporting database 13 and to analyze the rental data stored therein in a manner as will be described below.

The computing devices 12,14,16, and 18, and the user terminals 22 may illustratively take the configuration of any computer ranging from mainframes to personal computers (PCs). In one illustrative embodiment of this invention as shown in Figure 2, such computing devices and terminals may comprise a bus 30, which is connected directly to each of the following: 1. a central processing unit (CPU) 32; 2. a memory 34; 3. a system clock 36; 4. a peripheral interface 38; a video interface 6. an input/output(I/O) interface 42; 7. a communications interface 44; and 8. a multimedia interface 46.

The common bus 30 is further connected 9. by the video interface 40 to a display by the 11O interface 42 to a storage device 52, which may illustratively take the form of memory gates, disks, diskettes, compact disks digital video disks (DVD), etc.; 11. by the multimedia interface 46 to any multimedia component 56; 9 12. by a peripheral interface 38 to the peripherals 58, such as the keyboard, the mouse, navigational buttons, on a digital phone, a touch screen, and/or a writing screen on full size and hand held devices, a palm pilotTM; 13. by the communications interface 44, a plurality of modems, to a network connection 60, an Intemrnet Service Provider (ISP), and to other services, which is in turn connected to the network 10, whereby a data path is provided between the network 10 and the computing devices 12, 14,16, and 18 (Figure 1) and, in particular, the common bus 30 of these computing devices; and 14. furthermore, by the communications interface 44 to a wired and/or a wireless telephone system 54.

Figure 3 shows the initial creation and/or daily/weekly/monthlybuilding of a set of interactive data warehouse tables in the reporting database 13 as will be explained below with respect to Figure 5. The design and creation of the reporting database 13 is intended to provide enhanced reporting features and capabilities for analysis purposes.

Many of these features are built into the architecture of the database 13 and include: 1. Building of transaction summary tables 74 (Figure 5) to facilitate the quick generation of summary reports.

2. Ability to retain data for a time period longer than the period of retention provided in the source system.

3. Strategic use of controlled redundancy to increase performance of the interactive system and to simplify its use.

4. Indexing designed specifically to facilitate the reporting process.

Reporting naming standards developed to ensure consistency across the database 13.

The system receives data files 62 which include transactional data, renter, location, organization, currency, country and pander information. These data files 62 may come directly from rental outlets after individual transaction are executed, from a reservations facility where records of reservations are kept. In a preferred embodiment of this invention, daily transactions are stored in central or distributed databases, which comprise the data noted in the background, and from which the data files 62 may be built and transmitted to the system and apparatus of this invention. It is appreciated that the preferred central distributed databases of this invention are essentially similar to those of the large vehicle rental companies, Hertz, Budget, Dollar, etc., and that data files from their databases could be readily processed by the method and apparatus of this invention without departing from the scope of this invention. The record layout of six of the data files 62 is shown in Figures 4a-4c. In the present illustrative embodiments, there are six files 62a to 62f, each comprising a similar header record 62g. These files provide the following information: 1. Country codes tables 62a; 2. Detailed information for the individual rental transaction table 62b; 3. Currency conversion rates (both current and historical) tables 62c; 4. The pander file used to exclude individual renters from the lists of individual renter profiles produced for the corporate customers' table 62d; 5. Information about the individual rental locations table 62e; 6. Information about the individual renters table 62f, where each renter is identified by a unique number; and 7. Information about a table 62g containing company profiles of corporate customers (including associations and tour operators), where each organization is identified by a unique Worldwide Discount (AWD) number.

Returning now to Figure 3, data files 62 are loaded into a work tables database 64, where the data record column names and sizes match those in the data files 62. In other words, the data files 62 are loaded into the work tables database 64 without any transformation. The received data is scrubbed, validated, and transformed into a staging tables database 66, where the data record column names and data types are identical to the interactive data warehouse tables, which are constructed in the reporting database 13. The data from the staging tables database 66 is then transferred and added to the reporting database 13.

The process of data transfer from the data files 62 into the reporting database 13 effectively transforms six variously formatted record collections 62a-62f into four groups or warehouse tables 13a-13d of interactive data shown in Figures 5a to 5e. Each of the main categories of tables 13a-13d within the reporting database 13 is briefly described below.

1. The core data tables 13a comprise information central to the rental business. This information is usually used across applications due to its fundamental importance to the business. Examples include information about organizations, individuals, and locations, such as the following: a. table 13al of information about the individual renter; b. table 13a2 of information about the individual rental locations; 11 c. table 13a4 contains the current assignment of Sales Territory Codes (STC) to organization accounts (STC is used to assign particular geographic areas to the sales staff. For example, a regional head of the sales department for the US northeast may be assigned the code of 400000. That person will e allowed to see all of the transactions with the codes 400199 to 409999. The head of a New York division is assigned an STC of 400100. That person will be able to access all records or transactions with the codes 400100 to 409999); d. table 13a5 of organization profiles of corporate, association or tour operator customers; e. table 13a6 of information used to exclude individual renter profiles from the employee/renter profile lists.

2. The transaction data tables 13b comprise business events, rental transactions that are incurred by core data instances, organizations and individuals. The transaction data tables 13b includes a table 13bl comprising the most frequently accessed detail information for individual rental transactions, identity of renter, dates of rental, rental check-out and check-in locations, miles driven, rates charged, etc., and a table 13b2 comprising additional detail information for individual rental transactions, e.g., renter address, driver's license number, etc.

3. The summary data tables 13c comprise a pre-summarized view of transactional data.

These tables are primarily built to provide increased performance when the data is being presented at a high to intermediate level. The tables include the following: a. summary_car group table 13cl for summarizing numbers of the rentals reserved, charged and rented using an AWD, the check-out location of each rental, the month/year of each rental and the car or vehicle group of each rental b. summary_client table 13c2 for summarizing rental activity according to its AWD, check-out location and month/year of occurrence c. summaryday of week table 13c2 for summarizing number of rentals according to its AWD, check-out location, and month/year and day of the week of its occurrence d. summary_geographic expenditures table 13c4 for summarizing number of rentals, expenditures and distance travelled (miles or kilometres) according to its AWD, check-out location, check-in location, and month/year of occurrence e. summary_methodofpayment table 13c5 for summarizing rental activity using the AWD, check-out location, month/year and method of payment f. reservationorigin_table 13c6 for summarizing rental activity according to its 12 AWD, check-out location, month/year of occurrence and source of reservation (booking source) 4. The reference data tables 13d are also commonly known as "code" tables. These tables provide the ability to convert code values into descriptive phrases to make the data more informative; they include the following: a. cargroup_code table 13dl; b. country_code table 13d2; c. currency_conversion table 13d3; d. distancecode table 13d4; e. state_province_abbreviation f. methodof paymentcode table 13d6; g. method_ofpayment_ctgy_code table 13d7; h. booking_source_code table 13d8; i. booking_source_category_code table 13d9; and j. interational_source_division_code Figure 6a shows a table of the relationships between the input or source data files 62 (Figure 3) and the various groupings of data in the recording database 13 (Figure In Figure 6a, the data files are disposed as the columns of the table, whereas the data groupings are disposed as the rows.

The x at the intersection of a column/row pair indicates that data from a particular source data file 62 (Figure 3) populates a particular table of the reporting database 13 (Figure For example, the data from the cdbpnd input file 62d is used to populate or is added to the pander table 13a6. Moreover, formerly created tables, the rental table 13bl, may populate the summary tables like 13cl, 13c3 and 13c4. The reference tables 13d (Figure 5) may be manually populated at column 70. Figure 6b shows samples of representative data of some of the created tables of the reporting database 13 (Figure Namely, shown are a summary geographic expenditures table 13c3, a location table 13a2 and an organization table 13a5.

The identity of data is kept for historical purposes, even though such data may have been deleted from the source and the source identifier reused to identify different data.

This is achieved through the use of surrogate keys assigned in the reporting database 13 (Figure These surrogate keys are the identifiers referenced in the table descriptions that follow. For example, a location in the source file 62 (Figure 3) has a location 13 number code of"123". When this location is loaded to the interactive reporting database 13 (Figure it is assigned a unique location ID. If this location is deleted from the source system, the rental company is sold or consolidated, it will be flagged as deleted from the source data 62 (Figure 3) in the interactive reporting database 13 (Figure If the location number "123" is later reused on the source system for a new location, in a different part of the country, it will be assigned its own unique location ID, when it is loaded to the interactive reporting database 13 (Figure In this way, it is possible to maintain the history for each use of the location

ID.

Returning once again to Figure 3, the data loaded in the reporting database 13 is scrubbed, validated and transformed by program units stored inthe reporting database 13. A code generator developed for this invention used the mapping document to generate 90% of the code for the stored program units. In addition to reducing the time necessary to collect information and to generate reports, the generated code is highly accurate.

Some actual data from the mapping document is presented in Table 1.

TARGET TABLE TARGET COL SOURCE TABLE/COL rental t booking dt samdtl a.booking-date rental t booking tm samdtl a.booking-time Table 1.

For each of the two samples in Table 1, the code generator produced a line of code which calls a special routine that transfers the data from the target table 62b (Figure 4), the column samdtlla.booking-date 62bl (Figure 4) and the samdtlla.booking-time 62b2 (Figure 4) to the target database transaction table 13b at columns rental_t.booking_dt 13bla (Figure 5) and rental_t.booking_tm 13blb (Figure The code generation relied on a complete and accurate mapping document, the field names or work table 64 columns named in accordance with the column or field names of the input source data 62, and on the stage table 66 column names being the same as the database target column names.

Data Analysis The data analysis aspect of this invention allows a user to review and analyze a large 14 number of parameters related to the rental transactions, that include at least those listed above. In a preferred embodiment of this invention, the Internet connects a wide variety of users to the reporting database 13. These users may include for example the renter, a vehicle renter, the managers of the rental company, the managers of the company whose employees rent and the brokers such as travel agents who take reservations directly from the renters and place the orders for such rentals. The users may review a significant number of the parameters that relate to the rental transactions. For example, these parameters may include the total expenditures, the number of rentals, the percent of worldwide rentals, the rental days, the average distance in miles or kilometres that the rental vehicle or car is driven per day, the average distance driven per rental, and the average length of rentals. The user may choose to view the expenditures in various world currencies. Distance figures travelled by particular vehicle renters may be viewed in either kilometres or miles. The user may choose the date range to view the data, e.g.

January 1999 through December 1999. The historical data may be maintained indefinitely.

To begin requesting the rental information, the user may use any of the user terminals 22a-n, whose structure was described with reference to Figure 2, and any commercially available web browser, such as the Microsoft Explorer and the Netscape Navigator, to establish a data path via the Internet 10 to one of the user terminals 22a-n. After establishing a data path, the user may be authenticated and allowed to request any pertinent information found on the reporting database 13 (Figure The authentication of users may be achieved by any of a number of well known techniques familiar to these skilled in the art.

As will now be explained with respect to Figures 7a and b, the user may request selected information about and summary reports of selected parameters of the rental transactions. In the particular embodiment of this invention that will be described below, the rental transactions are vehicle rentals. In this embodiment, the processing illustratively includes a geographic explorer and an AWD explorer. Generally, these explorers permit the user to analyze or "drill down" to different layers of information, each lower level presenting more detailed information.

The geographic explorer has application to at least one embodiment of this invention, wherein the rental company has a large number of rental locations distributed in a number of countries through out the world. In each typical country, the vehicle rental locations are found in a number of states or provinces, a number of cites in each state or 15 province, and a plurality of street locations in certain ones of the cities. The geographic explorer permits, as will be explained below, the user to access or "drill down" to each of these geographic levels and to collect or sum data related to selected rental vehicle parameters at that particular level. For example, an user has the option of collecting in the following illustrative embodiment data at the following geographical levels: 1) worldwide, 2) country groups, 3) countries, 4) states or provinces, 5) cities, and 6) street locations.

The "AWD" explorer is used in that embodiment of the invention, where the user's employer/company is structured into divisions at various levels. The organization is divided at a first level into its largest divisions. In turn, each of these largest divisions may be further divided into sub divisions or sections at a secon4jevel. Further subdividing the organization structure into lower or smaller units is also contemplated by this invention. In a manner similar to that of the geographic explorer, the "AWD" explorer is capable of accessing or "drilling" down to data related to various levels of the renter's corporate structure. The "AWD" explorer is used extensively through out the user's terminal 22 to aid the user in selecting the organizational unit that is identified by its "AWD" number or ID that the user is interested in viewing data for. The "AWD" identifies that portion of the user's organization (the whole company, a division, or a sub-division). The "AWD" explorer looks at the user's security profile and allows the user to view only the "AWD" numbers that the user is authorized to view. The "AWD" explorer displays the hierarchy of the "AWD" numbers.

Referring now to Figure 7a, the data analysis process starts in step 104, which downloads from the reporting database 13 via the Internet 10 to one of the user terminals 22a-n as shown in Figure 2, a screen 170 as shown in Figure 9a to be presented on the user's display 50. Screen 170 and the others to be so displayed to the user, permit the user to select and analyze the rental data. The user clicks on an "AWD" explorer link 172, which effects the display in step 106 of a screen 178 as shown in Figure 9b. The screen 178 includes a block 180, in which the user may enter his/her "AWD" number or organization name, which in turn causes the display of a first set of links bearing the respective names of the divisions of the renter's employer at a first level, only one of which is identified in Figure 9b by the numeral 182a. Figure 9b also shows a second set of links bearing respectively the names of a plurality of subdivisions 182b-g at a second lower level. The user may then click on a selected one of the links 182a-g to "drill down" and to access data of a corresponding division at the first level or to data of a section at the second level.

16- Responding to the selection of a particular division or section of the company, the process displays in step 108 as shown in Figure 7a a screen 184 which is shown in Figure 9c as bearing data relating to the selected division or section on a world wide basis. As shown in Figure 9c, the expenditures are displayed for the U. S. in block 186a, the EAMEA countries in block 186b, Canada in block 186c, the Pacific countries in block 186d, the Caribbean countries in block 186e and the Latin American countries in block 186f. The screen 184 further includes blocks 188a and b, 190 and 192. The user may click on blocks 188a and b to set a range of dates, January 1999 to December 1999, whereby in step 114 rental data related to this time period is collected and displayed by the screen 184. For example, the amount displayed in block 196b represents the rental expenditures expressed in U. S. dollars for the named organization from January 1999 through December 1999 for vehicle rentals from all rental locations in the U. S. The user may click on the button 190, whereby step 116 sorts the rental data and identifies the top number of locations for a particular parameter. In the screen 184 of Figure 9c, all geographic divisions are displayed in blocks 186a-g in order of the rental expenditures spent in each of these geographic divisions. Further, the user may click on button 192, whereby step 118 down loads from the reporting database 13 any information provided to the user, the data currently displayed by the screen 184 to the web browser, to a text file. The text file can be imported into any commonly available spreadsheet programs and word processors and other PC software, that is maintained at the user's terminal 22.

If the user would now like to see information about the rental locations in the next lower level of the geographic divisions, the "international divisions" and, in particular, the UNITED STATES, the user clicks on a button 194 of the screen 184, whereby step 112 (Figure 7a) begins a geographic "drill down". Next in step 120 as shown in Figure 7b, the user selects by clicking on the block 186a of the screen 184 (Figure 9c) that corresponds to the selected international division, the UNITED STATES. Then, step 122 selects certain data from the Summary-Geographic-Expend table 13c3 and the Location table 13a2 as shown in Figure 6b. In this illustrative example, the user is collecting rental data relative to the UNITED STATES, which has the International Division Code The process accesses data related to the UNITED STATES in the Location table 13c3 by using its code One row of data bearing the code relates to Los Angeles and further includes the Location ID 143, which points to the related data row in the Summary table 13c3 that also bears a Location ID 143.

These rows from tables 13a2 and 13c3 are joined in step 122 into a single elongated 17row in preparation for further processing. In particular, step 124 (Figure 7b) identifies all of the elongated rows, known as summary records, that relate or apply to certain parameters. In this example, the parameter is International divisions and, in particular, the UNITED STATES which is identified by the International division code Thus step 124 identifies all summary records with the code before step 126 sums the rental data by parameter for all of the identified summary records. Though the steps 122,124 and 126 are shown separately, these steps are carried out substantially simultaneously. Though only a few records are illustrated in Figure 6b, the number of summary records so identified in step 124 and summed in step 126 may number in the hundreds, the thousands and potentially more. The summed data from step 126 is then displayed in a screen 196 shown in Figure 9d. In particular, data analysis has drilled down to the next or international level whereby U. S. expenditue may be displayed. As explained above, the user may actuate step 114 (Figure 7a) again to view the data summed by month and year. The user may actuate step 116 (Figure 7a) again to identify the top N (10,25,50,100, all) locations in the selected country in blocks 196a-c by expenditures. If the user wishes to "drill down" to the next lower level, i. the country level, the user again actuates step 112 (Figure 7a) to create and display a screen 200 as shown in Figure 9e for a selected country, U. S. A. If the user wishes to "drill down" down further to the state or province level, the user again actuates step 112 to produce a screen 214 as shown in Figure 9f for a selected state, New York. If the top N button 220 is clicked again, the expenditures for the top N locations will be displayed in blocks 218a-218j. In a similar fashion, the user can actuate the step 112 to again "drill down" to the city level and to produce a screen 250 as shown in Figure 9i for a selected city, New York City. It is within the scope of this invention to "drill down" to an individual renter level. The sort buttons can be used to sort the data in either ascending or descending order.

The user clicks on any column in the grid and presses the appropriate sort button (ascending, descending). Drop downs 210a and 210b can be used to designate the data range for the data of interest, eg. from January 1999 to December 1999. Drop down 210c is used to change currency displayed. Drop down 210c is used to change the distance parameter data. Link 211 is used to allow the user to "drill up" through the various geographic levels. Button 213 is used to allow the user to down load the data displayed to a text file.

Reports The user uses the process shown in Figure 8 to generate a variety of reports about 18 selected of the rental parameters, the geographic entity or a time period of interest.

When the user selects the Report Catalog option, step 144 displays a screen 220 as shown in Figure 9g that bears a list or menu 222 of reports which this particular embodiment is capable of assembling and generating. It is contemplated that other reports as would include other combinations of rental parameters are within the scope of this invention. Each report includes a button 224, which the user may click on to generate that report. For example if the user clicks on button 224k, the "Top Countries in EAMEA" report will be generated. After selection of a particular report, step 146 displays a screen 230 as shown in Figure 9h, which displays a plurality of parameters that may be reported by the selected report. The user may click in step 148 (Figure 8) on a pair of buttons 232a and b to set the limits of the time period of interest, a button 244 to select the company of interest, a button 246 to select the geographic level and unit of interest, a button 234 to set the currency of interest, and a button 238 to set the units of distance of interest, miles or kilometres. In step 150, selected of the data in the Summary-Geographic-Expend table 13c3, the Location table 13a2 and the Organization table 13a5 (all shown in Figure 6b) are accessed and joined according to the selected parameters. For example, if the user selects in step 148 data related to "Martin Marietta Aerospace" as the organization of interest, step 150 uses that rows Organization ID number to link to the corresponding row in the Summary table 13c3.

That row in the Summary table 13c3 uses its Checkout Location ID to link to the corresponding row in the Location table 13a2. These three rows are arranged in an elongated row or Summary record, where all of this information is available at one time. Next, step 152, identifies all of the Summary records, and step 154 sums the data in all of the identified Summary records by the selected country code. Though separate steps 150,152,154 and 156 are shown, it is appreciated that the functions of these four steps are carried out substantially simultaneously. Still referring to Figure 8, step 156 responds to the clicking of button 236 (Figure 9h) to access and sort the countries within the selected International division, in this example EAMEA, for expenditures to provide a list of the top 10 countries by total expenditures. Next step 158 generates a report (not shown) of the expenditure of EAMEA and the other parameters selected in step 148.

Renter/Employee Profiles List The renter/employee profile list feature allows the user to download profiles for employees in their organizations. They can choose to download all profiles for the entire company or for a particular division or subdivision of the employer/company("AWD" explorer). The employer can choose to download all 19 profiles or only those that have been added or updated since a certain month and year.

These profiles contain information such as employee name, address, identification number or ID, credit card information and insurance preferences.

Security The security portion of this system is used to manage user access to the website and to the specific data that the user can access. Users can be setup with one (or more) of three different roles: an interactive user, security officer, and password change officer. An interactive user cannot access the security functions of the system, a security officer can only access the security features. A password change officer can change another user's password (help desk). A user can have more than one role.

Interactive users are restricted to the specific data they can view in one of three ways. A user is either "All", "AWD", or "STC". An "All" user has access to all data in the system. An "AWD" user (extemrnal customer) can only access certain AWDs. A Sales Territory Codes (STC) user (internal sales user) can only access the AWDs associated with his/her STC code. When the security officer sets up an AWD user, he/she uses the AWD explorer to select the applicable AWD numbers. The security module allows the security officer to create new user IDs, modify existing user IDs, delete user IDs, change passwords, and unlock or lock a user's ID.

While the invention has been particularly shown and described with respect to illustrative and preferred embodiments thereof, it will be understood by those skilled in the art that the foregoing and other changes in form and details may be made therein without departing from the spirit and scope of the invention that should be limited only by the scope of the appended claims.

In the claims that follow and in the preceding description of the invention, except where the context requires otherwise owing to express language or necessary implication, the word "comprise" or variations such as "comprises" or "comprising" is used in an inclusive sense, that is, to specify the presence of the stated features but not to preclude the presence or addition of further features in various embodiments of the invention.

Further, any reference herein to prior art is not intended to imply that such prior art forms or formed a part of the common general knowledge.

Claims (53)

1. A method of extracting rental information from a database and analyzing the extracted rental information, said rental information relating to at least first and second parameters, said first parameter including at least first and second levels of detail, said first level of detail corresponding to the finest level of detail, said method comprising the steps of: a) constructing at least first and second tables, said first and second tables including pluralities of first and second rows respectively, each first row comprises at least a first parameter and each second row comprises a second parameter, said first and second parameters defining different attributes of the rental transaction; b) combining one of said plurality of first rows and one of said plurality of second rows to form a summary record; c) accessing each of said summary records with said first parameter to a selected one of said first and second levels of detail; and d) summing said second parameters of said accessed summary records to provide a summed indication of said second parameter to said first level of detail.

2. A method of extracting rental information as claimed in claim 1, wherein said first parameter defines geographic division of the rental location.

3. A method of extracting rental information as claimed in claim 2, wherein said second parameter defines the expenditure involved in the rental transaction.

4. A method of extracting rental information as claimed in claim 2, wherein said geographic division of said first level is relatively smaller than said geographic division of said second level.

A method of extracting rental information as claimed in claim 4, wherein said geographic divisions include selected of street addresses, cities, states, provinces, countries and combinations of countries.

6. A method of extracting rental information as claimed in claim 2, wherein step a) constructs each of said first and second rows with a third parameter.

7. A method of extracting rental information as claimed in claim 6, wherein step b) compares said third parameter of one of said first rows with said third parameter of one 21 of said second rows and, if there is a match, combining said one first and second rows to form said summary record.

8. A method of extracting rental information as claimed in claim 7, wherein said third parameter comprises an ID uniquely identifying one of the plurality of the rental locations.

9. A method of extracting rental information as claimed in claim 1, wherein said second parameter may comprise selected of expenditures involved in the rental transaction, the method of payment, the duration of the rental, the date of the rental and the employer of the renter.

A method of extracting rental information as claimed in claim 9, wherein the rental information relates to the rental of vehicles, said second parameter may further comprise the distance that the vehicle is driven in the course of a rental.

11. A method of extracting rental information as claimed in claim 1, wherein there is further comprised the step of assigning to each renter an ID that indicates the organization of the renter.

12. A method of extracting rental information as claimed in claim 11, wherein the organization of the employer comprises a plurality of divisions and each division comprises smaller subdivisions, said first parameter of said first level is one division of the organization and said first parameter of said second level is one subdivision of the organization.

13. A method of extracting rental information as claimed in claim 12, wherein said second expenditures is expenditures, and said step d) of summing said second parameter provides an indication of the total expenditures of the organization.

14. A method of extracting rental information as claimed in claim 13, wherein said step d) of summing expenditures to said second level of detail provides an indication of the total expenses of a relatively large division of the organization and summing expenditures to said first level of detail provides an indication of the total expenses of a relatively small division of the organization.

A method of constructing and accessing a database to permit an organization of the 22 renters to analyze vehicle transaction information, said method comprising the steps of: a) inputting to the database a plurality of files, each file defining a vehicle rental transaction, each file comprising a parameter indicative of the vehicle rental location in terms of a plurality of geographical divisions of different granularity and a parameter indicative of an attribute of its vehicle rental transaction; b) permitting the organization to select the granularity of the geographic division and identifying the vehicle rental transactions from the geographic division of selected granularity; and c) collecting the parameter from all of the identified vehicle rental transactions to provide an indication of the collected parameter from all of the rental locations within the geographic division of the selected granularity.

16. A method of constructing and accessing as claimed in claim 15, wherein said selecting step b) is repeated to permit the organization to select a geographic division of a different granularity, before repeating step c) to collect the parameter from all of the identified vehicle transactions with the geographic division of the different granularity.

17. A method of constructing and accessing as claimed in claim 15, wherein said parameter may be selected from a group comprising expenditures, the day of the vehicle rental, the manner of payment and the miles that the vehicle was driven during the vehicle rental.

18. A method of constructing and accessing as claimed in claim 15, wherein said parameter is numerically quantifiable.

19. A method of constructing and accessing as claimed in claim 18, wherein said quantifiable parameters are selected from a group comprising: the expenditures, and the number of the days of the rental transaction.

20. A method of constructing and accessing as claimed in claim 15, wherein step a) inputs files to the database, each file of which includes a second parameter that indicates the date of the vehicle rental transaction.

21. A method of constructing and accessing as claimed in claim 20, wherein there is further included the step of setting a period of time as to the vehicle rental transactions of interest, and collecting from the identified vehicle rental transactions those files with a second parameter that falls with the set period of time. 23

22. A method of constructing and accessing as claimed in claim 18, wherein there is further included the step of sorting the quantifiable parameters collected by the magnitude of the summed parameter.

23. A method of constructing and accessing a database of vehicle rental information related to a plurality of organizations and their renters, at least one organization having a structure comprised of a plurality of divisions, said method comprising the steps of: a) assigning to each vehicle renter an ID indicating the renter's affiliated organization and division; b) constructing and inputting into a database a file that includes data for each vehicle rental transaction, each file comprising the assigneq ID of the vehicle renter involved in the vehicle rental transaction; c) permissioning each organization access to the database for only that vehicle rental transaction data which includes an ID that matches the organization seeking access; and d) facilitating each permissioned organization to select the entire structure or division of interest and to collect vehicle rental transaction data of the renters assigned to the selected entire structure or division.

24. A method of constructing and accessing as claimed in claim 23, wherein step b) constructs each file to include at least one parameter indicative of an attribute of the vehicle rental transaction data, and step d) is repeated to permit the permissioned organization to select a different division or entire structure and collect said parameter from each of the vehicle rental transaction data of the renters assigned to the different division or entire structure.

A method of constructing and accessing as claimed in claim 24, wherein said parameter may be selected from a group comprising expenditure, the day of the vehicle rental, the manner of payment, and the miles that the vehicle was driven during the vehicle rental.

26. A method of constructing and accessing as claimed in claim 23, wherein step b) constructs each file to include a plurality of parameters, each parameter indicative of a different attribute of the vehicle rental transaction data, and there is further included the step of facilitating the employer to select any combination of said plurality of said parameters and to generate a report of the data corresponding to the selected 24 combination of parameters from the vehicle rental transaction data of the renters assigned to the selected division or entire structure.

27. A method of constructing and accessing as claimed in claim 23, wherein at least one organization has a structure comprised further of a plurality of subdivisions, and step d) is repeated to permit the permissioned organization to select a different one of the entire structure, division or subdivision and collect said parameter from the vehicle rental transaction data of the renter assigned to the different entire structure, division or subdivision.

28. A method of managing data related to transactions, wherein a single supplier is a party to each of the transactions, said method comprising the steps of: a) inputting a plurality of files of the data related to transactions involving the single supplier, the inputted data having field names and characteristics define by parameters; b) storing the inputted data files without substantial transformation into a first set of tables, the tables of the first set having the field names that match the field names of the inputted data files; and c) mapping the inputted data to be stored in a second set of tables, whereby the second set of table are structured in a manner to store the mapped data such that it may be accessed by one or more parameters which relate to a corresponding characteristic of the inputted data of the single supplier.

29. A method of managing transaction data as claimed in claim 28, wherein said step b) stores the inputted data files so that the field names of the tables of the first set matches the field names of the inputted data files.

A method of managing transaction data as claimed in claim 29, wherein said step b) stores the inputted data filed so that the size of the tables of the first set matches the size of the inputted data files.

31. A method of managing transaction data as claimed in claim 28, wherein step a) inputs the plurality of data files from different sources.

32. A method of managing transaction data as claimed in claim 28, wherein the second set of tables includes a core data table that stores data about various aspects of the transactions. 25

33. A method of managing transaction data as claimed in claim 32, wherein the transactions comprise vehicle rentals and the transactions involve an entity, and said core data table stores data selected from the group of a renter, a vehicle rental location, codes identifying the extent that certain entities are granted access to the data stored in the tables of the first set, organization of the entity, and a profile of a vehicle renter.

34. A method of managing transaction data as claimed in claim 28, wherein the second set of tables includes a table that stores data about the transactions.

A method of managing transaction data as claimed in claim 34, wherein the transactions comprise vehicle rentals and the transactions involve an entity, and said transaction data table stores data selected from a group of an identity of a renter, dates of rental, rental check-out and check-in locations, miles driven, rates charged, a renter's address and a driver's license number.

36. A method of managing transaction data as claimed in claim 28, wherein the second set of tables includes a summary data table that stores data summarizing various aspects of the transactions.

37. A method of managing transaction data as claimed in claim 36, wherein the transactions comprises vehicle rentals and involves employees of certain entities that rent vehicles, said core data table stores data selected from a group of summaries of data related to vehicle rentals comprising: a first summary of an ID of the entity and including the following characteristics of check-out locations, vehicle rental dates of each vehicle rental, and an identification of a vehicle involved in each rental, a second summary of an ID of the entity and including the following characteristics of a check- out location and the data of the transaction, a third summary of an ID and including the following characteristics of the number vehicle rentals, distance travelled, the check-out location, the check-in location and the date of the vehicle transaction, a fourth summary of an ID and including the following characteristics of the number of rentals, expenditures, distance travelled, the check-out location, the check-in location and the date of vehicle rental transaction, a fifth summary of an ID and including the following characteristics of the check-out location, the date of payment and the method of payment, and a sixth summary of an ID and including the following characteristics of the check-out location, the date of the vehicle transaction and a source of the reservation. 26

38. A method of managing transaction data as claimed in claim 28, wherein the second set of tables includes a table of codes whose value provides a further description of the stored data.

39. A method of managing transaction data as claimed in claim 38, wherein the codes provide a further description of characteristics of the following group of the transactions: identity the vehicles, country, currency, distance travelled, state, method of payment, and booking source.

A system for managing data related to transactions and facilitating at least one user to access data, wherein the data has one or more characteristics defined by corresponding parameters and a single supplier is a party to each of the transactions, said system comprising: a) a memory structured to store the data in a format adapted to be accessed and searched by the one user; b) a server memory programmed to receive and to map files of data of different formats into a common format compatible with the data format of the memory; and c) a network server coupled to a network to permit the one user to select and use one or more of the plurality of parameters to search the memory and to access its data that corresponds to the selected one or more parameters, each of which defines at least one characteristic of the transactions.

41. A data managing system as claimed in claim 40, wherein the network is the Internet.

42. A data managing system as claimed in claim 40, wherein the data relates to transactions of a single entity, and said network server is programmed to search the 3 0 memory for data related to the user.

43. A data managing system as claimed in claim 40, wherein the user is involved in the transaction, and said network server is programmed to search the memory for data related to the transactions in which the user is involved.

44. A data managing system as claimed in claim 40, wherein said network server is programmed to search the memory for data indicative of the quantity of transactions to 27 which the user is related.

A data managing system as claimed in claim 40, wherein the user comprises a plurality divisions, and said network server is programmed to search selectively the memory for transactions related to at least one of the plurality of divisions.

46. A data managing system as claimed in claim 40, wherein the user is an employer with a plurality of employees, and said network server is programmed to search selectively the memory for transactions related to at least one of the plurality of employees.

47. A data managing system as claimed in claim 40, wherein tte transactions comprise vehicle rental, and said network server is programmed to search selectively the memory for selected characteristics of the vehicle rentals.

48. A data managing system as claimed in claim 47, wherein the vehicle rental characteristics comprise identity of renter, dates of rental, rental check-out and check-in locations, miles driven, rental rates, renter's address and driver's license number.

49. A method of extracting rental information from a database and analyzing the extracted rental information substantially as hereinbefore described with reference to the accompanying drawings.

A method of constructing and accessing a database to permit an organization of the renters to analyze vehicle transaction information substantially as hereinbefore described with reference to the accompanying drawings.

51. A method of constructing and accessing a database of vehicle rental information related to a plurality of organizations and their renters substantially as hereinbefore described with reference to the accompanying drawings.

52. A method of managing data related to transactions, wherein a single supplier is a party to each of the transactions, substantially as hereinbefore described with reference to the accompanying drawings.

53. A system for managing data related to transactions and facilitating at least one user to access data, wherein the data has one or more characteristics defined by 28 corresponding parameters and a single supplier is a party to each of the transactions, substantially as hereinbefore described with reference to the accompanying drawings. Dated this 20th day of March 2006 ARAC MANAGEMENT SERVICES, INC. By their Patent Attorneys GRIFFITH HACK Fellows Institute of Patent and Trade Mark Attorneys of Australia