Company

Products

Services

Partners

Media

 

 

 

Home

Empress Markets

News & Events


Presentations

Press Releases

Product Profile

Success Stories

Technical News


White Papers

Join Mailing List

For More Info

         
EMPRESS Ultra Embedded in
Telecommunications and Networking

The convergence of Internet, telephony and wireless technology changes the way we communicate, work and live. The present challenge of leading telecommunications and networking vendors is to provide systems with richer functionality at faster speeds and lower cost in order to meet constantly evolving market demands.  

For telecommunications and networking vendors, accelerating time-to-market produces rapid recovery of development cost and increased revenue generation. One technique for faster time to market is to use component-based design for product development. Reusable modules and commercial off-the-shelf components like EMPRESS Ultra Embedded are ready to be embedded as part of feature rich products. By using commercial components, valuable human resources are not wasted in reinventing and maintaining the same component functionality.  Building intelligent devices becomes an easier and more straightforward task.  

Reasons why EMPRESS Ultra Embedded is utilized in telecommunications and networking applications:

  • Rich toolset, rich data types and rich functionality for rapid development
  • Flexible and configurable for application optimization
  • Small footprint ideal for size constrained environments
  • Predictable performance
  • High reliability and consistency of data
  • Embeddable as a single unified program that is robust and efficient
  • Easy, straightforward and cost effective runtime licensing
  • Continuous product development, deployment and life cycle support

EMPRESS Ultra Embedded Functionality 

EMPRESS Small Footprint Ultra Embedded delivers an unmatched combination of rich features, rich tools, rich data types and high performance that are well suited to the Telecommunications & Networking industry:

Rich toolset, rich data types and rich functionality for rapid development

  • TOOLSET API’s:
  • DSQL and ESQL
  • Interactive SQL and Java SQL
  • C and C++
  • JDBC
  • ODBC
  • Report writer
  • Third party product interfaces

EMPRESS DATA TYPES:

  • Character
  • Text
  • National Language Support
  • Binary
  • Date and Time
  • Microsecond Timestamp
  • Decimal
  • Dollar
  • Real
  • Float and Double Precision
  • Integer – short, long, 64-bit  
  • Tiny Integer
  • Sequence

 

EMPRESS FUNCTIONALITY:

  • SQL support
  • Kernel level C API
  • Transactions
  • Locking
  • Indexing
  • Time series Indexing
  • Hierarchical Join
  • Cascade Delete
  • Persistent Stored Modules
  • Triggers and Stored Procedures
  • Referential Constraints
  • Range Checks
  • Nanosecond Time Stamp
  • On-Line Backup and Recovery
  • Replication
  • Audit trail Logging
  • Unicode support
  • User Defined Functions
  • Integrity Check
  • Import and Export
  • Shared Memory
  • Batch Commands

Flexible and Configurable for application optimization

  • Stand-alone and client/server
  • On-disk and in-memory capability
  • Layered architecture accessible at 4 levels allows optimization and rapid prototyping
  • Over 170 system variables for configuration, tuning and optimizing
  • Customizable product footprint

 

Small footprint for constrained environments

  • Minimum resource consumption for high functionality
  • Small disk size that is customizable
  • Small memory usage with usage limits

 

Predictable performance

  • Fast database engine
  • Minimum overhead
  • Kernel level control and speed
  • Direct access to database structures
  • Deterministic response

 

High reliability and consistency of data

  • 24x7 unattended operation
  • Data integrity maintained
  • Minimum storage/disk fragmentation

 

Embeddable as a single unified program that is robust and efficient

EMPRESS can be linked with an application in a single address space

EMPRESS installation is embeddable into application installation procedure

Easy, straightforward and cost effective runtime licensing

 Choose from:  

  • royalty based
  • one-time fee
  • yearly subscription

Continuous product development, deployment and life cycle support

  • EMPRESS Software technical support team of knowledgeable database experts deliver high quality, timely support

     

High Performance Telecommunications and Networking Benchmark

EMPRESS Ultra Embedded users benefit from one of the fastest embedded real-time database engines in the industry. EMPRESS delivers high performance for the management of complex, large volumes of data. A benchmark designed by a large Telecommunications and Networking company, was conducted recently with EMPRESS Ultra Embedded. The benchmark application was specifically designed as a significant portion of the actual telecommunications application. Thus the benchmark can be considered to be very close to the final application and goes far beyond a simple generic database query benchmark.  The benchmark involved BGP, VRF and Interface data.

