MY187720A - Method for data input into a database - Google Patents

Method for data input into a database

Info

Publication number
MY187720A
MY187720A MYPI2014702153A MYPI2014702153A MY187720A MY 187720 A MY187720 A MY 187720A MY PI2014702153 A MYPI2014702153 A MY PI2014702153A MY PI2014702153 A MYPI2014702153 A MY PI2014702153A MY 187720 A MY187720 A MY 187720A
Authority
MY
Malaysia
Prior art keywords
data
database
data input
disclosed
source
Prior art date
Application number
MYPI2014702153A
Inventor
Boon Keong Seah
Kwang Ming Ng
Original Assignee
Mimos Berhad
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 Mimos Berhad filed Critical Mimos Berhad
Priority to MYPI2014702153A priority Critical patent/MY187720A/en
Priority to PCT/MY2015/050077 priority patent/WO2016022019A1/en
Publication of MY187720A publication Critical patent/MY187720A/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/25—Integrating or interfacing systems involving database management systems
    • G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

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)

Abstract

A database is a central source of data for query and analysis. Functions of a database include retrieving, analyzing, transforming, loading and managing data; making them available for further use. Disclosed herein is a method for improved data input into a database whilst maintaining the structure of metric of facts. Data is extracted from a data source (1), transformed and loaded into fact tables in a data warehouse by means of bridge tables. Automation of dynamically adding dimensions into multiple fact tables with respect to the data source (1) is disclosed in the present invention.
MYPI2014702153A 2014-08-05 2014-08-05 Method for data input into a database MY187720A (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
MYPI2014702153A MY187720A (en) 2014-08-05 2014-08-05 Method for data input into a database
PCT/MY2015/050077 WO2016022019A1 (en) 2014-08-05 2015-07-28 Method for data input into a database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
MYPI2014702153A MY187720A (en) 2014-08-05 2014-08-05 Method for data input into a database

Publications (1)

Publication Number Publication Date
MY187720A true MY187720A (en) 2021-10-14

Family

ID=54145972

Family Applications (1)

Application Number Title Priority Date Filing Date
MYPI2014702153A MY187720A (en) 2014-08-05 2014-08-05 Method for data input into a database

Country Status (2)

Country Link
MY (1) MY187720A (en)
WO (1) WO2016022019A1 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
AU2017224831B2 (en) 2016-02-26 2023-01-05 Crysp Intelligence Pty Ltd A data source system agnostic fact category partitioned information repository and methods for the insertion and retrieval of data using the information repository
CN109947861B (en) * 2017-11-09 2021-06-29 北京京东尚科信息技术有限公司 Method, apparatus and computer readable medium for data warehouse to generate target table
CN114595294B (en) * 2022-03-11 2022-09-20 北京梦诚科技有限公司 Data warehouse modeling and extracting method and system

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090055439A1 (en) 2007-08-24 2009-02-26 Ketera Technologies, Inc. Flexible Dimension Approach In A Data Warehouse
US8352458B2 (en) 2008-05-07 2013-01-08 Oracle International Corporation Techniques for transforming and loading data into a fact table in a data warehouse
US8818974B2 (en) 2010-10-27 2014-08-26 Hewlett-Packard Development Company, L.P. System and method for synchronously updating a hierarchy bridge table
US20140188784A1 (en) * 2012-12-28 2014-07-03 Joseph Guerra Systems and methods for data-warehousing to facilitate advanced business analytic assessment

Also Published As

Publication number Publication date
WO2016022019A1 (en) 2016-02-11

Similar Documents

Publication Publication Date Title
WO2016029018A3 (en) Executing constant time relational queries against structured and semi-structured data
PH12019501965A1 (en) Method and device for constructing scoring model and evaluating user credit
MY179952A (en) Graph generating device, graph generating method and graph generating program
WO2014183956A3 (en) Social media content analysis and output
WO2015191746A8 (en) Systems and methods for a database of software artifacts
WO2016018472A3 (en) Content-based association of device to user
GB2542053A (en) Automatically generating a semantic mapping for a relational database
CR20150552A (en) LANGUAGE LEARNING ENVIRONMENT
EP3477529C0 (en) Bottom up data anonymization in an in-memory database
SG10201810036QA (en) Processing queries containing a union-type operation
WO2012126015A3 (en) Xbrl database mapping system and method
MX2015015041A (en) Compiling drilling scenario data from disparate data sources.
MX2018007269A (en) Method and device for correlating multiple tables in a database environment.
EP2816431A3 (en) Information platform for industrial automation stream-based data processing
TW201614571A (en) Social media sharing system and method
IN2014CH00917A (en)
IES87497Y1 (en) System and method for secure analysis of datasets
PH12014502861A1 (en) Control system for machinery and equipment
MY187720A (en) Method for data input into a database
BR112016030854A2 (en) globally scalable solution
MX2017005214A (en) Reception device, transmission device, and data processing method.
IN2013MU01495A (en)
TW201711736A (en) Information distribution methods, computer readable media, and information distribution servers
GB2556481A (en) Automatic imports and dependencies in large-scale source code repositories
GB2534481A (en) Data analytics for oilfield data repositories