48 results about "Automated database" patented technology

A seamless ledger-based wagering system is provided wherein a secure, flexible and automated database method and apparatus is used for retrieving information and accounting for wagers in an electronic wagering format. The accounting system can be a ledger wherein funds are accounted for by a financial structure (e.g., financial institution such as a bank, credit union, savings and loan, deposit account, and the like) so that funds may be transferred through an intermediate transaction (e.g., the electronic wager entered onto the account) on the ledger and committed to payment at the ultimate target of the transfer (e.g., the pari-mutuel site, and ancillary recipients of wagering monies, such as horseman's associations, totalisator companies, automated machine lessors, track association, governmental agencies and the like). As the financial records from the financial structure never ‘sees’ the wagering facility in the transaction, transferring funds or guaranteeing funds to the intermediate transaction on a ledger, the entire transaction is in compliance with state and national regulations prohibiting or limiting or rendering illegal the availability of funds in the wagering transaction or transferring funds into a wagering account.

An interface for remote human input for reading a database, the interface including an automatic voice question unit for eliciting speech input, a speech recognition unit for recognizing human speech input, and a data recognition unit for recognizing remote data input. The interface is associated with a database to search the database using the recognized input. A typical application is as an automated directory enquiry service.

A method and system for identifying alternate contact information of a specific type; particularly, by providing an inputted Email address in a query, one or more alternate Email addresses can be returned to the query, using an automated database. The system is queried using an entity's known Email address, which, in turn, is associated with other contact information for the entity, such as name and postal address, and the other contact information is then used to identify alternative Email addresses for the targeted entity either at the time of the query or in preparation of the database, and the alternative Email address(es) are then outputted to the requestor from the system. The method uses knowledge of contact points of different types for the same entity to identify alternate contact points of a single type, within a database of contact information.

A database structure of a sort defined by an access and query language that defines tables of variables having labels and field characteristics, such as ANSI structured query language (SQL), is modified by determining the structural differences between an existing schema and a new schema, independent of database contents. The differences are processed to generate commands that are then applied to evolve an existing database from the old schema or structure to the new one. This avoids the need to dump and restructure the contents of the old database for reload into an empty new database that has been prepared to meet the new schema.

An automated blocking technique is used as a first step to find approximate matches in a database. The technique builds a blocking set to be as liberal as possible in retrieving records that match on individual fields or sets of fields while avoiding selection criteria that are predicted to return more than the maximum number of records defining a particular special requirement. The ability to do blocking without extensive manual setup at low cost is highly advantageous especially when using a machine learning based second-stage matching algorithm.

An automated blocking technique is used as a first step to find approximate matches in a database. The technique builds a blocking set to be as liberal as possible in retrieving records that match on individual fields or sets of fields while avoiding selection criteria that are predicted to return more than the maximum number of records defining a particular special requirement. The ability to do blocking without extensive manual setup at low cost is highly advantageous especially when using a machine learning based second-stage matching algorithm.

The migration of a database may be accomplished, at least in part, by careful preparation and analysis of the database objects prior to migration. Migration may be performed more timely, efficiently, and reliably if the source database and its objects are first analyzed to determine the properties of the data, relationships, dependencies, and the like. The length of time of the copying and installation is reduced may selecting appropriate operations for different object types.

A method and system for identifying alternate contact information of a specific type; particularly, by providing an inputted Email address in a query, one or more alternate Email addresses can be returned to the query, using an automated database. The system is queried using an entity's known Email address, which, in turn, is associated with other contact information for the entity, such as name and postal address, and the other contact information is then used to identify alternative Email addresses for the targeted entity either at the time of the query or in preparation of the database, and the alternative Email address(es) are then outputted to the requestor from the system. The method uses knowledge of contact points of different types for the same entity to identify alternate contact points of a single type, within a database of contact information.

A method and system for providing an open database model that allows the combining of spatial and Attribute data in a single relational database. The integration of spatial and Attribute data allows the data to be accessed by either standard structured query language (SQL) or a GIS viewing application. The invention provides: enhanced performance by avoiding proliferation of segmentation; open dynamic segmentation; integrated temporal data; and automated database maintenance. Permanent anchor sections are provided to define spatial references. The data model allows for intersections in the interior of a link (anchor section), resulting in a more stable form of a link, or anchor section. The use of anchor sections simplifies maintenance of data associated with the anchor sections and facilitates the use of anchor sections in a distributed environment. Database views display data in a simple, tabular format. Access to a continuous archive of historical data is supported.

Methods and apparatus are disclosed to provide continuous, automated database-table partitioning and database-schema evolution. In one example, the disclosed methods and apparatus for automatically partitioning a logical table include monitoring a database operation to detect a partition-invoking event associated with the logical table, wherein the monitoring of the database operation is initiated in response to a table creation command that includes a partition-by constraint specifying a column of the logical table or of a different table, and, when a partition-invoking event occurs and is detected by the monitoring of the database operation, creating the next partition for the logical table and storing the next partition in a computer-readable medium.

Systems and methods for automating database table and application data collection into one process to facilitate remote diagnostics of a computer problem are disclosed. A customized batch file is created by a remote support technician that can be run on a user computer that has the actual data to be gathered for the computer problem to be diagnosed. An output data file is created by the running batch file compiling problem diagnosis data from the user computer. The data file can then be viewed via a single viewing process that displays the application and database data of the data file through a single GUI and allows easy viewing manipulation of that data through the GUI. Because the database table data may be saved in a string delimited format with table field names saved with it, the database program is not needed in order to view the tables.

The invention discloses an automated database index creation method and system. The method comprises the steps: obtaining a data source corresponding to a database operation statement to be approved and instantiating the database connection; processing each database operation statement to be approved in a way of determining a database table used in the database operation statement and an index related field used in each database table; obtaining a field combination of an existing index of the database table from the data source; for each database table, creating a database index when a set formed by the index related fields in the database table is not a sub-set or a superset of the combination of each existing index of the database table and a corresponding database index is not created yet. The invention also provides the corresponding system. According to the automated database index creation method and system, automatic creation of indexes is realized according to the database operation statement to be approved and sample data, and the efficiency of the index creation is improved.

Embodiments of the present invention are directed to methods and computational subsystems employed in database-management systems that continuously partition relational-database tables in order to ameliorate database-management-system execution bottlenecks and inefficiencies. Certain embodiments of the present invention employ the creation and instantiation of templates in order to continuously partition a database, while other embodiments of the present invention provide high-level-interface support for on-going relational-database-table partitioning.

A system and method for automated database management are provided. Statistics relating to operation of a database may be collected, wherein the database comprises one or more database objects. Characteristics of the database objects may be determined, either automatically or by user intervention, using the collected statistics, one or more policies, and / or one or more definitions. The policies and definitions may be defaults or may be customized by a user. Actions to be performed on the database objects may be determined, either automatically or by user intervention, based on the characteristics of the database objects. A schedule for performing the actions on the database objects may be automatically determined. The actions may be performed on the database objects based on the schedule. The actions on the database objects may be confirmed. The results of the actions on the database objects may be analyzed or monitored. Policies and / or definitions may be reconfigured based on the results. The system and method may automatically decide to perform one or more REORG actions on the database objects based on the statistics. A recommendation of a modification to one or more of the database objects may be generated based on the statistics. The scheduled actions may be modified as a result of detecting a change in the characteristics or usage of at least one of the database objects.

Described are system, method, and computer-program product embodiments for automatically ingesting data from disparate data sources into a target database having a target data schema. In some embodiments, the data is received in a data file including data columns formatted according to a data schema, and a data dictionary describing the source data columns. Count data is generated for each cell selected from a data column, each count datum including counts of occurrences of a detected characteristic in each cell. One or more target data columns from the target data schema can be selected and displayed to a user as being semantically related to the data column based on the count data for each cell, a column header of the data column, and the data dictionary. Based on input received from the user, a data table is generated to store the source columns and loaded into the target database.

A system and method for automated database management are provided. Statistics relating to operation of a database may be collected, wherein the database comprises one or more database objects. Characteristics of the database objects may be determined, either automatically or by user intervention, using the collected statistics, one or more policies, and / or one or more definitions. The policies and definitions may be defaults or may be customized by a user. Actions to be performed on the database objects may be determined, either automatically or by user intervention, based on the characteristics of the database objects. A schedule for performing the actions on the database objects may be automatically determined. The actions may be performed on the database objects based on the schedule. The actions on the database objects may be confirmed. The results of the actions on the database objects may be analyzed or monitored. Policies and / or definitions may be reconfigured based on the results. The system and method may automatically decide to perform one or more REORG actions on the database objects based on the statistics. A recommendation of a modification to one or more of the database objects may be generated based on the statistics. The scheduled actions may be modified as a result of detecting a change in the characteristics or usage of at least one of the database objects.

An automated database tuning tool may include a user interface component and a tuning engine. The user interface may be a graphical component that interfaces with a user to collect configuration parameters for a tuning session for a specified database. The configuration parameters may be stored in a tuning database. A tuning engine that performs the actual tuning process may generate physical design recommendations and reports. The recommendations and reports may be stored in the tuning database, enabling the tuning tool to be run off-line or in background. Communication between components of the tuning tool may occur via stored procedures.

In accordance with the teachings of the present invention, a tool is presented for automatically generating a database in a Web Services environment. A database is identified. A Web Services Description Language (WSDL) document associated with a Web Services is identified. The elements of the WSDL document are examined to determine the data types associated with the Web Service. Based on the data types, a database is automatically generated that is compliant with the WSDL document and the Web Service.

Systems and methods for automating database table and application data collection into one process to facilitate remote diagnostics of a computer problem are disclosed. A customized batch file is created by a remote support technician that can be run on a user computer that has the actual data to be gathered for the computer problem to be diagnosed. An output data file is created by the running batch file compiling problem diagnosis data from the user computer. The data file can then be viewed via a single viewing process that displays the application and database data of the data file through a single GUI and allows easy viewing manipulation of that data through the GUI. Because the database table data may be saved in a string delimited format with table field names saved with it, the database program is not needed in order to view the tables.

New techniques for automated database deployment are disclosed. Change SQL files intended for any target database are checked into a designated source code control repository. A pre-validation process is applied to the proposed changes and reports all errors therein, not just the first error found. A tracking mechanism may find and report changes that have been done against a database since the last deployment, including changes applied without following source control procedure. All recent SQL files since previous promotion can be automatically gathered and built into a master run book SQL for execution in a correct sequence. Backout SQL may also be automatically generated and validated. A pre-test or mock deployment may be performed during regular business hours against an automatically generated copy of the target database. With these techniques, deployments and maintenance of databases become more efficient, and failure rates and failover responses could be significantly improved.

Described is a system and method for employing user created database-structured queries and data extraction engines to crawl through Websites extracting and organizing data from selected sources on a network, such as the Internet. The structure of a query processed by a Data Extraction engine enables a user to treat the network as a searchable database. The database-structured queries provide a user with tools to match patterns on selected sites on the network. A user may automate database-structured queries to be executed on a regular frequency. Output of the database-structured queries may be placed into a data log, displayed on a user display screen, or optionally reshaped for use by a plurality of data analysis tools. Additionally, an optional graphical user interface is provided.

Systems and methods for on-demand simulation based learning for an automation framework. According to one embodiment, the system or method comprises an automated process in a real computing environment that encounters a novel, divergent, or defined state that the automation cannot handle. The state is replicated in a simulated computing environment which a user interacts with to resolve the simulated issue. The user's actions are captured and replicated in the real computing environment in order to resolve the issue. Optionally, the user's actions are analyzed and added to the automation database or rules.

The migration of a database may be accomplished, at least in part, by careful preparation and analysis of the database objects prior to migration. Migration may be performed more timely, efficiently, and reliably if the source database and its objects are first analyzed to determine the properties of the data, relationships, dependencies, and the like. The length of time of the copying and installation is reduced may selecting appropriate operations for different object types.

A method and system for providing an open database model that allows the combining of spatial and Attribute data in a single relational database. The integration of spatial and Attribute data allows the data to be accessed by either standard structured query language (SQL) or a GIS viewing application. The invention provides: enhanced performance by avoiding proliferation of segmentation; open dynamic segmentation; integrated temporal data; and automated database maintenance. Permanent anchor sections are provided to define spatial references. The data model allows for intersections in the interior of a link (anchor section), resulting in a more stable form of a link, or anchor section. The use of anchor sections simplifies maintenance of data associated with the anchor sections and facilitates the use of anchor sections in a distributed environment. Database views display data in a simple, tabular format. Access to a continuous archive of historical data is supported.

Techniques are disclosed relating to create a configuration for a database system. In some embodiments, program instructions of a change set for an application are received from a source code management (SCM) repository. In response to the receiving, a build process is performed that includes causing compilation of the received program instructions to produce program instructions executable to run the application. The build process also includes provisioning the configuration with a schema by retrieving a first set of metadata defining the schema and issuing corresponding data definition language (DDL) instructions to create the schema in the configuration. The build process includes provisioning the configuration with data by retrieving a second set of metadata defining the data and issuing corresponding data manipulation language (DML) instructions to insert the data into the configuration and storing the provisioned configuration in a repository as one of multiple configurations associated with multiple received change sets.

A method and system for detecting intrusions on a fiber optic network. The method and system monitors polarization variations of light being transmitted in the fiber optic network. It then determines intrusions in the fiber optic network based on the polarization variations. The polarization variations are then compared to a database of known activity which would cause polarization variations to determine unknown intrusions. An intrusion alert is initiated when the determined intrusion does not correspond to any known activity. The known activity is contained in an automated database for automatically comparing to the polarization variations. The intrusions may be cross-correlated on two partially adjacent fiber optic cables to determine the location of the intrusion.

Disclosed is a template-based database analyzer. An automated database analyzer uses templates to adapt to various database languages, such as SQL (structured query language) and branches thereof. The templates are combined with a defined database schema and metadata for operating the database schema. SQL files instantiate the database schema on a database system under test. Then operation of the database schema can be executed so as to evaluate performance of the database system under test.

A system to assist a seller in creating product catalogues using a database and a separate pagination program. Information regarding specific, desired products is collected from the database. It is modified by Markup Interchange Format (“MIF”) code wherein directives are added that determine what information will be included in the final catalogue. The MIF code file is formatted so that it is compatible with the pagination program, and the resulting file is flowed directly to the pagination program. This method and computer program reduces the likelihood of errors, redundant work, and costs for automated processing of catalogues. The resulting file provides data and the specifications useful for creating a formatted, printable or viewable output.

The invention discloses a database migration method and device. The method comprises the steps of obtaining parameter information of a to-be-migrated database and a target server; judging whether thetarget server meets a database migration condition or not according to the parameter information of the to-be-migrated database and the target server; and if the target server satisfies the database migration condition, migrating the to-be-migrated database to the target server. According to the method, selection of the target server and judgment of database migration conditions are automaticallycompleted, automatic database migration is achieved, dependence of database migration on manpower is relieved, and compared with manual processing, the efficiency of automatic database migration is higher.