A short list of three database benchmark finalists were selected from an initial set of 26 database vendors. The benchmarks and detailed analysis of the three database finalists were run in parallel over an intensive six-month period. The final analysis revealed EMPRESS Ultra Embedded to be the clear #1 choice and best fit for embedded Telecommunications and Networking applications.

a.  Evaluation Criteria Summary

  1. Features: All relevant features of database tested including Create, Read, Update and Delete operations, transactions/isolation, granular locking etc.
  2. Performance: In-memory mode, disk mode, multiple transactions with concurrent operations, reading hierarchical information from tables
  3. Memory Footprint:  Static overhead of DB engine code, system tables etc. Dynamic overhead of DB growth: transactions, rollback logs etc.

b.  Test Environment

  1. PC w/Red Hat Enterprise Linux
  2. C Programming
  3. DB Native API
  4. No SQL
  5. DB: In-memory and disk mode

c.   Benchmark results (Time in Seconds)

Create Operation (whole configuration)          

No. Records

Mode

Top Competitor

EMPRESS

50K

In-mem

2.28

1.5

100K

In-mem

4.46

3.18

500K

In-mem

23.25

12.8

1M

In-mem

45.00

12.8

2M

In-mem

95.60

56.30

 

 

 

 

50K

Disk

4.65

2.15

100K

Disk

10.81

4.38

500K

Disk

73.43

17.9

1M

Disk

208.87

31.50

2M

Disk

777.32

63.80

 

 

 

 

 

 

 

Read Operation (bgp_neighbor table)             

No. Records

Mode

Top Competitor

EMPRESS

50K

In-mem

0.11

0.09

100K

In-mem

0.23

0.2

500K

In-mem

1.2

0.69

1M

In-mem

2.52

1.37

2M

In-mem

4.94

2.75

 

 

 

 

50K

Disk

0.21

0.09

100K

Disk

0.56

0.18

500K

Disk

8.59

0.71

1M

Disk

31.29

1.35

2M

Disk

123.25

2.67

 

Delete Operation (bgp and child tables)

No. Records

Mode

Top Competitor

EMPRESS

50K

In-mem

27.66

2.40

100K

In-mem

56.29

6.14

500K

In-mem

289.45

24.20

1M

In-mem

577.17

48.05

2M

In-mem

1128.81

101.77

 

 

 

 

50K

Disk

39.12

3.28

100K

Disk

88.73

7.94

500K

Disk

613.57

28.23

1M

Disk

1650.40

58.12

2M

Disk

4713.49

119.93

 

 

 

 

 

 

 

Read Operation (complete bgp instance)

No. Records

Mode

Top Competitor

EMPRESS

50K

In-mem

2.95

1.35

100K

In-mem

10.24

2.28

500K

In-mem

236.53

13.8

1M

In-mem

923.11

24

2M

In-mem

3569.66

90

 

 

 

 

50K

Disk

3.41

1.9

100K

Disk

10.82

4

500K

Disk

255.98

22

1M

Disk

1016.57

47

2M

Disk

3889.12

110

 

Read Operation (complete configuration)

No. Records

Mode

Top Competitor

EMPRESS

50K

In-mem

3.22

1.15

100K

In-mem

10.47

2.32

500K

In-mem

238

14.75

1M

In-mem

929

29

2M

In-mem

3586.63

143

 

 

 

 

50K

Disk

3.41

1.14

100K

Disk

10.86

2.32

500K

Disk

260

36

1M

Disk

1014.76

91.49

2M

Disk

3966.65

200.15

Memory Footprint Benchmark

 

Top Competitor

EMPRESS

1. DB Engine code size

~2 MB (full version)

~550 KB (light version)

~1 MB (full version)

2. Empty DB size (system tables)

440 KB

203 KB

Conclusions and EMPRESS Benefits

 

  1. EMPRESS ran 1.5 to 39 times faster than best competitor for create, delete and read operations
  2. EMPRESS has hierarchical join via native API. A frequently used operation in the application.
  3. EMPRESS has CASCADED DELETE feature. A frequently used operation in the application.
  4. EMPRESS has low per row overhead.
  5. EMPRESS has linear performance on large data.
  6. EMPRESS has configurable DB engine code size.

What Distinguishes EMPRESS for Telecommunications  & Networking

EMPRESS is known for its rich feature set, fast performance and small footprint.  For telecommunications and networking applications, there are additional key unique features that distinguish EMPRESS:

1.  Hierarchical Join

Data structures in telecommunications and networking applications are mostly hierarchical in nature. EMPRESS  “hierarchical-join” feature is used for hierarchical relationships among tables. This feature offers the potential for greater performance optimization as shown in benchmark read operations.

