Invention Grant
- Patent Title: System and method for controlling database access
- Patent Title (中): 用于控制数据库访问的系统和方法
-
Application No.: US11503620Application Date: 2006-08-14
-
Publication No.: US07676456B2Publication Date: 2010-03-09
- Inventor: Toshio Suganuma , Akira Koseki , Hideaki Komatsu
- Applicant: Toshio Suganuma , Akira Koseki , Hideaki Komatsu
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Shimokaji & Associates, P.C.
- Agent Richard M. Goldman
- Priority: JP2005-251594 20050831
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A system to controls access to a database, including: an acquiring section which acquires an access program including a plurality of database access instructions; a detecting section which detects a plurality of different tables in the database that are accessed by the plurality of access instructions; a join control section which executes a join instruction prior to the execution of the access instructions, the join instruction obtaining a result table from the database by combining the plurality of different tables detected; and a conversion control section which executes a conversion instruction prior to the execution of the plurality of access instructions, the conversion instruction extracting records from the result table for the access instructions and converting the records into the form of a structure accessible for the plurality of access instructions.
Public/Granted literature
- US20070050367A1 System and method for controlling database access Public/Granted day:2007-03-01
Information query