Patents
Literature
Patsnap Eureka AI that helps you search prior art, draft patents, and assess FTO risks, powered by patent and scientific literature data.

42 results about "User-defined function" patented technology

A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment.

Rule engine configuration method and device based on machine learning, equipment and storage medium

The invention belongs to the technical field of artificial intelligence, is applied to the field of financial science and technology and the field of medical health, and discloses a rule engine configuration method, device and equipment based on machine learning and a storage medium. The method comprises the steps that historical calculation data and performance indexes in historical calculation tasks are collected, and a training data set is constructed; a machine learning model is trained, and algorithm parameters of the rule engine are dynamically optimized through the training data set; configuring an expression and a user-defined function of a rule engine, and realizing analysis and execution of scripts through JEXL (JavaScript Exchange Library); establishing a dynamic mapping relationship between the algorithm configuration library and the business variables, mapping algorithm variable names and business variable names, and generating configurable algorithm rules; and analyzing task load and resource requirements based on a pre-trained machine learning model, distributing system resources, and repairing abnormal behaviors in a calculation process. According to the invention, the problems of low processing efficiency, high maintenance cost, unreasonable resource allocation and poor expandability in the prior art are solved.
Owner:CHINA PING AN LIFE INSURANCE CO LTD

Data compression for real-time analytics

Systems and methods for compressing and querying data for real-time analytics. The system can receive log data and generate an intermediate representation by parsing a log template and variables from the log data into a columnar format. The method includes generating a compressed intermediate representation associated with an index type and storing the compressed intermediate representation in the columnar format based on the index type. The method includes receiving a search query and analyzing the search query to identify a user defined function. The method includes parsing the search query to convert the search query into one or more predicates that satisfy the search query. The method includes filtering the compressed log data based on the one or more predicates and providing a query result.
Owner:UBER TECHNOLOGIES INC

Data simulation method and system based on database function and timed task

The invention discloses a data simulation method based on a database function and a timed task. The method comprises the following steps: S1, acquiring source data based on a multi-modal lightweight intelligent acquisition strategy; s2, performing data cleaning and standardization so as to ensure engineering processing of simulation data quality and consistency; s3, creating a user-defined function in the database to package intelligent logic of data simulation; according to a time condition and a data mode in the timed task, intelligently performing simulation trigger judgment and simulation data generation through the user-defined function; s4, performing efficient data injection based on a buffer and batch optimization mechanism of the intermediate table; and S5, performing timed task period regulation and control. The invention further discloses a corresponding system, electronic equipment and a computer readable storage medium.
Owner:GUANGZHOU HUIYUN NETWORK TECH CO LTD

First class database object server application

A data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.
Owner:SNOWFLAKE INC

Using custom functions to access a cloud-based data warehouse

ActiveUS12717816B1Data setEngineering
Using custom functions to access a cloud-based data warehouse including: receiving, by a workbook manager from a client computing system, a call to a first user-defined function input to an element of a workbook, wherein the workbook presents a dataset from a cloud-based data warehouse, wherein the first user-defined function is defined in the workbook manager; and executing, by the workbook manager and in the cloud-based data warehouse, based on the call to the first user-defined function, a second user-defined function defined in the cloud-based data warehouse.
Owner:SIGMA COMPUTING INC

A pallet rental data management method, system, intelligent device, and storage medium

This invention discloses a pallet rental data management method, system, intelligent device, and storage medium. The method includes: obtaining the user identifier of the current user and the database identifier of the currently accessed database; obtaining a customer number list string based on the user identifier and database identifier; saving the customer number list string to a session variable; establishing a custom function to obtain the customer number list string; splitting the customer number list string into a row-based list view; establishing a data view for the relevant data tables in the currently accessed database; associating the list view with the data view to obtain the associated view; setting the relevant data tables to write-only; obtaining the query information input by the current user; retrieving result data from the associated view based on the query information; and providing the result data back to the current user. This invention ensures effective isolation of data in the shared pallet rental system and guarantees the confidentiality of user data.
Owner:深圳市普拉托科技有限公司

A method and system for generating and testing custom functions of a database

