Database Maintenance

14,000,000 Leading Edge Experts on the ideXlab platform

Scan Science and Technology

Contact Leading Edge Experts & Companies

Scan Science and Technology

Contact Leading Edge Experts & Companies

The Experts below are selected from a list of 318 Experts worldwide ranked by ideXlab platform

Chuang Qian - One of the best experts on this subject based on the ideXlab platform.

  • fast signals of opportunity fingerprint Database Maintenance with autonomous unmanned ground vehicle for indoor positioning
    Sensors, 2018
    Co-Authors: Yitang Peng, Jian Tang, Chuang Qian
    Abstract:

    : Indoor positioning technology based on Received Signal Strength Indicator (RSSI) fingerprints is a potential navigation solution, which has the advantages of simple implementation, low cost and high precision. However, as the radio frequency signals can be easily affected by the environmental change during its transmission, it is quite necessary to build location fingerprint Database in advance and update it frequently, thereby guaranteeing the positioning accuracy. At present, the fingerprint Database building methods mainly include point collection and line acquisition, both of which are usually labor-intensive and time consuming, especially in a large map area. This paper proposes a fast and efficient location fingerprint Database construction and updating method based on a self-developed Unmanned Ground Vehicle (UGV) platform NAVIS, called Automatic Robot Line Collection. A smartphone was installed on NAVIS for collecting indoor Received Signal Strength Indicator (RSSI) fingerprints of Signals of Opportunity (SOP), such as Bluetooth and Wi-Fi. Meanwhile, indoor map was created by 2D LiDAR-based Simultaneous Localization and Mapping (SLAM) technology. The UGV automatically traverse the unknown indoor environment due to a pre-designed full-coverage path planning algorithm. Then, SOP sensors collect location fingerprints and generates grid map during the process of environment-traversing. Finally, location fingerprint Database is built or updated by Kriging interpolation. Field tests were carried out to verify the effectiveness and efficiency of our proposed method. The results showed that, compared with the traditional point collection and line collection schemes, the root mean square error of the fingerprinting-based positioning results were reduced by 35.9% and 25.0% in static tests and 30.0% and 21.3% respectively in dynamic tests. Moreover, our UGV can traverse the indoor environment autonomously without human-labor on data acquisition, the efficiency of the automatic robot line collection scheme is 2.65 times and 1.72 times that of the traditional point collection and the traditional line acquisition, respectively.

