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

151 results about "Foreign key" patented technology

In the context of relational databases, a foreign key is a set of attributes subject to a certain kind of inclusion dependency constraint, specifically a constraint that the tuples consisting of the foreign key attributes in one relation, R, must also exist in some other (not necessarily distinct) relation, S, and furthermore that those attributes must also be a candidate key in S. In simpler words, a foreign key is a set of attributes that references a candidate key. For example, a table called TEAM may have an attribute, MEMBER_NAME, which is a foreign key referencing a candidate key, EMPLOYEE_NAME, in the EMPLOYEE table. Since MEMBER_NAME is a foreign key, any value existing as the name of a member in TEAM must also exist as an employee name in the EMPLOYEE table.

Data quality monitoring method and system based on knowledge graph

The invention discloses a data quality monitoring method and system based on a knowledge graph. According to the method, data tables and fields in multi-source heterogeneous data are constructed into graph nodes, graph edges are constructed through main and foreign key constraint relationships and field value overlapping analysis, and a data blood relationship knowledge graph is formed; business rules are coded into the atlas to execute data constraint check, and an abnormal data influence range is traversed and tracked through a directed graph; and dynamic monitoring is realized based on the time change of the abnormal score sequence. The invention further provides system implementation including data acquisition and preprocessing, knowledge graph construction, quality monitoring, problem diagnosis and quality evaluation. The method solves the problems that a traditional method is difficult to track the influence range of abnormal data and lacks systematic evaluation, and improves the automation level and accuracy of data quality management.
Owner:GUANGZHOU HUITONG GUOXIN TECH CO LTD

Data security processing method and system based on distributed storage

The invention relates to a data security processing method and system based on distributed storage, and relates to the technical field of computer information processing. The method comprises the following steps: cutting data into encryption fragments with a configurable number by adopting a dynamic fragmentation strategy, and generating a physically isolated dynamic check block in combination with a timestamp to realize tampering prevention; a dynamic threshold value is dynamically calculated based on the data sensitivity index and the node load, and the node is optimized through the reliability score for cooperative decryption; a database table is divided into independent marshalling storage according to main foreign key association, foreign key fields are encrypted by adopting cross keys, and cross-marshalling access needs to meet a multi-key threshold condition; an intelligent threat perception engine is constructed, access logs and threat intelligence are analyzed in real time, and key rotation, fragment replacement and joint defense response mechanisms are dynamically triggered. According to the invention, full life cycle protection of data is realized, and the problems of key leakage risk and cross-table association attack are effectively solved.
Owner:WUHAN ANYU INFORMATION SECURITY TECH CO LTD

Multi-table joint natural language query SQL generation method

The invention discloses a multi-table combined natural language query SQL (structured query language) generation method, which comprises the following steps of: 1, constructing a database meta-knowledge graph, and establishing a triple storage comprising a table structure, a primary and foreign key relationship and business description for each data table; 2, receiving a natural language query request, and calculating the topic relevancy between query semantics and each database table through a pre-trained topic matching model; 3, dynamically constructing a view, and logically associating the database tables of which the theme relevancy exceeds a threshold value to form a temporary view; 4, generating a context enhancement prompt, and combining the temporary view structure, the field semantic description of the view and the view content sample to form a structured prompt; 5, inputting the natural language query and the structured prompt into the large language model to generate candidate SQL statements; and step 6, executing verification and iterative optimization on the candidate SQL statements, verifying logic correctness through SQL execution plan analysis and result sampling, and triggering and prompting a reconstruction mechanism when detection is abnormal.
Owner:THE 28TH RES INST OF CHINA ELECTRONICS TECH GROUP CORP

Power equipment data intelligent interaction method, system, equipment and medium

A power equipment data intelligent interaction method, system, device and medium, comprising: retrieving database table information based on query information input by a user to obtain database table information; performing power equipment knowledge base retrieval based on the query information to obtain business knowledge calculation logic and a context learning example; creating prompts based on database table information, business knowledge calculation logic and context learning examples, and inputting the prompts into the large model to generate database statements; running the database statement and judging whether the statement succeeds or not, and if yes, outputting a query result; otherwise, error correction is carried out, and corrected database statements are obtained and run again; according to database table information retrieval, extraction of table field links, table main and foreign keys and table association relationships can be carried out on user query, the accuracy and performance of model generation database languages are improved, the data query threshold is lowered, and the data utilization efficiency is improved; the power equipment knowledge base can realize flexibility and expandability of business knowledge injection.
Owner:GLOBAL ENERGY INTERCONNECTION RES INST CO LTD +3

