Identifying Join Relationships Based on Transactional Access Patterns

A technology for relational and transactional data, used in database models, structured data retrieval, instruments, etc.

Active Publication Date: 2021-06-22
AMAZON TECH INC
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, analytically useful relationships may exist even without well-defined
There may also be analytically useful relationships that are not known to the user of the analysis tool

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Identifying Join Relationships Based on Transactional Access Patterns
  • Identifying Join Relationships Based on Transactional Access Patterns
  • Identifying Join Relationships Based on Transactional Access Patterns

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0122] 14. A computer-implemented method for identifying analytical relationships in transactional data, the method comprising:

[0123] identifying join paths for at least two fields in a plurality of queries based at least in part on coincident references to the fields; and

[0124] A level of aggregation associated with the join path is identified by analyzing at least the plurality of queries of information indicative of a hierarchical organization of the at least two fields, the analyzed information including at least one of One of: a data type of a field of the at least two fields, a first association of the field with a grouping clause in the plurality of queries, and a first association of the field with a summary clause in the plurality of queries of the second association.

[0125] 15. The computer-implemented method of clause 14, further comprising:

[0126] The level of aggregation is identified based at least in part on a mapping between the data type and one or...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Analytical relationships that are not explicitly defined in the schema or not provided by the user can be identified using a corpus of information describing the queries used to access the transactional data store. Associative relationships may be identified based on field coincidence in query elements in the corpus. Join relationships can indicate dimensions and attributes of dimensions. Hierarchical levels of dimensions can be identified based on factors including data types, references in summary clauses, and references in grouping clauses.

Description

[0001] Cross References to Related Applications [0002] This application claims the benefit of US Patent Application No. 14 / 578,786, filed December 22, 2014, the disclosure of which is incorporated herein by reference in its entirety. technical field Background technique [0003] Data warehousing and online analytical processing ("OLAP") systems may include various tools that allow the automatic generation of analytical queries. In some cases, these tools may rely on the user to provide various details about the structure of the data to be analyzed. However, providing this information may be the process involved. In other cases, tools can automatically generate analytical queries using well-defined schema information (eg, primary key and foreign key relationships). However, analytically useful relationships may exist even if they are not clearly defined. There may also be analytically useful relationships that are not known to the user of the analysis tool. Contents of...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2453G06F16/27G06F16/28G06F16/242
CPCG06F16/24544G06F16/282G06F16/244G06F16/275
Inventor 阿努拉格·温德拉斯·古普塔蒂莫西·安德鲁·拉斯斯里尼瓦桑·孙达尔·拉加万桑托什·凯克
Owner AMAZON TECH INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap