290 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 human resources and payroll system having a plurality of separate modules includes a SQL server or alternative server being able to implement a back end database. In one example, each separate module is designed to be integrated seamlessly into the core payroll system. In another example, each separate module is capable of being controlled by a security management system. In one example, each separate module may be activated or deactivated by the security management system based on the needs or contracted arrangements of a client using the system.

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 present invention extends to methods, systems, and computer program products for optimizing queries of parallel databases. Queries can be partially optimized at an optimizer that is unaware of its use to optimize queries for parallel processing. The optimizer can produce a data structure (e.g., a SQL Server MEMO) that encapsulates a logical serial plan search space. The logical serial plan search space may not incorporate any notion of parallelism into the plan space itself. A parallel-aware optimizer can parallelize the logical serial plan search space by augmenting the data structure (e.g., transforming the SQL Server MEMO into a parallel MEMO). Augmentation can be with data movement operations that move data associated one or more compute nodes in a distributed architecture. Cost estimates can be calculated for the operations contained in the parallelized data structure. The parallel plan with the lowest estimated cost can be selected for the query.

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.

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.

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.

A system and method for conducting distributed transactions wherein a connect JDBC™ driver for a Microsoft™ SQL Server implements Java™ JTA distributed transactions. To conduct the JTA distributed transactions, JTA specific interfaces are engineered in the driver. The JDBC™ driver is a wire protocol driver in direct TCP communication with the SQL server. During communication, the JDBC™ driver sends packets of information back and forth to and from the database server. These packets may request information form the server, or instruct the server to perform a function, such as executing a stored procedure.

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.

In the invention, a display screen, an ultrahigh frequency RFID reader and writer, an ultrahigh frequency RFID label, a commodity and the like are adopted, and an electronic display screen and the ultrahigh frequency RFID reader and writer are installed on a shopping trolley. Simultaneously, a SQL Server database provides a data service. The reader and writer in the shopping trolley can read commodity information pasted with an information label and commodity area position information pasted with a position label. The system read information from a database through a wireless network and displays on the display screen. A large-scale reader and writer at an exit can read the commodities in the shopping trolley for one time. A user can pass through after self-checkout. Compared to the prior art, customer shopping time can be saved; a customer shopping experience can be increased; the commodity information can be acquired conveniently; through using a navigation function, time for the customer to search the commodities can be saved; through the self-checkout, time for the customer to queue so as to pay can be saved; intelligent commodity recommending provides a humanized service for the customer; a supermarket service is integrally optimized, and shopping efficiency and the experience are increased.

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 present invention discloses a multi-sensing information fusion-based power transformer on-line monitoring system and method. With the system and method adopted, online and real-time monitoring of a power transformer can be realized reliably, and vibration, current, voltage and switching quantity information can be acquired, processed, transmitted and analyzed reliably. The multi-sensing information fusion-based power transformer on-line monitoring system of the invention comprises a multi-sensor acquisition assembly; the multi-sensor acquisition assembly includes an acceleration sensor, a voltage sensor, a current sensor, a temperature sensor and a switching quantity acquisition sensor which are respectively used for acquiring the vibration information, voltage information, current information, temperature information and switching quantity information of the power transformer; an embedded master controller is an ARM embedded system-based master controller; a remote controller is a host computer; and the host computer uses SQL Server database software to carry out open database management.

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.

A software architecture for debugging the execution of T-SQL and managed data-tier application logic associated with a single connection, in isolation from other connections, is provided. In the architecture, a database server hosts the data-tier application logic. A client connects to the database server and issues requests on the connection, which initiates the execution of the data-tier application logic. A debugger debugs a client process on the server. An application program interface (API) receives a request to initiate a debugging session from the debugger, and returns an interface pointer to the debugger, thereby enabling the debugger to debug the client connection to the server.

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 discloses a method for remotely monitoring and controlling a hydraulic support on an underground working surface. A Power Builder platform and an SQL Server database are utilized, and a serial port of a ground industrial personal computer transmits a control parameter or operating command for the hydraulic support by means of an MODBUS protocol to an underground end head controller and an underground hydraulic support controller and receives feedback information; by utilizing a Power Builder control event, the remote tracking and display of an underground coal-winning machine is realized and the remote real-time data and state of the hydraulic support are remotely displayed on the ground industrial personal computer in forms of graphs, curves and tables; by utilizing the function of the Power Builder of quoting external events OLE and OLE Database Blob, the real-time graph processing is realized; the actions of the hydraulic support are controlled on the ground industrial personal computer according to the real-time position of the coal-winning machine on the underground working surface and the real-time state of the hydraulic support, which are analogically displayed on the ground industrial personal computer; and the hydraulic support on the underground working surface automatically tracks the position of the coal-winning machine to carry out machine-following action according to the control parameter sent by the ground industrial personal computer.

The invention discloses a method for establishing a comprehensive agricultural environmental information database. The comprehensive agricultural environmental information database comprises four sub-databases, i.e. a general attribute sub-database, a space sub-database, a video and audio sub-database and a model sub-database. The general attribute sub-database stores and manages agricultural environmental information attribute data through arranging a two-dimensional datasheet in a relation database management system SQL server. The establishment method of the space sub-database comprises that effective storage of space data in a relation database is realized through a space database engine and management logic is created through SDE in a classifying and layering way. The invention has the advantages of the practicability is high, the pertinence is high, the universality is good and powerful information support is provided for the comprehensive integration application of agricultural information.

A computer system monitors database servers to mitigate server availability risks. The plurality of servers may be proactively monitored to determine database status at each server before an alert is generated. An automated proactive process executes at a user's desktop to monitor database features over a plurality of database servers. Information about the server status is presented in a graphical user interface (GUI) format where status information for all of the database servers is presented in one integrated view in an automated manner. For example, the monitoring process reads a list of SQL instances and then connects to each listed SQL server to query the system catalogs of an SQL server engine. The monitoring process interprets the received information from the SQL servers and updates the GUI. The GUI may be color-coded to indicate the status state of individual SQL features for each monitored SQL server.

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.