USRE44478E1 - Method and system for navigating a large amount of data - Google Patents

Method and system for navigating a large amount of data Download PDF

Info

Publication number
USRE44478E1
USRE44478E1 US11/122,214 US12221405A USRE44478E US RE44478 E1 USRE44478 E1 US RE44478E1 US 12221405 A US12221405 A US 12221405A US RE44478 E USRE44478 E US RE44478E
Authority
US
United States
Prior art keywords
data
formatted
grid
warehoused
warehoused data
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.)
Expired - Lifetime, expires
Application number
US11/122,214
Inventor
Niels Godfredsen
Spencer Lord
Yusuf Bashir
Eric Ying
Oliver Tse
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Informatica LLC
Original Assignee
Informatica LLC
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Informatica LLC filed Critical Informatica LLC
Priority to US11/122,214 priority Critical patent/USRE44478E1/en
Application granted granted Critical
Publication of USRE44478E1 publication Critical patent/USRE44478E1/en
Assigned to INFORMATICA LLC reassignment INFORMATICA LLC CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). Assignors: INFORMATICA CORPORATION
Assigned to NOMURA CORPORATE FUNDING AMERICAS, LLC reassignment NOMURA CORPORATE FUNDING AMERICAS, LLC SECURITY INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: INFORMATICA LLC
Assigned to NOMURA CORPORATE FUNDING AMERICAS, LLC reassignment NOMURA CORPORATE FUNDING AMERICAS, LLC FIRST LIEN SECURITY AGREEMENT SUPPLEMENT Assignors: INFORMATICA LLC
Assigned to JPMORGAN CHASE BANK, N.A. reassignment JPMORGAN CHASE BANK, N.A. SECURITY INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: INFORMATICA LLC
Assigned to INFORMATICA LLC reassignment INFORMATICA LLC RELEASE BY SECURED PARTY (SEE DOCUMENT FOR DETAILS). Assignors: NOMURA CORPORATE FUNDING AMERICAS, LLC
Assigned to INFORMATICA LLC reassignment INFORMATICA LLC RELEASE BY SECURED PARTY (SEE DOCUMENT FOR DETAILS). Assignors: NOMURA CORPORATE FUNDING AMERICAS, LLC
Adjusted expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/26Visual data mining; Browsing structured data
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching

Definitions

  • the present invention relates to database management systems. Specifically, the present invention pertains to a method and system for navigating a large amount of data.
  • Computers are used to perform a wide variety of applications in such diverse fields as finance, traditional and electronic commercial transactions, manufacturing, health care, telecommunications, etc. Most of these applications typically involve inputting or electronically receiving data, processing the data according to a computer program, then storing the results in a database, and perhaps transmitting the data to another application, messaging system, or client in a computer network. As computers become more powerful, faster, and more versatile, the amount of data that can be processed also increases.
  • Extracting raw data from one or more operational databases and transforming it into useful information is the function of analytic applications.
  • data warehouses and data marts the data are structured to satisfy decision support roles rather than operational needs.
  • a data warehouse utilizes a business model to combine and process operational data and make it available in a consistent way. Before the data are loaded into the data warehouse, the corresponding source data from an operational database are filtered to remove extraneous and erroneous records; cryptic and conflicting codes are resolved; raw data are translated into something more meaningful; and summary data that are useful for decision support, trend analysis and modeling or other end-user needs are pre-calculated.
  • a data mart is similar to a data warehouse, except that it contains a subset of corporate data for a single aspect of business, such as finance, sales, inventory, or human resources.
  • the data warehouse or data mart is comprised of an “analytical” database containing extremely large amounts of data useful for direct decision support or for use in analytic applications capable of sophisticated statistical and logical analysis of the transformed operational raw data.
  • useful information is retained at the disposal of the decision-makers and users of analytic applications and may be distributed to data warehouse servers in a networked system. Additionally, decision-maker clients can retrieve analytical data resident on a remote data warehouse servers over a computer system network.
  • An example of the type of company that would use data warehousing is an online Internet bookseller having millions of customers located worldwide whose book preferences and purchases are tracked. By processing and warehousing these data, top executives of the bookseller can access the processed data from the data warehouse, which can be used for sophisticated analysis and to make key decisions on how to better serve the preferences of their customers throughout the world.
  • WAN Wide Area Networks
  • Worldwide Web the Internet
  • Internet provides the capability to transmit operational data into database applications and to share data contained in databases resident in disparate networked servers.
  • vast amounts of current transactional data are continuously generated by business-to-consumer and business-to-business electronic commerce conducted over the Internet. These transactional data are routinely captured and collected in an operational database for storage, processing, and distribution to databases in networked servers.
  • Messaging systems are computer systems that allow logical elements of diverse applications to seamlessly link with one another. Messaging systems also provide for the delivery of data across a broad range of hardware and software platforms, and allow applications to interoperate across network links despite differences in underlying communications protocols, system architectures, operating systems, and database services. Messaging systems and the recent development of Internet access through wireless devices such as enabled cellular phones, two-way pagers, and hand-held personal computers, serve to augment the transmission and storage of data and the interoperability of disparate database systems.
  • Portable and/or wireless services such as cellular phones, two-way pagers, and hand-held personal computers, have limited computational and display resources.
  • the present invention provides a reliable, convenient and rapid method and/or system for the navigating through the large amounts of data, such as data in a data warehouse/mart.
  • the present invention further provides a method and/or system for navigating through a large amount of data on a wireless device such as enabled cellular phones, two-way pagers, and hand-held personal computers.
  • the present invention accesses a source of formatted warehoused data.
  • the present invention then displays a grid on a display device.
  • the grid is an iconic representation of the formatted warehoused data.
  • the grid is comprised of elements, each element corresponding to some portion of the formatted warehoused data.
  • a portion of the formatted warehoused data is displayed on the display device in response to a selection of a corresponding element of the grid.
  • a source of formatted warehoused data is accessed.
  • the formatted warehoused data is then distilled into a plurality of hierarchical overviews.
  • a hierarchical overview comprises a subtotal of selected entries from the formatted warehoused data.
  • a hierarchical overview is received.
  • FIG. 1 illustrates a schematic block diagram of an exemplary client/server computer system network upon which embodiments of the present invention may be implemented.
  • FIG. 2 illustrates an exemplary computer system upon which embodiments of the present invention may be practiced.
  • FIG. 3 illustrates an exemplary display device in accordance with an embodiment of the present invention for navigating a large amount of data.
  • FIG. 4 is a flowchart of steps performed in accordance with an embodiment of the present invention for navigating a large amount of data.
  • FIGS. 5A-5C illustrate an exemplary version of formatted warehoused data in accordance with embodiments of the present invention for navigating a large amount of data.
  • FIG. 6 is a flowchart of steps performed in accordance with another embodiment of the present invention for navigating a large amount of data.
  • FIG. 1 is a block diagram depicting one embodiment of a system 100 for the delivery of data, particularly the wireless delivery of data, in accordance with the present invention.
  • Data sources 101 include one or more sources of data resulting from business and financial transactions, equipment performance logs, and the like.
  • RDBMS Relational Database Management System
  • ERP Enterprise Resource Planning
  • SAP Service Advertising Protocol
  • Data storage 102 is for storing operational data and the like from data sources 101 , typically using a high capacity mass storage device (such as hard disk drives, optical drives, tape drives, etc.).
  • data storage 102 is a data warehouse.
  • Data storage 102 is coupled to a database management system (DBMS) 104 by analytic data interface 103 .
  • DBMS 104 executes an analytic application such as a data mart application.
  • a repository 105 is coupled to (or integrated with) DBMS 104 for storing information from the database management system.
  • data e.g., business metrics
  • periodic style data are calculated at predetermined intervals (e.g., hourly, daily, weekly, etc.) and stored in repository 105 , and the most recent data are provided to the requester.
  • on demand style the data are calculated in response to a user request. These data may be cached or persisted in some manner (e.g., in repository 105 ), but do not exist or have value until they are initially requested.
  • the continuous (real time) style data are updated as underlying data are updated. For example, a business metric describing the moving average for the inventory of a particular item gets updated as the inventory level for that item is updated. In each case, the requester gets the freshest data.
  • an application server 106 is interposed between the DBMS 104 and a voice server 107 or the Internet 109 .
  • application server 106 is accessible to users via a unique Uniform Resource Locator (URL).
  • URL Uniform Resource Locator
  • Application server 106 provides information (e.g., business metrics and transformed data, but also untransformed or raw data) to users from DBMS 104 and/or repository 105 .
  • Voice server 107 provides voice-to-text and text-to-voice services for converting voice messages received from a user via a conventional telephone 110 , and for similarly converting information from application server 106 into an audible message. A user can thereby access application server 106 using a conventional telephone 110 via voice server 107 , and receive information from application server 106 via the same path.
  • a firewall 108 encloses voice server 107 , application server 106 , and the other devices and components coupled with those devices on the internal side of the firewall.
  • Wireless gateway 111 enables communication between wireless devices and application server 106 within the framework of a wireless service provider (WSP).
  • WSP wireless service provider
  • Wireless devices are exemplified as wireless phone 112 and PDA 113 ; however, it is appreciated that other types of wireless devices such as a pager or two-way pager, or any other data-capable or data-enabled device operable for wireless communication, may be used.
  • the wireless devices Preferably, the wireless devices have display capability, but other means for conveying information to a user may be utilized. For example, information can be converted into an audible message (e.g., text-to-voice).
  • Coupled to the Internet 109 may be a computer system 114 that is also capable of communicating with application server 106 .
  • information can be exchanged between computer system 114 and application server 106 via electronic mail (e-mail).
  • Computer system 114 may also incorporate a Web browser or other such elements allowing it to access a Web site on application server 106 using the URL for application server 106 .
  • system 100 supports a number of various different types of end-user devices, as well as different types of service providers (e.g., Internet Service Providers, WSPs, etc.).
  • service providers e.g., Internet Service Providers, WSPs, etc.
  • a user can register a variety of devices and device types utilizing different service providers, protocols (e.g., wireless application protocol (WAP)), Communication standards, and data formats, and use these devices to receive information (e.g., business metrics, etc.) at remote locations (e.g., at field locations worldwide).
  • WAP wireless application protocol
  • FIG. 2 is a block diagram of an embodiment of an exemplary device 200 used in accordance with the present invention.
  • device 200 of the present embodiment is well suited to be any type of computing device (e.g., server computer, portable computing device, desktop computer, mobile phone, pager, personal digital assistant, etc.).
  • computing device e.g., server computer, portable computing device, desktop computer, mobile phone, pager, personal digital assistant, etc.
  • certain processes and steps are discussed that are realized, in one embodiment, as a series of instructions (e.g., software program) that reside within computer readable memory units of device 200 and executed by a processor(s) of device 200 . When executed, the instructions cause device 200 to perform specific actions and exhibit specific behavior which is described in detail herein.
  • Device 200 of FIG. 2 comprises an address/data bus 299 for communicating information, one or more central processors 201 coupled with bus 299 for processing information and instructions.
  • Central processor unit(s) 201 may be a microprocessor or any other type of processor.
  • the device 200 also includes data storage features such as a computer usable volatile memory unit 202 (e.g., random access memory, static RAM, dynamic RAM, etc.) coupled with bus 299 for storing information and instructions for central processor(s) 201 , a computer usable nonvolatile memory unit 203 (e.g., read only memory, programmable ROM, flash memory, EPROM, EEPROM, etc.) coupled with bus 299 for storing static information and instructions for processor(s) 201 .
  • a computer usable volatile memory unit 202 e.g., random access memory, static RAM, dynamic RAM, etc.
  • a computer usable nonvolatile memory unit 203 e.g., read only memory, programmable ROM, flash memory, EPROM,
  • Device 200 also includes one or more signal generating and receiving devices 208 coupled with bus 299 for enabling device 200 to interface with other electronic devices and computer systems.
  • the communication interface(s) 208 of the present embodiment may include wired and/or wireless communication technology.
  • the communication interface 208 may be a serial communication port, a Universal Serial Bus (USB), an Ethernet adapter, a Fire Wire (IEEE 1394) interface, a parallel port, a small computer system interface (SCSI) bus interface, infrared (IR) communication port, Bluetooth wireless communication port, a broadband interface, or an interface to the Internet, among others.
  • device 200 may include an alphanumeric input device 206 including alphanumeric and function keys coupled to the bus 299 for communicating information and command selections to the central processor(s) 201 .
  • alphanumeric input device 206 is a touch screen device; in this implementation, alphanumeric input device 206 is capable of registering a position where a stylus element (not shown) makes contact.
  • the device 200 can include an optional cursor control or cursor directing device 207 coupled to the bus 299 for communicating user input information and command selections to the central processor (s) 201 .
  • the cursor-directing device 207 may be implemented using a number of well known devices such as a mouse, a track-ball, a track-pad, an optical tracking device, among others.
  • cursor control 207 is a touch screen device incorporated with display device 205 .
  • cursor control 207 is capable of registering a position on display device 205 where a stylus element makes contact.
  • a cursor may be directed and/or activated via input from the alphanumeric input device 206 using special keys and key sequence commands.
  • the present embodiment is also well suited to directing a cursor by other means such as, for example, voice commands.
  • a display device 205 is coupled to bus 299 of device 200 for displaying video and/or graphics. It should be appreciated that display device 205 may be a cathode ray tube (CRT), flat panel liquid crystal display (LCD), field emission display (FED), plasma display or any other display device suitable for displaying video and/or graphic images and alphanumeric characters recognizable to a user.
  • the device 200 of FIG. 2 may also include one or more optional computer usable data storage devices 204 such as a magnetic or optical disk and disk drive (e.g., hard drive or floppy diskette) coupled with bus 299 for storing information and instructions.
  • a magnetic or optical disk and disk drive e.g., hard drive or floppy diskette
  • FIG. 3 illustrates an exemplary display device 205 in accordance with an embodiment of the present invention for navigating a large amount of data.
  • FIG. 3 in combination with process 400 of FIG. 4 , enables a user of a device 200 to access a large amount of formatted warehoused data, such as formatted warehoused data 500 of FIG. 5A .
  • FIG. 3 in combination with process 400 enables the user of device 200 to easily navigate the formatted warehoused data 500 .
  • FIG. 3 portrays the formatted data in an easily navigable environment.
  • the easily navigable environment of display 205 includes a grid 330 , grid elements 340 , and a displayed portion of warehoused data 500 .
  • the source of formatted warehoused data (e.g., 500 ) is stored on a content server (e.g., application server 106 ).
  • application server 106 may be a web server, WAP gateway, or the like.
  • the present embodiment prevents a server timeout between application server 106 and device 200 . Specifically, the timeout is prevented by utilizing a separate thread for query execution that also allows for query cancellation. In so doing, the “pipeline” between device 200 and application server 106 remains open until the user chooses to close it.
  • device 200 will not be disconnected from application server 106 if an amount of idle time has passed. Therefore, the user of device 200 is does not have to re-access the formatted warehoused data 500 and re-enter a password.
  • the formatted warehoused data 500 may be formatted in a cross-tabular manner (as a “report”).
  • formatted warehouse data 500 is presented in a scaled iconic representation on display 205 .
  • grid 330 is the scaled iconic representation of the formatted warehoused data 500 shown on a portion of display 205 .
  • grid 330 is comprised of many elements, such as 340 and 344 , which correspond to some portion of formatted warehoused data 500 .
  • An element in grid 330 may correspond to an entry in formatted warehoused data 500 , or an element may correspond to multiple entries.
  • each element 340 represents some portion of the total formatted warehoused data 500 . Therefore, if a user desires to view a specific portion of the formatted warehoused data 500 , the user need only select an element, such as element 340 , from grid 330 . In one embodiment, the user selects an element by contacting display device 205 with a stylus element, as described above. Upon selection of an element, such as element 340 , a corresponding portion 310 of the formatted warehoused data 500 is downloaded to, and displayed on, display device 205 . Hence, a user can easily read portion 310 on display device 205 without being overwhelmed with the entire formatted warehoused data 500 file.
  • elements e.g., 340 , 344 , etc.
  • display device 205 further utilizes analytic data interface 103 in conjunction with repository 105 to download only portion 310 to display device 205 . Therefore, device 200 is not overloaded with the entire version of formatted warehoused data 500 , but instead receives only the portion 310 selected for viewing.
  • the corresponding portion 310 of grid 330 may retain the axis labels of the formatted warehoused data 500 while the user navigates through grid 330 .
  • both a row 320 label and a column 325 label are included.
  • the content of row 320 and column 325 will pertain to the content of element 340 .
  • element 344 is then selected as the next portion 310 to be represented, the column 325 and row 320 will remain a visual part of portion 310 ; however, the content of row 320 and column 325 will now pertain to the content of element 344 .
  • an element e.g., 344
  • column 325 and row 320 headings will remain in the displayed portion 310 .
  • elements of grid 330 can be navigated upon display device 205 with the use of alpha-numeric input 206 (e.g. hot keys, keyboard arrows, etc.) and/or a graphical user interface (GUI) displayed on device 200 .
  • GUI graphical user interface
  • Examples of a GUI may include, but not limited to, a cursor 375 , or scrolling arrows 350 .
  • the actual navigation of grid 330 can therefore be accomplished by scrolling through the elements (e.g., 340 , 344 ) utilizing scrolling arrows 350 , cursor 375 , stylus element, or any specified keys.
  • a specific element, such as element 340 or element 344 , of grid 330 may be selected by utilizing hot keys, cursor 375 , stylus element, etc., to choose the desired element (e.g., 340 , 344 ) for viewing.
  • examples of device 200 may include, but are not limited to, a mobile phone, and a portable-computing device (e.g. personal digital assistant, pager, and the like). It is also appreciated, that in one embodiment, the element (e.g., 340 ) of grid 330 which is displayed as portion 310 may be visually modified (e.g., highlighted, darkened, lightened, shaded, etc.) to signify the element (e.g., 340 ) of grid 330 presently being viewed.
  • the dimensions of grid 330 , element 340 , and displayed portion 310 are all adjusted by analytic data interface 103 according to specific metrics supplied to analytic data interface 103 by device 200 .
  • analytic data interface 103 formats the warehoused data 500 such that a presentation of size x-by-y dimensions will appear on display device 205 . Therefore, the present method for navigating a large amount of data can account for the characteristics of the display 205 utilized by device 200 , and thus can be used with a variety of such devices.
  • FIG. 4 is a flowchart 400 of the steps performed in accordance with an embodiment of the present invention for navigating a large amount of data.
  • Flowchart 400 includes processes of the present invention which, in one embodiment, are carried out by processors and electrical components under the control of computer readable and computer executable instructions.
  • the computer readable and computer executable instructions may reside, for example, in data storage features such as data storage device 202 , 203 , and/or 204 of FIG. 2 .
  • the computer readable and computer executable instructions may reside in any type of computer readable medium.
  • specific steps are disclosed in flowchart 400 , such steps are exemplary. That is, the present embodiment is well suited to performing various other steps or variations of the steps recited in FIG. 4 .
  • the steps of flowchart 400 may be performed by software, by hardware, or by any combination of software and hardware.
  • step 402 of FIG. 4 the present embodiment causes device 200 to access a source of formatted warehouse data (e.g., 500 of FIG. 5A ). It is understood that step 402 may be implemented in a wide variety of ways in accordance with an embodiment of the present invention. For example, the present embodiment may cause device 200 to access formatted warehouse data 500 in any manner similar to that described herein.
  • a source of formatted warehouse data e.g., 500 of FIG. 5A.
  • step 404 of FIG. 4 the present embodiment causes device 200 to display a grid 330 on display device 205 (FIG. 3 ).
  • grid 330 is an iconic representation of the formatted warehoused data 500 .
  • grid 330 is comprised of elements, such as element 340 .
  • each element e.g., 340
  • step 404 may be implemented in a wide variety of ways in accordance with an embodiment of the present invention.
  • the present embodiment may cause device 200 to display a grid 330 in any manner similar to that described herein.
  • the present embodiment causes the device (e.g. 200 ) to display a portion of the formatted warehoused data 500 on the display (e.g., 205 ) in response to a selection of a corresponding element (e.g. 340 ) of grid 330 .
  • Step 406 may be performed in diverse ways in accordance with an embodiment of the present invention.
  • the present embodiment may cause device 200 to display a portion of the formatted warehoused data 500 on display 205 in response to a selection of a corresponding element of grid 330 in any manner similar to that described herein.
  • FIGS. 5A-5C illustrate exemplary versions of formatted warehoused data in accordance with an embodiment of the present invention for navigating a large amount of data.
  • formatted warehoused data 500 is a cross-tabular illustration of one embodiment for representing the formatted warehoused data stored in repository 105 . Although a specific cross-tabular version of formatted warehoused data 500 is shown, many organizational formats of warehoused data 500 may be used. The cross-tabular format is shown merely for purposes of brevity and clarity.
  • FIGS. 5B-5C are subtotal versions of the initial formatted warehoused data 500 .
  • subtotaling data is a method for dynamically rolling formatted warehoused data 500 up to a higher level to make it more digestible.
  • subtotaling refers to trying to distill as much information as possible from a larger more detailed table of data. That is, table 520 is a subtotal of table 500 , table 540 is a subtotal of table 520 . Therefore, table 540 shows the least amount of detail while table 500 shows the most detail. It is appreciated that tables 500 , 520 , and 540 are exemplary and are shown in the present embodiment merely for purposes of clarity.
  • FIG. 6 is a flowchart of the steps performed in accordance with an embodiment of the present invention for navigating a large amount of data.
  • Flowchart 600 includes processes of the present invention which, in one embodiment, are carried out by processors and electrical components under the control of computer readable and computer executable instructions.
  • the computer readable and computer executable instructions may reside, for example, in data storage features such as data storage device 202 , 203 , and/or 204 of FIG. 2 .
  • the computer readable and computer executable instructions may reside in any type of computer readable medium.
  • specific steps are disclosed in flowchart 600 , such steps are exemplary. That is, the present embodiment is well suited to performing various other steps or variations of the steps recited in FIG. 6 .
  • the steps of flowchart 600 may be performed by software, by hardware, or by any combination of software and hardware.
  • process 600 is an exemplary process for navigating a large amount of formatted warehoused data 500 utilizing voice commands.
  • device 200 may be any device which can transmit and/or receive voice data, such as, but not limited to, a regular phone 110 , wireless phone 112 , PDA 113 , and/or computer system 114 .
  • the formatted warehoused data 500 of process 600 is the same formatted warehoused data 500 of process 400 .
  • the format in which analytic data interface 103 represents the formatted warehoused data 500 to process 600 may be different
  • process 600 uses a voice recognition interface, such as voice server 107 , to convey easily digestible portions of formatted warehoused data 500 .
  • voice server 107 conveys inquiries and responses to inquiries audibly according to a voice-based communications protocol.
  • analytic data interface 103 formats the warehoused data 500 into a plurality of hierarchical overviews (e.g., FIGS. 5A-5C ). Specifically, formatted warehoused data 500 is reduced in scope by subtotaling the contents thereof. Then, at each subtotal (e.g. overview), a user has the option of drilling deeper into a specific result in order to review the underlying data. For example, if process 600 were to deliver an initial hierarchical overview (e.g., table 540 of FIG. 5C ) to device 200 , the initial information received in response to an inquiry may be a quantity statement then a cost statement.
  • an initial hierarchical overview e.g., table 540 of FIG. 5C
  • the user may then wish to hear more information or hear the information from a different perspective by selecting a new level of clarity. For example, in a report with Year and Product attributes, the user could first hear sub-totaled metric values for a given year for all products. Then after selecting a specific product, they could hear the metric values for the given year for the selected product. In order to obtain this information, the user formulates an inquiry. In one embodiment, the user accomplishes this with a voice command.
  • Process 600 may respond with the quantities NA, NB, NC of each product A, B, C.
  • the user can drill down to the next level (e.g., table 510 of FIG. 5A ) by initiating an inquiry for more information about one of the products in particular (e.g., product A), receiving in response a breakdown of the components of the quantity NA.
  • Such “drilling down” can be continued in infinitum.
  • a report exemplified by table 500 of FIG. 5A is generated and resides in applications server 106 of FIG. 1 .
  • a user at a wireless device accesses this information, instead of hearing an item-by-item recitation of all the entries in table 500 .
  • a hierarchical overview such as that of table 540 is heard. The user can then select one of the items in the hierarchical overview, and receive more details about that item. This process can be repeated until the user reaches the desired level of detail.
  • a user can receive detailed information using a voice based communications system, but without having to hear an item-by-item recitation of a multitude of entries.
  • the present invention thus provides a ready mechanism for navigating through a large table of data using voice commands.
  • any hierarchical overview is possible with respect to the present embodiment, the examples with regard to FIGS. 5A-5C are shown merely as one example of a multitude of possible overview breakdown criteria. It is further appreciated that the present process 600 can be performed on a screen and may not require voice cues at all. In fact, the hierarchical overview utilized in process 600 may respond to voice inquiries, hot key inquiries, a single click of a cursor, or any other possible input features which are known to one skilled in the art.
  • the formatted warehoused data of table 500 may be represented in a row-by-row format instead of the subtotal format as described above.
  • each row of data from table 500 may be represented in a row-by-row fashion on display 205 .
  • This type of format may be useful when a table of data (e.g., 500 ) contains many rows but few columns.
  • the user may choose to view the formatted warehoused data 500 by row.
  • Such a row-by-row format will allow a user to gain a useful view of a table while not being overwhelmed with the entire table (e.g. 500 ).
  • the row-by-row method for displaying formatted warehoused data 500 , on device 200 may further “freeze” a row for comparison purposes. That is, in the same way as the row 320 and column 325 (of FIG. 3 ) headings were maintained on display 205 , a specific row of data may be held on display 205 . Therefore, a user may compare one specific row with many different rows throughout the table. For example, if one row is of particular interest, the user may navigate throughout the other rows of a table (e.g., table 500 ) while maintaining the desired row as a fixed part on display 205 .
  • a table e.g., table 500
  • the present embodiment causes device 200 to access a source of formatted warehouse data. It is understood that step 602 may be implemented in a wide variety of ways in accordance with an embodiment of the present invention. For example, the present embodiment may cause device 200 to access formatted warehouse data in any manner similar to that described herein. It is further appreciated that device 200 may be any device which can transmit and receive voice data, such as, but not limited to, a regular phone 110 , wireless phone 112 , PDA 113 , computer system 114 . 7 .
  • the present embodiment causes formatted warehoused data 500 to be distilled into a plurality of hierarchical overviews (e.g. 500 , 520 , and 540 of FIGS. 5A-5C ). Further, the hierarchical overviews (e.g. 500 , 520 , and 540 ) comprise a subtotal of selected entries from the formatted warehoused data 500 .
  • Step 604 may be performed in a variety of ways in accordance with embodiment of the present invention.
  • the present embodiment may cause formatted warehoused data 500 to be distilled into a plurality of hierarchical overviews (e.g. 500 , 520 , and 540 ) in any manner similar to that described herein.
  • the present embodiment causes device (e.g., 200 ) to receive a hierarchical overview (e.g. 540 ) in response to a first inquiry.
  • Step 606 may be performed in a variety of ways in accordance with embodiment of the present invention.
  • the present embodiment may cause device 200 to receive a hierarchical overview 540 in any manner similar to that described herein.
  • the present invention provides a reliable, convenient and rapid method and/or system for the navigating through the large amounts of data, such as data in a data warehouse/mart.
  • the present invention further provides a method and/or system for navigating through a large amount of data on a wireless device such as enabled cellular phones, two-way pagers, and hand-held personal computers.

