Dimensional Table Research Articles

Implementation of Data Warehouse and Star Schema for Optimizing Property Business Decision Making

The property industry is a sector that faces intense competition, so innovation is needed to plan business strategies. PT Wijaya Karya Realty faces several problems, such as determining strategic locations for its property products, such as houses or shophouses, and comparing the price of company houses with the market price of homes in specific locations. To answer these needs, it is necessary to implement a data warehouse and Extract, Transform, Load (ETL). In this research, Pentaho Data Integration (PDI) is used as a tool for managing and cleaning data that can be used as analysis material to assist in data-based decision-making. Apart from that, Mondrian can be used through the workbench scheme to improve data analysis effectively. Designing a star schema that includes a dimensional table and fact table can help optimize the analysis process better. The implementation of a data warehouse allows companies to make in-depth decisions based on critical variables. The research results show that the implementation of Star Schema can provide information for companies in decision-making and business strategy planning in the property sector.

A Fundamental Experiment for Micro Ultrasonic Knurling Technology Creating High Precision Texture on Sliding Surface

Sliding surface in mechanical system is required to move smoothly and stop at target position. Sliding surface can move and stop by applying adequate friction force. Friction force is controlled by developing technology creating small texture on the surface with a few to a few hundred micrometer intervals. If friction force is reduced by applying this technology to large area sliding surface of airplanes, generators and machine tools, so on, the machining effect drastically improves. It is necessary to develop machining technology to create texture with high precision and efficiency. On the other hand, ultrasonic vibration is used in many manufacturing fields. It is well known that surface roughness is improved and stress is reduced using ultrasonic vibration. In this study, machining technology creating wear resistant texture on large area sliding surface with high precision and efficiency using ultrasonic vibration during knurling is developed. In this paper, effect of ultrasonic vibration is examined by the fundamental experiment. A horn to amplify ultrasonic vibration is designed and made. Frequency of ultrasonic vibration is measured and it is found that desired frequency is available. In the experiment making a groove on the surface with an indenter using a 2 dimensional table, pressing force and friction force are measured. These forces are reduced using ultrasonic vibration. Pressing experiment making texture on the surface is also made. Deeper and clearer marks are formed using ultrasonic vibration during knurling for the specimen made of copper.

COLLIMATOR EXCHANGE EFFECT OF MEGAVOLTAGE PHOTON BEAMS AND ITS IMPACT ON CLINICAL DOSIMETRY

AIM To determine the Collimator Exchange Effect (CEE) for telecobalt unit (Bhabhatron -II TAW) and Linear accelerator unit (Varian Trilogy). MATERIALS AND METHOD The study was carried out in Bhabhatron-II TAW Telecobalt machine and Varian Trilogy Linear Accelerator. The study was done to find the collimator scatter factor (S¬c) for rectangular fields at 5 and 10gm/cm2 depths using indigenously designed mini phantom. Three sets of electrometer reading were noted for the irradiation of each field size and the average was taken for calculation. Sc values for different rectangular fields were then calculated from these data sets and the CEE at two depths (5 and 10 gm/cm2) for the 6MV and 15MV photon and Co-60 gamma beam were calculated. RESULTS The values of Sc obtained for the rectangular fields as alternatively defined by X & Y jaws are different for high energy photon beams indicating CEE. The maximum percentage difference between the Sc of the corresponding collimator settings for the Bhabhatron-II TAW unit for depths 5 and 10gm/cm2 were found to be 0.42% and 0.5% respectively. Sc values for 6MV and 15MV photon beams were found to be higher when Y-jaw (upper jaw) acts as the longer side of the rectangular field. The maximum percentage difference between the Sc values of the corresponding collimator settings for 6MV at depths 5 and 10gm/cm2 were 2.74% and 2.87% respectively whereas for 15 MV the differences were 3% and 2.99%. CONCLUSION The CEE of Cobalt Teletherapy units can be ignored in clinical dosimetry. However, the CEE of Linear Accelerators having energies 6MV & 15MV should be taken into consideration. A two dimensional table of Sc should be generated for rectangular fields during MU calculations in Linear Accelerators. For TPS based calculations, the generated data should be incorporated during beam modeling for accurate dose delivery in clinical dosimetry.