Business modeling method, medium and system based on enterprise data asset management platform

The invention provides a business modeling method, medium and system based on an enterprise data asset management platform, and belongs to the technical field of modeling methods.The business modeling method based on the enterprise data asset management platform comprises the following steps that an enterprise data asset catalog is read to generate a data asset list, the method comprises the steps of extracting a foreign key association relationship between data tables to construct an initial entity relationship table, calculating reference frequencies between the data tables to generate an entity association degree matrix, dividing a service domain by adopting a K-means clustering algorithm, counting data table fields in the service domain to generate a data table field mapping table, recording a data table operation sequence to construct a data table operation link diagram, and establishing a data table operation link diagram. The method comprises the following steps: generating a data table node evaluation matrix, dividing sub-domains and determining a core entity, and constructing and training a multilayer neural network model for constructing business affiliation, data table incidence relation and business interface definition of a new data table, so as to solve the defects in the aspects of data asset relation discovery, business modeling automation, service interface generation and the like in the prior art.
Owner:BEIJING NANCAL RUIYUAN DIGITAL TECH CO LTD

Inferring graph model from semantic model

Apparatuses, methods, and computer-readable media infer a graph model from a semantic model that describes source tables and relationships among the source tables. The apparatus identifies at least one primary key for each relationship of a plurality of relationships defined in the semantic model based on whether the relationship is a m:1 relationship or a 1:1 relationship, each relationship defining at least one from-table and one to-table. The apparatus creates a vertex table in the graph model for each source table having a primary key. The apparatus creates an edge table in the graph model for each from-table defined in a m:1 relationship of the semantic model and creates an edge table in the graph model for one of the from-table or the to-table in a 1:1 relationship of the semantic model. Each edge of the edge table is labeled with a source or destination vertex table and a foreign-key.
Owner:MICROSOFT TECHNOLOGY LICENSING LLC

Method for converting relational database into graph database

The invention relates to the technical field of databases, in particular to a method for converting a relational database into a graph database. Comprising the following steps: S1, connecting a relational database by adopting an application framework, and migrating to generate a model file; s2, establishing a graph database, obtaining table names, foreign keys and indexes of the relational database according to the model file, and respectively generating points, edges and indexes corresponding to the graph database; s3, generating insertion statements of points and edges of the graph database, executing insertion operation, and migrating data in the relational database into the graph database; and S4, performing data verification by comparing the metadata, the data volume and the data query result of the relational database and the graph database. The method can adapt to various mainstream relational databases, the difficulty of indiscriminately converting the multi-source relational database into the graph database is realized, and the conversion process comprises points, edges and indexes of the graph database.
Owner:SHANGHAI BIG DATA INC

Large model-based sql statement generation method and device

The invention discloses an sql statement generation method and device based on a large model. The method comprises the steps of obtaining an original question of a user and corresponding table structure information in a database; on the basis of the original question and the table structure information, four structure information query questions are inquired on a large model step by step, and mode link information of the original question is obtained; wherein the mode link information comprises a table name, a field name, a field value and foreign key information; analyzing the category to which the original problem belongs; according to a preset mode corresponding to the category to which the original question belongs, generating a mode structure of the original question by at least utilizing information of the database, the original question and mode link information thereof; and analyzing the large model based on the mode structure of the original problem to obtain an sql query statement of the original problem.
Owner:SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD

Database normalization using statistical analysis

A method for generating schemas to compress storage of denormalized data includes receiving user selection of an initial data table and constructing a snowflake schema to decompose the initial data table into a plurality of tables. Tables in the plurality of tables that are related to one another are connected by foreign keys. The snowflake schema is constructed according to a cost model that balances the cost of storing the plurality of tables and the cost of storing the foreign keys. The method also includes transforming data in the initial data table into the plurality of tables according to the snowflake schema.
Owner:TABLEAU SOFTWARE INC

Internet self-research operation and maintenance management method and device and storage medium

The invention discloses an Internet self-research operation and maintenance management method and device and a storage medium, and the method comprises the steps: analyzing a current operation and maintenance management demand, and determining and selecting at least one target instance according to an analysis result; extracting an associated foreign key of the target instance, and dynamically associating the target instance based on the associated foreign key to form a target entity set; service configuration information based on the target entity set is obtained, and dynamic key value pair configuration of the target entity set is updated according to the service configuration information; and generating a task flow arrangement template based on the updated target entity set, and scheduling a task object to execute a task chain through the task flow arrangement template. According to the method, a multi-level configuration management framework and a template task chain mechanism are established, environment self-adaptive differential execution is supported after multi-level configuration parameters are automatically combined, the operation and maintenance efficiency and the full-link execution monitoring and auditing tracing capability are improved, and the risk of manual operation errors is reduced.
Owner:SHENZHEN BAOYI NETWORK TECH CO LTD