Abstract

Methods for navigating a large amount of data are disclosed. In one embodiment, the present invention accesses a source of formatted warehoused data. The present invention then displays a grid on a display device. In one embodiment, the grid is an iconic representation of the formatted warehoused data. The grid is comprised of elements, each element corresponding to some portion of the formatted warehoused data. The present invention displays a portion of the formatted warehoused data on the display device in response to a selection of a corresponding element of the grid. In another embodiment, the formatted warehoused data is condensed so that it can be read in summary form to a user using a voice-based protocol. The user can issue voice commands to drill down deeper into the data, until the desired information is reached. The user thus doesn't need to hear all of the information in the formatted warehoused data, but instead can make inquiries to directly navigate to a particular item of interest.

Description

FIELD OF THE INVENTION
The present invention relates to database management systems. Specifically, the present invention pertains to a method and system for navigating a large amount of data.
BACKGROUND ART
Computers are used to perform a wide variety of applications in such diverse fields as finance, traditional and electronic commercial transactions, manufacturing, health care, telecommunications, etc. Most of these applications typically involve inputting or electronically receiving data, processing the data according to a computer program, then storing the results in a database, and perhaps transmitting the data to another application, messaging system, or client in a computer network. As computers become more powerful, faster, and more versatile, the amount of data that can be processed also increases.
Unfortunately, the raw data found in operational databases often exist as rows and columns of numbers and codes which, when viewed by individuals, appears bewildering and incomprehensible. Furthermore, the scope and vastness of the raw data stored in modern databases is overwhelming to a casual observer. Hence, applications were developed in an effort to help interpret, analyze, and compile the data so that it may be readily and easily understood by a human. This is accomplished by sifting, sorting, and summarizing the raw data before it is presented for display, storage, or transmission. Thereby, individuals can now interpret the data and make key decisions based thereon.
Extracting raw data from one or more operational databases and transforming it into useful information (e.g., data “warehouses” and data “marts”) is the function of analytic applications. In data warehouses and data marts, the data are structured to satisfy decision support roles rather than operational needs. A data warehouse utilizes a business model to combine and process operational data and make it available in a consistent way. Before the data are loaded into the data warehouse, the corresponding source data from an operational database are filtered to remove extraneous and erroneous records; cryptic and conflicting codes are resolved; raw data are translated into something more meaningful; and summary data that are useful for decision support, trend analysis and modeling or other end-user needs are pre-calculated. A data mart is similar to a data warehouse, except that it contains a subset of corporate data for a single aspect of business, such as finance, sales, inventory, or human resources.
In the end, the data warehouse or data mart is comprised of an “analytical” database containing extremely large amounts of data useful for direct decision support or for use in analytic applications capable of sophisticated statistical and logical analysis of the transformed operational raw data. With data warehouses and data marts, useful information is retained at the disposal of the decision-makers and users of analytic applications and may be distributed to data warehouse servers in a networked system. Additionally, decision-maker clients can retrieve analytical data resident on a remote data warehouse servers over a computer system network.
An example of the type of company that would use data warehousing is an online Internet bookseller having millions of customers located worldwide whose book preferences and purchases are tracked. By processing and warehousing these data, top executives of the bookseller can access the processed data from the data warehouse, which can be used for sophisticated analysis and to make key decisions on how to better serve the preferences of their customers throughout the world.
The rapid increase in the use of networking systems, including Wide Area Networks (WAN), the Worldwide Web and the Internet, provides the capability to transmit operational data into database applications and to share data contained in databases resident in disparate networked servers. For example, vast amounts of current transactional data are continuously generated by business-to-consumer and business-to-business electronic commerce conducted over the Internet. These transactional data are routinely captured and collected in an operational database for storage, processing, and distribution to databases in networked servers.
The expanding use of “messaging systems” and the like enhances the capacity of networks to transmit data and to provide interoperability between disparate database systems. Messaging systems are computer systems that allow logical elements of diverse applications to seamlessly link with one another. Messaging systems also provide for the delivery of data across a broad range of hardware and software platforms, and allow applications to interoperate across network links despite differences in underlying communications protocols, system architectures, operating systems, and database services. Messaging systems and the recent development of Internet access through wireless devices such as enabled cellular phones, two-way pagers, and hand-held personal computers, serve to augment the transmission and storage of data and the interoperability of disparate database systems.
In the current data warehouse/data mart networking environment, one general concern involves the sheer volume of data that must be dealt with. Often massive, multi-terabyte data files are stored in various server sites of data warehouses or in operational databases. Transmitting these massive amounts of data over WANs or the Internet is a troublesome task. The space needed to store the data is significant, and the transmission time is often lengthy.
Furthermore, accessing the resulting data is difficult on a wireless device due to the vast size of the data file. Portable and/or wireless services such as cellular phones, two-way pagers, and hand-held personal computers, have limited computational and display resources.
Accordingly, there is a need for a reliable, convenient and rapid method and/or system for the navigating through the large amounts of data, such as data in a data warehouse/mart. There is a further need to accomplish the navigation through the large amounts of data on a wireless device such as enabled cellular phones, two-way pagers, and hand-held personal computers.
SUMMARY OF INVENTION
The present invention provides a reliable, convenient and rapid method and/or system for the navigating through the large amounts of data, such as data in a data warehouse/mart. The present invention further provides a method and/or system for navigating through a large amount of data on a wireless device such as enabled cellular phones, two-way pagers, and hand-held personal computers.
Specifically, in one embodiment, the present invention accesses a source of formatted warehoused data. The present invention then displays a grid on a display device. In one embodiment, the grid is an iconic representation of the formatted warehoused data. The grid is comprised of elements, each element corresponding to some portion of the formatted warehoused data. In addition, a portion of the formatted warehoused data is displayed on the display device in response to a selection of a corresponding element of the grid.
In another embodiment, a source of formatted warehoused data is accessed. The formatted warehoused data is then distilled into a plurality of hierarchical overviews. In general, a hierarchical overview comprises a subtotal of selected entries from the formatted warehoused data. Specifically, in response to a first inquiry, a hierarchical overview is received.
BRIEF DESCRIPTION OF THE DRAWINGS
The accompanying drawings, which are incorporated in and form a part of this specification, illustrate embodiments of the invention and, together with the description, serve to explain the principles of the invention.
FIG. 1 illustrates a schematic block diagram of an exemplary client/server computer system network upon which embodiments of the present invention may be implemented.
FIG. 2 illustrates an exemplary computer system upon which embodiments of the present invention may be practiced.
FIG. 3 illustrates an exemplary display device in accordance with an embodiment of the present invention for navigating a large amount of data.
FIG. 4 is a flowchart of steps performed in accordance with an embodiment of the present invention for navigating a large amount of data.
FIGS. 5A-5C illustrate an exemplary version of formatted warehoused data in accordance with embodiments of the present invention for navigating a large amount of data.
FIG. 6 is a flowchart of steps performed in accordance with another embodiment of the present invention for navigating a large amount of data.
The drawings referred to in this description should be understood as not being drawn to scale except if specifically noted.
DETAILED DESCRIPTION
A method and system for the wireless delivery of data, including business metrics, transformed data, untransformed data, or raw data are described. In the following description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It will be obvious, however, to one skilled in the art that the present invention may be practiced without these specific details. In other instances, well-known structures and devices are shown in block diagram form in order to avoid obscuring the present invention.
Some portions of the detailed descriptions that follow are presented in terms of procedures, logic blocks, processing, and other symbolic representations of operations on data bits within a computer memory. These descriptions and representations are the means used by those skilled in the data processing arts to most effectively convey the substance of their work to others skilled in the art. In the present application, a procedure, logic block, process, etc., is conceived to be a self-consistent sequence of steps or instructions leading to a desired result. The steps are those requiring physical manipulations of physical quantities. Usually, though not necessarily, these quantities take the form of electrical or magnetic signals capable of being stored, transferred, combined, compared, and otherwise manipulated in a computer system. It has proven convenient at times, principally for reasons of common usage, to refer to these signals as bits, values, elements, symbols, characters, terms, numbers, or the like.
It should be borne in mind, however, that all of these and similar terms are to be associated with the appropriate physical quantities and are merely convenient labels applied to these quantities. Unless specifically stated otherwise as apparent from the following discussions, it is appreciated that throughout the present invention, discussions utilizing terms such as “transmitting”, “receiving”, “determining”, “creating”, “storing”, “delivering”, “accessing”, “generating”, “distilling”, “providing”, “displaying”, “outputting”, “compressing”, “decompressing” or the like, can refer to the actions and processes (e.g., processes 400 and 600 of FIGS. 4 and 6, respectively) of a computer system or similar electronic computing device. The computer system or similar electronic computing device manipulates and transforms data represented as physical (electronic) quantities within the computer system's registers and memories into other data similarly represented as physical quantities within the computer system memories or registers or other such information storage, transmission, or display devices.
FIG. 1 is a block diagram depicting one embodiment of a system 100 for the delivery of data, particularly the wireless delivery of data, in accordance with the present invention. Data sources 101 include one or more sources of data resulting from business and financial transactions, equipment performance logs, and the like.
These data sources can based on and formatted according to a Relational Database Management System (RDBMS) (such as from Oracle, Informix, Sybase, Microsoft, etc.), an Enterprise Resource Planning (ERP) system, Service Advertising Protocol (SAP), flat files, and other data transmission formats, either planned or envisioned, including XML, WML, HDML, HTML, and compact (lightweight) HTML.
Data storage 102 is for storing operational data and the like from data sources 101, typically using a high capacity mass storage device (such as hard disk drives, optical drives, tape drives, etc.). In one embodiment, data storage 102 is a data warehouse. Data storage 102 is coupled to a database management system (DBMS) 104 by analytic data interface 103. DBMS 104 executes an analytic application such as a data mart application. A repository 105 is coupled to (or integrated with) DBMS 104 for storing information from the database management system.
There are at least three styles of calculating data (e.g., business metrics): periodic, on demand, and continuous (real time). In the periodic style, data are calculated at predetermined intervals (e.g., hourly, daily, weekly, etc.) and stored in repository 105, and the most recent data are provided to the requester. In the on demand style, the data are calculated in response to a user request. These data may be cached or persisted in some manner (e.g., in repository 105), but do not exist or have value until they are initially requested. In the continuous (real time) style, data are updated as underlying data are updated. For example, a business metric describing the moving average for the inventory of a particular item gets updated as the inventory level for that item is updated. In each case, the requester gets the freshest data.
Returning to FIG. 1, in the present embodiment, an application server 106 is interposed between the DBMS 104 and a voice server 107 or the Internet 109. In one embodiment, application server 106 is accessible to users via a unique Uniform Resource Locator (URL). Application server 106 provides information (e.g., business metrics and transformed data, but also untransformed or raw data) to users from DBMS 104 and/or repository 105.
Voice server 107 provides voice-to-text and text-to-voice services for converting voice messages received from a user via a conventional telephone 110, and for similarly converting information from application server 106 into an audible message. A user can thereby access application server 106 using a conventional telephone 110 via voice server 107, and receive information from application server 106 via the same path. For security purposes, a firewall 108 encloses voice server 107, application server 106, and the other devices and components coupled with those devices on the internal side of the firewall.
Wireless gateway 111 enables communication between wireless devices and application server 106 within the framework of a wireless service provider (WSP). Wireless devices are exemplified as wireless phone 112 and PDA 113; however, it is appreciated that other types of wireless devices such as a pager or two-way pager, or any other data-capable or data-enabled device operable for wireless communication, may be used. Preferably, the wireless devices have display capability, but other means for conveying information to a user may be utilized. For example, information can be converted into an audible message (e.g., text-to-voice).
Coupled to the Internet 109 may be a computer system 114 that is also capable of communicating with application server 106. For example, information can be exchanged between computer system 114 and application server 106 via electronic mail (e-mail). Computer system 114 may also incorporate a Web browser or other such elements allowing it to access a Web site on application server 106 using the URL for application server 106.
In summary, system 100 supports a number of various different types of end-user devices, as well as different types of service providers (e.g., Internet Service Providers, WSPs, etc.). In accordance with the present invention, a user can register a variety of devices and device types utilizing different service providers, protocols (e.g., wireless application protocol (WAP)), Communication standards, and data formats, and use these devices to receive information (e.g., business metrics, etc.) at remote locations (e.g., at field locations worldwide).
FIG. 2 is a block diagram of an embodiment of an exemplary device 200 used in accordance with the present invention. It should be appreciated that device 200 of the present embodiment is well suited to be any type of computing device (e.g., server computer, portable computing device, desktop computer, mobile phone, pager, personal digital assistant, etc.). Within the following discussions of the present invention, certain processes and steps are discussed that are realized, in one embodiment, as a series of instructions (e.g., software program) that reside within computer readable memory units of device 200 and executed by a processor(s) of device 200. When executed, the instructions cause device 200 to perform specific actions and exhibit specific behavior which is described in detail herein.
Device 200 of FIG. 2 comprises an address/data bus 299 for communicating information, one or more central processors 201 coupled with bus 299 for processing information and instructions. Central processor unit(s) 201 may be a microprocessor or any other type of processor. The device 200 also includes data storage features such as a computer usable volatile memory unit 202 (e.g., random access memory, static RAM, dynamic RAM, etc.) coupled with bus 299 for storing information and instructions for central processor(s) 201, a computer usable nonvolatile memory unit 203 (e.g., read only memory, programmable ROM, flash memory, EPROM, EEPROM, etc.) coupled with bus 299 for storing static information and instructions for processor(s) 201. Device 200 also includes one or more signal generating and receiving devices 208 coupled with bus 299 for enabling device 200 to interface with other electronic devices and computer systems. The communication interface(s) 208 of the present embodiment may include wired and/or wireless communication technology. For example, within the present embodiment, the communication interface 208 may be a serial communication port, a Universal Serial Bus (USB), an Ethernet adapter, a Fire Wire (IEEE 1394) interface, a parallel port, a small computer system interface (SCSI) bus interface, infrared (IR) communication port, Bluetooth wireless communication port, a broadband interface, or an interface to the Internet, among others.
Optionally, device 200 may include an alphanumeric input device 206 including alphanumeric and function keys coupled to the bus 299 for communicating information and command selections to the central processor(s) 201. In one embodiment, alphanumeric input device 206 is a touch screen device; in this implementation, alphanumeric input device 206 is capable of registering a position where a stylus element (not shown) makes contact. The device 200 can include an optional cursor control or cursor directing device 207 coupled to the bus 299 for communicating user input information and command selections to the central processor (s) 201. The cursor-directing device 207 may be implemented using a number of well known devices such as a mouse, a track-ball, a track-pad, an optical tracking device, among others. In one embodiment, cursor control 207 is a touch screen device incorporated with display device 205. In this implementation, cursor control 207 is capable of registering a position on display device 205 where a stylus element makes contact. Alternatively, it is appreciated that a cursor may be directed and/or activated via input from the alphanumeric input device 206 using special keys and key sequence commands. The present embodiment is also well suited to directing a cursor by other means such as, for example, voice commands.
A display device 205 is coupled to bus 299 of device 200 for displaying video and/or graphics. It should be appreciated that display device 205 may be a cathode ray tube (CRT), flat panel liquid crystal display (LCD), field emission display (FED), plasma display or any other display device suitable for displaying video and/or graphic images and alphanumeric characters recognizable to a user. The device 200 of FIG. 2 may also include one or more optional computer usable data storage devices 204 such as a magnetic or optical disk and disk drive (e.g., hard drive or floppy diskette) coupled with bus 299 for storing information and instructions.
FIG. 3 illustrates an exemplary display device 205 in accordance with an embodiment of the present invention for navigating a large amount of data. Specifically, FIG. 3, in combination with process 400 of FIG. 4, enables a user of a device 200 to access a large amount of formatted warehoused data, such as formatted warehoused data 500 of FIG. 5A. Additionally, FIG. 3 in combination with process 400 enables the user of device 200 to easily navigate the formatted warehoused data 500. For example, when device 200 accesses a source of formatted data (e.g., analytic data interface 103 of FIG. 1), FIG. 3 portrays the formatted data in an easily navigable environment. In one embodiment, the easily navigable environment of display 205 includes a grid 330, grid elements 340, and a displayed portion of warehoused data 500.
In one embodiment, the source of formatted warehoused data (e.g., 500) is stored on a content server (e.g., application server 106). Furthermore, application server 106 may be a web server, WAP gateway, or the like. In addition, the present embodiment prevents a server timeout between application server 106 and device 200. Specifically, the timeout is prevented by utilizing a separate thread for query execution that also allows for query cancellation. In so doing, the “pipeline” between device 200 and application server 106 remains open until the user chooses to close it. Thus, during the accessing of formatted warehoused data 500, device 200 will not be disconnected from application server 106 if an amount of idle time has passed. Therefore, the user of device 200 is does not have to re-access the formatted warehoused data 500 and re-enter a password.
More specifically, the formatted warehoused data 500 may be formatted in a cross-tabular manner (as a “report”). In addition, formatted warehouse data 500 is presented in a scaled iconic representation on display 205. In one embodiment, grid 330 is the scaled iconic representation of the formatted warehoused data 500 shown on a portion of display 205. Specifically, grid 330 is comprised of many elements, such as 340 and 344, which correspond to some portion of formatted warehoused data 500. An element in grid 330 may correspond to an entry in formatted warehoused data 500, or an element may correspond to multiple entries.
In addition, by selecting different elements (e.g., 340, 344, etc.) located within grid 330, a user can easily navigate the entire formatted warehoused data 500. As mentioned, each element 340 represents some portion of the total formatted warehoused data 500. Therefore, if a user desires to view a specific portion of the formatted warehoused data 500, the user need only select an element, such as element 340, from grid 330. In one embodiment, the user selects an element by contacting display device 205 with a stylus element, as described above. Upon selection of an element, such as element 340, a corresponding portion 310 of the formatted warehoused data 500 is downloaded to, and displayed on, display device 205. Hence, a user can easily read portion 310 on display device 205 without being overwhelmed with the entire formatted warehoused data 500 file.
Furthermore, by utilizing the iconic representation (e.g., grid 330), a user can intuitively deduce the size of the formatted warehoused data 500 being navigated. In one embodiment, display device 205 further utilizes analytic data interface 103 in conjunction with repository 105 to download only portion 310 to display device 205. Therefore, device 200 is not overloaded with the entire version of formatted warehoused data 500, but instead receives only the portion 310 selected for viewing.
Furthermore, in one embodiment, the corresponding portion 310 of grid 330 may retain the axis labels of the formatted warehoused data 500 while the user navigates through grid 330. For example, in the initial representation of portion 310 both a row 320 label and a column 325 label are included. The content of row 320 and column 325 will pertain to the content of element 340. If element 344 is then selected as the next portion 310 to be represented, the column 325 and row 320 will remain a visual part of portion 310; however, the content of row 320 and column 325 will now pertain to the content of element 344. Even if the user selects an element (e.g., 344) of grid 330 that does not intrinsically include column 325 and row 320 headings, column 325 and row 320 headings will remain in the displayed portion 310.
In one embodiment, elements of grid 330 can be navigated upon display device 205 with the use of alpha-numeric input 206 (e.g. hot keys, keyboard arrows, etc.) and/or a graphical user interface (GUI) displayed on device 200. Examples of a GUI may include, but not limited to, a cursor 375, or scrolling arrows 350. The actual navigation of grid 330 can therefore be accomplished by scrolling through the elements (e.g., 340, 344) utilizing scrolling arrows 350, cursor 375, stylus element, or any specified keys. In addition, a specific element, such as element 340 or element 344, of grid 330 may be selected by utilizing hot keys, cursor 375, stylus element, etc., to choose the desired element (e.g., 340, 344) for viewing.
With reference still to FIG. 3, examples of device 200 may include, but are not limited to, a mobile phone, and a portable-computing device (e.g. personal digital assistant, pager, and the like). It is also appreciated, that in one embodiment, the element (e.g., 340) of grid 330 which is displayed as portion 310 may be visually modified (e.g., highlighted, darkened, lightened, shaded, etc.) to signify the element (e.g., 340) of grid 330 presently being viewed.
In the present embodiment, the dimensions of grid 330, element 340, and displayed portion 310 are all adjusted by analytic data interface 103 according to specific metrics supplied to analytic data interface 103 by device 200. For example, if device 200 has a display 205 of x-by-y dimensions, then analytic data interface 103 formats the warehoused data 500 such that a presentation of size x-by-y dimensions will appear on display device 205. Therefore, the present method for navigating a large amount of data can account for the characteristics of the display 205 utilized by device 200, and thus can be used with a variety of such devices.
FIG. 4 is a flowchart 400 of the steps performed in accordance with an embodiment of the present invention for navigating a large amount of data. Flowchart 400 includes processes of the present invention which, in one embodiment, are carried out by processors and electrical components under the control of computer readable and computer executable instructions. The computer readable and computer executable instructions may reside, for example, in data storage features such as data storage device 202, 203, and/or 204 of FIG. 2. However, the computer readable and computer executable instructions may reside in any type of computer readable medium. Although specific steps are disclosed in flowchart 400, such steps are exemplary. That is, the present embodiment is well suited to performing various other steps or variations of the steps recited in FIG. 4. Within the present embodiment, it should be appreciated that the steps of flowchart 400 may be performed by software, by hardware, or by any combination of software and hardware.
With reference now to step 402 of FIG. 4, the present embodiment causes device 200 to access a source of formatted warehouse data (e.g., 500 of FIG. 5A). It is understood that step 402 may be implemented in a wide variety of ways in accordance with an embodiment of the present invention. For example, the present embodiment may cause device 200 to access formatted warehouse data 500 in any manner similar to that described herein.
In step 404 of FIG. 4, the present embodiment causes device 200 to display a grid 330 on display device 205 (FIG. 3). In general, grid 330 is an iconic representation of the formatted warehoused data 500. It is further appreciated that grid 330 is comprised of elements, such as element 340. In addition, each element (e.g., 340) corresponds to a portion of the formatted warehouse data 500. It is understood that step 404 may be implemented in a wide variety of ways in accordance with an embodiment of the present invention. For example, at step 404, the present embodiment may cause device 200 to display a grid 330 in any manner similar to that described herein.
At step 406 of FIG. 4, the present embodiment causes the device (e.g. 200) to display a portion of the formatted warehoused data 500 on the display (e.g., 205) in response to a selection of a corresponding element (e.g. 340) of grid 330. Step 406 may be performed in diverse ways in accordance with an embodiment of the present invention. For example, the present embodiment may cause device 200 to display a portion of the formatted warehoused data 500 on display 205 in response to a selection of a corresponding element of grid 330 in any manner similar to that described herein.
FIGS. 5A-5C illustrate exemplary versions of formatted warehoused data in accordance with an embodiment of the present invention for navigating a large amount of data. Specifically, formatted warehoused data 500 is a cross-tabular illustration of one embodiment for representing the formatted warehoused data stored in repository 105. Although a specific cross-tabular version of formatted warehoused data 500 is shown, many organizational formats of warehoused data 500 may be used. The cross-tabular format is shown merely for purposes of brevity and clarity.
With reference still to FIGS. 5B-5C, the present embodiment illustrates further hierarchical overview versions of FIG. 5A. Specifically, FIGS. 5B-5C are subtotal versions of the initial formatted warehoused data 500. In one embodiment, subtotaling data is a method for dynamically rolling formatted warehoused data 500 up to a higher level to make it more digestible. Specifically, subtotaling refers to trying to distill as much information as possible from a larger more detailed table of data. That is, table 520 is a subtotal of table 500, table 540 is a subtotal of table 520. Therefore, table 540 shows the least amount of detail while table 500 shows the most detail. It is appreciated that tables 500, 520, and 540 are exemplary and are shown in the present embodiment merely for purposes of clarity.
FIG. 6 is a flowchart of the steps performed in accordance with an embodiment of the present invention for navigating a large amount of data. Flowchart 600 includes processes of the present invention which, in one embodiment, are carried out by processors and electrical components under the control of computer readable and computer executable instructions. The computer readable and computer executable instructions may reside, for example, in data storage features such as data storage device 202, 203, and/or 204 of FIG. 2. However, the computer readable and computer executable instructions may reside in any type of computer readable medium. Although specific steps are disclosed in flowchart 600, such steps are exemplary. That is, the present embodiment is well suited to performing various other steps or variations of the steps recited in FIG. 6. Within the present embodiment, it should be appreciated that the steps of flowchart 600 may be performed by software, by hardware, or by any combination of software and hardware.
In one embodiment, process 600 is an exemplary process for navigating a large amount of formatted warehoused data 500 utilizing voice commands. In general, device 200 may be any device which can transmit and/or receive voice data, such as, but not limited to, a regular phone 110, wireless phone 112, PDA 113, and/or computer system 114. Further, in one embodiment, the formatted warehoused data 500 of process 600 is the same formatted warehoused data 500 of process 400. However, due to the voice navigation abilities of process 600, the format in which analytic data interface 103 represents the formatted warehoused data 500 to process 600 may be different
For example, in one embodiment, process 600 uses a voice recognition interface, such as voice server 107, to convey easily digestible portions of formatted warehoused data 500. In one embodiment, voice server 107 conveys inquiries and responses to inquiries audibly according to a voice-based communications protocol.
In order to distill the formatted warehoused data 500 into pieces that can be readily conveyed by voice, analytic data interface 103 formats the warehoused data 500 into a plurality of hierarchical overviews (e.g., FIGS. 5A-5C). Specifically, formatted warehoused data 500 is reduced in scope by subtotaling the contents thereof. Then, at each subtotal (e.g. overview), a user has the option of drilling deeper into a specific result in order to review the underlying data. For example, if process 600 were to deliver an initial hierarchical overview (e.g., table 540 of FIG. 5C) to device 200, the initial information received in response to an inquiry may be a quantity statement then a cost statement. The user may then wish to hear more information or hear the information from a different perspective by selecting a new level of clarity. For example, in a report with Year and Product attributes, the user could first hear sub-totaled metric values for a given year for all products. Then after selecting a specific product, they could hear the metric values for the given year for the selected product. In order to obtain this information, the user formulates an inquiry. In one embodiment, the user accomplishes this with a voice command.
Process 600 may respond with the quantities NA, NB, NC of each product A, B, C. The user can drill down to the next level (e.g., table 510 of FIG. 5A) by initiating an inquiry for more information about one of the products in particular (e.g., product A), receiving in response a breakdown of the components of the quantity NA. Such “drilling down” can be continued in infinitum.
In general, a report exemplified by table 500 of FIG. 5A is generated and resides in applications server 106 of FIG. 1. When a user at a wireless device accesses this information, instead of hearing an item-by-item recitation of all the entries in table 500. A hierarchical overview such as that of table 540 is heard. The user can then select one of the items in the hierarchical overview, and receive more details about that item. This process can be repeated until the user reaches the desired level of detail. Thus, according to the present invention, a user can receive detailed information using a voice based communications system, but without having to hear an item-by-item recitation of a multitude of entries. The present invention thus provides a ready mechanism for navigating through a large table of data using voice commands.
With reference still to process 600, any hierarchical overview is possible with respect to the present embodiment, the examples with regard to FIGS. 5A-5C are shown merely as one example of a multitude of possible overview breakdown criteria. It is further appreciated that the present process 600 can be performed on a screen and may not require voice cues at all. In fact, the hierarchical overview utilized in process 600 may respond to voice inquiries, hot key inquiries, a single click of a cursor, or any other possible input features which are known to one skilled in the art.
Another embodiment for navigating a large amount of formatted warehoused data 500 on a display device 200 (of FIG. 2) is described herein. Specifically, the formatted warehoused data of table 500 may be represented in a row-by-row format instead of the subtotal format as described above. For example, each row of data from table 500 may be represented in a row-by-row fashion on display 205. This type of format may be useful when a table of data (e.g., 500) contains many rows but few columns. Thus instead of viewing a small table (e.g., table 540) with a limited amount of subtotaled data, the user may choose to view the formatted warehoused data 500 by row. Such a row-by-row format will allow a user to gain a useful view of a table while not being overwhelmed with the entire table (e.g. 500).
In addition, the row-by-row method for displaying formatted warehoused data 500, on device 200 may further “freeze” a row for comparison purposes. That is, in the same way as the row 320 and column 325 (of FIG. 3) headings were maintained on display 205, a specific row of data may be held on display 205. Therefore, a user may compare one specific row with many different rows throughout the table. For example, if one row is of particular interest, the user may navigate throughout the other rows of a table (e.g., table 500) while maintaining the desired row as a fixed part on display 205.
With reference now to step 602 of FIG. 6, the present embodiment causes device 200 to access a source of formatted warehouse data. It is understood that step 602 may be implemented in a wide variety of ways in accordance with an embodiment of the present invention. For example, the present embodiment may cause device 200 to access formatted warehouse data in any manner similar to that described herein. It is further appreciated that device 200 may be any device which can transmit and receive voice data, such as, but not limited to, a regular phone 110, wireless phone 112, PDA 113, computer system 114. 7.
At step 604 of FIG. 6, the present embodiment causes formatted warehoused data 500 to be distilled into a plurality of hierarchical overviews (e.g. 500, 520, and 540 of FIGS. 5A-5C). Further, the hierarchical overviews (e.g. 500, 520, and 540) comprise a subtotal of selected entries from the formatted warehoused data 500. Step 604 may be performed in a variety of ways in accordance with embodiment of the present invention. For example, the present embodiment may cause formatted warehoused data 500 to be distilled into a plurality of hierarchical overviews (e.g. 500, 520, and 540) in any manner similar to that described herein.
At step 606 of FIG. 6, the present embodiment causes device (e.g., 200) to receive a hierarchical overview (e.g. 540) in response to a first inquiry. Step 606 may be performed in a variety of ways in accordance with embodiment of the present invention. For example, the present embodiment may cause device 200 to receive a hierarchical overview 540 in any manner similar to that described herein.
Thus, the present invention provides a reliable, convenient and rapid method and/or system for the navigating through the large amounts of data, such as data in a data warehouse/mart. The present invention further provides a method and/or system for navigating through a large amount of data on a wireless device such as enabled cellular phones, two-way pagers, and hand-held personal computers.
The foregoing descriptions of specific embodiments of the present invention have been presented for purposes of illustration and description. They are not intended to be exhaustive or to limit the invention to the precise forms disclosed, and obviously many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and its practical application, to thereby enable others skilled in the art to best utilize the invention and various embodiments with various modifications are suited to the particular use contemplated. It is intended that the scope of the invention be defined by the Claims appended hereto and their equivalents.

