公开(公告)号：KR20070080564A

公开(公告)日：2007-08-10

申请号：KR20070011360

申请日：2007-02-05

Applicant: IBM

Inventor： OLIVIERI RICARDO N ,  WHELAN MARK B

IPC: G06F17/30 ,  G06F9/06 ,  G06F17/00

CPC classification number: G06F17/246

Abstract: A system, a method, and a medium for processing a spreadsheet to store the spreadsheet to a database are provided to process/store the spreadsheet to the database by automatically processing records of the spreadsheet and applying a conventional validation/business process logic. A request for processing the spreadsheet including a plurality of records to store the spreadsheet to the database is received(502). A configuration file related to the spreadsheet is generated by receiving more than one name of a business object related to the record of the spreadsheet, metadata for more than one column of the spreadsheet, and the name of a back-end business component related to the spreadsheet. The generated configuration file is accessed(508). A new business object is generated for each record of the spreadsheet, and is populated based on the records and the configuration file(514). Each new business object is transferred to a back-end business application(516).

Abstract translation: 提供用于处理电子表格以将电子表格存储到数据库的系统，方法和介质，用于通过自动处理电子表格的记录并应用常规的验证/业务流程逻辑来将该电子表格处理/存储到数据库。 接收用于处理包括多个记录以将该电子表格存储到数据库的电子表格的请求（502）。 通过接收与电子表格的记录相关的业务对象的多个名称，电子表格的多个列的元数据以及与该电子表格相关的后端业务组件的名称，生成与电子表格相关的配置文件 电子表格。 生成的配置文件被访问（508）。 为电子表格的每个记录生成一个新的业务对象，并根据记录和配置文件（514）进行填充。 每个新的业务对象被转移到后端业务应用程序（516）。

公开(公告)号：JP2005004754A

公开(公告)日：2005-01-06

申请号：JP2004167646

申请日：2004-06-04

Applicant: Internatl Business Mach Corp ,  インターナショナル・ビジネス・マシーンズ・コーポレーションInternational Business Maschines Corporation

Inventor： DORRANCE DANIEL MICHAEL ,  OLIVIERI RICARDO N

IPC: G06F12/00 ,  G06F9/46 ,  G06F11/07 ,  G06F17/30

CPC classification number: G06F17/30371 ,  G06F9/466 ,  G06F11/079 ,  Y10S707/99952 ,  Y10S707/99953

Abstract: PROBLEM TO BE SOLVED: To provide a device and a method for maintaining the integrity of data in a software environment.
SOLUTION: According to the present device and method, individual software resources associated with a transaction are identified, and the processing of these resources is started. When the processing of these resources is finished, their associated APIs return messages indicating either that the software resource committed or could not commit and a reason why the software resource could not commit. Based on this reason, appropriate error resolution and recovery operations are performed, and the transaction is resubmitted only to those software resources which could not commit. The software resources which already committed have their states maintained. By this method, the roll back of committed software resources is avoided.
COPYRIGHT: (C)2005,JPO&NCIPI

Abstract translation: 要解决的问题：提供一种用于在软件环境中维护数据的完整性的装置和方法。 解决方案：根据本装置和方法，识别与事务相关联的各个软件资源，并开始处理这些资源。 当这些资源的处理完成后，它们的相关API返回指示软件资源已提交或无法提交的消息以及软件资源无法提交的原因。 基于此原因，执行适当的错误解决和恢复操作，并且仅将事务重新提交给那些无法提交的软件资源。 已经承诺的软件资源已经维持了状态。 通过这种方法，避免了提交的软件资源的回滚。 版权所有（C）2005，JPO＆NCIPI

公开(公告)号：CA2577537A1

公开(公告)日：2007-08-07

申请号：CA2577537

申请日：2007-02-07

Applicant: IBM

Inventor： OLIVIERI RICARDO N ,  WHELAN MARK B

IPC: G06F17/30

Abstract: Generally speaking, systems, methods and media for processing a spreadsheet for storage in a database are disclosed. Embodiments may include a method for processing records of a spreadsheet by receiving a request to process a spreadsheet having a plurality of records for storage in a database. Embodiments may also include accessing a configuratio n file associated with the spreadsheet and, for each record of the spreadsheet, creating a new business object and populating the new business object based on the record and the configuration file associated with the spreadsheet. Embodiments may also include passing each new business obje ct to a back-end business component for processing. The configuration file may include a name of a business object associated with a record of the spreadsheet, metadata for one or more columns of the spreadsheet, and/or a name of a back-end business component associated with the spreadsheet.

公开(公告)号：GB2402769A

公开(公告)日：2004-12-15

申请号：GB0411739

申请日：2004-05-26

Applicant: IBM

Inventor： DORRANCE DANIEL M ,  OLIVIERI RICARDO N

IPC: G06F12/00 ,  G06F9/46 ,  G06F11/07 ,  G06F17/30 ,  G06F11/14

Abstract: An apparatus and method for maintaining integrity of data in a software environment are provided. The individual software resources associated with a transaction are identified and the processing of these resources is started. As the processing of these resources terminates, their associated APIs return messages indicating either that the software resource committed or was unable to commit and the reason why the software resource was unable to commit. Based on this reason, appropriate error resolution and recovery operations are performed and the transaction is resubmitted only to those software resources that were unable to commit. The software resources that already committed have their states maintained. In this way, roll back of committed software resources is avoided.

公开(公告)号：GB2402769B

公开(公告)日：2005-12-07

申请号：GB0411739

申请日：2004-05-26

Applicant: IBM

Inventor： DORRANCE DANIEL M ,  OLIVIERI RICARDO N

IPC: G06F12/00 ,  G06F9/46 ,  G06F11/07 ,  G06F17/30 ,  G06F11/14

Abstract: An apparatus and method for maintaining integrity of data in a software environment are provided. With the apparatus and method, the individual software resources associated with a transaction are identified and the processing of these resources is started. As the processing of these resources terminates, their associated APIs return messages indicating either that the software resource committed or was unable to commit and the reason why the software resource was unable to commit. Based on this reason, appropriate error resolution and recovery operations are performed and the transaction is resubmitted only to those software resources that were unable to commit. The software resources that already committed have their states maintained. In this way, roll back of committed software resources is avoided.