39 results about "Operational database" patented technology

Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In one aspect of the present invention, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional OLAP systems to achieve significant improments in system performance. In accordance with the principles of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distribute data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable. The stand-alone aggregation server of the present invention can be used to realize (i) an improved MDDB for supporting on-line analytical processing (OLAP) operations, (ii) an improved Internet URL Directory for supporting on-line information searching operations by Web-enabled client machines, as well as (iii) diverse types of MDDB-based systems for supporting real-time control of processes in response to complex states of information reflected in the MDDB. In another aspect of the present invention, the apparatus is integrated within a database management system (DBMS). The improved DBMS can be used to realize achieving a significant increase in system performance (e.g. deceased access / search time), user flexibility and ease of use. The improved DBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system, operational database system, or the like.

A robotics process automation platform for developing and managing a workflow is provided. The platform includes development and operational databases stored in a memory, a development interface component, a control interface component, and a runner component. The development interface component is configured for creating a workflow and storing the workflow in the development database. The control interface component is configured for selecting the workflow stored in the development database and storing a copy of the workflow in the operational database. The runner component is configured for receiving instructions from the control interface component to store a copy of the workflow stored in the operational database in a memory of a virtual computing device, and downloading the workflow in the second memory. The runner component is also configured for instructing the virtual computing device to execute the workflow in association with the target application.

An improved method of and apparatus for aggregating data including a high-performance aggregation module (comprising a scalable multi-dimensional database (MDDB)) that is integrated into a database management system (DBMS). The DBMS includes a relational part comprising a relational datastore storing data in tables and support mechanisms. Bi-directional data flow occurs between the relational part and the integrated aggregation module whereby data stored in the relational datastore in loaded into the aggregation module and aggregated data stored in the MDDB of the aggregation module is communicated to the relational part. The improved DBMS can be used to realize achieving a significant increase in system performance (e.g. deceased access / search time), user flexibility and ease of use. The improved DBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system, operational database system, or the like.

An improved method of and apparatus for aggregating data including a scalable multi-dimesional database (MDDB) and a high-performance aggregation engine that are integrated into a database management system (DBMS). The improved DBMS can be used to realize achieving a significant increase in system performance (e.g. deceased access / search time), user flexibility and ease of use. The improved DBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system, operational database system, or the like.

A system and method for managing a fleet of vehicles including a control unit on one or more vehicles in the fleet of vehicles, a data collection unit on one or more vehicles in the fleet of vehicles in communication with the control unit, a server having an operational database for receiving data from one of the control unit and the data collection unit, and a telemetry module having access to the operational database for initiating an action based on an analysis of data on the server.

A system and method for managing and analyzing data stored in an operational database, such as a Sales Force Automation (SFA) database, provides an analysis of changes to the data over time. An analytical database periodically obtaining a snapshot of an operational database. The analytical database identifies changes within the operational database between the snapshots. The analytical database can classify a type of change that has occurred within the operational database, and organize data copied from the database and calculated data indicative of the changes in the database in tables. The analytical database can provide a report containing information regarding changes in the database over time to a multidimensional analysis tool and / or back to the operational database to provide feedback regarding activity that is tracked by the operational database.

A method and computer system for aggregating data from a plurality of operational databases are provided. It is determined if a transformation script stored in storage of a computer system has been modified. Delta data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified. All data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified.

A method and system for routing and processing insurance related data. A data entry operator that receives insurance application-related documents from external sources. The data entry operator stores the documents electronically in a raw data database. A rules engine converts the documents into at least one data element having a common format. The rules engine then determines whether each of the at least one data element has been fully validated as clean data. If the data is verified, the clean data is stored in an operational database for use in application processing. If a data element is not clean, the rules engine generates an exception task. The rules engine then receives a resolution to the exception task, thereby enabling validation of the at least one data element.

The invention discloses a method and system based on a browser for visually dragging and querying data. The method comprises the following steps: step one, an operational database and structure information of the same are extracted; step two, the database and the structure information of the same are obtained in the browser and rendered in WEB pages; step three, graphic components and canvases of query operation are rendered in the browser; step four, users arrange procedures of the query operation in graphical interfaces by dragging configuration; step five, a graphical query flow-process diagram is resolved for SQL statements; step six, the SQL query statements are carried out in the back-end; step seven, query results are output in the browser. The method and system based on the browser for visually dragging and querying the data has the advantages that querying the data in the WEB system is more flexible, and SQL query statement writing is simplified; the current situation that the database query is only carried out by inputting the SQL statement is changed; the use threshold of the system can be lowered, and the query process is arranged in a graphical mode; then the description of establishing the query process becomes clearer and more intuitive, and the learning threshold can be lowered.

