To solve the problem of delayed update of spectrum information(SI) in the database assisted dynamic spectrum management(DB-DSM), this paper studies a novel dynamic update scheme of SI in DB-DSM. Firstly, a dynamic upd...To solve the problem of delayed update of spectrum information(SI) in the database assisted dynamic spectrum management(DB-DSM), this paper studies a novel dynamic update scheme of SI in DB-DSM. Firstly, a dynamic update mechanism of SI based on spectrum opportunity incentive is established, in which spectrum users are encouraged to actively assist the database to update SI in real time. Secondly, the information update contribution(IUC) of spectrum opportunity is defined to describe the cost of accessing spectrum opportunity for heterogeneous spectrum users, and the profit of SI update obtained by the database from spectrum allocation. The process that the database determines the IUC of spectrum opportunity and spectrum user selects spectrum opportunity is mapped to a Hotelling model. Thirdly, the process of determining the IUC of spectrum opportunities is further modelled as a Stackelberg game by establishing multiple virtual spectrum resource providers(VSRPs) in the database. It is proved that there is a Nash Equilibrium in the game of determining the IUC of spectrum opportunities by VSRPs. Finally, an algorithm of determining the IUC based on a genetic algorithm is designed to achieve the optimal IUC. The-oretical analysis and simulation results show that the proposed method can quickly find the optimal solution of the IUC, and ensure that the spectrum resource provider can obtain the optimal profit of SI update.展开更多
Kawasaki disease(KD)is a significant pediatric vasculitis known for its potential to cause severe coronary artery complications.Despite the effectiveness of initial treatments,such as intravenous immunoglobulin,KD pat...Kawasaki disease(KD)is a significant pediatric vasculitis known for its potential to cause severe coronary artery complications.Despite the effectiveness of initial treatments,such as intravenous immunoglobulin,KD patients can experience long-term cardiovascular issues,as evidenced by a recent case report of an adult who suffered a ST-segment elevation myocardial infarction due to previous KD in the World Journal of Clinical Cases.This editorial emphasizes the critical need for long-term management and regular surveillance to prevent such complications.By drawing on recent research and case studies,we advocate for a structured approach to follow-up care that includes routine cardiac evaluations and preventive measures.展开更多
This article provides a comprehensive analysis of the study by Hou et al,focusing on the complex interplay between psychological and physical factors in the postoperative recovery(POR)of patients with perianal disease...This article provides a comprehensive analysis of the study by Hou et al,focusing on the complex interplay between psychological and physical factors in the postoperative recovery(POR)of patients with perianal diseases.The study sheds light on how illness perception,anxiety,and depression significantly influence recovery outcomes.Hou et al developed a predictive model that demonstrated high accuracy in identifying patients at risk of poor recovery.The article explores the critical role of pre-operative psychological assessment,highlighting the need for mental health support and personalized recovery plans in enhancing POR quality.A multidisciplinary approach,integrating mental health professionals with surgeons,anesthesiologists,and other specialists,is emphasized to ensure comprehensive care for patients.The study’s findings serve as a call to integrate psychological care into surgical practice to optimize outcomes for patients with perianal diseases.展开更多
In the Engine CAD application system engineering database management system (ECAD-EDBMS) is the kernel. ECAD-EDBMS can manage and process the multimedia such as graphics, data, text, sound, image and video. It provide...In the Engine CAD application system engineering database management system (ECAD-EDBMS) is the kernel. ECAD-EDBMS can manage and process the multimedia such as graphics, data, text, sound, image and video. It provides the integrated environment and more functions for many subsystems of ECAD and engine designers. So it improves the design efficiency.展开更多
The spatial database management system of China geological survey extent is a social service system. Its aim is to help the government and the whole social public to expediently use the spatial database, such as query...The spatial database management system of China geological survey extent is a social service system. Its aim is to help the government and the whole social public to expediently use the spatial database, such as querying, indexing, mapping and product outputting. The management system has been developed based on MAPGIS6.x SDK and Visual C++, considering the spatial database contents and structure and the requirements of users. This paper introduces the software structure, the data flow chart and some key techniques of software development.展开更多
Mining sector in Indonesia faces many challenges including needed to support national economy, compliance to central and local government regulations, local community empowerment and environmental impact management. M...Mining sector in Indonesia faces many challenges including needed to support national economy, compliance to central and local government regulations, local community empowerment and environmental impact management. Mining companies are mandatory to perform the environmental management efforts to minimize the negative impact to the environment and pursue sustainability of post-mining land use and as much as possible to restore land to the initial conditions. There are many challenges on management multi parameter and multi temporal spatial data of environmental management. The aim of this research is to design the GIS database template for environmental management in Indonesia’s mining operation. This GIS database is designed using ArcCatalog ArcGIS 9.3 software, through following steps: inventory and assessment government regulations, inventory and assessment environmental quality standards, sorting and grouping parameters, design feature class and attribute, create GIS database, create GIS database dictionary. According to research result, GIS database template has many advantages for environmental management include integrated into a single database, avoid redundancy data, reduce volume data, uniformity data, easy to find and track data, integrated spatial and attribute data, can be used as an input for GIS analysis for decision-making and development strategies.展开更多
In order to design a new kind of mobile database management system (DBMS)more suitable for mobile computing than the existent DBMS, the essence of database systems in mobilecomputing is analyzed. An opinion is introdu...In order to design a new kind of mobile database management system (DBMS)more suitable for mobile computing than the existent DBMS, the essence of database systems in mobilecomputing is analyzed. An opinion is introduced that the mobile database is a kind of dynamicdistributed database, and the concept of virtual servers to translate the clients' mobility to theservers' mobility is proposed. Based on these opinions, a kind of architecture of mobile DBMS, whichis of versatility, is presented. The architecture is composed of a virtual server and a local DBMS,the virtual server is the kernel of the architecture and its functions are described. Eventually,the server kernel of a mobile DBMS prototype is illustrated.展开更多
An Oracle8i-based approach is proposed to manage the integrated databases oflarge CyberCity. This approach consists of three schemes: ① a special R+-tree index is designed toaccelerate spatial retrieving, in which th...An Oracle8i-based approach is proposed to manage the integrated databases oflarge CyberCity. This approach consists of three schemes: ① a special R+-tree index is designed toaccelerate spatial retrieving, in which the bounding boxes of local regions have no intersection andall leaf nodes of the R+-tree (geometry records ) have no repetition; ② different data compressionalgorithms are adopted to compress the digital elevation models, 3D vector models and images, suchas LZ77 lossless compression algorithm for compression of vector data and JPEG compressionalgorithms for texture images; ③ in order to communicate with Oracle8i database, a CyberCity GIS.spatial database engine (SDE) is designed. On the basis of this SDE prototype a case study is done.展开更多
A SOTER management system was developed by analyzing, designing, programming, testing, repeated proceeding and progressing based on the object-oriented method. The function of the attribute database management is inhe...A SOTER management system was developed by analyzing, designing, programming, testing, repeated proceeding and progressing based on the object-oriented method. The function of the attribute database management is inherited and expanded in the new system. The integrity and security of the SOTER database are enhanced. The attribute database management, the spatial database management and the model base are integrated into SOTER based on the component object model (COM), and the graphical user interface (GUI) for Windows is used to interact with clients, thus being easy to create and maintain the SOTER, and convenient to promote the quantification and automation of soil information application.展开更多
With the deepening informationization of Resources & Environment Remote Sensing geological survey conducted,some potential problems and deficiency are:(1) shortage of unified-planed running environment;(2) inconsi...With the deepening informationization of Resources & Environment Remote Sensing geological survey conducted,some potential problems and deficiency are:(1) shortage of unified-planed running environment;(2) inconsistent methods of data integration;and(3) disadvantages of different performing ways of data integration.This paper solves the above problems through overall planning and design,constructs unified running environment, consistent methods of data integration and system structure in order to advance the informationization展开更多
This paper presents a domain engineering approach to build a software product line that supports the change notification service in a Configuration Management Database (CMDB) according to the Information Technology In...This paper presents a domain engineering approach to build a software product line that supports the change notification service in a Configuration Management Database (CMDB) according to the Information Technology Infrastructure Library (ITIL) best practices. For the development of this product line, the proposed approach makes use of a construction of products methodology by analogy: this is a new notation which reports the variability of the products, obtaining metrics as important as the number of products and uses a language that enables, by means of the flexibilization of a product and the development of some generators, to build the rest of the product line. In addition the paper offers a standard for the analysis and design of the CMDB as well. Finally, the paper presents an economic model for the product line, where the profitability and productivity of the proposed solution are analyzed.展开更多
In the context of a proliferation of DatabaseManagement Systems(DBMSs),we have envisioned and produced an OWL 2 ontology able to provide a high-level machine-processable description of the DBMSs domain.This conceptual...In the context of a proliferation of DatabaseManagement Systems(DBMSs),we have envisioned and produced an OWL 2 ontology able to provide a high-level machine-processable description of the DBMSs domain.This conceptualization aims to facilitate a proper execution of various software engineering processes and database-focused administration tasks.Also,it can be used to improve the decision-making process for determining/selecting the appropriate DBMS,subject to specific requirements.The proposed model describes the most important features and aspects regarding the DBMS domain,including the support for various paradigms(relational,graph-based,key-value,tree-like,etc.),query languages,platforms(servers),plus running environments(desktop,Web,cloud),specific contexts—i.e.,focusing on optimizing queries,redundancy,security,performance,schema vs.schema-less approaches,programming languages/paradigms,and others.The process of populating the ontology with significant individuals(actual DBMSs)benefits from the existing knowledge exposed by free and open machine-processable knowledge bases,by using structured data fromWikipedia and related sources.The pragmatic use of our ontology is demonstrated by two educational software solutions based on current practices in Web application development,proving support for learning and experimenting key features of the actual semantic Web technologies and tools.This approach is also an example of using multiple knowledge from database systems,semanticWeb technologies,and software engineering areas.展开更多
The basic frame and the design idea of J2EE-based Product Data Management (PDM) system are presented. This paper adopts the technology of Object-Oriented to realize the database design and builds the information model...The basic frame and the design idea of J2EE-based Product Data Management (PDM) system are presented. This paper adopts the technology of Object-Oriented to realize the database design and builds the information model of this PDM system. The integration key technology of PDM and CAD systems are discussed, the isomerous interface characteristics between CAD and PDM systems are analyzed, and finally, the integration mode of the PDM and CAD systems is given. Using these technologies, the integration of PDM and CAD systems is realized and the consistence of data in PDM and CAD systems is kept. Finally, the Product Data Management system is developed, which has been tested on development process of the hydraulic generator. The running process is stable and safety.展开更多
Geo-data is a foundation for the prediction and assessment of ore resources, so managing and making full use of those data, including geography database, geology database, mineral deposits database, aeromagnetics data...Geo-data is a foundation for the prediction and assessment of ore resources, so managing and making full use of those data, including geography database, geology database, mineral deposits database, aeromagnetics database, gravity database, geochemistry database and remote sensing database, is very significant. We developed national important mining zone database (NIMZDB) to manage 14 national important mining zone databases to support a new round prediction of ore deposit. We found that attention should be paid to the following issues: ① data accuracy: integrity, logic consistency, attribute, spatial and time accuracy; ② management of both attribute and spatial data in the same system;③ transforming data between MapGIS and ArcGIS; ④ data sharing and security; ⑤ data searches that can query both attribute and spatial data. Accuracy of input data is guaranteed and the search, analysis and translation of data between MapGIS and ArcGIS has been made convenient via the development of a checking data module and a managing data module based on MapGIS and ArcGIS. Using AreSDE, we based data sharing on a client/server system, and attribute and spatial data are also managed in the same system.展开更多
For a transaction processing system to operate effectively and efficiently in cloud environments, it is important to distribute huge amount of data while guaranteeing the ACID (atomic, consistent, isolated, and dura...For a transaction processing system to operate effectively and efficiently in cloud environments, it is important to distribute huge amount of data while guaranteeing the ACID (atomic, consistent, isolated, and durable) properties. Moreover, database partition and migration tools can help transplanting conventional relational database systems to the cloud environment rather than rebuilding a new system. This paper proposes a database distribution management (DBDM) system, which partitions or replicates the data according to the transaction behaviors of the application system. The principle strategy of DBDM is to keep together the data used in a single transaction, and thus, avoiding massive transmission of records in join operations. The proposed system has been implemented successfully. The preliminary experiments show that the DBDM performs the database partition and migration effectively. Also, the DBDM system is modularly designed to adapt to different database management system (DBMS) or different partition algorithms.展开更多
The basic procedure of the Italian Civil Protection Department aims at reducing disaster losses by giving prominence to a proactive strategy, focusing on prevision and prevention of hazard events rather than postdisat...The basic procedure of the Italian Civil Protection Department aims at reducing disaster losses by giving prominence to a proactive strategy, focusing on prevision and prevention of hazard events rather than postdisater activities. Italian law commits municipalities to produce Emergency Plans that include risk scenarios as well as all data required for emergency management, such as structures, infrastructures and human resources. However the law in the matter of Civil Protection does not supply information about how to produce and archive necessary data for emergency planning and management. For this reason, we propose a standard methodology to create a geodatabase using GIS software, to collect all data that could be used by municipalities to create Emergency Plans. The resulting geodatabase provides a tool for hazard mitigation planning, allowing not only the identification of areas at risk, but also the structures, infrastructures and resources needed to overcome a crisis, thus improving all strategies of risk reduction and the resilience of the system [1].展开更多
A method of how to describe expert system using relative data model and the realization of inference using data search in support of database management system is introduced in this article.Thereby,the database system...A method of how to describe expert system using relative data model and the realization of inference using data search in support of database management system is introduced in this article.Thereby,the database system is promoted from data processing up to knowledge processing,and a practical method of how to develop expert system using the popular database developing tools is proposed.展开更多
The efficiency and performance of Distributed Database Management Systems (DDBMS) is mainly measured by its proper design and by network communication cost between sites. Fragmentation and distribution of data are the...The efficiency and performance of Distributed Database Management Systems (DDBMS) is mainly measured by its proper design and by network communication cost between sites. Fragmentation and distribution of data are the major design issues of the DDBMS. In this paper, we propose new approach that integrates both fragmentation and data allocation in one strategy based on high performance clustering technique and transaction processing cost functions. This new approach achieves efficiently and effectively the objectives of data fragmentation, data allocation and network sites clustering. The approach splits the data relations into pair-wise disjoint fragments and determine whether each fragment has to be allocated or not in the network sites, where allocation benefit outweighs the cost depending on high performance clustering technique. To show the performance of the proposed approach, we performed experimental studies on real database application at different networks connectivity. The obtained results proved to achieve minimum total data transaction costs between different sites, reduced the amount of redundant data to be accessed between these sites and improved the overall DDBMS performance.展开更多
This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format. There is a great am...This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format. There is a great amount of work done regarding comparison of multiple database management applications on the basis of their performances, security etc., but we have limited information available where these databases are assessed on the basis of provided data. This study will mainly focus on looking at all the possibilities that both these database types offer us when handling data in JSON. We will accomplish this by implementing a series of experiments while taking into consideration that the subjected data does not require to be normalized;and therefore, evaluate the outcome to conclude the result.展开更多
Surface quality has been one of the key factors influencing the ongoing improvement of the quality of steel. Therefore,it is urgent to provide methods for efficient supervision of surface defects. This paper first exp...Surface quality has been one of the key factors influencing the ongoing improvement of the quality of steel. Therefore,it is urgent to provide methods for efficient supervision of surface defects. This paper first expressed the main problems existing in defect management and then focused on constructing a data platform of surface defect management using a multidimensional database. Finally, some onqine applications of the platform at Baosteel were demonstrated. Results show that the constructed multidimensional database provides more structured defect data, and thus it is suitable for swift and multi-angle analysis of the defect data.展开更多
文摘To solve the problem of delayed update of spectrum information(SI) in the database assisted dynamic spectrum management(DB-DSM), this paper studies a novel dynamic update scheme of SI in DB-DSM. Firstly, a dynamic update mechanism of SI based on spectrum opportunity incentive is established, in which spectrum users are encouraged to actively assist the database to update SI in real time. Secondly, the information update contribution(IUC) of spectrum opportunity is defined to describe the cost of accessing spectrum opportunity for heterogeneous spectrum users, and the profit of SI update obtained by the database from spectrum allocation. The process that the database determines the IUC of spectrum opportunity and spectrum user selects spectrum opportunity is mapped to a Hotelling model. Thirdly, the process of determining the IUC of spectrum opportunities is further modelled as a Stackelberg game by establishing multiple virtual spectrum resource providers(VSRPs) in the database. It is proved that there is a Nash Equilibrium in the game of determining the IUC of spectrum opportunities by VSRPs. Finally, an algorithm of determining the IUC based on a genetic algorithm is designed to achieve the optimal IUC. The-oretical analysis and simulation results show that the proposed method can quickly find the optimal solution of the IUC, and ensure that the spectrum resource provider can obtain the optimal profit of SI update.
文摘Kawasaki disease(KD)is a significant pediatric vasculitis known for its potential to cause severe coronary artery complications.Despite the effectiveness of initial treatments,such as intravenous immunoglobulin,KD patients can experience long-term cardiovascular issues,as evidenced by a recent case report of an adult who suffered a ST-segment elevation myocardial infarction due to previous KD in the World Journal of Clinical Cases.This editorial emphasizes the critical need for long-term management and regular surveillance to prevent such complications.By drawing on recent research and case studies,we advocate for a structured approach to follow-up care that includes routine cardiac evaluations and preventive measures.
基金Supported by National Research Foundation of Korea,No.NRF-2021S1A5A8062526.
文摘This article provides a comprehensive analysis of the study by Hou et al,focusing on the complex interplay between psychological and physical factors in the postoperative recovery(POR)of patients with perianal diseases.The study sheds light on how illness perception,anxiety,and depression significantly influence recovery outcomes.Hou et al developed a predictive model that demonstrated high accuracy in identifying patients at risk of poor recovery.The article explores the critical role of pre-operative psychological assessment,highlighting the need for mental health support and personalized recovery plans in enhancing POR quality.A multidisciplinary approach,integrating mental health professionals with surgeons,anesthesiologists,and other specialists,is emphasized to ensure comprehensive care for patients.The study’s findings serve as a call to integrate psychological care into surgical practice to optimize outcomes for patients with perianal diseases.
文摘In the Engine CAD application system engineering database management system (ECAD-EDBMS) is the kernel. ECAD-EDBMS can manage and process the multimedia such as graphics, data, text, sound, image and video. It provides the integrated environment and more functions for many subsystems of ECAD and engine designers. So it improves the design efficiency.
文摘The spatial database management system of China geological survey extent is a social service system. Its aim is to help the government and the whole social public to expediently use the spatial database, such as querying, indexing, mapping and product outputting. The management system has been developed based on MAPGIS6.x SDK and Visual C++, considering the spatial database contents and structure and the requirements of users. This paper introduces the software structure, the data flow chart and some key techniques of software development.
文摘Mining sector in Indonesia faces many challenges including needed to support national economy, compliance to central and local government regulations, local community empowerment and environmental impact management. Mining companies are mandatory to perform the environmental management efforts to minimize the negative impact to the environment and pursue sustainability of post-mining land use and as much as possible to restore land to the initial conditions. There are many challenges on management multi parameter and multi temporal spatial data of environmental management. The aim of this research is to design the GIS database template for environmental management in Indonesia’s mining operation. This GIS database is designed using ArcCatalog ArcGIS 9.3 software, through following steps: inventory and assessment government regulations, inventory and assessment environmental quality standards, sorting and grouping parameters, design feature class and attribute, create GIS database, create GIS database dictionary. According to research result, GIS database template has many advantages for environmental management include integrated into a single database, avoid redundancy data, reduce volume data, uniformity data, easy to find and track data, integrated spatial and attribute data, can be used as an input for GIS analysis for decision-making and development strategies.
文摘In order to design a new kind of mobile database management system (DBMS)more suitable for mobile computing than the existent DBMS, the essence of database systems in mobilecomputing is analyzed. An opinion is introduced that the mobile database is a kind of dynamicdistributed database, and the concept of virtual servers to translate the clients' mobility to theservers' mobility is proposed. Based on these opinions, a kind of architecture of mobile DBMS, whichis of versatility, is presented. The architecture is composed of a virtual server and a local DBMS,the virtual server is the kernel of the architecture and its functions are described. Eventually,the server kernel of a mobile DBMS prototype is illustrated.
基金Project supported by the National Key Basic Research and Development Program (No. 2002CB312101) the National Natural Science Foundation of China (No.40001017).
文摘An Oracle8i-based approach is proposed to manage the integrated databases oflarge CyberCity. This approach consists of three schemes: ① a special R+-tree index is designed toaccelerate spatial retrieving, in which the bounding boxes of local regions have no intersection andall leaf nodes of the R+-tree (geometry records ) have no repetition; ② different data compressionalgorithms are adopted to compress the digital elevation models, 3D vector models and images, suchas LZ77 lossless compression algorithm for compression of vector data and JPEG compressionalgorithms for texture images; ③ in order to communicate with Oracle8i database, a CyberCity GIS.spatial database engine (SDE) is designed. On the basis of this SDE prototype a case study is done.
基金Project supported by the National Natural Science Foundation of China (No. 40271056) Hubei Provin- cial Natural Science Foundation of China (No. 99J123).
文摘A SOTER management system was developed by analyzing, designing, programming, testing, repeated proceeding and progressing based on the object-oriented method. The function of the attribute database management is inherited and expanded in the new system. The integrity and security of the SOTER database are enhanced. The attribute database management, the spatial database management and the model base are integrated into SOTER based on the component object model (COM), and the graphical user interface (GUI) for Windows is used to interact with clients, thus being easy to create and maintain the SOTER, and convenient to promote the quantification and automation of soil information application.
文摘With the deepening informationization of Resources & Environment Remote Sensing geological survey conducted,some potential problems and deficiency are:(1) shortage of unified-planed running environment;(2) inconsistent methods of data integration;and(3) disadvantages of different performing ways of data integration.This paper solves the above problems through overall planning and design,constructs unified running environment, consistent methods of data integration and system structure in order to advance the informationization
文摘This paper presents a domain engineering approach to build a software product line that supports the change notification service in a Configuration Management Database (CMDB) according to the Information Technology Infrastructure Library (ITIL) best practices. For the development of this product line, the proposed approach makes use of a construction of products methodology by analogy: this is a new notation which reports the variability of the products, obtaining metrics as important as the number of products and uses a language that enables, by means of the flexibilization of a product and the development of some generators, to build the rest of the product line. In addition the paper offers a standard for the analysis and design of the CMDB as well. Finally, the paper presents an economic model for the product line, where the profitability and productivity of the proposed solution are analyzed.
文摘In the context of a proliferation of DatabaseManagement Systems(DBMSs),we have envisioned and produced an OWL 2 ontology able to provide a high-level machine-processable description of the DBMSs domain.This conceptualization aims to facilitate a proper execution of various software engineering processes and database-focused administration tasks.Also,it can be used to improve the decision-making process for determining/selecting the appropriate DBMS,subject to specific requirements.The proposed model describes the most important features and aspects regarding the DBMS domain,including the support for various paradigms(relational,graph-based,key-value,tree-like,etc.),query languages,platforms(servers),plus running environments(desktop,Web,cloud),specific contexts—i.e.,focusing on optimizing queries,redundancy,security,performance,schema vs.schema-less approaches,programming languages/paradigms,and others.The process of populating the ontology with significant individuals(actual DBMSs)benefits from the existing knowledge exposed by free and open machine-processable knowledge bases,by using structured data fromWikipedia and related sources.The pragmatic use of our ontology is demonstrated by two educational software solutions based on current practices in Web application development,proving support for learning and experimenting key features of the actual semantic Web technologies and tools.This approach is also an example of using multiple knowledge from database systems,semanticWeb technologies,and software engineering areas.
基金Sponsored by Scientific Technology Development Project of Heilongjiang (Grant No.WH05A01) and Scientific Research Foundation of Harbin Institute of Technology(Grant No.HIT.MD2003.21).
文摘The basic frame and the design idea of J2EE-based Product Data Management (PDM) system are presented. This paper adopts the technology of Object-Oriented to realize the database design and builds the information model of this PDM system. The integration key technology of PDM and CAD systems are discussed, the isomerous interface characteristics between CAD and PDM systems are analyzed, and finally, the integration mode of the PDM and CAD systems is given. Using these technologies, the integration of PDM and CAD systems is realized and the consistence of data in PDM and CAD systems is kept. Finally, the Product Data Management system is developed, which has been tested on development process of the hydraulic generator. The running process is stable and safety.
基金This paper is financially supported by the National I mportant MiningZone Database ( No .200210000004)Prediction and Assessment ofMineral Resources and Social Service (No .1212010331402) .
文摘Geo-data is a foundation for the prediction and assessment of ore resources, so managing and making full use of those data, including geography database, geology database, mineral deposits database, aeromagnetics database, gravity database, geochemistry database and remote sensing database, is very significant. We developed national important mining zone database (NIMZDB) to manage 14 national important mining zone databases to support a new round prediction of ore deposit. We found that attention should be paid to the following issues: ① data accuracy: integrity, logic consistency, attribute, spatial and time accuracy; ② management of both attribute and spatial data in the same system;③ transforming data between MapGIS and ArcGIS; ④ data sharing and security; ⑤ data searches that can query both attribute and spatial data. Accuracy of input data is guaranteed and the search, analysis and translation of data between MapGIS and ArcGIS has been made convenient via the development of a checking data module and a managing data module based on MapGIS and ArcGIS. Using AreSDE, we based data sharing on a client/server system, and attribute and spatial data are also managed in the same system.
基金supported by the Taiwan Ministry of Economic Affairs and Institute for Information Industry under the project titled "Fundamental Industrial Technology Development Program (1/4)"
文摘For a transaction processing system to operate effectively and efficiently in cloud environments, it is important to distribute huge amount of data while guaranteeing the ACID (atomic, consistent, isolated, and durable) properties. Moreover, database partition and migration tools can help transplanting conventional relational database systems to the cloud environment rather than rebuilding a new system. This paper proposes a database distribution management (DBDM) system, which partitions or replicates the data according to the transaction behaviors of the application system. The principle strategy of DBDM is to keep together the data used in a single transaction, and thus, avoiding massive transmission of records in join operations. The proposed system has been implemented successfully. The preliminary experiments show that the DBDM performs the database partition and migration effectively. Also, the DBDM system is modularly designed to adapt to different database management system (DBMS) or different partition algorithms.
文摘The basic procedure of the Italian Civil Protection Department aims at reducing disaster losses by giving prominence to a proactive strategy, focusing on prevision and prevention of hazard events rather than postdisater activities. Italian law commits municipalities to produce Emergency Plans that include risk scenarios as well as all data required for emergency management, such as structures, infrastructures and human resources. However the law in the matter of Civil Protection does not supply information about how to produce and archive necessary data for emergency planning and management. For this reason, we propose a standard methodology to create a geodatabase using GIS software, to collect all data that could be used by municipalities to create Emergency Plans. The resulting geodatabase provides a tool for hazard mitigation planning, allowing not only the identification of areas at risk, but also the structures, infrastructures and resources needed to overcome a crisis, thus improving all strategies of risk reduction and the resilience of the system [1].
文摘A method of how to describe expert system using relative data model and the realization of inference using data search in support of database management system is introduced in this article.Thereby,the database system is promoted from data processing up to knowledge processing,and a practical method of how to develop expert system using the popular database developing tools is proposed.
文摘The efficiency and performance of Distributed Database Management Systems (DDBMS) is mainly measured by its proper design and by network communication cost between sites. Fragmentation and distribution of data are the major design issues of the DDBMS. In this paper, we propose new approach that integrates both fragmentation and data allocation in one strategy based on high performance clustering technique and transaction processing cost functions. This new approach achieves efficiently and effectively the objectives of data fragmentation, data allocation and network sites clustering. The approach splits the data relations into pair-wise disjoint fragments and determine whether each fragment has to be allocated or not in the network sites, where allocation benefit outweighs the cost depending on high performance clustering technique. To show the performance of the proposed approach, we performed experimental studies on real database application at different networks connectivity. The obtained results proved to achieve minimum total data transaction costs between different sites, reduced the amount of redundant data to be accessed between these sites and improved the overall DDBMS performance.
文摘This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format. There is a great amount of work done regarding comparison of multiple database management applications on the basis of their performances, security etc., but we have limited information available where these databases are assessed on the basis of provided data. This study will mainly focus on looking at all the possibilities that both these database types offer us when handling data in JSON. We will accomplish this by implementing a series of experiments while taking into consideration that the subjected data does not require to be normalized;and therefore, evaluate the outcome to conclude the result.
文摘Surface quality has been one of the key factors influencing the ongoing improvement of the quality of steel. Therefore,it is urgent to provide methods for efficient supervision of surface defects. This paper first expressed the main problems existing in defect management and then focused on constructing a data platform of surface defect management using a multidimensional database. Finally, some onqine applications of the platform at Baosteel were demonstrated. Results show that the constructed multidimensional database provides more structured defect data, and thus it is suitable for swift and multi-angle analysis of the defect data.