The Analysis of High Dimensional Contingency Table with Interactions

This paper is focused on the analysis of categorical data in a 2 × c × K contingency table. The theoretical frame work of a 2 × c design is extended to 2 × c × K with provision for testing interactions among subsets of either lower or upper columns of the designated table. The developed chi square tests for the total interactions as well as for the partitions are shown to be significant and the degrees of freedom additive.

Parallel Techniques for Large Data Analysis in the New Version of a Futures Trading Evaluation Service

Abstract A futures trading evaluation system is used to help investors analyze their trading history and find out the root cause of profit and loss, so that investors can learn from their past and make better decisions in the future. To analyze trading history of investors, the system processes a large volume of transaction data to calculate key performance indicators (KPI) as well as time series behavior patterns, and concludes some recommendations with the help of an expert knowledge base. This work is based on our early work of parallel techniques for large data analysis for futures trading evaluation service. In our early work, we have used the query rewriting technique to avoid joining between fact table and dimension table for OLAP aggregation queries, and used a data driven shared scanning of data method to compute KPIs for one customer. However, the query rewriting technique cannot eliminate joining for queries which aggregate on an intermediate level of the hierarchy of a dimensional table, so we propose a segmented bit encoding of dimensional table method which can eliminate the joining operation when the query aggregates on any level of the hierarchy of any dimensional table. Furthermore, our previous method perform badly when concurrency is high, so we propose an inter customer data scan sharing scheme to improve system performance in highly concurrent situations. We present our new experimental results.

Spatial hashing based contact detection for numerical manifold method

A spatial hashing method was introduced to accelerate the contact detection process in the numerical manifold method. All objects (blocks) in the work space are hashed to a one dimensional hash table based on a spatial grid, then only blocks within the same place in the hash table need to do contact detection. The proposed method has a time complexity of O(n). Experiments show that the spatial hashing contact detection has a significant improvement in performance.

FPGA Implementation of a Fuzzy Control Surface

This paper presents a design methodology of a dual-input single-output fuzzy logic controller where synthesizing the classical three stages, fuzzification, inference engine, and defuzzification, are replaced by the outcome control surface obtained from these stages which is treated as a tow dimensional table called fuzzy control table FCT. With this proposed approach, (8x8), (16x16), (32x32), and (64x64) FCTs were investigated each having 64, 256, 1024, and 2048 values respectively. To make this system adaptable to different operating states a supervisor fuzzy controller is designed to continuously adjust, on line, the output factor of the basic fuzzy controller based on the error and change in error signals. The proposed architecture is implemented in XC3S200 FPGA, Spartan-3 starter kit to control the position of a D.C. servo motor with unknown parameters in real time. Keywords: control table, FPGA, fuzzy control surface, supervisor controller.

تطبيقات ادوات برامج المصفوفات للتطوير الكمي للتعليم العالي

Academic quality assurance process is a central to achieving and maintaining universities excellence and advancement. Academic staff and scientific research are strongly involved in this process.<br /> Scientific research is the major significant indicator of academic staff’s quality and the determinant of development and advancement.<br /> In this research the relationships of the related indicators of the academic staff categories, and scientific research fields, are studied based on the quality indexes. The case study application, included (academic staff & scientific research of four engineering departments). The “Matrix Diagram Tool”, which is one of seven new quality tools ,is used to analyze the collection data of the above two fields and their indicators, , it is beneficial for problem solving process.<br /> Many “Matrix Diagrams Tools” are used to analyze the data collected for this research purpose, such as; L- type matrix, which is a two- dimensional table, T- type matrix, which is a three dimensional table and Y- type matrix, which is a three dimensional.<br /> The results signified the relationships of academic staff categories and subcategories, the strength and weakness points, and also the comparison of the four departments of all indicators.<br /> According to the results, many recommendations are suggested to strengthen the weak points and many corrective actions are mentioned, to improve quality in the engineering departments.<br />Key words: quality assurance ,matrix diagram , new” quality tools, higher education, academic staff<br />

