289 results about "Sql server" patented technology

System for tracking mobile tags. Cell controllers with multiple antenna modules generate a carrier signal which is received by the tags. Tags shift the frequency of the carrier signal, modulate an identification code onto it, and transmit the resulting tag signal at randomized intervals. The antennas receive and process the response, and determine the presence of the tags by proximity and triangulation. The recursive-least squares (RLS) technique is used in filtering received signals. Distance of a tag from an antenna is calculated by measuring the round trip signal time. The cell controllers send data from the antenna to a host computer. The host computer collects the data and resolves them into positional estimates. Data are archived in a data warehouse, such as an SQL Server. Also disclosed is an article tracking system that supports both active and passive tags with a cell controller able to read both passive and active tag signals.

The present invention relates to a subscription modeling system and methodology. A query processor receives subscription query and subscriber information and transforms the query and subscriber information into data. An index component propagates at least one database with the transformed data; and a matching component that associates the transformed data with event data to generate a database of notification data that can be delivered to subscribers. The invention provides for abstracting subscription and subscriber information (as well as event information if desired) to high-level classes (e.g., data fields)—thus the invention provides for modeling such notification related information as data. Subscription applications can thus be developed at high levels wherein complex subscription queries and subscriber information can be defined as data fields for example. Databases in accordance with the data fields can be propagated with subscription/subscriber specific information. The present invention takes advantages of the processing power associated with database engines (e.g., SQL server) to generate notifications via performing a join operation on the databases (e.g., subscription database(s), subscriber database(s) and event database(s)). Accordingly, notifications are generated en masse as compared to per subscription per subscriber. Thus the present invention provides for a highly scalable and efficient notification system.

A system and method for identifying medical facilities along a travel route preferably includes an input device, a processor, Microsoft SQL server database and a memory storing various information regarding medical facilities. For on-demand determination of medical facilities along a travel route, the input device preferably includes a GPS receiver providing the current geographical coordinates of a patient requiring medical assistance to the processor. The processor compares the geographical coordinates of the patient to coordinates of medical facilities in the database to determine medical facilities near the patient. A user of the system may also input a type of medical emergency, preferred language and insurance information to refine the search for medical facilities. The processor may also calculate a projected travel route using navigational software. The identified medical facilities may be displayed to a user in any manner and/or saved in a navigational computer for reference in case of a medical emergency.

A computer software system is provided, namely An Object Process Graph Relational Database Interface (OPGRDI) system. The OPGRDI defines and updates relational database tables based on an OPG and stores and retrieves data in the tables as an OPG-defined application is run. The OPGRDI also defines and updates OPG persistent data object elements based on relational database table schemas. The OPGRDI functions can be enabled by users who want to store and retrieve application information in a relational database system, such as Oracle, Sybase, SQL Server, etc. The OPGRDI alters relational database tables as a user changes the structure of OPG-defined application.

Systems and methods consistent with concepts of the present embodiment of the inventive concept provide mechanisms for database migration from one database (source database platform) platform to another (target database platform). The target and source databases can be any relational databases including, without limitation, Oracle, SQL Server (Microsoft), DB2 UDB (IBM), Sybase, MySQL, PostgreSQL, and the like. The inventive methodology will work well for migration of any relational database that implements SQL language from one platform to another. A feature of the invention is the provision of a virtual engine enabling the running of an original application on a migrated database.

A system, method, and medium for performing incremental backups of a Microsoft SQL server database. A snapshot of the database is created, and then a map identifying the changed extents is retrieved from the snapshot. The changed extents are then retrieved from the snapshot and stored in a backup storage device. For a restore operation, a full database backup file is written to a storage device and then the changed extents from a stored incremental backup file may be merged with the full backup file. Next, the database server is notified of the reconstructed file and then the reconstructed file is mounted by the database server as a live instance of the database.

Method and system for detecting a dead server in a multi-server environment. A virtual ring structure is used in which each server in a server pool is only required to monitor the status of two other servers in the server pool. Thus, a server need only transmit ping signals to two other servers (its buddies) in the server pool at any given time. Because each server maintains the status of only two other servers at any given time, the size of the server pool is not limited by the ability of each server to send and process ping signals. The two servers which are monitored by any given server in the server pool are referred to as the “buddy A” server and the “buddy B” server. When the monitoring server determines that one of its buddy servers is down, the monitoring server reports the status of the down server to a SQL server that maintains a server table. The server table maintains a list of each “live” server and the buddy servers assigned to that server. Down servers are removed from the server table. When a server determines that one of its buddies is down, the report to the SQL server results in a buddy reassignment. The buddies of the down server are made buddies of one another and the virtual server ring is once more intact. The SQL server then knows not to route any client to the down server.

