SERVER FOR CONNECTING JAVA APPLET WITH DATA BASES

INTEGRATED WORKFLOW AND DATABASE TRANSACTIONS

A computer-implemented method and system to integrate workflow and database transactions is provided. Also provided is a computer readable storage medium that includes a program. 5 The computer-implemented method includes assigning a data structure stored in a database to one or more workflow processes. The computer-implemented method also includes automatically creating an instance of the workflow in response to the data structure being populated with a new record. co S,' C.-, a ~WGISAS a)iC U) a U) e qj j -0 (n -0 CD~ cu Do coI z U) WGIUA U)U o Ocoo (c:) L E- L) ...

Content item-centric conversation aggregation in shared folder backed integrated workspaces

Disclosed are systems, methods, and non-transitory computer-readable storage media for shared folder backed integrated workspaces. In some implementations, a content management system can provide a graphical user interface (GUI) that integrates communications and content management into a single user interface. The user interface can include mechanisms that allow a user to provide input to generate a new workspace. The user interface can provide a mechanism to allow a user to view conversations related to the workspace and/or content items associated with the workspace. The user interface can present representations of content items associated with the workspace and allow the user to provide input to generate, view, edit, and share content items associated with the workspace.

A CO-PRESENCE DATA RETRIEVAL SYSTEM WHICH INDICATES OBSERVERS OF DATA

A data retrieval system (12) has a data server (10), a co-presence server (22) and at least one awareness co-presence client. The data server (12) retrieves at least one data object from among a plurality of data objects stored in a data repository. The co-presence server (22) opens communication (52B) and observation channels (52A) associated with at least one of the data objects. The awareness co-presence clients communicate with the co-presence server (22) and define an awareness state of the client. The co-presence server (22) opens a communication channel (52B) or an observation channel (52A) with each client depending on the awareness state of each client per retrieved data object. For observation channels, the co-presence server (22) indicates to each client which other clients have retrieved the same data object. The co-presence server (22) opens a communication channel (52B) associated with a retrieved data object to those clients which retrieved the data object and which are in ...

SYSTEM AND METHOD OF DATA BROKERING

A data brokering system and method for programming is provided. The data brokering system comprises a process module for executing process logic, a panel module for accessing external information, and a process-panel interface for defining a standard of communication between the process module and the panel module. The panel module communicates with the process module and the external information. The method comprises the steps of executing process logic, having the process logic communicating with a panel module to access external information, and defining a standard of communication between the process logic and the panel module.

A CO-PRESENCE DATA RETRIEVAL SYSTEM WHICH INDICATES OBSERVERS OF DATA

A data retrieval system (12) has a data server (10), a co-presence server (22) and at least one awareness co-presence client. The data server (12) retrieves at least one data object from among a plurality of data objects stored in a data repository. The co-presence server (22) opens communication (52B) and observation channels (52A) associated with at least one of the data objects. The awareness co-presence clients communicate with the co-presence server (22) and define an awareness state of the client. The co-presence server (22) opens a communication channel (52B) or an observation channel (52A) with each client depending on the awareness state of each client per retrieved data object. For observation channels, the co-presence server (22) indicates to each client which other clients have retrieved the same data object. The co-presence server (22) opens a communication channel (52B) associated with a retrieved data object to those clients which retrieved the data object and which are in ...

METHOD AND MEANS FOR ENCODING STORING AND RETRIEVING HIERARCHICAL DATA PROCESSING INFORMATION FOR A COMPUTER SYSTEM

METHOD AND MEANS FOR ENCODING STORING AND RETRIEVING HIERARCHICAL DATA PROCESSING INFORMATION FOR A COMPUTER SYSTEM

Electronic masking - and marking engine for masking and unique signing of database content and - source code.

Vorgeschlagen wird eine elektronische Maskierungs- und Kennzeichnungsengine zur Maskierung und eindeutigeN Signierung von Datenbankinhalten und Datenbank-Quellcode, wobei ein Datenbank-Quellcode SQL-Code und PL-SQL-Code als Host-Sprache umfasst. Die SQL-Kommandos werden an entsprechenden Stellen in den Quellcode eingebunden, entweder durch Prozeduraufrufe oder als Klartext-Befehle, die von einem Precompiler in Prozeduraufrufe der Host-Sprache übersetzt werden. Mittels eines Ladeprozesses liest die Maskierungs- und Kennzeichnungsengine Klartext-Schlüsselwörter aus dem Source-Code aus und erzeugt dynamisch, in Realtime ein verschlüsseltes Keyword nach den PL/SQL-Regeln. Mittels der Maskierungs- und Kennzeichnungsengine wird das Klartext-Schlüsselwort mit dem encrypted Schlüsselwort substituiert und der gesamte, maskierte PL/SQL-Source-Code stückweise in eine relationale Tabelle abgespeichert, wobei die encrypted Schlüsselwörter von der Oracle PL/SQL Engine korrekt interpretierbar sind.

Electronic masking - and marking engine for masking and unique signing of database content and - source code.

Vorgeschlagen wird eine elektronische Maskierungs- und Kennzeichnungsengine zur Maskierung und eindeutigen Signierung von Datenbankinhalten und Datenbank-Quellcodes, wobei ein Datenbank-Quellcode SQL-Code und PL-SQL-Code als Host-Sprache umfasst. Die SQL-Kommandos werden an entsprechenden Stellen in den Quellcode eingebunden, entweder durch Prozeduraufrufe oder als Klartext-Befehle, die von einem Precompiler in Prozeduraufrufe der Host-Sprache übersetzt werden. Mittels eines Ladeprozesses liest die Maskierungs- und Kennzeichnungsengine Klartext-Schlüsselwörter aus dem Source-Code aus und erzeugt dynamisch, in Realtime ein verschlüsseltes Keyword nach den PL/SQL-Regeln. Mittels der Maskierungs- und Kennzeichnungsengine wird das Klartext-Schlüsselwort mit dem encrypted Schlüsselwort substituiert und der gesamte, maskierte PL/SQL-Source-Code stückweise in eine relationale Tabelle abgespeichert, wobei die encrypted Schlüsselwörter von der Oracle PL/SQL Engine korrekt interpretierbar sind.

Dynamic data binding for mobile business objects

Systems, methods and computer program products for dynamically binding data from a remote data source in a container-based mobile application are described herein. The method includes the steps of: 1) defining a metadata source that references both a mobile business object (MBO) and the mobile application, the MBO being connected to the remote data store; 2) binding an attribute from the MBO to the mobile application using the metadata source; and 3) changing, dynamically, the binding of the attribute while the mobile application is executing.

이벤트 리뷰들을 획득하는 방법 및 시스템

... 실시예들은 일반적으로 이벤트 리뷰들을 획득하는 것에 관련된다. 한 실시예에서 방법은 디바이스의 위치에 대응하는 위치 데이터를 수신하는 단계 및 디바이스가 상기 위치에 있었던 시간에 대응하는 시간적 데이터를 수신하는 단계를 포함한다. 또한 방법은 상기 위치 데이터 및 상기 시간적 데이터에 기초하여 이벤트 정보를 획득하는 단계 및 이벤트 정보와 관련된 이벤트의 리뷰들을 행할 수 있도록 디바이스에 사용자 인터페이스를 생성하는 단계를 포함한다. 또한 방법은 상기 위치 데이터 및 상기 시간적 데이터에 기초하여 하나 이상의 프롬프트들을 생성하는 단계를 포함한다.

플레이스홀더 및 콘텐츠 스트리밍 기법

... 본 명세서에 기술된 발명대상은 파일 시스템 플레이스홀더(placeholder)에 관한 것이다. 어떤 면에서, 플레이스홀더는 원격 파일 시스템 객체를 나타내기 위해 클라이언트에 의해 사용될 수 있다. 플레이스홀더는 메타데이터를 포함할 수 있으며, 또한 표현된 원격 파일 시스템 객체의 콘텐츠 전부 또는 일부를 포함할 수도 있고 하나도 포함하지 않을 수도 있다. 플레이스홀더에 의해 표현된 파일 시스템 객체의 콘텐츠에 대한 액세스 요청에 응답하여, 클라이언트는 원격 저장 시스템으로부터 필요한 데이터를 획득할 수 있으며, 요청 애플리케이션이 데이터를 스트리밍할 수 있는지 여부에 기초하여 데이터를 그 요청 애플리케이션에 스트리밍하거나 스트리밍하지 않을 수 있다.

METHOD AND SYSTEM FOR CACHE TIERING

METHOD AND APPARATUS FOR PROVIDING MULTILINGUAL INFORMATION

The present invention provides the ability to internationalize a database application by providing a capability to create and maintain related international records. Data items can be stored in a base language with accompanying related copies of the data items represented in multiple languages and/or currencies. Application users can specify a preferred language. When data items are retrieved from a database, and when the user's language preference is not the same as the base language, language-dependent data items are retrieved from the related language records. When a related language record does not exist, or the preferred language is equal to the base language, the data items are retrieved from the base language records. Delete, Insert and Update operations can be performed on base language records, related language records or both.

METHODS AND APPARATUSES TO CANCEL QUERY

Methods and apparatuses to cancel database (140) queries from a web application (307) user interface in a networked (301) database application. In one embodiment, the method includes receiving a user request to cancel a query previously sent to a database and calling an application programming interface (API) provided by the database to terminate one or more statements running on the database, the one or more statements being related to the query.

INTERFACES FOR A PRODUCTIVITY SUITE APPLICATION AND A HOSTED USER INTERFACE

User interfaces are defined by metadata for use with productivity suite applications in a wrapped window, a task pain, or some other suitable representation. Data can be bound to a data source in a one-way format such that changes from the data source propagate to property fields in the UI form. Data can also be bound to a data source in a two-way format such that changes from the property field of the UI propagate back to the data source. The data source can be a local cache such as for synchronization between a productivity suite application and a line of business application (e.g., CRM applications). A rendering engine is arranged to process the UI and data bindings such that custom event handlers are defined in a code behind assembly format. Productivity suite items are accessible from the code behind assembly through a series of item interfaces.

APPLICATION INTEGRATION SYSTEMS AND METHODS

Systems and methods are disclosed for integrating applications that use different message formats. In one embodiment, the method comprises receiving, at an application integrator, a message in a first format from a first application. A message type for the message is determined and metadata associated with the message type is retrieved. The metadata includes at least one mapping associating a data element in the first format to a data element in a second format. The method further comprises using the metadata to adapt the message in the first format to a message in the second format and transmitting the message in the second format to a second application. The method further comprises optimization algorithms and meta-data storage designed to perform transformations at a very high speed with minimal impact to overall message performance.

PROCESS FOR THE CONSULTATION AND UPDATING OF SPECIALIZED DATA AND SYSTEM FOR PUTTING INTO EFFECT SAID PROCESS

Process for the consultation and updating of changing specialized data for a given group of persons, in which each person uses processing means (11) associated with transmission means (16) in order to access a specialized videotex server (12), through a switched telephone network (10) , and in which data is automatically updated as soon as the processing means (11)/server (12) connection is established. The invention also concerns a system for putting into effect this process. Application especially in aeronautics, legal and accounting practices and medicine for the remote support and follow-up of patients.

Performance mechanism for presenting integrated information in a graphical user interface

The invention relates to methods and apparatus for improving the performance of an integrated Graphical User Interface (GUI) client that presents an integrated view of model information originating from distributed information sources. Performance is enhanced by mapping the integrated GUI display components to replicated model information stored locally on the integrated GUI client. Replicated model information is maintained using information updates pushed from remote information sources to the integrated GUI client based upon a set of demand information mapping rules created based on the client's demand request. The load placed on the network to support an integrated display is distributed over time, thereby reducing spikes in network traffic associated with conventional integrated GUI approaches. Integrated GUI performance is improved regardless of the number of information sources, regardless of the number of queries to remote information sources, and regardless of network/processor ...

Method and process of query optimization to a given environment via specific abstraction layer domain knowledge

Methods and apparatus for optimizing an abstract query are disclosed. Embodiments of the present invention allow an abstract database to optimize an abstract query composed from a set of logical fields. Each logical field includes a field name and an access method used to map the logical field to an underlying physical representation of the data. After a user composes an abstract query and submits it for execution, a runtime component and optimization component may be configured to resolve the abstract query to a physical query of the underlying physical data source using an access method associated with each logical field. In addition, as the runtime component builds a query consistent with the schema of the underlying database, an optimizing component may modify the query using any suitable optimization techniques. Different optimization techniques include optimizations based on logical field metadata, optimizations based on the underlying physical data repositories referenced by an access ...

System and method for managing user data in a plurality of databases

A system and method for integrating data from a source application to a target application includes an interface module incorporating a publisher for publishing extracted data in an XML message and a subscriber for uncompressing the XML message. The method includes the steps of publishing an XML message of user data from the source application; receiving, decoding and uncompressing the XML message; and transforming the XML message into a workflow request for integrating the source data to the target application.

Database management system

A database for use by a plurality of user groups, the database including: designation means for designating data into one of the following sets, a general set for data of potential general applicability to all user groups, the data within the general set being customizable only by one or more system administrators, and a specific set for each individual user group for data of potential applicability to only that user group, the data within the specific set being customizable only by the user group, whereby the information as presented to any selected user group is the result of aggregation of the data from the general set and the specific set for the selected group. Preferably the sets into which the designation means is capable of designating data further includes one or more intermediate sets for data of potential applicability to one or more sub-sets of user groups respectively.

Service desk data transfer interface

A system and method for managing data transfer operations includes at least one data server including data stored in a plurality of data fields, at least one transaction server operatively coupled to the at least one data server and configured to provide at least one customizable business rule and a customer relationship application, an information server operatively coupled to the at least one transaction server, and at least one workstation operatively coupled to the information server. The least one workstation includes local memory accessible to the customer relationship application and configured to provide web communication and presentation services to a user of the at least one workstation that are deployed on the information server. The at least one customizable business rule specifies a mapping between the plurality of data fields and the local memory, the mapping having been provided by the user interacting with the web communication and presentation services.

Big Data Analytical Platform Tools And Methods Of Use

Methods and systems for extraction, transformation, and loading of source data into an integrated extract-transform-load (ETL) data warehouse analytical platform to map source data from at least one data source column as mapped source data to at least one Input Layout (IL) column of a selected IL table of a plurality of IL tables associated with a Data Layout (DL) table of a plurality of DL tables associated with a named standard package or to a custom target table associated with a named custom package to permit a real-time display on a graphical user interface (GUI) of one or more key performance indicators associated with each DL table.

FORMAT MANAGEMENT FOR A CONTENT REPOSITORY

A computing system performs file conversion upon format expiration. A computing system evaluates a risk of expiration of a first format associated with a first format object. The computing system determines if the risk of expiration is above a threshold. The computing system identifies in response to determining the risk of expiration is above the threshold, one or more files stored in the first format for conversion. The computing system converts one or more files stored in the first format to a second format. The computing system saves the one or more files in the second format.

QUERY TEMPLATE DEFINITION AND TRANSFORMATION

Apparatus and method for flexible data base access

PROCEDURE FOR THE DATA ADMINSTRATION

Shared folder backed integrated workspaces

Disclosed are systems, methods, and non-transitory computer-readable storage media for shared folder backed integrated workspaces. In some implementations, a content management system can provide a graphical user interface (GUI) that integrates communications and content management into a single user interface. The user interface can include mechanisms that allow a user to provide input to generate a new workspace. The user interface can provide a mechanism to allow a user to view conversations related to the workspace and/or content items associated with the workspace. The user interface can present representations of content items associated with the workspace and allow the user to provide input to generate, view, edit, and share content items associated with the workspace.

METHOD AND APPARATUS FOR SUPPORTING DYNAMIC RUN-TIME OBJECT DEFINITION IN A RELATIONAL DATABASE MANAGEMENT SYSTEM

... ▓▓▓A method and system for providing dynamic run-time object definition in a ▓relational database. A mediating layer is introduced between applications ▓(100) and database objects. This layer mediates access to the physical ▓database objects, such as tables (1500), and allows applications to embed ▓logical instead of physical names. If desired, the mediating layer can be ▓maintained dynamically, as applications are running. The mediating layer ▓preferably can run on a variety of relational databases, overcoming the vendor-▓specific extensions to SQL that relational databases vendors have introduced.▓ ...

DIGITAL CONSUMER DATA MODEL AND CUSTOMER ANALYTIC RECORD

As a company expands its businesses to include digital products and services in addition to more traditional telecommunications and media offerings, digital consumption data may be used along with telecommunications consumption data and other customer-centric information in order to create a more comprehensive data model and make better predictions. A customer-centric data model identifies entities with data from diverse locations and product sectors associated with a single customer. Customer analytic records aggregate existing data into base variables and store it for each customer along with additional variables generated by performing calculations on exiting data. Both the data model and the customer analytic records can be used by the company to make more accurate business and marketing decisions.

SYSTEM AND METHOD FOR CREATING INTERFACE DATA BASE

System for exposing definition of process of sequence of operations as commercial object within organizations, has processor creating business object based on process of sequence of operations, where object has data from sources in formats

La présente invention propose des procédés et des appareils d'exposition de définition de procédés de flux de travail en tant qu'objet commercial. En utilisant les procédés et l'appareil présenté ici, les utilisateurs peuvent accéder à un objet commercial qui représente une définition de procédé de flux de travail provenant d'un système quelconque utilisant des constructions de base de données standard. Les données de l'objet commercial peuvent être combinées à partir d'une variété de sources existantes et/ou de nouvelles données. En utilisant ces procédés et cet appareil, un utilisateur peut générer des rapports à partir de l'objet commercial.

SYSTEM Of INTERFACE Of ACCESS TO the DATA Of a Database

Ce système d'interface d'accès aux données d'une base de données stockée dans des moyens (1) de stockage correspondants, comportant au moins une zone (2) de stockage des données proprement dites et une zone (3) de stockage d'un dictionnaire de données de définition structurelle de cette base de données, la base de données étant accessible à travers des moyens formant interface d'accès (4), est caractérisé en ce que les moyens (4) formant interface d'accès sont associés à un dictionnaire (5) de descripteurs de définition d'interface, accessible à travers des moyens (7, 8) de modification de son contenu pour permettre une programmation de la configuration des moyens formant interface par création, suppression ou modification de descripteurs dans le dictionnaire (5) de descripteurs de définition d'interface et en ce qu'il est prévu des moyens (6) d'actualisation automatique du dictionnaire (3) de données de définition structurelle de la base de données pour adapter celle-ci à la configuration ...

CORRESPONDING SYSTEM OF PUBLICATION MULTITERMINAL AND PROCEEDED OF IMPLEMENTATION

L'invention concerne un système de publication multi - terminal, du type offrant un accès à au moins une application correspondant à un service, permettant de fournir à une pluralité de terminaux, selon au moins deux types de terminal distincts, des informations contenues dans au moins une source d'informations. Selon l'invention, un tel système comprend : - au moins un module (30, 301, 302, 303) de création d'objets à partir de données brutes; - un module (31) de génération de réponse sous un format de présentation générique, en réponse à une requête (51) formulée par un terminal et relative à une application donnée; - un module (32) de présentation, permettant de transformer ladite réponse sous un format de présentation générique en une réponse sous un format de présentation spécifique au type dudit terminal ayant formulé ladite requête.

METHOD FOR UPDATING A RECORD IN A DATABASE BY A DATA PROCESSING DEVICE

Procédé de mise à jour d'un enregistrement dans une base de données par un dispositif de traitement de données configuré pour la mise en œuvre d'une application de traitement d'enregistrements, l'enregistrement ayant une structure comportant une pluralité de champs prédéterminée dans la base de données, l'enregistrement étant accédé par l'application via une modélisation selon un langage objet dans lequel la structure d'un enregistrement est modélisé par une classe, chaque champs de l'enregistrement correspond à une méthode de la classe, caractérisé en ce que le procédé comporte les étapes suivantes pour chaque méthode : - Analyse 2030 de la déclaration de la méthode telle que connue au lancement de l'application pour trouver au moins une annotation prédéterminée ; - Si l'annotation prédéterminée est trouvée, alors analyse des paramètres de l'annotation pour produire 2040 un contrôle de saisie ; - Utilisation 2050 du contrôle produit pour la création d'une interface homme machine permettant ...

DATA PROFILING

DISPOSITION OF INTERFACE HUMANO-COMPUTADORA AND METHOD TO PROVIDE INTELLIGENCE IN REAL TIME BY MEANS OF THE DISPOSITION

Una disposicion de interfaz humano-computadora y método para proporcionar inteligencia en tiempo real por medio de la disposicion, para proporcionarinteligencia en tiempo real con contexto en relacion con senales de entrada reconocidas enforma automática. La disposicion proporciona el monitoreo entiempo real de los ingresos del operador y/o usuario, que brinda soporte inteligente en forma de salidas de texto, datos presentados electronicamente,informacion y habla.

QUERY TEMPLATE DEFINITION AND TRANSFORMATION

A database query template and metadata mapping provide an end-user to generate customized database reports via a user interface. The parameters and data available to the end-user can be modified by editing the database query template and metadata mapping without modifications of the underlying system. A database query template includes query language keywords, variables, and template-tokens and defines the metrics, dimensions, data comparisons, filters, and aggregations available to an end-user. Template tokens include restriction tokens for comparing and filtering data, options-section-tokens for defining and omitting sections of the query template, and descriptor tokens for identifying dimensions and metrics of the database. The database query template is transformed into a database query based on values input by a user. The metadata mapping associates the variables of the database query template to the database data model and can include data constraints for validation of user input.

SYSTEM AND METHOD FOR BUILDING MULTIPLE ONLINE LEGAL RESEARCH APPLICATIONS

The present inventors devised, among other things, an application development system and method. One exemplary method entails providing a set of legal research application feature or functions and receiving a first configuration file from a user, selectively enabling or disabling one or more of the features to define a first legal research application on a first server for a first country. The method further entails receiving a second configuration file from a user, which similarly selectively enables or disables one or more of the features to define a second legal research application on a second server for a second country. The configuration files also customize the user interfaces accord to brand specific criteria for each of the countries.

