Siemens Industry, Inc.

Siemens Building Technologies, Inc.

Phil Pollock

Mark B Gagner

Michael H Soemo

John Stewart

A method includes receiving a data input file, the data input file defining a first set of data fields to be included in a database and including a set of data elements to be included in the database. The method also includes identifying a second set of data fields in the data input file that are designated to contain a Boolean element, said second set of data fields being a subset of the first set of data fields. The method further includes defining at least one new data field, each new data field collectively storing a plurality of the Boolean elements. The first set of data fields are modified to eliminate the second set of data fields. The method also includes storing in a catalog data that defines an arrangement of the first set of data fields, wherein the arrangement includes the at least one new data field for collectively storing the Boolean elements.

Method for cataloging and storing data in a control system

A method is used for editing a data element stored in a static memory device comprising a plurality of storage units. The method includes a step of copying a content of one of the storage units to a dynamic memory device, wherein the content comprises the data element. The method further includes editing the data element while the data element is stored in the dynamic memory. The method also includes erasing said one of the storage units, and writing the content, including the data element that has been edited, into one of the storage units.

Partially embedded database and an embedded database manager for a control system

A method for creating a compressed database includes a step of receiving a data input file. The data input file defines a first set of data fields to be included in the database and includes a set of data elements to be included in the database. The method also includes identifying a second set of data fields in the data input file that are designated to contain a Boolean element, the second set of data fields being a subset of the first set of data fields. The method further includes defining one or more new data fields for collectively storing the Boolean elements, and modifying the first set of data fields to eliminate the second set of data fields. The method also includes generating a catalog that defines an arrangement of the first set of data fields, wherein the arrangement includes the one or more new data fields for collectively storing the Boolean elements.

A data storage system includes a database that is configured as a static data file containing static data and a dynamic data file containing dynamic data. The static data file is stored in a static memory device and the dynamic data file is stored in a dynamic memory device. A catalog included in the database defines whether the data is static or dynamic and further defines an arrangement of a set of data fields and data records included in the database. A database manager uses a file system to access the files in a rapid manner using an address pointer and, because the data is stored in files, the data may be accessed remotely without need for additional communication strategies/protocol. To enable editing of the static data, the database manager creates a mirror image of the static data in the dynamic memory where editing may occur. The mirror image of data having the edited data is later returned to the flash memory. A database generation tool ensures that Boolean data elements are efficiently stored in the database by causing all of the Boolean elements to be collectively stored in one or more data fields.

Growing community of inventors

McHenry, IL, United States of America

Phil Pollock