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

4 results about "Fact table" patented technology

In data warehousing, a fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or a snowflake schema surrounded by dimension tables. Where multiple fact tables are used, these are arranged as a fact constellation schema. A fact table typically has two types of columns: those that contain facts and those that are a foreign key to dimension tables. The primary key of a fact table is usually a composite key that is made up of all of its foreign keys. Fact tables contain the content of the data warehouse and store different types of measures like additive, non additive, and semi additive measures.

Artificial Intelligence-Based Rural Economic Data Analysis Methods

PendingCN122311631AEngineeringAdministrative division
This invention relates to the field of rural economic data analysis technology, specifically an artificial intelligence-based method for rural economic data analysis. The method includes: delineating an economic data perception domain in a geographic information system based on the administrative division vector data of the target administrative village; collecting multi-source heterogeneous economic data through a protocol parser of an agricultural IoT terminal and converting it into standardized economic behavior data; extracting entities using natural language processing technology to generate a structured rural economic behavior fact table; inputting the fact table into a pre-trained economic activity association model and constructing a rural industry relationship graph using a graph embedding algorithm; and calculating the centrality index of economic entities based on the graph topology to identify core operating entities. This method enables accurate processing and association analysis of rural economic data, clearly presenting industry relationships and providing effective technical support for rural economic analysis.
Owner:HEBEI UNIV OF ENG

A HIS-based intelligent diagnosis and decision support method for coronary heart disease angina pectoris TCM syndrome elements

PendingCN122348080AImprove normativegood repeatabilityMedical recordCoronary heart disease
The application discloses a kind of intelligent diagnosis and decision support method of coronary heart disease angina TCM syndrome factor based on HIS, it is related to medical information and TCM diagnosis and treatment technical field, the method will coronary heart disease angina TCM syndrome factor diagnostic criteria be deconstructed into standardization diagnostic item, build machine-readable weight rule base containing score, threshold and severity grading rule, response syndrome differentiation operation generates electronic collection form, receives structured data storage to the TCM syndrome factor fact table associated with patient main index and medical record, after structured data is submitted, trigger intelligent computing engine verification essential item, total score is accumulated, determine the establishment of syndrome factor and severity, through TCM diagnosis and treatment knowledge graph push personalized treatment or nursing suggestion in clinical business node, and continuously update rule base and knowledge graph through clinical data feedback.The application integrates corresponding function module to realize and deeply fuse with hospital information system, improves the standardization and efficiency of diagnosis and treatment, and has strong practicality.
Owner:GUANGANMEN HOSPITAL CHINA ACAD OF CHINESE MEDICAL SCI

Partition handling for multi table scan semi join operations

Arrangements for partition handling for multi table scan semi join operations are provided. Partition information of a first logical relation may be determined. Partition information of a first physical operator may be determined based on the partition information of the first logical relation. The partition information of the first physical operator may be stored in a data structure which includes partition information of a fact table and of each reducer in a predefined sequence. Partition information of a second logical relation may be determined. The partition information of a second physical operator may be determined based on the partition information of the second logical relation and the partition information of the first physical operator. The partition information of the second physical operator may be stored in the data structure. Execution of the second physical operator may be performed using the stored partition information, skipping mappings between pairs of partitions.
Owner:SAP SE

An auxiliary decision-making and precise diagnosis and treatment system based on interpretable multi-modal reasoning

PendingCN122369883AData acquisitionPatient data
This invention discloses an auxiliary decision-making and precision diagnosis system based on interpretable multimodal reasoning, belonging to the field of medical informatics and clinical decision support technology. It includes: a data acquisition module for acquiring DKD clinical medical knowledge and multi-source patient data; a feature extraction module for processing the multi-source patient data to obtain a time-series data view of the patient; wherein the time-series data view includes: a fact table and a wide index table; multiple patient time-series data views constitute a structured feature warehouse; a knowledge graph construction module for constructing a medical knowledge graph based on DKD clinical medical knowledge; and a local reasoning module for constructing a local reasoning model and performing retrieval reasoning based on the structured feature warehouse and the medical knowledge graph to obtain the decision result.
Owner:THE FIRST AFFILIATED HOSPITAL OF ARMY MEDICAL UNIV