SOFTWARE, METHOD AND SYSTEM FOR DATA CONNECTIVITY AND INTEGRATION HAVING TRANSFORMATION AND EXCHANGE INFRASTRUCTURE

Software, methods, and system for data connectivity and integration having a transformation and exchange gateway are provided. The transformation and exchange gateway software is stored in a memory and has a mapper to map connection data path instructions, a plurality of inbound templates each to provide inbound data processing instructions for an inbound data set having an inbound data interchange protocol, at least one outbound template to provide outbound data processing instructions for an outbound data set having an outbound data interchange protocol different from the inbound data interchange protocol, and a data transformation and exchange engine in communication with the mapper to locate a data path and determine a select one of the plurality of inbound templates to use for inbound data processing instructions, in communication with the select one of the plurality of inbound templates to process the inbound data set responsive to the inbound data processing instructions of the select ...

METHOD FOR DISTRIBUTED TRANSACTION SUPPORT USING JDBC 1.0 DRIVERS

La présente invention concerne un procédé se rapportant à la réalisation d'une fonctionnalité de mise en oeuvre distribuée de transactions avec utilisation des pilotes JDBC 1.0. Au lieu de créer une nouvelle connexion base de données physique pour chaque demande de connexion, on utilise un pilote d'interface qui tient à jour en interne une table de correspondances entre un identifiant global de transaction et la connexion base de données. Même si une application demande plusieurs connexions avec la même base de données pour la même transaction, la totalité de l'accès base de données via ces connexions est redirigée sur la connexion base de données physique telle qu'elle a été tenue à jour dans la table. Cela permet de coordonner la totalité du travail sous la même transaction. L'invention permet ainsi d'utiliser les pilotes JDBC 1.0 standards pour réaliser une compatibilité limitée avec le pilote de l'extension standard JDBC 2.0.

AN E-BUSINESS MOBILITY PLATFORM

A platform (1) allows end users to engage in a session with servers such as content providers, corporate systems, commercial services or ASPs. A session object is associated with each session, attributes of which includes the channel - thereby allowing changing of a channel during a session. Request/event objects are associated with the session object as request/notification arise, and these objects are shared with other modules. Hosted services may be physically resident on the platform or may be accessed transparently via interfaces. A device/channel neutral mark-up language extended from a presentation mark-up language is used as a single common form from which the delivered content is derived. The content form a service is generated by an executable process, normally (but not exclusively) in the extended mark-up language. The derivation of deliverable content is performed via a dynamic and configurable sequence of providers that manipulate the original content in stages.

Systems and methods for generating a user interface

Systems and methods for generating a user interface are described. In one described system, an aspect associated with an article is identified. Next, an insert comprising a search result is generated based, at least in part, on the aspect. The insert is then caused to be output in association with the aspect.

DYNAMIC OPTIMIZATION OF PREPARED STATEMENTS IN A STATEMENT POOL

An apparatus, program product and method dynamically optimize prepared statements resident in a statement pool to permit subsequent reuses of such statements to utilize the optimized representations of such statements. The optimization of pooled statements may be performed responsive to the tracked usage of the statements in a statement pool, to direct the overhead associated with such optimization to those statements that are more likely to be utilized in the future. Among a multitude of possible optimizations, a pooled statement that requests data in a format other than that utilized by the database being accessed may be modified to request the data in the format used by the database, thereby decreasing the overhead in the database associated with format conversions.

System and method for a Web service definition

Embodiments of the invention are generally directed to a system and method for a Web service definition. A development environment may receive input selecting a Web service interface. The development environment may also receive input to specify one or more system independent features of the selected interface. In an embodiment, the development environment may create a Web service definition descriptor file that includes the received input specifying the one or more system independent features.

Enterprise server version migration through identity preservation

Systems and methods are described for service availability that provides automated recovery of server service in a timely and application intelligent manner, maintaining application consistency and integrity, while preserving server identity. The systems and methods, referred to herein as a Service Preservation System (SPS), manage complete recovery of server data and preserve continuity of server service, reestablishing user access to server(s) after an event or disaster in which in which primary or other server(s) fail. The failures, disasters, and losses referred to herein can be at many levels and include, but are not limited to, accidental deletion of an item, loss of an entire mailbox, loss of an entire disk drive, loss of an entire server, and/or loss of an entire server site.

Templates in a schema editor

A schema editor allows for definition, distribution, and use of schema templates. The schema editor allows schema to be edited and then saved in such a way that the saved file can be reimported into the schema editor.

Transient data facility for database applications

In one embodiment, a method for providing a transient data facility for database applications includes creating a definition of transient data that corresponds to a unit of work to be performed by an application, and mapping the definition of transient data to a temporary storage table. The method further includes storing the transient data in the temporary storage table while the application performs the unit of work spanning one or more user sessions, and deleting the transient data after the application completes the unit of work.

System and method for providing access to an application through a common interface for application extensions

A method and system to permit externally created business objects to access a business management application database without using direct database language statements. An add-on framework includes an add-on extension manager to start an add-on application, register a form from the add-on application, and receive and route an event from the business management application to the add-on application through a user interface application programming interface component object model interface. A persistency layer provides a set of programming language classes and interface definitions to develop a persistent business object in the add-on extension, and connect the persistent business object to a database through a data interface application programming interface component object model interface to read and write data from the database associated with the business management application.

DATABASE SYSTEM WITH QUERY INTERCEPTION AND REDIRECTION

TO ACCESS PROCEDURE AND SYSTEM OVER DATA

SYSTEM AND PROCEDURE FOR A GENERAL INTEGRATION OF A DATA BASE INTO A HIGH AVAILABILITY CLUSTER

Content item-centric conversation aggregation in shared folder backed integrated workspaces

Disclosed are systems, methods, and non-transitory computer-readable storage media for shared folder backed integrated workspaces. In some implementations, a content management system can provide a graphical user interface (GUI) that integrates communications and content management into a single user interface. The user interface can include mechanisms that allow a user to provide input to generate a new workspace. The user interface can provide a mechanism to allow a user to view conversations related to the workspace and/or content items associated with the workspace. The user interface can present representations of content items associated with the workspace and allow the user to provide input to generate, view, edit, and share content items associated with the workspace.

Content item-centric conversation aggregation in shared folder backed integrated workspaces

APPARATUS AND SYSTEM FOR AN ADAPTIVE DATA MANAGEMENT ARCHITECTURE

The present invention provides an apparatus, computer program and system for managing data. The computer program has at least one code segment to control system data stored in a first database (112) and client data stored in a second database (114) and several code segments that define a first set of objects linked to the first database (112), a second set of objects linked to the second database (114), and one or more minions (128). In addition, there are code segments to manage a job queue and one or more agent processes. There is also a code segment to provide an interface between a user and the code segment to manage the job queue.

METHOD, COMPUTER PROGRAM PRODUCT AND COMPUTER SYSTEM FOR A SINGLE DATABASE SYSTEM TO SUPPORT MULTIPLE APPLICATION SYSTEMS

Multiple application systems use a single database system. At least a first application system (901) and a second application system (902) run application services for application system users. The database system (900) has at least a first memory portion (920-1) and a second memory portion (920-2). The memory portions are disjunctive. The database system (900) stores a first assignment of a first predetermined profile (110) to the first memory portion (920-1) and a second assignment of a second predetermined profile (111) to the second memory portion (920-2). The first and second profiles (110,111) are unique and refer to the first and second application systems (901, 902), respectively. The first application system (901) and the second application system (902) access the first memory portion (920-1) and the second memory portion (920-2), through the respective profiles (110, 111).

KEY-VALUE REPOSITORY WITH A PLUGGABLE ARCHITECTURE

A system and techniques are described for managing key-value pairs using an architecture that does not restrict its users to any specific platform or storage subsystem. According to one aspect of the invention, the repository is portable in that the architecture need not change based on the environment and platform in which the repository is used. Rather, the portion of the architecture that is platform-specific is limited to plug-ins at a storage abstraction layer of the repository. The plug-ins expose the same storage abstraction interface to the other layers of the repository, but are implemented to interact with different platforms and storage subsystems. Consequently, in response to being ported from one platform to another, the repository may simply change the plug-in to invoke for persistent storage operations.

APPARATUS AND METHOD FOR FLEXIBLE DATA BASE ACCESS

... 72674-2 In order to access a data base system, a system user establishes communication with an interface unit associated with the data base system by means of telephone apparatus. Upon being connected with the data base system, the user is presented with a predetermined verbal message produced by a digitizing speech unit responding to preestablished logic signal sequences. In response to this message, the user can select from a plurality of verbally presented options by an appropriate activity, such as depressing the appropriate key on the dialing apparatus of a touch-tone telephone apparatus. By providing a verbal response from the interface unit that is determined by the user response to presented options, the system user can communicate with the interface unit, the verbal responses from the interface unit representing an abbreviated menu for the system user. As a result of this communication, a system user can interrogate and retrieve data from a data base without data processing apparatus ...

INTERFACE SYSTEM FOR ACCESSING DATA IN A DATABASE

Ce système d'interface d'accès aux données d'une base de données stockée dans des moyens (1) de stockage correspondants, comportant au moins une zone (2) de stockage des données proprement dites et une zone (3) de stockage d'un dictionnaire de données de définition structurelle de cette base de données, la base de données étant accessible à travers des moyens formant interface d'accès (4), est caractérisé en ce que les moyens (4) formant interface d'accès sont associés à un dictionnaire (5) de descripteurs de définition d'interface, accessible à travers des moyens (7, 8) de modification de son contenu pour permettre une programmation de la configuration des moyens formant interface par création, suppression ou modification de descripteurs dans le dictionnaire (5) de descripteurs de définition d'interface et en ce qu'il est prévu des moyens (6) d'actualisation automatique du dictionnaire (3) de données de définition structurelle de la base de données pour adapter celle- ci à la configuration ...

ADAPTIVE DATA ARCHITECTURE

