公开(公告)号：MY171409A

公开(公告)日：2019-10-11

申请号：MYPI2015001696

申请日：2015-06-30

Applicant: MIMOS BERHAD

Inventor： SEAH BOON KEONG ,  MOHAMMED SHAFI HANDI ,  NOR EZAM BIN SELAN

Abstract: A method (100) for automatically generating schema agnostic of database type, date dimension and data loading in multiple target databases is disclosed. The databases can be a single or cluster based on relational database management system (RDBMS) or Big Data (NoSQUSQL) databases. The method includes step of generating SQL statements (103) that define the tables or views to multiple target databases in order to enable different data type required for the target databases. In addition, the method also includes a common metadata definition that is mapped to the selected target database (102) for table creation and update process without the need ofSQL knowledge.

公开(公告)号：MY174817A

公开(公告)日：2020-05-17

申请号：MYPI2015001694

申请日：2015-06-30

Applicant: MIMOS BERHAD

Inventor： SEAH BOON KEONG ,  NOR EZAM BIN SELAN ,  KHALID MOHAMMAD SALEEM

Abstract: A method (100) for dynamically creating multiple charts based on dynamic parameterized input defined for SQL query. The method comprises of retrieving data from any database (101), creating multiple parameters input based on user defined SQL query parameters input (103), receiving the results of the query (104) and dynamically generating multiple charts with dynamic filtering options from the results (105). With this method, it will enable end-user to analyze the data rapidly without the need of skilled developers to develop the reports in the application tool system.