49 results about "Sql server" patented technology

This disclosure describes systems, methods, and devices related to analyzing data stored in a relational database. A method may include installing a structured query language (SQL) server on a host server; installing statistical analysis modules on the host server; executing the statistical analysis modules within a relational database of the SQL server to analyze data stored in the relational database; and generating outputs based on the execution of the statistical analysis modules within the relational database.

Intelligent memory brokering for multiple process instances, such as relational databases (e.g., SQL servers), reclaims memory based on value, thereby minimizing cost across instances. An exemplary solution includes: based at least on a trigger event, determining a memory profile for each of a plurality of process instances at a computing node; determining an aggregate memory profile, the aggregate memory profile indicating a memory unit cost for each of a plurality of memory units; determining a count of memory units to be reclaimed; identifying, based at least on the aggregate memory profile and the count of memory units to be reclaimed, a count of memory units to be reclaimed within each process instance so that a total cost is minimized to reclaim the determined count; and communicating, to each process instance having identified memory units to be reclaimed, a count of memory units to be reclaimed within the process instance.

The invention discloses a data acquisition and automatic control system for a carbon filament collecting machine, which adopts a modular design and comprises a main control module for connecting and controlling other modules, and a plurality of functional modules such as a display and operation interface module, a real-time monitoring module, a fault detection and early warning module, a shredding control module, a label printing module and a multi-device adaptation module. The system is realized on the basis of an MVVM (Model-View-ViewModel) architecture of a WPF (Wireless Power Function), and has good expansibility and maintainability. The system uses the SQL Server as a database, and the EFCore performs data operation, so that data access is more efficient and flexible. Meanwhile, the system supports parallel operation of a plurality of wire collecting machines, each wire collecting machine is managed through an independent thread, concurrence conflicts are avoided, PLC data can be obtained in real time, wire collecting machine equipment can be dynamically managed, and a proper label template is automatically selected for printing according to batch information.

This disclosure describes systems, methods, and devices related to analyzing data stored in a relational database. A method may include installing a structured query language (SQL) server on a host server; installing statistical analysis modules on the host server; executing the statistical analysis modules within a relational database of the SQL server to analyze data stored in the relational database; and generating outputs based on the execution of the statistical analysis modules within the relational database.

This invention discloses a method and system for processing the entire lifecycle of procurement contracts based on a unified stored procedure with multiple TVPs and AI protection verification, belonging to the field of industrial software MES / ERP technology. This invention uses three sets of table-valued parameters (TVPs) as a unified data entry point, integrating six core operations—adding, modifying, deleting, appending details, modifying details, and deleting details—in a single stored procedure, and returning unified exception information through a single output parameter. The system incorporates a two-level centralized parameter verification mechanism. The first level performs a one-time empty table check on the three sets of TVP tables; if any table is empty, the transaction is immediately rolled back and an exception is returned. The second level performs centralized integrity and legality verification on all business parameters, achieving security protection for AI and external calls, effectively intercepting dirty data and illegal requests. This invention features a simple architecture, high execution efficiency, and comprehensive business coverage. The transaction mechanism ensures strong consistency of master-slave table data, supports compatible operation with both SQL Server and GaussDB databases, and can securely integrate into the AI ​​ecosystem without business restructuring. It is particularly suitable for the high-stability and high-security procurement contract business processing of complex factories with more than 11 production lines. This invention has been fully implemented in a real industrial ERP system and can run stably in a real production environment for a long time, demonstrating mature engineering value and industrial promotion capabilities.

The invention provides a one-stop knowledge graph construction method and system, a medium, a program product and equipment, and belongs to the technical field of data processing. The method comprises the following steps: processing dynamically acquired map service data from a structured or unstructured data source to a set relational database, and performing primary processing of the map service data; creating schema information of the atlas, and mapping data fields and entity attribute information or relation attribute information to complete migration binding of data; migrating the migrated and bound relational data to a graph database of a specified type to complete graph construction; according to the method, the problem that the source of supporting data of an existing atlas construction system is single is solved, and the method is adaptive to currently common relational databases such as MySQL, Oracle and SQL Server, so that the system can directly fetch data from different relational databases during atlas data migration, and the data processing work in the earlier stage of atlas construction is reduced.

