WO2012169807A3 - Method and system for building database using data warehouse - Google Patents

Method and system for building database using data warehouse Download PDF

Info

Publication number
WO2012169807A3
WO2012169807A3 PCT/KR2012/004507 KR2012004507W WO2012169807A3 WO 2012169807 A3 WO2012169807 A3 WO 2012169807A3 KR 2012004507 W KR2012004507 W KR 2012004507W WO 2012169807 A3 WO2012169807 A3 WO 2012169807A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
data warehouse
ods
items
generating
Prior art date
Application number
PCT/KR2012/004507
Other languages
French (fr)
Korean (ko)
Other versions
WO2012169807A2 (en
Inventor
백승호
Original Assignee
Baek Seung Ho
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 Baek Seung Ho filed Critical Baek Seung Ho
Publication of WO2012169807A2 publication Critical patent/WO2012169807A2/en
Publication of WO2012169807A3 publication Critical patent/WO2012169807A3/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
    • G06F16/212—Schema design and management with details for data modelling support

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

A method for building a database using a data warehouse is comprised by generating the data warehouse based on items of source data, which are provided by at least one source system. The method for building the database comprises the steps of: configuring an operational data store (ODS) by refining at least a portion of the items of source data; comprising the data warehouse (DW) by integrating the ODS data and generating a reference relationship between the items of data which have an associative relationship; comprising a business logic by enabling at least one business rule for analysis; and comprising a data mart by generating a multi-dimensional model per analysis subject with regard to the ODS or the DW data, based on the at least one business rule.
PCT/KR2012/004507 2011-06-07 2012-06-07 Method and system for building database using data warehouse WO2012169807A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
KR10-2011-0054503 2011-06-07
KR1020110054503A KR101253335B1 (en) 2011-06-07 2011-06-07 Method for constructing database based on warehouse and database system therof

Publications (2)

Publication Number Publication Date
WO2012169807A2 WO2012169807A2 (en) 2012-12-13
WO2012169807A3 true WO2012169807A3 (en) 2013-03-28

Family

ID=47296607

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/KR2012/004507 WO2012169807A2 (en) 2011-06-07 2012-06-07 Method and system for building database using data warehouse

Country Status (2)

Country Link
KR (1) KR101253335B1 (en)
WO (1) WO2012169807A2 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101508068B1 (en) * 2013-11-19 2015-04-07 중소기업은행 Apparatus and method for data de-duplication
CN110807016A (en) * 2019-09-29 2020-02-18 北京淇瑀信息科技有限公司 Data warehouse construction method and device applied to financial business and electronic equipment
CN111159154A (en) * 2019-12-31 2020-05-15 新奥数能科技有限公司 Energy data warehouse system
CN111104394A (en) * 2019-12-31 2020-05-05 新奥数能科技有限公司 Energy data warehouse system construction method and device
CN111367989B (en) * 2020-06-01 2020-08-28 北京江融信科技有限公司 Real-time data index calculation system and method
CN112612778B (en) * 2020-12-25 2024-05-07 上海航空工业(集团)有限公司 Enterprise data architecture method

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010084166A (en) * 2000-02-24 2001-09-06 이태균 System and method for providing customer relationship management solution based on internet
JP2003150594A (en) * 2001-11-12 2003-05-23 Hitachi Ltd Data warehouse system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010084166A (en) * 2000-02-24 2001-09-06 이태균 System and method for providing customer relationship management solution based on internet
JP2003150594A (en) * 2001-11-12 2003-05-23 Hitachi Ltd Data warehouse system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
CHOI, CHEOL MIN.: "Design and implementation of Data WareHouse-based for the Efficient Analysis of Data", GRADUATE SCHOOL OF ENGINEERING & TECHNOLOGY, August 2007 (2007-08-01) *

Also Published As

Publication number Publication date
KR101253335B1 (en) 2013-04-10
WO2012169807A2 (en) 2012-12-13
KR20120135665A (en) 2012-12-17

Similar Documents

Publication Publication Date Title
CA2834864C (en) Database system and method
WO2014102548A3 (en) Search system and corresponding method
WO2012169807A3 (en) Method and system for building database using data warehouse
WO2013025996A3 (en) Multidimensional digital platform for building integration and analysis
MX341699B (en) Course skeleton for adaptive learning.
WO2014025705A3 (en) Search result ranking and presentation
WO2014085832A3 (en) Event investigation within an online research system
WO2007127956A3 (en) Apparatus and method for merging metadata within a repository
WO2011109583A3 (en) Bottom-up optimized search system and method
WO2011149961A3 (en) Systems and methods for identifying intersections using content metadata
CA2836829C (en) Systems and methods for in-memory database processing
WO2008019364A3 (en) Method, system, and computer readable storage for affiliate group searching
GB201120308D0 (en) System and method for controlling operation of an airline
GB2520878A (en) System and method for matching data using probabilistic modeling techniques
WO2012126015A3 (en) Xbrl database mapping system and method
IN2014DN00244A (en)
WO2012093815A3 (en) Method, system, and computer-readable recording medium for recommending other users or objects by considering preference of at least one user
WO2013089919A3 (en) Developing and executing workflow processes associated with data-encoded tags
WO2014004204A3 (en) Systems and methods for analyzing and managing electronic content
WO2013006367A3 (en) Airport operations optimization
IN2015DE02783A (en)
WO2014025811A3 (en) Method and apparatus of implementing navigation of product properties
WO2012039923A3 (en) Data model dualization
WO2013025624A3 (en) Searching encrypted electronic books
WO2013033473A3 (en) Searching belongings using social graph information

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: 12797382

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 28/03/2014)

122 Ep: pct application non-entry in european phase

Ref document number: 12797382

Country of ref document: EP

Kind code of ref document: A2