CoreModel

The Professional Database Modeler


home page

description

license

metadata server

xml schema

internal map

external map

change log

   




Professional data modeler.

            Metadata server.

                        Data dictionary.




      Project Change Log


          ( Please scroll down. )


documentation

testing

free download

requirements

database manager

query tool

inquiries

policy letter

date protocol



                                                               

About Bugs

I forget to finish things. I forget to include things in a new function. I forget to test things. My memory is terrible.

I could write task lists. I could create test scripts. I could develop project plans. And generally expend adequate time on administration.

So I just build.

Keep each download so you can roll back if you cannot live with the current bugs.




Current Work

AxleBase is receiving most of my attention at the moment. But CoreModel is still my first love.

I appreciate the way that CoreModel's concepts and documentation have impacted the computing world, and I plan to do more with it when AxleBase is at a stopping point. Although CoreReader has been downloaded far far more than has CoreModel, I believe that it is because CoreModel is so hard to understand for most people. CoreModel is far more important and is a much bigger contribution to those who can understand it.

CoreModel is massive and much of his code has not been looked at in years. So that he can continue to evolve (and to give me a means of relaxing), the error handler that weaves throughout his code will be entirely rebuilt as time permits. He will be given techniques that were developed in the AxleBase project to better handle internal system errors.




Change Log
( Upgrades, Fixes, and Enhancements )

release target description
 