The invention relates to the technical field of database management, and discloses an automatic failover method of an SQL Server database and the database, and the automatic failover method of the SQL Server database comprises the following steps: collecting node data of a corresponding node, and reporting the node data to a Zookeeper cluster; whether election succeeds or not is judged through a distributed lock mechanism of the Zookeeper cluster, and when election succeeds, node data of the nodes are obtained from the Zookeeper cluster; judging whether the node fails or not based on the node data, when the node fails and the node is a main node, writing a failover node in a Zookeeper cluster, and initializing the state of the failover node to be a starting state; switching a main node and a standby node, transferring fault data, and updating the state of a fault transfer node to a waiting state after the fault data is transferred; and when it is detected that the fault of the original main node is recovered, re-establishing the mirror image relation of the main and standby nodes, performing data synchronization, and deleting the fault transfer node. According to the invention, the single-point fault risk of the witness server can be eliminated.

The present application provides a data assembly method and related equipment, which are applied to a data assembly system. The data assembly system includes a SQL Server database with a configuration library, multiple SQL Server servers, a HBase cluster system, and an HBase database set in the HBase cluster system. The HBase cluster system configures a data assembly program and a configuration file. The method includes: reading the configuration file through the data assembly program to obtain data range information; performing data query through the configuration library according to the data range information to obtain row storage data query information; processing the row storage data query information using the data assembly program to obtain column storage data information; and loading the column storage data information through the HBase database. The required data is queried and assembled at one time, and the program only needs to be run once, which can better realize the loading of the specified range of data from the SQL Server database into the HBase database.

The invention discloses an instance object synchronous disaster recovery method and device based on an SQL Server and computer equipment. The method comprises the following steps: acquiring asset configuration information of an SQL Server source end instance and an SQL Server target end instance, and matching a disaster recovery pair relationship to obtain a source end and a target end; an instance object needing to be synchronized is selected, and a synchronization strategy is configured; respectively collecting data of instance objects needing to be synchronized from the source end instance and the target end instance according to a synchronization strategy, and comparing to obtain a comparison result; according to the comparison result, synchronizing different instance objects into target end instances in batches by adopting a synchronization strategy to obtain a synchronization result; and the synchronization result is displayed, and when an abnormal condition occurs in the synchronization process, early warning of the abnormal condition is carried out. By implementing the method provided by the invention, more efficient, reliable and customizable disaster recovery of SQL Server instance object synchronization can be realized.

The present invention belongs to the field of three-dimensional visualization technology and discloses a three-dimensional visualization method for a biomedical platform data map. The method includes installing SQL Server in the biomedical platform; constructing a biomedical database through SQL services; collecting biomedical product data and production and sales geographic data through a vertical search engine; transmitting the data to the platform in the form of a data stream; cleaning the collected medical data and storing it in the biomedical database; constructing a biomedical platform map canvas through a map construction program; constructing a map model on the map canvas, and displaying the map model in association with the biomedical data through key geographic information in the biomedical data; and constructing a biomedical knowledge graph, and associating the knowledge graph with the map model through a vector file. The present invention can reduce the number of displayed tables by constructing a biomedical platform map canvas through a map construction program, thereby improving the efficiency of constructing data maps.

Automated SQL Server performance tuning and optimization system that includes: a query optimization engine for analyzing and optimizing SQL queries and execution plans; a dynamic index management module for automating index creation, modification, and removal; a performance monitoring module for tracking query execution, detecting deadlocks, and identifying bottlenecks; a workload balancing module to optimize resource utilization by redistributing workloads; an adaptive memory and storage module for dynamically adjusting memory allocation and memory settings; a security and compliance module to monitor access patterns and enforce security policies; a dashboard to provide real-time insights, tuning recommendations, and performance analysis.

Embodiments as disclosed allow identity management with respect to SQL database by discovering substantially database objects and their entitlements and associating them with corresponding identities within the identity management system, thus providing insights into such SQL server entitlements and their associated identities, even across multiple SQL servers within an enterprise environment.

Techniques for dynamically allocating RAM among a plurality of SQL server instances are provided. A method includes analyzing, for a first SQL server instance of the plurality of SQL server instances, one or more first instance performance metrics; and responsive to determining, based upon the analysis of the one or more first instance performance metrics, that the first SQL server instance requires additional RAM: determine, based upon the analysis of the one or more first instance performance metrics, a first amount of RAM required by the first SQL server instance, and responsive to determining that the first amount of RAM is available in a memory pool, allocate the first amount of RAM for the first SQL server instance from the memory pool.

The application provides a kind of scheduling communication system performance test method and system based on BICC signaling, the method comprises: building client and server in Linux system, deploying SQL server on Windows system, and configuring WAV file, WAV file transcoding tool in SQL server, creating configuration information table of performance test and carrying out data configuration;Read each configuration information, find corresponding WAV file according to WAV file path in the configuration information, the WAV file and the information other than WAV file path in the configuration information constitute test data;The test data and the WAV file transcoding tool are issued to client and server;Server and client generate test cases according to the test data issued respectively;Client initiates call as calling, server responds call as called, and carries out performance test according to test case.

