US5794246A - Method for incremental aggregation of dynamically increasing database data sets - Google Patents
Method for incremental aggregation of dynamically increasing database data sets Download PDFInfo
- Publication number
- US5794246A US5794246A US08/846,934 US84693497A US5794246A US 5794246 A US5794246 A US 5794246A US 84693497 A US84693497 A US 84693497A US 5794246 A US5794246 A US 5794246A
- Authority
- US
- United States
- Prior art keywords
- data
- stored
- intermediate file
- group identifier
- value
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/244—Grouping and aggregation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- Y—GENERAL 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
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
-
- Y—GENERAL 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
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
- Y10S707/99934—Query formulation, input preparation, or translation
-
- Y—GENERAL 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
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99937—Sorting
-
- Y—GENERAL 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
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
Definitions
- the present invention relates to database systems. More specifically, the present invention pertains to a method for incremental aggregation of a dynamically increasing computer database data set.
- Computers are used to perform a wide variety of applications in such diverse fields as finance and commercial transactions, manufacturing, healthcare, telecommunications, etc. Most of these applications typically involve inputting data, processing the data according to a computer program, and then storing the results in a database. As computers became more powerful, faster, and versatile, the amount of data that can be processed correspondingly increased. In order to keep up with advances in computer technology, it became imperative that databases be designed for peak operational efficiency. Consequently, operational databases were constructed, categorized, and formatted in a manner conducive for maximum throughput, access time, and storage capacity.
- Extracting raw data from one or more operational databases and transforming it into useful information is the function of data "warehouses" and data "marts.”
- data warehouses and data marts the data is structured to satisfy decision support roles rather than operational needs.
- the corresponding source data from an operational database is filtered to remove extraneous and erroneous records; cryptic and conflicting codes are resolved; raw data is translated into something more meaningful; and summary data that is useful for decision support, trend analysis or other end-user needs is pre-calculated.
- the data warehouse is comprised of an analytical database containing extremely large amounts of data useful for decision support.
- 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. With data warehouses and data marts, useful information is retained at the disposal of the decision makers.
- An example of the type of company that would use data warehousing is a hotel chain having thousands of hotels located worldwide which all keep track of the details of each customer's visit. By warehousing this data, top executives of the hotel chain can access this stored data from the data warehouse, which can be use to make key decisions on how to better serve their customers throughout the world.
- the reason for the long aggregation processing time is that all the pertinent data stored within the data mart or data warehouse is reaggregated along with the newly inputted data.
- the problem of long aggregation processing time becomes compounded as very large amounts of data are frequently received for input into the data mart or data warehouse. For instance, if a data warehouse contains terabytes of stored data and one million records of data are received for input every week, the central computers accessing the data warehouse are overwhelmed trying to perform the reaggregations of the stored complete data set each time new data is received for input.
- the present invention is a method of performing incremental aggregation of dynamically increasing database data sets.
- An embodiment of the present invention operates within a data mart or data warehouse to aggregate data stored within an operational database corresponding to newly received or inputted data to provide the most current up-to-date information.
- a computer server creates an intermediate file which is initialized with an aggregate data set.
- the aggregate data set consists of data values and count values that each correspond to specific group identifiers.
- the present invention is ready to receive a new set of input data, consisting of data values that each correspond to specific group identifiers.
- the computer determines if any of the group identifiers located within the new set of inputs are identical to any of the group identifiers stored within the intermediate file. If an inputted group identifier matches a stored group identifier, the inputted data value corresponding to the inputted group identifier, is aggregated with the stored data value corresponding to the stored group identifier. The count value corresponding to the stored group identifier is incremented by the value of one. If an inputted group identifier does not match any of the group identifiers stored within the intermediate file, the inputted group identifier and corresponding inputted data value are stored within the intermediate file and a count value of one is appended to the that specific group identifier.
- the computer to stores all the changes that were made to the intermediate file into the aggregate data set.
- the aggregate data set is updated with the most current information without having to update the entire aggregate data set.
- FIG. 1 illustrates a computer system database that the present invention resides within to perform its operations of incremental aggregation on dynamically increasing database data sets.
- FIG. 2 illustrates a flowchart of an embodiment of the present invention which performs incremental aggregation comprising of Sum, Average or Count on dynamically increasing database data sets.
- FIG. 3A illustrates a block diagram and tables representing how the present invention operates to incrementally aggregate dynamically increasing database data sets.
- FIG. 3B shows source table 300a' and target table 302a of FIG. 3A to illustrate more fully how the present invention incrementally aggregates dynamically increasing the database data sets.
- FIG. 1 illustrates a computer system database that the present invention resides within to perform its aggregate operations of inputted data into the database system.
- This database system is made up of dedicated computer terminals 101-105 (e.g., personal computers, laptop computers, workstations, terminals, etc.) which are used to access the information accessible to server 110 (e.g., Unix or NT server computer).
- server 110 e.g., Unix or NT server computer.
- Each computer terminals 101-105 has its own physical memory system (e.g., hard drive, random access memory, read only memory, etc.) for storing and manipulating data.
- Server 110 is connected to mass storage device 112 which allows computer terminals 101-105 to access extremely large amounts of data located within mass storage device 112.
- Server 110 also has its own physical memory system which is accessible by computer terminals 101-105.
- server 110 Within the memory system of server 110 is located an in memory representation of the intermediate disk file 114, which is used during the aggregation operations of the present invention within server 110 for display on computer terminals 101-105.
- operational database 116 Located within mass storage device 112 is operational database 116, which stores the raw data for a data mart or data warehouse.
- Data marts/warehouses 113 located within mass storage device 112, translates the raw data stored within operational database 116 into information that is more meaningful for decision support.
- Either intermediate disk file 115, located within mass storage memory device 112, or the in memory representation intermediate disk file 114 can be used by the present invention to perform its aggregation operations.
- Server 110 and mass storage device 112 are representative of a data warehouse, data mart, or any large database. It is important to point out that data marts/warehouses 113, intermediate disk file 115, and operational database 116 could each reside within a separate mass storage device and each mass storage device could be connected to a separate server.
- FIG. 2 illustrates a flowchart of an embodiment of the present invention which performs incremental aggregation comprising of Sum, Average, or Count on dynamically increasing database data sets.
- FIG. 2 includes process 200 which starts at step 202.
- Step 204 directs server 110 of FIG. 1 to create and initialize either intermediate disk file 114 or 115 with the aggregated data set currently stored within a target table located within data marts/warehouses 113.
- the purpose of step 204 is to prepare either intermediate disk file 114 or 115 to store the aggregation of newly inputted data from operational database 116 with the data that has already been stored within the target table within data marts/warehouses 113.
- the present invention can use either intermediate disk file 114 or 115 for its aggregation operations. For clarity during the explanation of the operation of the present invention, intermediate disk file 115 will be used during further description of process 200.
- step 206 of FIG. 2 directs server 110 to receive the new input row, which contains group identifiers and corresponding data values.
- the group identifier defines a specific group of items (e.g., hamburgers) while the data value could represent how many of the group were sold.
- Step 207 directs server 110 to examine the input row, which contains the group identifier and its corresponding data value, to determine the type of function that will be performed on the group identifier and corresponding data value during steps 210 or 214.
- the functions that could be performed by server 110 on the group identifier and corresponding data value are an insert, update, or delete function.
- the insert function directs server 110 to add the data of the input row to intermediate file 115 while the delete function directs server 110 to remove the data of the input row from intermediate file 115.
- the update function directs server 110 to propagate the change or changes located within the data of the input row into intermediate file 115. To clarify the explanation of the operation of the present invention, the insert function will be performed on the group identifier and corresponding data value of each input row within the intermediate file 115.
- step 208 directs server 110 to determine whether a received group identifier of an input row is already located within the stored information of intermediate disk file 115. If the received group identifier is not located within intermediate disk file 115, server 110 is directed to step 214. Step 214 directs server 110 to add the new unique group identifier and its corresponding data value to the list of data stored within intermediate disk file 115. Step 216 directs server 110 to store a count value equal to the value of one that corresponds to the new group identifier just added to the stored data within intermediate disk file 115.
- step 208 of FIG. 2 directs server 110 to step 210.
- Step 210 directs server 110 to aggregate the newly received data value with the stored data value, located within intermediate disk file 115, both data values corresponding to the same group identifier.
- Step 212 directs server 110 to increment the stored count value by one which corresponds to the same group identifier of step 210.
- the stored count value, corresponding to a specific group identifier represents the amount of times that specific group identifier has been received by server 110.
- Steps 212 and 216 both direct server 110 to step 218 of FIG. 2.
- Step 218 directs server 110 to determine if the last group identifier and its corresponding data value have been received and processed by process 200. If the last group identifier and its corresponding data value have not been received and processed, step 218 directs server 110 to step 206. Server 110 repeats steps 206-218 until the last group identifier and data value have been received and processed by server 110.
- step 218 directs server 110 to step 220.
- Step 220 directs server 110 to propagate the changes made within intermediate disk file 115 to the target table stored within data marts/warehouses 113 to update it with the new information. For optimization in speed, only the changes that occurred within intermediate disk file 115 are stored within the target table located within data marts/warehouses 113. This optimization results in quicker storage and the elimination of unneeded storing procedures.
- step 220 is completed, server 110 is directed to step 222 which ends process 200.
- each distinctive group identifier along with its corresponding sum of data values and a count corresponding to each specific group identifier indicating the amount of times each specific group identifier was received.
- server 110 determines the average data value for each group identifier as part of its aggregation operations.
- the average data value, Average, for a specific group identifier is computed by server 110 based on the relationship shown below:
- Sum is equal to the sum of the data values of a group identifier and Count is equal to the count corresponding to that particular group identifier.
- the average data value can be computed for each group identifier and provides important information about the raw stored data.
- the present invention is also able to direct server 110 (FIG. 1) to use the data values of the group identifiers to compute the maximum and minimum data values.
- Computing the maximum and minimum data values are each a separate function of the aggregation operations of the present invention. Determining the maximum data value of all the groups could be useful in determining, for example, the customer who has spent the most amount of money. Computing the minimum data value of all the group identifiers can likewise result in useful information for a decision maker.
- server 110 (FIG. 1) to compute the variance of a user defined value or variable x.
- the variance of a number is computed by server 110 based on the relationship shown below: ##EQU1## Wherein xi is one of the elements of a user defined value x and n is the number of elements in the set of x. If the value of n is equal to 1, the variance is equal to zero.
- xi is one of the elements of a user defined value x and n is the number of elements in the set of x. If the value of n is equal to 1, the variance is equal to zero.
- Another function included within the incremental aggregation operations of the present invention is the ability to direct server 110 to compute the standard deviation of a user defined value or variable x.
- the standard deviation is computed by first computing the variance as described above and then executing the square root of the value that represents the variance. Computing the standard deviation of a user defined value can result in the translating of unintelligible data into useful information to be use in making key decisions.
- the present invention has the ability within its incremental aggregation operations to direct server 110 to compute the median of a user defined value or variable x. Furthermore, the present invention has the ability within its incremental aggregation operations to direct server 110 to compute the rank of a user defined value or variable x.
- the rank function may require server 110 to rank the ten largest data values located within intermediate file 115 in a list in descending order. Computing the median or rank of a user defined value can result in the translating of unintelligible data into useful information to be use in making key decisions.
- FIG. 3A illustrates a block diagram and tables representing how the present invention operates to direct server 110 (FIG. 1) to incrementally aggregate dynamically increasing database data sets.
- Source table 300 represents the newly inputted data of operational database 116 that is received by server 110 for eventual storage within target table 302, located within data marts/warehouses 113.
- Located within source table 300 is source fields 304 and 308 which jointly contain specific newly inputted data.
- Source field 308 contains the newly inputted group identifiers while source field 304 contains their corresponding data values.
- Target table 302 contains target fields 306 and 310 which jointly contain the stored aggregated data value for each corresponding group identifier.
- target field 310 contains the stored unique group identifiers while target field 306 contains the corresponding aggregated sum data values of each group identifier.
- Source table 300a and target table 302a of FIG. 3A are provided to illustrate a specific example of how the present invention directs server 110 (FIG. 1) to perform aggregate operations.
- Source table 300a and target table 302a each represent a more detailed depiction of source table 300 and target table 302, respectively.
- Source field 304a of source table 300a contain the data values while source field 308a contains the corresponding group identifiers.
- Each data value of source field 304a corresponds to the group identifier of source field 308a located within the same row of source table 300a.
- each aggregated sum data value of target field 306a corresponds to the group identifier of target field 310a located within the same row of target table 302a.
- source table 300a and target table 302a of FIG. 3A will be used in a specific example.
- the data value corresponding to the hamburgers group represents the amount of hamburger that were sold within an hour.
- the data value corresponding to the apple pie group represents the amount of apple pies that were sold within an hour.
- the data value corresponding to the milk shake group represents the amount of milk shakes that were sold within an hour.
- Source field 308a of FIG. 3A contains the different group identifiers while source field 304a contains their corresponding data values. It can be observed that the first row within source table 300a represents the fact that 5 hamburgers were sold within an hour, while the second row represents the fact that 6 apple pies were sold within an hour. The third row within source table 300a represents the fact that 3 hamburgers were sold within an hour, while the fourth row represents the fact that 4 milk shakes were sold within an hour. The fifth row located within source table 300a represents the fact that 7 apple pies were sold within an hour. The present invention directs the aggregation of this newly inputted data and then stores this information within target table 302a.
- the present invention directs server 110 to receive and aggregate all the data values of the hamburger group and store them for a total of 8 hamburgers sold within an hour, which is shown in the first row of target table 302a.
- the present invention directs server 110 to receive and aggregate all the data values of the apple pie group and store them for a total of 13 apple pies sold within an hour, which is shown in the second row of target table 302a.
- the present invention directs server 110 to receive the data value of the milk shake group and store it for a total of 4 milk shakes sold within an hour, which is shown in the third row of target table 302a.
- This example illustrates the aggregation operation that is performed by server 110 (FIG.
- FIG. 3B shows source table 300a' and target table 302a of FIG. 3A to illustrate more fully how the present invention incrementally aggregates dynamically increasing the database data sets.
- Target table 302a is exactly the same table that is shown in FIG. 3A, except that it exhibits how the present invention directs server 110 to change the data values and add new group identifiers and their corresponding data values, as they are received.
- Source table 300a' is the same type of table representation as source table 300a of FIG. 3A, except that source table 300a' represents a new set of input data values along with corresponding group identifiers.
- the group identifiers located within both source table 300a' and target table 302a represent that same things as described above for FIG. 3A. The only difference is that there is a new group identifier that has not yet been defined.
- the data value corresponding to the salad group represents the amount of salads that were sold within an hour.
- Source field 308a' of FIG. 3B contains the different group identifiers while source field 304a' contains their corresponding data values. It can be observed that the first row within source table 300a' represents the fact that 5 milk shakes were sold within an hour, while the second row represents the fact that 6 salads were sold within an hour. The third row within source table 300a' represents the fact that 4 hamburgers were sold within an hour.
- the present invention directs server 110 to receive this second set of newly inputted data and then incrementally aggregate it and store it within target table 302a.
- the present invention directs server 110 (FIG. 1) to receive all the data values of the hamburger group and incrementally aggregate them with the data value that already existed in FIG. 3A and store them for a new total of 12 hamburgers sold within an hour, which is shown in the first row of target table 302a.
- the present invention did not receive any data values for the apple pie group, so the data value that already existed within target table 302a for the apple pie group is not modified and remains constant at 13 apple pies sold within an hour. This constant data value of the apple pie group is shown in the second row of target table 302a.
- the present invention directs server 110 to receive all the data values of milk shake group and aggregate them with the data value that already existed in FIG.
- server 110 (FIG. 1) to receive the new salad group and its corresponding data value and store them within target table 302a for a total of 6 salads sold within an hour, which is shown in the fourth row of the table.
- This example illustrates the incremental aggregation operation that is performed by the present invention on dynamically increasing database data sets.
- a high speed search mechanism is used to search through intermediate disk file 114, which resides within server 110 of FIG. 1, or intermediate disk file 115.
- One way to implement this high speed search mechanism within the present invention is to use a b-tree, which is well-known to those of ordinary skill in the art. For example, assume there is one million groups stored within intermediate disk file 114 of FIG. 1. A new group is inputted into server 110 from operational database 116, which needs to determine if the newly received group is located within the one million stored groups or not. The b-tree methodology is able to quickly determine whether the newly received group is located within the one million stored groups without evaluating each and every stored group.
- Another embodiment of the present invention to quicken the aggregation operations is to move the data stored within either intermediate disk files 114 or 115 into the random access memory (RAM) of server 110 of FIG. 1. This allows the aggregation operations of the present invention to be performed much quicker than if it was done from the hard drive of server 110. In other words, the present invention will cache the b-tree disk file in RAM to be utilized.
- RAM random access memory
- a method for maintaining the integrity of either intermediate files 114 or 115 of FIG. 1 there is a method for maintaining the integrity of either intermediate files 114 or 115 of FIG. 1.
- a copy is made of either intermediate files 114 or 115 before and after the new inputted data from operational database 116 is aggregated by the present invention.
- This copying is also performed to guard against a system failure happening before or after aggregation has taken place.
- Another process that is performed to prevent against the loss of data during a system failure is that either intermediate disk files 114 or 115 have sealed significants of the data bits to ensure data correctness.
- individual intermediate disk files 114 or 115 may be created for each target table 302 (FIG. 3A) aggregation.
- target table 302 FIG. 3A
- a further embodiment of the present invention includes the ability to provide failure recovery support.
- a system failure can occur before or after it is constructed. If the failure occurs before the b-tree is constructed, the present invention is able to return to the previously saved point and maintain the data integrity. If the system failure occurs after the b-tree has been successfully constructed but before the target database has been updated, intermediate disk files 114 or 115 contains an accurate copy of the aggregated data but the target data is out of synch. To solve this problem, a specific mechanism is used that is able to load directly from the b-tree into the target table at high speeds without error.
Abstract
Description
Claims (16)
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US08/846,934 US5794246A (en) | 1997-04-30 | 1997-04-30 | Method for incremental aggregation of dynamically increasing database data sets |
JP54735498A JP2001522495A (en) | 1997-04-30 | 1998-04-29 | How to Aggregate a Dynamically Growing Database Data Set |
PCT/US1998/008667 WO1998049636A1 (en) | 1997-04-30 | 1998-04-29 | A method for incremental aggregation of dynamically increasing database data sets |
EP98920008A EP0979469A1 (en) | 1997-04-30 | 1998-04-29 | A method for incremental aggregation of dynamically increasing database data sets |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US08/846,934 US5794246A (en) | 1997-04-30 | 1997-04-30 | Method for incremental aggregation of dynamically increasing database data sets |
Publications (1)
Publication Number | Publication Date |
---|---|
US5794246A true US5794246A (en) | 1998-08-11 |
Family
ID=25299348
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US08/846,934 Expired - Lifetime US5794246A (en) | 1997-04-30 | 1997-04-30 | Method for incremental aggregation of dynamically increasing database data sets |
Country Status (4)
Country | Link |
---|---|
US (1) | US5794246A (en) |
EP (1) | EP0979469A1 (en) |
JP (1) | JP2001522495A (en) |
WO (1) | WO1998049636A1 (en) |
Cited By (106)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6014670A (en) * | 1997-11-07 | 2000-01-11 | Informatica Corporation | Apparatus and method for performing data transformations in data warehousing |
US6023694A (en) * | 1996-01-02 | 2000-02-08 | Timeline, Inc. | Data retrieval method and apparatus with multiple source capability |
WO2000042530A1 (en) * | 1999-01-15 | 2000-07-20 | Metaedge Corporation | Method for visualizing information in a data warehousing environment |
WO2000042553A2 (en) * | 1999-01-15 | 2000-07-20 | Harmony Software, Inc. | Method and apparatus for processing business information from multiple enterprises |
WO2000072165A1 (en) * | 1999-05-24 | 2000-11-30 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
WO2001067303A1 (en) * | 2000-02-28 | 2001-09-13 | Hyperroll Israel Ltd. | Multi-dimensional database and integrated aggregation server |
US6339775B1 (en) * | 1997-11-07 | 2002-01-15 | Informatica Corporation | Apparatus and method for performing data transformations in data warehousing |
US20020023091A1 (en) * | 2000-06-23 | 2002-02-21 | Silberberg David P. | Architecture for distributed database information access |
US6377934B1 (en) | 1999-01-15 | 2002-04-23 | Metaedge Corporation | Method for providing a reverse star schema data model |
US6393472B1 (en) | 1997-12-10 | 2002-05-21 | At&T Corp. | Automatic aggregation of network management information in spatial, temporal and functional forms |
US6411961B1 (en) | 1999-01-15 | 2002-06-25 | Metaedge Corporation | Apparatus for providing a reverse star schema data model |
US6434544B1 (en) * | 1999-08-04 | 2002-08-13 | Hyperroll, Israel Ltd. | Stand-alone cartridge-style data aggregation server providing data aggregation for OLAP analyses |
US6438538B1 (en) | 1999-10-07 | 2002-08-20 | International Business Machines Corporation | Data replication in data warehousing scenarios |
US20020178394A1 (en) * | 2000-11-06 | 2002-11-28 | Naama Bamberger | System for processing at least partially structured data |
US20020198902A1 (en) * | 2001-06-25 | 2002-12-26 | Mohan Sankaran | Real time sessions in an analytic application |
US20030009443A1 (en) * | 2001-06-15 | 2003-01-09 | Oleg Yatviskiy | Generic data aggregation |
US6513043B1 (en) | 2000-09-01 | 2003-01-28 | Syntricity, Inc. | System and method for storing, retrieving, and analyzing characterization data |
US20030037037A1 (en) * | 2001-08-17 | 2003-02-20 | Ec Outlook, Inc. | Method of storing, maintaining and distributing computer intelligible electronic data |
US20030065650A1 (en) * | 2001-10-03 | 2003-04-03 | Annand Ritchie I. | Method and query application tool for searching hierarchical databases |
US20030093429A1 (en) * | 2001-11-12 | 2003-05-15 | Hitachi, Inc. | Data warehouse system |
US6567796B1 (en) | 1999-03-23 | 2003-05-20 | Microstrategy, Incorporated | System and method for management of an automatic OLAP report broadcast system |
US6587547B1 (en) | 1999-09-13 | 2003-07-01 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, with real-time drilling via telephone |
US20030154194A1 (en) * | 2001-12-28 | 2003-08-14 | Jonas Jeffrey James | Real time data warehousing |
US6611216B1 (en) | 1999-02-02 | 2003-08-26 | Cisco Technology, Inc. | Fast look-up table based scheme for NRZI encoding/decoding and zero insertion/removal in serial bit streams |
US20030172084A1 (en) * | 2001-11-15 | 2003-09-11 | Dan Holle | System and method for constructing generic analytical database applications |
US6625617B2 (en) | 1996-01-02 | 2003-09-23 | Timeline, Inc. | Modularized data retrieval method and apparatus with multiple source capability |
US6631382B1 (en) | 1996-01-02 | 2003-10-07 | Timeline, Inc. | Data retrieval method and apparatus with multiple source capability |
US20030217079A1 (en) * | 2000-02-28 | 2003-11-20 | Reuven Bakalash | Customer relationship management (CRM) system with integrated data aggregation engine |
US20040162802A1 (en) * | 2003-02-07 | 2004-08-19 | Stokley-Van Camp, Inc. | Data set comparison and net change processing |
US20040205045A1 (en) * | 2001-04-04 | 2004-10-14 | Li-Wen Chen | Method and system for decision support analysis |
US20040243593A1 (en) * | 2003-06-02 | 2004-12-02 | Chris Stolte | Computer systems and methods for the query and visualization of multidimensional databases |
US6829334B1 (en) | 1999-09-13 | 2004-12-07 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, with telephone-based service utilization and control |
US6836537B1 (en) | 1999-09-13 | 2004-12-28 | Microstrategy Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for information related to existing travel schedule |
US6850603B1 (en) | 1999-09-13 | 2005-02-01 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized dynamic and interactive voice services |
US20050060556A1 (en) * | 2002-12-31 | 2005-03-17 | Jonas Jeffrey J. | Authorized anonymous authentication |
US20050060300A1 (en) * | 2003-09-16 | 2005-03-17 | Chris Stolte | Computer systems and methods for visualizing data |
US20050066182A1 (en) * | 2003-03-24 | 2005-03-24 | Systems Research & Development | Secure coordinate identification method, system and program |
US6885734B1 (en) | 1999-09-13 | 2005-04-26 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive inbound and outbound voice services, with real-time interactive voice database queries |
US20050125436A1 (en) * | 2003-12-03 | 2005-06-09 | Mudunuri Gautam H. | Set-oriented real-time data processing based on transaction boundaries |
US20050125568A1 (en) * | 2003-12-05 | 2005-06-09 | Yeo Soon I. | Method and apparatus for managing reconfiguration data memory |
US6940953B1 (en) | 1999-09-13 | 2005-09-06 | Microstrategy, Inc. | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services including module for generating and formatting voice services |
US6947934B1 (en) * | 2000-02-16 | 2005-09-20 | International Business Machines Corporation | Aggregate predicates and search in a database management system |
US6964012B1 (en) | 1999-09-13 | 2005-11-08 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, including deployment through personalized broadcasts |
US20060005127A1 (en) * | 2004-07-02 | 2006-01-05 | Ferguson Kevin M | System and method of format specification |
US20060004738A1 (en) * | 2004-07-02 | 2006-01-05 | Blackwell Richard F | System and method for the support of multilingual applications |
US20060004813A1 (en) * | 2004-07-02 | 2006-01-05 | Desbiens Marc A | Very large dataset representation system and method |
US20060005112A1 (en) * | 2004-07-02 | 2006-01-05 | David Lilly | System and method of report layout |
US7007029B1 (en) | 1999-01-15 | 2006-02-28 | Metaedge Corporation | System for visualizing information in a data warehousing environment |
US7080066B1 (en) | 2001-08-09 | 2006-07-18 | Ncr Corporation | Systems and methods for refining a decision-making process via executable sequences |
US20060206512A1 (en) * | 2004-12-02 | 2006-09-14 | Patrick Hanrahan | Computer systems and methods for visualizing data with generation of marks |
US7111010B2 (en) | 2000-09-25 | 2006-09-19 | Hon Hai Precision Industry, Ltd. | Method and system for managing event attributes |
US7117215B1 (en) | 2001-06-07 | 2006-10-03 | Informatica Corporation | Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface |
US7162643B1 (en) | 2001-06-15 | 2007-01-09 | Informatica Corporation | Method and system for providing transfer of analytic application data over a network |
US7174342B1 (en) | 2001-08-09 | 2007-02-06 | Ncr Corp. | Systems and methods for defining executable sequences to process information from a data collection |
US20070038664A1 (en) * | 2002-12-27 | 2007-02-15 | Jonas Jeffrey J | Real time data warehousing |
US20070061611A1 (en) * | 2005-09-09 | 2007-03-15 | Mackinlay Jock D | Computer systems and methods for automatically viewing multidimensional databases |
US7197461B1 (en) | 1999-09-13 | 2007-03-27 | Microstrategy, Incorporated | System and method for voice-enabled input for use in the creation and automatic deployment of personalized, dynamic, and interactive voice services |
US7233952B1 (en) | 1999-01-15 | 2007-06-19 | Hon Hai Precision Industry, Ltd. | Apparatus for visualizing information in a data warehousing environment |
US7266181B1 (en) | 1999-09-13 | 2007-09-04 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized dynamic and interactive voice services with integrated inbound and outbound voice services |
US20070250523A1 (en) * | 2006-04-19 | 2007-10-25 | Beers Andrew C | Computer systems and methods for automatic generation of models for a dataset |
US7308542B1 (en) * | 2004-02-19 | 2007-12-11 | Microsoft Corporation | Data integrity protection for stored data |
US7320001B1 (en) | 1999-01-15 | 2008-01-15 | Hon Hai Precision Industry, Ltd. | Method for visualizing information in a data warehousing environment |
US7340040B1 (en) * | 1999-09-13 | 2008-03-04 | Microstrategy, Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for corporate-analysis related information |
US20080071818A1 (en) * | 2006-09-18 | 2008-03-20 | Infobright Inc. | Method and system for data compression in a relational database |
US20080099831A1 (en) * | 2006-10-31 | 2008-05-01 | Oki Electric Industry Co., Ltd. | Semiconductor memory device and method for the same |
US20080140696A1 (en) * | 2006-12-07 | 2008-06-12 | Pantheon Systems, Inc. | System and method for analyzing data sources to generate metadata |
US7421458B1 (en) | 2003-10-16 | 2008-09-02 | Informatica Corporation | Querying, versioning, and dynamic deployment of database objects |
US20090106210A1 (en) * | 2006-09-18 | 2009-04-23 | Infobright, Inc. | Methods and systems for database organization |
US7720842B2 (en) | 2001-07-16 | 2010-05-18 | Informatica Corporation | Value-chained queries in analytic applications |
US7900052B2 (en) | 2002-11-06 | 2011-03-01 | International Business Machines Corporation | Confidential data sharing and anonymous entity resolution |
US20110099167A1 (en) * | 2004-05-26 | 2011-04-28 | Nicholas Galbreath | Graph Server Querying for Managing Social Network Information Flow |
US8204831B2 (en) | 2006-11-13 | 2012-06-19 | International Business Machines Corporation | Post-anonymous fuzzy comparisons without the use of pre-anonymization variants |
US8321411B2 (en) | 1999-03-23 | 2012-11-27 | Microstrategy, Incorporated | System and method for management of an automatic OLAP report broadcast system |
US8417727B2 (en) | 2010-06-14 | 2013-04-09 | Infobright Inc. | System and method for storing data in a relational database |
US20130182287A1 (en) * | 2012-01-17 | 2013-07-18 | Toshiba Tec Kabushiki Kaisha | Information processing apparatus |
US8521748B2 (en) | 2010-06-14 | 2013-08-27 | Infobright Inc. | System and method for managing metadata in a relational database |
USRE44478E1 (en) | 2002-02-22 | 2013-09-03 | Informatica Corporation | Method and system for navigating a large amount of data |
US8533661B2 (en) | 2007-04-27 | 2013-09-10 | Dell Products, Lp | System and method for automated on-demand creation of a customized software application |
US20130290690A1 (en) * | 2012-04-30 | 2013-10-31 | Dell Products, Lp | Cloud Based Master Data Management System with Configuration Advisor and Method Therefore |
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 |
US8607138B2 (en) | 1999-05-28 | 2013-12-10 | Microstrategy, Incorporated | System and method for OLAP report generation with spreadsheet report within the network user interface |
US20140095515A1 (en) * | 2011-05-18 | 2014-04-03 | Elyasaf Korenwaitz | Real time single-sweep detection of key words and content analysis |
US8782103B2 (en) | 2012-04-13 | 2014-07-15 | Dell Products, Lp | Monitoring system for optimizing integrated business processes to work flow |
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 |
US8819072B1 (en) * | 2004-02-02 | 2014-08-26 | Microsoft Corporation | Promoting data from structured data files |
US8943076B2 (en) | 2012-02-06 | 2015-01-27 | Dell Products, Lp | System to automate mapping of variables between business process applications and method therefor |
US8995628B2 (en) | 1999-09-13 | 2015-03-31 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services with closed loop transaction processing |
US9015106B2 (en) | 2012-04-30 | 2015-04-21 | Dell Products, Lp | Cloud based master data management system and method therefor |
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 |
US9111284B2 (en) | 2004-05-21 | 2015-08-18 | Google Inc. | Maintaining a history of query results |
US9183074B2 (en) | 2013-06-21 | 2015-11-10 | Dell Products, Lp | Integration process management console with error resolution interface |
US9208213B2 (en) | 1999-05-28 | 2015-12-08 | Microstrategy, Incorporated | System and method for network user interface OLAP report formatting |
US9355273B2 (en) | 2006-12-18 | 2016-05-31 | Bank Of America, N.A., As Collateral Agent | System and method for the protection and de-identification of health care data |
US9424318B2 (en) | 2014-04-01 | 2016-08-23 | Tableau Software, Inc. | Systems and methods for ranking data visualizations |
US9606995B2 (en) | 2012-04-30 | 2017-03-28 | Dell Products, Lp | Cloud based master data management system with remote data store and method therefor |
US9613102B2 (en) | 2014-04-01 | 2017-04-04 | Tableau Software, Inc. | Systems and methods for ranking data visualizations |
US9710282B2 (en) | 2011-12-21 | 2017-07-18 | Dell Products, Lp | System to automate development of system integration application programs and method therefor |
US9886558B2 (en) | 1999-09-20 | 2018-02-06 | Quintiles Ims Incorporated | System and method for analyzing de-identified health care data |
US9934478B1 (en) * | 2000-09-22 | 2018-04-03 | Jda Software Group, Inc. | Generating an ordering of workflow items given a partial ordering and extension data |
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 |
US10896297B1 (en) | 2017-12-13 | 2021-01-19 | Tableau Software, Inc. | Identifying intent in visual analytical conversations |
US11030255B1 (en) | 2019-04-01 | 2021-06-08 | Tableau Software, LLC | Methods and systems for inferring intent and utilizing context for natural language expressions to generate data visualizations in a data visualization interface |
US11042558B1 (en) | 2019-09-06 | 2021-06-22 | Tableau Software, Inc. | Determining ranges for vague modifiers in natural language commands |
US11244114B2 (en) | 2018-10-08 | 2022-02-08 | Tableau Software, Inc. | Analyzing underspecified natural language utterances in a data visualization user interface |
US11500882B2 (en) | 2014-04-01 | 2022-11-15 | Tableau Software, Inc. | Constructing data visualization options for a data set according to user-selected data fields |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
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 |
US5713020A (en) * | 1993-09-02 | 1998-01-27 | Microsoft Corporation | Method and system for generating database queries containing multiple levels of aggregation |
-
1997
- 1997-04-30 US US08/846,934 patent/US5794246A/en not_active Expired - Lifetime
-
1998
- 1998-04-29 WO PCT/US1998/008667 patent/WO1998049636A1/en not_active Application Discontinuation
- 1998-04-29 JP JP54735498A patent/JP2001522495A/en active Pending
- 1998-04-29 EP EP98920008A patent/EP0979469A1/en not_active Withdrawn
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5455945A (en) * | 1993-05-19 | 1995-10-03 | Vanderdrift; Richard | System and method for dynamically displaying entering, and updating data from a database |
US5713020A (en) * | 1993-09-02 | 1998-01-27 | Microsoft Corporation | Method and system for generating database queries containing multiple levels of aggregation |
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 |
Cited By (215)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6023694A (en) * | 1996-01-02 | 2000-02-08 | Timeline, Inc. | Data retrieval method and apparatus with multiple source capability |
US6631382B1 (en) | 1996-01-02 | 2003-10-07 | Timeline, Inc. | Data retrieval method and apparatus with multiple source capability |
US6625617B2 (en) | 1996-01-02 | 2003-09-23 | Timeline, Inc. | Modularized data retrieval method and apparatus with multiple source capability |
US6339775B1 (en) * | 1997-11-07 | 2002-01-15 | Informatica Corporation | Apparatus and method for performing data transformations in data warehousing |
US6014670A (en) * | 1997-11-07 | 2000-01-11 | Informatica Corporation | Apparatus and method for performing data transformations in data warehousing |
US6393472B1 (en) | 1997-12-10 | 2002-05-21 | At&T Corp. | Automatic aggregation of network management information in spatial, temporal and functional forms |
US7007029B1 (en) | 1999-01-15 | 2006-02-28 | Metaedge Corporation | System for visualizing information in a data warehousing environment |
US7319996B2 (en) | 1999-01-15 | 2008-01-15 | Hon Hai Precision Industry, Ltd. | System and method for providing a data warehouse in accordance with a virtual schema |
WO2000042553A2 (en) * | 1999-01-15 | 2000-07-20 | Harmony Software, Inc. | Method and apparatus for processing business information from multiple enterprises |
US7233952B1 (en) | 1999-01-15 | 2007-06-19 | Hon Hai Precision Industry, Ltd. | Apparatus for visualizing information in a data warehousing environment |
US6377934B1 (en) | 1999-01-15 | 2002-04-23 | Metaedge Corporation | Method for providing a reverse star schema data model |
WO2000042553A3 (en) * | 1999-01-15 | 2000-11-30 | Harmony Software Inc | Method and apparatus for processing business information from multiple enterprises |
US6411961B1 (en) | 1999-01-15 | 2002-06-25 | Metaedge Corporation | Apparatus for providing a reverse star schema data model |
WO2000042530A1 (en) * | 1999-01-15 | 2000-07-20 | Metaedge Corporation | Method for visualizing information in a data warehousing environment |
US7320001B1 (en) | 1999-01-15 | 2008-01-15 | Hon Hai Precision Industry, Ltd. | Method for visualizing information in a data warehousing environment |
US6611216B1 (en) | 1999-02-02 | 2003-08-26 | Cisco Technology, Inc. | Fast look-up table based scheme for NRZI encoding/decoding and zero insertion/removal in serial bit streams |
US8321411B2 (en) | 1999-03-23 | 2012-11-27 | Microstrategy, Incorporated | System and method for management of an automatic OLAP report broadcast system |
US9477740B1 (en) | 1999-03-23 | 2016-10-25 | Microstrategy, Incorporated | System and method for management of an automatic OLAP report broadcast system |
US6567796B1 (en) | 1999-03-23 | 2003-05-20 | Microstrategy, Incorporated | System and method for management of an automatic OLAP report broadcast system |
US6850952B2 (en) * | 1999-05-24 | 2005-02-01 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
WO2000072165A1 (en) * | 1999-05-24 | 2000-11-30 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
AU779250B2 (en) * | 1999-05-24 | 2005-01-13 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
US6282544B1 (en) * | 1999-05-24 | 2001-08-28 | Computer Associates Think, Inc. | Method and apparatus for populating multiple data marts in a single aggregation process |
US10592705B2 (en) | 1999-05-28 | 2020-03-17 | Microstrategy, Incorporated | System and method for network user interface report formatting |
US8607138B2 (en) | 1999-05-28 | 2013-12-10 | Microstrategy, Incorporated | System and method for OLAP report generation with spreadsheet report within the network user interface |
US9208213B2 (en) | 1999-05-28 | 2015-12-08 | Microstrategy, Incorporated | System and method for network user interface OLAP report formatting |
US8463736B2 (en) | 1999-08-04 | 2013-06-11 | Yanicklo Technology Limited Liability Company | Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements |
US8041670B2 (en) | 1999-08-04 | 2011-10-18 | Yanicklo Technology Limited Liability Company | Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines |
US7392248B2 (en) | 1999-08-04 | 2008-06-24 | Hyperroll Israel, Ltd. | Data aggregation server supporting rapid query response with sparse multi-dimensional data |
US20050091237A1 (en) * | 1999-08-04 | 2005-04-28 | Reuven Bakalash | Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements |
US8799209B2 (en) | 1999-08-04 | 2014-08-05 | Yanicklo Technology Limited Liability Company | Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines |
US20050060326A1 (en) * | 1999-08-04 | 2005-03-17 | Reuven Bakalash | Stand-alone cartridge-style data aggregation server and method of and system for managing multi-dimensional databases using the same |
US20030225752A1 (en) * | 1999-08-04 | 2003-12-04 | Reuven Bakalash | Central data warehouse with integrated data aggregation engine for performing centralized data aggregation operations |
US8788453B2 (en) | 1999-08-04 | 2014-07-22 | Yanicklo Technology Limited Liability Company | Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines |
US20100185581A1 (en) * | 1999-08-04 | 2010-07-22 | Hyperroll, Inc. | Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines |
US6434544B1 (en) * | 1999-08-04 | 2002-08-13 | Hyperroll, Israel Ltd. | Stand-alone cartridge-style data aggregation server providing data aggregation for OLAP analyses |
US6836537B1 (en) | 1999-09-13 | 2004-12-28 | Microstrategy Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for information related to existing travel schedule |
US6850603B1 (en) | 1999-09-13 | 2005-02-01 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized dynamic and interactive voice services |
US7266181B1 (en) | 1999-09-13 | 2007-09-04 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized dynamic and interactive voice services with integrated inbound and outbound voice services |
US6798867B1 (en) | 1999-09-13 | 2004-09-28 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, with real-time database queries |
US7197461B1 (en) | 1999-09-13 | 2007-03-27 | Microstrategy, Incorporated | System and method for voice-enabled input for use in the creation and automatic deployment of personalized, dynamic, and interactive voice services |
US6940953B1 (en) | 1999-09-13 | 2005-09-06 | Microstrategy, Inc. | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services including module for generating and formatting voice services |
US6829334B1 (en) | 1999-09-13 | 2004-12-07 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, with telephone-based service utilization and control |
US7020251B2 (en) | 1999-09-13 | 2006-03-28 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, with real-time drilling via telephone |
US8051369B2 (en) | 1999-09-13 | 2011-11-01 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, including deployment through personalized broadcasts |
US6768788B1 (en) | 1999-09-13 | 2004-07-27 | Microstrategy, Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for property-related information |
US6765997B1 (en) | 1999-09-13 | 2004-07-20 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, with the direct delivery of voice services to networked voice messaging systems |
US6788768B1 (en) | 1999-09-13 | 2004-09-07 | Microstrategy, Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for book-related information |
US8094788B1 (en) | 1999-09-13 | 2012-01-10 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services with customized message depending on recipient |
US7340040B1 (en) * | 1999-09-13 | 2008-03-04 | Microstrategy, Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for corporate-analysis related information |
US6658093B1 (en) | 1999-09-13 | 2003-12-02 | Microstrategy, Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for travel availability information |
US7881443B2 (en) | 1999-09-13 | 2011-02-01 | Microstrategy, Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for travel availability information |
US6873693B1 (en) | 1999-09-13 | 2005-03-29 | Microstrategy, Incorporated | System and method for real-time, personalized, dynamic, interactive voice services for entertainment-related information |
US6885734B1 (en) | 1999-09-13 | 2005-04-26 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive inbound and outbound voice services, with real-time interactive voice database queries |
US6606596B1 (en) | 1999-09-13 | 2003-08-12 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, including deployment through digital sound files |
US8995628B2 (en) | 1999-09-13 | 2015-03-31 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services with closed loop transaction processing |
US6587547B1 (en) | 1999-09-13 | 2003-07-01 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, with real-time drilling via telephone |
US6964012B1 (en) | 1999-09-13 | 2005-11-08 | Microstrategy, Incorporated | System and method for the creation and automatic deployment of personalized, dynamic and interactive voice services, including deployment through personalized broadcasts |
US9886558B2 (en) | 1999-09-20 | 2018-02-06 | Quintiles Ims Incorporated | System and method for analyzing de-identified health care data |
US6438538B1 (en) | 1999-10-07 | 2002-08-20 | International Business Machines Corporation | Data replication in data warehousing scenarios |
US6947934B1 (en) * | 2000-02-16 | 2005-09-20 | International Business Machines Corporation | Aggregate predicates and search in a database management system |
US8195602B2 (en) | 2000-02-28 | 2012-06-05 | Yanicklo Technology Limited Liability Company | Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines |
US8321373B2 (en) | 2000-02-28 | 2012-11-27 | Yanicklo Technology Limited Liability | Method of servicing query statements from a client machine using a database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) |
US20030217079A1 (en) * | 2000-02-28 | 2003-11-20 | Reuven Bakalash | Customer relationship management (CRM) system with integrated data aggregation engine |
US8170984B2 (en) | 2000-02-28 | 2012-05-01 | Yanicklo Technology Limited Liability Company | System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner |
US20030225736A1 (en) * | 2000-02-28 | 2003-12-04 | Reuven Bakalash | Enterprise-wide resource planning (ERP) system with integrated data aggregation engine |
WO2001067303A1 (en) * | 2000-02-28 | 2001-09-13 | Hyperroll Israel Ltd. | Multi-dimensional database and integrated aggregation server |
US20050149491A1 (en) * | 2000-02-28 | 2005-07-07 | Reuven Bakalash | Database management system having data aggregation module integrated therein |
US8452804B2 (en) | 2000-02-28 | 2013-05-28 | Yanicklo Technology Limited Liability Company | Database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) for servicing query statements in a manner transparent to client machine |
US7315849B2 (en) | 2000-02-28 | 2008-01-01 | Hyperroll Israel, Ltd. | Enterprise-wide data-warehouse with integrated data aggregation engine |
US7333982B2 (en) | 2000-02-28 | 2008-02-19 | Hyperroll Israel, Ltd. | Information system having a mode of operation in which queries form one or more clients are serviced using aggregated data retrieved from a plurality of different types of data storage structures for improved query performance |
US20070233644A1 (en) * | 2000-02-28 | 2007-10-04 | Reuven Bakalash | System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner |
US8473450B2 (en) | 2000-02-28 | 2013-06-25 | Yanicklo Technology Limited Liability Company | Relational database management system (RDBMS) employing multi-dimensional database (MDDB) for servicing query statements through one or more client machines |
US6957214B2 (en) * | 2000-06-23 | 2005-10-18 | The Johns Hopkins University | Architecture for distributed database information access |
US20020023091A1 (en) * | 2000-06-23 | 2002-02-21 | Silberberg David P. | Architecture for distributed database information access |
US6513043B1 (en) | 2000-09-01 | 2003-01-28 | Syntricity, Inc. | System and method for storing, retrieving, and analyzing characterization data |
US9934478B1 (en) * | 2000-09-22 | 2018-04-03 | Jda Software Group, Inc. | Generating an ordering of workflow items given a partial ordering and extension data |
US7111010B2 (en) | 2000-09-25 | 2006-09-19 | Hon Hai Precision Industry, Ltd. | Method and system for managing event attributes |
US20020178394A1 (en) * | 2000-11-06 | 2002-11-28 | Naama Bamberger | System for processing at least partially structured data |
US7233940B2 (en) | 2000-11-06 | 2007-06-19 | Answers Corporation | System for processing at least partially structured data |
US20040205045A1 (en) * | 2001-04-04 | 2004-10-14 | Li-Wen Chen | Method and system for decision support analysis |
US20060242160A1 (en) * | 2001-06-07 | 2006-10-26 | Firoz Kanchwalla | Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface |
US7117215B1 (en) | 2001-06-07 | 2006-10-03 | Informatica Corporation | Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface |
US7162643B1 (en) | 2001-06-15 | 2007-01-09 | Informatica Corporation | Method and system for providing transfer of analytic application data over a network |
US20030009443A1 (en) * | 2001-06-15 | 2003-01-09 | Oleg Yatviskiy | Generic data aggregation |
US20020198902A1 (en) * | 2001-06-25 | 2002-12-26 | Mohan Sankaran | Real time sessions in an analytic application |
US6789096B2 (en) * | 2001-06-25 | 2004-09-07 | Informatica Corporation | Real time sessions in an analytic application |
US7720842B2 (en) | 2001-07-16 | 2010-05-18 | Informatica Corporation | Value-chained queries in analytic applications |
US7174342B1 (en) | 2001-08-09 | 2007-02-06 | Ncr Corp. | Systems and methods for defining executable sequences to process information from a data collection |
US7080066B1 (en) | 2001-08-09 | 2006-07-18 | Ncr Corporation | Systems and methods for refining a decision-making process via executable sequences |
US6931408B2 (en) * | 2001-08-17 | 2005-08-16 | E.C. Outlook, Inc. | Method of storing, maintaining and distributing computer intelligible electronic data |
US20030037037A1 (en) * | 2001-08-17 | 2003-02-20 | Ec Outlook, Inc. | Method of storing, maintaining and distributing computer intelligible electronic data |
US20030065650A1 (en) * | 2001-10-03 | 2003-04-03 | Annand Ritchie I. | Method and query application tool for searching hierarchical databases |
US20030093429A1 (en) * | 2001-11-12 | 2003-05-15 | Hitachi, Inc. | Data warehouse system |
US20030172084A1 (en) * | 2001-11-15 | 2003-09-11 | Dan Holle | System and method for constructing generic analytical database applications |
US6836777B2 (en) * | 2001-11-15 | 2004-12-28 | Ncr Corporation | System and method for constructing generic analytical database applications |
US20060010119A1 (en) * | 2001-12-28 | 2006-01-12 | International Business Machines Corporation | Real time data warehousing |
US8615521B2 (en) | 2001-12-28 | 2013-12-24 | International Business Machines Corporation | Real time data warehousing |
US20030154194A1 (en) * | 2001-12-28 | 2003-08-14 | Jonas Jeffrey James | Real time data warehousing |
KR100850255B1 (en) * | 2001-12-28 | 2008-08-19 | 인터내셔널 비지네스 머신즈 코포레이션 | Real time data warehousing |
KR100856771B1 (en) | 2001-12-28 | 2008-09-05 | 인터내셔널 비지네스 머신즈 코포레이션 | Real time data warehousing |
US8452787B2 (en) | 2001-12-28 | 2013-05-28 | International Business Machines Corporation | Real time data warehousing |
CN100483333C (en) * | 2001-12-28 | 2009-04-29 | 国际商业机器公司 | Real time data warehousing |
USRE44478E1 (en) | 2002-02-22 | 2013-09-03 | Informatica Corporation | Method and system for navigating a large amount of data |
US7900052B2 (en) | 2002-11-06 | 2011-03-01 | International Business Machines Corporation | Confidential data sharing and anonymous entity resolution |
US8620937B2 (en) | 2002-12-27 | 2013-12-31 | International Business Machines Corporation | Real time data warehousing |
US20070038664A1 (en) * | 2002-12-27 | 2007-02-15 | Jonas Jeffrey J | Real time data warehousing |
US7702919B2 (en) | 2002-12-31 | 2010-04-20 | International Business Machines Corporation | Authorized anonymous authentication |
US8352746B2 (en) | 2002-12-31 | 2013-01-08 | International Business Machines Corporation | Authorized anonymous authentication |
US20050060556A1 (en) * | 2002-12-31 | 2005-03-17 | Jonas Jeffrey J. | Authorized anonymous authentication |
US7200602B2 (en) | 2003-02-07 | 2007-04-03 | International Business Machines Corporation | Data set comparison and net change processing |
US20040162802A1 (en) * | 2003-02-07 | 2004-08-19 | Stokley-Van Camp, Inc. | Data set comparison and net change processing |
US7962757B2 (en) | 2003-03-24 | 2011-06-14 | International Business Machines Corporation | Secure coordinate identification method, system and program |
US20050066182A1 (en) * | 2003-03-24 | 2005-03-24 | Systems Research & Development | Secure coordinate identification method, system and program |
US10042517B2 (en) | 2003-06-02 | 2018-08-07 | The Board Of Trustees Of The Leland Stanford Jr. University | Systems and methods of generating a chart matrix in a data visualization region |
US9633091B2 (en) | 2003-06-02 | 2017-04-25 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for the query and visualization multidimensional databases |
US10528583B2 (en) | 2003-06-02 | 2020-01-07 | The Board Of Trustees Of The Leland Stanford Jr. University | Data visualization user interface for multidimensional databases |
US10528582B2 (en) | 2003-06-02 | 2020-01-07 | The Board Of Trustees Of The Leland Stanford Jr. University | Systems and methods of generating color saturated data marks in data visualizations |
US10528584B2 (en) | 2003-06-02 | 2020-01-07 | The Board Of Trustees Of The Leland Stanford Jr. University | Systems and methods of generating data marks in data visualizations |
US10324945B2 (en) | 2003-06-02 | 2019-06-18 | The Board Of Trustees Of The Leland Stanford Jr. University | Systems and methods of generating color saturated data marks in data visualizations |
US7089266B2 (en) | 2003-06-02 | 2006-08-08 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for the query and visualization of multidimensional databases |
US10042901B2 (en) | 2003-06-02 | 2018-08-07 | The Board Of Trustees Of The Leland Stanford Jr. University | Systems and methods of generating a plurality of data visualizations in a data visualization region |
US8140586B2 (en) | 2003-06-02 | 2012-03-20 | Tableau Software, Inc. | Computer systems and methods for the query and visualization of multidimensional databases |
US20040243593A1 (en) * | 2003-06-02 | 2004-12-02 | Chris Stolte | Computer systems and methods for the query and visualization of multidimensional databases |
US8713072B2 (en) | 2003-06-02 | 2014-04-29 | The Board of Trustees of the Leland Stanford, Jr. Univeristy | Computer systems and methods for the query and visualization of multidimensional databases |
US20110131250A1 (en) * | 2003-06-02 | 2011-06-02 | Chris Stolte | Computer Systems and Methods for the Query and Visualization of Multidimensional Databases |
US8972457B2 (en) | 2003-06-02 | 2015-03-03 | Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for the query and visualization of multidimensional databases |
US10545977B2 (en) | 2003-06-02 | 2020-01-28 | The Board Of Trustees Of The Leland Stanford Jr. University | Adjusting padding of graphical charts representing data from multidimensional databases |
US9183235B2 (en) | 2003-06-02 | 2015-11-10 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for the query and visualization of multidimensional databases |
US11550802B2 (en) | 2003-06-02 | 2023-01-10 | The Board Of Trustees Of The Leland Stanford Jr. University | Systems and methods of generating data marks in data visualizations |
US11550803B2 (en) | 2003-06-02 | 2023-01-10 | The Board Of Trustees Of The Leland Stanford Jr. University | Systems and methods of generating data marks in data visualizations |
US7756907B2 (en) | 2003-09-16 | 2010-07-13 | The Board Of Trustees Of The Leland Stanford Jr. University | Computer systems and methods for visualizing data |
US9092467B2 (en) | 2003-09-16 | 2015-07-28 | The Board Of Trustees Of The Leland Stanford Junior University | Systems and methods for displaying data in split dimension levels |
US20050060300A1 (en) * | 2003-09-16 | 2005-03-17 | Chris Stolte | Computer systems and methods for visualizing data |
US7421458B1 (en) | 2003-10-16 | 2008-09-02 | Informatica Corporation | Querying, versioning, and dynamic deployment of database objects |
US20050125436A1 (en) * | 2003-12-03 | 2005-06-09 | Mudunuri Gautam H. | Set-oriented real-time data processing based on transaction boundaries |
US7254590B2 (en) | 2003-12-03 | 2007-08-07 | Informatica Corporation | Set-oriented real-time data processing based on transaction boundaries |
US20050125568A1 (en) * | 2003-12-05 | 2005-06-09 | Yeo Soon I. | Method and apparatus for managing reconfiguration data memory |
US7793006B2 (en) * | 2003-12-05 | 2010-09-07 | Electronics And Telecommunications Research Institute | Method and apparatus for managing reconfiguration data memory with a preservation data storing buffer in the target system and server |
US8819072B1 (en) * | 2004-02-02 | 2014-08-26 | Microsoft Corporation | Promoting data from structured data files |
US7308542B1 (en) * | 2004-02-19 | 2007-12-11 | Microsoft Corporation | Data integrity protection for stored data |
US9111284B2 (en) | 2004-05-21 | 2015-08-18 | Google Inc. | Maintaining a history of query results |
US9990430B2 (en) | 2004-05-26 | 2018-06-05 | Facebook, Inc. | Graph server querying for managing social network information flow |
US20110099167A1 (en) * | 2004-05-26 | 2011-04-28 | Nicholas Galbreath | Graph Server Querying for Managing Social Network Information Flow |
US9241027B2 (en) | 2004-05-26 | 2016-01-19 | Facebook, Inc. | System and method for managing an online social network |
US9703879B2 (en) | 2004-05-26 | 2017-07-11 | Facebook, Inc. | Graph server querying for managing social network information flow |
US8572221B2 (en) | 2004-05-26 | 2013-10-29 | Facebook, Inc. | System and method for managing an online social network |
US10628502B2 (en) | 2004-05-26 | 2020-04-21 | Facebook, Inc. | Graph server querying for managing social network information flow |
US7333995B2 (en) * | 2004-07-02 | 2008-02-19 | Cognos, Incorporated | Very large dataset representation system and method |
US20060005127A1 (en) * | 2004-07-02 | 2006-01-05 | Ferguson Kevin M | System and method of format specification |
US20060005112A1 (en) * | 2004-07-02 | 2006-01-05 | David Lilly | System and method of report layout |
US7818282B2 (en) | 2004-07-02 | 2010-10-19 | International Business Machines Corporation | System and method for the support of multilingual applications |
US20060004813A1 (en) * | 2004-07-02 | 2006-01-05 | Desbiens Marc A | Very large dataset representation system and method |
US20060004738A1 (en) * | 2004-07-02 | 2006-01-05 | Blackwell Richard F | System and method for the support of multilingual applications |
US8904273B2 (en) | 2004-07-02 | 2014-12-02 | International Business Machines Corporation | System and method of format specification |
US7800613B2 (en) | 2004-12-02 | 2010-09-21 | Tableau Software, Inc. | Computer systems and methods for visualizing data with generation of marks |
US20060206512A1 (en) * | 2004-12-02 | 2006-09-14 | Patrick Hanrahan | Computer systems and methods for visualizing data with generation of marks |
US8099674B2 (en) | 2005-09-09 | 2012-01-17 | Tableau Software Llc | Computer systems and methods for automatically viewing multidimensional databases |
US10712903B2 (en) | 2005-09-09 | 2020-07-14 | Tableau Software, Inc. | Systems and methods for ranking data visualizations using different data fields |
US20070061611A1 (en) * | 2005-09-09 | 2007-03-15 | Mackinlay Jock D | Computer systems and methods for automatically viewing multidimensional databases |
US11592955B2 (en) | 2005-09-09 | 2023-02-28 | Tableau Software, Inc. | Methods and systems for building a view of a dataset incrementally according to data types of user-selected data fields |
US11068122B2 (en) | 2005-09-09 | 2021-07-20 | Tableau Software, Inc. | Methods and systems for building a view of a dataset incrementally according to characteristics of user-selected data fields |
US9600528B2 (en) | 2005-09-09 | 2017-03-21 | Tableau Software, Inc. | Computer systems and methods for automatically viewing multidimensional databases |
US10386989B2 (en) | 2005-09-09 | 2019-08-20 | Tableau Software, Inc. | Computer systems and methods for automatically viewing multidimensional databases |
US11847299B2 (en) | 2005-09-09 | 2023-12-19 | Tableau Software, Inc. | Building a view of a dataset incrementally according to data types of user-selected data fields |
US7999809B2 (en) | 2006-04-19 | 2011-08-16 | Tableau Software, Inc. | Computer systems and methods for automatic generation of models for a dataset |
US9292628B2 (en) | 2006-04-19 | 2016-03-22 | Tableau Software, Inc. | Systems and methods for generating models of a dataset for a data visualization |
US8860727B2 (en) | 2006-04-19 | 2014-10-14 | Tableau Software, Inc. | Computer systems and methods for automatic generation of models for a dataset |
US20070250523A1 (en) * | 2006-04-19 | 2007-10-25 | Beers Andrew C | Computer systems and methods for automatic generation of models for a dataset |
US20090106210A1 (en) * | 2006-09-18 | 2009-04-23 | Infobright, Inc. | Methods and systems for database organization |
US20080071748A1 (en) * | 2006-09-18 | 2008-03-20 | Infobright Inc. | Method and system for storing, organizing and processing data in a relational database |
US8700579B2 (en) | 2006-09-18 | 2014-04-15 | Infobright Inc. | Method and system for data compression in a relational database |
US20080071818A1 (en) * | 2006-09-18 | 2008-03-20 | Infobright Inc. | Method and system for data compression in a relational database |
US8266147B2 (en) | 2006-09-18 | 2012-09-11 | Infobright, Inc. | Methods and systems for database organization |
US8838593B2 (en) * | 2006-09-18 | 2014-09-16 | Infobright Inc. | Method and system for storing, organizing and processing data in a relational database |
US20080099831A1 (en) * | 2006-10-31 | 2008-05-01 | Oki Electric Industry Co., Ltd. | Semiconductor memory device and method for the same |
US8204831B2 (en) | 2006-11-13 | 2012-06-19 | International Business Machines Corporation | Post-anonymous fuzzy comparisons without the use of pre-anonymization variants |
US20080140696A1 (en) * | 2006-12-07 | 2008-06-12 | Pantheon Systems, Inc. | System and method for analyzing data sources to generate metadata |
US9355273B2 (en) | 2006-12-18 | 2016-05-31 | Bank Of America, N.A., As Collateral Agent | System and method for the protection and de-identification of health care data |
US9176711B2 (en) | 2007-04-27 | 2015-11-03 | Dell Products, Lp | System and method for automated on-demand creation of a customized software application |
US8533661B2 (en) | 2007-04-27 | 2013-09-10 | Dell Products, Lp | System and method for automated on-demand creation of a customized software application |
US8521748B2 (en) | 2010-06-14 | 2013-08-27 | Infobright Inc. | System and method for managing metadata in a relational database |
US8417727B2 (en) | 2010-06-14 | 2013-04-09 | Infobright Inc. | System and method for storing data in a relational database |
US8943100B2 (en) | 2010-06-14 | 2015-01-27 | Infobright Inc. | System and method for storing data in a relational database |
US20140095515A1 (en) * | 2011-05-18 | 2014-04-03 | Elyasaf Korenwaitz | Real time single-sweep detection of key words and content analysis |
US9519704B2 (en) * | 2011-05-18 | 2016-12-13 | Netspark Ltd | Real time single-sweep detection of key words and content analysis |
US9710282B2 (en) | 2011-12-21 | 2017-07-18 | Dell Products, Lp | System to automate development of system integration application programs and method therefor |
US8958097B2 (en) * | 2012-01-17 | 2015-02-17 | Kabushiki Kaisha Toshiba | Information processing apparatus |
US20130182287A1 (en) * | 2012-01-17 | 2013-07-18 | Toshiba Tec Kabushiki Kaisha | Information processing apparatus |
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 |
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 |
US20130290690A1 (en) * | 2012-04-30 | 2013-10-31 | Dell Products, Lp | Cloud Based Master Data Management System with Configuration Advisor and Method Therefore |
US9158782B2 (en) * | 2012-04-30 | 2015-10-13 | Dell Products, Lp | Cloud based master data management system with configuration advisor and method therefore |
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 |
US9183074B2 (en) | 2013-06-21 | 2015-11-10 | Dell Products, Lp | Integration process management console with error resolution interface |
US9864673B2 (en) | 2013-06-21 | 2018-01-09 | Dell Products, Lp | Integration process management console with error resolution interface |
US11500882B2 (en) | 2014-04-01 | 2022-11-15 | Tableau Software, Inc. | Constructing data visualization options for a data set according to user-selected data fields |
US9613102B2 (en) | 2014-04-01 | 2017-04-04 | Tableau Software, Inc. | Systems and methods for ranking data visualizations |
US9424318B2 (en) | 2014-04-01 | 2016-08-23 | Tableau Software, Inc. | Systems and methods for ranking data visualizations |
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 |
US11790182B2 (en) | 2017-12-13 | 2023-10-17 | Tableau Software, Inc. | Identifying intent in visual analytical conversations |
US10896297B1 (en) | 2017-12-13 | 2021-01-19 | Tableau Software, Inc. | Identifying intent in visual analytical conversations |
US11244114B2 (en) | 2018-10-08 | 2022-02-08 | Tableau Software, Inc. | Analyzing underspecified natural language utterances in a data visualization user interface |
US11314817B1 (en) | 2019-04-01 | 2022-04-26 | Tableau Software, LLC | Methods and systems for inferring intent and utilizing context for natural language expressions to modify data visualizations in a data visualization interface |
US11030255B1 (en) | 2019-04-01 | 2021-06-08 | Tableau Software, LLC | Methods and systems for inferring intent and utilizing context for natural language expressions to generate data visualizations in a data visualization interface |
US11734358B2 (en) | 2019-04-01 | 2023-08-22 | Tableau Software, LLC | Inferring intent and utilizing context for natural language expressions in a data visualization user interface |
US11790010B2 (en) | 2019-04-01 | 2023-10-17 | Tableau Software, LLC | Inferring intent and utilizing context for natural language expressions in a data visualization user interface |
US11416559B2 (en) | 2019-09-06 | 2022-08-16 | Tableau Software, Inc. | Determining ranges for vague modifiers in natural language commands |
US11734359B2 (en) | 2019-09-06 | 2023-08-22 | Tableau Software, Inc. | Handling vague modifiers in natural language commands |
US11042558B1 (en) | 2019-09-06 | 2021-06-22 | Tableau Software, Inc. | Determining ranges for vague modifiers in natural language commands |
Also Published As
Publication number | Publication date |
---|---|
JP2001522495A (en) | 2001-11-13 |
WO1998049636A1 (en) | 1998-11-05 |
EP0979469A1 (en) | 2000-02-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5794246A (en) | Method for incremental aggregation of dynamically increasing database data sets | |
CA2420214C (en) | Data processing method and apparatus | |
US6208990B1 (en) | Method and architecture for automated optimization of ETL throughput in data warehousing applications | |
CA2418859C (en) | Method and apparatus relating to data transport | |
US7908242B1 (en) | Systems and methods for optimizing database queries | |
US6968330B2 (en) | Database query optimization apparatus and method | |
US20030135495A1 (en) | Database indexing method and apparatus | |
US7890519B2 (en) | Summarizing data removed from a query result set based on a data quality standard | |
Campagna et al. | Finding associations and computing similarity via biased pair sampling | |
US7243100B2 (en) | Methods and apparatus for mining attribute associations | |
US6553359B1 (en) | Data mining for association rules and sequential patterns within data of inhomogeneous type | |
EP1590749B1 (en) | Method and system for mapping xml to n-dimensional data structure | |
Servan-Schreiber et al. | ProSecCo: Progressive sequence mining with convergence guarantees | |
Jukic et al. | Expediting analytical databases with columnar approach | |
Powell | Oracle performance tuning for 10gR2 | |
US8229946B1 (en) | Business rules application parallel processing system | |
US7516144B2 (en) | Method and system for re-population of data in a database | |
US7996366B1 (en) | Method and system for identifying stale directories | |
CN1324466A (en) | Method for checking tables paces involved in referential integrity | |
US6442562B1 (en) | Apparatus and method for using incomplete cached balance sets to generate incomplete or complete cached balance sets and balance values | |
JPH10301935A (en) | Data processing method | |
Tillmann et al. | The Data Warehouse | |
Hrybkov et al. | Study of the methods and approaches of databases refactoring | |
CN115061982A (en) | Case-customization-based relational graph construction method, system, terminal and medium | |
Chen | Derivation and estimation of summary data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: INFORMATICA CORPORATION, CALIFORNIA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:SANKARAN, MOHAN;SANKARAN, SURESH;WONG, MON;AND OTHERS;REEL/FRAME:008536/0047 Effective date: 19970430 |
|
STCF | Information on status: patent grant |
Free format text: PATENTED CASE |
|
REMI | Maintenance fee reminder mailed | ||
FPAY | Fee payment |
Year of fee payment: 4 |
|
SULP | Surcharge for late payment | ||
FPAY | Fee payment |
Year of fee payment: 8 |
|
FPAY | Fee payment |
Year of fee payment: 12 |
|
AS | Assignment |
Owner name: BANK OF AMERICA, N.A., AS COLLATERAL AGENT, NORTH CAROLINA Free format text: SECURITY AGREEMENT;ASSIGNOR:INFORMATICA CORPORATION;REEL/FRAME:036294/0701 Effective date: 20150806 Owner name: BANK OF AMERICA, N.A., AS COLLATERAL AGENT, NORTH Free format text: SECURITY AGREEMENT;ASSIGNOR:INFORMATICA CORPORATION;REEL/FRAME:036294/0701 Effective date: 20150806 |
|
AS | Assignment |
Owner name: INFORMATICA LLC, CALIFORNIA Free format text: CHANGE OF NAME;ASSIGNOR:INFORMATICA CORPORATION;REEL/FRAME:036453/0406 Effective date: 20150806 |
|
AS | Assignment |
Owner name: NOMURA CORPORATE FUNDING AMERICAS, LLC, NEW YORK Free format text: NOTICE OF SUCCESSION OF AGENCY;ASSIGNOR:BANK OF AMERICA, N.A.;REEL/FRAME:052018/0070 Effective date: 20200225 |
|
AS | Assignment |
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 |