Data Architecture is the common building block for any relational database application. Primarily, in most data centric applications, the database specialist would describe, based upon the given business rules and by the knowledge obtained about the application, the architecture of the database tables and their relationships (the number of fields and their interconnections). Given that the selected data architecture can determine the success or failure of an application, it is required that all of the business requirements are complete before the design of tables, fields and their interconnectedness ("The Data Architecture's can commence. A major disadvantage posed by this process is that there are limitations to the future growth of business requirements; this is due to the raggedness imposed by the fixed Data Architecture. The Adaptive Data Architecture (EVOLUTION) technology, proposed by SYGENICS Corporation, provides a solution that triumphs over the limitations posed by the fixed Data ...

METHOD AND SYSTEM FOR ENTERPRISE DATA ACCESS, ANNOTATION AND SHARING

Methods and/or systems allowing flexible, cross-platform data access in enterprise environments and from a variety of different information sources using a convenient interface uses multiple and/or parallel examination of a number of data sources through a client process and return of multiple results that can be modified, cross-referenced or annotated by a user.

ON-LINE DIRECTORY SERVICE

A directory service has a number of databases and a processing system with a number of processors. A first processor receives requests and passes them to one of a number of other processors to access one of the databases. The service has a firewall and a monitor outside the firewall for randomly generating names to access the database. A configuration manager communicates with applications in the database and processors and with a directory to cause applications to reconfigure in response to certain events.

Communication system

A method of updating a data record stored in a data store with information supplied by at least one of a plurality of users of a communication network, said data record comprising a first type of information and a second type of information; each of said users having an associated communication identifier identifying an endpoint in the communication network for receiving a communication event, said method comprising; storing a communication identifier in association with the data record; providing information to update the data record from a user together with a communication identifier associated with the user providing the information; comparing the identifier stored in association with the data record to the communication identifier associated with the user providing the information; ;wherein if the information is the first type of information, the data record is updated with the information only if the identifier associated with the user providing the information is the same as the ...

STORAGE AND RETRIEVAL SYSTEM OF A DATABASE

L'invention concerne un système (2) de stockage et d'interrogation d'une base de données de marques (6), comprenant : -une base de données (6) incluant des informations pour un ensemble de marques (16), les informations relatives à chacune des marques étant associées à des champs respectifs; -une interface d'interrogation invitant l'utilisateur à définir plusieurs critères de filtrage, invitant l'utilisateur à définir pour chaque critère de filtrage au moins un champ de la base de données et une valeur identifiée pour ce champ, affichant l'ensemble des champs de la base de données et requérant la sélection d'un de ces champs pour la définition du champ de chaque critère de filtrage, invitant en outre l'utilisateur à sélectionner des opérateurs logiques entre les différents critères définis par l'utilisateur, invitant l'utilisateur à valider ses critères de filtrage et l'interface renvoyant une liste de marques satisfaisant les critères de filtrage validés.

AUTOMATIC INTEGRATION DATA RELATING TO A MAINTENANCE OPERATION

L'invention propose d'automatiser l'extraction et la consolidation de données de maintenance et concerne un procédé et un système d'intégration automatique de données parmi une pluralité de données de maintenance, ladite pluralité de données de maintenance étant diffusée à travers un ensemble d'éléments documentaires (E1-En) de maintenance comprenant un ensemble de liens orientés (Al-Am), ledit système comportant des moyens de traitement (3) configurés pour extraire selon des règles d'extraction (R1-Rs) prédéterminées un sous-ensemble de liens pertinents (A1-A3) et pour intégrer dans un élément résultant (5), des données de maintenance pertinentes provenant d'un sous-ensemble d'éléments documentaires (E1-E4) pertinents associé audit sous-ensemble de liens pertinents.

GENERATING RELATIONAL STRUCTURE FOR NON-RELATIONAL MESSAGES

A messaging server (112) provides a message store (116) for storing messages in a relational manner. A set of related messages, such as an email string between two or more people, is represented as a message container (200) having relational references to one or more submessages (210, 212, 214). The messaging server (112) processes non-relational messages sent by the server by inserting (516) tags that uniquely identify components within the message. The messaging server (112) also processes tagged or untagged non-relational messages received by the server to create (616, 618) relational counterparts in the message store (116). Relational searches can be executed on the messages in the message store (116) to perform audits or forensic analyses of the messages.

METHODS AND APPARATUS FOR ENTERPRISE APPLICATION INTEGRATION

A method for enterprise application integration that uses "connectors" (108a,108b,108c) that can be instantiated via downloading (e.g., using Java or other such technologies) to provide interfaces to respective disparate database systems (140). The databases systems may comprise any variety of now or heretofore known systems, e.g. SAP, Oracle, and so forth. The connectors can, for example, translate between a native language (or API) of the respective database systems and an internal language/protocol of the enterprise application integration system. To this end, the connectors can utilize a scripting language to access the respective database systems. Data retrieved from the database systems can be stored in a central data store (114) in the form of RDF triplets, from which directed graphs can be generated for to generate presentations consolidated from the multiple database systems.

MULTI-TENANT DATA INTEGRATION

An enterprise application integration system (EAIS) is disclosed that enables customer service applications to access and share data with enterprise information systems in real time.

SERVICE PROVISIONING SYSTEM

A method for generating objects which facilitate access of application platform system and service provisioning system to a shared database. The method includes generating automatically objects for incorporating in the application platform system as well as objects for incorporating in the provisioning system. The generated objects facilitate access of the application platform system to the shared database, and further facilitate access of the service provisioning system to the shared database.

DATA EXCHANGE BETWEEN INSURER AND REPAIRER

This invention concerns a data exchange, and in particular a computer system for exchanging data between an insurer and a repairer, for instance between software applications of a vehicle insurer and a crash repairer. The invention also concerns the structure of a database in which the messages are stored. In a further aspect it concerns a method of exchanging the data. In each case a message transceiving station operates to send messages to and receive messages from the repairer, where each message is one of a closed set and is in the form of data wrapped in syntax to allow it to be mapped into a database structure which obeys relationship constraints and has referential integrity. A message receiver operates to unpack received messages to retrieve their data content. A message data content parser operates to parse the data content and write it to tables organised in a predetermined schema in a first database that does not have the relationship constraints and referential integrity. A ...

Method for establishing and conducting communication between a data source and a user

A method of establishing and carrying out communication between a data source and a user, where the communication is effected via a fixed or a mobile network. A program that handles the presentation to a user is placed in a server which is connected to a data source that contains data and which handles data to and from the source such that when receiving information from a user the server clears this information from the layout and protocol and sends to the data source solely interaction data, and, on the other hand, when receiving data from the data source places this data in a correct protocol for presentation to the user on his/her terminal in the right presentation form.

STRUCTURED DATA IN A BUSINESS NETWORKING FEED

Disclosed are database systems, methods, systems, and computer program products for providing tabular data in a social network feed. In some implementations, a server of a database system stores, in a database, social network feed data comprising a plurality of feed items as data objects. The server also stores, in a database, tabular data as data objects. The server shares the social network feed data and the tabular data in a social network feed displayable to present the feed items and the tabular data in a user interface, the tabular data being presentable in the user interface in a tabular format. The user interface may receive shareable user commentary regarding the tabular data. The stored tabular data may be editable by users of the database system. The social network feed may be updated to comprise notifications of edits to the tabular data.

SYSTEM AND METHOD FOR BUILDING BUSINESS SERVICE MODEL

A modeling system has a database that stores information of resources of a computer network service. A server f has a graphical user interface application for creating and editing service models. The application receives user-entered search criteria and searches information in the database based on the criteria. The search criteria can include a name, type, attribute, and other information of the resources. In addition, the search criteria can be a user-entered search query entered that has one or more logical or Boolean conditions relating resource attributes to attribute values. Using information obtained through searching, the application is used to create at least a portion of a service model of the computer network service. Once created, the application is used to initiate publishing of at least a portion of the service model to one or more impact managers of the computer network service.

System and method for accessing data objects via remote references

One embodiment of the present invention sets forth a method for providing access to a data object stored on an application server from within a client side machine. The method includes creating a remote reference that is linked to the data object, transmitting the remote reference to an application executing on a second machine, receiving an expression to evaluate that includes the remote reference, accessing at least one element included in the data object via the remote reference, evaluating the expression based on the at least one element to produce a result, and transmitting the result to the application.

DYNAMIC ACCESS TO DATA

Dynamic access to data stored in a database maintained by a server. A client sends a request to the server to access the data stored in the database. A first set of data is retrieved from the database and mapped to a second set of data based on a set of mapping rules that is defined by the client. The client then receives the second set of data.

Method, computer program product and computer system for a single database system to support multiple application systems

Multiple application systems use a single database system. At least a first application system (901) and a second application system (902) run application services for application system users. The database system (900) has at least a first memory portion (920-1) and a second memory portion (920-2). The memory portions are disjunctive. The database system (900) stores a first assignment of a first predetermined profile (110) to the first memory portion (920-1) and a second assignment of a second predetermined profile (111) to the second memory portion (920-2). The first and second profiles (110, 111) are unique and refer to the first and second application systems (901, 902), respectively. The first application system (901) and the second application system (902) access the first memory portion (920-1) and the second memory portion (920-2), through the respective profiles (110, 111).

A CO-PRESENT DATA BACK GETTING SYSTEM WHICH OBSERVER DATA INDICATES

DISTRIBUTED PEER TON PEER SECURITY SYSTEM FOR MOBILE OF DEVICES

DATA SHAPING

PROCEDURE AND INTERPROCESS COMMUNICATION DRIVER FOR THE ADMINISTRATION OF INQUIRIES OF A DATENBANKCLIENTS TO A DATA BASE SERVER

METHOD OF COMMUNICATING DATA BETWEEN COMPUTERS HAVING DIFFERENT RECORD FORMATS

A method of communicating data between databases having different formats includes providing a first computer (4), a second computer (14), and a server (22) in a distributed computer network (2) where the server (22) is configured to send, receive, and process data packets including records having different formats to and from the first computer (4) and the second computer (14). The server (22) converts a first record in a first format (26a) into the first record in a second format (26b) and converts a second record in the second format (26b) into the first format (26a). The second computer is configured to receive data packets having the first record in the second format (26b), and to send data packets having the second record in the second format (26b).

DATA MODEL FOR OBJECT-RELATIONAL DATA

A common data model (CDM) that is a data model common to multiple application-specific data models. The CDM supports both PIM (Personal Information Manager end-user application data and line-of business (LOB) data. Similarly, an SDM-type (system definition model) application can specify its model on top of the CDM. The CDM enables improved interoperability between applications by employing an entity component that provides a data entity having a uniform identity across a plurality of disparate applications and a relationship component that defines a relationship between two or more of the data entities. The CDM provides a type system over which any algebra will operate.

DISTRIBUTED MANAGEMENT SUPPORT SYSTEM FOR SOFTWARE MANAGERS

METHOD AND MEANS FOR ENCODING STORING AND RETRIEVING HIERARCHICAL DATA PROCESSING INFORMATION FOR A COMPUTER SYSTEM

A data transmission dictionary is provided, which is adapted for use by a comput er system for encoding, storing, or retrieving hierarchically related data transmission in formation. The dictionary is comprised of a group of one or more computer searchable definition trees relating to transmission information of the computer system. The trees are deriv ed from a first definition group which includes characteristics of commands, replies or data usable by the computer system. The characteristics include structure and value properti es and restrictions, if any, applying to the commands, replies or data. Each tree repre sents, respectively, a definition of a the command, reply or data to which it relates. Each tree includes a root node identified by name, eg. a codepoint. The root node includes information describing the type of definition tree concerned (i.e. whether it re lates to a command, reply or data), and may include one or more internal or terminal descen dant nodes. These nodes represent ...

METHOD AND MEANS FOR ENCODING STORING AND RETRIEVING HIERARCHICAL DATA PROCESSING INFORMATION FOR A COMPUTER SYSTEM

A data transmission dictionary is provided, which is adapted for use by a comput er system for encoding, storing, or retrieving hierarchically related data transmission in formation. The dictionary is comprised of a group of one or more computer searchable definition trees relating to transmission information of the computer system. The trees are deriv ed from a first definition group which includes characteristics of commands, replies or data usable by the computer system. The characteristics include structure and value properti es and restrictions, if any, applying to the commands, replies or data. Each tree repre sents, respectively, a definition of a the command, reply or data to which it relates. Each tree includes a root node identified by name, eg. a codepoint. The root node includes information describing the type of definition tree concerned (i.e. whether it re lates to a command, reply or data), and may include one or more internal or terminal descen dant nodes. These nodes represent ...

METHOD AND MEANS FOR ENCODING STORING AND RETRIEVING HIERARCHICAL DATA PROCESSING INFORMATION FOR A COMPUTER SYSTEM

A data transmission dictionary is provided, which is adapted for use by a comput er system for encoding, storing, or retrieving hierarchically related data transmission in formation. The dictionary is comprised of a group of one or more computer searchable definition trees relating to transmission information of the computer system. The trees are deriv ed from a first definition group which includes characteristics of commands, replies or data usable by the computer system. The characteristics include structure and value properti es and restrictions, if any, applying to the commands, replies or data. Each tree repre sents, respectively, a definition of a the command, reply or data to which it relates. Each tree includes a root node identified by name, eg. a codepoint. The root node includes information describing the type of definition tree concerned (i.e. whether it re lates to a command, reply or data), and may include one or more internal or terminal descen dant nodes. These nodes represent ...

STORAGE AND RETRIEVAL SYSTEM OF A DATABASE

DEVICE FOR the UPDATE OF INFORMATION ENREGISTREES IN a SYSTEM OF TRANSMISSION Of VISUAL INFORMATIONS PER Phone line

SYSTEM Of INTERROGATION OF HETEROGENEOUS DATABASES AND PROCEDED' INTERROGATION

La présente invention concerne un système et un procédé d'interrogation de bases de données hétérogènes. Selon l'invention, le jeu original (1) de bases de données hétérogènes est découplé du système d'interrogation au moyen de : • Un module (3) organisateur des données pour les associer par référence à une pluralité de domaines et une pluralité de métadomaines ; • Un module (4) d'interrogation et de production de données de réponse qui comporte un métamoteur de recherche pour gérer des formulaires de requête et produire des données de réponse.

SYSTEM Of INTERROGATION OF HETEROGENEOUS AND PROCEEDED DATABASES Of INTERROGATION

INTERFACES FOR A PRODUCTIVITY SUITE APPLICATION AND A HOSTED USER INTERFACE

User interfaces are defined by metadata for use with productivity suite applications in a wrapped window, a task pain, or some other suitable representation. Data can be bound to a data source in a one-way format such that changes from the data source propagate to property fields in the UI form. Data can also be bound to a data source in a two-way format such that changes from the property field of the UI propagate back to the data source. The data source can be a local cache such as for synchronization between a productivity suite application and a line of business application (e.g., CRM applications). A rendering engine is arranged to process the UI and data bindings such that custom event handlers are defined in a code behind assembly format. Productivity suite items are accessible from the code behind assembly through a series of item interfaces.

ARCHITECTURE FOR A SMART ENTERPRISE FRAMEWORK AND METHODS THEREOF

A system for enabling a user to execute an application on a client device is disclosed. The system includes a first datastore for storing metadata pertaining to design, development, deployment, presentation, and/or execution of the application. The design, development, deployment, presentation, and/or execution of the application may pertain to user interface and/or business logic of the application. The system also includes a second datastore storing application data pertaining to utilization of the application. The system further includes a third datastore residing in the client device for storing replicated metadata and replicated application data. The replicated metadata are a copy of the metadata, and the replicated application data are a copy of the application data. The system further includes logic residing in the client device for converting at least the replicated metadata into the at least one of user interface and business logic of the application.

PEER-TO-PEER DISTRIBUTED BACKUP SYSTEM FOR MOBILE DEVICES

Some embodiments provide a method, system, and apparatus for transparently backing-up information from a mobile device to distributed devices having storage capabilities. As the mobile device comes within communication range of one or more of the trusted partner devices, information from the mobile device is backed up, in segments or portions, on the one or more distributed partner devices. Information backed-up in one partner device may be transferred to another partner device for storage. A centralized master server may also maintain a list of the locations (e.g., partner devices) where backup information is maintained for the mobile device. When requested to do so by a user, the centralized server can retrieve and consolidate the backup information for the mobile device.

METHOD AND INTEGRATED CIRCUIT CARD FOR MANAGING THE DATABASE BY INTERACTING WITH THE MOBILE EQUIPMENT

A method for managing the database by interacting with the mobile equipment includes the following steps: interacting with the mobile equipment by the STK active order to obtain the data operation information of the user; confirming the corresponding expanded STK database order according to the data operation information; calling the corresponding database application programming interface (API) function to execute the data operation in the database according to the expanded STK database order. An integrated circuit card corresponding to the method for managing the database by interacting with the mobile equipment is also provided.

MESSAGE TRANSLATION USING ADAPTIVE AGENTS

A message translation system and process useful in handling translation between different formats of messages when integrating software applications. The message translation system and process utilizes a map database, external mapping services and a mapping knowledge base. Adaptive agents are used to update the mapping knowledge base.

DYNAMIC DATABASE INTERFACE

The invention relates to a method for operating a dynamic database interface for the communication between a database system application and a database system. According to the inventive method, said interface (i) receives a parameterised database system function call from the database system application, coded in the XML format, for the database system, (ii) converts said function call, as far as possible, into a format which is compatible with the database system, (iii) sends the corresponding parameterised database system function call, as far as possible, to the database system, in a format which is compatible with the database system, (iv) if a database system function call is successful, receives a parameterised result from the database system, coded in a format which is compatible with the database system, (v) if a database system function call is successful, converts the parameterised result into the XML format, and (vi) if a database system function call is successful, sends the ...

EMAIL TO DATABASE IMPORT UTILITY

The present invention facilitates the transfer of data from an email message or the like to records, tables, and/or fields of an electronic database. In an illustrative embodiment, an email message and a number of database fields are identified. Certain data from the email message are associated with one or more of records, tables, and/or fields of the database. With this association, the data in the email message may be automatically or manually parsed and saved to the associated records, tables, and/or fields of the database.

FACTORY AUTOMATION TRANSACTIONS

A system that facilitates direct communication of a transaction between an automation controller and a business system comprises a request analyzer that receives a request for data relating to the automation controller and locates a transaction definition within the automation controller based upon the request. A subscribing component subscribes the business system to the automation controller based at least in part upon the located transaction definition. 1. A method , comprising:inputting, by a device including a processor, transaction definitions into an automation controller;receiving, by the device, a request for a defined transaction with a business system database;subscribing, by the device, the business system database to the defined transaction; andinitiating, by the device, the transaction directly between the business system database and the automation controller via the standard transaction engine.2. The method of claim 1 , further comprising sensing claim 1 , by the device claim 1 , at least one of an event or a condition that triggers initiating of the transaction.3. The method of claim 2 , further comprising acknowledging claim 2 , by the device claim 2 , the at least one of the event or the condition prior to initiating the transaction.4. The method of claim 2 , the at least one of the event or the condition is an alarm.5. The method of claim 2 , the at least one of the event or the condition is a passage of a defined amount of time.6. The method of claim 1 , further comprising rolling back claim 1 , by the device claim 1 , the transaction upon a communication failure between the business system database and the automation controller.7. The method of claim 1 , the transaction comprising at least one of data in a maintenance class claim 1 , a production schedule class claim 1 , or a batch record class.8. The method of claim 7 , further comprising formatting data in the production schedule class in SP95 format.9. A system claim 7 , comprising:a ...

METHOD AND SYSTEM FOR THE MANAGEMENT OF PROFESSIONAL SERVICES PROJECT INFORMATION

A method and system are provided for the transfer and/or aggregation of data and, in particular, integrating data used in managing a professional services practice. The invention preferably transfers and/or aggregates data relating to the identity of clients and matters for whom professional services are being rendered with data relating to the work which data may be maintained in inconsistent, proprietary formats, comprising one or more of the following types of information: accounting: budgeting; docketing; time and billing: work product; word processing; records; project management; and/or other information relating to the professional services. The system of the present invention preferably comprises data storage and data processing means adapted to use the data in substantially portable and/or application-independent format, and/or and transfer or aggregate data between common, and/or proprietary data formats. 1. A data processing system for managing data related to a professional services project , comprising:a. a computer for processing the data;b. a software application cooperating with said computer; andc. data storage means cooperating with said computer for storing data;d. the data cooperating with said software application;e. the data in a substantially portable format.2. The data processing system of claim 1 , further comprising data in portable format.3. The data processing system of claim 1 , further comprising data in a substantially application-independent format.4. The data processing system of claim 1 , further comprising data in application-independent format claim 1 ,5. The data processing system of claim 1 , further comprising claim 1 , data selected from the group consisting of: docketing; calendaring; word processing; document management; accounting; and time and billing:6. The data processing system of claim 5 , further comprising data in data in portable format.7. The data processing system of claim 5 , further comprising data in ...

DATA CONVERTING APPARATUS, METHOD, AND COMPUTER PRODUCT

A data converting apparatus includes a storage unit that stores encoded meta-definition information, a data converting function, a conversion rule table, and a conversion rule; an input unit that receives input of data to be converted; a detecting unit that uses the encoded meta-definition information to detect metadata codes for a conversion source and a conversion destination for which the conversion rule code matches; a determining unit that determines whether the detected metadata codes match; a specifying unit that, by referring to a conversion rule and based on the determination result at the determining unit, specifies the data converting function, according to the combination of the metadata codes for the conversion source and for the conversion destination; and a converting unit that uses the specified data converting function to convert the data of the conversion source to have a property prescribed by metadata for the conversion destination. 1. A data converting apparatus comprising:a storage unit that stores encoded meta-definition information that assigns a metadata code as a unique code to an element making up metadata in meta-definition information that defines metadata indicative of a property related to data of a conversion source and a conversion destination, a data converting function that converts conversion source data having a property prescribed by the metadata for the conversion source into conversion destination data having a property prescribed by the metadata for the conversion destination, a conversion rule table that assigns the data converting function according to a combination of a metadata code for the conversion source and a metadata code the conversion destination, and a conversion rule that correlates with each of the conversion rule tables, a relevant metadata code as a conversion rule code;an input unit that receives input of data to be converted;a detecting unit that refers to the encoded meta-definition information stored in ...

SYSTEM AND METHODS THEREOF FOR DETECTION OF USER DEMOGRAPHIC INFORMATION

A system and method for detecting implicit information related to a user are disclosed. The system comprises a network interface for accessing one or more data sources; a plurality of agents for collecting textual content from the one or more data sources; a processing unit for extracting explicit demographic information related to the user and generating implicit demographic information related to the user respective of the explicit demographic information; and a data warehouse connected to the processing unit for storing the generated implicit demographic information. 1. A system for detecting implicit information related to a user , comprising:a network interface for accessing one or more data sources;a plurality of agents for collecting textual content from the one or more data sources;a processing unit for extracting explicit demographic information related to the user and generating implicit demographic information related to the user respective of the explicit demographic information; anda data warehouse connected to the processing unit for storing the generated implicit demographic information.2. The system of claim 1 , wherein the plurality of agents are further configured to collect data respective of the user's common activity with respect of the one or more data sources; and claim 1 , to store the data collected in the data warehouse.3. The system of claim 2 , wherein the user's common activity is at least one of: a typing speed claim 2 , language proficiency claim 2 , time of the day the user is usually active in the one or more data sources.4. The system of claim 1 , wherein the one or more data sources are at least one of: a social network claim 1 , a blog claim 1 , a news feed claim 1 , and a web page.5. The system of claim 1 , wherein the implicit demographic information is at least one of the following statistics characterizing the user: user age claim 1 , gender claim 1 , relationship status claim 1 , location claim 1 , home address claim 1 , work ...

MEDIA MEDIATOR SYSTEM AND METHOD FOR MANAGING CONTENTS OF VARIOUS FORMATS

Provided is a system and method that may encode various formats of contents to a single format and thereby manage the contents, and may transform the contents to a format corresponding to a request of a third party or an end user to distribute the content. A media mediator system of managing various formats of contents may include: a service manager to receive a content and metadata of the content from a content provider; a metadata manager to register the content using the metadata, and to store the metadata of the registered content; a database manager to store and manage information associated with the content; and an encoding manager to schedule an encoding sequence of the content, and to sequentially encode the content based on a scheduling result. 1. A method of managing various formats of contents , comprising:aggregating, by a media mediator system, contents and metadata of the contents from a plurality of content providers;converting, by the media mediator system, the contents and metadata to web style for end-user in Web service platform; andproviding, by the media mediator system, the converted contents and metadata to the end-user.2. The method of claim 1 , wherein the content providers have different kinds of services platform.3. The method of claim 1 , wherein the converting converts a format of contents according to the end-user's request for contents.4. The method of claim 1 , wherein the metadata includes an access path to the content and an access path to a thumbnail extracted from the contents.5. The method of claim 1 , wherein the converting converts a format of metadata according to the end-user's request for contents.6. The method of claim 5 , wherein the converting converts a format of metadata to a format accessible for end-user in Web service platform.7. The method of claim 1 , wherein the format accessible for end-user in Web service platform is an Extensible Markup Language (XML) format.8. The method of claim 1 , wherein the converting ...

SYSTEM AND METHOD FOR DATA AGGREGATION, INTEGRATION AND ANALYSES IN A MULTI-DIMENSIONAL DATABASE

The present invention relates to a system and method for flexibly integrating a data warehouse with one or more operational database in real-time. The system comprises of a plurality of components embedded under one or more layers. The system comprises of a staging database, an ETL (extract transform load) module, a data warehouse and a networking module. The flexible integration is enabled by invoking one or more web services from a business enterprise. The invention further provides one or more analytical modules for performing an intelligent operation to carry out comparative analyses of the data. The designing and implementation module enables a deployment of the system on any related technology platform and tools. 1. A system for flexibly integrating a data warehouse with one or more operational database in real-time , a first node communicatively accessing one or more data elements from one or more disparate databases installed at a plurality of disparate computing environment , the system comprising:an extracting module for extracting a data from one or more disparate databases;a staging database configured for correlating and accumulating the data for supporting a mining of a transactional data out of the data, the correlated data is further processed through an extraction transformation and load routine for loading it onto the data warehouse, the data warehouse configured for storing the data in a summarized form;a networking module configured to enable the flexible integration of the data warehouse with the one or more operational systems and enterprise processes to support real time sharing of data from the data warehouse to the connected operational systems and enterprise processes;one or more analytical module communicatively coupled to the data warehouse for performing an intelligent operation to provide an insight into a customer's behavior and business performance of one or more industries by enabling a comparative analyses with respect to the data; ...

ON-LINE TRANSACTION PROCESSING (OLTP) COMPRESSION AND RE-COMPRESSION OF DATABASE DATA

A computer is programmed to compress data of a database in response to database modification language (DML) statements generated by on-line transaction processing (OLTP) systems. In several embodiments, data that is initially added to a database block is left uncompressed until a predetermined condition is satisfied, which happens infrequently (relative to OLTP transactions on the block). When satisfied, the computer automatically compresses all uncompressed data in the block, which increases the amount of unused space in the block. New data is thereafter added uncompressed to the partially compressed block, until satisfaction of a predetermined condition whereby the partially compressed block is again compressed, i.e. re-compressed. Adding of new data to a partially compressed block and its compression are repeated unless another predetermined condition is met, in response to which the block is not further re-compressed, thereby to recognize a limit on the benefit from compression. 1. A method implemented in a computer for compression of data in a database , the method comprising:determining whether at least one predetermined condition is satisfied; decompressing first compressed data from a block comprising the first compressed data and first uncompressed data, to obtain second uncompressed data from the first compressed data, the block being comprised among multiple blocks in the database; and', 'compressing at least the first uncompressed data and the second uncompressed data together, to generate second compressed data; and, 'in response to the determining that the at least one predetermined condition is satisfiedstoring the block in a mass storage device.2. The method of wherein:unused space in the block after compressing is greater than unused space in the block prior to decompressing.3. The method of further comprising:writing new uncompressed data to the block if at least another predetermined condition is satisfied, else writing the new uncompressed data ...

DATA PROVIDING APPARATUS, ELECTRONIC APPARATUS, DATA PROCESSING SYSTEM, AND METHOD OF DATA PROCESSING

A data processing system includes an electronic apparatus including a script implementation unit which receives a Web page including a script via a network, and sends a request for obtaining data based on the script to a data providing apparatus which is connected via a network, the request for obtaining data including identification data of target data to obtain, and attribute data of the electronic apparatus; and the data providing apparatus including a conversion unit which converts a data format of target data stored in a data storing unit identified by the identification data included in the request for obtaining data sent from the electronic apparatus to another data format based on the attribute data of the electronic apparatus included in the request for obtaining data, and a sending unit which sends the target data with the other data format to the electronic apparatus. 1. A data processing system comprising:an electronic apparatus including a script implementation unit which receives a Web page including a script via a network, and sends a request for obtaining data based on the script to a data providing apparatus which is connected via a network,the request for obtaining data including identification data of target data to obtain, and attribute data of the electronic apparatus; and a conversion unit which converts a data format of the target data stored in a data storing unit identified by the identification data included in the request for obtaining data sent from the electronic apparatus to another data format based on the attribute data of the electronic apparatus included in the request for obtaining data, and', 'a sending unit which sends the target data with the other data format to the electronic apparatus., 'the data providing apparatus including'}2. The data processing system according to claim 1 ,wherein the other data format to which the target data is converted is designated by the attribute data.3. The data processing system according to ...

Systems and Methods for Providing a Multi-Tenant Knowledge Network

Business intelligence, decision support and knowledge management network systems and methods provide efficient, robust, and business-friendly services for the rapid analysis of massive amounts of business, electronic, and other disparate data into actionable intelligence. An advantageous element of the multi-party knowledge network allows the aggregation of common data formats in order to analyze a combined dataset consisting of information from multiple parties, thereby providing additional business intelligence than with a single set of data alone. 1. A system for delivering business intelligence comprising:a database comprising two or more datasets, said datasets each comprising information related to a different business;an integration unit in communication with at least two disparate data sources and in communication with the database; andan analytics unit in communication with the database and in communication with at least one user;wherein the integration unit gathers data from the at least two disparate data sources and translates said data into comparable data and wherein the analytics unit analyzes the comparable data.2. The system of claim 1 , wherein one of the two or more datasets is private and belongs to one of the at least one user.3. The system of claim 1 , wherein the database further comprises at least one public dataset claim 1 , wherein the analytics unit combines the at least one public dataset with at least one of the two or more datasets to perform an analysis.4. The system of claim 3 , wherein the at least two disparate data sources are selected from the group consisting of social networks claim 3 , electronic mail claim 3 , website analytics claim 3 , market reports claim 3 , sales and marketing information claim 3 , and logistics information.5. The system of claim 1 , wherein the two or more datasets are private and further comprising a collaboration unit for combining at least two of the two or more datasets to create a combined dataset ...

INFORMATION PROCESSING APPARATUS, INFORMATION PROCESSING SYSTEM, AND DATA CONVERSION METHOD

An information processing apparatus may include a plurality of converting units respectively configured to execute a predetermined data conversion from one data format to another data format, and a control unit. The control unit may coordinate the converting units based on a conversion request to convert electronic data in a first data format into electronic data in a second data format, in order to make the converting units execute a data conversion from the first data format to the second data format. 1. An information processing apparatus comprising: a plurality of converting units respectively configured to execute a predetermined data conversion from one data format to another data format; and', 'a control unit configured to coordinate the plurality of converting units, based on a conversion request to convert electronic data in a first data format into electronic data in a second data format, in order to make the plurality of converting units execute a data conversion from the first data format to the second data format., 'a processor including'}2. The information processing apparatus as claimed in claim 1 , wherein the control unit analyzes the conversion request claim 1 , and coordinates the data conversion by the plurality of converting units when a single converting unit cannot realize the data conversion from the first data format to the second data format claim 1 , in order to make the plurality of converting units execute the data conversion from the first data format to the second data format.3. The information processing apparatus as claimed in claim 2 , wherein the control unit accepts the conversion request claim 2 , and controls the plurality of converting units so that the electronic data in the first data format is converted into the electronic data in the second data format by coordinating the plurality of converting units.4. The information processing apparatus as claimed in claim 1 , wherein the control unit segments the data conversion from ...

METHOD AND APPARATUS FOR CONSTRUCTING DATA WAREHOUSE TO MANAGE MASS BUILDING ENERGY INFORMATION

A method and apparatus for constructing a data warehouse for managing mass building energy information are provided. The apparatus for constructing a data warehouse in order to manage mass building energy information includes a primitive database generator for constructing primitive databases in each building based on energy control point information, a time series data warehouse generator for generating time series data warehouses based on the constructed primitive databases, a space time series data warehouse generator for reconstructing the generated time series data warehouses based on an object construction information table including space information about objects for control points of the plurality of buildings to be controlled to generate space time series data warehouses, and a view database generator for generating view databases by a search condition in accordance with the search condition for energy usage information based on the generated space time series data warehouses. 1. An apparatus for constructing data warehouses in order to manage mass building energy information , comprising:a primitive database generator for constructing primitive databases in each building of a plurality of buildings to be controlled, based on energy control point information received from the plurality of buildings to be controlled;a time series data warehouse generator for generating time series data warehouses based on the constructed primitive databases;a space time series data warehouse generator for reconstructing the generated time series data warehouses, to generate space time series data warehouses, based on an object construction information table including space information about objects for control points of the plurality of buildings to be controlled; anda view database generator for generating view databases by a search condition in accordance with a search condition for energy usage information based on the generated space time series data warehouses.2. The ...

