35 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.

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 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 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.

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 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.

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.

The invention discloses a storage process calling and business process decoupling method and system based on declarative configuration, the system comprises a CHECK module, a grammar parser, a storage process execution layer and a business process control layer, the CHECK module outputs configuration information to the grammar parser, the grammar parser transmits a parsing result to the storage process execution layer, and the business process control layer controls the storage process execution layer to execute the business process. According to the method, the decoupling capacity is improved, when the storage process is changed, only configuration files of the CHECK module need to be modified, the modification amount of service codes is reduced by 90% or above, hundreds of lines in a traditional method are reduced to several lines, the development efficiency is improved, the development period is shortened by 30%-40%, and the development cost is reduced by 30%-40%. Different developers can independently modify the storage process and the business process, code conflicts are reduced, the expandability of the system is enhanced, the scheme supports multiple database types, such as SQL Server and MySQL, and can easily adapt to different business processes, and the expandability is improved by more than 50%.

The application discloses an ERP&MES integrated data fusion method based on a material full-dimension wide table, and relates to the technical field of industrial production information integration.The application takes a unique product code as a primary key, constructs a material wide table covering the whole life cycle as a core base, matches TVP standardized interaction, double-layer mistake-proofing verification, AI access reservation capability, is compatible with SQL Server and Gauss DB dual databases, and accurately retrieves fields according to requirements in the core design of each business module.The application realizes homology, unified caliber, efficient operation, safety controllability and intelligent scalability of ERP-MES-finance data, solves problems such as data island, inconsistent caliber, difficult business linkage and high development and maintenance cost in the traditional architecture, supports complex business and intelligent upgrading, and is suitable for integrated management in multiple industrial production fields.The application has been completely applied in actual industrial system ERP&MES, can be long-term and stable in real production environment, and has mature engineering value and industrialization popularization capability.

The embodiment of the invention provides a database monitoring method and device, electronic equipment and a storage medium, and belongs to the technical field of databases. The method comprises the steps that in response to a first instruction, a target disaster recovery database is displayed on a newly-added task interface, and a disaster recovery check task is established according to the target disaster recovery database; if the target disaster recovery database type comprises an Oracle database, querying disaster recovery application delay of the target disaster recovery database by adopting an SQL statement, and obtaining a disaster recovery result according to the disaster recovery application delay; if the target disaster recovery database type comprises an SQL Server database, querying the target disaster recovery database by adopting an SQL statement to obtain a disaster recovery result; and in response to the second instruction, displaying the target disaster recovery database and the disaster recovery result on the task result viewing page. According to the embodiment of the invention, the database can be automatically monitored, the disaster tolerance problem of the database can be found in time, the operation and maintenance time is shortened, the system safety and stability are improved, and the user experience is improved.

A method for automatically generating a PLC program for a crane relates to the technical field of crane control. The method comprises the following steps: S1, library creation: creating standard function blocks in TIA Portal software based on hardware devices, and classifying and installing the standard function blocks to create standard library files; creating call logic relationships in the standard library files into call files, and storing them in a SQL Server database; the call logic is divided into configuration call logic, selection call logic, and variable call logic, wherein the configuration call logic is based on the type identifier of the hardware device in the TIA Portal software, and calls the TIA Portal OPENNESS interface through C# according to the type identifier of the hardware device to create a corresponding hardware device configuration; S2, human-computer interaction: an operator adds the hardware devices included in the design drawings to the configuration interface of the Espace interface according to the project design drawings, and defines the parameters of the hardware devices. The method is simple to operate and highly portable; a library can be reused after it is created once, thereby reducing repetitive work.

This invention discloses an integrated method for dynamic contract modification based on a unified stored procedure, achieving deep integration of ERP and MES. Belonging to the field of intelligent manufacturing, it is applicable to continuous production industries such as metallurgy and steel. This invention uses a unified table type as the parameter entry point, integrating eight operations into a single stored procedure to construct a closed-loop process of application-review-execution-lock-off. Through dual-review interlocking and intelligent identification of production status, it prevents tampering with completed products. During modification execution, it achieves one-click synchronization of multiple tables in ERP and MES. Full-process operation traceability, critical data locking, and transaction control ensure security, and it is compatible with SQL Server and GaussDB. This invention breaks down the barriers between dual systems, solving pain points such as data asynchrony, non-closed-loop processes, and chaotic permissions. It has been practically applied and possesses mature engineering and promotional value.

Methods, systems, and computer program products are provided that construct and execute multi-step query plans in a database application. A database application accepts a query such as, for example, a graph query. The database application generates a physical query plan comprising a set of execution steps that perform the query. The set of execution steps comprises at least an initial step, an intermediate step and a final step. The database executes the query by passing control to the initial step that, when complete, passes execution control to some other step. The intermediate step executes and when complete, may pass execution control to any other step including itself. Steps may be configured to communicate arbitrary data between steps. The generated query plan may also comprise multiple multi-step sequences, and such sequences may be configured to execute in the alternative based on intermediate query results, or a parameter included in the query.

This application relates to a SQL Server database-based migration method, apparatus, electronic device, and storage medium, and relates to the technical field of data transmission. The method includes the following steps: receiving a migration request uploaded by a user, the migration request carrying first address information of a first server and information to be migrated; determining a second server associated with the first server and its corresponding second address information, and generating a migration path; obtaining a database and corresponding available storage capacity on the second server; based on the database and its corresponding available storage capacity, screening idle databases that match the information to be migrated; and transferring each file matching the information to be migrated to an idle database according to the migration path. This application reduces user workload.

Embodiments for creating transactional consistent snapshot copies of SQL server containers in a Kubernetes system for copy reuse on different clusters to facilitate processing local snapshots for secondary workloads without impacting production quality of service. A copy data management (CDM) tool acts as an orchestrator, while a backup toolkit is deployed in the namespace of the production cluster containers. A container storage interface (CSI) plugin supplies persistent storage to the containers. Before taking a copy, the process posts the toolkit in the container and a quiesce / unquiesce operation is then performed. The databases are first quiesced, the snapshot copy is taken, and then the databases are unquiesced. The toolkit is then removed, thus producing a transactional consistent backup in a different namespace.

The application discloses a device and method for constructing a protocol based on an SQLSERVER database, and relates to the technical field of industrial automation and data communication, which comprises a protocol meta-database module, a protocol engine module, a dynamic node generator module, a version and audit module, a cross-protocol mapper module and a management configuration interface module, wherein the protocol meta-database module is connected with the protocol engine module, the protocol engine module is connected with the dynamic node generator module, the dynamic node generator module is connected with the version and audit module, the version and audit module is connected with the cross-protocol mapper module, and the cross-protocol mapper module is connected with the management configuration interface module. Through efficient cooperation among the protocol engine, an OPC server and a client, real-time processing and dynamic updating of data flow in the field of industrial automation are realized.