Relationships Between Full and Layer Models with Applications to Level Merging

Analysis of a large dimensional contingency table is quite involved. Models corresponding to layers of a contingency table are easier to analyze than the full model. Relationships between the interaction parameters of the full log-linear model and that of its corresponding layer models are obtained. These relationships are not only useful to reduce the analysis but also useful to interpret various hierarchical models. We obtain these relationships for layers of one variable, and extend the results for the case when layers of more than one variable are considered. We also establish, under conditional independence, relationships between the interaction parameters of the full model and that of the corresponding marginal models. We discuss the concept of merging of factor levels based on these interaction parameters. Finally, we use the relationships between layer models and full model to obtain conditions for level merging based on layer interaction parameters. Several examples are discussed to illustrate the results.

Prediction and Control of Response Rate to Surveys

Synoptic This paper proposes a technique for survey designers to infer response rates based on the length and the salience (importance of subject to the respondent) of questionnaires. In order to understand the relationship between response rate, salience and the time respondents are willing to spend on a questionnaire, 430 people were surveyed. A statistical analysis was conducted on the data and a set of rules were generated for a fuzzy Inference System (FIS). Implementation of the proposed technique has resulted into a three dimensional reference table which shows the correlation between Time, Importance and Response Rate. The inferred table may be used as a guideline to estimate response rates in surveys. The provision of incentives is also considered in this work.

Alignment Between the Science Curriculum and Assessment in Selected NY State Regents Exams

This article reports on an analysis of alignment between NY state core curricula and NY Regents tests in physics and chemistry. Both the curriculum and test were represented by a two dimensional table consisting of topics and cognitive demands. The cell values of the table were numbers of major understandings in the curriculum and points of test items in the test. The Porter alignment index was computed for each test. It was found that, overall, there was a high alignment between the NY core curriculum and the NY Regents test, and the alignment remained fairly stable from test to test. However, there were considerable dis- crepancies in emphases on different cognitive levels and topics between the core curriculum and the test. Issues related to the nature of alignment, and the nature and validity of content standards were raised, and implications for sci- ence curriculum and instructions were also discussed.

고속회전구동기의 힘 및 토크 외란 3차원 측정과 파라미터 추정

A momentum type actuator produces force and torque disturbances as well as its designed control torque. These disturbances are ones of the largest disturbance sources inside the spacecraft, which deteriorate the pointing stability of the high precision spacecraft. The measurement and analysis of actuator disturbances are therefore imperative for such a spacecraft, and thus a three dimensional torque measurement table has been developed for that purpose. The data acquired from the measurement table are processed in the frequency domain and displayed in the power spectral density(PSD). Through this process, disturbance model parameters are obtained and used for the attitude stability simulation. The process has been adopted for the disturbance measurement of the reaction wheel, and the validity of measurements and parameter identification procedure is verified.

Fuzzy Control Algorithm Eliminating Steady-state Position Errors of Robotic Manipulators

In order to eliminate position errors existing at the steady state in the motion control of robotic manipulators, a new fuzzy control algorithm is propeosed using three variables, position error, velocity error and integral of position errors as input variables of the fuzzy controller. Although the number of input variables of the fuzzy controller is increased from two to three, the number of fuzzy control rules is just increased by two. Three dimensional look-up table is used to reduce the computational time in real-time control, and a technique reducing the amount of necessary memory is introduced. Simulation and experimental studies show that the position errors at the steady state are decreased more than 90% compared to those of existing fuzzy controller when the proposed fuzzy controller is applied to the 2 axis direct drive SCARA robot manipulator.

Decision tables: Formalisation, validation, and verification

