PL2843567T3 - Realizowany przy pomocy komputera sposób usprawnienia wykonywania zapytań w relacyjnych bazach danych znormalizowanych na poziomie 4 i powyżej - Google Patents

Realizowany przy pomocy komputera sposób usprawnienia wykonywania zapytań w relacyjnych bazach danych znormalizowanych na poziomie 4 i powyżej

Info

Publication number
PL2843567T3
PL2843567T3 PL13461545T PL13461545T PL2843567T3 PL 2843567 T3 PL2843567 T3 PL 2843567T3 PL 13461545 T PL13461545 T PL 13461545T PL 13461545 T PL13461545 T PL 13461545T PL 2843567 T3 PL2843567 T3 PL 2843567T3
Authority
PL
Poland
Prior art keywords
normalized
computer
level
implemented method
query execution
Prior art date
Application number
PL13461545T
Other languages
English (en)
Inventor
Krystian Piećko
Original Assignee
Pilab S A
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 Pilab S A filed Critical Pilab S A
Publication of PL2843567T3 publication Critical patent/PL2843567T3/pl

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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • 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
    • 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/284—Relational databases

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)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
PL13461545T 2013-08-30 2013-08-30 Realizowany przy pomocy komputera sposób usprawnienia wykonywania zapytań w relacyjnych bazach danych znormalizowanych na poziomie 4 i powyżej PL2843567T3 (pl)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
EP13461545.9A EP2843567B1 (en) 2013-08-30 2013-08-30 Computer-implemented method for improving query execution in relational databases normalized at level 4 and above

Publications (1)

Publication Number Publication Date
PL2843567T3 true PL2843567T3 (pl) 2017-10-31

Family

ID=49123810

Family Applications (1)

Application Number Title Priority Date Filing Date
PL13461545T PL2843567T3 (pl) 2013-08-30 2013-08-30 Realizowany przy pomocy komputera sposób usprawnienia wykonywania zapytań w relacyjnych bazach danych znormalizowanych na poziomie 4 i powyżej

Country Status (4)

Country Link
US (2) US10095743B2 (pl)
EP (1) EP2843567B1 (pl)
ES (1) ES2636758T3 (pl)
PL (1) PL2843567T3 (pl)

