Server and database access method

A database and server technology, applied in the database field, can solve the problem that non-relational databases cannot completely replace relational databases.

Active Publication Date: 2017-05-17
CHINA UNITED NETWORK COMM GRP CO LTD
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Operations on the database include query operations and non-query operations. Since non-relational databases are mainly suitable for query operations, non-relational databases cannot completely replace the functions of relational databases. However, access to relational databases requires the use of structure Access to non-relational databases requires the use of non-relational query languages. Therefore, it is necessary to consider how to meet high concurrent read and write, efficient storage and access to massive data, and high scalability while maintaining existing relational databases. and high availability requirements

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Server and database access method
  • Server and database access method
  • Server and database access method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Access to relational databases requires the use of structured query language SQL. The SQL statements used by different relational databases will have certain differences. Relational databases can be "added", "deleted", "modified" and / or "Query" and other operations; when accessing non-relational databases, you cannot directly use SQL for access. Instead, you need to use an unstructured query language, and you can perform "query" operations on non-relational databases. The server provided by each embodiment of the present invention constructs a heterogeneous database unified service PaaS platform, and the PaaS platform supports both a relational database and a non-relational database. The meaning of PaaS is Platform as a Service (Platform as a Service). Through the PaaS platform in the server, the operation of querying non-relational databases using SQL is realized. The servers described in the following embodiments are the servers on which the PaaS platform is construct...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a server and a database access method. The server comprises a receiving module, an access rule routing module, a semantic translation module and a connection protocol fitting module. The receiving module is used for receiving a first access statement; the access rule routing module is used for acquiring a first operating command and data-table identification information both carried in the first access statement, and judging whether or not data in a data table corresponding to the identification information is extracted into a non-relational database when the first operating command is an operation capable of being performed by the non-relational database; the semantic translation module is used for determining the non-relational database as a target non-relational database and translating the first operating command into a second operating command capable of being analyzed by the target non-relational database when the data in the data table corresponding to the identification information is extracted into the non-relational database is judged; the connection protocol fitting module is used for sending the second operating command and the data-table identification information to the target non-relational database. According to the server and the database access method, requirements on high-concurrency database read-write and the like are met by the non-relational database.

Description

Technical field [0001] The invention relates to database technology, in particular to a server and a database access method. Background technique [0002] With the rise of web 2.0 websites on the Internet, the data query requirements for super-large-scale and highly concurrent social network services (Social Networking Services, SNS) type web 2.0 purely dynamic websites have also increased accordingly. [0003] A relational database is a database based on a relational model. It uses Structured Query Language (SQL) to perform retrieval and operation of data in the relational database. Tables in relational databases store some formatted data structures. The composition of each tuple field is the same. Even if not every tuple requires all fields, the database will assign all fields to each tuple. This structure can facilitate operations such as connection between tables, but it limits the performance of relational databases. The relational database used in the prior art can no longe...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/2308G06F16/252
Inventor 郭志斌李卫张云勇
Owner CHINA UNITED NETWORK COMM GRP CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products