Jian Tang - One of the best experts on this subject based on the ideXlab platform.

  • fast signals of opportunity fingerprint Database Maintenance with autonomous unmanned ground vehicle for indoor positioning
    Sensors, 2018
    Co-Authors: Yitang Peng, Jian Tang, Chuang Qian
    Abstract:

    : Indoor positioning technology based on Received Signal Strength Indicator (RSSI) fingerprints is a potential navigation solution, which has the advantages of simple implementation, low cost and high precision. However, as the radio frequency signals can be easily affected by the environmental change during its transmission, it is quite necessary to build location fingerprint Database in advance and update it frequently, thereby guaranteeing the positioning accuracy. At present, the fingerprint Database building methods mainly include point collection and line acquisition, both of which are usually labor-intensive and time consuming, especially in a large map area. This paper proposes a fast and efficient location fingerprint Database construction and updating method based on a self-developed Unmanned Ground Vehicle (UGV) platform NAVIS, called Automatic Robot Line Collection. A smartphone was installed on NAVIS for collecting indoor Received Signal Strength Indicator (RSSI) fingerprints of Signals of Opportunity (SOP), such as Bluetooth and Wi-Fi. Meanwhile, indoor map was created by 2D LiDAR-based Simultaneous Localization and Mapping (SLAM) technology. The UGV automatically traverse the unknown indoor environment due to a pre-designed full-coverage path planning algorithm. Then, SOP sensors collect location fingerprints and generates grid map during the process of environment-traversing. Finally, location fingerprint Database is built or updated by Kriging interpolation. Field tests were carried out to verify the effectiveness and efficiency of our proposed method. The results showed that, compared with the traditional point collection and line collection schemes, the root mean square error of the fingerprinting-based positioning results were reduced by 35.9% and 25.0% in static tests and 30.0% and 21.3% respectively in dynamic tests. Moreover, our UGV can traverse the indoor environment autonomously without human-labor on data acquisition, the efficiency of the automatic robot line collection scheme is 2.65 times and 1.72 times that of the traditional point collection and the traditional line acquisition, respectively.

  • Fast fingerprint Database Maintenance for indoor positioning based on UGV SLAM
    Sensors (Switzerland), 2015
    Co-Authors: Jian Tang, Hannu Hyyppä, Juha Hyyppä, Jingbin Liu, Antero Kukko, Harri Kaartinen, Hannu Hyyppa, Juha Hyyppa, Liang Chen, Yuwei Chen, Ruizhi Chen
    Abstract:

    Indoor positioning technology has become more and more important in the last two decades. Utilizing Received Signal Strength Indicator (RSSI) fingerprints of Signals of OPportunity (SOP) is a promising alternative navigation solution. However, as the RSSIs vary during operation due to their physical nature and are easily affected by the environmental change, one challenge of the indoor fingerprinting method is maintaining the RSSI fingerprint Database in a timely and effective manner. In this paper, a solution for rapidly updating the fingerprint Database is presented, based on a self-developed Unmanned Ground Vehicles (UGV) platform NAVIS. Several SOP sensors were installed on NAVIS for collecting indoor fingerprint information, including a digital compass collecting magnetic field intensity, a light sensor collecting light intensity, and a smartphone which collects the access point number and RSSIs of the pre-installed WiFi network. The NAVIS platform generates a map of the indoor environment and collects the SOPs during processing of the mapping, and then the SOP fingerprint Database is interpolated and updated in real time. Field tests were carried out to evaluate the effectiveness and efficiency of the proposed method. The results showed that the fingerprint Databases can be quickly created and updated with a higher sampling frequency (5Hz) and denser reference points compared with traditional methods, and the indoor map can be generated without prior information. Moreover, environmental changes could also be detected quickly for fingerprint indoor positioning.

Jong-kyun Hong - One of the best experts on this subject based on the ideXlab platform.

James Walker - One of the best experts on this subject based on the ideXlab platform.

  • Sams Teach Yourself Exchange Server 2003 in 10 Minutes (Sams Teach Yourself in 10 Minutes)
    2005
    Co-Authors: James Walker
    Abstract:

    In your daily Maintenance routine of your company's Microsoft Exchange Server, you probably run into bumps along the way. Sams Teach Yourself Exchange Server 2003 in 10 Minutes is a great, quick-reference guide to the most common tasks you perform as an Exchange Server administrator. Use this guide as a basis for practical knowledge and solutions to problems with managing mailboxes, performing Database Maintenance, Outlook Web access, performance optimization and group policy management. When all you need is a quick-hit of information so you can quickly get back to work, Sams Teach Yourself Exchange Server 2003 in 10 Minutes is your best option.

Carmen Taglienti - One of the best experts on this subject based on the ideXlab platform.

  • Common Database Maintenance Tasks
    Beginning SQL Server 2008 Administration, 2020
    Co-Authors: Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Abstract:

    Database administrators perform a variety of tasks. Depending on how your organization is structured, your own roles and responsibilities will most likely differ when compared to DBAs at other companies. However, there are a few common Database Maintenance tasks that every DBA should be familiar with, regardless of your position. This chapter will introduce you to the core DBA Maintenance tasks, such as moving Databases and data, and other routine Maintenance tasks, like index reorganization.

  • Database Maintenance Plans
    Beginning SQL Server 2008 Administration, 2020
    Co-Authors: Robert E. Walters, Grant Fritchey, Carmen Taglienti
    Abstract:

    In Chapters 10 and 11, we talked a lot about ways in which you can execute both interactive and batchscheduled Database administrative tasks. In this chapter, we will introduce the SQL Server Maintenance plan. SQL Server’s Maintenance plans give you a way to perform an array of Database administrative tasks on a defined schedule. There are two ways to create SQL Server Maintenance plans: The first is by using the Maintenance Plan Wizard, which we will walk you through in detail in this chapter. The second is to use the Maintenance plan authoring environment in Management Studio. Figure 12-1 shows that environment. Open image in new window Figure 12-1 Maintenance plan authoring environment in Management Studio