The automation of traditional Chinese medicine(TCM)pharmaceuticals has driven the development of process analysis from offline to online.Most of common online process analytical technologies are based on spectroscopy,...The automation of traditional Chinese medicine(TCM)pharmaceuticals has driven the development of process analysis from offline to online.Most of common online process analytical technologies are based on spectroscopy,making the identification and quantification of specific ingredients still a challenge.Herein,we developed a quality control(QC)system for monitoring TCM pharmaceuticals based on paper spray ionization miniature mass spectrometry(mini-MS).It enabled real-time online qualitative and quantitative detection of target ingredients in herbal extracts using mini-MS without chromatographic separation for the first time.Dynamic changes of alkaloids in Aconiti Lateralis Radix Praeparata(Fuzi)during decoction were used as examples,and the scientific principle of Fuzi compatibility was also investigated.Finally,the system was verified to work stably at the hourly level for pilot-scale extraction.This mini-MS based online analytical system is expected to be further developed for QC applications in a wider range of pharmaceutical processes.展开更多
In this paper, we designed a customer-centered data warehouse system with five subjects： listing, bidding, transaction, accounts, and customer contact based on the business process of online auction companies. For ea...In this paper, we designed a customer-centered data warehouse system with five subjects： listing, bidding, transaction, accounts, and customer contact based on the business process of online auction companies. For each subject, we analyzed its fact indexes and dimensions. Then take transaction subject as example, analyzed the data warehouse model in detail, and got the multi-dimensional analysis structure of transaction subject. At last, using data mining to do customer segmentation, we divided customers into four types： impulse customer, prudent customer, potential customer, and ordinary customer. By the result of multi-dimensional customer data analysis, online auction companies can do more target marketing and increase customer loyalty.展开更多
OLAP(online analytical processing,在线联机分析处理)是关系数据基础上实现商业智能的核心技术。在大数据时代,人们迫切希望在由普通机器组成的大规模集群上能实现高性能的OLAP,然而系统性能的挑战巨大。可喜的是,近年来进展迅速,涌...OLAP(online analytical processing,在线联机分析处理)是关系数据基础上实现商业智能的核心技术。在大数据时代,人们迫切希望在由普通机器组成的大规模集群上能实现高性能的OLAP,然而系统性能的挑战巨大。可喜的是,近年来进展迅速,涌现了很多以Hadoop上的数据进行OLAP的所谓SQL on Hadoop系统,并且系统性能不断提升。在综述OLAP技术发展的基础上,重点对几个有代表性的SQL on Hadoop系统进行了测试分析,并展示了这类系统的性能特点。可以预见,未来在低成本的大数据OLAP市场,这类系统会占有重要位置。展开更多
传统网络环境和P2P环境中,客户端向OLAP服务器提交OLAP查询,并从服务器获取查询结果,OLAP服务器的负载将随着客户端的增加而急剧增加。设计了一种基于P2P(Peer-to-Peer,点对点技术)技术的DQDC(Distributed Query Data Cube,多维数据集...传统网络环境和P2P环境中,客户端向OLAP服务器提交OLAP查询,并从服务器获取查询结果,OLAP服务器的负载将随着客户端的增加而急剧增加。设计了一种基于P2P(Peer-to-Peer,点对点技术)技术的DQDC(Distributed Query Data Cube,多维数据集的分布式查询)算法,实现P2P网络中语义级的多节点Data Cube数据共享,从而提高系统整体的决策分析性能。展开更多
基金supported by Ministry of Science and Technology of the People's Republic of China(Grant No.:2022YFC3502300)Beijing Natural Science Foundation(Grant No.:L222150)+2 种基金the National Natural Science Foundation of China(Grant No.:82072247)the second batch of“Ten thousand plan”National High Level Talents Special Support Plan(Grant No.:W02020052)Beijing University of Chinese Medicine(Grant Nos.:XJYS21005,JY21024,MSGZF-202001,2022-syjs-05,and 2022-syjs-10).
文摘The automation of traditional Chinese medicine(TCM)pharmaceuticals has driven the development of process analysis from offline to online.Most of common online process analytical technologies are based on spectroscopy,making the identification and quantification of specific ingredients still a challenge.Herein,we developed a quality control(QC)system for monitoring TCM pharmaceuticals based on paper spray ionization miniature mass spectrometry(mini-MS).It enabled real-time online qualitative and quantitative detection of target ingredients in herbal extracts using mini-MS without chromatographic separation for the first time.Dynamic changes of alkaloids in Aconiti Lateralis Radix Praeparata(Fuzi)during decoction were used as examples,and the scientific principle of Fuzi compatibility was also investigated.Finally,the system was verified to work stably at the hourly level for pilot-scale extraction.This mini-MS based online analytical system is expected to be further developed for QC applications in a wider range of pharmaceutical processes.
基金Supported by the National Natural Science Foundation of China (70471037)211 Project Foundation of Shanghai University (8011040506)
文摘In this paper, we designed a customer-centered data warehouse system with five subjects： listing, bidding, transaction, accounts, and customer contact based on the business process of online auction companies. For each subject, we analyzed its fact indexes and dimensions. Then take transaction subject as example, analyzed the data warehouse model in detail, and got the multi-dimensional analysis structure of transaction subject. At last, using data mining to do customer segmentation, we divided customers into four types： impulse customer, prudent customer, potential customer, and ordinary customer. By the result of multi-dimensional customer data analysis, online auction companies can do more target marketing and increase customer loyalty.
文摘OLAP(online analytical processing,在线联机分析处理)是关系数据基础上实现商业智能的核心技术。在大数据时代,人们迫切希望在由普通机器组成的大规模集群上能实现高性能的OLAP,然而系统性能的挑战巨大。可喜的是,近年来进展迅速,涌现了很多以Hadoop上的数据进行OLAP的所谓SQL on Hadoop系统,并且系统性能不断提升。在综述OLAP技术发展的基础上,重点对几个有代表性的SQL on Hadoop系统进行了测试分析,并展示了这类系统的性能特点。可以预见,未来在低成本的大数据OLAP市场,这类系统会占有重要位置。
文摘传统网络环境和P2P环境中,客户端向OLAP服务器提交OLAP查询,并从服务器获取查询结果,OLAP服务器的负载将随着客户端的增加而急剧增加。设计了一种基于P2P(Peer-to-Peer,点对点技术)技术的DQDC(Distributed Query Data Cube,多维数据集的分布式查询)算法,实现P2P网络中语义级的多节点Data Cube数据共享,从而提高系统整体的决策分析性能。