Database relation intelligent discovery and ER graph construction method and self-evolution learning method

The invention provides a database relationship intelligent discovery and ER graph construction method and a self-evolution learning method, and belongs to the technical field of ER graph construction, and the database relationship intelligent discovery and ER graph construction method comprises the steps of S1, metadata collection and preprocessing; s2, vectorizing domain sensing metadata; s3, recalling a multi-strategy candidate relationship; s4, performing LLM structured reasoning and verification; s5, carrying out data sampling inspection and cross validation; s6, hierarchical negative sample self-evolution learning; and S7, generating and visualizing an ER graph. According to the invention, a layered negative sample self-evolution learning mechanism and the structured reasoning ability of LLM are organically combined, and LoRA rapid fine tuning and a multi-stage verification process are supplemented. The defects of accuracy, generalization ability, cold start efficiency, reasoning transparency, automation integration and the like in the aspect of discovery of the primary and foreign key relationship of the relational database in the prior art are effectively overcome, and a more advanced and practical solution is provided.
Owner:JIUZHANG ARITHMETIC (ZHEJIANG) TECH CO LTD

NL2SQL method based on foreign key completion and knowledge graph

The invention belongs to the technical field of database query and natural language processing, and provides an NL2SQL method based on foreign key completion and a knowledge graph, and the method comprises the steps: extracting a candidate foreign key relationship from database metadata and data content, and trimming and completing the candidate foreign key relationship through a three-layer funnel verification mechanism, a Schema knowledge graph is constructed; based on the natural language query, determining a seed table set directly related to the query intention; on the basis of the Schema knowledge graph, calculating a connection path between nodes of a seed table, complementing an intermediate table on the path, and expanding the seed table into a sub-graph set containing a complete connection relationship; generating a plurality of candidate SQL statements based on the sub-chart set; and executing the plurality of candidate SQL statements, and voting according to the consistency of execution results to select a final SQL statement.
Owner:XIAMEN UNIV +1

Data processing method and system based on data security management

The invention relates to the technical field of data processing, and particularly discloses a data processing method and system based on data security management, and the method comprises the steps: S1, obtaining a table name, a primary key value, a field value and a foreign key value in a database, and building an association line among the table name, the primary key value, the field value and the foreign key value; representing the elements by nodes to form a data association tree; s2, some nodes are preset as sensitive nodes, and the longest path from the sensitive nodes to the bottom end of the tree is found; s3, for each piece of data in the database, calculating the shortest path length from a node corresponding to the data to a sensitive node, and calculating a sensitive association index according to a preset coefficient; classifying the data into different security levels according to the sensitive association index; the invention aims to identify and manage the data security in the relational database by constructing the data association tree.
Owner:SHANGHAI HUASHANG INFORMATION TECHNOLOGY CO LTD

Machine learning based data structuring system and method for automating a dimensional data modelling process in data repositories

A machine learning based data structuring method for automating dimensional data modelling process in data repositories is disclosed. The ML-based data structuring method includes obtaining datasets from databases; classifying the data comprising attributes and measures based on historical data using a ML-based classifier model; determining associations between the datasets using primary and foreign keys, SQL logs, usage of the datasets in creating transformations, and performance of fuzzy string match; assigning weightages to the determined associations between the datasets based on utilization of the determined associations using weighted network graphs; validating the determined associations between the datasets based on recurrent utilization of the determined associations; clustering the datasets based on the validated associations between the datasets by detecting dimensional models in the weighted network graphs; and generating actionable insights on each of the clustered datasets by performing exploratory data analysis, influencer analytics, and forecasting of the data.
Owner:TESSER INSIGHTS INC

Test data generation method

