[go: up one dir, main page]

WO2018174749A3 - Электронная база данных и способ ее формирования - Google Patents

Электронная база данных и способ ее формирования Download PDF

Info

Publication number
WO2018174749A3
WO2018174749A3 PCT/RU2018/000157 RU2018000157W WO2018174749A3 WO 2018174749 A3 WO2018174749 A3 WO 2018174749A3 RU 2018000157 W RU2018000157 W RU 2018000157W WO 2018174749 A3 WO2018174749 A3 WO 2018174749A3
Authority
WO
WIPO (PCT)
Prior art keywords
database
data
elements
column
storing
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.)
Ceased
Application number
PCT/RU2018/000157
Other languages
English (en)
French (fr)
Other versions
WO2018174749A2 (ru
Inventor
Алексей Петрович СЕМЕНОВ
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
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 Individual filed Critical Individual
Priority to DE112018001458.4T priority Critical patent/DE112018001458T5/de
Priority to CN201880013620.5A priority patent/CN110325977A/zh
Priority to US16/489,623 priority patent/US11138174B2/en
Publication of WO2018174749A2 publication Critical patent/WO2018174749A2/ru
Publication of WO2018174749A3 publication Critical patent/WO2018174749A3/ru
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/2282—Tablespace storage structures; Management thereof
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/221—Column-oriented storage; Management thereof
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/2272—Management thereof
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/901—Indexing; Data structures therefor; Storage structures

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)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Группа изобретений относится к области обработки данных, а именно к электронной базе данных и способу формирования электронной базы данных. Техническим результатом заявляемой группы изобретений является повышение надежности базы данных за счет исключения ошибок при добавлении новых данных и формировании запросов и отчетов, а также снижения риска лавинообразной деградации производительности из-за отсутствия необходимых индексов при работе с большими объемами данных (десятки и сотни миллионов записей). Способы и системы для формирования электронной базы данных, при этом электронная база данных содержит элементы базы данных, организованные в единственную таблицу, которая содержит по крайней мере четыре столбца, включающие: первый столбец для хранения идентификационных номеров элементов базы данных, второй столбец для хранения номеров родительских элементов для элементов базы данных, находящихся в зависимости от других элементов базы данных, третий столбец для хранения значений элементов базы данных, четвертый столбец для хранения кодов используемых типов данных; и по крайней мере пять строк, которые включают в себя: первую строку, отображающую корневой элемент, вторую строку, отображающую тип данных, третью строку, отображающую термин, четвертую строку, отображающую реквизит термина, пятую строку, отображающую данные.
PCT/RU2018/000157 2017-03-20 2018-03-14 Электронная база данных и способ ее формирования Ceased WO2018174749A2 (ru)

Priority Applications (3)

Application Number Priority Date Filing Date Title
DE112018001458.4T DE112018001458T5 (de) 2017-03-20 2018-03-14 Elektronische datenbank und verfahren zu deren erstellung
CN201880013620.5A CN110325977A (zh) 2017-03-20 2018-03-14 电子数据库及其生成方法
US16/489,623 US11138174B2 (en) 2017-03-20 2018-03-14 Electronic database and method for forming same

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
RU2017109115 2017-03-20
RU2017109115A RU2650032C1 (ru) 2017-03-20 2017-03-20 Электронная база данных и способ её формирования

Publications (2)

Publication Number Publication Date
WO2018174749A2 WO2018174749A2 (ru) 2018-09-27
WO2018174749A3 true WO2018174749A3 (ru) 2018-11-22

Family

ID=61867122

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/RU2018/000157 Ceased WO2018174749A2 (ru) 2017-03-20 2018-03-14 Электронная база данных и способ ее формирования

Country Status (5)

