How to get to Shiqiao central hospital
because power (kw) = torque (nm) × Speed (RPM) / 9549, so the output torque (nm) = 9549 x η X input power (kw) / speed (RPM).
the specific numerical calculation should be supplemented.
friction angle = arctan μ μ It is friction factor)
friction factor is related to contact line, lubricating oil, sliding speed, material matching, processing, installation accuracy, heat treatment, etc., which is difficult to determine, only recommended value
you can refer to the manual, for example, when the sliding speed is 0.1m/s, the friction factor is 0.08, and the friction angle is 4 ° 34'
ETL is the abbreviation of English extract transform load, which is used to describe the process of extracting, transforming and loading data from the source to the destination. ETL is commonly used in data warehouse, but its object is not limited to data warehouse
Generally, ETL or ELT (extract load transform) are used in the process described by ETL. Generally, the larger the amount of data, the more complex the conversion logic, and the database with strong computing power at the destination, the more apt is used to make use of the parallel processing power of the database at the destination 
extended data
ETL has several characteristics:
one is data synchronization, which is not a one-time data pull, it is a regular activity, according to a fixed cycle, and even now some people put forward the concept of real-time ETL
The second is the amount of data, which is generally huge. It is worth splitting the data flow process into e, t and L<source: Internet ETL
(2) SQL Server: can be used to find auto increment fields or timestamps
(3) Oracle: the search sequence field is also self increasing
(4) if you can't find the above fields, you can analyze the actual business data, such as whether various numbers are self incrementing without repetition
the data of last month will not change, but the change is only in this month, so the data of this month is incremental data
(1) for data tables with incremental change records, split them (insert, update and delete) to process data synchronously
(2) for incremental data:
A: the lookup component delete can implement insert and update, and only the outer join method can be used for delete
b: the outer join and null keyword methods can implement insert, update and delete, but it consumes performance when the amount of data is large
C: the slow changing dimension component of SCD can easily implement insert and update, while delete can only use the outer join method
Two: ETL no incremental data: if you can't find incremental data, you can only delete all of them first and then extract all of them
recommend great articles:
The typical representatives of ETL tools are: Informatica, Datastage, OWB, Microsoft DTS, beeload, kettle, Jiuqi ETL...
the open source tools are eclipse ETL plug-in: cloveretl
Data Integration: fast implementation of ETL
the quality problems of ETL are manifested in correctness, integrity, consistency, completeness, effectiveness, timeliness and accessibility. There are many reasons that affect the quality of the system. The main reasons caused by the system integration and historical data include: the data model of the business system is inconsistent in different periods of time; The business process of business system changes in different periods; The old system mole is inconsistent in operation, personnel, finance, office system and other related information; The inconsistency caused by incomplete data integration of legacy system, new business and management system
to implement ETL, the first step is to implement the ETL conversion process. It can be reflected in the following aspects:
1. Null value processing: it can capture the null value of the field, load or replace it with other meaningful data, and load it to different target databases according to the null value of the field
2. Standardized data format: the definition of field format constraints can be realized, and the loading format can be customized for time, value, character and other data in the data source
3. Split data: fields can be broken down according to business requirements. For example, the calling number is 861082585313-8148, which can be decomposed into area code and telephone number
4. Verify the correctness of the data: you can use the lookup and split functions to verify the data. For example, after the calling number 861082585313-8148 is decomposed into area code and telephone number, lookup can be used to return the calling area recorded by the calling gateway or switch for data verification
5. Data replacement: e to business factors, invalid data and missing data can be replaced
6. Lookup: find the missing data. Lookup implements sub query and returns the missing fields obtained by other means to ensure the integrity of the fields
7. Set up the primary and foreign key constraints of ETL process: for the non dependent illegal data, it can be replaced or exported to the error data file to ensure the loading of the unique record of the primary key
44 minutes 7.7 km
Nancun
walk 640 meters
get on at Nanmen station of Shawan ancient town
fan130 road 13 station
get off at Panyu Central Hospital terminus
walk 120 meters
Shiqiao Central Hospital
2. From Zengcheng Xintang station, take No.214 (no monthly ticket) (no 39 station), go to Gangding station, go to Gangding station a, and transfer to Metro Line 3 (Tianhe) Passenger station - Panyu Square (take 11 stops) get off at entrance C of Shiqiao station, cross the road and go left to Panyu Baiyue Square Station (Metro Shiqiao station), then transfer to Shiqiao baomoyuan special line (no monthly ticket is supported) (take 4 stops) and get off at Panyu middle school station. Walk about 670 meters to Panyu Shiqiao hospital station