公开(公告)号：US10990573B2

公开(公告)日：2021-04-27

申请号：US16248799

申请日：2019-01-16

申请人： SYSCOM COMPUTER ENGINEERING CO.

发明人： Chen-Yu Yen ,  Pei-Fen Hu ,  Shu-Yuan Hu ,  Kun-Ting Chiu

IPC分类号： G06F16/22 ,  G06F16/2453

摘要： A fast index creation system for a cloud big data database electrically and communicatively coupled to a cloud non-relational database for inquiring and creating an index includes an application exchange module, a data exchange module, a first processing module, a second processing module and an integrated processing module. The application exchange module receives a query string inputted by a user and prompts a result index table. The data exchange module has a temporary index table. The first processing module computes the query string and generates a query instruction to compute a temporary index table for comparison and check if there is any data matched with the query instruction. If yes, then the first processing module will generate a cache index table, or else the first module will generate a create instruction provided for the second processing module to compute a non-relational database and generate a new index table.

公开(公告)号：US20150074794A1

公开(公告)日：2015-03-12

申请号：US14019547

申请日：2013-09-06

申请人： SYSCOM COMPUTER ENGINEERING CO.

发明人： Ching-Ju Chuang ,  Pei-Fen Hu ,  Shu-Yuan Hu ,  Kun-Ting Chiu

IPC分类号： H04L29/06

CPC分类号： H04L63/0218 ,  G06F17/3056 ,  H04L12/4641 ,  H04L63/02 ,  H04L63/0272 ,  H04L63/029 ,  H04L63/08 ,  H04L67/02 ,  H04L67/1002

摘要： Disclosed is a system for accessing data of a cloud database via transparent technology, and the system includes at least one channel server and at least one cloud database end. When a connection notice is outputted from an application end, the user channel unit detects a first server address and a first database address in a HTTP data format, and connects to a corresponding channel server via the HTTP tunnel to send a database request, so that the channel server can convert the first database address in the HTTP data format into a TCP/IP data format and then connect to a corresponding database end. Therefore, the application end can access data from the database behind the firewall via the Internet without modifying any program code.

摘要翻译： 公开了一种通过透明技术访问云数据库的数据的系统，并且系统包括至少一个信道服务器和至少一个云数据库端。 当从应用端输出连接通知时，用户信道单元以HTTP数据格式检测第一服务器地址和第一数据库地址，并且经由HTTP隧道连接到对应的信道服务器以发送数据库请求，使得 通道服务器可以将HTTP数据格式的第一个数据库地址转换为TCP / IP数据格式，然后连接到相应的数据库端。 因此，应用程序结束可以通过Internet从防火墙后面的数据库访问数据，而无需修改任何程序代码。

公开(公告)号：US20180232406A1

公开(公告)日：2018-08-16

申请号：US15430544

申请日：2017-02-13

申请人： SYSCOM COMPUTER ENGINEERING CO.

发明人： TZE-JEN YU ,  KUN-TING CHIU ,  SHU-YUAN HU ,  PEI-FEN HU

IPC分类号： G06F17/30 ,  H04L29/08 ,  H04L12/24

CPC分类号： G06F16/213 ,  G06F16/27 ,  H04L41/024 ,  H04L67/1097

摘要： A big data database system created in a language structure of a SQL database and a language structure of a NoSQL database is provided for accessing data after clients have requested for a connection, and the system includes at least one transfer server and a data host, and the transfer server has a plurality of queuing devices and an assigner, and the queuing devices are telecommunicatively coupled to the clients respectively, and the assigner is telecommunicatively coupled to the queuing devices and the data host. When the clients send out a data request, the respective queuing device receives and queues the data request, and the assigner sends the data request to the data host through a single connection between the transfer server and the data host. Therefore, the connection load of the data host of a terminal is reduced to improve the overall system operation performance.

公开(公告)号：US20140201192A1

公开(公告)日：2014-07-17

申请号：US13741400

申请日：2013-01-15

申请人： SYSCOM COMPUTER ENGINEERING CO.

发明人： PEI-FEN HU ,  CHEN-YU YEN ,  SHU-YUAN HU ,  KUN-TING CHIU