Claims (30)

What is claimed is:
1. A method for navigating a large amount of formatted warehouse data, said the method comprising:
accessing a source of the formatted warehoused data;
displaying a grid on a display device, said the grid being an iconic representation of said the formatted warehoused data, said the grid comprising elements, each element corresponding to some portion of said the formatted warehoused data; and
displaying a portion of said the formatted warehoused data on said the display device, the portion concurrently displayed with and visually distinguished from the grid, in response to a selection of a corresponding element of said the grid.
2. The method as recited in claim 1, wherein content server timeouts are prevented while accessing said the source of formatted data.
3. The method as recited in claim 1, wherein said the warehoused data is formatted in a cross-tabular manner.
4. The method as recited in claim 1, wherein said the portion of said the formatted warehoused data is indicated by a distinctive marking of said the corresponding element of said the grid.
5. The method as recited in claim 1, wherein only said the portion of said the formatted warehoused data is downloaded to said the display device in response to said the selection.
6. The method as recited in claim 1, wherein a different portion of said the formatted warehoused data is displayed on said the display device by selecting a different element of said the grid.
7. The method as recited in claim 1, wherein a graphical user interface (GUI) comprising a cursor and scrolling arrows is also displayed on said the display device.
8. The method as recited in claim 7, wherein a different portion of said the formatted warehoused data is displayed by utilizing said the GUI to navigate within said the grid and to select a different element of said the grid.
9. A device comprising:
a bus;
a display coupled with said the bus;
a memory unit coupled with said the bus; and
a processor coupled with said the bus, said the processor for executing a method for navigating a large amount of data, said the method comprising:
accessing a source of formatted warehoused data;
displaying a grid on said the display, said the grid being an iconic representation of said the formatted warehoused data, said the grid comprising elements, each element corresponding to some portion of said the formatted warehoused data; and
displaying a portion of said the formatted warehoused data on said the display, the portion concurrently displayed with and visually distinguished from the grid, in response to a selection of a corresponding element of said the grid.
10. The device of claim 9, wherein content server timeouts are prevented while accessing said the source of formatted data.
11. The device of claim 9, wherein said the warehoused data is formatted in a cross-tabular manner.
12. The device of claim 9, wherein said the portion of said the formatted warehoused data is indicated by a distinctive marking of said the corresponding element of said the grid.
13. The device of claim 9, wherein only said the portion of said the formatted warehoused data is downloaded in response to said the selection.
14. The device of claim 9, wherein a different portion of said the formatted warehoused data is displayed on said the display by selecting a different element of said the grid.
15. The device of claim 9, wherein a graphical user interface (GUI) comprising a cursor and scrolling arrows is also displayed on said the display.
16. The device of claim 15, wherein a different portion of said the formatted warehoused data is displayed by utilizing said the GUI to navigate within said the grid and to select a different element of said the grid.
17. A The method for navigating a large amount of data, said method as recited in claim 1, further comprising:
accessing a source of formatted warehoused data;
distilling said the formatted warehoused data into a plurality of hierarchical overviews, wherein a hierarchical overview comprises a subtotal of selected entries from said the formatted warehoused data; and
receiving a hierarchical overview in response to a first inquiry, the received hierarchical overview corresponding to the portion.
18. The method as recited in claim 17, wherein content server timeouts are prevented while accessing said the source of formatted data.
19. The method as recited in claim 17, wherein the formatted warehoused data is formatted in a cross-tabular manner.
20. The method as recited in claim 17, wherein said the device is a communications device.
21. The method as recited in claim 17, wherein information about said the selected entries is received in response to a subsequent inquiry.
22. The method as recited in claim 17, wherein inquiries and responses to inquiries are conveyed audibly according to a voice-based communications protocol.
23. The method as recited in claim 21, wherein a response to an inquiry is displayed.
24. A The device of claim 9, the processor for executing the method further comprising:
a bus;
a memory unit coupled with said bus; and
a processor coupled with said bus, said processor for executing a method for navigating a large amount of data, said method comprising:
accessing a source of formatted warehoused data;
distilling said the formatted warehoused data into a plurality of hierarchical overviews, wherein a hierarchical overview comprises a subtotal of selected entries from said the formatted warehoused data; and
receiving a hierarchical overview in response to a first inquiry, the received hierarchical overview corresponding to the portion.
25. The device of claim 24, wherein content server timeouts are prevented while accessing said the source of formatted data.
26. The device of claim 24, wherein the formatted warehoused data is formatted in a cross-tabular manner.
27. The device of claim 24, wherein said the device is a communications device.
28. The device of claim 24, wherein information about said the selected entries is received in response to a subsequent inquiry.
29. The device of claim 24, wherein inquiries and responses to inquiries are conveyed audibly according to a voice-based communications protocol.
30. The device of claim 28, wherein a response to an inquiry is displayed.
US11/122,214 2002-02-22 2005-05-03 Method and system for navigating a large amount of data Expired - Lifetime USRE44478E1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US11/122,214 USRE44478E1 (en) 2002-02-22 2005-05-03 Method and system for navigating a large amount of data

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/082,486 US6820077B2 (en) 2002-02-22 2002-02-22 Method and system for navigating a large amount of data
US11/122,214 USRE44478E1 (en) 2002-02-22 2005-05-03 Method and system for navigating a large amount of data

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
US10/082,486 Reissue US6820077B2 (en) 2002-02-22 2002-02-22 Method and system for navigating a large amount of data