The present invention relates to a corporation call center system having real time capabilities, which comprises: (a) storage for at least a portion of the operational database of the corporation; (b) analysis module for analyzing the data of said storage, and forming model tables describing some selling and purchasing pattern of behavior as realized from prior knowledge, and model engine programs for operating with said model tables; (c) model engine programs for: (c.1.) initially, and in real time during a specific interaction with a customer, substituting real values relating to said specific interaction in said model tables, and determining respectively a most valuable parameter for the corporation or a ranking list of most valuable parameters which has to be obtained from said customer, and providing the same to a real time engine for introduction in real time to said customer; and (c.2.) upon receipt of real, value for said most valuable parameter from the customer, determining in real time by using said model tables a most attractive product or a ranking list of most attractive products, and conveying the same to said real time engine for introduction as an offer to said customer; (d) a real time engine for: (d.1.) during said interaction of an agent with a specific customer, receiving from said model engine programs either said most valuable parameter for the corporation or said ranking list of most valuable parameters, and introducing the same as a real time message to the agent for questioning by the agent from the client a real value for the same, and upon receipt of said real value from said agent, conveying it to said model engine programs; (d.2.) receiving from said model engine programs an indication relating to a most attractive product or a ranking list of most attractive products, and initiating in real time a respective message to the agent notifying him to offer the customer one or more of said most attractive products.

The invention provides an alarming method and an alarming system. The alarming method is used for configuring monitoring indexes for an information system, and respectively configuring threshold engine, a policy engine and an alarming engine for various monitoring indexes, and comprises the following steps: collecting data corresponding to various monitoring indexes in the information system, and transmitting the collected data to an operational database; carrying out sorted storing on the collected data by the operational database according to the data type; judging whether the data of various monitoring indexes stored in the operational database are in a threshold range or not according to the threshold engine; when the data of a target monitoring index are not in the threshold range, further judging whether the data of the target monitoring index meet the policy which is set by the target monitoring index in the policy engine or not; and when the data of the target monitoring index meet the policy which is set by the target monitoring index in the policy engine, alarming by virtue of the alarming engine. According to the scheme, the unreasonable monitoring indexes are rapidly reminded.

System and method for completing metadata for a recorded session. A recorder may initiate a recording of a session to produce a recorded session. The recorder may mark the recorded session as an incomplete or bad session. The session may be inserted into a bad sessions list. The bad sessions list may be examined and metadata related to sessions included therein may be used to update an operational database. Other embodiments are described and claimed.

In certain embodiments, a method for implementing one or more business rules in an entity includes receiving a database operation corresponding to one or more database components of one or more operational databases and invoking, in response to receiving the database operation, a rule evaluation service. The rule evaluation service is operable to (1) determine one or more appropriate business rules to evaluate based on the database operation; (2) evaluate the one or more appropriate business rules to determine whether allowing the database operation to be performed will violate any of the one or more business rules; and (3) determine, if it is determined that allowing the database operation to be performed will violate one or more of the evaluated business rules, an appropriate action to initiate for handling the determined violation.

A system for providing assistance to the visually impaired includes: a first image recognition sensor having a first focusing range; a database of images of everyday articles, objects and shapes, each image taken at a distance of about said first focusing range; means for searching and matching an image recognized by said image sensor with an image stored in said database; and an audio chip of an audio database for orally expressing the identity or subject of a first recognized image. The system further includes a second image recognition sensor having a second focusing range; a database of images of everyday articles and shapes, each image taken at a distance of about said second focusing range; means for searching and matching an image recognized by said image sensor at said second range with an image stored in the database of images for said range; and an audio chip of an audio database for orally expressing the identity or subject of an image recognized by the second database. The voice command allows for the user to access the image, audio, GPS, and operational database simultaneously. When the user wishes to identify the object each of these databases will be accessed. If the information cannot be provided the cameras on the glasses will search for the proper operational information. If it cannot be found a signal will be sent requesting a different voice command.

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.

The invention discloses a method and system for evaluating a logistics platform driver credit index based on big data. In the invention, a logistics driver credit system comprises a certificate acquisition system, a platform service system, an operation database system, a BI system and an authority management system, wherein the certificate acquisition system comprises mobile terminal equipment and certificate detection equipment; the operation database system comprise a data storage unit, a data backup unit and a data access unit; and the BI system is connected with a cloud storage system through an information verification and data transmission module. According to the invention, a valuable driver credit index is extracted by means of a big data analysis method and tool according to multi-dimensional long-period driver static and dynamic data accumulated by a logistics information platform for a long time, the efficiency and accuracy of logistics driver credit evaluation are improved, and thus the logistics industry is promoted to develop quickly and healthily.

The invention discloses a system and method for real-time inquiring of train dynamic information. The system comprises a user registration module, a user position sharing module, a train position inquiring module, a train dynamic information displaying module, a train dynamic information push module, a user database, a train operation route space database and a train operation time database. The method comprises the following steps of based on the train operation route space database and the train operation time database, judging the sharing position information of users, so as to form a position sharing information set of the users in a train; through a method of analyzing geographic information, calculating out a geometric center of all the positions, and using the geometric center as the current position of the train; utilizing geometric space analysis, based on the train time database and the train operation database, calculating actual time of the train arrives each station, the information for judging whether the train is late or not and the like; providing a service for real-time dynamic information inquiring of the train and a service of user cooperation question and answer for the users; and providing a systematical train position push service for VIP users in the train.

