Abstract: Enables a database generator interface configured to map complex constructs and semantics so internal complexities are hidden while providing efficient internal storage and speed. Extracts and analyzes complex relationships in database and exposes schema as XSD to allow for external interfacing. Presents a list of tables and fields that exist in database and accepts user input to determine which tables and fields to create an interface for. Lookup fields are listed which allow for user input for specifying which fields to create XSD enumeration lists for. The generated XSD file may be saved and utilized by other mapping tools to allow for interfacing with other databases. Mapping the schema of a extended SQL database allows for users with limited understanding of the internals of the extended SQL database to connect the database to other systems using commonly available tools. May be coupled with web services to provide universal access.

Abstract: Enables a database generator interface configured to map complex constructs and semantics so internal complexities are hidden while providing efficient internal storage and speed. Extracts and analyzes complex relationships in database and exposes schema as XSD to allow for external interfacing. Presents a list of tables and fields that exist in database and accepts user input to determine which tables and fields to create an interface for. Lookup fields are listed which allow for user input for specifying which fields to create XSD enumeration lists for. The generated XSD file may be saved and utilized by other mapping tools to allow for interfacing with other databases. Mapping the schema of a extended SQL database allows for users with limited understanding of the internals of the extended SQL database to connect the database to other systems using commonly available tools. May be coupled with web services to provide universal access.

Abstract: A system and method for relating unstructured data in portable document format to external structured data. A software component layered on top of an existing PDF document to bridge static information in the document to dynamic information in an external IT system. A PDF document may be parsed and “hotspotted” to provide clickable areas that allow for windows to show structured data without adding hyperlinks to the PDF document. Input information is used to provide descriptions of items of interest that are to be used as hotspots which are located in the document and optionally visually marked. The input information may be in the form of a general regular expression for example. Types of unstructured PDF files include manuals, brochures, etc. Types of structured data include material, business process, finance, or any other type of data including enterprise data. Dynamic data is thus obtained for a static PDF document.