The invention provides a method for realizing high-efficiency rapid backup of a database, which is characterized by triggering a writing-log daemon progress of the database to start when the database sends out a service update request, starting a synchronous writing-log daemon progress during writing a local rework log to write a backup rework log and forming archived log data at the backup end. By the archived log analysis at the backup end, the database required to be backed up can be identified and an increment marker file can be generated. A system backup daemon progress reads the increment marker file for backing up the increment and generates an increment backup gather. The method can realize the immediate backup of the database system, rapid increment backup of the database system and key function of backup synthesis, thereby achieving high-efficiency rapid backup. The method is suitable for database systems of Oracle, Microsoft SQL Server, Mysql and the like.

The invention discloses an intelligent fault diagnosis system for an ICNI system, which can improve the maintenance efficiency, carry out intelligent and automatic diagnosis and is applicable to the ICNI system. According to the technical scheme of the invention, a knowledge base and a management module thereof carry out standardization research and mathematical modeling based on a fault tree, an SQL Server database software framework is adopted, a relational database is used for building a logic relation among a fault phenomenon, a fault mode, a detection method, a historical case and a fault tree internal event to form the knowledge base; and a diagnosis information acquisition module interacts with an automatic testing system via Ethernet to acquire diagnosis data from the ICNI system and a testing instrument, a reasoning machine module adopts CBR and RBR hybrid diagnostic reasoning, after comprehensive judgment is carried out on the fault phenomenon inputted by the user, the field knowledge stored by the knowledge base and the diagnosis data from the automatic testing system, a reasoning method is automatically selected to carry out reasoning diagnosis on the fault, a reasoning process and a reasoning result are outputted to an explanation machine module, and a diagnosis report is generated.

The invention relates to a batch processing request-based Microsoft SQL server database cluster. The cluster consists of two parts, wherein a gateway and backups thereof are arranged at the front end of the cluster, and two or more of database server nodes are arranged at the rear end of the cluster; each node is provided with a structured query language (SQL) Server example and a cluster proxy and is not provided with a shared disk structure; and each node has an independent and consistent data set, and the cluster is only provided with a host. The gateway is used for managing the integral cluster; and for each client link, the gateway opens a database link corresponding to each node simultaneously to receive, analyze and optimize all client requests, wherein the client requests are divided into two classes, namely the read-only query requests and the data updating requests; for the read-only query requests, the gateway sends the requests to any one node to execute the requests according to a set load balancing algorithm so as to realize the real database access load balancing and improve the performance of a system; and the updating requests are sent to the host of the cluster to be executed, and are subjected to synchronous data by the host to other nodes to keep the data set of each node real-time and consistent, eliminate a single-point fault source and realize system fault tolerance. The integral cluster can improve the performance, availability and reliability of the system obviously and solve various problematic issues of the performance, single-point faults, zero data loss and the like in the field of databases, and is a comprehensive database cluster scheme.

The present invention relates to a system and methodology to facilitate data communications and data management between network entities operating in accordance with various data structures and operating environments. A managed class of application programming interfaces (API) are provided that support data communications between remote/local locations employing a first data structure and a second location supporting a second data structure (e.g., API for NET languages to access SQL Server via XML views). The managed class and associated APIs provide data transformations between such structures to facilitate communications and data management among various locations and architectures. In addition, the managed class and APIs facilitate operations between disparate object systems such as between managed and unmanaged object systems via interface support of a wrapper and associated marshalling technologies to bridge communications between such systems.

Methods, systems, and computer code for (i) performance-monitoring a multi-tier application including a .NET tier and a database tier; and (ii) for visually presenting performance-data to a user are disclosed. In some embodiments, a multi-tiered performance data interface, for example, including a .NET tier performance data interface and a database tier performance data interface operatively coupled to the .NET tier performance data interface, is provided. In some embodiments, the .NET tier performance data interface is configured to present .NET stack data and the database performance data interface is configured to present internal database performance data, for example, wait times (e.g. relative magnitudes of different types of wait times). Techniques for matching .NET-tier requests to execute SQL statements with database-tier executions of SQL statements are also disclosed.