Publications (1)

Publication Number Publication Date
USRE44478E1 true USRE44478E1 (en) 2013-09-03

Family

ID=27753109

Family Applications (2)

Application Number Title Priority Date Filing Date
US10/082,486 Ceased US6820077B2 (en) 2002-02-22 2002-02-22 Method and system for navigating a large amount of data
US11/122,214 Expired - Lifetime USRE44478E1 (en) 2002-02-22 2005-05-03 Method and system for navigating a large amount of data

Family Applications Before (1)

Application Number Title Priority Date Filing Date
US10/082,486 Ceased US6820077B2 (en) 2002-02-22 2002-02-22 Method and system for navigating a large amount of data

Country Status (5)

Country Link
US (2) US6820077B2 (en)
EP (1) EP1479015A2 (en)
AU (1) AU2003216336A1 (en)
CA (1) CA2476788C (en)
WO (1) WO2003073328A2 (en)

Families Citing this family (33)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7083438B2 (en) * 2002-01-18 2006-08-01 International Business Machines Corporation Locking covers for cable connectors and data ports for use in deterring snooping of data in digital data processing systems
US20030149603A1 (en) * 2002-01-18 2003-08-07 Bruce Ferguson System and method for operating a non-linear model with missing data for use in electronic commerce
JP3914861B2 (en) * 2002-11-29 2007-05-16 Necインフロンティア株式会社 Communications system
US20040128000A1 (en) * 2002-12-26 2004-07-01 Phillips Larry S. Recipe control system and method
TW591500B (en) * 2003-01-09 2004-06-11 Darfon Electronics Corp Input apparatus having scrolling function using cursor key and method thereof
US20050071318A1 (en) * 2003-09-30 2005-03-31 International Business Machines Corporation Complex table rendering and navigation with highly constrained devices
FR2863081A1 (en) * 2003-12-01 2005-06-03 Thomson Licensing Sa DEVICE AND METHOD FOR EXTRACTING INFORMATION FROM A DATABASE AND ASSOCIATED PRODUCTS
US7447647B1 (en) 2005-05-02 2008-11-04 Shedlack David G Techniques and definition logic embodied in a computer program product stored and performed on a computerized device for providing a singular graphical user interface configured to enable a user to create/manage/transact/report and view all full granular reference product data in a configurable transactable aggregate form
US7779346B2 (en) * 2006-10-03 2010-08-17 Research In Motion Limited System and method for freezing columns and rows in a UI table
US20080140696A1 (en) * 2006-12-07 2008-06-12 Pantheon Systems, Inc. System and method for analyzing data sources to generate metadata
CA2578980A1 (en) 2007-02-19 2008-08-19 Cognos Incorporated System and method of report rendering
WO2008134627A2 (en) 2007-04-27 2008-11-06 Boomi, Inc. System and method for automated on-demand creation of a customized software application
US20100010965A1 (en) * 2008-07-08 2010-01-14 International Business Machines Corporation Query Management Systems
WO2010065511A1 (en) 2008-12-02 2010-06-10 Ab Initio Software Llc Mapping instances of a dataset within a data management system
CN103180826B (en) 2010-10-25 2017-04-05 起元技术有限责任公司 Object data set is managed in the data flow diagram for represent computer program
WO2012097278A1 (en) 2011-01-14 2012-07-19 Ab Initio Technology Llc Managing changes to collections of data
US9710282B2 (en) 2011-12-21 2017-07-18 Dell Products, Lp System to automate development of system integration application programs and method therefor
US8943076B2 (en) 2012-02-06 2015-01-27 Dell Products, Lp System to automate mapping of variables between business process applications and method therefor
US8805716B2 (en) 2012-03-19 2014-08-12 Dell Products, Lp Dashboard system and method for identifying and monitoring process errors and throughput of integration software
US8782103B2 (en) 2012-04-13 2014-07-15 Dell Products, Lp Monitoring system for optimizing integrated business processes to work flow
US9158782B2 (en) 2012-04-30 2015-10-13 Dell Products, Lp Cloud based master data management system with configuration advisor and method therefore
US9015106B2 (en) 2012-04-30 2015-04-21 Dell Products, Lp Cloud based master data management system and method therefor
US9606995B2 (en) 2012-04-30 2017-03-28 Dell Products, Lp Cloud based master data management system with remote data store and method therefor
US8589207B1 (en) 2012-05-15 2013-11-19 Dell Products, Lp System and method for determining and visually predicting at-risk integrated processes based on age and activity
US9069898B2 (en) 2012-05-31 2015-06-30 Dell Products, Lp System for providing regression testing of an integrated process development system and method therefor
US9092244B2 (en) 2012-06-07 2015-07-28 Dell Products, Lp System for developing custom data transformations for system integration application programs
US20140047310A1 (en) * 2012-08-13 2014-02-13 Business Objects Software Ltd. Mobile drilldown viewer for standardized data
US10489360B2 (en) * 2012-10-17 2019-11-26 Ab Initio Technology Llc Specifying and applying rules to data
US9372942B1 (en) 2013-03-15 2016-06-21 Dell Software Inc. System and method for facilitating data visualization via a map-reduce framework
US9183074B2 (en) 2013-06-21 2015-11-10 Dell Products, Lp Integration process management console with error resolution interface
AU2015289442B2 (en) 2014-07-18 2019-07-11 Ab Initio Technology Llc Managing lineage information
US9626393B2 (en) 2014-09-10 2017-04-18 Ab Initio Technology Llc Conditional validation rules
US10498858B2 (en) 2016-12-14 2019-12-03 Dell Products, Lp System and method for automated on-demand creation of and execution of a customized data integration software application

