Topic > Creating an EcOS Database - 1468

How to create an EcOS database?In EcOS, data and metadata are stored in the time series database. An EcoS database has a few key characteristics: • An EcoS database serves as a container for data, metadata, and objects. • The database structure is governed by its attributes. • Since it is a time series database, each stored series is tied to a time dimension.• Each time series has a predefined scale.This video shows how to create an EcoOS database.Step 1. Planning. Before building a database in EcoOS determine the processes of creating, updating and maintaining the database. (You should determine the database creation, update, and maintenance processes before building a database in Ecos.)• For example, try to think about database attributes and the contents of these attributes.• Determine how the database should be built.• Decide which data and metadata import activities should be established in the database.• Determine the actions to be performed on the database, such as transformations, validations, reports, and activities.• Determine how the results should be presented and shared. These steps can help you create a database effectively. Step 2. Set up the dictionary that governs the database.1. How to set a new definition? (For starters, we need to set a new definition) Let me show you how to set a new definition in a dictionary. I start by clicking the Global Definitions button from the EcoOS home page. Then, I select a folder from the left pane where you want to set a definition and click the Create button from the Home toolbar. Now I can see a dialog box In Open Definition where I can replace the default name New Definition with the desired name, for example My Country. Upon request you can... half of the sheet ......see The Date Format.f dialog box appears. Because the current date format appears as YYYY, under Allowed Substitutions, double-click Year ($Year$) to insert this code into the Date Format field. Click OK.h. Now that your selection is complete, click the Map.i button. Once all mappings are done, click Next to continue.14. Configure the Settings options.15. Before importing, users are recommended to test their import configurations. You can do this easily by clicking the Test Import button. Note that no errors were found.16. Click Next to review the import summary.17. Click the Import button to import the data into the database. The import procedure is executed. When complete, a summary of the import log is displayed.18. After the import is complete, review the import process log and select Finish to close. And I have successfully loaded the data into my database.