The invention provides a test data generation method. The method comprises the following steps: acquiring field types of business fields in a plurality of business data tables of a specified business database; obtaining business data associated with each business field according to a data desensitization strategy matched with the field type of each business field; generating a structured file according to each business field and business data; obtaining a primary and foreign key relationship among business fields in the plurality of business data tables; and according to the structured file and the main and foreign key relationship, generating test data for testing each service field, thereby realizing accurate identification and processing of sensitive fields, avoiding information leakage, and ensuring that the generated test data not only conforms to the field type and service scene of the actual service field, but also conforms to the service scene of the actual service field. The logic correctness of the generated test data is ensured, and the effectiveness and accuracy of the test data are improved; meanwhile, manual operation is not needed in the test data generation process, and the labor cost and the test data generation time are reduced.
Owner:CLP JINXIN SOFTWARE (SHANGHAI CO LTD

Technique for generating views of archived business data

An apparatus, a method and a non-transitory computer readable medium are described herein related to generating views for archived business objects. The views display query results which are retrieved from a relational database for archived business data. The views are generated with a view generator which makes use of both a catalog, a standard business object and a business object parser which may detect differences in terms of field names and foreign-key relationships between a standard business object and a customer-enhanced business object. The combination of standard business objects with a business object parser enables the re-use of components from a standard library of business objects across various clients without resulting data loss, especially when there are client-specific deviations from the standard model of business objects.
Owner:BUSINESS MOBILE AG

Processing method, device and equipment of power grid project database and storage medium

The invention discloses a power grid project database processing method and device, equipment and a storage medium. The method comprises the steps that all GIM initial data of a target power grid project and unified management of multi-version and multi-type data are acquired; extracting header information of each piece of GIM initial data, and determining an extension file corresponding to each piece of GIM initial data according to the header information; each piece of GIM initial data is stored in each data table structure; processing each data table structure according to a relational database management system technology so as to extract a unique identifier of each piece of GIM initial data; determining primary key information and foreign key information corresponding to each data table structure; and constructing a target database based on each data table structure, the unique identifier, the primary key information and the foreign key information. According to the processing method of the power grid project database provided by the embodiment of the invention, the efficiency and quality of power grid project data management can be remarkably improved, and a solid technical basis is provided for sustainable development and intelligent upgrading of power grid projects.
Owner:STATE GRID ECONOMIC TECH RES INST CO LTD +2

Prediction method, device and equipment and readable storage medium

The invention discloses a prediction method, device and equipment and a readable storage medium, and the method comprises the steps: obtaining a relational database containing a to-be-predicted object in response to a prediction request, taking a business object in an entity table in the relational database as an entity node, taking a business event in an event table as an event node, and carrying out the prediction of the to-be-predicted object. And determining edges between the entity nodes and the event nodes according to foreign keys corresponding to the business events in the event table, and constructing a target topological graph according to the entity nodes, the event nodes and the edges between the entity nodes and the event nodes. Therefore, the target features of the to-be-predicted object are automatically extracted from the whole target topological graph, original data in all tables in the relational database are fully utilized, human intervention of feature engineering is reduced, the prediction efficiency is improved, the complex relation between the to-be-predicted object and other data in the relational database can be better captured, and the prediction accuracy is improved. And the accuracy of model prediction is improved.
Owner:ALIPAY (HANGZHOU) INFORMATION TECH CO LTD

Database selection rate determination method and device, medium and product

The invention provides a database selection rate determination method and device, a medium and a product. The method for determining the selection rate of the database comprises the steps of obtaining a query statement, wherein query conditions of the query statement comprise connection conditions of a foreign key reference table and a foreign key referenced table; searching and storing a reference column filtering condition about a reference column of the foreign key referenced table in the query statement; obtaining an initial foreign key connection selection rate for the foreign key reference table and the foreign key referenced table, wherein the initial foreign key connection selection rate is one fraction of the total row number of the foreign key referenced table; and correcting the initial foreign key connection selection rate according to a reference column filtering condition to obtain a finally used foreign key connection selection rate. Therefore, according to different filtering conditions, the method can be suitable for a more appropriate foreign key connection selection rate, so that the cardinality estimation accuracy of the connection query of the foreign key reference table and the foreign key referenced table is improved.
Owner:CETC JINCANG (BEIJING) TECH CO LTD

Join specific materialized view query rewrite for queries using unified dimension tables

A method and one or more non-transitory storage media for materialized view-based query rewrite are provided. A plurality of materialized views is created based on a fact table and a dimension table. Each materialized view is based on a join between the dimension table and the fact table based on a respective foreign key column of the fact table. A database management system executes a query against the fact table and the dimension table, the query requiring one or more joins between the dimension table and the fact table based on one or more foreign key columns. For each given join of the one or more joins, responsive to the given join satisfying one or more rewrite criteria, the query is rewritten to replace the join between the dimension table and the fact table with a join between a respective materialized view for the given join and the fact table.
Owner:ORACLE INT CORP

Database table business domain division method and device, medium and product

The invention discloses a business domain division method and device for a database table, a medium and a product, and relates to the technical field of data processing. According to the scheme, when the business domain grouping requirement of the database table exists, from the three aspects of the structure, the semantics and the behavior of the database table, the similarity degree of three dimensions including the foreign key relation, the name similarity and the common current mode between the database tables is comprehensively considered; the problem that effective information in metadata is difficult to extract due to the fact that only an NLP model is used for unilaterally extracting database table information in a traditional method is effectively avoided; and finally, determining a corresponding comprehensive weight by utilizing the structure weight, the semantic weight and the behavior weight corresponding to each database table, namely dividing each database table into a plurality of business domain groups according to each comprehensive weight, so that manual intervention can be effectively reduced, and the method is suitable for a large-scale database scene.
Owner:LANGCHAO ELECTRONIC INFORMATION IND CO LTD

Machine learning techniques for discovering keys in relational datasets

Techniques for discovering primary, unique, and / or foreign keys for relational datasets are described. The techniques include profiling the relational datasets to obtain respective data profiles; identifying one or more primary key candidates for a first relational dataset using a first data profile of the first relational dataset and a first trained machine learning model; identifying one or more foreign key proposals for a second relational dataset using the one or more primary key candidates by performing a subset analysis of the second relational dataset with respect to the first relational dataset; identifying one or more foreign key candidates for the second relational dataset using the first data profile, a second data profile of the second relational dataset, and a second trained machine learning model different from the first trained machine learning model; and outputting the at primary key candidate(s) and the foreign key candidate(s).
Owner:AB INITIO TECHNOLOGY LLC

Cross-platform power grid data conversion synchronization method and device, terminal and medium

The invention discloses a cross-platform power grid data conversion synchronization method and device, a terminal and a medium. According to the method, a master table in a source database is synchronized to a target database according to master-slave table dependency sequence information; in the synchronization process, an ID mapping table is constructed to record the mapping relation between a first primary key ID and a second primary key ID of each piece of primary table data, the second primary key ID corresponding to a foreign key field is dynamically calculated to be used for updating the foreign key field based on the foreign key field of the slave table in combination with foreign key mapping relation information and the ID mapping table, and the secondary table data is synchronized. Finally, after all the foreign key fields of the slave table are updated, the data synchronization action of the slave table is executed in combination with ORM data synchronization logic, dynamic remapping of the primary key ID is achieved by constructing the ID mapping table, the foreign key fields of the slave table are updated based on the foreign key mapping relation information, the foreign key reference integrity during cross-database synchronization is ensured, and the synchronization efficiency is improved. The problem of foreign key reference integrity caused by inconsistent primary key IDs in the cross-database synchronization process is effectively solved.
Owner:ELECTRIC POWER RES INST CHINA SOUTHERN POWER GRID CO LTD

Automated metadata generation and natural language database querying

A machine-readable medium stores instructions that, when executed by a processor, cause the processor to execute operations. The operations include receiving information identifying a database table and preprocessing the table. The preprocessing includes extracting primary and foreign key relationships and generating sample data by combining frequency-based sampling of common values with random sampling. The operations also include generating, using an LLM, a unified metadata schema. The generating includes processing the table and the sample data using domain-specific prompts and outputting the unified metadata schema. The operations include embedding and indexing the unified metadata schema and converting a natural language question output from an end-user device into a SQL query. The converting includes identifying relevant metadata in the unified metadata schema matching query intent and generating the SQL query using the filtered metadata. The operations also include executing the SQL query and providing query results to the end-user device.
Owner:INVENTUS HOLDINGS LLC

Data warehouse model design method

The invention discloses a data warehouse model design method, and belongs to the technical field of data warehouse modeling. According to the method, a dimension modeling method is adopted to construct and analyze a mart model, data is organized into a non-standardized relation model, and the relation between tables is defined through keywords and foreign keys. And designing a dimension table system comprising a product dimension, a calendar day dimension, an institution dimension, an insurance policy attribute dimension and a customer dimension, and a fact table system comprising an insurance claim settlement analysis fact table, a payment analysis fact table, a claim settlement efficiency analysis fact table and a corresponding intermediate fact table. The analysis subject domain data is formatted into a star model or snowflake model, where the analysis fact table is a lightly summarized transactional fact table, and the intermediate fact table is a versioned historical table. According to the method, repeated data construction is avoided through a unified modeling method, and the cost is reduced; an efficient query analysis function is provided by optimizing a model structure; and the data traceability is ensured through versioning management.
Owner:HAIER CONSUMER FINANCE CO LTD

Information system service data integrity checking method

The application belongs to the technical field of data processing, and discloses a kind of information system business data integrity check method, comprising: the data entity class instance of information system is encoded based on the data structure of data entity class, and initial encoding is obtained;Data entity class instance is encoded again to obtain current time encoding;According to the initial encoding and current time encoding of data entity class check and output data integrity check result.The method can obtain understandable and directly related fine-grained integrity check result by participating in the encoding and encoding comparison process of business entity class, and the integrity of all information including the external information associated with foreign key can be checked out by directly checking the integrity of class instance used in business system, saving storage space and speeding up comparison speed.
Owner:THE 28TH RES INST OF CHINA ELECTRONICS TECH GROUP CORP

Real-time analysis method for mobile customer purchase intention grading

The invention discloses a real-time analysis method for mobile customer purchase intention grading, which comprises the steps of collecting a customer in-store data set and an online data set, carrying out abnormal value processing on the data, establishing an association relationship between the data in a database by using a primary key and a foreign key through a unique identifier of a customer, associating the online data with the offline data, and carrying out real-time analysis on the online data and the offline data. A data matching technology is combined to identify and associate similar data records, correlation analysis is utilized, most representative features are selected from a data set, a cross validation technology is combined to construct and train a model, customer purchase intention data variables are continuously collected, an association relationship is established in a database, and the customer purchase intention data is acquired. According to the method, the mobile customer purchase intention data can be effectively and accurately analyzed in real time, and the customer purchase intention data can be fed back to the sales personnel in time.
Owner:ANHUI PEIFENG XIANGMAO TECHNOLOGY CONSULTING CO LTD

Data blood relationship analysis method and equipment

The invention provides a data consanguinity analysis method and equipment, and is applied to the field of data governance. The method comprises the steps of obtaining a data dictionary corresponding to a target database; wherein the target database comprises a plurality of data tables; foreign key information is extracted from the target database, the foreign key information is used for representing the relation among the multiple data tables, and the foreign key information is obtained; performing data correlation analysis on the target database based on a correlation coefficient algorithm to obtain a correlation analysis result; and based on the data dictionary, the foreign key information and the correlation analysis result, constructing a data blood relationship map. As the data correlation analysis is performed on the target database based on the correlation coefficient algorithm, not only can the correlation between the data fields be accurately quantified, but also the correlation analysis result for revealing the potential data dependency relationship between the fields and the business logic can be obtained, so that the data correlation analysis efficiency is improved. The data blood relationship map constructed based on the data dictionary, the foreign key information and the correlation analysis result can reveal potential data dependency and business logic, and the accuracy is high.
Owner:XFUSION DIGITAL TECH CO LTD

Database model established for low-code platform

A database model established for a low-code platform is characterized by comprising an engineering basic information table, a component definition table, a component type table, an engineering component association table, an engineering variable table, an engineering event registry, a data source registry, a data set registry and a data set field definition table, the model designed by the invention adopts a standardized structure, so that data storage and management are more orderly, subsequent data maintenance and query are facilitated, and the problems of data redundancy and inconsistency are reduced. Through the clearly defined table relation and foreign key constraint, the user can more effectively manage the relation between the data, the integrity and consistency of the data are ensured, and the efficiency of data operation is improved. The method can adapt to various business scenes and requirements, a user can easily adjust and expand the data model according to different business logics, and the expandability and adaptability of the system are enhanced. According to the invention, through reasonable database design, the capability of data-driven decision making is improved.
Owner:武汉智博创享科技股份有限公司

Test data generation method and apparatus, device, and storage medium

The application discloses a test data generation method and device, equipment and a storage medium. The test data generation method comprises the following steps: obtaining a plurality of target record contents from a test data rule table, each target record content comprising a field type, data source information, test data generation rule information corresponding to the data source, and a record number; for each target record content, generating a test data table based on the data source information, the test data generation rule information, the record number, and a first table generated based on the field type; and finally, combining a plurality of test data tables based on the association relationship between the physical primary keys and the physical foreign keys of the plurality of database tables to obtain test data. According to the embodiment of the application, the test data is generated, the test data is rich in dimensions, the association relationship between the data is complete, and conforms to the real law.
Owner:CHINA CONSTRUCTION BANK +1