Citations (132)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5404513A (en) 1990-03-16 1995-04-04 Dimensional Insight, Inc. Method for building a database with multi-dimensional search tree nodes
US5403147A (en) 1991-06-28 1995-04-04 Kao Corporation Method for warehousing and delivery of articles
US5405531A (en) 1993-02-16 1995-04-11 Geo-Microbial Technologies, Inc. Method for reducing the amount of and preventing the formation of hydrogen sulfide in an aqueous system
US5410688A (en) 1989-07-21 1995-04-25 Hewlett-Packard Company Distributed object based systems for communicating object data among different storage domains
US5420688A (en) 1992-12-14 1995-05-30 Farah; John Interferometric fiber optic displacement sensor
US5455945A (en) 1993-05-19 1995-10-03 Vanderdrift; Richard System and method for dynamically displaying entering, and updating data from a database
US5511190A (en) 1995-01-20 1996-04-23 Tandem Computers, Inc. Hash-based database grouping system and method
US5519859A (en) 1993-11-15 1996-05-21 Grace; John A. Method and apparatus for automatic table selection and generation of structured query language instructions
US5537589A (en) 1994-06-30 1996-07-16 Microsoft Corporation Method and system for efficiently performing database table aggregation using an aggregation index
US5563999A (en) 1990-10-19 1996-10-08 Moore Business Forms, Inc. Forms automation system
US5603024A (en) 1993-10-08 1997-02-11 International Business Machines Corporation Lossless distribution of time series data in a relational data base network
US5655101A (en) 1993-06-01 1997-08-05 International Business Machines Corporation Accessing remote data objects in a distributed memory environment using parallel address locations at each local memory to reference a same data object
US5675785A (en) 1994-10-04 1997-10-07 Hewlett-Packard Company Data warehouse which is accessed by a user using a schema of virtual tables
US5692181A (en) 1995-10-12 1997-11-25 Ncr Corporation System and method for generating reports from a computer database
US5706495A (en) 1996-05-07 1998-01-06 International Business Machines Corporation Encoded-vector indices for decision support and warehousing
US5708828A (en) 1995-05-25 1998-01-13 Reliant Data Systems System for converting data from input data environment using first format to output data environment using second format by executing the associations between their fields
US5713020A (en) 1993-09-02 1998-01-27 Microsoft Corporation Method and system for generating database queries containing multiple levels of aggregation
US5721911A (en) 1996-06-25 1998-02-24 International Business Machines Corporation Mechanism for metadata for an information catalog system
US5721903A (en) 1995-10-12 1998-02-24 Ncr Corporation System and method for generating reports from a computer database
US5778355A (en) 1996-06-11 1998-07-07 International Business Machines Corp. Database method and apparatus for interactively retrieving data members and related members from a collection of data
US5781911A (en) 1996-09-10 1998-07-14 D2K, Incorporated Integrated system and method of data warehousing and delivery
US5787415A (en) 1996-10-30 1998-07-28 International Business Machines Corporation Low maintenance data delivery and refresh system for decision support system database
US5794246A (en) 1997-04-30 1998-08-11 Informatica Corporation Method for incremental aggregation of dynamically increasing database data sets
US5794030A (en) 1995-12-04 1998-08-11 Objectivity, Inc. System and method for maintenance and deferred propagation of schema changes to the affected objects in an object oriented database
US5794228A (en) 1993-04-16 1998-08-11 Sybase, Inc. Database system with buffer manager providing per page native data compression and decompression
US5794229A (en) 1993-04-16 1998-08-11 Sybase, Inc. Database system with methodology for storing a database table by vertically partitioning all columns of the table
US5799310A (en) 1995-05-01 1998-08-25 International Business Machines Corporation Relational database extenders for handling complex data types
US5806060A (en) 1992-11-06 1998-09-08 Ncr Corporation Interactive data analysis employing a knowledge base
US5822751A (en) 1996-12-16 1998-10-13 Microsoft Corporation Efficient multidimensional data aggregation operator implementation
US5826258A (en) 1996-10-02 1998-10-20 Junglee Corporation Method and apparatus for structuring the querying and interpretation of semistructured information
US5832496A (en) 1995-10-12 1998-11-03 Ncr Corporation System and method for performing intelligent analysis of a computer database
US5842213A (en) 1997-01-28 1998-11-24 Odom; Paul S. Method for modeling, storing, and transferring data in neutral form
US5848415A (en) 1996-12-18 1998-12-08 Unisys Corporation Selective multiple protocol transport and dynamic format conversion in a multi-user network
US5854890A (en) 1996-10-15 1998-12-29 National Instruments Corporation Fieldbus function block shell with user selectable data ownership
US5857197A (en) 1997-03-20 1999-01-05 Thought Inc. System and method for accessing data stores as objects
US5870746A (en) 1995-10-12 1999-02-09 Ncr Corporation System and method for segmenting a database based upon data attributes
US5870747A (en) 1996-07-09 1999-02-09 Informix Software, Inc. Generalized key indexes
US5873102A (en) 1997-04-29 1999-02-16 Oracle Corporation Pluggable tablespaces on a transportable medium
US5884262A (en) 1996-03-28 1999-03-16 Bell Atlantic Network Services, Inc. Computer network audio access and conversion system
US5898431A (en) 1996-12-31 1999-04-27 International Business Machines Corporation Database graphical user interface with calendar view
WO1999024922A1 (en) 1997-11-07 1999-05-20 Informatica Corporation Apparatus and method
US5915019A (en) 1995-02-13 1999-06-22 Intertrust Technologies Corp. Systems and methods for secure transaction management and electronic rights protection
US5933796A (en) * 1996-08-09 1999-08-03 Hitachi, Ltd. Data extracting system based on characteristic quantities of data distribution
US5982890A (en) 1996-05-24 1999-11-09 Hitachi, Ltd. Method and system for detecting fraudulent data update
US5987454A (en) 1997-06-09 1999-11-16 Hobbs; Allen Method and apparatus for selectively augmenting retrieved text, numbers, maps, charts, still pictures and/or graphics, moving pictures and/or graphics and audio information from a network resource
US5991742A (en) 1996-05-20 1999-11-23 Tran; Bao Q. Time and expense logging system
US6003024A (en) 1997-07-25 1999-12-14 Amazon. Com System and method for selecting rows from dimensional databases
US6002402A (en) 1997-04-09 1999-12-14 Symantec Corporation System and method for producing a drag-and-drop object from a popup menu item
WO2000004466A1 (en) 1998-07-15 2000-01-27 Informatica Corporation Method and architecture for automated optimization of etl throughput in data warehousing applications
US6026388A (en) 1995-08-16 2000-02-15 Textwise, Llc User interface and other enhancements for natural language information retrieval system and method
WO2000008581A1 (en) 1998-08-03 2000-02-17 Harvest Technology, Inc. Dynamic flow-through context switching of investment data into multiple investment tools
US6032145A (en) 1998-04-10 2000-02-29 Requisite Technology, Inc. Method and system for database manipulation
US6032158A (en) 1997-05-02 2000-02-29 Informatica Corporation Apparatus and method for capturing and propagating changes from an operational database to data marts
US6044374A (en) 1997-11-14 2000-03-28 Informatica Corporation Method and apparatus for sharing metadata between multiple data marts through object references
US6065007A (en) 1998-04-28 2000-05-16 Lucent Technologies Inc. Computer method, apparatus and programmed medium for approximating large databases and improving search efficiency
US6078994A (en) 1997-05-30 2000-06-20 Oracle Corporation System for maintaining a shared cache in a multi-threaded computer environment
US6119167A (en) 1997-07-11 2000-09-12 Phone.Com, Inc. Pushing and pulling data in networks
US6122628A (en) 1997-10-31 2000-09-19 International Business Machines Corporation Multidimensional data clustering and dimension reduction for indexing and searching
US6128624A (en) 1997-11-12 2000-10-03 Ncr Corporation Collection and integration of internet and electronic commerce data in a database during web browsing
EP1043671A2 (en) 1999-03-19 2000-10-11 International Business Machines Corporation Message broker providing a publish/subscribe service and method of processing messages in a publish/subscribe environment
US6141699A (en) 1998-05-11 2000-10-31 International Business Machines Corporation Interactive display system for sequential retrieval and display of a plurality of interrelated data sets
US6151601A (en) 1997-11-12 2000-11-21 Ncr Corporation Computer architecture and method for collecting, analyzing and/or transforming internet and/or electronic commerce data for storage into a data storage area
US6151584A (en) 1997-11-20 2000-11-21 Ncr Corporation Computer architecture and method for validating and collecting and metadata and data about the internet and electronic commerce environments (data discoverer)
GB2350758A (en) 1999-06-04 2000-12-06 Ibm Message broker providing a publish/subscribe sevice and method of processing messages in a publish/subscribe environment
WO2000077707A1 (en) 1999-06-11 2000-12-21 Onecore Financial Network, Inc. Method and system for allowing a financial consultant to manage a plurality of business accounts
US6173310B1 (en) 1999-03-23 2001-01-09 Microstrategy, Inc. System and method for automatic transmission of on-line analytical processing system report output
US6192364B1 (en) 1998-07-24 2001-02-20 Jarg Corporation Distributed computer database system and method employing intelligent agents
US6205472B1 (en) 1998-09-18 2001-03-20 Tacit Knowledge System, Inc. Method and apparatus for querying a user knowledge profile
WO2001024040A1 (en) 1999-09-30 2001-04-05 Hnc Software, Inc. Webstation: configurable web-based workstation for reason driven data analysis
US6216125B1 (en) 1998-07-02 2001-04-10 At&T Corp. Coarse indexes for a data warehouse
US6233575B1 (en) 1997-06-24 2001-05-15 International Business Machines Corporation Multilevel taxonomy based on features derived from training documents classification using fisher values as discrimination values
EP0987868A3 (en) 1998-09-14 2001-05-23 Phone.Com Inc. Method and architecture for interactive two-way communication devices to interact with a network
GB2357596A (en) 1999-12-20 2001-06-27 Univ London A navigation engine for assessing the quality of a trail between linked pages
US6269369B1 (en) 1997-11-02 2001-07-31 Amazon.Com Holdings, Inc. Networked personal contact manager
US6269336B1 (en) 1998-07-24 2001-07-31 Motorola, Inc. Voice browser for interactive services and methods thereof
US6272598B1 (en) 1999-03-22 2001-08-07 Hewlett-Packard Company Web cache performance by applying different replacement policies to the web cache
US6272485B1 (en) 1999-02-18 2001-08-07 Creative Internet Applications, Inc. Transferring selected formatted documents over a computer network using interface script
US6292657B1 (en) 1998-07-13 2001-09-18 Openwave Systems Inc. Method and architecture for managing a fleet of mobile stations over wireless data networks
US6308203B1 (en) 1997-10-14 2001-10-23 Sony Corporation Information processing apparatus, information processing method, and transmitting medium
WO2001018728A8 (en) 1999-09-10 2001-12-13 Getapproved Com Llc Computer-implemented dynamic financial mentor
EP1164511A2 (en) 2000-06-16 2001-12-19 Cognos Incorporated Method of managing slowly changing dimensions
US6336137B1 (en) 2000-03-31 2002-01-01 Siebel Systems, Inc. Web client-server system and method for incompatible page markup and presentation languages
US6339775B1 (en) 1997-11-07 2002-01-15 Informatica Corporation Apparatus and method for performing data transformations in data warehousing
US20020035565A1 (en) 2000-04-27 2002-03-21 Arun Shah Graphical user interface for relational database
US6369840B1 (en) * 1999-03-10 2002-04-09 America Online, Inc. Multi-layered online calendaring and purchasing
US6385604B1 (en) 1999-08-04 2002-05-07 Hyperroll, Israel Limited Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
US20020056081A1 (en) 1999-12-02 2002-05-09 Qualcomm Incorporated Apparatus and method for decoding digital image and audio signals
US20020059267A1 (en) 2000-04-17 2002-05-16 Arun Shah Analytical server including metrics engine
US6393386B1 (en) 1998-03-26 2002-05-21 Visual Networks Technologies, Inc. Dynamic modeling of complex networks and prediction of impacts of faults therein
US6404884B1 (en) 1999-10-08 2002-06-11 Grape Technology Group, Inc. Personalized assistance system and method
US6408292B1 (en) 1999-08-04 2002-06-18 Hyperroll, Israel, Ltd. Method of and system for managing multi-dimensional databases using modular-arithmetic based address data mapping processes on integer-encoded business dimensions
US20020077787A1 (en) 2000-12-18 2002-06-20 Theodore Rappaport Textual and graphical demarcation of location, and interpretation of measurements
US6411936B1 (en) 1999-02-05 2002-06-25 Nval Solutions, Inc. Enterprise value enhancement system and method
US6418200B1 (en) 1999-02-26 2002-07-09 Mitel, Inc. Automatic synchronization of address directories for unified messaging
US6421781B1 (en) 1998-04-30 2002-07-16 Openwave Systems Inc. Method and apparatus for maintaining security in a push server
US6424426B1 (en) 2000-03-28 2002-07-23 Mongonet Fax-to-email and email-to-fax communication system and method
US20020099691A1 (en) 1998-06-24 2002-07-25 Michael Dean Lore Method and apparatus for aggregation of data in a database management system
US6430624B1 (en) 1999-10-21 2002-08-06 Air2Web, Inc. Intelligent harvesting and navigation system and method
US20020112237A1 (en) 2000-04-10 2002-08-15 Kelts Brett R. System and method for providing an interactive display interface for information objects
WO2001020438A3 (en) 1999-09-17 2002-08-15 Ericsson Inc Device and method for displaying data
US6438552B1 (en) 1998-10-02 2002-08-20 Ncr Corporation SQL-Based automated histogram bin data derivation assist
US6446096B1 (en) 1998-09-11 2002-09-03 International Business Machines Corporation Method and system for providing device-specific key control using role-based HTML element tags
US6446062B1 (en) 1999-12-23 2002-09-03 Bull Hn Information Systems Inc. Method and apparatus for improving the performance of a generated code cache search operation through the use of static key values
US6446059B1 (en) 1999-06-22 2002-09-03 Microsoft Corporation Record for a multidimensional database with flexible paths
US6449619B1 (en) 1999-06-23 2002-09-10 Datamirror Corporation Method and apparatus for pipelining the transformation of information between heterogeneous sets of data sources
US6457030B1 (en) 1999-01-29 2002-09-24 International Business Machines Corporation Systems, methods and computer program products for modifying web content for display via pervasive computing devices
US6466969B1 (en) 1998-03-18 2002-10-15 Sony International (Europe) Gmbh Notification subsystem
US20020161770A1 (en) 1999-08-20 2002-10-31 Shapiro Eileen C. System and method for structured news release generation and distribution
US6477525B1 (en) 1998-12-28 2002-11-05 Oracle Corporation Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins
US6480711B1 (en) 1998-09-15 2002-11-12 Nms Communications Corporation Method and system for wireless data communication over the internet
US6487584B1 (en) 1998-03-18 2002-11-26 Sony International (Europe) Gmbh Multiple personality internet account
US6493800B1 (en) 1999-03-31 2002-12-10 International Business Machines Corporation Method and system for dynamically partitioning a shared cache
US6502101B1 (en) 2000-07-13 2002-12-31 Microsoft Corporation Converting a hierarchical data structure into a flat data structure
US6526335B1 (en) 2000-01-24 2003-02-25 G. Victor Treyz Automobile personal computer systems
US6535872B1 (en) * 1999-04-08 2003-03-18 International Business Machines Corporation Method and apparatus for dynamically representing aggregated and segmented data views using view element sets
US6539359B1 (en) 1998-10-02 2003-03-25 Motorola, Inc. Markup language for interactive services and methods thereof
US6549937B1 (en) 1999-07-21 2003-04-15 Microsoft Corporation System and method for multi-protocol communication in a computer network
US6553366B1 (en) 1998-10-02 2003-04-22 Ncr Corporation Analytic logical data model
US6564264B1 (en) 1999-12-08 2003-05-13 At&T Corp. System, apparatus and method for automatic address updating of outgoing and incoming user messages in a communications network
US6563912B1 (en) 1999-03-02 2003-05-13 Toshiba America Information Systems, Inc. System and method for providing integrated messaging
US6574599B1 (en) 1999-03-31 2003-06-03 Microsoft Corporation Voice-recognition-based methods for establishing outbound communication through a unified messaging system including intelligent calendar interface
US6581062B1 (en) 2000-03-02 2003-06-17 Nimble Technology, Inc. Method and apparatus for storing semi-structured data in a structured manner
US6591304B1 (en) 1999-06-21 2003-07-08 Cisco Technology, Inc. Dynamic, scaleable attribute filtering in a multi-protocol compatible network access environment
US6601062B1 (en) 2000-06-27 2003-07-29 Ncr Corporation Active caching for multi-dimensional data sets in relational database management system
WO2002044953A3 (en) 2000-11-17 2003-09-04 Intel Corp Customizing tabular data for wireless handset units
US6616701B2 (en) * 1998-05-23 2003-09-09 Eolas Technologies, Inc. Method and apparatus for identifying features of multidimensional image data in hypermedia systems
US20030172247A1 (en) 2001-07-06 2003-09-11 Computer Associates Think, Inc. System and method for rapidly locating historical performance data
US6629102B1 (en) 2000-07-28 2003-09-30 International Business Machines Corporation Efficiently updating a key table during outline restructure of a multi-dimensional database
US6631497B1 (en) 1999-07-19 2003-10-07 International Business Machines Corporation Binding data from data source to cells in a spreadsheet
US6636870B2 (en) 1999-10-25 2003-10-21 Oracle Corporation Storing multidimensional data in a relational database management system
US6671689B2 (en) * 2001-01-19 2003-12-30 Ncr Corporation Data warehouse portal
US6721728B2 (en) 2001-03-02 2004-04-13 The United States Of America As Represented By The Administrator Of The National Aeronautics And Space Administration System, method and apparatus for discovering phrases in a database

