Abstract
According to military logistics data warehouse dealing with large-scale data effect is poor. This paper puts forward the construction scheme of dual computing engine military logistics data ...warehouse based on hive in order to improve the military logistics support capability. The scheme adopts Hadoop and Spark dual search architecture to support efficient storage of heterogeneous data. In addition, a data block placement strategy based on correlation analysis was used. This article use the intersection relationship matrix and the concurrency relationship matrix to calculate the correlation between the data block placed on the node and the data block to be placed. The access frequency of the target data block was integrated to select the appropriate node storage. The scheme can effectively improve hive’s query efficiency and provide more effective information aided decision support for commanders.
Nowadays, the data used for decision-making come from a wide variety of sources which are difficult to manage using relational databases. To address this problem, many researchers have turned to Not ...only SQL (NoSQL) databases to provide scalability and flexibility for On-Line Analytical Processing (OLAP) systems. In this paper, we propose a set of formal rules to convert a multidimensional data model into a graph data model (MDM2G). These rules allow conventional star and snowflake schemas to fit into NoSQL graph databases. We apply the proposed rules to implement star-like and snowflake-like graph data warehouses. We compare their performances to similar relational ones focusing on the data model, dimensionality, and size. The experimental results show large differences between relational and graph implementations of a data warehouse. A relational implementation performs better for queries on a couple of tables, but conversely, a graph implementation is better when queries involve many tables. Surprisingly the performances of a star-like and snowflake-like graph data warehouses are very close. Hence a snowflake schema could be used in order to easily consider new sub-dimensions in a graph data warehouse.
Hydroxychloroquine has been widely administered to patients with Covid-19 without robust evidence supporting its use.
We examined the association between hydroxychloroquine use and intubation or ...death at a large medical center in New York City. Data were obtained regarding consecutive patients hospitalized with Covid-19, excluding those who were intubated, died, or discharged within 24 hours after presentation to the emergency department (study baseline). The primary end point was a composite of intubation or death in a time-to-event analysis. We compared outcomes in patients who received hydroxychloroquine with those in patients who did not, using a multivariable Cox model with inverse probability weighting according to the propensity score.
Of 1446 consecutive patients, 70 patients were intubated, died, or discharged within 24 hours after presentation and were excluded from the analysis. Of the remaining 1376 patients, during a median follow-up of 22.5 days, 811 (58.9%) received hydroxychloroquine (600 mg twice on day 1, then 400 mg daily for a median of 5 days); 45.8% of the patients were treated within 24 hours after presentation to the emergency department, and 85.9% within 48 hours. Hydroxychloroquine-treated patients were more severely ill at baseline than those who did not receive hydroxychloroquine (median ratio of partial pressure of arterial oxygen to the fraction of inspired oxygen, 223 vs. 360). Overall, 346 patients (25.1%) had a primary end-point event (180 patients were intubated, of whom 66 subsequently died, and 166 died without intubation). In the main analysis, there was no significant association between hydroxychloroquine use and intubation or death (hazard ratio, 1.04, 95% confidence interval, 0.82 to 1.32). Results were similar in multiple sensitivity analyses.
In this observational study involving patients with Covid-19 who had been admitted to the hospital, hydroxychloroquine administration was not associated with either a greatly lowered or an increased risk of the composite end point of intubation or death. Randomized, controlled trials of hydroxychloroquine in patients with Covid-19 are needed. (Funded by the National Institutes of Health.).
This paper takes Deppon Express Company as an example to study the optimization of the layout of the store warehouse under the standardized operation mode. First of all, it Analyzes warehouse layout ...present situation of the express company, and gets the problems of the warehouse layout of the company, for example, the layout of the lack of scientific, as well as part of the operational areas of position arrangement is not reasonable and unreasonable action path which leads to the whole business operation efficiency is low. Finally, thus using SLP to solve those problems, and put forward the company store aisle warehouse layout optimization strategy of management according to the comprehensive relations preliminary to the data warehouse layout optimization figure.
Multi-model DBMSs (MMDBMSs) have been recently introduced to store and seamlessly query heterogeneous data (structured, semi-structured, graph-based, etc.) in their native form, aimed at effectively ...preserving their variety. Unfortunately, when it comes to analyzing these data, traditional data warehouses (DWs) and OLAP systems fall short because they rely on relational DBMSs for storage and querying, thus constraining data variety into the rigidity of a structured, fixed schema. In this paper, we investigate the performances of an MMDBMS when used to store multidimensional data for OLAP analyses. A multi-model DW would store each of its elements according to its native model; among the benefits we envision for this solution, that of bridging the architectural gap between data lakes and DWs, that of reducing the cost for ETL, and that of ensuring better flexibility, extensibility, and evolvability thanks to the combined use of structured and schemaless data. To support our investigation we define a multidimensional schema for the UniBench benchmark dataset and an ad-hoc OLAP workload for it. Then we propose and compare three logical solutions implemented on the PostgreSQL multi-model DBMS: one that extends a star schema with JSON, XML, graph-based, and key–value data; one based on a classical (fully relational) star schema; and one where all data are kept in their native form (no relational data are introduced). As expected, the full-relational implementation generally performs better than the multi-model one, but this is balanced by the benefits of MMDBMSs in dealing with variety. Finally, we give our perspective view of the research on this topic.
•We investigate the performances of a multi-model DBMS to store multidimensional data for OLAP analyses.•We define a multidimensional schema for the UniBench benchmark dataset and an ad-hoc OLAP workload for it.•We propose and quantitatively compare three logical solutions implemented on the PostgreSQL multi-model DBMS.•The querying performances of a multi-model solution are slightly worse than those of a full-relational solution.•A multi-model solutions brings advantages in terms of extendibility, flexibility, evolvability, ETL.
Abstract in the process of monitoring the operation state of power equipment, it is easy to be affected by the external environment, resulting in a large amount of data of the operation state of ...power equipment and the monitoring effect. A monitoring method of power equipment operation condition based on data warehouse is proposed. By analyzing the constraints of power equipment operation condition monitoring, a data warehouse is established; The transition probability and stability probability are determined by Markov chain model, and the characteristic values of operation state level variables are obtained by calculating the comprehensive correlation value and sensitivity; The entropy weight coefficient method calculates the weight of each performance index of the monitoring object, constructs the operation state monitoring model of power equipment, and realizes the monitoring of the operation state of power equipment. The experimental results show that the improved method can effectively improve the monitoring efficiency and shorten the monitoring time.
Radio frequency identification (RFID) has been widely used in supporting the logistics management on manufacturing shopfloors where production resources attached with RFID facilities are converted ...into smart manufacturing objects (SMOs) which are able to sense, interact, and reason to create a ubiquitous environment. Within such environment, enormous data could be collected and used for supporting further decision-makings such as logistics planning and scheduling. This paper proposes a holistic Big Data approach to excavate frequent trajectory from massive RFID-enabled shopfloor logistics data with several innovations highlighted. Firstly, RFID-Cuboids are creatively introduced to establish a data warehouse so that the RFID-enabled logistics data could be highly integrated in terms of tuples, logic, and operations. Secondly, a Map Table is used for linking various cuboids so that information granularity could be enhanced and dataset volume could be reduced. Thirdly, spatio-temporal sequential logistics trajectory is defined and excavated so that the logistics operators and machines could be evaluated quantitatively. Finally, key findings from the experimental results and insights from the observations are summarized as managerial implications, which are able to guide end-users to carry out associated decisions.
Temporal Graph Cube Wang, Guoren; Zeng, Yue; Li, Rong-Hua ...
IEEE transactions on knowledge and data engineering,
12/2023, Volume:
35, Issue:
12
Journal Article
Peer reviewed
Data warehouse and OLAP (Online Analytical Processing) are effective tools for decision support on traditional relational data and static multidimensional network data. However, many real-world ...multidimensional networks are often modeled as temporal multidimensional networks, where the edges in the network are associated with temporal information. Such temporal multidimensional networks typically cannot be handled by traditional data warehouse and OLAP techniques. To fill this gap, we propose a novel data warehouse model, named <inline-formula><tex-math notation="LaTeX">\mathsf {Temporal{\kern3.0pt}Graph{\kern3.0pt}Cube}</tex-math></inline-formula>, to support OLAP queries on temporal multidimensional networks. Through supporting OLAP queries in any time range, users can obtain summarized information of the network in the time range of interest, which cannot be derived by using traditional static graph OLAP techniques. We propose a segment-tree based indexing technique to speed up the OLAP queries, and also develop an index-updating technique to maintain the index when the temporal multidimensional network evolves over time. In addition, we also propose a novel concept called <inline-formula><tex-math notation="LaTeX">\mathsf {similarity{\kern3.0pt}of{\kern3.0pt}snapshots}</tex-math></inline-formula> which shows a strong correlation with the efficiency of indexing technique and can provide a good reference on the necessity of building the index. The results of extensive experiments on two large real-world datasets demonstrate the effectiveness and efficiency of the proposed method.
Digital data collection during routine clinical practice is now ubiquitous within hospitals. The data contains valuable information on the care of patients and their response to treatments, offering ...exciting opportunities for research. Typically, data are stored within archival systems that are not intended to support research. These systems are often inaccessible to researchers and structured for optimal storage, rather than interpretability and analysis. Here we present MIMIC-IV, a publicly available database sourced from the electronic health record of the Beth Israel Deaconess Medical Center. Information available includes patient measurements, orders, diagnoses, procedures, treatments, and deidentified free-text clinical notes. MIMIC-IV is intended to support a wide array of research studies and educational material, helping to reduce barriers to conducting clinical research.
Opioid-related mortality and national prescribing guidelines have led to tapering of doses among patients prescribed long-term opioid therapy for chronic pain. There is limited information about ...risks related to tapering, including overdose and mental health crisis.
To assess whether there are associations between opioid dose tapering and rates of overdose and mental health crisis among patients prescribed stable, long-term, higher-dose opioids.
Retrospective cohort study using deidentified medical and pharmacy claims and enrollment data from the OptumLabs Data Warehouse from 2008 to 2019. Adults in the US prescribed stable higher doses (mean ≥50 morphine milligram equivalents/d) of opioids for a 12-month baseline period with at least 2 months of follow-up were eligible for inclusion.
Opioid tapering, defined as at least 15% relative reduction in mean daily dose during any of 6 overlapping 60-day windows within a 7-month follow-up period. Maximum monthly dose reduction velocity was computed during the same period.
Emergency or hospital encounters for (1) drug overdose or withdrawal and (2) mental health crisis (depression, anxiety, suicide attempt) during up to 12 months of follow-up. Discrete time negative binomial regression models estimated adjusted incidence rate ratios (aIRRs) of outcomes as a function of tapering (vs no tapering) and dose reduction velocity.
The final cohort included 113 618 patients after 203 920 stable baseline periods. Among the patients who underwent dose tapering, 54.3% were women (vs 53.2% among those who did not undergo dose tapering), the mean age was 57.7 years (vs 58.3 years), and 38.8% were commercially insured (vs 41.9%). Posttapering patient periods were associated with an adjusted incidence rate of 9.3 overdose events per 100 person-years compared with 5.5 events per 100 person-years in nontapered periods (adjusted incidence rate difference, 3.8 per 100 person-years 95% CI, 3.0-4.6; aIRR, 1.68 95% CI, 1.53-1.85). Tapering was associated with an adjusted incidence rate of 7.6 mental health crisis events per 100 person-years compared with 3.3 events per 100 person-years among nontapered periods (adjusted incidence rate difference, 4.3 per 100 person-years 95% CI, 3.2-5.3; aIRR, 2.28 95% CI, 1.96-2.65). Increasing maximum monthly dose reduction velocity by 10% was associated with an aIRR of 1.09 for overdose (95% CI, 1.07-1.11) and of 1.18 for mental health crisis (95% CI, 1.14-1.21).
Among patients prescribed stable, long-term, higher-dose opioid therapy, tapering events were significantly associated with increased risk of overdose and mental health crisis. Although these findings raise questions about potential harms of tapering, interpretation is limited by the observational study design.
PDF