This invention discloses an artificial intelligence-based transformer bushing safety monitoring system, mainly composed of a fault diagnosis expert system and a transformer oil chromatography online analysis system. The fault diagnosis expert system includes a transformer bushing electrical knowledge base, an SQL Server database, an inference engine, a human-computer interface, and a built-in controller. The transformer oil chromatography online analysis system includes a gas source module, an oil-gas separation module, a gas detection module, and a chromatographic data acquisition and processing module. This invention generates a gas concentration distribution map based on the pairwise correlations between gas occurrences, and forms triangles by connecting pairs of concentration values, statistically analyzing the S-t curves of the areas of each triangle. By combining the gas concentration distribution map and the S-t curves for diagnosis, the visualization of various fault diagnoses is significantly improved, and the speed of fault analysis is greatly increased. Furthermore, statistical analysis of data from a period prior to the fault provides a new approach for real-time fault monitoring.

This invention discloses a method and system for generating and updating a Bill of Materials (BOM) chart during prototype design and development. The method comprises the following steps: periodically extracting BOM data of main materials and sub-materials from a source database, establishing a correspondence and quantity details table between main materials and sub-materials, using SQL queries and material hierarchy restructuring to convert the data according to the material hierarchy, generating multiple hierarchical conversion tables of main materials and sub-materials, and loading these tables into a target SQL Server database; establishing a database connection in Excel, updating and querying the hierarchical conversion tables, and extracting BOM data at each level and displaying it in multiple worksheets; reconstructing the single-level BOM data displayed in the multiple worksheets according to the hierarchical structure by converting multiple rows to multiple columns, and finally summarizing them into a single multi-level BOM chart; periodically extracting material information at each level from the multi-level BOM chart, automatically generating node relationship data through Kettle's conversion and job scheduling functions, and periodically updating it to a Neo4j database; and using a D3 force-directed graph to graphically display the multi-level BOM chart based on the node relationship information in the Neo4j graph database. This invention improves the automation and visualization of BOM data processing.

This invention discloses an integrated method and system for the entire lifecycle processing of spot contracts in the industrial sector, relating to the field of industrial MES / ERP technology. This invention uses a single database stored procedure as a unified entry point to centrally realize all lifecycle operations of spot contracts, including creation, modification, addition / deletion of product batches, and cancellation. Batch data transmission is achieved through table-valued parameters, with contract hash values ​​serving as unique identifiers. This is combined with automatic contract number generation, pre-emptive centralized verification, and database transaction control. Furthermore, it uses standard SQL syntax to support cross-database compatibility (SQL Server, GaussDB, DMDB). This invention solves the problems of fragmented business logic, cumbersome operations, data chaos, and poor cross-platform adaptability in traditional spot contract management. It achieves fully automated and standardized processing of spot contracts, reducing system maintenance costs by over 80% and improving data processing efficiency by 90%. It is suitable for large-volume, high-frequency business scenarios in industrial spot trading and meets the needs of enterprises for domestic transformation. This invention has been fully implemented in actual industrial MES systems and can operate stably in real production environments for a long time, demonstrating mature engineering value and industrial promotion capabilities.

The invention discloses a rapid cable design method for a carriage of a refrigerator car. The rapid cable design method comprises the following steps: (1) reading a wiring space; (2) reading coordinate points of the electrical equipment, namely judging whether the parts are the electrical equipment or not by traversing the parts of the assembly tree and combining with an SQL server electrical equipment database; reading coordinate points of the electrical equipment to serve as a starting point and an ending point of an algorithm; (3) performing path planning by using an improved A * algorithm; (4) establishing a cable model, and expressing data as a model entity; (5) defining a wiring relation; (6) outputting wiring information; according to the method, a traditional wiring system cannot recognize a space area where wiring can be conducted in the compartment of the refrigerator car, the method for dividing the space where wiring can be conducted in the compartment of the refrigerator car is given in detail according to characteristic analysis of the compartment of the refrigerator car, detailed implementation steps in SolidWorks are described, and finally the feasibility of the method and the system is verified through an instance model.