The invention discloses a college teacher teaching archive management system. The college teacher teaching archive management system comprises a teacher system function module, a student system function module and a common part function module. Aiming to solve the problems of existing college teaching archive management, the college teacher teaching archive management system is designed and implemented, and the college teacher teaching archive management system is mainly used for monitoring and managing teaching archives, can run parallel with an existing college educational management system and share data with the existing college educational management system and is based on Web access. The college teacher teaching archive management system is developed through an ASP.NET language, and the background database of the college teacher teaching archive management system is SQL Server 2008. For archive management of the college teacher teaching archive management system, the open-source control DSOFramer of the Microsoft company is embedded in pages to be used for online browsing and management of archives. The college teacher teaching archive management system is a management information system with teaching archive monitoring and management as the core, the functional modules are divided mainly according to the business process of users, takes the thinking habits of the users into full consideration, is clear in layer and convenient to operate, and guarantees the overall independence of the modules.

The invention provides a batch configuration management method for monitoring base station equipment, which comprises the following steps: (1) equipment configuration and service data which are required by a monitored object are generated through EXCEL forms; (2) data in an EXCEL document is automatically imported to an SQL SERVER database to complete the batch data configuration processing of a base station and equipment as well as the affiliate monitored object of the equipment through importing SQL SERVER process by batch; (3) the data in the EXCEL document is automatically imported to an ACCESS database through importing ACCESS by batch to complete the batch configuration processing of the communication link parameters and interfaces of equipment and the affiliate monitored objects of the equipment.

The invention relates to a method for managing component library which supports heterogeneous components. The method comprises steps of: on the base of the uniform component package structure of the heterogeneous components, creating a network indexed structure by combining XML with SQL Server database as component library frame; classifying the heterogeneous components; normalizing and storing to the component index library defined by the classified organization mode definition; realizing uniform access and index to the component library on the base of the classification and storage. The invention obtains each component from internet to local efficiently, after verification, information mapping standard, information description, entity storage in library and component indexed access, forms uniform data package, transmits and analyzes standard for providing support on program digging and components package.

The invention belongs to the technical field of monitoring of volatile organic compounds and particularly relates to an on-line monitoring system and analysis method for volatile organic compounds. The on-line monitoring system comprises a data acquisition and transmission control system, a flue gas sampling system, a sample gas transfer pipe, a flue gas pretreatment modulation system, a gas analysis system and a temperature and pressure flow measuring system, wherein the data acquisition and transmission control system comprises a PLC (Programmable Logic Controller), a data acquisition module of the PLC and an industrial personal computer; monitoring configuration software and an SQL Server database are mounted in the industrial personal computer; the flue gas sampling system is connected with the flue gas pretreatment modulation system through the sample gas transfer pipe; and the sample gas transfer pipe is an electric tracing type constant-power sampling pipe and is made of a polytetrafluoroethylene material. The on-line monitoring system for volatile organic compounds is stable in operation, low in fault rate, high in monitoring accuracy, relatively small in error, stable in measurement and relatively low in equipment maintenance cost.

The invention provides an SQL (structured query language) server based automatic script upgrading method. The method includes steps of selecting a target database; generating a database template; comparing the database template with a target database template and generating an upgrading script; executing the upgrading script; generating the upgraded database template, comparing the upgraded database with the target database to generate the upgrading script, and checking whether the upgraded database template and the target database template are consistent or not, if yes, upgrading successfully, if not, repeatedly upgrading. The invention further provides an SQL server based automatic script upgrading system comprising a database template selection module, a database setting module, a database template generating module, an upgrading script generating module, an upgrading script executing module and a checking module. Once upgrading of the database is realized and is accurate, upgrading operation is simplified, and file management difficulty is reduced.

The invention provides an implementation method of a central control platform of underground fully-mechanized coal face hydraulic supports. The central control platform is composed of a PLC S7-300 c8051f020 single-chip microcomputer by SIEMENS, a Power Builder tool, an SQL server database and a multi-protocol communication platform. The Power Builder tool is used as a front development platform; the PLC S7-300 c8051f020 single-chip microcomputer by SIEMENS is a real-time control platform; thus, central control is implemented for the coal mine underground fully-mechanized coal face hydraulic support. A control method provided by the invention has a function of automatic post-cutting and support-removing under central control; video-based crossheading remote adjustment and control can be achieved; various messages can be transmitted remotely to a ground monitor center in real time; various faults during a mining process can be monitored in real time; mining production is automated.