A method and computer system for aggregating data from a plurality of operational databases are provided. It is determined if a transformation script stored in storage of a computer system has been modified. Delta data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified. All data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified.

A robotics process automation platform for developing and managing a workflow is provided. The platform includes development and operational databases stored in a memory, a development interface component, a control interface component, and a runner component. The development interface component is configured for creating a workflow and storing the workflow in the development database. The control interface component is configured for selecting the workflow stored in the development database and storing a copy of the workflow in the operational database. The runner component is configured for receiving instructions from the control interface component to store a copy of the workflow stored in the operational database in a memory of a virtual computing device, and downloading the workflow in the second memory. The runner component is also configured for instructing the virtual computing device to execute the workflow in association with the target application.

The invention relates to a construction method of a Yellow River water and sand change data warehouse and a public service platform. The construction method of the Yellow River water and sand change data warehouse comprises the following steps: step 1, carrying out decision topic demand analysis; 2, determining a decision topic information model or a concept model; 3, determining a data source related to the decision topic information model, and screening and analyzing the data source, wherein the data source comprises data from an operational database, files and other formats, spatial data, professional attribute data and management data; 4, designing a decision topic data model or a logic model; 5, determining metadata of the data warehouse, technical standards of data collection, fusionand integration and ETL implementation of the data; and step 6, carrying out physical model design including index design, storage architecture, data loading and interface design. By constructing a Yellow River water and sediment change data warehouse, the Yellow River water and sediment change trend is scientifically predicted and analyzed, and then the purpose of scientifically governing YellowRiver is achieved.

The invention relates to a distribution network operation data monitoring method and device, computer equipment and a storage medium. The method comprises the following steps: acquiring a service monitoring request; searching target monitoring data and service associated data in a preset distribution network operation database through a micro-service architecture according to the service monitoring request; obtaining an operation data monitoring result according to the target monitoring data and the service associated data; and feeding operating data monitoring results. According to the invention, after the service monitoring request is received, searching can be carried out in the preset distribution network operation database through the micro-service architecture corresponding to the monitoring method according to the data requested by the service monitoring request to obtain the target monitoring data and the service associated data corresponding to the service monitoring request; and corresponding monitoring results are fed back according to the data, and the utilization efficiency of the distribution network operation data can be effectively improved by comprehensively displaying the distribution network operation data associated with various service monitoring requests.

The distribution of Bluetooth IDs among multiple integrated circuit testers at multiple sites for programming with a master database containing large size ID blocks, site operational databases with medium size ID blocks and tester programs with small size ID blocks provides reduced memory requirements and limits the chance of two units with a duplicate ID.

The invention discloses a system and method for real-time inquiring of train dynamic information. The system comprises a user registration module, a user position sharing module, a train position inquiring module, a train dynamic information displaying module, a train dynamic information push module, a user database, a train operation route space database and a train operation time database. The method comprises the following steps of based on the train operation route space database and the train operation time database, judging the sharing position information of users, so as to form a position sharing information set of the users in a train; through a method of analyzing geographic information, calculating out a geometric center of all the positions, and using the geometric center as the current position of the train; utilizing geometric space analysis, based on the train time database and the train operation database, calculating actual time of the train arrives each station, the information for judging whether the train is late or not and the like; providing a service for real-time dynamic information inquiring of the train and a service of user cooperation question and answer for the users; and providing a systematical train position push service for VIP users in the train.

A computing system of an organization receives data through multiple channels of communication; a programmatic interface for each of the different channel infrastructures may be called to convert data about a member's contact with the system. Contact records for contain data such as a member ID and a channel identifier. An operational database may receive the converted contact records from the devices or software. A transaction application may perform various tasks resulting in the generation of transaction data. A transaction record containing the transaction data may be generated in a message queue or operational database. The interface for the communication channel may convert the transaction data in a message queue, after the transaction data is detected by a listening application that monitors the message queue and logs new transaction data to the operational database.

The invention discloses a method and system based on a browser for visually dragging and querying data. The method comprises the following steps: step one, an operational database and structure information of the same are extracted; step two, the database and the structure information of the same are obtained in the browser and rendered in WEB pages; step three, graphic components and canvases of query operation are rendered in the browser; step four, users arrange procedures of the query operation in graphical interfaces by dragging configuration; step five, a graphical query flow-process diagram is resolved for SQL statements; step six, the SQL query statements are carried out in the back-end; step seven, query results are output in the browser. The method and system based on the browser for visually dragging and querying the data has the advantages that querying the data in the WEB system is more flexible, and SQL query statement writing is simplified; the current situation that the database query is only carried out by inputting the SQL statement is changed; the use threshold of the system can be lowered, and the query process is arranged in a graphical mode; then the description of establishing the query process becomes clearer and more intuitive, and the learning threshold can be lowered.