Families Citing this family (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP3182304A1 (en) 2013-03-29 2017-06-21 Pilab S.A. Computer-implemented method for storing unlimited amount of data as a mind map in relational database systems
EP3159815A1 (en) 2013-06-30 2017-04-26 Pilab S.A. Database hierarchy-independent data drilling
ES2636758T3 (es) * 2013-08-30 2017-10-09 Pilab S.A. Procedimiento implementado por ordenador para mejorar la ejecución de consulta en bases de datos relacionales normalizadas en el nivel 4 y superior
EP2843568A1 (en) 2013-08-30 2015-03-04 Pilab S.A. Computer implemented method for creating database structures without knowledge on functioning of relational database system
EP3091449B1 (en) * 2015-05-04 2018-07-25 Deloitte Consulting GmbH Operating a database system
US10726008B2 (en) * 2015-07-15 2020-07-28 Sybase, Inc. Accelerating database queries using enhanced partition elimination
CN107193813B (zh) 2016-03-14 2021-05-14 阿里巴巴集团控股有限公司 数据表连接方式处理方法及装置
WO2017186774A1 (en) 2016-04-26 2017-11-02 Pilab S.A. Systems and methods for querying databases
CN106909666A (zh) * 2017-02-27 2017-06-30 广东工业大学 一种基于多参数扰动的数据挖掘隐私保护方法
WO2019060861A1 (en) * 2017-09-24 2019-03-28 Domo, Inc. SYSTEMS AND METHODS FOR ANALYZING AND VISUALIZING DATA COVERING MULTIPLE DATA SETS
WO2019129520A1 (en) 2017-12-28 2019-07-04 Datawalk Spolka Akcyjna Systems and methods for combining data analyses
PL3732587T3 (pl) 2017-12-29 2024-01-29 DataWalk Spółka Akcyjna Systemy i sposoby dla kontekstowo niezależnych ścieżek przeszukiwania baz danych
EP3732606A1 (en) 2017-12-29 2020-11-04 Datawalk Spolka Akcyjna Systems and methods for determining database permissions
US11295854B1 (en) * 2018-09-11 2022-04-05 Allscripts Software, Llc Proximity-based patient check-in computing system
CN111259003B (zh) * 2020-01-07 2023-07-21 广州虎牙科技有限公司 一种数据库建立方法及装置

Family Cites Families (74)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5604899A (en) 1990-05-21 1997-02-18 Financial Systems Technology Pty. Ltd. Data relationships processor with unlimited expansion capability
US5257349A (en) 1990-12-18 1993-10-26 David Sarnoff Research Center, Inc. Interactive data visualization with smart object
US5539870A (en) 1992-10-05 1996-07-23 International Business Machines Corporation Computerized system and process for interactively managing a distributed database system
US5418961A (en) 1993-01-12 1995-05-23 International Business Machines Corporation Parallel tables for data model with inheritance
US5729730A (en) * 1995-03-28 1998-03-17 Dex Information Systems, Inc. Method and apparatus for improved information storage and retrieval system
US5548754A (en) 1995-02-07 1996-08-20 International Business Machines Corporation Optimization of SQL queries using early-out join transformations
US6038566A (en) 1996-12-04 2000-03-14 Tsai; Daniel E. Method and apparatus for navigation of relational databases on distributed networks
US6425005B1 (en) * 1997-10-06 2002-07-23 Mci Worldcom, Inc. Method and apparatus for managing local resources at service nodes in an intelligent network
US6105035A (en) 1998-02-17 2000-08-15 Lucent Technologies, Inc. Method by which notions and constructs of an object oriented programming language can be implemented using a structured query language (SQL)
US6587856B1 (en) * 1998-12-07 2003-07-01 Oracle International Corporation Method and system for representing and accessing object-oriented data in a relational database system
US6192371B1 (en) 1999-04-28 2001-02-20 Lucent Technologies, Inc Object morphing in an object oriented computing environment using relational database query procedure
US6986102B1 (en) * 2000-01-21 2006-01-10 International Business Machines Corporation Method and configurable model for storing hierarchical data in a non-hierarchical data repository
US20020029207A1 (en) 2000-02-28 2002-03-07 Hyperroll, Inc. Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
US6934712B2 (en) 2000-03-21 2005-08-23 International Business Machines Corporation Tagging XML query results over relational DBMSs
US6947945B1 (en) 2000-03-21 2005-09-20 International Business Machines Corporation Using an XML query language to publish relational data as XML
US8386920B2 (en) 2000-04-27 2013-02-26 Alcatel Lucent Method and apparatus for data visualization
US6598041B1 (en) * 2000-09-07 2003-07-22 International Business Machines Corporation Method, system, and program for processing modifications to data in tables in a database system
JP3636977B2 (ja) * 2000-09-11 2005-04-06 ダットジャパン株式会社 可変長データベース装置及びアクセス方法
CA2427354A1 (en) 2000-10-31 2002-08-01 Michael Philip Kaufman System and method for generating automatic user interface for arbitrarily complex or large databases
GB2406678B (en) * 2000-11-30 2005-05-18 Coppereye Ltd Database
US6782383B2 (en) * 2001-06-18 2004-08-24 Siebel Systems, Inc. System and method to implement a persistent and dismissible search center frame
US7363593B1 (en) 2001-11-30 2008-04-22 Versata Development Group, Inc. System and method for presenting information organized by hierarchical levels
US7693917B2 (en) 2001-11-30 2010-04-06 Intelligent Medical Objects, Inc. Method for adaptive data management
US7058622B1 (en) * 2001-12-26 2006-06-06 Tedesco Michael A Method, apparatus and system for screening database queries prior to submission to a database
US20030208493A1 (en) 2002-04-12 2003-11-06 Hall Bradley S. Object relational database management system
US20040133581A1 (en) 2002-05-21 2004-07-08 High-Speed Engineering Laboratory, Inc. Database management system, data structure generating method for database management system, and storage medium therefor
US6910032B2 (en) * 2002-06-07 2005-06-21 International Business Machines Corporation Parallel database query processing for non-uniform data sources via buffered access
CA2394514A1 (en) 2002-07-23 2004-01-23 Cognos Incorporated Method and system for parameterized database drill-through
CA2394713A1 (en) 2002-07-23 2004-01-23 Cognos Incorporated Static drill-through modelling with graphical interface
US7225197B2 (en) 2002-10-31 2007-05-29 Elecdecom, Inc. Data entry, cross reference database and search systems and methods thereof
US7895191B2 (en) 2003-04-09 2011-02-22 International Business Machines Corporation Improving performance of database queries
US20040255301A1 (en) 2003-06-13 2004-12-16 Andrzej Turski Context association schema for computer system architecture
US7814093B2 (en) * 2003-07-25 2010-10-12 Microsoft Corporation Method and system for building a report for execution against a data store
US7499915B2 (en) 2004-04-09 2009-03-03 Oracle International Corporation Index for accessing XML data
US7831384B2 (en) 2004-10-29 2010-11-09 Aol Inc. Determining a route to destination based on partially completed route
US20060288035A1 (en) 2005-06-16 2006-12-21 Oracle International Corporation Relational database support for immutable media
US8364623B1 (en) * 2005-06-29 2013-01-29 Symantec Operating Corporation Computer systems management using mind map techniques
US7664742B2 (en) 2005-11-14 2010-02-16 Pettovello Primo M Index data structure for a peer-to-peer network
US20070198557A1 (en) * 2006-02-23 2007-08-23 Microsoft Corporation Generic object database system and design
US8103703B1 (en) 2006-06-29 2012-01-24 Mindjet Llc System and method for providing content-specific topics in a mind mapping system
US7606817B2 (en) 2006-08-02 2009-10-20 Entity Labs, Ltd. Primenet data management system
US9020995B2 (en) * 2006-12-28 2015-04-28 International Business Machines Corporation Hybrid relational, directory, and content query facility
US7849050B2 (en) 2007-01-29 2010-12-07 Business Objects Data Integration, Inc. Apparatus and method for analyzing impact and lineage of multiple source data objects
EP2150890A1 (en) * 2007-05-21 2010-02-10 Stefan Becker A method for providing or operating a framework for the realization of independently developed programs
US7734659B2 (en) 2007-06-01 2010-06-08 United Technologies Corporation System and method for creating an object model
US20120317141A1 (en) * 2007-10-12 2012-12-13 Lexxe Pty Ltd System and method for ordering of semantic sub-keys
US8538013B2 (en) * 2007-10-19 2013-09-17 International Business Machines Corporation Rules-driven hash building
US7836100B2 (en) * 2007-10-26 2010-11-16 Microsoft Corporation Calculating and storing data structures including using calculated columns associated with a database system
US8028000B2 (en) * 2008-02-28 2011-09-27 Microsoft Corporation Data storage structure
DE102008047915B4 (de) * 2008-09-19 2010-05-12 Continental Automotive Gmbh Infotainmentsystem und Computerprogrammprodukt
US8214352B2 (en) 2008-11-26 2012-07-03 Hewlett-Packard Development Company Modular query optimizer
US20110289112A1 (en) * 2009-01-26 2011-11-24 Junpei Kamimura Database system, database management method, database structure, and storage medium
US8019783B2 (en) 2009-05-19 2011-09-13 Oracle International Corporation Search interface for finding data items of interest from a database system
US9218380B2 (en) * 2009-12-30 2015-12-22 Telecom Italia S.P.A. Method and system for carrying out searches in a database comprising taxonomic classification of digital information contents
FR2959089B1 (fr) 2010-04-16 2012-08-03 Inst Nat Rech Inf Automat Outil de gestion de ressources et d'infrastructures informatiques et reseaux
US8468151B2 (en) 2010-06-29 2013-06-18 Teradata Us, Inc. Methods and systems for hardware acceleration of database operations and queries based on multiple hardware accelerators
US8694537B2 (en) * 2010-07-29 2014-04-08 Soundhound, Inc. Systems and methods for enabling natural language processing
US20120096002A1 (en) 2010-10-19 2012-04-19 7 Degrees, Inc. Systems and methods for generating and managing a universal social graph database
EP2455869A1 (en) * 2010-11-04 2012-05-23 Tieto Oyj Method for performing a database search in a database system
US20140046983A1 (en) 2011-05-05 2014-02-13 Centrifuge Pty Ltd Data Analysis
US8806352B2 (en) 2011-05-06 2014-08-12 David H. Sitrick System for collaboration of a specific image and utilizing selected annotations while viewing and relative to providing a display presentation
US9720708B2 (en) * 2011-08-19 2017-08-01 Advanced Micro Devices, Inc. Data layout transformation for workload distribution
JP5916325B2 (ja) 2011-09-30 2016-05-11 株式会社Ｓｃｒｅｅｎホールディングス インクジェットプリンタおよび画像記録方法
US9020981B2 (en) 2011-09-30 2015-04-28 Comprehend Systems, Inc. Systems and methods for generating schemas that represent multiple data sources
US8874621B1 (en) 2011-10-09 2014-10-28 LockPath, Inc. Dynamic content systems and methods
US9286583B2 (en) 2011-12-05 2016-03-15 International Business Machines Corporation Integrating mind mapping technology with case modeling
US9472015B2 (en) 2012-05-15 2016-10-18 Sap Se Real-time visualization of transactional data objects
US9165048B2 (en) * 2012-05-16 2015-10-20 Sap Se Linked field table for databases
US8793246B1 (en) * 2013-03-08 2014-07-29 Fmr Llc Identifying ranking scores for domains of interest
EP3182304A1 (en) * 2013-03-29 2017-06-21 Pilab S.A. Computer-implemented method for storing unlimited amount of data as a mind map in relational database systems
US9483508B1 (en) 2013-06-28 2016-11-01 Google Inc. Omega names: name generation and derivation
EP3159815A1 (en) * 2013-06-30 2017-04-26 Pilab S.A. Database hierarchy-independent data drilling
ES2636758T3 (es) * 2013-08-30 2017-10-09 Pilab S.A. Procedimiento implementado por ordenador para mejorar la ejecución de consulta en bases de datos relacionales normalizadas en el nivel 4 y superior
EP2843568A1 (en) 2013-08-30 2015-03-04 Pilab S.A. Computer implemented method for creating database structures without knowledge on functioning of relational database system

Also Published As

Publication number Publication date
EP2843567A1 (en) 2015-03-04
EP2843567B1 (en) 2017-05-10
US11893022B2 (en) 2024-02-06
US10095743B2 (en) 2018-10-09
US20150066986A1 (en) 2015-03-05
ES2636758T3 (es) 2017-10-09
US20190042624A1 (en) 2019-02-07

Similar Documents

Publication Publication Date Title
PL2843567T3 (pl) Realizowany przy pomocy komputera sposób usprawnienia wykonywania zapytań w relacyjnych bazach danych znormalizowanych na poziomie 4 i powyżej
HK1223174A1 (zh) 表型整合社交搜索數據庫及方法
EP3710957A4 (en) DATABASE METADATA IN IMMUTABLE MEMORY
EP2946333A4 (en) EFFICIENT QUERY PROCESSING USING HISTOGRAMS IN A COLUMN DATABASE
EP3039574A4 (en) Queries involving multiple databases and execution engines
GB201404489D0 (en) Computer-implemented systems and methods for comparing and associating objects
GB201404486D0 (en) Computer-implemented systems and methods for comparing and associating objects
IL239717A0 (en) System and method for distributed database query engines
EP2973035A4 (en) PREVIEWS OF SOCIAL ENTITIES IN A REQUEST FORMULATION
EP2913768A4 (en) METHOD AND DATABASE ENGINE FOR RECORDING A TRANSACTION LOG
EP3079078A4 (en) Multi-version concurrency control method in database, and database system
EP2962226A4 (en) SYSTEM AND METHOD FOR DISTRIBUTED SQL JOINT PROCESSING IN NON-SHARED RELATIONAL DATA BASE CLUSTERS USING FIXED TABLES
HK1204685A1 (en) Method for classifying query word and device thereof
EP3111347A4 (en) Efficient methods and systems for consistent read in record-based multi-version concurrency control
GB201315611D0 (en) Method and system for accessing a set of data tables in a source database
GB2514320B (en) A method and system for 3D model database retrieval
EP3077918A4 (en) Systems and methods for in-memory database search
EP2875423A4 (en) SEARCH PROPOSALS PARTLY BASED ON A PREVIOUS SEARCH AND SEARCH OPERATIONS BASED ON SUCH SUGGESTIONS
EP2948890A4 (en) SYSTEM AND METHOD FOR SEARCHING DATABASES
EP2947582A4 (en) COMPUTER DEVICE AND METHOD FOR PERFORMING DATABASE COMMAND INSTRUCTIONS
GB201307293D0 (en) Method and system for scoring data in a database
EP2963562A4 (en) RELATIONAL GRAPHIC DATABASE SYSTEM
GB201409463D0 (en) Database controller, method, and program for handling range queries
EP2761504A4 (en) APPARATUS AND METHOD FOR SEARCHING DISTRIBUTED KEY DATABASE KEYWORDS
EP2933750A4 (en) INTERMEDIATE SERVER, DATA BASE INTERROGATION PROCESSING METHOD, AND PROGRAM