IPC分类号： G06F17/30

CPC分类号： G06F16/2272 ,  G06F16/2455 ,  G06F16/24553

摘要： An automatic data index establishment method includes the steps of comparing a data index existed in at least one table when a database inquires at least one query to obtain the data index correspondingly and directly uses the data index to search related data. If the query has no corresponding data index, a Where Condition field, a Sorting field and a Group By field of the query are recorded and integrated to automatically generate the newly established data index and fill the data index into the table correspondingly. Therefore, the database has intelligent functions with automatic analysis to automatically generate, update, and delete the data index, so as to achieve the effects of enhancing the accuracy and execution efficiency of the data management and reducing the manpower of data managers effectively.

摘要翻译： 自动数据索引建立方法包括以下步骤：当数据库查询至少一个查询以相应地获得数据索引时，比较存在于至少一个表中的数据索引，并直接使用数据索引来搜索相关数据。 如果查询没有相应的数据索引，则会记录并整合查询的Where Condition字段，Sorting字段和Group By字段，以自动生成新建立的数据索引，并相应地将数据索引填充到表中。 因此，数据库具有自动分析的智能功能，可自动生成，更新和删除数据索引，从而实现提高数据管理的准确性和执行效率，有效降低数据管理人员的效率。

公开(公告)号：US20200226116A1

公开(公告)日：2020-07-16

申请号：US16248799

申请日：2019-01-16

申请人： SYSCOM COMPUTER ENGINEERING CO.

发明人： CHEN-YU YEN ,  PEI-FEN HU ,  SHU-YUAN HU ,  KUN-TING CHIU

IPC分类号： G06F16/22 ,  G06F16/2453

摘要： A fast index creation system for a cloud big data database electrically and communicatively coupled to a cloud non-relational database for inquiring and creating an index includes an application exchange module, a data exchange module, a first processing module, a second processing module and an integrated processing module. The application exchange module receives a query string inputted by a user and prompts a result index table. The data exchange module has a temporary index table. The first processing module computes the query string and generates a query instruction to compute a temporary index table for comparison and check if there is any data matched with the query instruction. If yes, then the first processing module will generate a cache index table, or else the first module will generate a create instruction provided for the second processing module to compute a non-relational database and generate a new index table.

公开(公告)号：US09148404B2

公开(公告)日：2015-09-29

申请号：US14019547

申请日：2013-09-06

申请人： SYSCOM COMPUTER ENGINEERING CO.

发明人： Ching-Ju Chuang ,  Pei-Fen Hu ,  Shu-Yuan Hu ,  Kun-Ting Chiu

IPC分类号： G06F17/00 ,  H04L29/06 ,  H04L9/32 ,  H04L12/46

CPC分类号： H04L63/0218 ,  G06F17/3056 ,  H04L12/4641 ,  H04L63/02 ,  H04L63/0272 ,  H04L63/029 ,  H04L63/08 ,  H04L67/02 ,  H04L67/1002

摘要： Disclosed is a system for accessing data of a cloud database via transparent technology, and the system includes at least one channel server and at least one cloud database end. When a connection notice is outputted from an application end, the user channel unit detects a first server address and a first database address in a HTTP data format, and connects to a corresponding channel server via the HTTP tunnel to send a database request, so that the channel server can convert the first database address in the HTTP data format into a TCP/IP data format and then connect to a corresponding database end. Therefore, the application end can access data from the database behind the firewall via the Internet without modifying any program code.

摘要翻译： 公开了一种通过透明技术访问云数据库的数据的系统，并且系统包括至少一个信道服务器和至少一个云数据库端。 当从应用端输出连接通知时，用户信道单元以HTTP数据格式检测第一服务器地址和第一数据库地址，并且经由HTTP隧道连接到对应的信道服务器以发送数据库请求，使得 通道服务器可以将HTTP数据格式的第一个数据库地址转换为TCP / IP数据格式，然后连接到相应的数据库端。 因此，应用程序结束可以通过Internet从防火墙后面的数据库访问数据，而无需修改任何程序代码。