This invention discloses a paperless, systematic, and mobile-based collaborative management method for the entire industrial production process, belonging to the fields of industrial manufacturing execution systems and industrial digital management technology. Based on an integrated underlying architecture, this invention completely eliminates the paper-based document circulation model. Using the plan number / material number as the unique core identifier for the entire process, it builds a digital management system comprising a back-end management terminal and a lightweight mobile terminal. This enables systematic input of information across all stages of industrial production, including production planning, process quality inspection, equipment inspection, and anomaly handling; real-time mobile operation; and full lifecycle data linkage. The system automatically generates tamper-proof digital logs for all operations based on the underlying architecture, supports one-click full-link traceability by plan number / material number, and can seamlessly integrate with modules such as production planning management and intelligent reminders to form a closed-loop, systematic management system for the entire process. This invention addresses industry pain points such as information transmission failures, traceability difficulties, low efficiency, and data disconnection under traditional architectures, significantly improving the precision and intelligence of production management. Moreover, this method can only be implemented based on an integrated underlying architecture, which cannot be adapted to traditional modular architectures, forming a unique technical barrier. All database operations adopt standard SQL basic syntax, are compatible with both SQL Server and GaussDB platforms, have strong implementation and high scalability, and can be widely applied to various industrial production line management scenarios.

The present application relates to a method, device, electronic device and storage medium for building a SQL Server database with high availability technology, which belongs to the technical field of databases, wherein the method comprises the following steps: receiving a building request sent by a first user, wherein the building request carries a first node address; determining a primary node associated with the first node address; creating mirror information corresponding to the primary node based on a preset script file; building an auxiliary node according to the mirror information and the first node address and a preset AlwaysOn configuration function, and generating building information; and feeding back the building information to the first user. The SQL server automatically creates auxiliary nodes for the database, reducing the work that users need to do to create them manually. The present application has the effect of improving user work efficiency.

Embodiments as disclosed allow identity management with respect to SQL database by discovering substantially database objects and their entitlements and associating them with corresponding identities within the identity management system, thus providing insights into such SQL server entitlements and their associated identities, even across multiple SQL servers within an enterprise environment.

This invention discloses an integrated automated processing method and system for sales settlement across all scenarios, featuring AI-based pre-parameter verification, belonging to the field of financial settlement technology for industrial ERP / MES systems. Based on a unified stored procedure architecture, this invention incorporates an AI-based pre-parameter verification module, supporting settlement of spot and futures contracts, as well as real-time price locking and post-pricing modes. It achieves batch parameter transmission through table-valued parameters, combined with automatic settlement number generation, transaction-level atomicity guarantees, multi-table automatic updates, financial auditing and access control, automatic generation and printing of settlement documents, and full-link operation tracking, realizing automated and standardized management of the entire sales settlement process. This invention solves the problems of traditional settlement systems, such as limited scenario adaptability, fragmented operations, low efficiency, data error susceptibility, lack of traceability, and inability to integrate with AI. It adopts standard SQL syntax to adapt to multiple database platforms such as SQL Server and GaussDB, possessing cross-database compatibility and independent controllability. This invention has been fully implemented in actual industrial MES systems and can operate stably in real production environments for a long time, demonstrating mature engineering value and industrial-scale promotion capabilities.

The application discloses a kind of industrial finished material contract cancellation full-process automation processing methods, belong to industrial ERP / MES sales and inventory management field.The application uses front and rear independent research and development deep fusion architecture, seamlessly connects through self-research front end interface and rear storage process, realizes multi-mode contract cancellation automation processing;Through front and rear double check intercepts illegal operation, automatically corrects attribute according to material type, resets inventory, updates contract hash value;Whole transaction control, exception automatically rolls back, and complete record traces information, forms end-to-end closed loop.The application is compatible with SQL Server and Gauss DB, has actually landed in industry, can standardize process, avoid data confusion, improve management automation level, and has strong expansibility and maintainability.

The invention discloses a multilayer tubular column pulsed eddy current electromagnetic response simulation system, which realizes rapid simulation analysis on eddy current response of a complete and defective multilayer tubular column by integrating analytical calculation and finite element simulation technologies. The system is composed of a human-computer interaction interface, a background integration module and an SQL Server database management system, and supports parameterized input, dynamic calling of a background module and result storage. A user can set tubular column parameters, defect parameters and excitation parameters through an interface, analysis and demodulation and a finite element simulation process are automatically carried out, and finally an eddy current response signal is obtained through simulation calculation and stored in a database. According to the system, a large number of industrial tubular columns are simulated, a rich eddy current sound signal response database can be constructed, response signal data can be quickly retrieved and expanded in real time in actual engineering operation, and the industrial simulation efficiency is remarkably improved.