Patent Citations (135)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5410688A (en) 1989-07-21 1995-04-25 Hewlett-Packard Company Distributed object based systems for communicating object data among different storage domains
US5404513A (en) 1990-03-16 1995-04-04 Dimensional Insight, Inc. Method for building a database with multi-dimensional search tree nodes
US5563999A (en) 1990-10-19 1996-10-08 Moore Business Forms, Inc. Forms automation system
US5403147A (en) 1991-06-28 1995-04-04 Kao Corporation Method for warehousing and delivery of articles
US5806060A (en) 1992-11-06 1998-09-08 Ncr Corporation Interactive data analysis employing a knowledge base
US5420688A (en) 1992-12-14 1995-05-30 Farah; John Interferometric fiber optic displacement sensor
US5405531A (en) 1993-02-16 1995-04-11 Geo-Microbial Technologies, Inc. Method for reducing the amount of and preventing the formation of hydrogen sulfide in an aqueous system
US5794228A (en) 1993-04-16 1998-08-11 Sybase, Inc. Database system with buffer manager providing per page native data compression and decompression
US5794229A (en) 1993-04-16 1998-08-11 Sybase, Inc. Database system with methodology for storing a database table by vertically partitioning all columns of the table
US5455945A (en) 1993-05-19 1995-10-03 Vanderdrift; Richard System and method for dynamically displaying entering, and updating data from a database
US5655101A (en) 1993-06-01 1997-08-05 International Business Machines Corporation Accessing remote data objects in a distributed memory environment using parallel address locations at each local memory to reference a same data object
US5713020A (en) 1993-09-02 1998-01-27 Microsoft Corporation Method and system for generating database queries containing multiple levels of aggregation
US5603024A (en) 1993-10-08 1997-02-11 International Business Machines Corporation Lossless distribution of time series data in a relational data base network
US5519859A (en) 1993-11-15 1996-05-21 Grace; John A. Method and apparatus for automatic table selection and generation of structured query language instructions
US5537589A (en) 1994-06-30 1996-07-16 Microsoft Corporation Method and system for efficiently performing database table aggregation using an aggregation index
US5675785A (en) 1994-10-04 1997-10-07 Hewlett-Packard Company Data warehouse which is accessed by a user using a schema of virtual tables
US5511190A (en) 1995-01-20 1996-04-23 Tandem Computers, Inc. Hash-based database grouping system and method
US5915019A (en) 1995-02-13 1999-06-22 Intertrust Technologies Corp. Systems and methods for secure transaction management and electronic rights protection
US5799310A (en) 1995-05-01 1998-08-25 International Business Machines Corporation Relational database extenders for handling complex data types
US5708828A (en) 1995-05-25 1998-01-13 Reliant Data Systems System for converting data from input data environment using first format to output data environment using second format by executing the associations between their fields
US6026388A (en) 1995-08-16 2000-02-15 Textwise, Llc User interface and other enhancements for natural language information retrieval system and method
US5832496A (en) 1995-10-12 1998-11-03 Ncr Corporation System and method for performing intelligent analysis of a computer database
US5870746A (en) 1995-10-12 1999-02-09 Ncr Corporation System and method for segmenting a database based upon data attributes
US5692181A (en) 1995-10-12 1997-11-25 Ncr Corporation System and method for generating reports from a computer database
US5721903A (en) 1995-10-12 1998-02-24 Ncr Corporation System and method for generating reports from a computer database
US5794030A (en) 1995-12-04 1998-08-11 Objectivity, Inc. System and method for maintenance and deferred propagation of schema changes to the affected objects in an object oriented database
US5884262A (en) 1996-03-28 1999-03-16 Bell Atlantic Network Services, Inc. Computer network audio access and conversion system
US5706495A (en) 1996-05-07 1998-01-06 International Business Machines Corporation Encoded-vector indices for decision support and warehousing
US5991742A (en) 1996-05-20 1999-11-23 Tran; Bao Q. Time and expense logging system
US5982890A (en) 1996-05-24 1999-11-09 Hitachi, Ltd. Method and system for detecting fraudulent data update
US5778355A (en) 1996-06-11 1998-07-07 International Business Machines Corp. Database method and apparatus for interactively retrieving data members and related members from a collection of data
US5721911A (en) 1996-06-25 1998-02-24 International Business Machines Corporation Mechanism for metadata for an information catalog system
US5870747A (en) 1996-07-09 1999-02-09 Informix Software, Inc. Generalized key indexes
US5933796A (en) * 1996-08-09 1999-08-03 Hitachi, Ltd. Data extracting system based on characteristic quantities of data distribution
US5781911A (en) 1996-09-10 1998-07-14 D2K, Incorporated Integrated system and method of data warehousing and delivery
US5826258A (en) 1996-10-02 1998-10-20 Junglee Corporation Method and apparatus for structuring the querying and interpretation of semistructured information
US5854890A (en) 1996-10-15 1998-12-29 National Instruments Corporation Fieldbus function block shell with user selectable data ownership
US5787415A (en) 1996-10-30 1998-07-28 International Business Machines Corporation Low maintenance data delivery and refresh system for decision support system database
US5822751A (en) 1996-12-16 1998-10-13 Microsoft Corporation Efficient multidimensional data aggregation operator implementation
US5848415A (en) 1996-12-18 1998-12-08 Unisys Corporation Selective multiple protocol transport and dynamic format conversion in a multi-user network
US5898431A (en) 1996-12-31 1999-04-27 International Business Machines Corporation Database graphical user interface with calendar view
US5842213A (en) 1997-01-28 1998-11-24 Odom; Paul S. Method for modeling, storing, and transferring data in neutral form
US5857197A (en) 1997-03-20 1999-01-05 Thought Inc. System and method for accessing data stores as objects
US6002402A (en) 1997-04-09 1999-12-14 Symantec Corporation System and method for producing a drag-and-drop object from a popup menu item
US5873102A (en) 1997-04-29 1999-02-16 Oracle Corporation Pluggable tablespaces on a transportable medium
US5794246A (en) 1997-04-30 1998-08-11 Informatica Corporation Method for incremental aggregation of dynamically increasing database data sets
US6032158A (en) 1997-05-02 2000-02-29 Informatica Corporation Apparatus and method for capturing and propagating changes from an operational database to data marts
US6078994A (en) 1997-05-30 2000-06-20 Oracle Corporation System for maintaining a shared cache in a multi-threaded computer environment
US5987454A (en) 1997-06-09 1999-11-16 Hobbs; Allen Method and apparatus for selectively augmenting retrieved text, numbers, maps, charts, still pictures and/or graphics, moving pictures and/or graphics and audio information from a network resource
US6233575B1 (en) 1997-06-24 2001-05-15 International Business Machines Corporation Multilevel taxonomy based on features derived from training documents classification using fisher values as discrimination values
US6119167A (en) 1997-07-11 2000-09-12 Phone.Com, Inc. Pushing and pulling data in networks
US6003024A (en) 1997-07-25 1999-12-14 Amazon. Com System and method for selecting rows from dimensional databases
US6308203B1 (en) 1997-10-14 2001-10-23 Sony Corporation Information processing apparatus, information processing method, and transmitting medium
US6122628A (en) 1997-10-31 2000-09-19 International Business Machines Corporation Multidimensional data clustering and dimension reduction for indexing and searching
US6269369B1 (en) 1997-11-02 2001-07-31 Amazon.Com Holdings, Inc. Networked personal contact manager
US6339775B1 (en) 1997-11-07 2002-01-15 Informatica Corporation Apparatus and method for performing data transformations in data warehousing
WO1999024922A1 (en) 1997-11-07 1999-05-20 Informatica Corporation Apparatus and method
US6014670A (en) 1997-11-07 2000-01-11 Informatica Corporation Apparatus and method for performing data transformations in data warehousing
US6151601A (en) 1997-11-12 2000-11-21 Ncr Corporation Computer architecture and method for collecting, analyzing and/or transforming internet and/or electronic commerce data for storage into a data storage area
US6128624A (en) 1997-11-12 2000-10-03 Ncr Corporation Collection and integration of internet and electronic commerce data in a database during web browsing
US6044374A (en) 1997-11-14 2000-03-28 Informatica Corporation Method and apparatus for sharing metadata between multiple data marts through object references
US6151584A (en) 1997-11-20 2000-11-21 Ncr Corporation Computer architecture and method for validating and collecting and metadata and data about the internet and electronic commerce environments (data discoverer)
US6466969B1 (en) 1998-03-18 2002-10-15 Sony International (Europe) Gmbh Notification subsystem
US6487584B1 (en) 1998-03-18 2002-11-26 Sony International (Europe) Gmbh Multiple personality internet account
US6393386B1 (en) 1998-03-26 2002-05-21 Visual Networks Technologies, Inc. Dynamic modeling of complex networks and prediction of impacts of faults therein
US6032145A (en) 1998-04-10 2000-02-29 Requisite Technology, Inc. Method and system for database manipulation
US6065007A (en) 1998-04-28 2000-05-16 Lucent Technologies Inc. Computer method, apparatus and programmed medium for approximating large databases and improving search efficiency
US6421781B1 (en) 1998-04-30 2002-07-16 Openwave Systems Inc. Method and apparatus for maintaining security in a push server
US6141699A (en) 1998-05-11 2000-10-31 International Business Machines Corporation Interactive display system for sequential retrieval and display of a plurality of interrelated data sets
US6616701B2 (en) * 1998-05-23 2003-09-09 Eolas Technologies, Inc. Method and apparatus for identifying features of multidimensional image data in hypermedia systems
US20020099691A1 (en) 1998-06-24 2002-07-25 Michael Dean Lore Method and apparatus for aggregation of data in a database management system
US6216125B1 (en) 1998-07-02 2001-04-10 At&T Corp. Coarse indexes for a data warehouse
US6292657B1 (en) 1998-07-13 2001-09-18 Openwave Systems Inc. Method and architecture for managing a fleet of mobile stations over wireless data networks
WO2000004466A1 (en) 1998-07-15 2000-01-27 Informatica Corporation Method and architecture for automated optimization of etl throughput in data warehousing applications
US6208990B1 (en) 1998-07-15 2001-03-27 Informatica Corporation Method and architecture for automated optimization of ETL throughput in data warehousing applications
US6269336B1 (en) 1998-07-24 2001-07-31 Motorola, Inc. Voice browser for interactive services and methods thereof
US6192364B1 (en) 1998-07-24 2001-02-20 Jarg Corporation Distributed computer database system and method employing intelligent agents
WO2000008581A1 (en) 1998-08-03 2000-02-17 Harvest Technology, Inc. Dynamic flow-through context switching of investment data into multiple investment tools
US6446096B1 (en) 1998-09-11 2002-09-03 International Business Machines Corporation Method and system for providing device-specific key control using role-based HTML element tags
EP0987868A3 (en) 1998-09-14 2001-05-23 Phone.Com Inc. Method and architecture for interactive two-way communication devices to interact with a network
US6480711B1 (en) 1998-09-15 2002-11-12 Nms Communications Corporation Method and system for wireless data communication over the internet
US6205472B1 (en) 1998-09-18 2001-03-20 Tacit Knowledge System, Inc. Method and apparatus for querying a user knowledge profile
US6553366B1 (en) 1998-10-02 2003-04-22 Ncr Corporation Analytic logical data model
US6438552B1 (en) 1998-10-02 2002-08-20 Ncr Corporation SQL-Based automated histogram bin data derivation assist
US6549910B1 (en) 1998-10-02 2003-04-15 Ncr Corporation SQI-based automated, adaptive, histogram bin data description assist
US6539359B1 (en) 1998-10-02 2003-03-25 Motorola, Inc. Markup language for interactive services and methods thereof
US6477525B1 (en) 1998-12-28 2002-11-05 Oracle Corporation Rewriting a query in terms of a summary based on one-to-one and one-to-many losslessness of joins
US6457030B1 (en) 1999-01-29 2002-09-24 International Business Machines Corporation Systems, methods and computer program products for modifying web content for display via pervasive computing devices
US6411936B1 (en) 1999-02-05 2002-06-25 Nval Solutions, Inc. Enterprise value enhancement system and method
US6272485B1 (en) 1999-02-18 2001-08-07 Creative Internet Applications, Inc. Transferring selected formatted documents over a computer network using interface script
US6418200B1 (en) 1999-02-26 2002-07-09 Mitel, Inc. Automatic synchronization of address directories for unified messaging
US6563912B1 (en) 1999-03-02 2003-05-13 Toshiba America Information Systems, Inc. System and method for providing integrated messaging
US6369840B1 (en) * 1999-03-10 2002-04-09 America Online, Inc. Multi-layered online calendaring and purchasing
EP1043671A2 (en) 1999-03-19 2000-10-11 International Business Machines Corporation Message broker providing a publish/subscribe service and method of processing messages in a publish/subscribe environment
US6272598B1 (en) 1999-03-22 2001-08-07 Hewlett-Packard Company Web cache performance by applying different replacement policies to the web cache
US6173310B1 (en) 1999-03-23 2001-01-09 Microstrategy, Inc. System and method for automatic transmission of on-line analytical processing system report output
US6493800B1 (en) 1999-03-31 2002-12-10 International Business Machines Corporation Method and system for dynamically partitioning a shared cache
US6574599B1 (en) 1999-03-31 2003-06-03 Microsoft Corporation Voice-recognition-based methods for establishing outbound communication through a unified messaging system including intelligent calendar interface
US6535872B1 (en) * 1999-04-08 2003-03-18 International Business Machines Corporation Method and apparatus for dynamically representing aggregated and segmented data views using view element sets
GB2350758A (en) 1999-06-04 2000-12-06 Ibm Message broker providing a publish/subscribe sevice and method of processing messages in a publish/subscribe environment
WO2000077707A1 (en) 1999-06-11 2000-12-21 Onecore Financial Network, Inc. Method and system for allowing a financial consultant to manage a plurality of business accounts
US6591304B1 (en) 1999-06-21 2003-07-08 Cisco Technology, Inc. Dynamic, scaleable attribute filtering in a multi-protocol compatible network access environment
US6446059B1 (en) 1999-06-22 2002-09-03 Microsoft Corporation Record for a multidimensional database with flexible paths
US6449619B1 (en) 1999-06-23 2002-09-10 Datamirror Corporation Method and apparatus for pipelining the transformation of information between heterogeneous sets of data sources
US6631497B1 (en) 1999-07-19 2003-10-07 International Business Machines Corporation Binding data from data source to cells in a spreadsheet
US6549937B1 (en) 1999-07-21 2003-04-15 Microsoft Corporation System and method for multi-protocol communication in a computer network
US6385604B1 (en) 1999-08-04 2002-05-07 Hyperroll, Israel Limited Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
US6408292B1 (en) 1999-08-04 2002-06-18 Hyperroll, Israel, Ltd. Method of and system for managing multi-dimensional databases using modular-arithmetic based address data mapping processes on integer-encoded business dimensions
US20020161770A1 (en) 1999-08-20 2002-10-31 Shapiro Eileen C. System and method for structured news release generation and distribution
WO2001018728A8 (en) 1999-09-10 2001-12-13 Getapproved Com Llc Computer-implemented dynamic financial mentor
WO2001020438A3 (en) 1999-09-17 2002-08-15 Ericsson Inc Device and method for displaying data
WO2001024040A1 (en) 1999-09-30 2001-04-05 Hnc Software, Inc. Webstation: configurable web-based workstation for reason driven data analysis
US6404884B1 (en) 1999-10-08 2002-06-11 Grape Technology Group, Inc. Personalized assistance system and method
US6430624B1 (en) 1999-10-21 2002-08-06 Air2Web, Inc. Intelligent harvesting and navigation system and method
US6636870B2 (en) 1999-10-25 2003-10-21 Oracle Corporation Storing multidimensional data in a relational database management system
US20020056081A1 (en) 1999-12-02 2002-05-09 Qualcomm Incorporated Apparatus and method for decoding digital image and audio signals
US6564264B1 (en) 1999-12-08 2003-05-13 At&T Corp. System, apparatus and method for automatic address updating of outgoing and incoming user messages in a communications network
GB2357596A (en) 1999-12-20 2001-06-27 Univ London A navigation engine for assessing the quality of a trail between linked pages
US6446062B1 (en) 1999-12-23 2002-09-03 Bull Hn Information Systems Inc. Method and apparatus for improving the performance of a generated code cache search operation through the use of static key values
US6526335B1 (en) 2000-01-24 2003-02-25 G. Victor Treyz Automobile personal computer systems
US6581062B1 (en) 2000-03-02 2003-06-17 Nimble Technology, Inc. Method and apparatus for storing semi-structured data in a structured manner
US6424426B1 (en) 2000-03-28 2002-07-23 Mongonet Fax-to-email and email-to-fax communication system and method
US6336137B1 (en) 2000-03-31 2002-01-01 Siebel Systems, Inc. Web client-server system and method for incompatible page markup and presentation languages
US20020112237A1 (en) 2000-04-10 2002-08-15 Kelts Brett R. System and method for providing an interactive display interface for information objects
US20020059267A1 (en) 2000-04-17 2002-05-16 Arun Shah Analytical server including metrics engine
US20020035565A1 (en) 2000-04-27 2002-03-21 Arun Shah Graphical user interface for relational database
EP1164511A2 (en) 2000-06-16 2001-12-19 Cognos Incorporated Method of managing slowly changing dimensions
US6601062B1 (en) 2000-06-27 2003-07-29 Ncr Corporation Active caching for multi-dimensional data sets in relational database management system
US6502101B1 (en) 2000-07-13 2002-12-31 Microsoft Corporation Converting a hierarchical data structure into a flat data structure
US6629102B1 (en) 2000-07-28 2003-09-30 International Business Machines Corporation Efficiently updating a key table during outline restructure of a multi-dimensional database
WO2002044953A3 (en) 2000-11-17 2003-09-04 Intel Corp Customizing tabular data for wireless handset units
US20020077787A1 (en) 2000-12-18 2002-06-20 Theodore Rappaport Textual and graphical demarcation of location, and interpretation of measurements
US6671689B2 (en) * 2001-01-19 2003-12-30 Ncr Corporation Data warehouse portal
US6721728B2 (en) 2001-03-02 2004-04-13 The United States Of America As Represented By The Administrator Of The National Aeronautics And Space Administration System, method and apparatus for discovering phrases in a database
US20030172247A1 (en) 2001-07-06 2003-09-11 Computer Associates Think, Inc. System and method for rapidly locating historical performance data

