SG11201604859RA - Database key identification - Google Patents

Database key identification

Info

Publication number
SG11201604859RA
SG11201604859RA SG11201604859RA SG11201604859RA SG11201604859RA SG 11201604859R A SG11201604859R A SG 11201604859RA SG 11201604859R A SG11201604859R A SG 11201604859RA SG 11201604859R A SG11201604859R A SG 11201604859RA SG 11201604859R A SG11201604859R A SG 11201604859RA
Authority
SG
Singapore
Prior art keywords
key identification
database key
database
identification
key
Prior art date
Application number
SG11201604859RA
Inventor
Timothy Spencer Bush
Original Assignee
Ab Initio Technology Llc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ab Initio Technology Llc filed Critical Ab Initio Technology Llc
Publication of SG11201604859RA publication Critical patent/SG11201604859RA/en

Links

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/21—Design, administration or maintenance of databases
    • G06F16/211—Schema design and management
    • 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/21—Design, administration or maintenance of databases
    • G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2237—Vectors, bitmaps or matrices
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2228—Indexing structures
    • G06F16/2255—Hash tables
    • 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/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24558—Binary matching operations

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Quality & Reliability (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
SG11201604859RA 2014-01-16 2015-01-15 Database key identification SG11201604859RA (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US14/156,544 US11487732B2 (en) 2014-01-16 2014-01-16 Database key identification
PCT/US2015/011518 WO2015109047A1 (en) 2014-01-16 2015-01-15 Database key identification

Publications (1)

Publication Number Publication Date
SG11201604859RA true SG11201604859RA (en) 2016-08-30

Family

ID=52432993

Family Applications (1)

Application Number Title Priority Date Filing Date
SG11201604859RA SG11201604859RA (en) 2014-01-16 2015-01-15 Database key identification

Country Status (9)

Country Link
US (1) US11487732B2 (en)
EP (1) EP3095047B1 (en)
JP (1) JP6526684B2 (en)
KR (1) KR102240137B1 (en)
CN (1) CN105917336B (en)
AU (1) AU2015206487B2 (en)
CA (1) CA2934034C (en)
SG (1) SG11201604859RA (en)
WO (1) WO2015109047A1 (en)

Families Citing this family (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9892026B2 (en) 2013-02-01 2018-02-13 Ab Initio Technology Llc Data records selection
US11227104B2 (en) * 2014-05-11 2022-01-18 Informatica Llc Composite data creation with refinement suggestions
US20160027123A1 (en) * 2014-07-22 2016-01-28 Gastke Inc. Automatic tagging of trial balance
US10891294B1 (en) 2014-07-22 2021-01-12 Auditfile, Inc. Automatically migrating computer content
US11232085B2 (en) * 2016-01-07 2022-01-25 Amazon Technologies, Inc. Outlier detection for streaming data
GB2566677A (en) * 2017-09-12 2019-03-27 Infosum Ltd Grouping datasets
CN107766570B (en) * 2017-11-10 2020-04-07 广东电网有限责任公司电力科学研究院 File homology checking method
US11068540B2 (en) 2018-01-25 2021-07-20 Ab Initio Technology Llc Techniques for integrating validation results in data profiling and related systems and methods
US10846307B1 (en) * 2020-04-03 2020-11-24 Csg Systems, Inc. System and method for managing interactions with a data lake
KR102416517B1 (en) * 2020-11-13 2022-07-01 디비에프아이에스 주식회사 Apparatus and method for database central management using rpa
CN112800085B (en) * 2021-04-13 2021-09-14 成都四方伟业软件股份有限公司 Method and device for identifying main foreign key fields among tables based on bloom filter

Family Cites Families (106)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5179643A (en) 1988-12-23 1993-01-12 Hitachi, Ltd. Method of multi-dimensional analysis and display for a large volume of record information items and a system therefor
JPH032938A (en) 1989-05-31 1991-01-09 Hitachi Ltd Data base processing method
FR2698465B1 (en) 1992-11-20 1995-01-13 Bull Sa Method for extracting statistics profiles, use of statistics created by the method.
JP3079881B2 (en) 1993-08-10 2000-08-21 三菱自動車工業株式会社 Road traffic condition estimation method and vehicle driving characteristic control method
JP3002938B2 (en) 1993-10-28 2000-01-24 オークマ株式会社 Automatic tool changer and tool change method
US5742806A (en) 1994-01-31 1998-04-21 Sun Microsystems, Inc. Apparatus and method for decomposing database queries for database management system including multiprocessor digital data processing system
JP3519126B2 (en) 1994-07-14 2004-04-12 株式会社リコー Automatic layout system
US5842200A (en) 1995-03-31 1998-11-24 International Business Machines Corporation System and method for parallel mining of association rules in databases
US6601048B1 (en) 1997-09-12 2003-07-29 Mci Communications Corporation System and method for detecting and managing fraud
US5966072A (en) 1996-07-02 1999-10-12 Ab Initio Software Corporation Executing computations expressed as graphs
US5778373A (en) 1996-07-15 1998-07-07 At&T Corp Integration of an information server database schema by generating a translation map from exemplary files
US6138123A (en) 1996-07-25 2000-10-24 Rathbun; Kyle R. Method for creating and using parallel data structures
JPH1055367A (en) 1996-08-09 1998-02-24 Hitachi Ltd Data utilization system
US5845285A (en) 1997-01-07 1998-12-01 Klein; Laurence C. Computer system and method of data analysis
US5987453A (en) 1997-04-07 1999-11-16 Informix Software, Inc. Method and apparatus for performing a join query in a database system
US6134560A (en) 1997-12-16 2000-10-17 Kliebhan; Daniel F. Method and apparatus for merging telephone switching office databases
US6553366B1 (en) 1998-10-02 2003-04-22 Ncr Corporation Analytic logical data model
US6959300B1 (en) 1998-12-10 2005-10-25 At&T Corp. Data compression method and apparatus
US6343294B1 (en) 1998-12-15 2002-01-29 International Business Machines Corporation Data file editor for multiple data subsets
US6741995B1 (en) 1999-03-23 2004-05-25 Metaedge Corporation Method for dynamically creating a profile
US6163774A (en) 1999-05-24 2000-12-19 Platinum Technology Ip, Inc. Method and apparatus for simplified and flexible selection of aggregate and cross product levels for a data warehouse
US6801938B1 (en) 1999-06-18 2004-10-05 Torrent Systems, Inc. Segmentation and processing of continuous data streams using transactional semantics
CN100375088C (en) 1999-06-18 2008-03-12 国际商业机器公司 Segmentation and processing of continuous data streams using transactional semantics
JP3318834B2 (en) 1999-07-30 2002-08-26 三菱電機株式会社 Data file system and data retrieval method
JP3567861B2 (en) 2000-07-07 2004-09-22 日本電信電話株式会社 Information source location estimation method and apparatus, and storage medium storing information source location estimation program
JP4366845B2 (en) 2000-07-24 2009-11-18 ソニー株式会社 Data processing apparatus, data processing method, and program providing medium
US6788302B1 (en) 2000-08-03 2004-09-07 International Business Machines Corporation Partitioning and load balancing graphical shape data for parallel applications
US7039627B1 (en) 2000-12-22 2006-05-02 Nortel Networks Limited Method and apparatus for performing a radix search by selecting one of a valid table and a transition table
US6952693B2 (en) 2001-02-23 2005-10-04 Ran Wolff Distributed mining of association rules
US20020161778A1 (en) 2001-02-24 2002-10-31 Core Integration Partners, Inc. Method and system of data warehousing and building business intelligence using a data storage model
US20020120602A1 (en) 2001-02-28 2002-08-29 Ross Overbeek System, method and computer program product for simultaneous analysis of multiple genomes
CA2349265A1 (en) 2001-05-30 2002-11-30 Andrew Emili Protein expression profile database
US20030033138A1 (en) 2001-07-26 2003-02-13 Srinivas Bangalore Method for partitioning a data set into frequency vectors for clustering
US7130852B2 (en) 2001-07-27 2006-10-31 Silicon Valley Bank Internal security system for a relational database system
WO2003014867A2 (en) 2001-08-03 2003-02-20 John Allen Ananian Personalized interactive digital catalog profiling
US6801903B2 (en) 2001-10-12 2004-10-05 Ncr Corporation Collecting statistics in a database system
US20030140027A1 (en) 2001-12-12 2003-07-24 Jeffrey Huttel Universal Programming Interface to Knowledge Management (UPIKM) database system with integrated XML interface
US7813937B1 (en) 2002-02-15 2010-10-12 Fair Isaac Corporation Consistency modeling of healthcare claims to detect fraud and abuse
US7031969B2 (en) 2002-02-20 2006-04-18 Lawrence Technologies, Llc System and method for identifying relationships between database records
AU2003223314B2 (en) 2002-03-19 2007-04-05 Mapinfo Corporation Location based service provider
US20040083199A1 (en) 2002-08-07 2004-04-29 Govindugari Diwakar R. Method and architecture for data transformation, normalization, profiling, cleansing and validation
US6657568B1 (en) 2002-08-27 2003-12-02 Fmr Corp. Data packing for real-time streaming
US7047230B2 (en) 2002-09-09 2006-05-16 Lucent Technologies Inc. Distinct sampling system and a method of distinct sampling for optimizing distinct value query estimates
US7043476B2 (en) 2002-10-11 2006-05-09 International Business Machines Corporation Method and apparatus for data mining to discover associations and covariances associated with data
WO2004036461A2 (en) 2002-10-14 2004-04-29 Battelle Memorial Institute Information reservoir
US7698163B2 (en) 2002-11-22 2010-04-13 Accenture Global Services Gmbh Multi-dimensional segmentation for use in a customer interaction
US7403942B1 (en) 2003-02-04 2008-07-22 Seisint, Inc. Method and system for processing data records
US7433861B2 (en) 2003-03-13 2008-10-07 International Business Machines Corporation Byte-code representations of actual data to reduce network traffic in database transactions
US7117222B2 (en) 2003-03-13 2006-10-03 International Business Machines Corporation Pre-formatted column-level caching to improve client performance
US7840664B2 (en) 2003-05-21 2010-11-23 Ixia Automated characterization of network traffic
US20040249810A1 (en) 2003-06-03 2004-12-09 Microsoft Corporation Small group sampling of data for use in query processing
GB0314591D0 (en) 2003-06-21 2003-07-30 Ibm Profiling data in a data store
US20060069717A1 (en) 2003-08-27 2006-03-30 Ascential Software Corporation Security service for a services oriented architecture in a data integration platform
US20050240354A1 (en) 2003-08-27 2005-10-27 Ascential Software Corporation Service oriented architecture for an extract function in a data integration platform
US7426520B2 (en) 2003-09-10 2008-09-16 Exeros, Inc. Method and apparatus for semantic discovery and mapping between data sources
CN101271472B (en) 2003-09-15 2011-04-13 起元科技有限公司 Data processing method and data processing system
KR100922141B1 (en) 2003-09-15 2009-10-19 아브 이니티오 소프트웨어 엘엘시 Data profiling method and system
US7587394B2 (en) 2003-09-23 2009-09-08 International Business Machines Corporation Methods and apparatus for query rewrite with auxiliary attributes in query processing operations
US7149736B2 (en) 2003-09-26 2006-12-12 Microsoft Corporation Maintaining time-sorted aggregation records representing aggregations of values from multiple database records using multiple partitions
US7698345B2 (en) 2003-10-21 2010-04-13 The Nielsen Company (Us), Llc Methods and apparatus for fusing databases
US7689542B2 (en) 2004-01-13 2010-03-30 Oracle International Corporation Dynamic return type generation in a database system
US7376656B2 (en) 2004-02-10 2008-05-20 Microsoft Corporation System and method for providing user defined aggregates in a database system
US20050177578A1 (en) 2004-02-10 2005-08-11 Chen Yao-Ching S. Efficient type annontation of XML schema-validated XML documents without schema validation
US8447743B2 (en) 2004-08-17 2013-05-21 International Business Machines Corporation Techniques for processing database queries including user-defined functions
US20060074881A1 (en) 2004-10-02 2006-04-06 Adventnet, Inc. Structure independent searching in disparate databases
US8145642B2 (en) * 2004-11-30 2012-03-27 Oracle International Corporation Method and apparatus to support bitmap filtering in a parallel system
US8572018B2 (en) 2005-06-20 2013-10-29 New York University Method, system and software arrangement for reconstructing formal descriptive models of processes from functional/modal data using suitable ontology
US7716630B2 (en) 2005-06-27 2010-05-11 Ab Initio Technology Llc Managing parameters for graph-based computations
US7584205B2 (en) 2005-06-27 2009-09-01 Ab Initio Technology Llc Aggregating data with complex operations
US7774346B2 (en) 2005-08-26 2010-08-10 Oracle International Corporation Indexes that are based on bitmap values and that use summary bitmap values
JP3962417B2 (en) 2005-08-31 2007-08-22 インターナショナル・ビジネス・マシーンズ・コーポレーション System and method for controlling access to database
US20070073721A1 (en) 2005-09-23 2007-03-29 Business Objects, S.A. Apparatus and method for serviced data profiling operations
US8271452B2 (en) 2006-06-12 2012-09-18 Rainstor Limited Method, system, and database archive for enhancing database archiving
US8260910B2 (en) 2006-09-19 2012-09-04 Oracle America, Inc. Method and apparatus for monitoring a data stream to detect a pattern of data elements using bloom filters
NO325864B1 (en) 2006-11-07 2008-08-04 Fast Search & Transfer Asa Procedure for calculating summary information and a search engine to support and implement the procedure
CN101191069B (en) 2006-11-21 2011-04-27 中国石油化工股份有限公司 Method for preparing ethene and propene by naphtha catalysis cracking
US8412713B2 (en) 2007-03-06 2013-04-02 Mcafee, Inc. Set function calculation in a database
US8069129B2 (en) 2007-04-10 2011-11-29 Ab Initio Technology Llc Editing and compiling business rules
US7958142B2 (en) 2007-09-20 2011-06-07 Microsoft Corporation User profile aggregation
US20090226916A1 (en) 2008-02-01 2009-09-10 Life Technologies Corporation Automated Analysis of DNA Samples
US7912867B2 (en) 2008-02-25 2011-03-22 United Parcel Services Of America, Inc. Systems and methods of profiling data for integration
US8463739B2 (en) 2008-08-28 2013-06-11 Red Hat, Inc. Systems and methods for generating multi-population statistical measures using middleware
EP2350879A1 (en) 2008-09-19 2011-08-03 Oracle International Corporation Hash join using collaborative parallel filtering in intelligent storage with offloaded bloom filters
US20100114976A1 (en) 2008-10-21 2010-05-06 Castellanos Maria G Method For Database Design
US9251212B2 (en) 2009-03-27 2016-02-02 Business Objects Software Ltd. Profiling in a massive parallel processing environment
US20110029478A1 (en) 2009-05-20 2011-02-03 Broeker Stephen A Stream Star Schema and Nested Binary Tree for Data Stream Analysis
EP2478433A4 (en) 2009-09-16 2016-09-21 Ab Initio Technology Llc Mapping dataset elements
CN101661510A (en) 2009-09-29 2010-03-03 金蝶软件（中国）有限公司 Data matching method and device thereof
US8560575B2 (en) 2009-11-12 2013-10-15 Salesforce.Com, Inc. Methods and apparatus for selecting updates to associated records to publish on an information feed in an on-demand database service environment
KR20120115233A (en) 2009-11-13 2012-10-17 아브 이니티오 테크놀로지 엘엘시 Managing record format information
US8396873B2 (en) 2010-03-10 2013-03-12 Emc Corporation Index searching using a bloom filter
KR20150042872A (en) 2010-06-22 2015-04-21 아브 이니티오 테크놀로지 엘엘시 Processing related datasets
US10558705B2 (en) 2010-10-20 2020-02-11 Microsoft Technology Licensing, Llc Low RAM space, high-throughput persistent key-value store using secondary memory
US8296274B2 (en) 2011-01-27 2012-10-23 Leppard Andrew Considering multiple lookups in bloom filter decision making
CN103348598B (en) 2011-01-28 2017-07-14 起元科技有限公司 Generate data pattern information
US9275367B2 (en) 2011-05-05 2016-03-01 Aegis Analytical Corporation System for designating, displaying and selecting types of process parameters and product outcome parameters
US8610605B2 (en) 2011-06-17 2013-12-17 Sap Ag Method and system for data compression
US8856085B2 (en) 2011-07-19 2014-10-07 International Business Machines Corporation Automatic consistent sampling for data analysis
US8666919B2 (en) 2011-07-29 2014-03-04 Accenture Global Services Limited Data quality management for profiling, linking, cleansing and migrating data
US8880880B2 (en) * 2011-07-29 2014-11-04 Qualcomm Incorporated Facilitating access control in peer-to-peer overlay networks
CN103176973B (en) 2011-12-20 2016-04-20 国际商业机器公司 For generating the system and method for the test job load of database
US8762396B2 (en) 2011-12-22 2014-06-24 Sap Ag Dynamic, hierarchical bloom filters for network data routing
US9336246B2 (en) 2012-02-28 2016-05-10 International Business Machines Corporation Generating composite key relationships between database objects based on sampling
CN102681946B (en) 2012-05-11 2015-03-11 龙芯中科技术有限公司 Memory access method and device
US11449952B2 (en) 2012-10-01 2022-09-20 Oracle International Corporation Efficiently modeling database scenarios for later use on live data
US9892026B2 (en) 2013-02-01 2018-02-13 Ab Initio Technology Llc Data records selection

Also Published As

Publication number Publication date
CN105917336B (en) 2021-06-29
JP2017507392A (en) 2017-03-16
AU2015206487B2 (en) 2020-07-02
EP3095047B1 (en) 2021-06-23
WO2015109047A1 (en) 2015-07-23
KR102240137B1 (en) 2021-04-13
CA2934034C (en) 2021-09-21
CN105917336A (en) 2016-08-31
EP3095047A1 (en) 2016-11-23
KR20160107188A (en) 2016-09-13
US11487732B2 (en) 2022-11-01
AU2015206487A1 (en) 2016-06-30
JP6526684B2 (en) 2019-06-05
US20150199352A1 (en) 2015-07-16
CA2934034A1 (en) 2015-07-23

Similar Documents

Publication Publication Date Title
GB2529817B (en) Key module
HK1251076A1 (en) Key entry device
SG11201703004XA (en) Database security
SG11201604859RA (en) Database key identification
GB201401009D0 (en) Vehicle identification
GB2528233B (en) Identifying features
GB201413101D0 (en) Security Tag
GB2533601B (en) Key
GB201411107D0 (en) Object-assisted identification label
GB201405510D0 (en) Security booket
GB2533108B (en) Contactless key localisation
EP2975199A4 (en) Variably-combined mechanical key
PL2915939T3 (en) Lock
GB2542061B (en) Biometric identification
SI3191663T1 (en) Key
PL3026201T3 (en) Additional lock
GB2531332B (en) Location identification
GB201512792D0 (en) Security tag
SI3018273T1 (en) Additional lock
PL3194178T3 (en) Security element
PL2963213T3 (en) Lock
ZA201602946B (en) Borehole location identification
PL3215696T3 (en) Lock
GB201409524D0 (en) Security tag
GB201403921D0 (en) Improved database