SYSTEM AND METHOD FOR MATHEMATICS ONTOLOGY EXTRACTION AND RESEARCH

An extensive computer based online math research system (the “Research System”) having as its foundation an Ontology of mathematics, and utilizing unique and intensive computer support, coordination, data structuring, data storage, computer processing, retrieval capabilities, and data-mining capabilities, and an Ontology editing system that runs on computer software with computer processors and data storage capabilities (the “Ontology Editor System”). The Research System also includes a methodology to enable online reference and data manipulation of the Ontology, and an Internet based search of the concepts of mathematics and applications of mathematics to the sciences on the basis of the Ontology. 1. (canceled)2. A method of creating a mathematical research system comprising:creating a plurality of concept line items (CLI)s from at least one mathematical problem, wherein a CLI is a mathematical concept expressed as a word phrase;defining interrelationships between said CLIs;generating, by a computer processor, a mapping of said interrelationships of said CLIs; andstoring said CLIs and said generated mapping in at least one database.3. The method of further comprising:creating additional CLIs from a second mathematical problem;redefining said interrelationships based on said additional CLIs;regenerating said mapping based on said redefined interrelationships; andstoring said additional CLIs and said regenerated mapping in said at least one database.4. The method of wherein said interrelationships are directional relationships claim 2 , wherein a directional relationship is defined as one of: a prerequisite relationship claim 2 , a dependency relationship claim 2 , and a lack of relationship.5. The method of wherein said generated mapping is a directional mapping positioning prerequisite CLIs before dependency CLIs claim 4 , thereby showing an order in which said CLIs are to be learned by a student.6. The method of further comprising:searching, by said computer ...

Interest-Driven Business Intelligence Systems and Methods of Data Analysis Using Interest-Driven Data Pipelines

Interest-driven Business Intelligence (BI) systems in accordance with embodiments of the invention are illustrated. In one embodiment of the invention, a data processing system includes raw data storage containing raw data, metadata storage containing metadata that describes the raw data, and an interest-driven data pipeline that is automatically compiled to generate reporting data using the raw data, wherein the interest-driven data pipeline is compiled based upon reporting data requirements automatically derived from at least one report specification defined using the metadata. 1. A data processing system , comprising:raw data storage containing raw data;metadata storage containing metadata that describes the raw data; andan interest-driven data pipeline that is automatically compiled to generate reporting data using the raw data;wherein the interest-driven data pipeline is compiled based upon reporting data requirements automatically derived from at least one report specification defined using the metadata.2. The data processing system of claim 1 , wherein the interest-driven data pipeline is automatically compiled based upon at least one change selected from the group consisting of a change to the reporting data requirements claim 1 , a change to the metadata claim 1 , and a change to the raw data.3. The data processing system of claim 1 , further comprising:source data storage configured to store source data; andwherein the interest-driven data pipeline is configured to create source data by performing an extract, transform, and load (ETL) process on raw data using a source model.4. The data processing system of claim 4 , further comprising:aggregate data storage configured to store aggregate data; andwherein the interest-driven data pipeline is configured to generate aggregate data by performing aggregations using the source data.5. The data processing system of claim 4 , wherein the interest-driven data pipeline is configured to generate aggregations ...

Dynamic access of data

A heterogeneous information technology system in which compatible and incompatible client systems are able to dynamically access master data stored in a master database maintained by a master data server. An integration server communicates with the client systems and the master data server, and in response to a request for data from a client system, maps the master data in the master database to mapped data based on a set of mapping rules associated with the client system, and sends the mapped data to the client system.

Interest-Driven Business Intelligence Systems and Methods of Data Analysis Using Interest-Driven Data Pipelines

Interest-driven Business Intelligence (BI) systems in accordance with embodiments of the invention are illustrated. In one embodiment of the invention, a data processing system includes raw data storage containing raw data, metadata storage containing metadata that describes the raw data, and an interest-driven data pipeline that is automatically compiled to generate reporting data using the raw data, wherein the interest-driven data pipeline is compiled based upon reporting data requirements automatically derived from at least one report specification defined using the metadata.

SYSTEM AND METHOD FOR RETRIEVING AND STORING INDUSTRIAL DATA

The invention provides a system and method for retrieving and storing industrial data, the system comprising a data retriever that includes a data retrieval manager and one or more watchers for monitoring data associated with one or more industrial devices, wherein if the data associated with the one or more industrial devices is new or modified, the one or more watchers notifies the data retrieval manager thereof and the data retrieval manager uploads the new or modified data. The system further includes a database manager for receiving the new or modified data in a first form from the data retrieval manager and for storing the new or modified data in a structural data form in one or more databases. 1. A method for retrieving industrial data and providing data in a structural form in a searchable database , the method comprising:reading data from an industrial data source;using a watcher to monitor the data for additions or modifications;notifying a data retrieval manager when additions or modifications to the data have occurred;uploading any new or modified data from the data source to the data retrieval manager;converting the new or modified data to a structural form; andstoring the new or modified data in a structural form in a searchable database.2. The method of claim 1 , further including filtering the new or modified data to provide new or modified data in a first form which is then converted to new or modified data in the structural form.3. The method of claim 2 , further including integrating the new or modified data in the structural form in a database with other data based on common terms and forming inference connections between the terms.4. The method of claim 1 , wherein the structural form is suitable for a structural search query.5. The method of claim 1 , wherein the data is obtainable from searching at least one of a file system claim 1 , an event logger claim 1 , and a device network.6. The method of claim 1 , wherein the watcher includes one of ...

Systems and Methods for Data Integration and Standardization

Systems and methods for data integration and standardization are disclosed. For example, one disclosed method comprises receiving first and second clinical trial data from first and second data stores, transforming the first clinical trial data and the second clinical trial data into operational data formats and storing the transformed data in a second operational data store; generating a first data entity stored in an integrated data format in an integrated data store; selecting a first data record from first clinical trial data in the first operational data format; identifying a second data record from the second clinical trial data in the second operational data format, wherein identifying the second data record is based at least in part on a determined association between the first data record and the second data record; and storing data from the first data record and the second data record in the first data entity. 1. A method comprising:receiving first clinical trial data from a first data store, the first clinical trial data stored in a first format and comprising a plurality of data records;receiving second clinical trial data from a second data store, the second data store different from the first data store, the second clinical trial data stored in a second format, the second format different from the first format and comprising a plurality of data records;transforming the first clinical trial data from the first format to a first operational data format and storing the first clinical trial data in the first operational data format in a first operational data store;transforming the second clinical trial data from the second format to a second operational data format and storing the second clinical trial data in the second operational data format in a second operational data store;generating a first data entity stored in an integrated data format in an integrated data store;selecting a first data record from first clinical trial data in the first ...

DATA CELL CLUSTER IDENTIFICATION AND TABLE TRANSFORMATION

Various embodiments may operate to access individual lines of information included in a file stored in an electronic storage medium, to detect the existence of data clusters in the file based on neighboring cell content in a horizontal direction (corresponding to the individual lines), and in a vertical direction (orthogonal to the horizontal direction), to identify at least some of the data clusters as being associated with predefined table types (comprising vertical tables, horizontal tables, or cross tables), to merge some of the data clusters into section tables having common properties, and to transform the tables resulting from the merging activity, as well as remaining un-merged data clusters, into a single flat table. The stored file may comprise a spreadsheet file. 1. (canceled)2. An apparatus , comprising:a processing node comprising a data reception module to sequentially access individual lines of information included in a file stored in an electronic storage medium; and to detect existence of data clusters in the file,', 'to generate metadata including characteristics associated with each of the data clusters,', 'to identify at least some of the data clusters as being associated with predefined table types comprising vertical tables, horizontal tables, or cross tables,', 'to merge one or more of the data clusters having common cluster table schemas into section tables, based on the metadata, and', 'to transform the vertical tables, the horizontal tables, the cross tables, the section tables, and remaining un-merged data clusters into a single flat table having a vertical or horizontal orientation, based on the metadata., 'a transformation module to couple to the data reception module, the transformation module'}3. The apparatus of claim 2 , wherein the transformation module is further configured to determine that said one or more of the data clusters have the common cluster table schemas claim 2 , based on the metadata.4. The apparatus of claim 2 , ...

SYSTEMS AND METHODS FOR CATEGORIZING AND PRESENTING PERFORMANCE ASSESSMENT DATA

The field of the invention relates to systems and methods for data mining and processing, and more particularly to systems and methods for automating content from performance assessment data. In one embodiment, an automated notes and categorization system may include a primary database comprising performance assessment data. The primary database is operatively coupled to a computer program product having a computer-usable medium having a sequence of instructions which, when executed by a processor, causes said processor to execute a process that analyzes and converts raw performance data into automated content that presents data in readable user friendly form to facilitate human understanding. 1. An automated notes and categorization system comprising:a primary database, the primary database having raw performance assessment data;wherein the primary database is operatively coupled to a computer program product having a computer-usable medium having a sequence of instructions which, when executed by a processor, causes said processor to execute an electronic process that analyzes and converts said raw performance data;a processed database for storing the processed data operatively couple to the computer program product; and data mining said performance assessment data to obtain summarized data;', 'prioritizing said summarized data based on user-defined weight values for a plurality of classification categories; and', 'converting results of the prioritization into automated plain language notes., 'said electronic process comprising2. The system of claim 1 , further comprising a secondary database having user-generated (secondary) performance assessment data.3. The system of claim 1 , wherein said process further comprises determining whether said summarized data is positive or negative to the classification category.4. The system of claim 1 , wherein the automated plain language notes include historical trend of said summarized data.5. The system of claim 4 , wherein ...

SINGLE COMMAND DATA WAREHOUSE TABLE UPDATE

Information warehouse table data is updated through a full outer join between warehouse tables and source tables in response to a single query language command statement of a relational database computer language. The single command statement comprises table mapping instructions for updating the warehouse tables that define matching conditions, delete instructions, archive instructions, and update instructions. The full outer join inserts rows in the warehouse tables for source table data rows that do not have corresponding matching rows in the warehouse table. Data rows in the warehouse tables without corresponding matching source table rows are deleted if a value of a parameter in the warehouse table system is set to delete; updated if the parameter is update; and updated with archive values and a new table row inserted with existing values if the parameter is archive. 1. A method for updating table data in an information warehouse via a single query language command , the method comprising: deleting the first data row if a value of a treat history parameter in the warehouse table system is set to delete;', 'updating the first data row with update values if the warehouse table system treat history parameter is set to update; and', 'updating the first data row with archive values and inserting a new table row into the at least one warehouse table that comprises existing values from the first data row if the warehouse table system treat history parameter is set to archive; and, 'in response to a single query language command statement of a relational database computer language comprising table mapping instructions for updating at least one information warehouse table of an information warehouse database system with data from at least one source table, performing a full outer join between the at least one warehouse table and the at least one source table based on the command matching conditions defined by the single query language command statement by the steps of, ...

DEVICE, METHOD OF PROCESSING DATA, AND COMPUTER-READABLE RECORDING MEDIUM

A device includes a memory configured to store a program; and a processor coupled to the memory and configured to execute a process based on the program. The process includes: for input data made of a combination of pieces of unit data and including a plurality of consecutive records each including data of a plurality of items, when a sequence of type information indicating a kind of each piece of the unit data in the input data is divided into partial sequences each having a certain length, analyzing a break position of the records in the input data by determining, as a length of each of the records, the length of each of the partial sequences when sequences of type information in all the partial sequences correspond to each other. 1. A device comprising:a memory configured to store a program; anda processor coupled to the memory and configured to execute a process based on the program, the process including:for input data made of a combination of pieces of unit data and including a plurality of consecutive records each including data of a plurality of items, when a sequence of type information indicating a kind of each piece of the unit data in the input data is divided into partial sequences each having a certain length, analyzing a break position of the records in the input data by determining, as a length of each of the records, the length of each of the partial sequences when sequences of type information in all the partial sequences correspond to each other.2. The device according to claim 1 , wherein the analyzing analyzes at least one of a start position and an end position of the partial sequence claim 1 , as break information indicating a break position of the input data.3. The device according to claim 2 , wherein the analyzing analyzes a position which is at least one of the start position and the end position of the partial sequence and is at least one of a start position and an end position of consecutive pieces of the type information of an identical ...

CUSTOMER SERVICE AND SUPPORT SYSTEMS AND METHODS FOR USE IN AN ON-DEMAND DATABASE SERVICE

Analytic snapshots aid reporting and dashboard infrastructure to be more scalable and responsive to users. By storing the results of a query generating aggregates, and refreshing these aggregates on a scheduled basis, refreshing the dashboard (using the current dashboard infrastructure) can be accelerated. 1. A method , the method comprising:identifying one or more source objects;identifying a target object;mapping fields between the one or more source objects and the target object;automatically updating fields in the target object pursuant to a user defined schedule; andproviding updates to a dashboard object using the target object upon request from the user to update the dashboard object.2. The method of claim 1 , further comprising determining an aggregation level claim 1 , the aggregation level describing a granularity of an aggregation of data of the target object.3. The method of claim 2 , further comprising the steps of:receiving a drill-down query on data supplied by the target object; andonce the target object has a sufficient aggregation level to support the drill-down query, using information within the target object to form a response to the drill-down query.4. The method of claim 3 , wherein the drill-down query is receive by the dashboard object.5. A tangible computer readable medium that stores code claim 3 , which when executed by one or more processors causes the processor(s) to:identify one or more source objects;identify a target object;map fields between the one or more source objects and the target object;automatically update fields in the target object pursuant to a user defined schedule; andprovide updates to a dashboard object using the target object upon request from the user to update the dashboard object.6. The tangible computer readable medium of claim 5 , further comprising determining an aggregation level claim 5 , the aggregation level describing a granularity of an aggregation of data of the target object.7. The tangible computer ...

OPTIMIZING DATA PROCESSING USING DYNAMIC SCHEMAS

A computer system accesses rows of feed data and converts the received feed data into portions of binary blob data. The computer system also sends the binary blob data to a database server which is configured to access metadata associated with a feed including a dynamic server statement to determine how to convert the binary blob data to a server table with a blob column configured to store the rows of feed data. The database server accesses feed data belonging to a particular feed and executes a dynamic server statement to create a relational dataset in an in-memory table of the server. A second dynamic statement applies data processing conditions indicated in the metadata. When feed data rows match conditions, the computer system places feed data row information into an alert table that includes references to the blob table with blob data, thereby triggering an alert. 1. A method , implemented at a computer system that includes one or more processors , for efficiently uploading data to a database using dynamic schemas , the method comprising:an act of receiving from an application server one or more portions of binary blob data at a database server;an act of executing a dynamic server statement to store the binary blob data into a database table, wherein the dynamic server statement is stored within metadata associated with the original feed;an act of restoring one or more feed data rows from the binary blob data by substituting varying size references with the actual feed data, while keeping the feed data in a binary format; andan act of storing the restored feed data in the database table in a blob data column, wherein each feed data row results in one binary blob value in one corresponding row in the database table.2. The method of claim 1 , further comprising an act of accessing the metadata included in the original feed to determine whether data processing conditions exist for the feed data.3. The method of claim 2 , further comprising claim 2 , upon ...

System and method for correct and effective transaction execution in a data center system by implementing FIFO-grouping in a data store

A data center is a computing environment focusing on the execution of data transactions for corporations and organizations. The data center has the capability of running many execution threads in parallel. 1. A data center using FIFO-grouping enabled data store , running a number of tasks for a number of customers , where based on selection criteria , a subset of the corporate data items will be selected.2. A data center as in claim 1 , where FIFOs of data items will be established claim 1 , with a FIFO per an group-type value as defined by the selection criteria.3. A data center as in claim 2 , where the FIFOs will be derived from the FIFO-grouping enabled indices.4. A data center as in where an available execution threads will be assigned per FIFO5. A data center as in where only one execution thread can be assigned to a certain FIFO.6. A data center as in where other execution threads can be assigned to FIFOs which are not being executed upon.7. A data center as in where the selection criteria can be changed from time to time.8. A data center as in where the execution is under a transaction per FIFO data element9. A data center as in where the first data element in a FIFO is being executed This non provisional patent application claims benefit of the filing date of provisional application 61/588,191 filed on Jan. 19, 2012, as a priority date for this applicationIn high throughput OLTP systems where partial ordering of incoming data is essential to the correctness of the processing, but total ordering of the data incurs a large processing time overhead. Examples for this kind of system are financial order management systems, which have to process large amounts of orders, but in most cases require ordering of incoming orders only between orders for a specific security or stock, but not across the entire set of orders.1 A Queue based systems. In queue based system a queue (or queues) are created in advance using a queue factory. In order to process a queue the ...

SYSTEM AND METHOD FOR PRESENTING AND MANAGING SOCIAL MEDIA

A method, system, apparatus, and computer program product provide the ability to present media content on a social media network. Live streaming data is received from multiple data sources. The data is enriched with meta information using internal systems via application programming interfaces (APIs). The live streamed data is transformed and transmitted, based on the meta information, to one or more users on a social media network. 1. A computer-implemented method for presenting media content on a social media network comprising:receiving, in a computer, live streaming data from multiple data sources;enriching the live streaming data with meta information using one or more internal systems via application programming interfaces (APIs) for the one or more internal systems; andtransforming and transmitting the live streamed data based on the meta information, wherein the transformed live streamed data is transmitted to one or more users on a social media network.2. The computer-implemented method of claim 1 , further comprising:normalizing the live streaming data into a common format via extraction transformation, and loading functions.3. The computer-implemented method of claim 1 , wherein one of the one or more internal systems comprises a frame application that identifies an influence of a user or resource within a pre-defined context based on point values assigned to activities that occur within the pre-defined context.4. The computer-implemented method of claim 1 , wherein one of the one or more internal systems comprises a tag inheritance system that determines affinities for resources and users via the live streamed data.5. The computer-implemented method of claim 1 , wherein the enriching comprises:maintaining state between one or more events such that meta information from one of the one or more internal systems is applied to a second of the one or more internal systems.6. The computer-implemented method of claim 1 , further comprising ensuring that the live ...

Transparent adaptive file transform

Embodiments of methods, systems, and services for transparent adaptive file transform are described. In one embodiment a method for transparent adaptive file transform is performed by a data processing device. The method may include automatically detecting a data transfer addressed to an external data storage. The method may also include redirecting data associated with the data transfer to a data transformer. Additionally, the method may include applying one or more data transforms to the data associated with the data transfer to generate a transformed data set. In an embodiment, the method may also include transferring the transformed data set to the external data storage. In one embodiment, the external data storage is a cloud storage facility.

MECHANISM FOR FACILITATING MANAGEMENT AND CUSTOMIZATION OF LIGHTWEIGHT OBJECTS IN AN ON-DEMAND SERVICES ENVIRONMENT