The present application relates to a method, device, electronic device and storage medium for creating an index of a SQL Server database, which relates to the technical field of SQL Server databases, wherein the method comprises the following steps: in a preset index database, regularly obtaining change information in all index tables, wherein the change information comprises an index to be detected and a change condition field; based on the index to be detected, executing a preset query instruction; if the index to be detected cannot match a corresponding file, processing the change condition field according to a preset change model to obtain a data update index; updating a preset search tree according to the data update index to obtain node update information; and sending the node update information to a user. The present application has the effect of improving user experience.

The invention provides a construction quality inspection knowledge base construction method based on natural language extraction and BIM fusion, and the method comprises the steps: firstly obtaining a construction BIM model, extracting BIM information contained in the BIM model through an Ifopen Shell tool, and storing the BIM information as a BIM information table; and then identifying inspection knowledge in the construction quality file by utilizing a gated loop unit model improved based on a deep bidirectional encoder and knowledge feedback in combination with a self-attention mechanism, extracting knowledge information in a text document, and storing the knowledge information as a quality knowledge table. And combining the first information form and the second information form into a BIM-coupled quality knowledge table through word vector semantic similarity matching of three dimensions, combining the BIM information table and quality knowledge into the BIM-coupled quality knowledge table, and constructing a construction quality inspection knowledge base by utilizing an SQL Server. And establishing a virtual-real fusion scene by utilizing Unity, and writing a program to call a knowledge base in the virtual-real scene. The step of knowledge retrieval in quality inspection is simplified, and the efficiency of construction quality inspection is improved.

This invention presents a unified processing method for eight business processes in an industrial finished goods warehouse based on table-valued parameters, relating to the fields of industrial MES and database security technology. This method encapsulates all eight processes—normal inbound, normal outbound, other inbound, other outbound, and corresponding queries—into stored procedures, using table-valued parameters as unified input parameters and standard SQL to achieve cross-database compatibility. A fully enclosed security architecture prevents direct front-end access to data tables, eliminating SQL injection and unauthorized operations at the source. Layered business logic, strong transactions, and pre-validation ensure data consistency, achieving controllable, secure, and standardized unified management of all finished goods warehouse business processes. This invention is applicable to industrial scenarios such as metallurgy and manufacturing, and can run seamlessly in databases such as SQL Server and GaussDB, improving system security, stability, and maintainability. This invention has been fully implemented in a real industrial ERP system, can run stably in real production environments for a long time, and possesses mature engineering value and industrial promotion capabilities.

Methods, systems, and computer program products for constructing and executing multi-step query plans in a database application are provided. The database application accepts a query, such as, for example, a graph query. The database application generates a physical query plan that includes a set of execution steps to execute the query. The set of execution steps includes at least an initial step, an intermediate step, and a final step. The database executes the query by passing control to the initial step, and passing execution control to some other step when the initial step is completed. The intermediate step executes and, when completed, may pass execution control to any other step, including itself. Steps may be configured to transfer arbitrary data between steps. The generated query plan may also include multiple multi-step sequences, and such sequences may be configured to be executed alternately based on intermediate query results or parameters included in the query.

A method of conversion of mapping formats into OpenDrive HD map formats is provided. The method includes retrieving geodatabase data to form a SQL Server or a PostgreSQL database. The method also includes reading one or more shapefiles and one or more OpenStreetMap (OSM) files for extracting relevant road network data. The method also includes checking for one or more missing tables or one or more fields in the database or shapefiles to ensure that one or more required fields are non-null. The method also includes processing the relevant road network data and preparing for conversion. The method also includes creating an OpenDrive (.XODR) file from the relevant road network data, tailored to meet one or more regional traffic simulation specifications for generating an OpenDrive map. The method also includes rendering the OpenDrive map via a user interface to a user, wherein the user is allowed to specify one or more input parameters for editing one or more map elements in the OpenDrive map.

The application relates to a method for managing data in a pipe jacking engineering construction process, adopts a pipe jacking engineering construction process data management system composed of a WEB system, a data summary processing module, a data viewing module, a visual report control, a mobile terminal, a SQL Server database, a data pushing service, a PLC collection system and an environment monitoring system, and comprises the following steps: 1) presetting basic information; 2) acquiring external data; 3) a data center: all data are stored in the SQL Server database, external data are connected and analyzed, an independent data table is established, and data support is provided for the management system; 4) jacking data calculation; 5) jacking data analysis; 6) pipe joint information calculation; 7) soil layer data positioning; 8) daily report layout; and 9) data pushing. The application can be used for managing data generated in a pipe jacking construction process, can be improved according to requirements, can be infinitely expanded, and can be connected with different external data.