The present invention discloses a method and system for generating and testing user-defined functions in a database. The method comprises the following steps: building a retrieval corpus containing function semantic fragments based on official documents of a database system; adopting a hierarchical strategy to build multi-layer prompt information based on the function semantic fragments, structured requirement information and example guidance templates; a function creation model adopts a streaming generation and syntax verification mechanism based on the multi-layer prompt information to generate a user-defined function creation statement; injecting the statement into a database system to execute a creation operation; if the execution is successful, performing correctness verification on the generated user-defined function; when the verification result is passed, recording metadata and a boundary value sample set of the user-defined function, and generating a corresponding user-defined function entity; constructing a database test statement group based on the metadata, boundary value sample set and target database structure of the user-defined function entity, and performing automated testing on the user-defined function entity.
Owner:SHANGHAI ANBAN INFORMATION TECH CO LTD

Custom formulas in office cloud platform add-in

The present disclosure involves systems, software, and computer implemented methods for enabling custom formulas in a cloud platform office add-in. An example method includes automatically loading a public landing page of a cloud platform add-in of a spreadsheet application. The public landing page includes a declaration and a first implementation of at least one custom function. Login credentials for a customer tenant of the cloud platform are obtained. A redirect is performed to a private web application for the customer tenant. The private web application includes, for each custom function, a second implementation that is configured to retrieve customer-specific cloud platform data of the customer tenant. Each first implementation of a custom function is replaced with the second implementation of the custom function. In response to a user request in the spreadsheet application to use a first custom function, the second implementation of the custom function is invoked.
Owner:SAP SE

Simulated liquid level dynamic control method based on Fluent continuous casting tundish

The invention discloses a simulated liquid level dynamic control method based on a Fluent continuous casting tundish, which comprises the following steps: S1, establishing a geometric model of the tundish and a long nozzle, and carrying out grid division; s2, importing the geometric model of the tundish and the long nozzle subjected to grid division into Fluent software, and setting calculation parameters; s3, developing a Fluent user self-defined function, and importing the Fluent user self-defined function into Fluent compiling; and S4, after the user-defined function is imported into Fluent to be compiled, analog calculation is started, and dynamic control over the liquid steel level in the tundish is achieved. The method has the advantages that real-time dynamic control of the liquid level of the molten steel in the tundish in the simulation process is achieved, the liquid level is accurately controlled, the limitation of single-phase flow or constant flow assumption adopted in a traditional simulation method is overcome, the actual production working condition is met, and the consistency of the simulation result and the actual production process is remarkably improved.
Owner:NANJING IRON & STEEL CO LTD

Custom replacement of functions with inverse functions for improved query performance

Techniques and solutions are provided for improving query performance using inverse functions. Often a function is used to perform operations such as data type conversions. The use of these functions can be resource intensive, such as if a conversion needs to be performed for all rows of a particular relational database table. The present disclosure allows for the registration of inverse functions that can be used, or at least be considered for use, in place of a function. A given inverse function can be associated with its function using techniques such as maintaining mapping information or using a particular naming convention. A particular syntax is provided for designating and creating an inverse function.
Owner:SAP SE

Tunnel train fire smoke spreading prediction method based on machine learning

The invention discloses a tunnel train fire smoke spreading prediction method based on machine learning, which comprises the following steps: S1, carrying out numerical simulation in Fluent, realizing variable-speed movement of a train and a fire source through a user-defined function (UDF) technology, and recording the change condition of the temperature of a key point along with time and the change condition of the carbon monoxide density along with time; s2, realizing multi-working-condition automatic solution and automatic data storage through a supercomputing platform and a PyFluent technology; the temperature distribution and the smoke concentration of the key evacuation position are obtained, and a learning sample is provided for the rapid prediction technology of the evacuation condition in the railway tunnel; and S3, training the recurrent neural network model to realize rapid prediction of disaster-causing parameters of the key point location. According to the method, the reduction degree is higher, the method better fits the actual situation, the CNN-LSTM model obtained through key input variable training is selected, and the flue gas spreading situation in the tunnel can be achieved.
Owner:BEIJING JIAOTONG UNIV +3

Industrial intelligent software development method and platform fusing model-driven architecture

The invention discloses an industrial intelligent software development method and platform of a fusion model-driven architecture, relates to the technical field of industrial software, and solves the problems that a traditional development mode is difficult to flexibly adapt to complex and changeable industrial scenes, the service logic reusability is poor, a UI and a core service are disjointed, and the collaboration efficiency of all stages is low. A user-defined function is supported through a data modeling tool, input and output attributes are visually defined, and flexible data structure construction under a complex service rule is achieved; the service modeling tool assembles a modular service process based on a domain model library through node dragging, gateway branch control and sub-process nesting; and the UI modeling tool automatically analyzes the attributes of the business model, and matches the template library to generate an interface and a standardized interface. And traditional coding is converted into visual operation, so that the development efficiency is improved, the service change response period is shortened, the maintenance cost is reduced, and industrial software is promoted to be upgraded to intelligence and standardization.
Owner:CHONGQING SAIBAO IND TECH RES INST CO LTD +1