In accordance with embodiments, there are provided mechanisms and methods for facilitating management and customization of lightweight objects in an on-demand services environment. In one embodiment and by way of example, a method includes receiving, at a first computing device, a request a file having data and associated metadata in a format that is not supported by default objects of a software application. The method may further include generating one or more dynamic objects to support the requested format, generating the requested format using the one or more dynamic objects, and providing the file in the requested format via the software application. 1. A method comprising:receiving, at a first computing device, a request for a file having data and associated metadata in a format that is not supported by default objects of a software application;generating one or more dynamic objects to support the requested format;generating the requested format using the one or more dynamic objects; andproviding the file in the requested format via the software application.2. The method of claim 1 , wherein the request is placed claim 1 , via a user interface claim 1 , at a second computing device including a client computing device having a mobile computing device claim 1 , wherein the request is placed by a user as an individual or serving as a representative of an organization claim 1 , wherein the organization includes a customer of a service provider that owns the software application.3. The method of claim 1 , wherein the software application comprises one or more of a business software application claim 1 , a business networking website claim 1 , and a social networking website.4. The method of claim 1 , wherein the first computing device comprises a server computing device coupled to the second computing device over a network claim 1 , wherein the network includes one or more of a cloud-based network claim 1 , a Local Area Network (LAN) claim 1 , a Wide Area Network ( ...

TRANSLATION MAP SIMPLIFICATION

A method for translation map simplification may include determining a translation map based on a predetermined criterion in response to receiving input data. The method may also include determining if the translation map extends another map or a referenced map and determining if the translation map includes at least one map fragment. The referenced map is loaded in response to a determination that the translation map includes an extension of the referenced map. The map fragment is loaded in response to a determination that the translation map comprises the map fragment. A new map is compiled based on at least the translation map, the referenced map and the at least one map fragment, in response to the translation map not including a new map reference or a modification to the translation map. The input data is processed based on the new map to produce translated data specific to the new map. 1. A method for translation map simplification , comprising:receiving input data by a computer device;determining, by the computer device, a translation map based on a predetermined criterion in response to receiving the input data;loading, by the computer device, the translation map determined based on the predetermined criterion;determining, by the computer device, if the translation map extends another map, the other map comprising a referenced map;determining, by the computer device, if the translation map comprises at least one map fragment;loading, by the computer device, the referenced map in response to a determination that the translation map comprises an extension of the referenced map;loading, by the computer device, the at least one map fragment in response to a determination that the translation map comprises the at least one map fragment;compiling, by the computer device, a new map based on at least the translation map, the referenced map and the at least one map fragment, in response to a determination that the translation map does not comprise at least one of a ...

AUTOMATIC LAYOUT DERIVATION AND IMPLEMENTATION

Embodiments are directed to determining a data insertion point in a data layout based on relative cardinalities between data objects and to determining a data insertion point in a data layout based on defined hierarchies between data objects. In an embodiment, a computer system receives a user input indicating that an additional portion of information is to be added to an existing data layout which includes multiple different data objects. The computer system accesses the data objects to determine relative cardinalities between the data objects in the data layout. The computer system determines an optimal data insertion point for inserting the additional portion of information based on the determined relative cardinalities between the data objects. The computer system also inserts the additional portion of information in the existing data layout at the determined optimal data insertion point. 1. At a computer system including a processor and a memory , in a computer networking environment including a plurality of computing systems , a computer-implemented method for determining a data insertion point in a data layout based on relative cardinalities between items in the data layout , the method comprising:an act of determining that one or more portions of additional information are to be added to a data layout, the data layout comprising one or more items that are to be presented in a user interface;an act of accessing at least one of the items in the data layout to determine one or more relative cardinalities between the items and the additional information that is to be added to the data layout;an act of determining a data insertion point for inserting the additional information into the data layout according to the determined relative cardinalities between the items and the additional information, the data insertion point indicating a determined optimal location to insert the additional information in the data layout; andan act of inserting the additional ...

Generation of Electronic Pedigree

A pedigree data processing system receives a first item from an upstream partner and generates a receive native event for the first item. The mechanism receives pedigree data for the first item from the upstream partner, generates at least one synthetic event based on the pedigree data and stores the receive native event and the at least one synthetic event in a pedigree data repository. The pedigree data processing system determines whether to send electronic pedigree information for the first item to downstream partners using push data exchange or pull data exchange, The pedigree data processing system generates an electronic pedigree for the first item using pull data exchange based on the receive native event and the at least one synthetic event and provides the electronic pedigree to a first downstream partner pedigree system. 1. A method , in a pedigree data processing system , for generating electronic pedigrees , the method comprising:generating a receive native event for a first item received from an upstream partner;receiving pedigree data for the first item from the upstream partner;generating at least one synthetic event based on the pedigree data;storing, by the pedigree data processing system, pre receive native event and the at least one synthetic event in a pedigree data repository;determining, by the pedigree data processing system, whether to send electronic pedigree information for the first item to downstream partners using push data exchange or pull data exchange;responsive to determining to send electronic pedigree information for the first Item using a pull data exchange, generating, by the pedigree data processing system, an electronic pedigree for the first item using pull data exchange based on the receive native event and the at least one synthetic event; andproviding, by the pedigree data processing system, the electronic pedigree to a first downstream partner pedigree system.2. The method of claim 1 , wherein the first item has an ...

COLUMN BASED DATA TRANSFER IN EXTRACT, TRANSFORM AND LOAD (ETL) SYSTEMS

Executing a plurality of transform stages in an extract, transform and load (ETL) job including, for each of the transform stages, receiving a plurality of input row identifiers (RIDs) corresponding to a first plurality of source database table rows in a source database table. Data is retrieved directly from a subset of the source database table columns in the first plurality of source database table rows based on the input RIDs and transform logic. Partial row data including data from the subset of the source database table columns is generated for each of the first plurality of source database table rows. Transformed data is generated based on the partial row data and to the transform logic. Output RIDs corresponding to a second plurality of rows in the source database table that include a least a subset of the transformed data are output to a downstream stage. 1. A method comprising: receiving, from an upstream stage, a plurality of input row identifiers (RIDs) corresponding to a first plurality of source database table rows in the source database table;', 'retrieving data directly from a subset of the source database table columns in the first plurality of source database table rows in the source database table, the retrieving responsive to the input RIDs and to transform logic associated with the transform stage;', 'generating partial row data for each of the first plurality of source database table rows, the partial row data comprising data from the subset of the source database table columns;', 'generating transformed data responsive to the partial row data and to the transform logic; and', 'outputting, to a downstream stage, a plurality of output RIDs corresponding to a second plurality of source database table rows that include at least a subset of the transformed data., 'executing a plurality of transform stages in an extract, transform and load (ETL) job, the ETL job including an extract stage and a load stage in addition to the plurality of transform ...

Cloud Logistics

Implementations of complex software solutions are accompanied with an intrinsic conflict between requirements, such as an ever-growing complexity of enterprise software solutions versus a demand for more and more shortened implementation cycles. Various embodiments include at least one of systems methods and software to address such conflicts. One method embodiment includes receiving a request to assemble a virtual appliance from at least one deployment template, the request including characteristic data representative of at least one virtual appliance functional and deployment requirement. In response to the received request, such embodiments may query a template warehouse to identify and deployment templates from a template warehouse to a data storage device to form a virtual appliance. The virtual appliance may then be packaged into a transport data structure and stored. The transport data structure may then be transported by various means to a target virtual machine and deployed therein.

SYSTEMS AND METHODS FOR ARBITRARY DATA TRANSFORMATIONS

Methods for organizing data. The methods may comprise the step of receiving a write request comprising a data unit. The methods may also comprise the steps of organizing the data unit into a sub-file and incorporating the sub-file into a data file according to a log-structured organization system. In addition, the methods may include the step of writing the data file to a data storage according to a second organization system. 121-. (canceled)22. A computer system comprising:at least one processor;non-transitory memory operatively associated with the at least one processor; and execute an application;', receive a first read request originating from the application and specifying a first sub-file, wherein the first sub-file is selected from a plurality of sub-files logically and physically organized within a first data file of the plurality of data files according to a log-structured file system;', 'in response to the first read request, derive an indication of the first data file;', 'direct a second read request to the data storage device, wherein the second read request indicates the first data file;', 'receive the first data file from the data storage device in response to the second read request;', 'extract the first sub-file from the first data file utilizing the log-structured file system;', 'return the first sub-file in response to the first read request;', 'receive a first write request originating from the application, wherein the first write request indicates a logical grouping of at least one data unit;', 'organize the logical grouping of at least one data unit into a second sub-file;', 'organize the second sub-file into a second data file of the first file system according to the log-structured file system; and', 'transmit a second write request to the data storage device for storage of the second data file on the data storage device according to the first file system., 'execute a data transformation module, wherein the data transformation module is ...

EMBEDDING AND RETRIEVING DATA IN AN APPLICATION FILE FORMAT

Third party data embedding may be provided. Data associated with a third party provider may be saved in a native application save file. If a save file opened by the application is determined to comprise third party data, the application may determine whether an appropriate data provider is available. The application may connect to the data provider and provide on-demand, asynchronous access to the third party data upon request from a user. 1opening the application file associated with an application, wherein the file comprises a third party data segment; 'in response to determining that the data provider is available, establishing a connection between the application and the data provider.', 'determining whether a data provider associated with the third party data segment is available; and'}. A method for embedding data in an application file, the method comprising: The present application is a continuation of U.S. patent application Ser. No. 12/605,126, filed Oct. 29, 2009, now U.S. Pat. No. 8,429,118 entitled Embedding and Retrieving Data in an Application File Format, which is assigned to the assignee of the present application, and hereby incorporated by reference.Embedding and retrieving data in an application file format is an extensible process for storing data in a work file without the application needing to understand the content and/or the format of the data. In some situations, users have no way to move and/or access data from an external data source. For example, data may be stored in an online database and inaccessible while working offline. If manipulating the data comprises complex, multi-dimensional queries such as Online Analytical Processing (OLAP), large amounts of data may need to be stored and/or managed separately from other working data. This conventional strategy may cause problems as the management of separate data files may cause distribution and synchronization issues, especially if the data is part of a collaboration project. Furthermore ...

Method for Operating an Automation Device

A method for operating an automation device, into the memory of which an automation solution has been loaded, wherein a technology-oriented control interpreter accesses a data warehouse of the automation solution, and is able to control external commands by virtue of such commands being analyzed and being implemented according to the analysis, where the technology-oriented control interpreter extracts at least one entity designation and at least one instruction from a respective command, the technology-oriented control interpreter searches for an object matching the entity designation in the data warehouse of the automation solution and, in the event of success, checks whether the instruction contained in the command has been defined for the found object, and where the technology-oriented control interpreter causes execution of the instruction for the found object. 1. A method for operating an automation device having a memory , comprising:loading an automation solution into the memory;accessing a data warehouse of the automation solution by a technology-oriented control interpreter;analyzing, by the technology-oriented control interpreter, external commands and implementing said external commands according to said analysis to control the external commands;extracting, by the technology-oriented control interpreter, at least one entity designation and at least one instruction from a respective external command;searching, by the technology-oriented control interpreter, for an object matching the at least one entity designation in the data warehouse of the automation solution;checking whether the instruction contained in the command has been defined for the located object in an event of successfully locating the object matching the at least one entity designation in the data warehouse of the automation solution; andexecuting, via the technology-oriented control interpreter, the instruction for the located object.2. The method as claimed in claim 1 , wherein the data ...

Defining and Mapping Application Interface Semantics

An example implementation includes a system having one or more processors, a definition module, a data store, and a workflow module. The definition module is executable by the one or more processors to determine a first semantic element for a first operation included in a first application interface representing a first service and a second semantic element for a second operation included in a second application interface representing a second service, such as an enterprise service bus. The definition module may further determine a mapping of the first semantic element with the second sematic element. The data store is configured to store the mapping of the first semantic element with the second sematic element by the definition module. The workflow module is executable by the one or more processors to integrate the first application interface with the second service based on the mapping. 1. A computer-implemented method comprising:determining, using one or more computing devices, a first semantic element for a first operation included in a first application interface representing a first service;determining, using the one or more computing devices, a second semantic element for a second operation included in a second application interface representing a second service;mapping, using the one or more computing devices, the first semantic element with the second sematic element; andintegrating, using the one or more computing devices, the first application interface with the second service based on the mapping.2. The computer-implemented method of claim 1 , wherein the second service includes one of an enterprise service bus claim 1 , an extract-transform-load framework claim 1 , and a gateway.3. The computer-implemented method of claim 1 , wherein the first semantic element includes a field associated with an input message of the first operation claim 1 , and the second semantic element includes a field associated with one of an output message and an error message of ...

Method and System for Analyzing Data Related to an Event

A system and method for analyzing data from a plurality of computer environments. A user may search for computer environments that meet a certain criterion. The computer environments are authenticated and data is copied from the computer environments to a memory location. The data may be marked so that a user may determine which computer environment provided the data. The user may add notations to the data during a review. Changes to data on the computer environments may be provided to a user using a syndication feed. 1. A method of analyzing data related to an event comprising:(a) copying a plurality of files from a plurality of storage devices to a memory location;(b) converting the plurality of files to a predetermined unified format;(c) analyzing the plurality of files; and(d) providing a report to a user based on the analysis.2. The method of wherein analyzing the data comprises sorting the data using a variable.3. The method of wherein the event is a user request.4. The method of wherein the event is a response to an incident.5. The method of wherein analyzing the data comprises sorting the data into data groups based on one or more variables.6. The method of comprising comparing the data groups and providing a report to the user showing the union of two groups.7. The method of comprising comparing the data groups and providing a report to the user showing the intersection of two groups.8. The method of comprising comparing the data groups and providing a report to the user showing the difference between two groups.9. The method of comprising comparing the data groups and providing a report to the user showing the similarities between two groups.10. The method of wherein the report comprises a list of the plurality of files.1165-. (canceled) As more businesses and governmental entities increasingly rely on computer networks to conduct their operations and store relevant data, security of these networks has become increasingly important. The need for increased ...

Method and System for Analyzing Data Related to an Event

A system and method for analyzing data from a plurality of computer environments. A user may search for computer environments that meet a certain criterion. The computer environments are authenticated and data is copied from the computer environments to a memory location. The data may be marked so that a user may determine which computer environment provided the data. The user may add notations to the data during a review. Changes to data on the computer environments may be provided to a user using a syndication feed. 110-. (canceled)11. A method of analyzing data comprising:(a) receiving a search request from a user;(b) searching for storage devices according to the search request;(c) searching for data on the storage devices according to the search request;(d) copying the data to a memory location;(e) converting the data to a user-defined format;(f) analyzing the data; and(g) providing a report to the user based on the analyzing of the data.12. The method of wherein the storage devices are coupled to a user computer through a network.13. The method of wherein the user-defined format is extensible markup language.14. The method of further comprising storing the data in a database.15. The method of wherein analyzing the data comprises searching the data for a user-defined variable.16. The method of wherein the user-defined variable is a file type.17. The method of wherein the user-defined variable is a bit string.18. The method of wherein analyzing the data comprises creating a plurality of groups of data according to a plurality of user-defined variables.19. The method of further comprising comparing the groups.20. A system for analyzing data comprising:(a) means for receiving a search request from a user;(b) means for searching for storage devices according to the search request;(c) means for searching for data on the storage devices according to the search request;(d) means for copying the data to a memory location;(e) means for converting the data to a user- ...

IN-QUERYING DATA CLEANSING WITH SEMANTIC STANDARDIZATION

The present invention relates to data cleansing, and in particular performing the semantic standardization process within a database before the transform portion of the extract-transform-load (ETL) process. Provided are a method, system and computer program product for standardizing data within a database engine, configuring the standardization function to determine at least one standardized value for at least one data value by applying the standardization table in a context of at least one data value, receiving a database query identifying the standardization function, at least one database value and the context of the data, and invoking the standardization function. 1. A system comprising: a processor; and a memory containing program code which when executed by the processor is configured to perform an operation , comprising:receiving at least one standardization table, wherein each standardization table comprises a first column containing a plurality of text representations of a standard text and a second column containing the standardized text; andupon receiving a database query identifying a standardization function and at least one data value to be converted to a standard value, converting the at least one data value to a standard value by invoking the standardization function within a database engine, wherein the standardization function uses the at least one standardization table and a context of the at least one data value to convert the at least one data value to the standard value.2. The system of wherein the standardization function is a user defined function.3. The system of claim 2 , wherein the user defined function receives the context of a least one data value as a parameter.4. The system of claim 2 , wherein the user defined function further comprises:determining a context of the data value.5. The system of claim 4 , wherein determining the context further comprises:accessing one or more metadata values describing the data value; anddetermining the ...

System and Method for Data Anonymization Using Hierarchical Data Clustering and Perturbation

A system and method for data anonymization using hierarchical data clustering and perturbation is provided. The system includes a computer system and an anonymization program executed by the computer system. The system converts the data of a high-dimensional dataset to a normalized vector space and applies clustering and perturbation techniques to anonymize the data. The conversion results in each record of the dataset being converted into a normalized vector that can be compared to other vectors. The vectors are divided into disjointed, small-sized clusters using hierarchical clustering processes. Multi-level clustering can be performed using suitable algorithms at different clustering levels. The records within each cluster are then perturbed such that the statistical properties of the clusters remain unchanged. 1. A system for data anonymization comprising:a computer system for electronically receiving an original dataset and allowing a user to specify a relative importance of at least one attribute of the dataset; and a vector space mapping sub-process for converting each record of the original dataset to a normalized vector that can be compared to other vectors;', 'a hierarchical clustering sub-process for dividing the normalized vectors into disjointed k-sized groups of similar records based on a hierarchical clustering technique;', 'a perturbation sub-process for generating anonymized clusters from individual clusters generated by the hierarchical clustering sub-process; and', 'an original domain mapping sub-process to combine and remap anonymized clusters back to an original domain of the original dataset., 'an anonymization program executed by the computer system for producing an anonymized dataset from the original dataset, the anonymization program executing2. The system of claim 1 , wherein the original dataset is a high-dimensional dataset containing record-level data.3. The system of claim 1 , wherein the vector space mapping sub-process executes a ...

BIG DATA ANALYTICS SYSTEM

A big data analytics system obtains a plurality of manufacturing parameters associated with a manufacturing facility. The big data analytics system identifies first real-time data from a plurality of data sources to store in memory-resident storage based on the plurality of manufacturing parameters. The plurality of data sources are associated with the manufacturing facility. The big data analytics system obtains second real-time data from the plurality of data sources to store in distributed storage based on the plurality of manufacturing parameters. 1. A method comprising:obtaining a plurality of manufacturing parameters associated with a manufacturing facility;identifying, by a computing system comprising a processing device, first real-time data from a plurality of data sources to store in memory-resident storage based on the plurality of manufacturing parameters, wherein the plurality of data sources are associated with the manufacturing facility; andidentifying, by the computing system, second real-time data from the plurality of data sources to store in distributed storage based on the plurality of manufacturing parameters.2. The method of claim 1 , wherein the plurality of manufacturing parameters are associated with an event claim 1 , and further comprising:obtaining a subset of the first real-time data from the memory-resident storage upon the occurrence of the event;determining whether additional data is needed to analyze the event; andobtaining the additional data upon determining that the additional data is needed to analyze the event, wherein the additional data is obtained from the memory-resident storage if the additional data is stored in the memory-resident storage, and wherein the additional data is obtained from the distributed storage if the additional data is not stored in the memory-resident storage.3. The method of claim 1 , further comprising:creating a graphical representation for the first real-time data based on the plurality of ...

DETECTING REFERENCE DATA TABLES IN EXTRACT-TRANSFORM-LOAD PROCESSES

A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data. 1. A computer-implemented method for identifying reference data tables in an extract-transform-load data integration process comprising:identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables; andevaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table, wherein a reference data table contains a set of values that describes other data.2. The computer-implemented method of claim 1 , further comprising:upon determining that the first table is a reference data table based on the score exceeding a predetermined threshold, loading the first table into a data store.3. The computer-implemented method of claim 1 , further comprising:presenting the first table to a user; andupon receiving user input specifying that the first table is a reference data table, loading the first table into a data store.4. The computer-implemented method of claim 1 , wherein identifying at least the first reference data operator comprises determining whether the first ...

AUTOMATED DATA ANALYSIS AND TRANSFORMATION

A transformation method and system is provided. The method includes generating a data hub application configured to embed extract, transform, and load (ETL) processes. The data hub application is linked to source tables and target tables. Meta data associated with the source and target tables is transferred from virtual views of the data hub application to an ETL work area of the ETL processes. An ETL job is generated and linked to the data hub application. ETL processes are executed and results are determined. 1. A method comprising:linking, by a computer processor of a data hub, source tables and target tables to a data hub application configured to embed, extract, transform, and load (ETL) processes;associating, by said computer processor, said source tables and said target tables to a local sensitive hashing (LSH) program comprising target flags;transferring, by said computer processor, metadata associated with said source tables and said target tables from virtual views of said data hub application to an ETL work area of said ETL processes, wherein said metadata comprises table definition metadata published to a DS tool comprising said source tables and said target tables;linking, by said computer processor, ETL job to said data hub application;executing, by said computer processor executing a data hub scheduler application, said ETL processes;determining, by said computer processor, results of said executing, wherein said results indicate that said executing was not successful; and analyzing, by said computer processor, a log file pattern indicating a reason that said executing was not successful;', 'decoding, by said computer processor, said log file pattern;', 'generating, by said computer processor, a change script based on a category of said log file pattern, wherein said change script comprises an exception routine associated with non-classified categories;', 'notifying, by said computer processor, users of said changes to said metadata and said change ...

DATABASE QUERY LANGUAGE GATEWAY

A method includes receiving a query request, generating a modified query in a database query language by modifying a stored query in the database query language based on the query request, and transmitting the modified query to a database endpoint. The method includes receiving query results in the database query language and converting by the processor the query results from the database query language to a format usable by a reporting engine. 1. A method comprising:receiving a query request;generating, by a processor, a modified query in a database query language by modifying a stored query in the database query language based on the query request;transmitting the modified query to a database endpoint;receiving query results in the database query language; andconverting by the processor the query results from the database query language to a format usable by a reporting engine.2. The method of claim 1 , wherein the query request is received in a Reportable Representational State Transfer (REST) format.3. The method of claim 1 , wherein the database query language is SPARQL Protocol and RDF Query Language (SPARQL).4. The method of claim 3 , further comprising:querying RDF data in an RDF triples database based on the SPARQL query.5. The method of claim 1 , wherein the query request includes a request URI claim 1 ,receiving the query request includes parsing, with the processor, parameters of the request URI defined by a Reportable Representational State Transfer (REST) specification, the parameters defining filtering conditions, andgenerating, by the processor, the modified query includes transforming the parameters into SPARQL graph patterns and adding the SPARQL graph patterns to a SPARQL query to generate a modified SPARQL query. The present application is a continuation of U.S. patent application Ser. No. 13/494,153, filed Jun. 12, 2012 which is hereby incorporated by reference in its entirety.The present invention relates to a database query language gateway, ...

Method, Program and System for Generating RDF Expressions

A system and method of generating RDF expression. The system receives a URI from a tool using linked data, and identifies an object to become a seed from the URI. Next, the appropriate mapping file is identified from the type of object, and type information is generated from this. The generated type information is referenced, and objects are collected following recursively from the seed. The system sends a graph of the collected objects to an RDF converter. The RDF converter references the mapping file, and converts the object graph into RDF, which is then outputted. 1. A computer implemented method for converting URI to RDF , comprising the steps of:receiving a URI;identifying an object to become a seed from the URI;generating type information from the type of the object in a mapping file;collecting the necessary objects from an object repository by referencing the generated type information;passing the collected objects to an RDF converter; andhaving the RDF converter reference the information of the mapping file to convert the collected objects to RDF.2. The method according to claim 1 , wherein the mapping file includes the pattern of the RDF to be generated claim 1 , and the types claim 1 , names claim 1 , and property names of the objects needed for RDF generation.3. The method according to claim 1 , wherein the step for generating type information further comprises the steps of:acquiring a prioritized list of the targeted type from type information referenced by the mapping file; andacquiring a property name list for objects to follow in the mapping file in the prioritized list of the targeted type.4. The method according to claim 1 , wherein the object repository is XML files and the mapping file is XSLT.5. A non-transitory computer readable storage medium tangibly embodying a computer readable program code having computer readable instructions which claim 1 , when implemented claim 1 , cause a computer to carry out the steps of a method for converting URI ...

AQUATIC GEOGRAPHIC INFORMATION SYSTEM