AbstractThe decision table is one of the simplest representations of the rules underlying a systematic decision‐making process, and is especially valuable in the development of knowledge‐based systems. A two dimensional table links all relevant combinations of input conditions to the desired combinations of output actions in a very intuitive way. This simplicity belies the complex considerations involved in verifying, validating, formulating or interpreting this (or any other) representation of machine‐based knowledge. In this paper, the common styles of decision table representation are reviewed, a formulation of their meaning is presented, construction methods are reviewed, and an algorithm for ensuring consistency is suggested. The problems that may occur in imperfectly constructed tables are discussed, detection methods reviewed, and some implementation methods are presented.

Intensité de liaison et masse d'information des tableaux de contingence: deux problèmes de mesure en analyse des données

Link Strength and Volume of Information in Contingency Tables - Two Problems of Measure in Data Analysis. This article presents on-going work concerning the unhealthy use of certain statistical measures. It flrst of all proposes a tool for measuring the internal correlation within a large dimensional contingency table in order to be able to compare other similar table in this framework by using a cœfficient whose values are between 0 and 1. The article then studies the information contained in a table which would correspond to the situation of statistical independence between variables during correspondence analysis. Using the hypothesls this quantity of Information should be taken into account before a correspondence analysis, the article then proposed a tool for measuring that volume of information that sociologists usually do not treat as such.

Spreadsheets:

For many years, I have been recommending Reflex (published by Borland International) as a tool for analyzing financial and statistical data. My primary reason for this recommendation has been that Reflex allowed me to cross‐tabulate data. If you want to look at the year's financial data broken down, for example, by month‐by cost center‐by line item, you are essentially dictating that you want to do a crosstab. Reflex has a built‐in “view” that allows you to construct a two dimensional table that, with data limiting capabilities, yields a surprisingly diverse and multidimensional look at your data. In fact, I installed a financial reporting system in a library back in 1987 that was based on Reflex. In 1993 the library finally changed over to a commercial reporting system (costing thousands of dollars) that replaced Reflex. Yet, the old system provided a fairly flexible reporting and analysis system.

A three-dimensional periodic table

The invention includes a three dimensional periodic table of the chemical elements and a method of learning about the periodic nature of the elements. Included are several cardboard or paper sheets, each having a plurality of blocks that display information about particular elements. The blocks are arranged in groupings of elements with similar properties, such as the transition Earth metals. Students follow a set of instructions provided with the sheets to cut out the groups, fold along particular lines, and affix tabs together to assemble several three dimensional forms. The students then place the forms on a planar map that indicates where to place each form and indicates how to follow the periods of elements between the forms.

The stability of several measures of association in small contingency tables

Measures of association are often used to describe the relationship between row and column variables in two—dimensional contingency tables. It is not uncommon in biomedical research to categorize continuous variables to obtain a two—dimensional table. In these situations it is desirable that the measure of association not be too sensitive to changes in the number of categories or to the choice of cut points. To accomplish this objective we attempt to find a measure of association that closely approximates the corresponding measure of association for the underlying distribution.Measures that are close to the underlying measure for various table sizes andcutpoints are called stable measures.

ねじ駆動による超精密位置決め (第1報)

One dimensional table unit driven by a sliding screw or a ball screw is made with a laserfeed-back system, aiming at ultra-precision positioning at high speed. In this report, the follow-ing items are clarified by the experiment of PTP proportionalcontrol : (1) With increasing theaxial speed, the sliding screw requires much more energy than the ball screw and this derivesa damping effect to the control system. Therefore, the ball screw shows a sharper response thanthe sliding screw. (2) In case of the simple proportional control, the deviation error (off-seterror) is generated by the quantumization of a D/A converter. By adjusting the proportionalgain, both the deviation error and the dispersion error cannot be decreased at the same time.

Multidimensional contingency tables with missing data

This paper is concerned wim ine maximum likelihood estimation and the likelihood ratio test for hierarchical loglinear models of multidimensional contingency tables with missing data. The problems of estimation and test for a high dimensional contingency table can be reduced into those for a class of low dimensional tables. In some cases, the incomplete data in the high dimensional table can become complete in the low dimensional tables through the reduction can indicate how much the incomplete data contribute to the estimation and the test.