First class database object server application

A data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.
Owner:SNOWFLAKE INC

Enterprise-level low-code-oriented data operation execution system

The application discloses a kind of data operation execution systems for enterprise level low code, specifically relates to low code development technical field, including atomic executor module, dependent parallel scheduling module and debugging sandbox module. Query, new, update, delete, rule check and custom function are uniformly encapsulated as standard atomic executor by atomic executor module, each executor configuration execution condition expression and trigger actual logic when condition is satisfied, while introducing adaptive timeout fuse mechanism to guarantee system stability. Dependent parallel scheduling module constructs data dependency graph between executors by regular matching, and based on topological sorting, non-dependent executors are divided into parallel groups. After priority sorting, they are executed in parallel through thread pool. The application solves the problems of low efficiency of low code platform data operation serial execution, dirty data in debugging process and opaque process, and realizes efficient parallel scheduling and safe and observable debugging experience.
Owner:FIRST KNOWLEDGE INTELLIGENT TECH (SHANGHAI) CO LTD

Method and system for providing indirect visualization access of a data-lake

A method and system of providing indirect and visualization access to data of a data-lake is disclosed. A user request from a user to access the data of the data lake is received. A user profile from a plurality of user profiles associated with the user is determined based on a first level of authentication. The first level of authentication is based on the domain object name and the public key. A user defined function (UDF) from a plurality of predefined UDFs associated with the user profile is determined based on the first level of authentication. A portion of the data of the data-lake requested in the user request is selectively rendered based on a second level of authentication. The second level of the authentication is based on the domain object name and the private key.
Owner:HCL TECH LTD

Code identification method and device, electronic equipment and computer readable storage medium

The invention discloses a code identification method and device, electronic equipment and a computer readable storage medium, relates to the technical field of computers, can be used for identifying risk codes, and comprises the steps that a function calling relation chain of a target application is obtained, and the function calling relation chain is used for describing functions with calling relations in the target application; identifying a user-defined function and a library function in the function calling relation chain; determining a target function library to which the library function belongs; and if the target function library is changed, determining the code of the custom function as a target code needing to be checked. According to the method, blindness of code inspection can be avoided, so that effectiveness of code inspection is improved.
Owner:TENCENT TECHNOLOGY (SHENZHEN) CO LTD

Method, system and equipment for automatically generating control strategy code of stability control system and storage medium

The invention discloses a control strategy code automatic generation method, system and device for a stability control system and a storage medium, and the method comprises the steps: reading and analyzing a stability control strategy description file of a power system, and carrying out the standardization processing; generating a strategy logic general table through multi-table association query, and intelligently converting strategy key elements in the strategy logic general table; and automatically generating a code head file based on a variable declaration framework, realizing control logic through a custom function library and a'condition-execution 'statement, and finally outputting an executable code containing debugging information. According to the method, the problems that traditional manual coding is low in efficiency and prone to errors are solved, the generated codes support multi-platform deployment and have the technical advantages of being complete in debugging information, traceable in variable naming and the like, and the code generation efficiency and system reliability of a power grid stability control strategy are remarkably improved.
Owner:STATE GRID ELECTRIC POWER RES INST +3

Method for acquiring overtemperature area of oil return pipeline of lubricating oil system

The invention provides a method for acquiring an overtemperature area of an oil return pipeline of a lubricating oil system. An oil return pipeline solid domain and a lubricating oil fluid domain are constructed, initial thermal boundary conditions are given, simulation software is used for fluid domain flow thermal coupling calculation, and a first fluid temperature field, a first solid temperature field and a first heat exchange coefficient are obtained; constructing a geometric model solid domain having a heat exchange component with the oil return pipeline, and obtaining a second solid temperature field after heat exchange between the oil return pipeline solid domain and the geometric model solid domain; replacing the first solid temperature field with a second fixed temperature field numerical value, and performing flow thermal coupling calculation again to obtain a second fluid temperature field and a third solid temperature field; the steps are repeated until the difference value between the third solid temperature field and the second solid temperature field meets the iteration requirement; and extracting an over-temperature area in the oil return pipeline solid domain temperature field and / or the lubricating oil fluid domain temperature field meeting iteration requirements. According to the method, the overtemperature area can be accurately judged and captured.
Owner:AECC COMML AIRCRAFT ENGINE CO LTD