60222 help Fixed bug created in help system by the new error path.
60221 web site The new error handler revealed a bug in the web site administrator.
AxleBase Upgraded the embedded AxleBase database manager.
import Upgraded and expanded the imports.
instantiator Improved the model instantiators.
instantiator Added OLEDB support
60216 errors Began conversion to the AxleBase error return protocol.
error traps Rebuilt error threads in various parts of the project.
sorts Fixed extended sorts in the data browser.
40516 data entry Cleaned up some ten year old code in edit screens.
40516 closure Expanded the closure test report.
edit screens Improved handling of the edit screens.
errors Added more internal error handlers.
May have created bugs, but some hidden ones were fixed.
40508 reports Bug fix: Reports can now check data types, etc.
dll hell Instituted a workaround for the Microsoft dll problem which, I hope, will protect multiple AxleBase installations.
40503 import Bug fix: Fixed the AxleBase import.
stepper Bug fix: Model movement to next level had stopped working.
import Did some cleanup on the instantiator and import reports.
connections Database connection creator had stopped working.
install The install corrupted CoreReader and other systems using AxleBase.
edit screen Delete action on the edit screen is improved.
grid Bug Fix: Grid column widths were not working properly.
30825 edits Enhanced object name validations.
model Bug fix: Model master edit screen.
config Bug fix: Administrator's configuration stopped working.
domains Bug fix: Domain edit screen.
cruds Bug fix: Crud add screen.
import Added data types and sizes to OLEDB imports.
table edit Bug fix: Intermittent error in table edit screen.
30803 indexes Index import was reversing table and column names.
server The case change broke part of the web administrator.
error trap Added more user error traps for utilities.
refresh Improved data browser and edit screen refresh.
brands Alleviated confusion between servers and brand names.
instantiator Enabled instantiation in AxleBase.
validator Tied server objects into the model validator.
validator Tied data type objects into the model validator.
case Bug fix: Upper case change caused conceptual level problems.
help Bug fix: Corrected the info screen displays.
import Bug fix: The upper case change broke the import.
sizer Removed index requirement from the size forecaster.
30722 edit Bug fix: Edit screen scroll had recently failed.
( Please tell me when these things happen. )
import Enabled model imports at the physical level.
import Enabled model imports from AxleBase.
case Meeting requests, codes are changed to upper case.
Please watch for bugs.
30525 connection Bug fix: Updated the connection types in the edit screens.
30320 model mgr Bug fix: Added check for demo before creating a new one.
30128 settings Added toggles and speed to the administrator's configuration screens.
Oracle Compensated for Oracle's inability to use industry standard syntax to produce a model schema.
Oracle Compensated for Oracle's inability to generate identity columns to enable it to support the daily messages.
Oracle Compensated for Oracle's inability to truncate the system log.
validator Reworked the model validation utility.
server Added detailed activity logging to the metadata server.
model mgr Added a model rename utility.
Oracle Bug fix: Oracle could not delete from the data browser.
Oracle Compensated for Oracle's inability to use industry standard syntax to load the data browser.
Oracle Compensated for Oracle's inability to use industry standard syntax in the model validation utility.
warnings Bug fix: Browser could not load the change warning editor.
MySql Added backslash escape mechanisms for MySql server installations.
MySql Bug fix: Printed reports were not loading for MySql server installations.
loader Bug fix: Admin's daily message was unloading the system.
instantiator Added process logging to the instantiator.
import Added process logging to the object import procedure.
import Bug fix: The OLEDB object import had stopped working.
model mgr. Added a button to separate the empty and destroy functions.
browser Cleaned up the column headings.
database Made the evaluation database pack a bit more solid.
export Bug fix: Intermitent failure to export indices.
model mgr. Bug fix: Drop model was not dropping the change warnings.
database Added a pack utility for the evaluation database.
edit screen Bug fix: Intermitent delete errors.
changes Added pending change warning to implementation module.
server Made the metadata server aware of change warnings and target dates.
validator Bug fix: Release 30102 changes stopped conceptual level validation.
export Bug fix: Release 30102 stopped conceptual level exports.
management Bug fix: Release 30102 broke the model manager utilities.
server Bug fix: Release 30102 broke the metadata server.
doc Expanded the documentation and on-line help.
genesis Bug fix: Forgot to alter genesis level for release 30102.
browser Bug fix: The select had quit working in the data browser.
security Removed model information from the main screen.
conceptual Added resource lists to the conceptual level.
data entry Enabled carry-forward in attribute and column add screens.
30102 * * Caution: Do NOT upgrade to or past this release until all models are worked past the conceptual level!
Enabled retrograde operations to the conceptual level.
web site Bug fix: The web site administrator had started adding extraneous lines to the documentation.
relations Revised the relation analysis utility.
21230 data entry Enabled cruds.
instantiator Added cruds.
21228 installation Enhanced the system initialization to support beginners.
installation Creates an empty database to support beginners.
errors Enhanced the error handling sub-system.
beginners The system now checks its database in every startup.
data entry Cleaned up the relation data entry screens.
validator The model validator utility has been completed,
and will now validate models at all levels.
data entry Improved the column data screens.
data entry Clarified the model master screens.
instantiator Added the ability to instantiate through OLEDB connections.
connections Added DSN connections.
metadata Bug fix. Metadata server was broken by the change to ODBC.
size rpt Bug fix: Size forecaster was broken by the change to ODBC.
standards Bug fix: Name standardizer was broken by the change to ODBC.
schema Bug fix. Schema report was broken by the change to ODBC.
instantiator Instantiator has been completed.
CoreModel can now instantiate a model in any database manager.
DML Change: The use of DML now requires a DML connection object.
demo The demonstration model is substantially upgraded to a complete and functional model.
connections Bug fix. Edit screen was not displaying saved data properly.
browser Bug fix. Wasn't behaving well after deleting all records.
connections Enabled the use of ODBC connections in all modules.
imports Expanded import ability to all database managers.
imports Added an ODBC import operation.
( Now has an automatic connection detector. )
imports Increased the amount of object information.
21208 internal Resumed work on CoreModel
Numerous minor internal changes.
Placed CoreReader in maintenance mode.
21119 screens Implemented CoreReader's screen handler.
Still in maintenance mode.
Resources are diverted to CoreReader.
21007 constraints Bug fix: Constraint table creation.
20910 Oracle Began testing with an Oracle backend.
20622 Project resources are temporarily diverted to the CoreReader project to bring it on line.
20603 OLEDB Chopped out the OLEDB overhead. Increased speed while decreasing the size by megabytes.
Added daily message utilities.
20305 remote Moved remote server settings into the configuration screen.
comm Added communication module with control console.
docs Improved documentation handling.
Bug fix: The data type add screen had stopped working
included standards and model states in the export
Bug fix: Export of models and process types
20202
increased the accuracy of the server cycle timer
corrected path in the second level XML dictionary pointer
If an object on which a server was working was deleted, the server logged an error and shut down. The server now logs the incident and continues functioning.
redesigned servers to reduce the load placed on the cpu
bug fix: on NT or win2k, web admin failed to create web site
finished the model publication approval mechanism
expanded the number of name standards
moved standards into a maintainable table format
bug fix: model copy didn't work at conceptual level
bug fix: model drop didn't work at conceptual level
20101
completed and enabled the security system
squashed a bug in column add screen
included indices in size forecasts
completed the relation utility
made data set size configurable
added an administrator's system lock
swatted a bug in the name standardizer
revealed protoforms to web administrator
added model publication to admin controls
gave web administrator more control of object selection
added new objects to the web site
created manager objects and screens
created controls for object types
created genesis level module
created protoform objects and screens
created model state objects and screens
redesigned and rebuilt name standardization utility
. . . . increased its scope
. . . . changed from a doer to an advisor
bug fix: the relation utility had quit working
also enhanced it while working on it
Enhanced the documentation handling
Rebuilt the help system
11206
added independent logging controls to metadata server
Enabled logging of import operations
Built the DML import apparatus
added constraint objects to the model
bug fix: Administrator could not create some kinds of help messages
Redesigned table, column, and index objects to ease index management.
Added secondary indices to ms. sql server instantiator
Added secondary indices to access instantiator
completed the DML generator
completed the ms. sql server instantiator
bug fix: database server export from admin module had stopped
enhancement: modified views interface to make more sense
enhancement: modified processes interface to make more sense
bug fix: demo creation had stopped because of new cruds
added crud table to models
created add, edit, browse screens for cruds
passed cruds to web site administrator
added cruds to dictionary server
completed the access instantiator
added column ordinality to the system
rebuilt model process table and screens
enabled model process import
created reports for imports
created reports for instantiator (but it's still not complete.)
built ASP dll to write remote control XML schema
gave CoreModel the ability to do an ASP web site
enabled the script selector for the web administrator
11102
bug fix: views were crossing model boundaries in edits
bug fix: server error when no models were published
added a model publication over-ride to the dictionary server
added a schema based XML driven internal remote control server
Included schema based XML in the data dictionary interface design.
Completed the Metadata Server.
Upgraded internal documentation handling.
Replaced internal documentation with extended documentation.
Enhanced the exported documentation.
Bug fix: System was not updating connection & query timeouts.
    caused all kinds of bad things after tables hit a half million records.
Built the model instantiator for ms. access.
Upgraded log truncator to handle large tables.
Created a custom query tool for the administrator.
Increased resilience with separate data connections in the metadata servers and server admin control.
Improved handling of add/edit screens.
Upgraded data error traps in all edit screens.
Set tab order on all of the data screens.
Reworked the documentation.
Bug fix: Changed server data connection to prevent crash when other systems change data.
Rebuilt metadata server to allow both processes to run on a single computer.
Completed the dictionary server test button.
Added names of server computers to server parameters.
Enabled verbose logging in metadata server.
Redesigned server control to allow remote reconfiguration of running servers.
11002 Added new publication controls to web administrator.
Enhanced operation of the web administrator.
Added maintainable company/organization id records.
Put company/organization i.d. in web page headers.
Built framework for dictionary server.
Added connection lookup to model import.
Fixed bug: Views were erring out of web site.
Added views to the model import.
Added procs to the model import.
Fixed bug in view exports.
Expanded web site administrator controls.
Created a separate control form for metadata server.
Created a data connection table to store connections.
Created data connection add screen.
Created data connection edit screen.
Completed the add and edit screens for views.
Included views in name standardization.
Included indices in validation.
Added keys to validation.
Included indices in size forecast.
Gave the web administrator access to model indices.
Created index table and table builder.
Created index add form.
Created index data browser.
Updated help messages and demo builder.
Added indexing to physical and implementation levels.
Removed index data from columns & tables.
Added index records to the export.
Added indices to the schema.
Enabled import of indices.
Fixed bug that turns on security in a new installation.
Cleaned up bugs in model exports.
Added export to the implementation module.
Completed the database size forecast module.
10906 Upgraded the model copier.
Upgraded the log truncater.
Enhanced some of the reports.
Completed the schematization module.
                                                               




This web site was created with and is maintained with
Notepad and FTP from the DOS prompt.

       

Copyright 1999 - 2006 John Ragan.
CoreReader, CoreModel, and AxleBase are registered trademarks.