SYSTEM AND METHOD FOR AUTOLOADING OF MULTIPLE TABLES FROM RELATIONAL DATABASE TO THE BIG DATA STORAGE PLATFORM

    公开(公告)号:MY179970A

    公开(公告)日:2020-11-19

    申请号:MYPI2015704308

    申请日:2015-11-26

    Applicant: MIMOS BERHAD

    Inventor: SEAH BOON KEONG

    Abstract: A system (100) and method of the present invention provide autoloading of multiple tables from a relational database (101) to a big data storage platform (102). The system and method of the present invention allow automatically loading of multiple tables to the big data storage platform for all tables with or without having a primary key by pre-identifying the multiple tables having primary key for data loading 10 and the target data store of the big data storage platform (102). For tables not having primary key, the temporary table will be pre-created whereby an auto-incrementing number will be pre-inserted into the temporary table. Hence, the tables not having primary keys will also be loaded by the present system and method. Figure 3

    METHOD FOR AUTOMATICALLY GENERATING SCHEMA AGNOSTIC OF DATABASE

    公开(公告)号:MY171409A

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

    申请号:MYPI2015001696

    申请日:2015-06-30

    Applicant: MIMOS BERHAD

    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.

    A SYSTEM AND METHOD FOR CLOUD PROVIDER TO PROVIDE VIRTUAL MACHINE SUBSCRIPTION SERVICE

    公开(公告)号:MY178206A

    公开(公告)日:2020-10-06

    申请号:MYPI2013002662

    申请日:2013-07-12

    Applicant: MIMOS BERHAD

    Inventor: SEAH BOON KEONG

    Abstract: Super user control subscription service by cloud infrastructure provider in which said super user has control access limitation over virtual machine application deployment by utilizing five main features namely interface layer; super user control service (SCS) storage; super user creator and rules validator; packet interception engine and packet queue. Further, the present invention deploys the used of logging activities of the said super user upon providing validation for authentication and authorization of Subscriber 1 (Submitter) and Subscriber 2 (Approver) to enhance security of the super user control subscription service. The present invention comprising at least one cloud provider administrator (102) and at least one virtual machine subscriber (104) in communication with at least one cloud infrastructure provider portal within a portal access; at least one networking protocol suite (110) in communication with at least one cloud service provider (CSP) portal (112) within a network; and at least one super user control service (SCS) (108) in communication with the at least one cloud infrastructure provider portal within a portal access and in communication with at least one cloud service provider (CSP) portal (112) within a network; said super user control service (SCS) enables virtual machine (VM) subscription service by enabling super user control limit to avoid insider security threats. The at least one interface layer (122) enables super user rules configuration for super user control service (SCS) subscriber through cloud infrastructure provider portal; the at least one super user creator and rules validator (116) creates and validates rules; the super user control service (SCS) storage (118) stores super user service (SCS} subscriber user information and super user rules information; the packet interception engine (120) verifies super user rules obtained from said super user control service (SCS) storage prior to forwarding to at least one virtual machine on cloud network layer and the packet queue module (114) queues network packet for analysis by said packet interception engine (120).

    METHOD FOR QUERYING ANY DATABASE WITH DYNAMIC PARAMETERIZED QUERY

    公开(公告)号:MY174817A

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

    申请号:MYPI2015001694

    申请日:2015-06-30

    Applicant: MIMOS BERHAD

    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.

    METHOD FOR DATA INPUT INTO A DATABASE

    公开(公告)号:MY187720A

    公开(公告)日:2021-10-14

    申请号:MYPI2014702153

    申请日:2014-08-05

    Applicant: MIMOS BERHAD

    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.

    A SYSTEM AND METHOD FOR SYNCHRONIZING OF CACHE REMOTELY WITH PRE-FETCHING OF NON-PROTECTED CONTENTS AND PROTECTED CONTENTS

    公开(公告)号:MY159279A

    公开(公告)日:2016-12-30

    申请号:MYPI2013002550

    申请日:2013-07-03

    Applicant: MIMOS BERHAD

    Inventor: SEAH BOON KEONG

    Abstract: PRE-FETCHING OF BOTH NON-PROTECTED AND PROTECTED CONTENTS FOR TRANSPARENT CACHING IS DESCRIBED IN THE PRESENT INVENTION TO IMPROVE USER EXPERIENCE. A SYSTEM (100) FOR SYNCHRONIZING OF CACHE REMOTELY WITH PRE-FETCHING OF BOTH NON-PROTECTED AND PROTECTED CONTENTS FOR TRANSPARENT CACHING COMPRISING AT LEAST ONE PROXY CACHE SERVER (104, 104N) CONNECTED TO A NETWORK AT EACH CLIENT SIDE OF SAID SYSTEM; AT LEAST ONE CLIENT PREFETCH CACHE APPLICATION (106, 106N) CONNECTED TO A NETWORK AT EACH CLIENT SIDE OF SAID SYSTEM: AT LEAST ONE SERVER PREFETCH CACHE APPLICATION (108) CONNECTED TO A NETWORK AT EACH SERVER SIDE OF SAID SYSTEM. THE AT LEAST ONE CLIENT PREFETCH CACHE APPLICATION (106, 106N) PERIODICALLY CHECK FOR SERVER PREFETCH CACHE FILE LISTING TO DOWNLOAD FILES TO CLIENT THROUGH SAID PROXY CACHE SERVER (104, 104N) LOCATED AT CLIENT SIDE; AND THE AT LEAST ONE SERVER PREFETCH CACHE APPLICATION (108) PERIODICALLY CHECK FOR BOTH PROTECTED AND NON- PROTECTED OF SERVERS FOR NEW CONTENTS TO BE CREATED WITH ENCRYPTED FILE LISTING LOCATION FOR RETRIEVAL BY SAID CLIENT PREFETCH CACHE APPLICATION (106, 106N). UTILIZATION OF THE AT LEAST ONE SERVER PREFETCH CACHE APPLICATION AND CLIENT PREFETCH CACHE APPLICATION IN BOTH PROXY CACHE SERVER AND APPLICATION SERVER WHEREIN THE NEED FOR ENABLING THE FILE DIRECTORY FEATURE IS NO LONGER REQUIRED. THE PRESENT INVENTION FURTHER PROVIDES ENCRYPTION FOR GENERATED RESOURCE REFERENCE PATH AT THE SERVER SIDE FOR SHARING BETWEEN STANDALONE APPLICATIONS; ABILITY TO RETRIEVE PLURALITY OF APPLICATION SERVERS WHILE CONFIGURABLE PARAMETERS FOR PREFETCHING CONTENTS TO ENABLE EASY CUSTOMIZATION TO CACHE AND RESOURCE REFERENCE REWRITING ON PROXY CACHE FOR PROTECTED CONTENT TO SIMULATE CONTENTS RETRIEVED FROM UNPROTECTED REFERENCE PATH.

Patent Agency Ranking