USAY Database Series
USAY Relational Database
USAY DB is a high-performance, high-reliable universal relational database products.
product development based on open source database PostgreSQL, combined with the actual needs of the domestic database market, in the function, performance and security of the three dimensions of a large number of development and testing. The database product supports multiple platforms, has rich and easy-to-use management tools, is powerful, and meets the needs of database transaction processing, spatial data processing and database replacement in various industries.
Product Overview
Architecture
A good architecture is the foundation of an excellent database product, and USAY DB’s architecture is similar to Oracle’s, consisting of five management modules.
Product Characteristics
As a basic software, in order to ensure the good operation of the production system in the information system, USAY database products have seven enterprise-level characteristics, namely: high performance, high security, light operation and maintenance, independent control, universal, ease of use, and high reliability.
Download
Documentation
Features of the Function
- Spatial data processing – USAY DB provides powerful spatial data processing capabilities through the inline spatial database component, including support for almost all spatial data types, operation functions, and operators, and provides excellent spatial indexing to accelerate query performance for spatial data. By using the USAY DB’s spatial database component, you can easily implement grid/vector analysis, sphere length operations, database coordinate transformation, topology model processing, and more. In smart cities, transportation, policing, environment, water conservancy, electricity, meteorology, emergency, logistics and other fields, you can quickly use USAY DB’s space components for the calculation and analysis of spatial data.
- External table – In the process of database application of some large organizations and organizations, there are often times when heterogeneous data sources are particularly large and their respective versions are particularly many, and it is difficult to do data manipulation quickly and easily in these heterogeneous data sources. In this case, USAY DB provides powerful external table functionality that provides easy and efficient access to data from these heterogeneous data sources. Features:
- Supports the creation of external table constrains.
- The optimizer supports external table queries to push down.
- External tables support inheritance.
- Supports import foreign schema one-click creation of external table analysis operations.
- NoSQL support – In the era of large data and Internet plus, traditional customers are facing more and more and more urgent need stoating Internet applications, but also need to effectively process unstructured data. However, the NoSQL architecture is widely used in Internet applications to complete the data processing of these requirements. SQL operations are fundamental to enterprise users and application software developers who are accustomed to using relational databases, developers are not used to syntax other than SQL, and system-demanding ACID associations are not available from NoSQL systems. In particular, many systems have been continuously developed and integrated for 3 or even 5 years, but due to the current need to dock the Internet, it is often necessary to rebuild the NoSQL system for business development, with significant investment and slow progress. USAY DB can easily manage unstructured data in relational databases with its own json and jsonb data processing capabilities, and the whole process is as easy as manipulating redis in SQL. Reduce development and quickly bring new systems online.
USAY Analytics Database
Product Overview
USAY ADB can help users solve the challenges of databases as follows: ” When database performance is experiencing problems, it is possible to scale out and achieve higher throughput by adding servers to take advantage of existing hardware for a better ROI.” Whether the scale-out of the database is transparent to the application, and if the scale-out of the database requires a lot of modifications on the application side, the consequences are not only high development costs, but also many potential and non-potential risks. Whether you have a copy of real-time synchronization, and when the database is in the event of a disaster, the availability of the database can be guaranteed by fail over for a short period of time. In addition, when data is lost or corrupted, the loss of data can be achieved through so-called real-time replicas (hot-prepared).
Download
Documentation
Architecture
Module Composition
- Data node – the USAY ADB data node consists of two parts: the data resolution engine and the data storage engine.Resolution engine – receives the SQL that the client has incoming, converts the SQL into an object tree, and then submits the object tree to the file engine. File engine – reads and writes data files based on the object tree passed in from the resolution engine, combining the resulting data to the client. From the storage method, USAY file engine supports column storage, row storage, ZIP compressed storage.
- Coordination node – The coordination node is the interface between the data node and the application, the coordination node does not physically store the table data, the coordination node accepts the instructions of the application, and the data of the data node is distributed or aggregated by operation. When an application initiates an SQL statement, it first reaches the coordination node, which then distributes the SQL statement to each data node and summarizes the data. MPP uses a fully peer-to-peer, non-shared architecture, with each database server called a node, each node being a separate database. Each node functions exactly the same, each node is deployed on a separate host, and the user can do so by connecting to any one node. The data node sites table data physically, and the data of the same table can be distributed among different nodes, and the result set is merged by data-driven or coordinated nodes.
USAY Spatial Database
Product Overview
At present, due to the advantages of rapid access to the “relational database and spatial data engine” and close contact with GIS, the spatial data engine occupies certain advantages in the application, but the spatial data engine is independent of the database kernel, it is difficult to make full use of all kinds of mature data management and access technology in the relational database, which becomes the Achilles heel of further development. In addition, it is difficult to support the expansion of SQL, not easy to implement data sharing and interoperability and other issues are gradually exposed. USAY, in order to adapt to the needs of the times, combined with years of experience in database research and development, the successful development of fully independent intellectual property rights of the USAY SpatiaL DB, so that the perfect combination of spatial database and relational database, so that enterprises in the era of big data seize business opportunities, looking to the future. is an extension of USAY DB, an object-relational database system, and follows the specifications of OpenGIS.
Download
Documentation
Technical Indicators
Vector spatial datatypes suppported
- Point (POINT)
- Line
- STRING Polygon (POLYGON)
- Multipoint (MULTI_POINT)
- Multi-line (MULTI_LINESTRING)
- Polygon Collection (MULTI_POLYGON)
- Collection object set (GEOMETRY_COLLECTION)
Types on indices supported
The B-tree index is mainly used for sequential one-dimensional data, with fewer applications on USAY Spatial DB for storage of space data. The R-tree index divides the data into rectangles, subrectangles, and subrectangles, which are suitable for indexing two-dimensional spatial data. The GiST index is a balanced, tree-shaped approach to access that divides data into general, overlapping, and internal data, and enables multiple index patterns in the underlying template.
USAY File Database
Product Overview
Document management is getting more and more attention from enterprises, but in the process of document management, enterprises often encounter the following problems: massive document storage, management difficulties; Therefore, document management has gradually become a hot topic of research in the industry at home and abroad. is specifically designed for big data analysis applications, management of enterprise’s diversified data, help enterprises to file and relationship attributes unified management, USAY FDB has high security, high speed, easy to use, easy to maintain, low cost and so on, not only can be applied to government departments and large enterprises, but also can be applied to the vast number of small and medium-sized enterprises, so that data into wealth become simply accessible. In particular, USAY FDB, all source code is auto generated, in the basic database field to take the lead in the realization of localization, technology is completely safe and controllable, can provide convenient and efficient customized services.
USAY File Database Cloud Platform
USAY FDB cloud platform is a software system by USAY to manage the massive and diversified data of enterprises, solve the root causes of document dispersion and uncontrollable document delivery, help enterprises build a centralized massive document management platform, unify the file and relationship attributes, and manage the document son-in-law.
Classification management – Standardized organization classification, according to the characteristics of the enterprise custom document metadata, tree-shaped directory structure, hierarchy, custom labels, attribute classification, according to the needs of the enterprise, self-defined.
Full text search – efficient full text search, conditional combination search, quickly find the required documents, zero copy generation, so that you can quickly get the right document. USAY FDB implements full-text indexing of files such as commonly used PDFs, Word, Excel, PPT, Txt, html, etc., enabling HDFS-based Lucene index storage, ensuring the security of index data, and automatically segmenting Lucene index data, managed by multiple servers. When full-text retrieval, multiple servers retrieve index segments in parallel, which improves query efficiency.
Download
Documentation
Core Technology Characteristics
USAY file database supports rich data types, and in addition to regular data types, character types, and date types, it supports more extended and personalized data types.
Cross-platform Architecture
USAY FDB is implemented in pure Java code and has the following advantages: It can be run on both commercial X86 architecture and domestic chip architectures; “Write once, run multiple times” without cross-platform compilation, you can support a variety of operating systems; provide sized core security at the basic software level that you can rely on.
Distributed Structure
The underlying storage of the Henghui file database uses Hadoop’s Distributed File System (HDFS), a typical shareless (Share) architecture that ensures high availability of the data storage tier while improving storage performance.
Diversified Data Management
USAY FDB aids enterprises in the management of diversified data. Unstructured content that cannot be expressed in terms of the ranks of the database structure. The Forms of unstructured content: documents, mail, reports, web pages, XML, sound, images, multimedia images, scanned files, drawings, recordings, presentations, etc…
File Version Management
USAY FDB has a powerful version management system. Each time a file is modified, a new version of the file is uploaded, as an independent file. This results in many historical versions. The latest version of the file is displayed, and all older versions can are visible.