The MAXDATA handbook gives a detailed introduction to the time series database system MAXDATA. This software product offers both specialists and inexperi- enced or occasional users a simple and convenient way to handle voluminous numerical databases on a personal computer. MAXDATA meets very conveniently the principal demands of ambitious and data processing users with respect to a modern database management and analysis system: database creation, research, management, documentation, data export and import, report, graphics, statistics, calculation, creation of indicator models, multiple regression, ex-ante and ex-post forecasts and so on. The MAXDATA handbook not only describes all these features in detail, but may also be regarded as a general introduction to the management and evaluation of empirical data, especially time series, and to the concept of central numerical databases on personal computers.
1. Hints for Studying the Handbook.- 1.1 Hint I: Readme File.- 1.2 Hint II: Survey of the Handbook.- 2. Philosophy.- 3. Concept.- 3.1 MAXDATA is Different.- 3.2 High Degree of User-Friendliness.- 3.3 Links to the World’s Databanks and Software Systems.- 3.4 Special Features.- 4. Summary of the MAXDATA Viewing Modes.- 4.1 Table Mode (MAXDATA option REPORT).- 4.2 Statistics Mode (MAXDATA option STATISTICS).- 4.3 Forecasting Mode (MAXDATA option REGRESSION).- 4.4 Formulae Mode (MAXDATA option CALCULATION).- 4.5 Regression Mode (MAXDATA option REGRESSION).- 4.6 Commentary Mode.- 4.7 Graphics Mode (MAXDATA option CHART).- 5. The MAXDATA Central Databank.- 5.1 MAXDATA Data Series.- 5.2 Structure of the MAXDATA Central Databank.- 5.3 Periodicities of the Central Databank.- 5.4 Time Horizon of the Central Databank.- 5.5 Central Databank Storage Capacity.- 5.6 Backup Copy of the Central Databank.- 5.7 Some Notes on the Treatment of Zeros and Missing Values.- 6. Installation of MAXDATA.- 6.1 MAXDATA Master Diskettes.- 6.2 Adaption of the DOS File CONFIG.SYS.- 6.3 MAXDATA Using Diskettes.- 6.4 MAXDATA Using Hard Disks.- 7. Start of MAXDATA.- 7.1 Screen Adaption.- 7.2 Batch Start of MAXDATA.- 7.3 Choice of Periodicity of the Central Databank.- 7.4 Creation of a Central Databank.- 7.5 Choice of an Existing Central Databank.- 7.6 Initialization of the Central Databank and RAM Variables.- 8. MAXDATA Main Menu.- 9. Some Principal MAXDATA Inquiries and Characteristics.- 9.1 Name Inquiry.- 9.2 Screen Display of Names.- 9.3 Period Inquiry.- 9.4 The Editor.- 9.5 The ESC Key.- 10. MAXDATA Options.- 10.1 INSERT.- 10.1.1 Data Series Documentation.- 10.1.2 Data Acquisition Period.- 10.1.3 Data Acquisition.- 10.1.4 Automatic Re-basing.- 10.1.5 Missing Values and True Zeros.- 10.1.6 Central Databank Full / No Storage Capacity.- 10.2 DELETE.- 10.3 UPDATE.- 10.3.1 UPDATE Command.- 10.3.2 UPDATE Command File.- 10.3.3 Updating of the Databank.- 10.3.3.1 Creation of a new UPDATE Command File.- 10.3.3.2 Editing an Existing UPDATE Command File.- 10.3.3.3 Execution of UPDATE Commands.- 10.3.3.4 Documentation of Updating.- 10.4 LIST.- 10.4.1 Display of a List of Contents of the Central Databank.- 10.4.2 Search of Data Series with Text Fragment.- 10.4.3 Search of Data Series with Name Fragment.- 10.4.4 Direct Display of Data Series Searched.- 10.5 PRINT.- 10.5.1 Printing the Contents of the Entire Central Databank.- 10.5.2 Printing the Contents of Part of the Central Databank.- 10.5.3 Printing a List of Contents.- 10.6 REPORT.- 10.6.1 Form and Structure of REPORT Tables.- 10.6.2 Defmition of a Table.- 10.6.3 Screen Display of Tables.- 10.6.4 Printout of a Table.- 10.6.5 Output to a Text File.- 10.7 RENAME.- 10.8 TRANSFORM.- 10.8.1 TRANSFO Databank.- 10.8.2 The Variables CONSTANT and TREND.- 10.8.3 Basic Types of Calculation.- 10.8.4 Square Root, Exponent, LN, EXP, SIN, COS.- 10.8.5 Moving Averages.- 10.8.5.1 Allocation to End of Period.- 10.8.5.2 Centered Moving Averages.- 10.8.6 LAGs and LEADs.- 10.8.7 Factor Option: Multiplication and Division Using Constants.- 10.8.8 Changing the Periodicity.- 10.8.8.1 Summing Method.- 10.8.8.2 Mean-Value Method.- 10.8.8.3 Special Features of Change of Periodicity.- 10.8.9 Non-Calculable Values.- 10.9 IMPORT.- 10.9.1 Import from Another MAXDATA Central Databank.- 10.9.2 Import from a TRANSFO Databank.- 10.9.3 Import from MAXDATA-Unrelated Files.- 10.9.3.1 Import of Individual Data Series.- 10.9.3.2 Import of Whole Files.- 10.9.3.3 Import of Documentary Texts of Data Series.- 10.9.3.4 Automatic Updating and Historical Memory.- 10.9.3.5 Problems with Data Import.- 10.9.4 DSI’s Diskette Databanks.- 10.9.5 DSI-Trans.- 10.10 EXPORT.- 10.10.1 EXPORT Macro Commands.- 10.10.2 EXPORT Command File.- 10.10.3 Data Export.- 10.10.3.1 Creation of a new EXPORT Command File.- 10.10.3.2 Editing an Existing EXPORT Command File.- 10.10.3.3 Choice of File Format for the Data to be Exported.- 10.10.4 Definition of File Formats.- 10.10.5 Screen Display of Exported Data.- 10.11 CHART.- 10.11.1 Immediate Graphic Display.- 10.11.2 Some Technical Details.- 10.11.3 CHART Main Menu.- 10.11.4 Definition and Presentation of Graphics.- 10.11.4.1 Logarithmic Scale.- 10.11.4.2 Automatic Scaling.- 10.11.4.3 Individual Scaling.- 10.11.4.4 Graphics Screen Editor.- 10.11.4.5 Printout of Graphics.- 10.11.5 The CHART Options.- 10.11.5.1 LINE Option.- 10.11.5.2 BAR Option.- 10.11.5.3 PIE Option.- 10.11.5.4 SCATTER Option.- 10.11.6 Treatment of Missing Data.- 10.11.6.1 Missing Data in a Time Interval.- 10.11.6.2 Missing Data at Start and End of a Time Interval.- 10.11.6.3 Too Many Missing Data.- 10.12 STATISTICS.- 10.12.1 Statistical Indicators.- 10.12.1.1 Non-Calculable Values.- 10.12.1.2 Treatment of Missing Data.- 10.12.2 Growth Rates.- 10.12.2.1 Based on the Previous Year.- 10.12.2.2 Based on the Previous Period.- 10.12.2.3 Growth Rate Indicators.- 10.12.3 Definition of a Statistical Analysis.- 10.12.4 Screen Display of Results.- 10.12.5 Printout of the Results.- 10.12.6 Storage of the Results in a Text File.- 10.12.7 Storage of Growth Rates.- 10.13 REGRESSION.- 10.13.1 Regression Methods Employed.- 10.13.2 The Variables CONSTANT and TREND.- 10.13.3 DefInition of a Regression.- 10.13.4 Presentation of the Estimates.- 10.13.4.1 Structure of the Result Table.- 10.13.4.2 Result Table for a Working Example.- 10.13.4.3 Output of Result Tables.- 10.13.4.4 Output of Variance-Covariance-Matrix.- 10.13.4.5 Non-Calculable and Missing Values.- 10.13.5 REGRESSION Menu Options.- 10.13.5.1 Storage of the Estimates.- 10.13.5.2 Reestimation for a Different Sample Period.- 10.13.5.3 New Estimate Using a Different Estimation Method.- 10.13.6 Trend Regression.- 10.13.6.1 Trend Calculation.- 10.13.6.2 Trend Smoothing.- 10.13.6.3 Trend Forecasting.- 10.13.6.4 Status-Quo Forecasting of Company Profits.- 10.13.7 Forecasts.- 10.13.7.1 Ex-Post Forecasts.- 10.13.7.2 Ex-Ante Forecasts.- 10.13.8 Estimation Procedures for Interdependent Systems of Equations.- 10.13.8.1 Two-stage Least Square Method (2SLS).- 10.13.8.2 Method of Instrument Variables.- 10.14 CALCULATION.- 10.14.1 Concept.- 10.14.1.1 Definition File.- 10.14.1.2 The Definition Equation of an Indicator.- 10.14.1.3 Mathematical Functions.- 10.14.1.4 DefInition Equation of a Balance Sheet Analysis Model.- 10.14.1.5 Definition Equation as a Means of Forecasting.- 10.14.2 CALCULATION Menu Options.- 10.14.2.1 Definition and Calculation of a new Indicator.- 10.14.2.2 Re-Calculation ofIndicators.- 10.14.2.3 Screen Display of Definition Equations.- 10.14.2.4 Amendment of DefInition Equations.- 10.14.2.5 Deletion of Definition Equations.- 10.15 PATH/SYSTEM.- 11. Treatment of Errors.- 11.1 Turbo-Pascal Errors.- 11.2 Turbo-Graphix Errors.- 11.3 Incorrect Graphics Board.- 11.4 Other Possible Sources of Error.- 11.5 Procedure with Systematic Errors.- 11.6 Guarantee.- A. Hardware Requirements.- B. On the MAXDATA Demonstration Software and Database.- C. Official National and International Economic Statistical Data on Diskette.- Cl. Offline Databases of the DEUTSCHE BUNDESBANK.- C2. Offline Databases of the E.C. COMMISSION (EUROSTAT).- C3. Offline Databases of the INTERNATIONAL MONETARY FUND.- C4. Offline Databases of the ORGANISATION FOR ECONOMIC COOPERATION AND DEVELOPMENT.- C5. Offline Databases of CITICORP.- C6. Classification Plan on Some Macroeconomic Offline Databases of the E.C.COMMISSION (EUROSTAT).- D. Copyright Information.- Abstract.- Order Form for Demo Diskettes.
Overview
The MAXDATA handbook gives a detailed introduction to the time series database system MAXDATA. This software product offers both specialists and inexperi- enced or occasional users a simple and convenient way to handle voluminous numerical databases on a personal computer. MAXDATA meets very conveniently the principal demands of ambitious and data processing users with respect to a modern database management and analysis system: database creation, research, management, documentation, data export and import, ...