A method of processing geo-statistical data includes preparing a data log, extracting acoustic data and coordinate data from the data log, and aligning the acoustic data and the coordinate data. The method also includes cleaning and aggregating the coordinate data, validating the coordinate data geospatially, and creating an output. 1. A method of processing geo-statistical data , the method comprising:preparing a data log of geo-statistical data from a monitoring system;extracting acoustic data and coordinate data from the data log;aligning the acoustic data and the coordinate data;cleaning and aggregating the coordinate data;validating the coordinate data geospatially; andcreating an output.2. The method of claim 1 , wherein the output is a contour map.3. The method of claim 1 , wherein the coordinate data is combined with additional coordinate data prior to creating the output.4. The method of claim 3 , wherein the additional coordinate data includes a first set of additional coordinate data and a second set of additional coordinate data.5. The method of claim 1 , wherein the output is a contour map of a water body having a plurality of depth ranges claim 1 , the method further comprising:correlating a water body parameter to at least one of the depth ranges.6. The method of claim 1 , wherein the output is a contour map of a water body having a plurality of depth ranges claim 1 , the method further comprising:correlating a water body parameter to each depth range.7. The method of claim 1 , wherein creating the output comprises:creating a first contour map with a first plurality of depth ranges from the coordinate data; andcreating a second contour map with a second plurality of depth ranges from the coordinate data.8. The method of claim 7 , wherein the first plurality of depth ranges are differentiated by 0.30 meters and the second plurality of depth ranges are differentiated by 0.91 meters.9. The method of claim 1 , wherein creating the output comprises: ...

RELATIVISTIC CONCEPT MEASURING SYSTEM FOR DATA CLUSTERING

A method and apparatus for mapping concepts and attributes to distance fields via rvachev-functions. The steps including generating, for a plurality of objects, equations representing boundaries of attributes for each respective object, converting, for a plurality of objects, the equations into greater than or equal to zero type inequalities, generating, for a plurality of objects, a logical expression combining regions of space defined by the inequalities into a semantic entity, and substituting, for a plurality of objects, the logical expression with a corresponding rvachev-function such that the resulting rvachev-function is equal to 0 on a boundary of the semantic entity, greater then 0 inside a region of the semantic entity, and less then 0 outside the region of the semantic entity. Also included is the step of generating a composite rvachev-function representing logical statements corresponding to the plurality of objects using the respective rvachev-functions of the objects. 1. (canceled)2. A method of generating , within a quantum-mechanical framework , an implicit structure to derive conclusions about data having an implicit structure , comprising:obtaining the data having the implicit structure;representing a superposition of the data by a superposition of multiple fields, the representation of the superposition corresponding to a representation of an entanglement state;collapsing the entanglement state by solving respective distance field functions using a particularly programmed computing device;measuring distances between points within the collapsed entanglement state to generate the structure; andderiving a similarity of a first piece of the data to a second piece of the data from the generated structure based on the measured distances.3. The method according to claim 2 , wherein the distance field functions are Rvachev-functions.4. The method according to claim 2 , wherein the particularly programmed computing device utilizes quantum computing to ...

SYSTEMS AND METHODS FOR COLLECTION AND CONSOLIDATION OF HETEROGENEOUS REMOTE BUSINESS DATA USING DYNAMIC DATA HANDLING

Remote data collection systems and methods retrieve data including financial, sales, marketing, operational and the like data from a plurality of databases and database types remotely over a network in an automated, platform-agnostic manner. An Extract Transform and Load (ETL) data replication method for Chart of Account (COA) standardization includes receiving a request for remote data collection to extract data from a data source; extracting data in a non-intrusive manner from the data source, wherein the data comprises non-standard COA data; and transforming one of an entire set or a subset of the extracted data based on the request based on a template or a standardized form desired for comparisons. 1. An Extract Transform and Load (ETL) data replication method for Chart of Account (COA) standardization , comprising:receiving a request for remote data collection to extract data from a data source;extracting data in a non-intrusive manner from the data source, wherein the data comprises non-standard COA data; andtransforming one of an entire set or a subset of the extracted data based on the request based on a template or a standardized form desired for comparisons.2. The ETL data replication method of claim 1 , further comprising:extracting the data using a two phase process comprising a reconciliation phase and a collection phase.3. The ETL data replication method of claim 1 , further comprising:performing the transforming as an agent side process, a server side process, or an automated client side process.4. The ETL data replication method of claim 1 , further comprising:reforming the data as the non-standard COA data so the extracted data conforms to a new standard.5. The ETL data replication method of claim 1 , further comprising:generating read only mapped views on the extracted data using a standard COA without modifying underlying data source.6. The ETL data replication method of claim 1 , further comprising:presenting a graphical user interface of a ...

Uniform Data Model and API for Representation and Processing of Semantic Data

In some implementations, a method includes receiving a first data set that is stored using a first format, generating an info item based on the first data set, the info item representing an entity extracted from the first data set, generating a delta item based on the first data set, the delta item including a reference to the info item and defining a context-based modification of the info item, generating a second data set in a second format comprising the info item and the delta item, and storing the second data set to the computer-readable storage medium. 120.-. (canceled)21. A method of importing data to a computer-readable storage medium , comprising:receiving a first data set provided in a first format corresponding to a first data model; and [ generating a delta item based on the first data set, the delta item including a reference to a source info item and a context-based modification of the source info item,', 'in response to performing the context-based modification to the source info item, setting a property type of the source info item to point to the delta item, wherein the delta item is associated with a subset of attributes of the source info item, and', 'storing the third data set to the computer-readable storage medium; and, 'transforming the first data set to a third data set provided in a third format corresponding to a unified data model, the third format comprising a quadruple schema including subject, context, predicate and object, the unified data model comprising source info items, target info items, delta items and context items, transforming comprising, 'generating the second data set based on the third data set., 'processing the first data set to generate a second data set provided in a second format corresponding to a second data model, the first data model being incompatible with the second data model, wherein processing the first data set comprises22. The method of claim 21 , further comprising providing a property specification ...

APPARATUS, SYSTEM AND METHOD FOR DATA COLLECTION, IMPORT AND MODELING

A method of and system for data analysis, including interrogating a plurality of computer systems to generate for each computer system at least one dump file, each dump file including configuration and state information; extracting predetermined configuration and state information from the respective dump files; and storing the extracted configuration and state information in a database in a normalized format. 1. A method of data analysis , the method comprising:interrogating a plurality of computer systems to generate at least one dump file for each computer system, each dump file comprising configuration and state information;extracting predetermined configuration and state information from the respective dump files; andstoring the extracted configuration and state information in a database in a normalized format.2. A method according to claim 1 , further comprising:transforming the predetermined configuration and state information to the normalized format from a format that is at least one of vendor and product specific.3. A method according to claim 1 , wherein interrogating a plurality of computer systems to generate at least one dump file for each computer system comprises:using a collector tool to query each computer system using the computer system's native interface.4. A method according to claim 3 , wherein at least one said native interface comprises a standard command line interface and the respective collector tool is adapted to run a predetermined series of commands.5. A method according to claim 3 , wherein extracting predetermined configuration and state information from the respective dump files and storing the extracted configuration and state information in the database in the normalized format comprises:using an importer tool, the importer tool being arranged to extract the predetermined configuration and state information from the dump files, transform the extracted information into the normalized format, and store the transformed information in ...

CUSTOM OBJECT-IN-MEMORY FORMAT IN DATA GRID NETWORK APPLIANCE

Techniques are disclosed for implementing custom object-in-memory formats in a data grid network appliance. The techniques include maintaining a record of format definitions on a client device of the data grid and a corresponding record of format definitions on a server device of the data grid. Each format definition may indicate one or more attributes of an object class and data types and byte ranges of the attributes. The client device may serialize one or more objects for storage in the data grid based on respective format definitions associated with the one or more objects and retrieved from the record of format definitions maintained on the client device. Further, the server device may perform one or more data grid operations using format definitions retrieved from the record of format definitions maintained on the server device. 1. A computer-implemented method for implementing custom object-in-memory formats in a data grid network appliance , comprising:maintaining, via one or more processors, a record of format definitions on a client device of a data grid and a corresponding record of format definitions on a server device of the data grid, each format definition indicating one or more attributes of an object-oriented programming object class and data types and byte ranges of the attributes;serializing, by the client device, one or more objects for storage in the data grid based on corresponding format definitions associated with the one or more objects and retrieved from the record of format definitions maintained on the client device; andperforming one or more data grid operations by the server device using format definitions retrieved from the record of format definitions maintained on the server device.2. The method of claim 1 , wherein the serializing the one or more objects includes claim 1 , for each object claim 1 , extracting values of attributes from the object in the order specified in the corresponding format definition associated with the object ...

Cross-Platform Compiler for Data Transforms

Techniques for automatically partitioning a multi-platform data transform flow graph to one or more target output platforms are provided. The techniques include performing type inference on a transform graph, wherein the transform graph comprises one or more data transforms, automatically partitioning the transform graph to one or more target output platforms based on one or more policies, performing an optimization of the partitioned transform graph, and generating code, from the partitioned transform graph, for each set of the one or more data transforms based on the one or more target output platforms. 1. A method for automatically partitioning a multi-platform data transform flow graph to one or more target output platforms , wherein the method comprises:performing type inference on a transform graph, wherein the transform graph comprises one or more data transforms;automatically partitioning the transform graph to one or more target output platforms based on one or more policies;performing an optimization of the partitioned transform graph; andgenerating code, from the partitioned transform graph, for each set of the one or more data transforms based on the one or more target output platforms.2. The method of claim 1 , wherein generating code comprises generating adapter code to facilitate data flow between the one or more target output platforms.3. The method of claim 1 , wherein performing an optimization of the partitioned transform graph comprises fusing one or more of the one or more data transforms if fusing of one or more data transforms is appropriate.4. The method of claim 1 , wherein performing type inference on a transform graph comprises parsing one or more entity types from at least one of a database schema and one or more virtual stream descriptions.5. The method of claim 1 , wherein performing type inference on a transform graph comprises determining each input and output schema for all one or more data transforms.6. The method of claim 1 , ...

COMPRESSED SET REPRESENTATION FOR SETS AS MEASURES IN OLAP CUBES

A cardinality of an incoming data stream is maintained in real time; the cardinality is maintained in a data structure that is represented by an unsorted list at low cardinalities, a linear counter at medium cardinalities, and a PCSA at high cardinalities. The conversion to the linear counter makes use of the data in the unsorted list, after which that data is discarded. The conversion to the PCSA uses only the data in the linear counter. 1. A method for storing a cardinality of a plurality of unique items of data in a received data stream , the method comprising:storing, in a computer memory, unique data items in the form of an unsorted list;when the number of unique items stored in the computer memory crosses a first threshold, converting the items in the unsorted list into a linear counter executable by a processor, discarding the unsorted list from the computer memory, and causing the processor to count further unique items in the received data stream using the linear counter; andwhen the number of unique items stored in the computer memory crosses a second threshold, converting the data in the linear counter into a PCSA structure or log-log counter, discarding the linear counter from the computer memory, and causing the processor to count further unique items in the received data stream using the PCSA structure or log-log counter.2. The method of claim 1 , wherein the first threshold is 1 claim 1 ,024 elements and the second threshold is 20 claim 1 ,000 elements.3. The method of claim 1 , wherein the unsorted list claim 1 , linear counter claim 1 , and PCSA or log-log counter use the same memory footprint.4. The method of claim 3 , wherein a size of the memory footprint is less than approximately four kilobytes.5. The method of claim 1 , wherein converting the data in the linear counter into the PCSA structure comprises inserting a plurality of random numbers into the PCSA structure.6. The method of claim 5 , wherein the plurality of random numbers has a size ...

Integrating Data Transform Test with Data Transform Tool

Embodiments relate to integrating data transform test with a data transform tool. A method and system are described for creating a data transform test for a data transform job having a data transform script, the method includes determining all data transform units available in the data transform job, determining a subset of the available data transform units for a new test, and generating a subset test execution script for the subset of data transform units from the data transform script. The method further includes determining boundary test data at each boundary of the subset of data transform units, defining a data transform test, and saving the data transform test for later testing. The data transform test includes the subset of data transform units with subset test execution script and with boundary test data.

METHODS AND SYSTEMS FOR DISPLAYING AND FILTERING BUSINESS ANALYTICS DATA STORED IN THE CLOUD

In accordance with disclosed embodiments, there are provided methods, systems, and apparatuses for displaying and filtering business analytics data stored in the cloud, including, for example, means for displaying a graphical interface at a client device; communicating a business analytics query from the client device to a remote host organization via a public Internet; receiving a business analytics dataset in a complete and unfiltered form from the host organization responsive to the business analytics query; caching the business analytics dataset in its complete and unfiltered form to the memory of the client device; displaying a business analytics report at the graphical interface of the client device, the business analytics report representative of the business analytics dataset in its complete and unfiltered form; receiving filter input at the client device; applying the filter input to the business analytics dataset to yield a filtered sub-set; and updating the business analytics report displayed at the graphical interface using the filtered sub-set of the business analytics dataset. Other related embodiments are disclosed. 1. A method at a client device having at least a processor and a memory therein , wherein the method comprises:displaying a graphical interface at the client device;communicating a business analytics query from the client device to a remote host organization via a public Internet;receiving a business analytics dataset in a complete and unfiltered form from the host organization responsive to the business analytics query;caching the business analytics dataset in its complete and unfiltered form to the memory of the client device;displaying a business analytics report at the graphical interface of the client device, the business analytics report representative of the business analytics dataset in its complete and unfiltered form;receiving filter input at the client device;applying the filter input to the business analytics dataset to yield a ...

WAVEFRONT MUXING AND DEMUXING FOR CLOUD DATA STORAGE AND TRANSPORT

Security on data storage and transport are important concerns on cloud computing. Wavefront multiplexing/demultiplexing process (WF muxing/demuxing) embodying an architecture that utilizes multi-dimensional waveforms has found applications in data storage and transport on cloud. Multiple data sets are preprocessed by WF muxing before stored/transported. WF muxed data is aggregated data from multiple data sets that have been “customized processed” and disassembled into any scalable number of sets of processed data, with each set being stored on a storage site. The original data is reassembled via WF demuxing after retrieving a lesser but scalable number of WF muxed data sets. In short, the WF muxed data storage solution enhances data security and data redundancy by, respectively, creating a new dimension to existing security/privacy methods and significantly reducing the storage space needed for data redundancy. In addition, WF muxing/demuxing methods enable a monitoring capability on the integrity of stored data. 1. A data storage method comprising:transforming multiple first data sets into multiple second data sets, wherein one of said second data sets comprises a weighted sum of said first data sets; andstoring said second data sets in an IP cloud via Internet.2. The data storage method of claim 1 , wherein the number of said first data sets is equal to the number of said second data sets.3. The data storage method of claim 1 , wherein one of said first data sets comprises a known data set.4. The data storage method of claim 1 , wherein one of said first data sets is grounded.5. The data storage method of claim 1 , wherein said transforming said first data sets into said second data sets comprises performing an orthogonal matrix transform.6. The data storage method of claim 1 , wherein said transforming said first data sets into said second data sets comprises performing a Hadamard transform.7. The data storage method of claim 1 , wherein said transforming said ...

ENHANCING PERFORMANCE OF EXTRACT, TRANSFORM, AND LOAD (ETL) JOBS

A computer receives one or more files having configuration information that includes data that defines a plurality of stages of an extract, transform, and load (ETL) job, wherein the plurality of stages comprise a read stage that is preceded by a write stage, and wherein the read stage reads data from a source location, and wherein the data that is read or a modified version of the data that is read is being written by the write stage that writes data to the source location. The computer replaces the read stage with a decompressor stage. The computer replaces the write stage with a compressor stage. The computer executes the decompressor stage and compressor stage on a field-programmable gate array that is programmatically customized with data compression and data decompression functionality to enhance the performance of the ETL job. 1. A computer implemented method for accelerating a read stage and a write stage of an extract , transform , and load job comprising:receiving one or more files having configuration information that includes data that defines a plurality of stages of at least one extract, transform, and load (ETL) job, wherein the plurality of stages comprise a read stage that is preceded by a write stage, and wherein the read stage reads data from a source location, and wherein the data that is read or a modified version of the data that is read is being written by the write stage that writes data to the source location;identifying the read stage and the write stage within the one or more files, wherein the read stage and write stage each have a first parameter that represents a name of a stage, and wherein the first parameter is associated with a second parameter that represents a type of stage;replacing the read stage with a decompressor stage that reads data from a hard disk, decompresses the data from the hard disk and passes the data that is decompressed to another stage or to a computer program for further processing, wherein the decompressor ...

INFORMATION PROCESSING SYSTEM, DATA MANAGEMENT METHOD, INFORMATION PROCESSING APPARATUS, AND CONTROL METHOD AND CONTROL PROGRAM THEREFOR

Provided is an information processing apparatus including a file input unit that inputs a data model file representing a data model in a first language for data model description; a first generation unit that generates a database configuration file described in a second language for database description from the data model file; and a second generation unit that generates an application interface described in a third language for application interface description from the data model file. 1. An information processing apparatus comprising:a file input unit that inputs a data model file representing a data model in a first language for data model description;a first generation unit that generates a database configuration file described in a second language for database description from the data model file; anda second generation unit that generates an application interface described in a third language for application interface description from the data model file.2. The information processing apparatus according to claim 1 , wherein the first language is an extensible markup language (XML).3. The information processing apparatus according to claim 1 , wherein the second language is a structured query language (SQL).4. The information processing apparatus according to claim 1 , wherein the third language is a web services description language (WSDL).5. The information processing apparatus according to claim 1 , further comprising:a creation unit that creates a database from the database configuration file of the second language which is generated by the first generation unit; anda device interface that collects data to be accumulated in the generated database from a device connected to the information processing apparatus,wherein the application interface searches for the data accumulated in the database and sends desired data to an application, in response to a data request through a predetermined protocol from the application to the information processing apparatus. ...

DISTRIBUTED, REAL-TIME ONLINE ANALYTICAL PROCESSING (OLAP)

Source data of an event stream is parsed and supplemented with additional data from reference data sources, producing an enriched event stream from the parsed event stream data. The data records of the enriched event stream are partitioned into data fields designated as a dimension partition and a metric partition, which are partitioned into sub-dimension projections mapped to a plurality of storage keys, such that each of the storage keys includes one or more placeholder wildcard values and each of the storage keys is stored into a database of the computer system by the computer processor. The stored storage keys are then aggregated onto a two-dimensional coordinate vector such that, if the computer processor identifies a permuted storage key having metric values for which a corresponding storage key already exists in the database, then the computer processor aggregates the metric values of the identified storage key with the metric values of the corresponding storage key, and if the computer processor does not identify the permuted storage key as having a corresponding storage key that already exists in the database, then the computer processor writes the metric values of the permuted storage key into the database, comprising initial values for the key combination of dimension values. 1. A method of online analytical processing (OLAP) of a computer system , the method comprising:enriching a data record read from a source database of the computer system by a computer processor with one or more enriched data fields comprising data read from a reference database by the computer processor, wherein the data record includes multiple data fields, such that the enriched data record includes one or more of the multiple data fields of the data record and one or more of the enriched data fields;partitioning the multiple data fields of the enriched data record into a dimension partition and a metric partition;permuting the dimension partition and the metric partition of the ...

LOCAL EXTREMA BASED DATA SAMPLING SYSTEM

A computing device sorts a plurality of data points in a first dimension. A first data point has a first value, a second data point has a second value, and a third data point has a third value defined in a second dimension. (a) The second value is compared to the first and third values. (b) When the second value is less than the first value and greater than the third value, or the second value is greater than the first value and less than the third value, the data point is deleted. (c) The first data point is defined as the second data point. (d) The second data point is defined as the third data point. (e) The third data point is defined as a next data point. (a)-(e) are repeated until each of the plurality of data points is defined as the third data point to define a plurality of sampled data points as remaining data points of the plurality of data points. 1. A non-transitory computer-readable medium having stored thereon computer-readable instructions that when executed by a computing device cause the computing device to:read a plurality of data points from a dataset, wherein each data point of the plurality of data points is defined in a first dimension and a second dimension, wherein the plurality of data points are sorted in the first dimension;{'sub': '1y', '(a) define a first data point from the read plurality of data points, wherein the first data point has a first value (V) defined in the second dimension;'}{'sub': '2y', '(b) define a second data point from the read plurality of data points, wherein the second data point has a second value (V) defined in the second dimension;'}{'sub': '3y', '(c) define a third data point from the read plurality of data points, wherein the third data point has a third value (V) defined in the second dimension;'}{'sub': 2y', '1y', '2y', '3y', '2y', '1y', '2y', '3y, '(d) determine whether the second data point is a local minima or a local maxima, wherein the second data point is the local minima when V Подробнее

STORING AND PROCESSING DATA ORGANIZED AS FLEXIBLE RECORDS

A system and method are disclosed for persisting data received from disparate data sources having different internal schemas. In operation, a data processing engine aggregates related data received from the different data sources and organizes the aggregated data into flexible records. A flexible record is a composite of associated fields aggregated from a set of records received from one or more data sources. Each field associated with a flexible record includes data received from a particular data source and specifies the particular data source as the source of the data. Flexible records are stored in a storage repository, and each flexible record is associated with at least one user who accesses data via a client device. 1. A method for persisting data received from different data sources , the method comprising:receiving, at a data aggregation server, data from a plurality of data sources having a plurality of schemas, the data including a plurality of data fields, and at least two of the data fields being structured according to different schema of the plurality of schema;aggregating a subset of the plurality of data fields that are relevant to an object stored by the data aggregation server;generating a record identifier associated with the object;generating a different insert event associated with each data field of the aggregated subset of data fields, each insert event including a value corresponding to the associated data field;storing each insert event in a different row of an operation log, each row including the record identifier, a field name corresponding to the data field associated with the insert event stored in the row, the value corresponding to the data field, and a timestamp of when the insert event occurred;receiving, from a client device, a first data request for accessing a value corresponding to a data field of the aggregated subset of data fields;transmitting, to the client device, the value included in the identified row in response to ...

SYSTEM AND METHOD FOR DYNAMIC DATA ARCHIVAL AND PURGING

An interface receives a user request associated with a first set of data. A processor determines whether the user request comprises a request to archive the first set of data. Upon a determination that the user request comprises a request to archive the first set of data, the processor facilitates retrieving archive rules, applies the archives rules to determines a first archive code for execution, and archives the first set of data based on the first archive code. 1. A system , comprising:an interface operable to receive a user request associated with a first set of data; and determine whether the user request comprises a request to archive the first set of data; and', facilitate retrieving archive rules;', 'apply the archive rules to determine a first archive code for execution; and', 'archive the first set of data based on the first archive code., 'upon a determination that the user request comprises a request to archive the first set of data], 'a processor operable to2. The system of claim 1 , further comprising: determine whether the user request comprises a request to purge the first set of data; and', 'upon a determination that the user request comprises a request to purge the first set of data:', 'facilitate retrieving purge rules;', 'apply the purge rules to determine a purge code for execution; and', 'purge the first set of data based on the purge code., 'the processor further operable to3. The system of claim 1 , wherein the archive code identifies the first set of data by metadata.4. The system of claim 1 , further comprising:the interface further operable to retrieve purge rules; and apply the purge rules to determine a purge code for execution; and', 'purge the archived data based on the purge code, the archived data purged after a predetermined time., 'the processor further operable to5. The system of claim 1 , wherein the first set of data comprises information related to a call received by a call center.6. The system of claim 1 , further comprising: ...

SYSTEM FOR AUTOMATING DATA VALIDATION

Embodiments of the invention are directed to systems, methods, and computer program products for automating data validation. The system is configured to receive the initial data set in the first data structure from a network of distributed servers; transform the initial data set into an expected data set having the second data structure using a first mapping logic; use the expected data set to validate a converted data set that was generated by converting the initial data set into the second data structure using a second mapping logic; and transmit control signals configured to cause a user device associated with the user to receive a notification indicating that the match is within the pre-determined tolerance level. 1. A system for automating data validation of data that has been converted from an initial data set having a first data structure to a converted data set having a second data structure during a data conversion procedure , the system comprising:one or more memory devices;one or more processing devices operatively coupled to the one or more memory devices; and receive the initial data set in the first data structure from a network of distributed servers;', 'transform the initial data set into an expected data set having the second data structure using a first mapping logic, wherein transforming further comprises mapping one or more fields associated with the initial data set into one or more fields associated with the expected data set, wherein the transformed data is stored in a database as the expected data set;', receiving the converted data set;', 'comparing the one or more fields associated with the expected data set with one or more fields associated with the converted data set;', 'determining a match between the one or more fields associated with the expected data set and the one or more fields associated with the converted data set based on at least the comparison; and', 'determining that the match between the one or more fields associated with ...

Systems and methods for type coercion

Systems and methods for converting a data item provided by an external data provider system into a data type specified by a data processing system for a data field of the data item. A data processing system stores a coercion rule for each data field of a first data set provided by the data provider system. Each stored coercion rule identifies at least one data type for the corresponding data field. Responsive to a second data set provided by the data provider system, the data processing system coerces each data item of the second data set into at least one data type specified by the stored coercion rule for the data field of the data item to generate at least one converted data item of the second data set. The data processing system generates information from at least one converted data item, and provides the information to a consuming system.

METADATA MANAGER FOR ANALYTICS SYSTEM

A metadata management system receives metadata changes and automatically updates a metadata architecture which maps the data. The metadata changes may be received through a simple user interface by a user or administrator. Once received, the system may automatically update schemas and data transformation code to process data according to the new data mapping preference. The system may handle metadata updates in a multi-tenant system having one or more applications per tenant, and may update data for a single tenant and 1 or more tenant applications in a multitenancy. 1. A method for managing metadata , the method comprising:maintaining data in a data collection store, wherein the data in the data collection store corresponds to a first format associated with a tenant application at a client device;receiving a portion selection over a computer network interface from the client device, wherein the portion selection identifies at least one portion of the maintained data and is selected via a user interface of the client device;transforming the at least one portion of the maintained data from the first format into a second format according to the received portion selection, wherein the transformed data in the second format is stored in a data repository according to a schema that associates an object name to the second format data stored in the data repository; andperforming analytics on the data in the second format that is associated with the object name, wherein results of the analytics are output for display on the user device.2. The method of claim 1 , wherein the received portion selection include changes in metadata selections.3. The method of claim 2 , wherein the transformation of the at least one portion from the first format to the second format is performed in accordance with the changes in the metadata selections.4. The method of claim 1 , wherein the transformation of the at least one portion from the first format to the second format includes splitting ...

DATA MANAGEMENT METHOD, DATA MANAGEMENT DEVICE AND STORAGE MEDIUM

A data management method employing the results of an analysis of data stored in a storage unit of a computer provided with a processor and a storage unit, wherein the computer generates an analysis data set by selecting data stored in the storage unit, subjects the analysis data set to prescribed data mining, extracts a model from the analysis data set, converts the model into a relational table, and associates the relational table with a dimension table and a history table that have been stored in advance in the storage unit. 1. A data management method using results of analyzing data stored in a storage module by a computer comprising a processor and the storage module , the data management method comprising:a first step of selecting, by the computer, data stored in the storage module, and generating, a data set for analysis;a second step of performing, by the computer, prescribed data mining on the data set for analysis, and extracting, a model from the data set for analysis;a third step of converting, by the computer, the model to a relational table; anda fourth step of associating, by the computer, with a dimension table and a history table stored in advance in the storage module in association with the relational table.2. The data management method according to claim 1 , wherein claim 1 , in the second step claim 1 , either a decision tree or clustering is executed as the data mining claim 1 , and the model is extracted from the decision tree and clustering results.3. The data management method according to claim 2 ,wherein, in the clustering, specific attributes of the data set for analysis are separated into clusters on the basis of distances between data points, andwherein, in the third step, a tree structure is converted to SQL on the basis of results of separating the data points into clusters to generate the relational table.4. The data management method according to claim 2 ,wherein the decision tree extracts a model that can predict specific attributes ...

Integrated Application Server and Data Server Processes with Matching Data Formats

In one embodiment, the present invention includes a computer-implemented method comprising storing data in an application using an application custom data type and application custom data structure. The data is stored in a database using the application custom data type and the application custom data structure. In one embodiment, a request is sent to access the data from the application to the database. The data is retrieved from the database in response to the request in the application custom data type and the application custom data structure. In one embodiment, the data is sent from the database to a shared memory in the application custom data type and the application custom data structure and the data is retrieved by the application from the shared memory in the application custom data type and the application custom data structure. 1. A computer-implemented method comprising:storing data from an application operating on an application server in an application format defined by an application custom data type and an application custom data structure in an in-memory database operating on a database server, the database server further comprising a hard disk drive storing other data in a database format that is different from the application format;retrieving the data from the in-memory database in response to a request to access the data;storing the data from the in-memory database in a shared memory;accessing the data from the shared memory for use in the application;receiving the application custom data structure in the in-memory database;transforming the other data stored in the hard disk drive from the database format to the application format using the application custom data structure processed by an in-memory database engine; andsending the transformed other data from the database to the shared memory in the application format.2. The method of wherein the application server and the database server are virtual machines.3. The method of wherein the shared ...

FACILITATING DATA SCIENCE OPERATIONS

The present disclosure is directed to performing data science operations. In particular, the present disclosure relates to a data science system that improves data science operations as well as enhances a user's experience in performing data science operations. For example, the data science system provides an improved framework that enables a data source to be paired with one or more algorithms to create a data science operation. In many instances, the data science operation outputs visual results, such as charts and graphs, that are easy for the user to understand. Further, using the framework, the data science system provides tools that enable the user to further customize data science operations. 1. In a digital environment for performing data science operations , a method of creating data science operations , the method comprising:providing, via a user interface, a list of data sources;providing, via the user interface, a list of data science algorithms; a data source from the list of data sources; and', 'a data science algorithm from the list of data science algorithms;, 'receiving, based on user input, a selection ofidentifying reusable algorithm building blocks from the data science algorithm;generating, by at least one processor, a data science operation by pairing data from the data source with the identified reusable algorithm building blocks from the data science algorithm;executing, by the at least one processor, the generated data science operation to generate a data science result; andproviding, via the user interface, a visualization of the data science result.2. The method as recited in claim 1 , wherein identifying reusable algorithm building blocks comprises identifying a component descriptor for the selected data science algorithm claim 1 , and wherein the component descriptor provides annotations that facilitate paring the data from the data source with the selected data science algorithm to generate the data science operation.3. The method as ...

Methods and apparatus related to data processing

In one general aspect, a non-transitory computer-readable storage medium can be configured to store instructions that when executed cause a processor to perform a process. The process can include receiving, at a first conversion block, a first set of parameter values associated with a user identifier, and receiving, at a second conversion block, a second set of parameter values associated with the user identifier. The first conversion block and the second conversion block can be included in a library of conversion blocks. The first conversion block and the second conversion block can be selected from a library of conversion blocks and defining a unit.

Non-transitory computer-readable recording medium recoding log obtaining program, log obtaining device, and log obtaining method

A non-transitory computer-readable recording medium recoding a log obtaining program that causes a computer to execute processing, the processing includes: obtaining first log data including request source identification information which is used for identifying a request, a response time period related to the request, and a first log record time, from among a plurality of log data included in an access log recorded in a storage; extracting second log data including a second log record time corresponding to a time that is early by the response time period as compared with the first log record time included in the first log data, from among the plurality of log data; and obtaining third log data including the request source identification included in the first log data from among the second log data.

Timers in stateless architecture

A front end logic instance of a network function in a stateless architecture of a telecommunications network. The logic instance comprises a logic performer configured to perform network function logic to carry out at least part of a network function of the telecommunications network, the logic performer being configured to control a transmitter and receiver for transmission and reception of data with a backend database during performance of the network function logic. The logic instance comprises a timer subscriber configured to control the transmitter to transmit a request to the backend database to be notified about a timer event relating to a timer run on the backend database, the request comprising data indicating the timer event. The receiver is further configured to receive a notification that the timer event has occurred.

ADAPTIVE USER-INTERFACE ASSEMBLING AND RENDERING

Methods, systems, and computer program products are provided for dynamic and adaptive user-interface component selection for rendering in distributed applications. An adaptive user-interface component selection system is enabled to select user-interface components for rendering and display on a client device running an instance of a client application. User-interface components are selected based on a set of applicable component rules. Applicable component rules are determined based on client feedback information that includes information regarding the client including: network bandwidth, geolocation, user role, user context and required application features. Selected user-interface components are transformed into renderable code either locally to the system or remotely at the client device, and rendered and displayed on the client device. 1. An adaptive user-interface component selection system for an application , comprising:a feedback database for storing information regarding a client device upon which an instance of the application is executing;a user-interface component database containing user-interface components;a component rule database containing user-interface component selection rules;one or more processors; and based at least in part on the information regarding the client device, retrieve at least one component rule from the component rule database;', 'based on the at least one component rule, select user-interface components to include in or to omit from the user-interface of the instance of the application, and based on the selected user-interface components, retrieve at least one user-interface component from the user-interface component database;', 'based on the at least one component rule, determine whether the at least one user-interface component should be assembled locally by the system, or assembled remotely by the client device;', 'in response to determining the at least one user-interface component should be assembled locally, assemble the ...

Application aware input/output fencing

Disclosed herein are methods, systems, and processes to perform application aware input/output (I/O) fencing operations. Performing such an application aware I/O fencing operation includes installing an identifier that identifies an instance of an application with a node on which the instance of the application is executing, on coordination points. A weight assigned to the instance of the application is determined, and the instance of the application is terminated based on the weight.

APPLICATION AWARE INPUT/OUTPUT FENCING

Disclosed herein are methods, systems, and processes to perform application aware input/output (I/O) fencing operations. A determination is made that a cluster has been partitioned. The cluster includes multiple nodes. As a result of the partitioning, the nodes are split between a first network partition with a first set of nodes and a second network partition with a second set of nodes. Another determination is made that instances of an application are executing on the first set of nodes and the second set of nodes. An application aware I/O fencing operation is then performed that causes termination of instances of the application executing on the first set of nodes or on the second set of nodes. 1. A method comprising: the cluster comprises a plurality of nodes, and', 'as a result of the partitioning, the plurality of nodes are split between a first network partition comprising a first set of nodes of the plurality of nodes and a second network partition comprising a second set of nodes of the plurality of nodes;, 'determining that a cluster has been partitioned, wherein'}determining that a plurality of instances of an application are executing on the first set of nodes and the second set of nodes; and 'the performing the application fencing operation causes termination of instances of the application executing on the first set of nodes or on the second set of nodes.', 'performing an application fencing operation, wherein'}2. The method of claim 1 , further comprising: [ 'the application weight matrix comprises a weight assigned to the application, and', 'accessing an application weight matrix, wherein'}, 'comparing a first total application weight of the first set of nodes and a second total application weight of the second set of nodes., 'performing the fencing race comprises, at least in part,'}, 'performing a fencing race, wherein'}3. The method of claim 2 , further comprising:bypassing the fencing race, if all instances of the application are executing on the ...