Non-Patent Citations (57)

* Cited by examiner, † Cited by third party
Title
"A Process for Selective Routing of Servlet Transcoding Modules," IBM Technical Disclosure Bulletin, vol. 42, Issue 422, Jun. 1999 UK.
"Parameterized XSL Style Sheets," Research Disclosure, vol. 42, No. 423, Jul. 1, 1999, Havant, UK, Article No. 423110.
24X7 The Magazine of Nonstop Computing, "Compaq's Zero Latency Enterprise Initiative," vol. 1, No. 2, Oct. 2000, pp. 1-25.
Anand, V. J. et al. "Data Warehouse Architecture for DDS Applications." Australian Journal of Information Systems. Sep. 1996, AJIS Publishing, Australia, vol. 4, No. 1, pp. 43-53.
Ballinger, C. et al., "Born to be Parallel. Why Parallel Origins Give Teradata an Enduring Performance Edge," Bulletin of the Technical Committee on Data Engineering, vol. 20, No. 2, Jun. 1997, IEEE Comput. Soc., Los Alamitos, CA, US.
Barclay et al.: "Microsoft TerraServer: A Spatial Data Warehouse", Technical Report MS-TR-99-29, Jun. 1999, Microsoft Corporation. *
Barrett, R. et al., "Intermediaries: An Approach to Manipulating Information Streams," IBM Systems Journal, IBM Corp., Armonk, New York, U.S. vol. 38, No. 4, 1999, pp. 629-641.
Bellatreche, L. et al., "OLAP Query Processing for Partitioned Data Warehouses," Proceedings 1999 Int'l. Symposium on Database Applications in Non-Traditional Environments (Dante'99) (Cat. No. PR00496), Kyoto, JP, Nov. 28-30, 1999, pp. 35-42, IEEE Comput. Soc., Los Alamitos, CA US ISBN: 0-7695-0496-5.
Bello, R.G. et al., "Materialized Views in Oracle," Proceedings of the Int'l. Conf. On Very Large Data Bases, NY, Aug. 24, 1998, pp. 659-664.
Chamberlin, D. et al., "A Complete Guide to DB2 Universal Database," 1992, pp. 659-600.
Chan, R. "12 Steps of Creating a Successful Data Warehouse," Proceedings of the 8th International Database Workshop (Industrial Volume), Proceedings of the 8th International Hong Kong Computer Society Database Workshop, Data Mining, Data Warehousing and CLI, pp. 227-248, ISBN 981-3083-53-0, 1997, Singapore, Springer-Verlag Singapore, Singapore.
Chaudhuri, S. et al., "An Overview of Data Warehousing and OLAP Technology," SIGMOD Record, Sigmod, New York, No. US, vol. 2, No. 1, Mar. 1997, pp. 65-74.
Curley, K. et al. "The Rationale for Developing a Corporate Data Warehouse and the Development of a Model for Sharing Data in a Data Warehouse Environment." OOIS '95. 1995 International Conference on Object Oriented Information Systems Proceedings, Proceedings of 1995, International Conference on Object Oriented Information Systems, Dublin, Ireland, Dec. 18-20, 1995, pp. 351-366, Berlin, Germany, Springer-Verlag, Germany.
Datta, A., et al., "A Case for Parallelism in Data Warehousing and OLAP," Ninth Int'l. Workshop on Database and Expert Systems Applications, Vienna, AT, IEEE Comput. Soc., Los Alamitos, CA, US, Aug. 26, 1998, pp. 226-231.
Dawson, F. et al., "RFC 2426 vCard MIME Directory Profile," Network Working Group, Request for Comments 2426, Sep. 1998.
Deutsch, A. et al., "Storing Semistructured Data with STORED," ACM SIGMOD Record, Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data, Jun. 1999, vol., 28, Issue 2.
Duncan, K., et al., "Optimizing the Data Warehousing Environment for Change: the Persistent Staging Area," Cutter IT Journal, Jun. 1999, Cutter Inf. Corp. USA, vol. 12, No. 6, pp. 28-35.
Fernanez, M. et al., "SilkRoute: Trading Between Relations and XML," WWW9/Computer Networks, 33(1-6), pp. 723-745, 2000.
Florescu, D. et al., "A Performance Evaluation of Alternative Mapping Schemes for Storing SML in a Relational Database," Technic Report 3680, INRIA, 1999.
Freytag, C. et al., "Resource Adaptive WWW access for Mobile Applications," Computers and Graphics, Pergamon Press Ltd., Oxford, GB, vol. 23, No. 6, Dec. 1999, pp. 841-848.
Fry, J.P, "Conversion Technology, An Assessment," ACM SIGMIS Database, vol. 12-13, No. 4-1, Jul. 1981, pp. 39-61.
Hammer, J. et al., "Extracting Semistructured Information From the Web," Proceedings of the Workshop on Management of Semi-structured Data, Mar. 16, 1997, pp. 1-25.
Hori, M. et al., "Annotation-Based Web Content Transcoding," Computer Networks, Elsevier Science Publishers B.V., Amsterdam NL., vol. 33, No. 106, Jun. 2000, pp. 197-211.
Housel, B. et al., "A High-Level Data Manipulation Language for Hierarchical Data Structures," International Conference on Management of Data, 1976, pp. 155-169.
Informatica Corporation, Release Notes, PowerCenter 1.6, PowerMart 4.6, Aug. 1999, pp. 1-30.
Informatica Corporation, User Guide, PowerCenter 1.6, PowerMart 4.6, Jul. 1999, pp. i-xxvii and 144-186 (Table of Contents, Preface, Chapters 6 & 7).
Informatica Press Releases, "Informatica Delivers Industry's First Synchronized Data Marts With Newest Version of Powermart Suite," , pp. 1-4, May 27, 1997.
Informatica Press Releases, "Informatica Delivers Industry's First Synchronized Data Marts With Newest Version of Powermart Suite," <http://www.informatica.com/syndata—-—052798.html>, pp. 1-4, May 27, 1997.
Jaczynski, M. et al., "Broadway: A Case-Based System for Cooperative Information Browsing on the World Wide Web," Collaboration Between Human and Artificial Societies, Online 1999.
Jones, Katherine, "An Introduction to Data Warehousing: What are the Implications for the Network," 1998, International Journal of Network Management, vol. 8, pp. 42-56.
Juhne, J., et al., "Ariadne: a Java-Based Guided Tour System for The World Wide Web," Computer Networks and ISDN Systems, North Holland Publishing, Amsterdam, NL, vol. 30, No. 107, Apr. 1, 1998, pp. 131-139.
Kim, W., "On Optimizing an SQL-Like Nested Query," ACM Transactions on Database Systems, Association for Computing Machinery, New York, US, vol. 7, No. 3, Sep. 1, 1982, pp. 443-469.
Kitayama, F. et al., "Design of a Framework for Dynamic Content Adaptation to Web-enabled Terminals and Enterprise Applications," Software Engineering Conference, 1999. Proceedings Sixth Asian Pacific Takamatsu, Japan, Dec. 7-10, 1999, Los Alamitos, CA, US.
Kovacs, L. et al., "Aqua: An Advanced User Interface for the Dienst Digital Library System," 8th Delos Workshop: User Interfaces for Digital Libraries, Online, Oct. 21-23, 1998, Sweden, p. 2.
Lum, V. Y. et al., "A General Methodology for Data Conversion and Restructuring," IBM Journal of Research and Development, IBM Corporation, Armonk, US, vol. 20, No. 5, Sep. 1, 1976, pp. 483-497.
Makpangou, M. et al., "Replicated Directory Service for Weakly Consistent Distributed Caches," INRIA SOR group-78143 Le Chesnay Cedex, France.
Mohania, M. et al.: "Advances and Research Directions in Data Warehousing Technology," Ajis. Australian Journal of Information Systems, Wollongong, Au. vol. 7, No. 1, Sep. 1999, pp. 41-59.
Multi-Modal Data Access Research Disclosure, Kenneth Mason Publications, Hampshire, GB, No. 426, Oct. 1999, pp. 133-1386.
Mumick, I. S. et al. "Maintenance of Data Cubes and Summary Tables in a Warehouse," SIGMOD 1997. ACM SIGMOD International Conference on Management of Data, Tucson, AZ, USA, May 13-15, 1997, vol. 26, No. 2, pp. 100-111, XP002074807, Jun. 1997, ACM, USA.
Mumick, I.S., "Magic is Relevant," Sigmod Record, Sigmod, New York, NY, US, vol. 19, No. 2, Jun. 1, 1990, pp. 247-258.
Rodriguez, J. et al., "IBM WebSphere Transcoding Publisher V1:1: Extending Web Applications to the Pervasive World," , Jul. 2000, pp. 1039.
Rodriguez, J. et al., "IBM WebSphere Transcoding Publisher V1:1: Extending Web Applications to the Pervasive World," <http://ibm.com/redbooks>, Jul. 2000, pp. 1039.
Rousskov, A., "Cache Digests," Computer Networks and ISDN Systems, 30 (1998) 2144-2168.
Roy, P. et al., "Don't Trash Your Intermediate Results, Cach'em," Technical Report, Online, Mar. 2, 2000, pp. 1-22.
Schneiderman, B. et al., "An Architecture for Automatic Relational Database System Conversion," ACM Transactions on Database Systems, vol. 7, No. 2, 1982.
Schneier, B., "Applied Cryptography, Second Edition," 1996, pp. 189-196, 226-227.
Seshadri, P. et al., "SQLServer for Windows CE-A Database Engine for Mobile and Embedded Platforms," Data Engineering 2000. Proceedings 16th International Conference in San Diego, CA, US, Feb. 29, 2000, IEE Computer Soc., US, Feb. 29, 2000, pp. 642-644.
Shanmugasundaram, J. et al., "Relational Databases for Querying SML Documents Limitations and Opportunities," Proc. Of VLBD, pp. 302-314, 1999.
Shimura, T. et al., "Storage and Retrieval of XML Documents Using Object-Relational Databases," Proc. Of DEXA, pp. 206-217, 1999.
Shu N. et al., "Convert: A High Level Translation Definition Language for Data Conversion," Proceedings of the 1975 ACM SIGMOD International Conference on Management of Data, May 1975 (May 1975), p. 111.
Shu, N. et al., "Convert: A High Level Translation Definition Language for Data Conversion," Communications of the ACM, vol. 18, No. 10, Oct. 1975 (Oct. 1975), pp. 557-567.
Shu, N. et al., "Express: A Data Extraction, Processing, and Restructuring System," ACM Transactions on Database Systems, vol. 2, No. 2, Jun. 1977, pp. 134-174.
Shu, N., "Automatic Data Transformation and Restructuring," IEEE, 1987, pp. 173-180.
Squire, C., "Data Extraction and Transformation for the Data Warehouse," ACM Proceedings of SIGMOD. International Conf. On Management of Data, vol. 24, No. 1, Mar. 1, 1995, p. 446.
Weyman, P.J., "The Case for a Process-Driven Approach to Data Warehousing," Database and Network Journal, A.P. Publications, London, FB, vol. 27, No. 1, Feb. 1, 1997, pp. 3-6.
White, C., "Data Warehousing: Cleaning and Transforming Data," Info DB, vol. 10, No. 6, Apr. 1997, pp. 11-12.
White, C., "Managing Data Transformations," byte, McGraw-Hill Inc., St. Peterborough US, vol. 22, No. 12, Dec. 1, 1997, pp. 53-54.