Country Link
US (1) US11138174B2 (ru)
CN (1) CN110325977A (ru)
DE (1) DE112018001458T5 (ru)
RU (1) RU2650032C1 (ru)
WO (1) WO2018174749A2 (ru)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
RU2696295C1 (ru) * 2018-10-31 2019-08-01 Алексей Викторович Морозов Способ формирования и структурирования электронной базы данных

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5442784A (en) * 1990-03-16 1995-08-15 Dimensional Insight, Inc. Data management system for building a database with multi-dimensional search tree nodes
US6163775A (en) * 1995-03-28 2000-12-19 Enfish, Inc. Method and apparatus configured according to a logical table having cell and attributes containing address segments
US6505205B1 (en) * 1999-05-29 2003-01-07 Oracle Corporation Relational database system for storing nodes of a hierarchical index of multi-dimensional data in a first module and metadata regarding the index in a second module
RU2364921C2 (ru) * 2003-10-23 2009-08-20 Майкрософт Корпорейшн Доступ к различным типам электронных сообщений через общий интерфейс обмена сообщениями

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5369761A (en) 1990-03-30 1994-11-29 Conley; John D. Automatic and transparent denormalization support, wherein denormalization is achieved through appending of fields to base relations of a normalized database
AU2002334721B2 (en) * 2001-09-28 2008-10-23 Oracle International Corporation An index structure to access hierarchical data in a relational database system
EP2662782A1 (en) * 2012-05-10 2013-11-13 Siemens Aktiengesellschaft Method and system for storing data in a database
CN103605797A (zh) * 2013-12-05 2014-02-26 用友软件股份有限公司 数据存储、查询装置和数据存储、查询方法
RU2613026C1 (ru) * 2015-09-30 2017-03-14 Общество с ограниченной ответственностью "Интерсофт" Способ подготовки документов на языках разметки при реализации пользовательского интерфейса для работы с данными информационной системы
CN106407303A (zh) * 2016-08-30 2017-02-15 北京深思数盾科技股份有限公司 数据存储、查询方法及装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5442784A (en) * 1990-03-16 1995-08-15 Dimensional Insight, Inc. Data management system for building a database with multi-dimensional search tree nodes
US6163775A (en) * 1995-03-28 2000-12-19 Enfish, Inc. Method and apparatus configured according to a logical table having cell and attributes containing address segments
US6505205B1 (en) * 1999-05-29 2003-01-07 Oracle Corporation Relational database system for storing nodes of a hierarchical index of multi-dimensional data in a first module and metadata regarding the index in a second module
RU2364921C2 (ru) * 2003-10-23 2009-08-20 Майкрософт Корпорейшн Доступ к различным типам электронных сообщений через общий интерфейс обмена сообщениями

Also Published As

Publication number Publication date
RU2650032C1 (ru) 2018-04-06
US20190370242A1 (en) 2019-12-05
US11138174B2 (en) 2021-10-05
WO2018174749A2 (ru) 2018-09-27
DE112018001458T5 (de) 2019-12-05
CN110325977A (zh) 2019-10-11

Similar Documents

Publication Publication Date Title
US9953102B2 (en) Creating NoSQL database index for semi-structured data
JP2013507689A5 (ru)
Khan et al. Exploring query optimization techniques in relational databases
CN110633292A (zh) 一种异构数据库的查询方法、装置、介质、设备及系统
CN102722584B (zh) 数据存储系统及方法
WO2018039381A3 (en) INTERFACE TOOL FOR ASSET FAILURE ANALYSIS
US9600559B2 (en) Data processing for database aggregation operation
CN102521303A (zh) 一种用于列数据库的单表多列序存储方法
Caballero et al. The rise of goodfatr: A novel accuracy comparison methodology for indicator extraction tools
CN104376091A (zh) 对SQLite中删除的数据进行恢复的方法及装置
US20200089798A1 (en) High volume-velocity time series data ingestion, analysis and reporting method and system
WO2018174749A3 (ru) Электронная база данных и способ ее формирования
AU2020276417B2 (en) Methods, systems, and media for resolving graph database queries
WO2006089208B1 (en) Processing information management in a plasma processing tool
US9031930B2 (en) Data browser for group-by data access
US10346376B2 (en) Systems and methods for database management
CN106933919B (zh) 数据表的连接方法及装置
Kim et al. Big data security hardening methodology using attributes relationship
CN106933902B (zh) 数据多维度自由剖析的查询方法及装置
CA2824227A1 (en) Storage and retrieval of sensor data and computed parameters for use in condition based maintenance systems
CN101980190A (zh) 一种业务数据快速入库的方法和装置
US20170109835A1 (en) Standard working hours management system
CN106933933B (zh) 数据表信息的处理方法及装置
US11061880B2 (en) Data structure with identifiers
CN108197162B (zh) 呈现业务交易情况的系统和方法

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 18771150

Country of ref document: EP

Kind code of ref document: A2

122 Ep: pct application non-entry in european phase

Ref document number: 18771150

Country of ref document: EP

Kind code of ref document: A2