|Veröffentlichungsdatum||12. Sept. 2006|
|Eingetragen||28. Dez. 1999|
|Prioritätsdatum||28. Dez. 1999|
|Veröffentlichungsnummer||09472852, 472852, US 7107284 B1, US 7107284B1, US-B1-7107284, US7107284 B1, US7107284B1|
|Erfinder||Eugene M. Betz, Mahesh P. Vannavada, Luo-Jen Chiang, James E. Thaisz, Karen A. Papierniak|
|Ursprünglich Bevollmächtigter||Ncr Corporation|
|Zitat exportieren||BiBTeX, EndNote, RefMan|
|Patentzitate (31), Referenziert von (18), Klassifizierungen (21), Juristische Ereignisse (4)|
|Externe Links: USPTO, USPTO-Zuordnung, Espacenet|
The present application relates to U.S. Ser. No. 08/975,433 is now U.S. Pat. No. 6,151,584 filed Nov. 20, 1997, entitled “COMPUTER ARCHITECTURE AND METHOD FOR VALIDATING AND COLLECTING METADATA AND DATA ABOUT THE INTERNET AND ELECTRONIC COMMERCE ENVIRONMENTS (DATA DISCOVERER), pending; and U.S. Ser. No. 08/969,082 filed Nov. 12, 1997, is now U.S. Pat. No. 6,128,624 entitled COMPUTER ARCHITECTURE AND METHOD FOR INTEGRATING INTERNET ELECTRONIC COMMERCE AND OPERATIONAL DATABASE DATA INTO WAREHOUSE OF DATABASE”, pending, both of which are hereby incorporated by reference in their entirety into this specification.
The present invention relates generally to support systems for data warehouse development and maintenance professionals, and more particularly, to a method and system for documenting an electronic and/or physical footprint of an engagement process used in a data warehouse environment.
A data warehouse can be used to store vast amounts of information or data including transactional/operational data. Data warehouse professionals including implementers and developers implement and maintain the data warehouse.
Data warehouse professionals also perform processes, referred to as a business data discovery process and a data discovery process, throughout the life of the data warehouse to ascertain the customer specific information/data required to build, run and maintain the data warehouse. The business discovery process is used to identify and record a set of specific customer related business problems. The data discovery process is used to establish customer related data available to solve such problems. The results from the business discovery process and the data discovery process each form an essential foundation of information upon which the data warehouse is built and operated.
During the business discovery process, the data warehouse professional identifies the customer's business goals, objectives, and problems to determine the types of problems that should or can be solved using the data warehouse. The data warehouse professional identifies the nature and availability of all data/information relating to the customer that can potentially serve as a basis for business analysis after being warehoused. The data discovery process is used to identify quantitatively and qualitatively the data sources of the customer's transactional/operational business related data. Data for the data warehouse is typically copied or derived from these data sources.
Exemplary data discovery information includes the types of devices serving as data warehouse data sources and the geographical locations of such devices, who administers the data source devices, the frequency with which the data source devices are updated or backed-up, the logical description of data stored by the data source devices and the access techniques or data transfer methods used to communicate data to and from the data source devices, and the business rationale for using such data (determined from the business discovery process). Data discovery information also includes defining the data or what the data means to the customer. For example, an end date in a billing table could mean the last date of service of the last date the customer was billed or both.
Data warehouse professionals typically perform the business discovery process and the data discovery process through a series of engagements with the customer. An engagement is a personal interaction between the data warehouse professionals and the customer, wherein the data warehouse professional solicits the business discovery information and the data discovery information from the customer and seeks to document relevant, discovered information. An engagement can last up to several months enabling the data warehouse professionals to gather the large amount of discovery data required to build and run a large data warehouse.
During a data warehouse engagement, many interactions occur between the customer and the data warehouse professionals. The information flow between the customer and the data warehouse professionals are intensive and spontaneous. Critical information and learned knowledge which are a result of these engagements may be lost if an automated process is not used to capture the transactions. To the inventors' knowledge, no such tool exists for documenting the engagement process used in creating and maintaining the data warehouse.
It is therefore an object of the present invention to provide a method and apparatus for capturing and recording changes made to an electronic and/or physical footprint during a data warehouse engagement.
It is another object of the present invention to document changes made to the starting system parameters of the data warehouse.
Another object of the present invention is to provide a document customizer for establishing a system of record document defining the system parameters of the data warehouse and to record the footprint and associated changes or content and process as a data warehouse professional interacts with a customer.
The present invention is called a document customizer. The document customizer captures and records changes made to an electronic and/or physical footprint of a data warehouse engagement by a knowledgeable field practitioner. The document customizer starts with a “system-of-record” (SOR) document which defines the starting system parameters of the data warehouse, as initially delivered to the customer (i.e., Logical Data Model, Physical Data Model, Metadata and system configuration templates). The document customizer allows the practitioner to archive and document the modifications made to the system-of-record and creates an on-line environment to document and time-stamp the modifications made to the data warehouse. The document customizer then creates a “current” system-of-record document. Provisions are included to make additions and modifications to the (new) current document to allow text comments and notes to be input. The knowledge captured via the engagement is vital data for both the customers' data warehouse administrator and the knowledgeable field practitioner. The customer benefits from understanding the modifications made to their data warehouse for future design changes, performance enhancements and troubleshooting needs. The knowledgeable field practitioner may now keep an archive of the customers' data warehouse to assist in quoting the cost of additional changes to the warehouse, while gaining a competitive edge in supporting the customer through knowledge gained, by knowing what modifications were made to the system, to date. The document customizer can be implemented in both standalone and networking manners using a Graphical User Interface—Windows and/or Web based. Document customizer provides the easy to use vehicle and interface to allow the instant capture of the ideas and information. These types of ideas and information usually include, but are not limited to, the data field descriptions, source data locations, relevant documents, critical customer files, Metadata and reports. Document customizer organizes, manipulates and presents the information such that the final output of the document customizer is a useful guide for users to perform the tasks.
In accordance with the present invention, discovery data for a data warehouse is solicited from a data warehouse customer using an orderly, predefined sequence of queries generated by a computer from an organized, configuration controlled set of query templates. The query templates and answers to the queries form the basis of an organized, centrally available, data warehouse system-of-record defining the data and data sources for the data warehouse, and business rules and/or rationales for using the data from the data sources. The present invention advantageously flags missing discovery information based on a comparison between the predefined sequence of queries and the order in which the queries are answered by the customer. Discovery information, in such different formats as text, audio, and video formats, can be imported automatically into the system-of-record and linked to the templates. Additionally, customized documents incorporating discovery information from the system-of-record, including the imported text, audio and video base information, can be generated using the present invention. The customized documents incorporate discovery information in user selected arrangements and formats.
These and other objects of the present invention are achieved by a computer implemented method of capturing and recording changes to an electronic and/or physical footprint of a data warehouse. A user is solicited for data discovery information defining data and sources of the data for a data warehouse. At least a portion of the footprint of the data warehouse is in an SOR document database using the discovery information collected from the user as a result of said soliciting step. A user customized document is generated incorporating at least a portion of the discovery information recorded in the SOR database.
Still other objects and advantages of the present invention will become readily apparent to those skilled in the art from the following detailed description, wherein the preferred embodiment of the invention is shown and described, simply by way of illustration of the best mode contemplated of carrying out the invention. As will be realized, the invention is capable of other and different embodiments, and its several details are capable of modifications in various obvious respects, all without departing from the invention. Accordingly, the drawings and description thereof are to be regarded as illustrative in nature, and not as restrictive.
The present invention is illustrated by way of example, and not by limitation, in the figures of the accompanying drawings, wherein elements having the same reference numeral designations represent like elements throughout and wherein:
A method of and apparatus for documenting an electronic and/or physical footprint of an engagement process for data warehouse environment 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 apparent, however, 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 unnecessarily obscuring the present invention.
Computer 100-n is representative of the other computers 100-1, 100-2 . . . and is described in detail herein. Computer system 100-n includes a bus 102 or other communication mechanism for communicating information, and a processor 104 coupled with the bus 102 for processing information. Computer system 100-n also includes a main memory 106, such as a random access memory (RAM) or other dynamic storage device, coupled to the bus 102 for storing information and instructions to be executed by processor 104. Main memory 106 also may be used for storing temporary variables or other intermediate information during execution of instructions to be executed by processor 104. Computer system 100-n further includes a read only memory (ROM) 108 or other static storage device coupled to the bus 102 for storing static information and instructions for the processor 104. A storage device 110, such as a magnetic disk or optical disk, is provided and coupled to the bus 102 for storing information and instructions.
Computer system 100-n may be coupled via the bus 102 to a display 112, such as a cathode ray tube (CRT) or a flat panel display, for displaying information to a computer user. An input device 114, including alphanumeric and other keys, is coupled to the bus 102 for communicating information and command selections to the processor 104. Another type of user input device is cursor control 116, such as a mouse, a trackball, or cursor direction keys for communicating direction information and command selections to processor 104 and for controlling cursor movement on the display 112. Computer system 100-n can generate printed output on a printer 117 coupled with the computer system 100-n.
The invention is related to the use of a computer system 100-n, such as the illustrated system, to display graphical interface icons, text, images, and the like relating to business and data discovery processes relating to a data warehouse, and to accept commands and data from a user. According to one embodiment of the invention, business and data discovery information and display is provided by computer system 100-n in response to processor 104 executing sequences of instructions contained in main memory 106. Such instructions may be read into main memory 106 from another computer-readable medium, such as storage device 110. However, the computer-readable medium is not limited to devices such as storage device 110. For example, the computer-readable medium may include a floppy disk, a flexible disk, hard disk, magnetic tape, or any other magnetic medium, a CD-ROM, any other optical medium, punch cards, paper tape, any other physical medium with patterns of holes, a RAM, a PROM, an EPROM, a FLASH-EPROM, any other memory chip or cartridge, a carrier wave embodied in an electrical, electromagnetic, infrared, or optical signal, or any other medium from which a computer can read. Execution of the sequences of instructions contained in the main memory 106 causes the processor 104 to perform the process steps described below. In alternative embodiments, hard-wired circuitry may be used in place of or in combination with computer software instructions to implement the invention. Thus, embodiments of the invention are not limited to any specific combination of hardware circuitry and software.
Computer system 100-n also includes a communication interface 118 coupled to the bus 102. Communication interface 118 provides a two-way data communication as is known. For example, communication interface 118 may be an integrated services digital network (ISDN) card or a modem to provide a data communication connection to a corresponding type of telephone line. As another example, communication interface 118 may be a local area network (LAN) card to provide a data communication connection to a compatible LAN. Wireless links may also be implemented. In any such implementation, communication interface 118 sends and receives electrical, electromagnetic or optical signals which carry digital data streams representing various types of information. Of particular note, the communications through interface 118 may permit transmission or receipt of the business and data discovery related information stored in a remote data base, as will be described. For example, two or more computer systems 100 may be networked together in a conventional manner with each using the communication interface 118.
Each computer system 100-1, 100-2 . . . 100-n is linked to a network 122 by a corresponding network link 120-1, 120-2 . . . 120-n. Each network link 120-1, 120-2 . . . 120-n provides data communication through one or more networks to other data devices. For example, each network link 120 may provide a connection through network 122 to a networked server 124 for storing business and data discovery related information in one or more centrally accessible databases and/or data warehouses 125. Databases 125 are centrally accessible because all computer systems 100-1, 100-2 . . . 100-n have network access to databases 125.
Network 122 represents, for example, a local area network, a company Intranet, the world wide packet data communication network now commonly referred to as the “Internet”, any other suitable communication network, or a combination of such networks. Network 122 uses electrical, electromagnetic or optical signals carrying digital data streams. The signals through the various networks and the signals on network link 120 and through communication interface 118-1, 118-2 . . . 118-n, which carries the digital data to and from computer systems 100-1, 100-2 . . . 100-n respectively, are exemplary forms of carrier waves transporting the information.
Each computer system 100 can send messages and receive data, including program code, through the network(s), network link 120 and communication interface 118. In the Internet or Intranet example, computer 100 might transmit a request for a business and data discovery information file to server 124 through communication interface 118 and network 122. In response, server 124 downloads the requested file to computer system 100 via network 122. The received file may be stored in storage device 110, or other non-volatile storage for later access.
Data warehouse professionals can use document customizer 200 during the business discovery process and the data discovery process as a tool for automatically recording such discovery information in a document customizer database 205 in a standardized format. Also, data warehouse professionals advantageously use document customizer 200 as a mechanism for maintaining centralized, configuration control over the discovery information recorded in document customizer database 205, and for generating a customized document 207 incorporating the recorded discovery information. Data warehouse professionals use such customized documents in building and maintaining the data warehouse.
Document customizer 200 includes the document customizer database 205, a graphical user interface (GUI) 210 displayed on the display device 112, a data collection controller 220, an exception table 222, an external interface (I/F) 230, an automatic collection agent 240, and a document generator 250. A user 255 participates with document customizer 200 through GUI 210 using the display device 112. A plurality of external information sources 260 can be imported into document customizer 200 in a known manner using external I/F 230 which interfaces with communication interface 118. External I/F 230 imports different types of data including textually based files 262, image data such as that provided by computer aided design packages, still and motion video data 264, and audio data 266, i.e., multimedia data. Also, document customizer 200 can download data from and upload data to the databases 125 on server 124.
User 255 generates the customized document 207, incorporating discovery information recorded in database 205, using document generator 250 of document customizer 200. An exemplary document 207 can include text portions 300, HTML pages 305, a video portion 310 and an audio portion 315, corresponding respectively, for example, to externally supplied discovery data items 262, 264 and 266.
GUI 210 supports a number of user selectable interactive environments, including, for example, a windowing environment, and a hypertext mark-up language (HTML) browser for Internet and Intranet environments, as is known. Data collection controller 220 provides information to and accepts information from GUI 210, and uses information stored in database 205 to supervise user interaction with document customizer 200 through GUI 210. Data collection controller 220 also supervises error or exception handling during the process of soliciting for discovery information from user 255. When an error occurs during the solicitation process, controller 220 generates an exception and stores the exception in exception table 222 residing in document customizer memory, such as memory 106. Collection agent 240 routes the discovery information collected or imported via GUI 210, collection controller 220 and external I/F 230, to database 205.
The document customizer 200 is used to record discovery information in a sub-component of database 205 referred to as a system-of-record document (SOR) 330. SOR 330 includes a template 410 (described later with reference to
Document customizer database 205 includes a plurality of system of record documents 330 each including a template column 410 and a content column 415 (see
Centralized knowledge base 270 external to document customizer 200 and residing in, for example, databases 125 of server 124 (see
Document customizer 200 also provides a convenient alternative to soliciting for discovery information. As mentioned above, document customizer 200 can import discovery information from external sources 260 using external I/F 230 and collection agent 240. Such information includes the text based files 262, image data such as that provided by computer aided design packages, the still and motion video data 264, and the audio data 266. Textually based files include formats such as HTML, Wordperfect, MS Word, and Excel. Video data includes data compatible with known formats, such as MPEG, Apple QuickTime, etc.
The document generator 250 includes a content selection controller 350 for extracting desired SOR templates and content from SOR 330 in response to commands entered by user 255 through GUI 210. Content selection controller 350 places such extracted items into a workspace area 355 in document customizer memory, such as memory 106. An output organizer 360 supervises the display of the desired items in workspace 355 in accordance with user specified output formats. Also, user 255 can edit and arrange the data in workspace 355 via GUI 210 and output organizer 360, to thereby construct a final, customized document suitable for output. In other words, document organizer 250 permits user 255 to visualize and rearrange selected discovery data from the SOR 330, in order to generate a customized output document incorporating the selected discovery information.
The content column 415 of document 400 is the template for obtaining content in column 415. Content column 410 represents the discovery information collected by, for example, a data warehouse professional during an engagement with a customer. The content column can contain default values to be used as a guide during the engagement.
With reference to document 400, column 410 includes the following template entries: Table Name 418A; Table Description 418B; Data Element Names 418C; Data Location 418D; Physical Location 418E; Administrator 418F; Administrator Phone Number 418G; Extraction Utility 418H; Extraction Output Filename 418I; Data Transfer Method 418J; and Data Transfer Frequency 418K.
The content column 415 includes the following entries for a data source for billing records: names 420A of source databases and source files providing a source of data to the data warehouse; descriptions 420B of the source databases and files; logical data models 420C of the source databases and files and of the data residing in the databases and files; locations of the source databases and files including an identifier 420D of the type of device wherein the source database and files reside and geographical locations 420E of the devices; names 420F and contact information 420G relating to administrators of the source databases and files; extraction utility information 420H and extraction output file names 420I; updating frequency of the source databases and files (not shown in
The document 400 also includes the configuration control table 405 indicating the revision history of the document 400 and thus enabling data warehouse professionals to track the evolution of the document 400. For each engagement resulting in an update to any SOR documents 400 in SOR 330, document customizer 200 populates a configuration record (row) 425 for each particular document 400 in configuration control table 405 with configuration control items, including, for example, a revision level 430A, a calendar date 430B, the name of a responsible individual 430C, a project identifier 430D, and the current size 430E of SOR 330. Configuration control table 405 can be expanded to include additional configuration control items as needed.
At step 510, the most current information available in knowledge base 270 is downloaded to document customizer database 205, as described above.
Next, at step 520, discovery information is captured from the customer during an engagement using one or more of the following collection techniques: a manual collection technique, a semi-automatic collection technique, and an automatic collection technique. The manual technique involves providing hard-copy query forms to the customer, the semi-automatic technique includes a computerized solicitation process, and the automatic technique involves importing external discovery data 260 into document customizer 200. The semi-automatic and automatic collection techniques are now described in sequence.
User 255 solicits and records discovery data from the customer in an organized, standardized manner using document customizer 200. Using the semi-automatic collection technique, GUI 210 presents to user 255 a menu driven, hierarchical sequence of discovery data queries requiring discovery data answers, to thereby step user 255 logically through the discovery solicitation process. Data collection controller 220 accesses and links together the SOR templates 410 in SOR 330, and the query templates and menus resident in database 205 to create a top-down, standardized query outline. Data collection controller 220 submits the query outline to GUI 210.
In turn, GUI 210 presents the query outline, that is, the queries, to the user in a viewable format, including fields for accepting user inputs in the form of responses to the queries. GUI 210 accepts the user inputs and passes the input data to automatic collection agent 240 via collection controller 220. In turn, automatic collection agent 240 populates the associated SOR template with the input data—which becomes SOR content—and in this way, SOR 330 is established.
Data collection controller 220 imposes a set of rules for soliciting discovery data using the query outline. Although user 255 has the freedom to traverse the query outline in the manner the user sees fit, at step 530 of the method of
The following example serves to illustrate the above mentioned exception handling. Initially, GUI 210 presents a main menu to user 255, followed by a sequence of queries in outline form. In this example, Billing record template 410 of table 400 (see
If user 255 jumps ahead and answers the query requesting data transfer frequency 420K before answering the preceding queries, data collection controller 220 generates and records in table 222 an exception indicating that the user failed to answer the queries in the predefined order in which the queries were presented. The exception is linked to each of the unanswered preceding queries, e.g., logical definition 420C and geographical location 420E, and any other intervening queries. An exception can also be generated when a table has been updated (
Using the automatic collection technique, external I/F 230 accepts externally supplied discovery data 260, and then transmits the data to automatic collection agent 240. Automatic collection agent 240 stores the externally supplied data to database 205 and links the external data to one or more appropriate SOR templates. Such linking causes the external data to be accessible to the user when the associated SOR template is accessed by the user. For example, if the external data is an MS Word business report relating to billing records, agent 240 links the MS Word report to billing record table 400, depicted in
Next, at step 535, user 255 can generate a customized document (e.g., document 207) using document generator 250, as will be described below.
Next, at step 540, document customizer 200 updates configuration control table 405, and uploads SOR 330 to knowledge base 270, to thereby establish a current, configuration controlled, centralized record of SOR 330. The process ends at step 550.
A detailed sequence of method steps performed in generating a document using document customizer 200, step 535 above, is depicted in
Next, at step 610, user 255 identifies and selects those portions of document 400 which are to be incorporated into output, such as document 207. User 255 selects identified portions of document 400 by selecting one or more SOR templates from a hierarchical menu of SOR templates displayed to the user.
Next, at step 620, content selection controller 350 extracts the selected SOR templates and associated content from SOR 330, and loads the extracted information into workspace 355. Output organizer 360 and GUI 210 display the extracted information to user 255 in a raw, textual format, to thereby enable user 255 to visualize the extracted information in workspace 355.
Next, at step 630, user 255 selects desired output formats for the discovery information in workspace 355. Specifically, user 255 chooses one or more output formats from SOR database 330, and associates the selected output formats with selected portions of the discovery information visualized in workspace 355. Output formats residing in database component 310 include industry standardized format definitions, such as definitions for MS Word, Wordperfect, Powerpoint, and multimedia (video and audio) formats, as well as customized formats defined apriori by the user and stored to database component 310 as a customized output format.
In an exemplary sequence of steps corresponding to step 630, user 255 first highlights portions of visualized text in workspace 355, and then associates an output template format with the highlighted text portions by selecting the desired format, such as MS Word, WordPerfect, HTML or XML, from a displayed menu or list of output template formats residing in database component 310.
Next, at step 640, if desired, user 255 rearranges visualized information in workspace 355 using any known technique, such as a “highlight text, then drag-and-drop” technique similar to that used in MS Word. In this manner, different portions of SOR 330 can be arranged by user 255 in any desired order. For example, textual and tabulated information can be positioned above multimedia items, etc.
After user 255 arrives at a desired, visualized arrangement of the information residing in workspace 355, at step 650, user 255 can command document customizer 200 to store the final, customized document residing in workspace 355 in a file. User 255 can also output the customized document to a printer or any other output device compatible with the output formats defined for the document, such as a multimedia output device (e.g., display and speaker of a personal computer). The process ends at step 660 when user 255 deactivates document generator 250.
An exemplary text based document or report 670 generated by document customizer 200 is depicted in
It should now be apparent that a method and apparatus for documenting an electronic and/or physical footprint of an engagement process used in a data warehouse environment has been described. The present invention establishes a system of record document defining the system parameters of the data warehouse and records the footprint and associated changes or content and processes as a data warehouse professional interacts with a customer.
It will be readily seen by one of ordinary skill in the art that the present invention solicits for, collects and records discovery information in a standardized, organized manner, to produce a centrally accessible, configuration controlled system-of-record database for a data warehouse. The present invention also generates a customized document based on the system-of-record. After reading the foregoing specification, one of ordinary skill will be able to affect various changes, substitutions of equivalents and various other aspects of the invention as broadly disclosed herein. It is therefore intended that the protection granted hereon be limited only by the definition contained in the appended claims and equivalents thereof.
|US5559692||5. Okt. 1994||24. Sept. 1996||Core Systems, Inc.||Customizable data gathering method which allows the user to define the classes of data which are gathered|
|US5615367||25. Mai 1993||25. März 1997||Borland International, Inc.||System and methods including automatic linking of tables for improved relational database modeling with interface|
|US5659676||20. Sept. 1994||19. Aug. 1997||International Business Machines Corporation||Systems and methods for creating and refreshing compound documents|
|US5675785||4. Okt. 1994||7. Okt. 1997||Hewlett-Packard Company||Data warehouse which is accessed by a user using a schema of virtual tables|
|US5692206||30. Nov. 1994||25. Nov. 1997||Taco Bell Corporation||Method and apparatus for automating the generation of a legal document|
|US5701453||1. Juli 1993||23. Dez. 1997||Informix Software, Inc.||Logical schema to allow access to a relational database without using knowledge of the database structure|
|US5717923||3. Nov. 1994||10. Febr. 1998||Intel Corporation||Method and apparatus for dynamically customizing electronic information to individual end users|
|US5771379||1. Nov. 1995||23. Juni 1998||International Business Machines Corporation||File system and method for file system object customization which automatically invokes procedures in response to accessing an inode|
|US5784562||10. Okt. 1995||21. Juli 1998||U S West Advanced Technologies, Inc.||System for using a dialog session context to process electronic forms data on the world wide web|
|US5812134||28. März 1996||22. Sept. 1998||Critical Thought, Inc.||User interface navigational system & method for interactive representation of information contained within a database|
|US6032158 *||2. Mai 1997||29. Febr. 2000||Informatica Corporation||Apparatus and method for capturing and propagating changes from an operational database to data marts|
|US6035330 *||29. März 1996||7. März 2000||British Telecommunications||World wide web navigational mapping system and method|
|US6067523 *||3. Juli 1997||23. Mai 2000||The Psychological Corporation||System and method for reporting behavioral health care data|
|US6128624 *||12. Nov. 1997||3. Okt. 2000||Ncr Corporation||Collection and integration of internet and electronic commerce data in a database during web browsing|
|US6151584 *||20. Nov. 1997||21. Nov. 2000||Ncr Corporation||Computer architecture and method for validating and collecting and metadata and data about the internet and electronic commerce environments (data discoverer)|
|US6151586 *||21. Nov. 1997||21. Nov. 2000||Health Hero Network, Inc.||Computerized reward system for encouraging participation in a health management program|
|US6163774 *||24. Mai 1999||19. Dez. 2000||Platinum Technology Ip, Inc.||Method and apparatus for simplified and flexible selection of aggregate and cross product levels for a data warehouse|
|US6167405 *||27. Apr. 1998||26. Dez. 2000||Bull Hn Information Systems Inc.||Method and apparatus for automatically populating a data warehouse system|
|US6178418 *||28. Juli 1998||23. Jan. 2001||Noetix Corporation||Distributed data warehouse query and resource management system|
|US6243703 *||14. Okt. 1997||5. Juni 2001||International Business Machines Corporation||Method of accessing and displaying subsystem parameters including graphical plan table data|
|US6289460 *||6. Dez. 1999||11. Sept. 2001||Astus Corporation||Document management system|
|US6353840 *||13. Aug. 1998||5. März 2002||Ricoh Company, Ltd.||User-defined search template for extracting information from documents|
|US6363391 *||29. Mai 1998||26. März 2002||Bull Hn Information Systems Inc.||Application programming interface for monitoring data warehouse activity occurring through a client/server open database connectivity interface|
|US6363393 *||22. Febr. 1999||26. März 2002||Ron Ribitzky||Component based object-relational database infrastructure and user interface|
|US6654737 *||23. Mai 2000||25. Nov. 2003||Centor Software Corp.||Hypertext-based database architecture|
|US6854086 *||13. Nov. 2002||8. Febr. 2005||Michael Umen & Co., Inc.||Drug document production system|
|CA2310943A1 *||2. Juni 2000||2. Dez. 2001||Michael J. Sikorsky||Methods, techniques, software and systems for providing context independent, protocol independent portable or reusable development tools|
|EP0703537A1 *||8. Aug. 1995||27. März 1996||International Business Machines Corporation||Systems and methods for creating and refreshing compound documents|
|EP0706140A1 *||15. Sept. 1995||10. Apr. 1996||Hewlett-Packard Company||Intelligent data warehouse|
|EP1160715A2 *||25. Mai 2001||5. Dez. 2001||iLaunch Inc.||Computerised record keeping and process control|
|GB2386219A *||Titel nicht verfügbar|
|Zitiert von Patent||Eingetragen||Veröffentlichungsdatum||Antragsteller||Titel|
|US7558799 *||1. Juni 2004||7. Juli 2009||Microsoft Corporation||Method, system, and apparatus for discovering and connecting to data sources|
|US7953712 *||24. Febr. 2005||31. Mai 2011||Sap Ag||Computer system, a database for storing electronic data and a method to operate a database system|
|US8179555||8. März 2002||15. Mai 2012||Hewlett-Packard Development Company, L.P.||Printing and finishing capability for customized document production system and method|
|US8185632||12. März 2009||22. Mai 2012||International Business Machines Corporation||Discovery of a generic device in a non-linear discovery framework|
|US8234569 *||28. Febr. 2007||31. Juli 2012||Business Objects Software Ltd.||Apparatus and method for defining and processing publication objects|
|US8479094 *||8. Sept. 2009||2. Juli 2013||Kenneth Peyton Fouts||Interactive writing aid to assist a user in finding information and incorporating information correctly into a written work|
|US8930356 *||12. Nov. 2007||6. Jan. 2015||Yahoo! Inc.||Techniques for modifying a query based on query associations|
|US9116863 *||31. Jan. 2012||25. Aug. 2015||The Boeing Company||Systems and methods for assembling documents|
|US20050193042 *||24. Febr. 2005||1. Sept. 2005||Carola Steinmaier||Computer system, a database for storing electronic data and a method to operate a database system|
|US20050262437 *||10. Febr. 2005||24. Nov. 2005||Patterson Dennis M||Process for creating and printing customized document at end user computer and printer|
|US20050278307 *||1. Juni 2004||15. Dez. 2005||Microsoft Corporation||Method, system, and apparatus for discovering and connecting to data sources|
|US20070204216 *||24. Febr. 2006||30. Aug. 2007||Morgan Brian S||System and method for creating layouts using a layout editor|
|US20080208906 *||28. Febr. 2007||28. Aug. 2008||Business Objects, S.A.||Apparatus and method for defining and processing publication objects|
|US20090083226 *||12. Nov. 2007||26. März 2009||Jaya Kawale||Techniques for modifying a query based on query associations|
|US20100235510 *||12. März 2009||16. Sept. 2010||Eric Wade Brown||Discovery of a generic device in a non-linear discovery framework|
|US20110060761 *||8. Sept. 2009||10. März 2011||Kenneth Peyton Fouts||Interactive writing aid to assist a user in finding information and incorporating information correctly into a written work|
|US20110295761 *||27. Mai 2011||1. Dez. 2011||Kabushiki Kaisha Toshiba||Business form management system, method and program|
|US20140298243 *||29. März 2013||2. Okt. 2014||Alcatel-Lucent Usa Inc.||Adjustable gui for displaying information from a database|
|US-Klassifikation||1/1, 715/205, 715/246, 715/207, 707/E17.005, 707/999.107, 707/999.104, 707/999.2, 707/999.001|
|Internationale Klassifikation||G06F17/00, G06F15/00, G06F17/30|
|Unternehmensklassifikation||Y10S707/99948, Y10S707/99931, Y10S707/99945, G06F17/30592, G06F17/2229, G06F17/212|
|Europäische Klassifikation||G06F17/30S8M, G06F17/22F, G06F17/21F2|
|28. Juni 2000||AS||Assignment|
Owner name: NCR CORPORATION, OHIO
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:BETZ, EUGENE M.;VANNAVADA, MAHESH P.;CHIANG, LUO-JEN;ANDOTHERS;REEL/FRAME:010884/0829
Effective date: 20000223
|21. Dez. 2007||AS||Assignment|
Owner name: TERADATA US, INC., OHIO
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:NCR CORPORATION;REEL/FRAME:020540/0786
Effective date: 20070924
|29. Dez. 2009||FPAY||Fee payment|
Year of fee payment: 4
|4. März 2014||FPAY||Fee payment|
Year of fee payment: 8