Systems, Methods, Software, and Interfaces for Formatting Legal Citations

The present disclosure is directed towards a citation formatting system and a method for operating an online research service for providing legal citations. The exemplary system provides the citation formatting function in a client-server architecture, receiving citations from a user's client access device over a computer network and communicating citation format suggestions back to the client access device for possible insertion into a document on the access device. 1. A citation formatting system associated with facilitating legal research , the system comprising:a database including a plurality of law-related documents associated with legal research;a citation data structure including one or more formatted citations associated with at least one of the law-related documents, the citation data structure being indexed and including a document identifier logically associated with at least a first citation formatted according to a citation standard, the citation standard being based on one or more of a bluebook standard, ALWD standard, and citation format preference associated with a user; and retrieve a citation using a citation-finder module, from a word-processing document of a client access device, the retrieved citation associated with a specific law-related document;', 'determine whether the specific law-related document represented by the retrieved citation exists in the database using a citation-identifier module which parses at least a portion of the formatted citation, the citation-identifier module integrating with the word-processing document;', 'transmit at least a portion of the formatted citation to a citation-formatter module for retrieving citation data from law-related documents corresponding to at least one of the retrieved citations;', 'determine, using the citation-formatter module, whether the specific law-related document represented by the formatted citation matches an existing law-related document in the database;', 'transmit an error message ...

Field types defined via custom metadata types

In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing field types which are defined via custom metadata types within a computing environment. An exemplary system may include, for example: means for operating a database system within the computing architecture to store a plurality of objects; creating a custom metadata type by specifying at least (i) a name for the custom metadata type, (ii) one or more fields to contain configuration information for the custom metadata type, and (iii) at least one relationship field having fields as its domain relating the custom metadata type to a column or field of an object stored in the database system; creating a custom datatype by specifying at least (i) a name for the custom datatype, (ii) a base datatype available from the database system, and (iii) the custom metadata type; executing application code at the computing architecture, wherein the application code evaluates one or more objects referenced by the application code to identify one or more fields of the objects to identify a field of an object expressly declared as having a datatype corresponding to the custom datatype; and retrieving, via the application code, the configuration information for use by the application code. Other related embodiments are disclosed.

Packaging Data Science Operations

The present disclosure relates to a data science system that packages data science operations. The data science system packages a data science operation with a component descriptor or service descriptor to allow the data science system to easily apply and execute the data science operations using data from a variety sources. As described herein, the data science system also enables a user to provide data science packages to a marketplace as well as retrieve data science packages created by other users from the marketplace. Further, the data science system can customize a data science package obtained from the marketplace to perform data science operations using data belonging to the user or using user-specified parameters. 1. In a digital environment for performing data science operations , a method of packaging data science algorithms for network-based deployment , the method comprising:obtaining, by at least one processor, a data science operation comprising a data science algorithm and referenced data from a data source;analyzing the data science operation to identify required parameters and optional parameters of the data science algorithm;determining, based on the referenced data from the data source, a data type required for the data science algorithm; andgenerating a component descriptor for the data science operation comprising the data type, the required parameters, and the optional parameters, wherein the component descriptor allows the data science operation to be applied to and executed with data from another data source.2. The method as recited in claim 1 , wherein a parameter of the required parameters and optional parameters is a tunable parameter claim 1 , and wherein a tunable parameter is a parameter that is interchangeable with data from the another data source or a parameter that is modifiable through user input.3. The method as recited in claim 1 , wherein generating the component descriptor comprises generating a metadata container that ...

On-demand database catalog upgrade

Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects.

ON-DEMAND DATABASE CATALOG UPGRADE

Upgrading a database while the database is accessible to applications. Specifically, the database upgrade is performed selectively as per demand from system catalog tables. With this on-demand technique, the upgrade of a database is run on a need basis to upgrade, over time, all the catalog objects. 1performing a selective upgrade of a database instance from a first version of a database to a second version of the database, wherein the selective upgrade causes the database instance to refer to the second version of the database, and the selective upgrade does not modify, in the database instance, a reference to a first system catalog table and a second catalog table of the first version;receiving a first request from an application to access the first system catalog table and a second request from another application to access the second system catalog table;identifying a first set of rows in the first system catalog table by searching every row of the first system catalog table, the first set of rows matching requirements of the first request;identifying a second set of rows in the second system catalog table by searching every row of the second system catalog table, the second set of rows matching requirements of the second request; and making the first and second sets of rows compatible with the second version of the database; and', 'updating the first and second sets of rows to refer to the second version of the database instead of the first version;, 'modifying, while the database instance referring to the second version of the database is running, the first set of rows and the second set of rows to match corresponding sets of rows of the second version of the database by performing, for the first and second sets of rows, implicit catalog row conversion includingwherein:the database instance includes processes and memory structures of a database engine.. A method comprising: The present invention relates generally to the field of database management, and more ...

System performance logging of complex remote query processor query operations

Described are methods, systems and computer readable media for performance logging of complex query operations.

Methods and Systems for Using Script Files to Obtain, Format and Transport Data

Embodiments of the invention can include a system and method for managing a plurality of data feeds to be loaded into a database. The method includes obtaining a script which specifies a query. The method includes executing the query against a source to extract a result set and consulting the script to determine a format for the data feed. The method also includes converting the result set in accordance with the format to create the data feed and transporting the data feed to be loaded into the database. 21. A system for managing a plurality of data feeds to a user device from a database , the system comprising:a server configured to generate a request for a result set;a database server coupled to the server and receiving the request, the database server including a commander module for executing a query against the database, the server calling the database server in order to invoke the commander module to execute predefined statements and return a result set to the database server;the server accessing a conversion module upon receiving the result set, the conversion module providing instructions to convert the result set to a readable format and to transmit the result set in a readable format to the user device, wherein the database server transmits the result set to the user device in response to the instructions.22. The system of claim 21 , further comprising a script file accessed by the server claim 21 , the script file containing instructions for creating claim 21 , formatting claim 21 , and forwarding a data feed.23. The system of claim 22 , wherein the script file includes a name of the database to access.24. The system of claim 21 , wherein the database server queries the database with predefined SQL commands.25. The system of claim 21 , further comprising a front-end system allowing configuration of the data requests.26. The system of claim 25 , further comprising a data driven web site at the front-end system receiving the result set.27. The system of ...

DATA CLASSIFICATION WORKFLOWS IMPLEMENTED WITH DYNAMICALLY MODIFIABLE DIRECTED GRAPHS

Various embodiments include a classification platform system. A user can define a classification experiment on the classification platform system. For example, the user can define an input data space by selecting at least one of data sources interfaced with the classification platform system and defining a directed graph (DG) connecting a plurality of transformation blocks to represent an experiment workflow. The DG can specify how one or more outputs of each of the transformation blocks are fed into one or more other transformation blocks. At least one of the transformation block can dynamically modify the DG. The classification platform system can schedule the experiment workflow to be executed on a distributed computation platform according to the input data space and the DG. 1. A computer-implemented method , comprising: defining an input data space by selecting at least one of data sources interfaced with the classification platform system; and', 'defining, via a definition user interface, a directed graph (DG) connecting a plurality of transformation blocks to represent an experiment workflow, wherein the DG specifies how one or more outputs of each of the transformation blocks are fed into one or more other transformation blocks and wherein at least one of the plurality of transformation blocks in the DG includes logic to dynamically modify the DG during execution of the experiment workflow;, 'defining a classification experiment in a classification platform system by at leastscheduling a distributed computation platform to execute the classification experiment according to the input data space and the DG; andimperatively programming computing nodes of the distributed computation platform to execute the transformation blocks according to the logic that dynamically modifies the DG during the execution of the experiment workflow.2. The computer-implemented method of claim 1 , further comprising:formatting the DG and the input data space into a data structure ...

Data generation method and computer system

A computer includes a data generation unit and a storage unit which retains graph information for managing a graph configured from a plurality of vertexes and sides. The data generation unit performs acquiring a plurality of data and graph information and assuring storage regions in number equal to the number of vertexes, converting each data into an input value and setting at least one input value to a storage region corresponding to at least one vertex, executing an updating process for updating a value set to a storage region corresponding to a first vertex using the value set to the storage region corresponding to the first vertex and a value set to a storage region corresponding to a different vertex directly connected to the first vertex, and outputting a set of values set to the storage regions corresponding to the vertexes as the feature value.

DYNAMIC NETWORK DATABASE INTEGRATION SYSTEM

