- Research Article
28
- 10.1016/0306-4573(88)90101-x
An extended relational document retrieval model
- Jan 01, 1988
- Information Processing & Management
- David C Blair
An extended relational document retrieval model
A relational data base management system (named DMC) designed to provide administrative software with a high level view of an Electronic Switching System (ESS) database is described. DMC is primarily designed for the No. 4 ESS, a toll switching system, but its design concepts and requirements are, also applicable to other Electronic Switching Systems. A unique feature of DMC is its ability to access pre-defined physical data structures, thus providing a data independent interface to application programs. DMC provides many capabilities not commonly found in existing systems. Included in these are transaction oriented processing, flexible physical to logical level mappings, automatic enforcement of user definable integrity constraints, and automatic invocation of generalized triggers.
An extended relational document retrieval model
An extended relational document retrieval model
JSON data management
Relational Database Management Systems (RDBMS) have been very successful at managing structured data with well-defined schemas. Despite this, relational systems are generally not the first choice for management of data where schemas are not pre-defined or must be flexible in the face of variations and changes. Instead, No-SQL database systems supporting JSON are often selected to provide persistence to such applications. JSON is a light-weight and flexible semi-structured data format supporting constructs common in most programming languages. In this paper, we analyze the way in which requirements differ between management of relational data and management of JSON data. We present three architectural principles that facilitate a schema-less development style within an RDBMS so that RDBMS users can store, query, and index JSON data without requiring schemas. We show how these three principles can be applied to industry-leading RDBMS platforms, such as the Oracle RDBMS Server, with relatively little effort. Consequently, an RDBMS can unify the management of both relational data and JSON data in one platform and use SQL with an embedded JSON path language as a single declarative language to query both relational data and JSON data. This SQL/JSON approach offers significant benefits to application developers as they can use one product to manage both relational data and semi-structured flexible schema data.
Read moreWhich Category Is Better: Benchmarking the RDBMSs and GDBMSs
Relational database management systems (RDBMSs) have been a common option to manage structured data over the past decades. In recent years, with the prevalence of big data applications, vast unstructured and semi-structured data are generated, deeply challenging the relational model used in RDBMSs. For this reason, a wide spectrum of NoSQL databases are developed for managing unstructured, semi-structured or structured data. For example, graph database management systems (GDBMSs) are commonly used as an important category of NoSQL databases, to manage sophisticated graph data as well as relational data. Nonetheless, as claimed in existing literatures, both RDBMSs and GDBMSs are capable of managing graph data and relational data, the boundaries of them still remain unclear. In this paper, we propose a unified benchmark for RDBMSs and GDBMSs, to evaluate them under the same metrics, and report which category is better in different application scenarios. We conduct extensive experiments over the unified benchmark, and report our findings: (1) RDBMSs are significantly faster for aggregations and order by operations, (2) GDBMSs are shown to be superior for projection, multi-table join and deep recursive operations, (3) GDBMSs and RDBMSs are comparable for two-table join and shallow recursive operations.
Read moreThe Loop Range Extension (LRE) Feature in Electronic Switching Systems (ESS)
The loop range extension (LRE) feature refers to electronic switching system (ESS) modifications required to implement concentrated range extension with gain, which involves the integration of switching and transmission technologies in the Central Office. This paper describes the interfaces between the LRE feature and Nos. 1/1A and 2/2B ESS's; it provides a brief description of the ESS networks and details the hardware connections and software processes required for LRE functions. Also provided are network administration considerations required in support of the feature.
Read moreReal-Time Testing of Automatic Overload Control Systems in a Laboratory Environment
In order to investigate overload control strategies for large electronic switching systems (ESS), it is extremely valuable to be able to load test actual switching machines in a controlled laboratory environment. This method is superior when compared to both testing actual machines in service (where service deterioration cannot be tolerated) and simulating test of virtual machines (where sufficient realism may not be attainable). In the past, this form of experimentation has not been feasible for large ESS's because of both technical and economic problems associated with existing methods of generating the high volume of traffic required for overload testing. With the advent of the real-time traffic simulator known as the programmed electronic traffic simulator (PETS), however, it has become practical to conduct real-time tests of on-line overload control systems. PETS has been utilized to perform overload control experiments on an ESS to demonstrate the feasibility of conducting controlledenvironment overload testing on an actual ESS. It is the intent of this paper to describe the methodology used in the simulation experiments conducted and summarize some of the simulation results. In particular, the results of the three overload control systems will be compared with respect to both the total number of calls completed within a specified period of time and the grade of service provided. The sensitivity of system performance to the peakedness factor of the offered traffic will also be presented.
Read moreIntermedia: A case study of the differences between relational and object-oriented database systems
This paper compares two approaches to meeting the data handling requirements of Intermedia, a hypermedia system developed at the Institute for Research in Information and Scholarship at Brown University. Intermedia, though written using an object-oriented programming language, relies on a traditional relational database management system for data storage and retrieval. We examine the ramifications of replacing the relational database with an object-oriented database. We begin by describing the important characteristics each database system. We then describe Intermedia and give an overview of its architecture and its data handling requirements. We explain why and how we used a relational database management system and the problems that we encountered with this system. We then present the design of an object-oriented database schema for Intermedia and compare the relational and object-oriented database management system approaches.
Read moreA Microprocessor Operating System for Real-Time Applications
A real-time microprocessor operating system for the 10A RSS (Remote Switching System) is described. An RSS consists of a MAC-8 microprocessor controlled Remote Terminal connected via a transmission medium to a host ESS (Electronic Switching System). The operating system design was influenced by the stack nature of the MAC-8 and the stack usuage conventions of the high-level C language compiler. A memory bank switching scheme was also incorporated to increase the address space of the MAC-8. The operating system approach fit very nicely into the top-down software design methodology used in RSS. Where possible dedicated stacks within process descriptors helped to preserve process origanizaton and structure at code level. Supporting processes in a structured fashion required significant amounts of memory since process descriptors were from 10 to 100 times larger than earlier systems. However, background processes required less memory to support than real-time processes because the number of concurrent background processes could be more easily limited.
Read more4.3 - Introduction to Data Vault Architecture
4.3 - Introduction to Data Vault Architecture
Modernization of the Suburban ESS: Adding Data Links to an Existing ESS
As a major modernizing improvement data links for three important functions have been added to the 2B Electronic Switching System (ESS). The data-link system was designed with a layered architecture using an enhanced subset of the X.25 protocol. Levels 1 and 2 of the protocol are implemented in the hardware and software of a new device, the Serial Peripheral Unit Controller/Data Link (SPUC/DL). Within the SPUC/DL itself, check circuitry and software are used for error detection. A second SPUC/DL for each critical application provides redundancy on either a dedicated or dial-up basis. An elaborate diagnostic program within the 2B ESS can be invoked automatically or manually. This paper discusses some of the issues in retrofitting the BX.25 protocol to pre-X.25-speaking machines.
Read morePerformance Metrics for Decision Support in Big Data vs. Traditional RDBMS Tools & Technologies
In IT industry research communities and data scientists have observed that Big Data has challenged the legacy of solutions. ‘Big Data’ term used for any collection of data or data sets which is so large and complex and difficult to process and manage using traditional data processing applications and existing Relational Data Base Management Systems (RDBMSs). In Big Data; the most important challenges include analysis, capture, curation, search, sharing, storage, transfer, visualization and privacy. As the data increases in various dimensions with various features like structured, semi structured and unstructured with high velocity, high volume and high variety; the RDBMSs face another fold of challenges to be studied and analyzed. Due to the aforesaid limitations of RDBMSs, data scientists and information managers forced to rethink about alternative solutions for handling such data with 3Vs.Initially research study focused on to develop an intelligent base for decision makers so that alternative solutions for long term suitable solutions and handle the data and information with 3Vs can be designed. In this research attempts has been made to analyze the feature based capabilities of RDBMSs and then performance experimentation, observation and analysis has been done with Big Data handling tools and technologies. The features considered for scientific observation and analysis were resource consumption, execution time, on demand scalability, maximum data size, structure of the data, data visualization, and ease of deployment, cost and security. Finally the research provides a decision support metrics for decision makers in selecting the appropriate tool or technology based on the nature of data to be handled in the target organizations.
Read moreOptimal pumping scheduling for municipal water storage systems
In this paper, bulk water abstractions and a purification process in terms of water pumped energy consumption, is modelled and simulated. The study proposes an optimal energy consumption-rate management system, using real-time data. The aim is to achieve the goal of obtaining potable water by scheduling the pumping process, to obtain the cheapest energy-rate at any given load demand. Considering the loss due to the effect of evaporation, the effect of precipitation (or rainfall) and seepage losses.As a baseline, an electronic timer switching system for the powering of electrical pumps, used to pump water from one level to another, is incorporated. An optimal control system is included that looks at the energy cost before scheduling the pumping sequence in such a way that pumping occurs during the more affordable energy costing period and ensures that the water demand from consumers matches the water pump level in the storage reservoir.The configuration involved the time of use (TOU) tariff; in the context of the South African electricity tariff. The optimal control output, compared to an electronic timer switching system, shows an end-of-day cost reduction of 1994 ZAR in water-pumped energy consumption from the grid. This reduction in energy consumption is therefore a direct reflection of the reduction in the cost of water supply to consumers.
Read moreMulti-log/sub 2/N self-routing networks and their applications in high speed electronic and photonic switching systems
A novel class of switching networks has been proposed to remove the time and space bottlenecks in conventional RAM-controlled switching architectures. The proposed networks possess many desirable characteristics for high-speed electronic and photonic switching systems, such as tolerance of faults, O(log/sub 2/N) stages between each inlet-outlet pair, self-routing capability, easy path hunt and easy fault diagnosis. Graph theory provides the basis for the proposed networks. It is shown that the key problem in the construction of this class of networks is related to the coloring problem in graph theory. >
Read moreAdministration and Maintenance Plan
The No. 2 Electronic Switching System has been planned with dependability, maintainability, and operational ease representing a major portion of the total system design concept. The major characteristics that fall under these headings are redundancy, trouble detection, trouble recovery, diagnosis, repair, man-machine interface, data protection, and operational and administrative procedures for growth and change. All these factors play a large role in both the hardware and software portions of the system design. This article reviews the highlights in each of these areas and describes how they interact in the overall system across both the control complex and peripheral system areas.
Read moreMaintenance Techniques of a Microprogrammed Self-Checking Control Complex of an Electronic Switching System
This paper describes the various fault detection, routine exercise, and diagnostic techniques used in the design of a switching complex. Unlike other electronic switching system (ESS) processors, the processor is entirely self-checking.
Read moreTranslations in the No. 1 Electronic Switching System
Translations are the means of storing and retrieving office and customer information in a No. 1 electronic switching system installation. The translation scheme must be sufficiently general to handle special telephone services in addition to the items stored as cross connections in present telephone systems. The categories of translation information, the techniques of storage, the means for specifying translation data, and means for making changes therein, are described in this article.
Read more