Large-model-driven time sequence database user-defined function testing method and system

The embodiment of the invention provides a large-model-driven time sequence database user-defined function testing method and system. The method is applied to the technical field of software testing, and comprises the following steps: extracting domain knowledge related to a user-defined function from a pre-constructed time sequence database knowledge base by adopting a retrieval enhancement generation strategy, and constructing a static analysis instruction based on the domain knowledge; the source code of the user-defined function and the static analysis instruction are input into the first large language model to be analyzed and processed, and a static analysis result is obtained; determining the time sequence characteristics of the test data according to the static analysis result, and generating the test data conforming to the time sequence characteristics by using the fine-tuned second large language model; and constructing a test case according to the test data, and testing the user-defined function by using the test case according to a preset execution strategy to obtain a dynamic test result. According to the method, the user-defined function testing efficiency and accuracy are improved.
Owner:CHONGQING UNIV OF POSTS & TELECOMM

Stain source identification method, stain source identification device, electronic device, and medium

The present application provides a kind of stain source identification method, stain source identification device, electronic equipment and medium.The method comprises: the similarity of the behavior feature vector corresponding to each function in target firmware respectively and target feature matrix is calculated, the similarity score of each function is determined, the behavior feature vector corresponding to each function respectively is determined based on binary program in the target firmware, and the target feature matrix is constructed based on the behavior feature vector corresponding to memory operation function;Based on the similarity score of each function, determine the target function as the stain source, and the target function is used for carrying out stain analysis.The stain source identification method provided by the present application can determine the stain source in the self-defined function of the binary program in the target firmware, and carry out stain analysis, which effectively discovers the security defects existing in binary program.
Owner:INSTITUTE OF INFORMATION ENGINEERING CHINESE ACADEMY OF SCIENCES

Binary executable file password misuse detection method based on dynamic compiling traceability

The invention relates to the technical field of information security, and provides a binary executable file password misuse detection method based on dynamic compilation traceability, which comprises the following steps of: performing local static analysis on an input binary executable file, positioning a sensitive function in the binary executable file and calling a self-defined function of the sensitive function; performing dynamic variation traceability on the parameters of the sensitive function, performing execution by changing parameter values and combining under-constraint dynamic symbols, tracing a real source of the parameters, and performing code accessibility verification in the traceability process to obtain an execution result of the sensitive function; and performing mode matching and constraint solution on the obtained execution result according to a predefined cryptographic security rule, judging whether a password misuse behavior exists or not, and outputting a detection log. Through the technical means of combining dynamic variation traceability and local static analysis, the effect of efficiently and accurately detecting the password misuse behavior in the binary file on the premise of avoiding path explosion is achieved.
Owner:GUANGZHOU UNIVERSITY

Geo-based vector data and raster data joining and / or aggregation using user defined function(s)

Techniques are disclosed herein that enable the generation and processing of user defined functions for customized aggregation and / or joining of instances of agricultural data. Various implementations include agricultural image data which includes one or more high elevation images that capture an agricultural plot. Additional or alternative implementations include transmitting the user defined function to a remote computing device for processing. In some implementations, the user defined function can be processed in tandem with additional user defined functions, where processing of instructions occurring in multiple user defined functions are not repeated.
Owner:DEERE & CO

System cue word generation method and system in urban and rural planning scene, terminal and medium

The invention relates to a system cue word generation method and system in an urban and rural planning scene, a terminal and a medium, and relates to the technical field of large language models.The method comprises the steps that in response to query operation, a planning scene is extracted from an input text, and the planning scene comprises urban and rural planning, traffic planning, municipal planning and the like; acquiring role positioning and task instructions according to the planning scene; determining a planning database corresponding to the planning scene; performing type labeling and semantic annotation on the planning database to obtain a data specification; identifying an analysis task in the planning scene; setting a custom function for the analysis task; and integrating the role location, the task instruction, the data specification and the custom function to obtain a system cue word. The method has the effect of improving the processing efficiency of the system cue word.
Owner:NINGBO PLANNING & DESIGN INST CO LTD