2.  Cascade Delete

EMPRESS Ultra Embedded provides native API cascade deletes.  This allows the deletion of all related information from multiple tables with one single delete operation.  In router and intelligent switch devices, routing information can be stored in a set of tables defined as routing schema. This routing schema is dynamic since certain devices on the network are re-configured or removed very frequently. Tables in routing schema are inter-related to each other.  In other words, tables that contain information about the routing nodes are related to tables that contain route maps associated with the nodes. With the EMPRESS Cascade Delete, deleting a record from the routing nodes can cause all associated records from route maps to be deleted.  The benchmark results show that EMPRESS Ultra Embedded is highly efficient with this type of operation.

3.  Transaction Span in Dealing with Database and Non-Database Operations

In telecommunications and network application, when the routing configuration is changed, the application has to enter/update new information into the routing tables. At the same time the actual reconfiguration activity on the device (non-database task) has to be performed. These two activities, a database task and a non-database task, must be done in atomic fashion, hence in the same transaction. EMPRESS native API provides the flexibility of allowing database transactions to span not only database tasks but also non-database tasks.

4.  EMPRESS and Application can Run in the Same Address Space

In Telecommunications and Networking applications, devices that are able to run an application in the same address space as the database have the advantage of:

  • Less memory consumption
    EMPRESS can be embedded in the same address space as the application.  In this environment, the EMPRESS footprint can be smaller than 1MB with full database functionality.  With client/server databases, there is the application, the client and the server. The server also may occupy much more memory.
  • Easy configuration
    With EMPRESS embedded in the application, there is only the application to configure. With client/server databases, there are 3 configurations (server configuration, client configuration and application configuration) to manage.
  • Single Point of Failure
    With EMPRESS embedded in the application, there is a potential single point of failure, the application.  With client/server databases, multiple potential points of failure (client, server, application) must be considered.
  • Decreased Complexity
    With EMPRESS embedded in the application, the system is much simpler to maintain.

In addition, EMPRESS has the flexibility to be configured as standalone (embedded in the application) or client/server as needed.

EMPRESS Applications in Telecommunications and Networking

EMPRESS Ultra Embedded has been embedded in many telecommunications and networking applications such as:

  • IP Telephony (VoIP) Systems
  • Voice Mail Tracking System
  • Enterprise Communication Server
  • Home Appliance Communication Server
  • Intelligent Routers
  • Intelligent Switches
  • Network Management Systems
  • Web-based Data and Network Management Systems

From companies such as Fujitsu, Lucent, Cisco, Intelliden, Matsushita, NTT-Com, Network Telco, etc.   

In these applications, EMPRESS Embedded Database is used to:

  • Collect and analyze data streams in real-time and store and transmit data from network and communications equipment such as phone systems, voice mail, routers and other equipment
  • Make the EMPRESS database engine and all its data entirely in memory for fastest data processing
  • Use EMPRESS User Defined Functions and User Defined Procedures to program devices automatically to deliver data and alarms to the local or remote data/control center
  • Define and store access and command level information in the database to securely communicate the devices via WAN, LAN or Web
  • Store statistics, usage data and events in EMPRESS databases and view the data with a Web browser

SUMMARY

EMPRESS Ultra Embedded delivers an unmatched combination of rich features, rich tools, rich data types and high performance that are well suited to the Telecommunications & Networking industry.  Unique features including hierarchical joins, cascade deletes, low-level interfaces, and single address space configuration solidify EMPRESS’ position as the leading database for telecommunications & networking products.

Reasons why EMPRESS Ultra Embedded is utilized in telecommunications and networking applications:

  • Rich toolset, rich data types and rich functionality for rapid development
  • Flexible and configurable for application optimization
  • Small footprint ideal for size constrained environments
  • Predictable performance
  • High reliability and consistency of data
  • Embeddable as a single unified program that is robust and efficient
  • Easy, straightforward and cost effective runtime licensing
  • Continuous product development, deployment and life cycle support

                       
                             
                         

Company
Information
GSA Contracts
Careers
Privacy Policy 
Contact US

Products
Empress RDBMS
Empress Servers
Empress API
Free Trial
 
Empress iPad Apps
 

Services
Consulting
Mobile Apps Development
Technical Support

Training Courses
Empress Extreme  

Partners
Distributors
Business Alliances
Partner Programs  
GSA Program
Distributors Program

Media 
Empress Markets
News and Events
Press releases
Technical News
Success Stories

        USA: 301-220-1919                 Canada & International:       905-513-8888         
Copyright © 2012              Empress Software Inc.           [email protected]           Join Empress Mailing List