公开(公告)号：US5826076A

公开(公告)日：1998-10-20

申请号：US242167

申请日：1994-05-13

申请人： John Bradley ,  Frederick A. Hewett ,  Bruce D. Sinclair

发明人： John Bradley ,  Frederick A. Hewett ,  Bruce D. Sinclair

IPC分类号： G06F12/00 ,  G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30471 ,  Y10S707/99934

摘要： A method and apparatus that permits creation, reading and modification of 3GL application programs by SQL requests. A catalog is created by selecting source programs from 3GL application data for which file definitions are to be extracted, identifying specific files within the selected source programs to be processed, extracting appropriate schema from the selected files, and recording the appropriate schema in a catalog. Once the 3GL-specific data schema contained in the application source has been extracted and stored in the catalog, the relational database which is to be based upon the data represented by the 3GL schema is defined and stored in the system catalog so that tables in the relational database may be accessed by a runtime SQL database engine. Further, both 3GL data and relational database data may be modified and maintained with a single tool set. After the catalog is created, the invention uses the catalog to process SQL requests in order to access the relational database representation of the 3GL data by parsing the SQL query request, generating a set of possible execution plans for manipulating the relational form of the data, selecting an optimal plan based upon information provided from the system catalog, and executing the plan by servicing the SQL request for relational data from the underlying 3GL data files described in the system catalog.

摘要翻译： 允许通过SQL请求创建，阅读和修改3GL应用程序的方法和装置。 通过从要提取的文件定义的3GL应用程序数据中选择源程序，识别所选择的要处理的源程序中的特定文件，从所选文件中提取适当的模式，并在目录中记录适当的模式，创建目录。 一旦包含在应用程序源中的3GL特定数据模式被提取并存储在目录中，则将基于由3GL模式表示的数据的关系数据库定义并存储在系统目录中，以便在 关系数据库可能由运行时SQL数据库引擎访问。 此外，3GL数据和关系数据库数据可以用单个工具集修改和维护。 在创建目录之后，本发明使用目录来处理SQL请求，以通过解析SQL查询请求来访问3GL数据的关系数据库表示，生成用于操纵数据关系形式的一组可能的执行计划， 基于从系统目录提供的信息选择最佳计划，并通过从系统目录中描述的底层3GL数据文件服务关系数据的SQL请求来执行计划。

公开(公告)号：US5539765A

公开(公告)日：1996-07-23

申请号：US516016

申请日：1995-08-16

申请人： Wilson Sibbett ,  Bruce D. Sinclair ,  Neil MacKinnon

发明人： Wilson Sibbett ,  Bruce D. Sinclair ,  Neil MacKinnon

IPC分类号： H01S3/06 ,  H01S3/08 ,  H01S3/0941 ,  H01S3/109 ,  H01S3/16

CPC分类号： H01S3/0627 ,  H01S2302/00 ,  H01S3/0604 ,  H01S3/0615 ,  H01S3/08086 ,  H01S3/09415 ,  H01S3/109 ,  H01S3/1611 ,  H01S3/1673

摘要： A laser 10 comprises a pump source 11, a resonator 13 including an etalon of gain material 15, and means 12 to focus the pump source 11 output onto one end 14 of the resonator 13 as a spot having a diameter in the range 50-150 .mu.m. The resonator 13 includes substantially parallel end faces 14,19 having a relative taper better than 0.25 milliradians, and the end faces 14,19 are substantially free of scratches greater than 10 .mu.m in size and pits greater than 5 .mu.m in size. A thermally induced microlens 22 is formed at the surface 14 of the gain material 15.

摘要翻译： 激光器10包括泵浦源11，包括增益材料15的标准具的谐振器13以及将泵浦源11输出到谐振器13的一端14上的方式12，该直径为直径在50-150范围内的点 亩 谐振器13包括基本上平行的端面14,19，其具有优于0.25毫弧度的相对锥度，并且端面14,19基本上没有大于10微米的大小和大于5微米的凹痕。 在增益材料15的表面14处形成热诱导微透镜22。