Embodiments of the present invention relate to apparatuses, systems, methods and computer program products for dynamic network database integration. Specifically, the system typically provides dynamic correlation, transformation and combination of data stored at a plurality of database locations. In some aspects, the system receives a retrieval request for retrieving one or more records. The system then typically retrieves, transforms and dynamically integrates unstructured data stored at disparate database locations to construct one or more structured records. The system may also construct the one or more structured records such that the one or more structured records are compatible with the user interface of the user device application API. The system may also be configured to facilitate dynamic modification of the retrieval request, in run-time, using custom HTTP headers. 1. A computerized system for dynamic network database integration , wherein the computerized system is configured for dynamic correlation , transformation and combination of data stored at a plurality of database locations , comprising:a memory device with computer-readable program code stored thereon;a communication device, wherein the communication device is configured to establish operative communication with a plurality of networked devices via a communication network; [ receiving a plurality of data elements to be integrated for each of the one or more records; and', 'receiving a data element transformation structure for integrating the plurality of data elements;, 'receive, from a user device, a retrieval request for retrieving one or more records, wherein receiving the retrieval request comprises, 'determine that (i) first unstructured data associated with a first data element of the plurality of data elements is stored at a first database location associated with a first application programming interface (API) and (ii) second unstructured data associated with a second data element of the ...

DISTRIBUTED DATA PROCESSING IN MULTI-TENANT ENVIRONMENTS

Methods, systems, and devices for data processing within a distributed data system are described. In a multi-tenant distributed data system, a provider may supply executable code for processing data using declarative processing instructions received from a tenant. For example, a tenant may provide tenant-specific processing instructions for a requested set of data. The processing instructions may indicate input information (e.g., a data structure, tenant-specific fields, etc.), transformation information (e.g., from a set of pre-defined transformations), and output information. The provider-supplied code may use the tenant-specific processing instructions to process and generate the requested set of data, where the code may be executed by multiple nodes within the system. As such, the code executed by multiple nodes may utilize the input information, transformation information, and output information from the tenant-specific processing instructions to generate the requested data and provide the data to the tenant. 1. A method for data processing within a multi-tenant distributed data system , comprising:receiving, from a tenant user device, tenant-specific processing instructions for a requested set of data, the tenant-specific processing instructions comprising input information, transformation information, and output information, wherein the input information comprises one or more custom fields specific to the tenant user device and a data structure for the requested set of data, and wherein the transformation information is from a pre-defined set of possible transformations;identifying, from the multi-tenant distributed data system, data that the tenant has access to based at least in part on a tenant identity (ID) associated with the tenant user device, wherein the data that the tenant has access to is used to generate the requested set of data;receiving, from a provider user device, code that is executable to process the requested set of data using the tenant- ...

COMPUTERIZED METHODS AND PROGRAMS FOR INGESTING DATA FROM A RELATIONAL DATABASE INTO A DATA LAKE

A computerized method for ingesting data from a relational database into a data lake is provided, wherein a user-defined function (UDF) is associated with a standard operation of extract, transform, load, or ETL, of an ETL pipeline. This UDF is triggered upon performing the standard operation and thereby allow a code associated with the UDF to be executed. Upon migrating data from one or more data sources into the relational database, the standard operation is executed, which triggers the UDF and, in turn, an execution of the code. As per the execution of this code, an entity running on the data lake is notified that a set of data migrated to the relational database is to be ingested according to given ingestion modalities specified by the code. Finally, the set of data can be ingested into the data lake according to the modalities. Related computer program products are also provided. 1. A computerized method for ingesting data from a relational database into a data lake , the method comprising:providing a relational database, wherein a user-defined function, or UDF, is associated with a standard operation of extract, transform, load, or ETL, of an ETL pipeline, so as for the UDF to be triggered upon performing said standard operation and thereby allow a code associated with said UDF to be executed;migrating data from one or more data sources into the relational database, according to said ETL pipeline, whereby said standard operation is executed so as to trigger said UDF and, in turn, an execution of said code;as per the execution of said code, notifying an entity running on the data lake that a set of data migrated to said relational database is to be ingested according to given ingestion modalities specified by the code; andingesting said set of data into the data lake according to said modalities.2. The computerized method according to claim 1 , wherein whether said set of data may be ingested in parallel;', 'whether said set of data should be appended to data ...

MANAGEMENT OF EXTRACT TRANSFORM LOAD (ETL) JOBS VIA A MODEL THAT IS BASED ON A BAYESIAN NETWORK

A device may receive, from a user device, a request for a set of forecasts of an extract transform load (ETL) completion time for a group of ETL jobs associated with an organization. The device may obtain a set of performance indicators associated with the group of ETL jobs. The device may filter the set of performance indicators using one or more filtering techniques. The device may generate the set of forecasts of the ETL completion time by using a data model to process the set of performance indicators and/or a set of assumptions associated with a set of recommendations for reducing the ETL completion time. The device may provide the set of forecasts of the ETL completion time to the user device. The device may perform one or more actions that cause the ETL system to execute the group of ETL jobs within a threshold completion time. 1. A device , comprising:one or more memories; and [ 'wherein an ETL system is to execute the group of ETL jobs at particular time periods;', 'receive, from a user device, a request for a set of forecasts of an extract transform load (ETL) completion time for a group of ETL jobs associated with an organization,'}, a first subset of performance indicators relating to system performance of the ETL system supporting the group of ETL jobs,', 'a second subset of performance indicators relating to transactional performance of the group of ETL jobs, or', 'a third subset of performance indicators relating to source data generated from the group of ETL jobs;, 'wherein the set of performance indicators include at least one of, 'obtain a set of performance indicators associated with the group of ETL jobs,'}, 'generate, by processing the set of performance indicators, a set of recommendations that are capable of reducing the ETL completion time;', [ historical source data,', 'a set of historical performance indicators,', 'historical ETL completion time data, or', 'historical network modifications data, and, 'wherein the data model has been trained ...

AUTOLAYOUT OF VISUALIZATIONS BASED ON CONTRACT MAPS

In an example, a method may include receiving input effective to select a visualization type of multiple different visualization types to apply to a visualization of data. The selected visualization type may be associated with a contract. Each of the different visualization types may be associated with a specific contract. Each contract may include a corresponding schema that specifies a set of data fields and one or more relationships between data fields in the set to generate and display a corresponding visualization having a corresponding visualization type. The method may also include mapping at least some data of a data source to the contract such that the contract is satisfied. The method may also include displaying the visualization of the at least some data of the data source based on the contract, the displayed visualization having the selected visualization type. 1. A method to generate a visualization of data from a data source based on a contract , the method comprising: the selected visualization type is associated with a contract;', 'each of the plurality of different visualization types is associated with a specific contract of a plurality of contracts; and', 'each corresponding contract includes a corresponding schema that specifies a set of data fields and one or more relationships between the data fields in the set to generate and display a corresponding visualization having a corresponding visualization type;, 'receiving input effective to select a visualization type of a plurality of different visualization types to apply to a visualization of data, whereinmapping at least some data of a data source to the contract such that the contract is satisfied; anddisplaying the visualization of the at least some data of the data source based on the contract, the displayed visualization having the selected visualization type.2. The method of claim 1 , wherein:the mapping comprises identifying a plurality of specific data from a plurality of different data ...

DYNAMIC INCREMENTAL UPDATING OF DATA CUBES

Systems and methods for dynamic incremental updating of online analytical processing (OLAP) data cubes are disclosed. In embodiments, a computer-implemented method, comprises: receiving real-time transactional event data including a plurality of data fields; identifying aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing OLAP data in the form of numeric values organized in fields; incrementally calculating the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of the plurality of data fields; repeating the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube; and updating the updated aggregated field database with the updated field data. 1. A computer-implemented method , comprising:receiving real-time transactional event data from one or more remote transaction computing devices, the real-time transactional event data including a plurality of data fields containing values;identifying aggregate computing functions for each of a plurality of standard query language (SQL) queries of a target data cube to be updated, wherein the target data cube is in a multidimensional form for storing online analytical processing (OLAP) data in the form of numeric values organized in fields;incrementally calculating the aggregate computing functions based on a current aggregated value obtained from an updated aggregated field database, and a value of one of the plurality of data fields;repeating the incremental calculation for each of the plurality of SQL queries to obtain updated field data for the target data cube; andupdating the updated aggregated field database with the updated field data,wherein the receiving the real-time transactional event data and the incrementally calculating ...

Prediction integration for data management platforms

Techniques are described for integrating prediction capabilities from data management platforms into applications. Implementations employ a data science platform (DSP) that operates in conjunction with a data management solution (e.g., a data hub). The DSP can be used to orchestrate data pipelines using various machine learning (ML) algorithms and/or data preparation functions. The data hub can also provide various orchestration and data pipelining capabilities to receive and handle data from various types of data sources, such as databases, data warehouses, other data storage solutions, internet-of-things (IoT) platforms, social networks, and/or other data sources. In some examples, users such as data engineers and/or others may use the implementations described herein to handle the orchestration of data into a data management platform.

SIGN LANGUAGE IMAGE INPUT METHOD AND DEVICE

A sign language image input method and a device are illustrated. The sign language image input method is provided for a computer device which has a database. The database has a plurality of sign language images, wherein each of the sign language images correspondingly has a code combination. Steps of the sign language image input method are described as follows. The computer device generates at least one key combination by pressing a plurality of key blocks which are disposed in the computer device, wherein the key combination is formed based on at least one hand shape, at least one position, and/or at least one hand action of an input sign language image. The key combination is compared with all code combinations of the database. The input sign language image is outputted according to a comparison result of the key combination and the all code combinations. 1. A sign language image input method , used in a computer device , the computer device comprising a database , wherein a plurality of sign language images are stored in the database and each of the sign language images corresponds to a code combination , the sign language image input method comprising:generating at least a key combination via pressing a plurality of key blocks of the computer device, wherein the key combination is set according to at least a hand shape, a position and/or a hand action of an input sign language image;comparing the key combination with the code combinations in the database; andoutputting the input sign language image according to a comparison result of the key combination and the code combinations.2. The sign language image input method according to claim 1 , wherein the step “outputting the input sign language image according to a comparison result of the key combination and the code combinations” further comprises:providing a plurality of sign language image candidates according to the comparison result, wherein the sign language image candidates are the sign language images ...

METHOD AND SYSTEM FOR DESIGNING BUSINESS DOMAIN MODEL, DATA WAREHOUSE MODEL AND MAPPING THEREBETWEEN SYNCHRONOUSLY

Method and system for designing a business domain model, a Data Warehouse (DW) model and a mapping therebetween synchronously are provided. The method includes: designing a business domain model based on business logic; designing a DW model based on a structure of a data cube in a DW and designing a mapping between the business domain model and the DW model synchronously; analyzing the business domain model, the DW model and the mapping therebetween based on a predetermined syntax rule; and generating a transactional database corresponding to the business domain model, a DW database corresponding to the DW model, and a mapping between data in the transactional database and in the DW database automatically and synchronously. The system includes a business domain model design unit, a DW model design unit, a mapping design unit, an analysis unit and an automatic generation unit. Mappings are designed more easily, efficiently and accurately. 1. A method for designing a business domain model , a data warehouse model and a mapping therebetween synchronously , comprising:designing a business domain model based on business logic;designing a data warehouse model based on a structure of a data cube in a data warehouse and designing a mapping relation between the business domain model and the data warehouse model synchronously;analyzing the business domain model, the data warehouse model and the mapping therebetween based on a predetermined syntax rule; andgenerating a transactional database corresponding to the business domain model, a data warehouse database corresponding to the data warehouse model, and a mapping between data in the transactional database and data in the data warehouse database automatically and synchronously.2. The method according to claim 1 , wherein the business domain model comprises at least one object claim 1 , each of the at least one object comprising at least one object element; the data warehouse model comprises one fact table and at least one ...

Methodology supported business intelligence (BI) software and system

The disclosed device provides idealized and reusable data source interfaces. The process of idealizing includes reengineering of an original data model using a surrogate key based model. The technique emphasizes readability and performance of the resulting operational data store. In, addition, the disclosed device provides a unique method for handling changes which allows for all types of changes to be automatically implemented in the operational data store by table conversion. Further the disclosed device provides inline materialization which supports a continuous data flow dependency chain. A continuous dependency chain is used to provide automated documentation as well as a dynamic paralleled transformation process. 1. A method of ensuring consistency between a configured product repository and a destination operational data store when changes to one or more configurations occurs , said method comprising the steps of:creating and maintaining a static reference model further comprising a storing of object information in one or more object extended properties in said operational data store; on a table level, at least one extended property containing a data source table; on a column level, at least one extended property per column created using a primary surrogate key having a static standardized value, a foreign surrogate key having a value of a corresponding external foreign key name, and ordinary columns having a corresponding data source column name; andcomparing one or more repository configurations and definitions with one or more extended properties in said static reference model.2. The method of claim 1 , wherein said comparing of one or more repository configurations and definitions further comprises extracting definitions from said repository and producing a first intermediate internal table claim 1 , extracting definitions from said operational data store and producing a second intermediate internal table claim 1 , comparing said first and said second ...

INTELLIGENT DATABASE CONNECTION MANAGEMENT

According to an aspect of an embodiment of the present disclosure a method of database connection management includes measuring a pattern of database connection use between a database and a client application. The pattern may include a number of database connections used by the client application under multiple conditions and a number of database connections in a connection pool under the plurality of conditions. The method may include identifying a first condition under which an increase in the number of database connections in the connection pool results in a decrease in connection delay. In response to existence of the first condition, the method may include adding a new database connection to the connection pool such that the new database connection is available to the client application in advance of a connection request for the new database connection. 1. A method of database connection management , the method comprising:measuring, by a database connection pool device that is communicative coupled between an application server and a database, a pattern of database connection use between the database and a client application hosted by the application server, the pattern including a number of database connections used by the client application under a plurality of conditions and a number of database connections in a connection pool under the plurality of conditions;identifying, by the database connection pool device, a first condition of the plurality of conditions under which an increase in the number of database connections in the connection pool results in a decrease in connection delay; andin response to existence of the first condition, adding, by the database connection pool device, a new database connection to the connection pool such that the new database connection is available to the client application in advance of a connection request for the new database connection.2. The method of claim 1 , wherein the identifying the first condition includes ...

MULTITHREADED CODE GENERATOR FOR DISTRIBUTED MEMORY SYSTEMS

Each machine runs a single process; in which each process calls a function generated by the SequenceL™ compiler, the generated SequenceL™ function being multi-threaded, allowing the generated SequenceL™ function to run on all of the cores of the machine at once. The user does not have to be concerned about introducing bugs that are difficult to diagnose and correct, and the program does not have the overhead of running many message passing processes on the same machine. 1. Apparatus comprising:a map reduce framework including a map object a shuffle object and a reduction object;a second framework that operates in shared memory having a single memory space shared by multiple processors wherein the processors do not have to be aware of where data to be operated on resides and that receives any number of items, such as floats, arrays, and matrices, processes the data, and outputs a result, during a processing step, parallelizes a process and runs the process across multiple cores in the multiple processors in a shared memory system; the second framework further comprising a mapper object and a reducer object,the mapper object comprising an object method that extends the map object of the map reduce framework to retrieve input data then place the input in framework data structures, and then call map reduce framework methods,the reduction object comprising an object method that extends the map object of the map reduce framework to retrieve input data then place the input in framework data structures, and then call map reduce framework methods.2. The apparatus of wherein the map object of the map reduce framework further comprises:an object method that receives a set of data and a mapper, wherein the mapper includes computer instructions provided by an operator which will operate on one item in a set of data, and that breaks the input data into individual items, and feeding those items, one at a time, to a mapper code, wherein the mapper code is responsible for outputting ...

EMOJI SEARCHING METHOD AND APPARATUS

The present disclosure provides an emoji searching method and apparatus, comprising: receiving an image search text input by a user; converting the image search text input by the user into a words form; obtaining an image search result corresponding to the image search text in the words form; returning the image search result to the user. Use of the technical solutions of embodiments of the present disclosure can avoid problems in the prior art such as failure to recognize emoji-related special characters, search errors, or return of irrelevant results during image search, and can implement understanding of the meaning of emojis and automatic matching with the image search result. This assists users having a habit of inputting emojis in performing image search more conveniently. 1. An emoji searching method , wherein the method comprises:receiving an image search text input by a user;converting the image search text input by the user into a words form;obtaining an image search result corresponding to the image search text in the words form;returning the image search result to the user.2. The emoji searching method according to claim 1 , whereinthe image search text is an emoji; ora text including an emoji and words.3. The emoji searching method according to claim 2 , wherein the converting the image search text input by the user into a words form comprises:detecting whether the image search text input by the user includes an emoji;looking up for a term result corresponding to the emoji included in the image search text input by the user;using the term result to replace the emoji, and converting the image search text including the emoji into the image search text in the words form.4. The emoji searching method according to claim 2 , wherein the detecting whether the image search text input by the user includes an emoji comprises:converting the image search text input by the user into a unicode code; performing regular expression judgment for the unicode code to ...

HEALTHCARE SEMANTIC INTEROPERABILITY PLATFORM

A system and method for efficiently linking local databases having different data formats or standards into a network, wherein a content based router is provided between each of the databases and a network “party line” bus and translates data from the respective database into a common canonical form or format so that all information within the network between the content based routers complies with the common canonical form and are validated according to single standard or mechanism, for example when information first enters the network. Also provided is a tracking or audit mechanism whereby each item of information provided with a unique network identifier when it first enters the network, and is also provided with or associated with a local identifier from each local database that originates or accesses the information item and router identifiers of the content based routers corresponding to those local databases. 136-. (canceled)37. A device comprising:a processor configured to validate data for compliance with a canonical standard in accordance with a metric;a communication port configured to provide a connection between the device and an entity associated with the device; anda memory configured to store a translation key configured to map information between a first form compliant with the canonical standard and a second form compliant with an information standard of the entity associated with the device, transform information that is in the second form into the first form or vice-versa based on the translation key,', 'validate the transformed information in accordance with the metric, and', 'indicate, responsive to a failure of a validation of the transformed information in accordance with the metric, that the translation key is inaccurate., 'wherein the processor is further configured to38. The device of claim 37 , wherein the communication port is further configured to receive a new communication from any of the entities associated with the device claim 37 , ...

CATALOG WITH LOCATION OF VARIABLES FOR DATA

A system may store a plurality of first records comprising a first variable in a first data storage format. The system may also store a plurality of second records comprising a second variable in a second data storage format. The first data storage format may have a different data structure than the second data storage format. The system may then generate a catalog including a first location of the first variable and a second location of the second variable. The first location identifies the first data storage format, which is where the first variable is stored. The second location identifies the second data storage format, which is where the second variable is stored. The system may then receive a request to access at least one of the first variable or the second variable and access the first variable and/or the second variable in response to the request. 1. A method comprising:receiving, by a data management system, a request to access at least one of a first variable or a second variable, wherein the request lacks a first data storage format and a second data storage format;analyzing, by the data management system, a catalog to determine at least one of a first location of the first variable or a second location of the second variable;obtaining, by the data management system, at least one of the first data storage format and a first identifier for the first variable from the first location or the second data storage format and a second identifier for the second variable from the second location; andaccessing, by the data management system, at least one of the first variable from the first location or the second variable from the second location.2. The method of claim 1 , wherein the catalog comprises metadata for the first variable.3. The method of claim 2 , wherein the metadata comprises at least one of a data type claim 2 , a permission claim 2 , a source variable claim 2 , or a timestamp.4. The method of claim 1 , wherein the first data storage format ...

Forecasting System and Method Using Change Data Based Database Storage for Efficient ASP and Web Application

In one embodiment, a system is provided. The system includes a first client. The system also includes an analysis server coupled to the first client. The system further includes a first customer database of information coupled to the analysis server. The first customer database is to embody forecast data and to receive essentially real-time updates to the forecast data. The first customer database supports an OLAP cube associated with the analysis server. 1. A system comprising:an analysis server adapted for coupling to at least an external first client and incorporating an analytics and aggregation unit to analyze and update the information in a first customer database; anda first database of information coupled to the analysis server, the first database embodying forecast data and receiving updates to the forecast data, the analytics and aggregation unit operable to analyze and update the information of at least a first partition of the first database.2. The system of claim 1 , further comprising the at least an external first client.3. The system of claim 1 , wherein the database comprises a customer database storing forecast data for a first customer.4. The system of claim 3 , wherein the database comprises a customer database storing forecast data for a second customer.5. The system of claim 1 , wherein the database is a database shared by a plurality of customers claim 1 , including for a first customer and a second customer.6. The system of claim 1 , wherein the change partition is aggregated by the analysis server.7. The system of claim 1 , wherein the database includes a first partition and a second partition claim 1 , the first partition including change data and the second partition including general data.8. The system of claim 1 , wherein updating the database includes both adding or changing data and calculating the effects of that added or changed data.9. The system of claim 1 , wherein the first partition containing change data may be calculated ...

GEOLOCATION USING REVERSE DOMAIN NAME SERVER INFORMATION

Generating an improved/more accurate geolocation database is provided. Given a dataset of reverse DNS hostnames for IP addresses, ground truth information, and a hierarchical geographical database, a machine learning classifier can be trained to extract and disambiguate location information from the reverse DNS hostnames of IP addresses and to apply machine learning algorithms to determine location candidates and to select a most probable candidate for a reverse DNS hostname based on a confidence score. The classifier can be used to generate an accurate geolocation database, or to provide accurate geolocation information as a service. 1. A system for accurately converting an IP address to a geolocation , comprising:a processing unit; and access a geographical database comprising features associated with a plurality of locations;', 'generate a plurality of dictionaries based on the geographical database, wherein each dictionary is associated with a feature type and comprises a key for matching against a part of a reverse DNS hostname and a value comprising a list of candidate locations that match the key and features extracted from the geographical database for the each candidate location;', receive a reverse DNS hostname as an input; and', 'based on the plurality of dictionaries, generate a list of candidate locations with a corresponding binary label, wherein the label indicates whether the corresponding candidate location is a likely location for the reverse DNS hostname., 'train a classifier using a set of ground truth training data, the ground truth training data comprising IP addresses of which the geolocation is known, wherein the classifier is operative to], 'a memory, including computer readable instructions, which when executed by the processing unit is operative to2. The system of claim 1 , wherein prior to training the classifier claim 1 , the system is further operative to access the ground truth training data claim 1 , wherein in accessing the ground ...