Computer-implemented methods and computing systems for reorganizing data

Computer-implemented methods and computing systems for reorganizing data are disclosed. One or more user defined functions (UDFs) are applied to one or more columns of a data set to generate a hidden column. The data set partitioned according to a first partition scheme and the hidden column are stored in memory of a computing system. A set of queries run against the data set and the hidden column are stored in the memory. Each query in the set of queries and the one or more UDFs are processed with a machine learning model to select a second partition scheme for the data set. The data set in the memory is reorganized according to the second partition scheme.
Owner:HUAWEI TECH CO LTD

An automated penetration testing method, device and medium based on expression language and high concurrency scanning

The application discloses an automatic penetration testing method and device based on expression language and high-concurrency scanning and a medium, and mainly relates to the technical field of penetration testing, and aims to solve the problems of long time consumption, multiple combination tools depending on fragmentation, and lack of flexibility of vulnerability detection rule engine in the prior art. The application comprises the following steps: constructing a front-end and back-end separated system architecture; a back-end service layer delivers task metadata to a message queue; an external network module and an internal network module of a penetration testing engine subscribe or poll a database from the message queue to obtain tasks; the external network module replaces POC template variables with actual parameter values in an execution context, generates a structured request and sends it in parallel, performs normalization processing after receiving a response, executes a precompiled CEL expression in a restricted sandbox and calls a custom function in a preset function library to obtain a vulnerability verification result; and a dynamically scalable pool of the internal network module sequentially obtains subtasks from a local bounded job queue to execute and obtain a vulnerability verification result.
Owner:SOUTHWEST PETROLEUM UNIV

Automatic penetration testing method and equipment based on expression language and high-concurrency scanning and medium

The invention discloses an automatic penetration testing method and device based on expression language and high-concurrency scanning and a medium, mainly relates to the technical field of penetration testing and is used for solving the problems that an existing scheme is long in consumed time, combination tools depend on splitting, and a vulnerability detection rule engine lacks flexibility. Comprising the following steps: constructing a front-end and rear-end separated system architecture; the back-end service layer delivers the task metadata to a message queue; an extranet module and an intranet module of the penetration test engine subscribe to or poll a database from a message queue to receive a task, the extranet module replaces a POC template variable with an actual parameter value in an execution context, a structured request is generated and sent concurrently, normalization processing is performed after a response is received, and the task is obtained. Executing the pre-compiled CEL expression in the limited sandbox and calling a self-defined function in a preset function library to obtain a vulnerability verification result; and the dynamically telescopic pool of the intranet module takes out the subtasks from the local bounded job queue in sequence and executes the subtasks to obtain a vulnerability verification result.
Owner:SOUTHWEST PETROLEUM UNIV

Efficient user-defined function execution and artificial intelligence model invocation

Efficient implementation of user defined functions (UDFs) is provided herein. Specifically, a database management system (DBMS) compiler may receive a UDF and a query that includes a relational operator and an indication of the UDF that is associated with the relational operator. The compiler may attach the UDF to the relational operator in the query plan, which indicates an execution order of components of the query.
Owner:HEWLETT PACKARD ENTERPRISE DEV LP

Accessing data objects using user defined function (UDF) streams

Techniques for accessing data objects using UDF streams include decoding by at least one hardware processor of a first computing node, a first request for a UDF. The first request is generated at a second computing node by one of a plurality of input streams of the UDF. A second request for one or more data objects associated with the UDF is generated at the first computing node using an execution thread assigned to the first request. An authorization of the execution thread is performed using data access rights assigned to the first request. The one or more data objects are retrieved based on the authorization in response to the second request. The one or more data objects are stored in a storage location accessible by the execution thread.
Owner:SNOWFLAKE INC

A memory statistics method, a memory statistics device and a computer readable storage medium

The application discloses a memory statistics method, a memory statistics device and a computer readable storage medium. The address of a target function is acquired, the target function including a function in a preset dynamic library and / or a function in an executable program. A self-defined function is constructed based on the prototype of the target function, wherein the self-defined function calls the target function. The position of the target function in a global offset table is acquired to obtain a relocation address. The global offset table is subjected to relocation processing based on the relocation address. The memory usage of the target function is obtained based on the self-defined function and the global offset table after relocation. In the foregoing manner, the application can simultaneously count the memory allocation of the executable program and the dynamic link library.
Owner:ZHEJIANG DAHUA TECH CO LTD