Also Published As

Publication number Publication date
US20030163441A1 (en) 2003-08-28
CA2476788A1 (en) 2003-09-04
EP1479015A2 (en) 2004-11-24
AU2003216336A1 (en) 2003-09-09
US6820077B2 (en) 2004-11-16
AU2003216336A8 (en) 2003-09-09
CA2476788C (en) 2008-05-20
WO2003073328A2 (en) 2003-09-04
WO2003073328A3 (en) 2004-07-29

Similar Documents

Publication Publication Date Title
USRE44478E1 (en) Method and system for navigating a large amount of data
US6701362B1 (en) Method for creating user profiles
US9852126B2 (en) Host-based intelligent results related to a character stream
US6775675B1 (en) Methods for abstracting data from various data structures and managing the presentation of the data
JP4620348B2 (en) User interface for web browser
US6931416B2 (en) Ephemeral list for object-action navigation
US20120215761A1 (en) Method and System for Automated Search for, and Retrieval and Distribution of, Information
US20040012626A1 (en) Method for creating configurable and customizable web user interfaces
AU7225301A (en) Web based visual self calculating order system
US20020156791A1 (en) Taxonomy of business metrics
US7716141B2 (en) Method for providing an industry report
CA2453863A1 (en) Database navigation
KR20010035263A (en) Web-based multi-dimensional information analyzing method and system
US20050262036A1 (en) Navigating to data in source system
Wani et al. A New Preprocessing Approach for Mining Association Rule from Large Database

Legal Events

Date Code Title Description
AS Assignment

Owner name: INFORMATICA LLC, CALIFORNIA

Free format text: CHANGE OF NAME;ASSIGNOR:INFORMATICA CORPORATION;REEL/FRAME:036453/0406

Effective date: 20150806

FPAY Fee payment

Year of fee payment: 12

AS Assignment

Owner name: NOMURA CORPORATE FUNDING AMERICAS, LLC, NEW YORK

Free format text: FIRST LIEN SECURITY AGREEMENT SUPPLEMENT;ASSIGNOR:INFORMATICA LLC;REEL/FRAME:052019/0764

Effective date: 20200225

Owner name: NOMURA CORPORATE FUNDING AMERICAS, LLC, NEW YORK

Free format text: SECURITY INTEREST;ASSIGNOR:INFORMATICA LLC;REEL/FRAME:052022/0906

Effective date: 20200225

AS Assignment

Owner name: JPMORGAN CHASE BANK, N.A., NEW YORK

Free format text: SECURITY INTEREST;ASSIGNOR:INFORMATICA LLC;REEL/FRAME:057973/0568

Effective date: 20211029

Owner name: INFORMATICA LLC, CALIFORNIA

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:NOMURA CORPORATE FUNDING AMERICAS, LLC;REEL/FRAME:057973/0507

Effective date: 20211029

Owner name: INFORMATICA LLC, CALIFORNIA

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:NOMURA CORPORATE FUNDING AMERICAS, LLC;REEL/FRAME:057973/0496

Effective date: 20211029