CN106951476A - Race informix processing system based on the network communications technology - Google Patents
Race informix processing system based on the network communications technology Download PDFInfo
- Publication number
- CN106951476A CN106951476A CN201710131949.9A CN201710131949A CN106951476A CN 106951476 A CN106951476 A CN 106951476A CN 201710131949 A CN201710131949 A CN 201710131949A CN 106951476 A CN106951476 A CN 106951476A
- Authority
- CN
- China
- Prior art keywords
- data
- json
- race
- information
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/50—Network services
- H04L67/55—Push-based network services
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses the race informix processing system based on the network communications technology, race information acquisition module gathers the real-time achievement data of contest of all individual events and generates JSON files, and race message processing module is uploaded to by data switching center according to FTP communication protocols；The race message processing module receives and the real-time achievement data file of contest is stored in into file server after competition Information data file, and by the JSON document analysis related to integrated data in data object write into Databasce server, the race information issuing module obtains the real-time achievement data of contest by http protocol to file server, integrated data is obtained to database server, and the information of acquisition is shown according to business rule.The present invention realizes the collection to all individual event competition Informations of comprehensive competitive sports, storage, statistics and distribution function, realizes the accuracy of data acquisition and distribution, simplifies processing system structure, improve treatment effeciency.
Description
Technical field
The present invention relates to race informix processing system, the race informix more particularly to based on the network communications technology
Processing system.
Background technology
With expanding economy and the promotion of society, it is living that large-scale synthesis competitive sports have become an important society
It is dynamic.The comprehensive competitive sports of early stage are as simple sports, using relatively simple traditional timing and score keeping mode, expend
More time and manpower, accuracy and efficiency than relatively low, it is desirable to there is a set of efficient system, on the one hand can all be saved
The step such as human metering and artificial calculating, improves accuracy, work on the other hand can be completed in an efficient way, accelerate match
Rhythm, makes the pace of the game compacter, more ornamental.Due to the appearance of above demand, simultaneous global IT application journey
Subsist cumulative length, comprehensive competitive sports system it is increasingly ripe and perfect, the comprehensive competitive sports information of complete set is comprehensive
Close processing system to arise at the historic moment, accurate efficient service is provided for comprehensive competitive sports.
Race informix processing system is developed so far, however it remains some problems, although computer technology and network
The problem of development of the communication technology make it that system is gradually improved, but still old new is exposed, and solving these problems could cause
Race informix processing system preferably serves large-scale synthesis competitive sports, is the committed step of propulsion system development.It is main
The problem of existing has the following aspects：First, while the feelings easily blocked when handling the request of data of multiple users
Condition；Second, because the data storage and transformat resolution speed taken are slower so that whole system efficiency compares relatively low；
3rd, data are uploaded directly into message processing module without verification and are stored and counted, easily because of the mistake of source data
Series of negative is caused to influence；4th, the means of information issue compare limitation so that a part of user is carried out to relevant information
It is restricted during acquisition, it is very inconvenient.5th, because the systemic-function is more, total system is huge and complicated, cost compared with
It is high.
The content of the invention
Purpose：In order to overcome the above not enough, a kind of information of present invention offer is timely, abundant in content, data are accurate, issue is wide
The general race informix processing system based on the network communications technology, for gathering and counting from the competing of all individual events
Data, issue schedule and result are matched, to sportsman, coach, race officials, staff and news media or even society
Can more, thinner, the more convenient race information service of public's offer.
Technical scheme is as follows：
Race informix processing system based on the network communications technology, including race information acquisition module, race information
Processing module and race information issuing module, wherein,
The race information acquisition module gathers the real-time achievement data of contest of all individual events and generates JSON files, according to
FTP communication protocols are uploaded to race message processing module by data switching center；
The race message processing module receives and be stored in the real-time achievement data file of contest after competition Information data file
File server, and be the number that data object writes race message processing module by the JSON document analysis related to integrated data
Integrated data is inquired about according to other modules in the server of storehouse, are facilitated；
The race information issuing module by file server requests from http protocol to race message processing module simultaneously
The real-time achievement data of contest is obtained, integrated data is obtained to database server, and the information of acquisition is entered according to business rule
Row displaying.
Preferably, the medium that the race information acquisition module is transmitted using JSON files as data storage, passes through scene
The real-time achievement sequence of each contest individual event is turned to JSON character strings by Ethernet, is write after being verified by data checking mechanisms
JSON files, the JSON files are uploaded to the file server of race message processing module by data switching center.
Preferably, the race message processing module includes information Store submodule and Information Statistics submodule, wherein,
Described information sub-module stored includes file server, for storing the contest real time data received, when race letter
Cease release module to contest real time data initiate inquire about when, can directly from file server by corresponding JSON file downloads to
Client is parsed；
Described information statistic submodule includes database server, for storing Integrated Services Digital, from file server
Middle reading JSON files, write data into database server, and statistic for receiver medal and integration information write into Databasce clothes
It is engaged in device, when race information issuing module is initiated to inquire about, query SQL sentence example is sent to database server and looked into
Ask and the data of return are generated into JSON character strings, send to race information issuing module and enter row information issue displaying.
Preferably, the race information issuing module is based on B/S frameworks, using jQuery frameworks, passes through asynchronous AJAX
Method obtains data needed for information issues the page from race message processing module, and is issued information using unified data structure
To official website, client and third party website.
Preferably, the data checking mechanisms are that progress of the JSON SCHEMA to JSON files is used under .NET platforms
Verification, end is handled by the event JSON SCHEMA the being pre-created on-site scores for being stored in the project race information acquisition module,
And each event needs the JSON file types uploaded to create JSON SCHEMA according to the event, each type file is created only
One JSON SCHEMA, its verification mode is as follows：
5a) when data sequence is turned to JSON character strings by race information acquisition module and not yet writes JSON files, lead to
Cross passed parameter and locally finding corresponding JSON SCHEMA files, corresponding JSON SCHEMA files are read in internal memory；
A JsonSchemaFactory reality 5b) is created by Default () method of JsonSchemaFactory classes
Example；
It is 5c) using fromString () method of JsonLoader classes, JSON character strings is incoming as parameter, obtain
The JsonNode objects of JSON data；
5d) using fromString () method of JsonLoader classes, the JSON SCHEMA frameworks in internal memory are regard as ginseng
Number is incoming, obtains JsonSchema JsonNode objects；
5e) in 5b) in JsonSchemaFactory examples incoming JSON is passed through using getJsonSchema () method
SCHEMA JsonNode objects produce the JsonSchema objects of instantiation；
5f) instantiation JsonSchema objects are gone by the JsonNode objects of the incoming JSON data of validata () method
Whether checking JSON character strings meet JSON SCHEMA frameworks；
5g) when isSuccess () method return value is 1 in the JsonSchema objects of return, it was demonstrated that the JSON characters
String meets JSON SCHEMA frameworks, into 5h), otherwise into 5i)；
5h) now the JSON character strings of serializing are stored in newly-built JSON files, complete and correct JSON files
Downward previous module is transmitted, and terminates verification；
5i) return and check whether source data is correct, regenerates new JSON, returns to 5a) verify again.
Preferably, the data switching center includes data distribution module and Configuration Manager, wherein,
The data distribution module provides request and serviced with the reception of data, caching and distribution, and data receiver thread is received
It is parsed during to packet, parsing confirms that its legal and message header identifies the data and needs forwarding, calculates the word of data
Joint number, opens up the space more than byte number as Buffer, then the data is added into Buffer buffering queues, data transmission line
Data in Buffer are written to receiving terminal by receiving terminal in journey traversal SessionList in the way of first in first out.
Data switching center is managed for configuration the Configuration Manager, including basic data management and messaging parameter
Storage communication terminal, data type, message route three tables in configuration, configuration management database, for data switching center
Parameter needed for configuration is managed, and pre-games is united according to contest business demand write-in data by team of Technical Operations Center
One management and maintenance.
Beneficial effects of the present invention：The present invention provides the race informix processing system based on the network communications technology, should
With correlation techniques such as the network communications technology .NET technologies, data storage access techniques, with reference to Object-Oriented Design thought, realize
To the collections of all individual event competition Informations of comprehensive competitive sports, storage, statistics and distribution function, realize data acquisition and
The accuracy of distribution, simplifies processing system structure, improves treatment effeciency.
Brief description of the drawings
Fig. 1 is main structure chart of the invention；
Fig. 2 is race information acquisition module fundamental diagram；
Fig. 3 is race message processing module fundamental diagram；
Fig. 4 is Information Statistics submodule design principle figure；
Fig. 5 is the race information issue request of data flow chart based on AJAX；
Fig. 6 is JSON SCHEMA checking process figures；
Fig. 7 is data switching center's workflow diagram.
Embodiment
In order that those skilled in the art more fully understand the technical scheme in the application, it is real below in conjunction with the application
The accompanying drawing in example is applied, the technical scheme in the embodiment of the present application is clearly and completely described, it is clear that described implementation
Example only some embodiments of the present application, rather than whole embodiments.Based on the embodiment in the application, this area is common
The every other embodiment that technical staff is obtained under the premise of creative work is not made, should all belong to the application protection
Scope.
As shown in figs. 1-7, the race informix processing system based on the network communications technology, including race information gathering mould
Block, race message processing module and race information issuing module, wherein,
The race information acquisition module gathers the real-time achievement data of contest of all individual events and generates JSON files, according to
FTP communication protocols are uploaded to race message processing module by data switching center；
The race message processing module receives and be stored in the real-time achievement data file of contest after competition Information data file
File server, and be the number that data object writes race message processing module by the JSON document analysis related to integrated data
Integrated data is inquired about according to other modules in the server of storehouse, are facilitated；
The race information issuing module by file server requests from http protocol to race message processing module simultaneously
The real-time achievement data of contest is obtained, integrated data is obtained to database server, and the information of acquisition is entered according to business rule
Row displaying.
Preferably, the medium that the race information acquisition module is transmitted using JSON files as data storage, passes through scene
The real-time achievement sequence of each contest individual event is turned to JSON character strings by Ethernet, is write after being verified by data checking mechanisms
JSON files, the JSON files are uploaded to the file server of race message processing module by data switching center.
As shown in Fig. 2 the information gathering principle of race information acquisition module is as follows：
The information of race information acquisition module is initially obtained by timing and score keeping equipment (end), and Games-time marking equipment is transferred to when value
Judge is used, and achievement data is sent to by the timing and score keeping equipment in each place by wireless aps or interchanger in wired mode
Timing and score keeping end, data are packaged and sent to on-site score by timing and score keeping end according to UDP message packets handles end, scene
Achievement handles end and initial estimate is carried out to fraction according to the individual event rules of contest and is write in venue DBMS storehouse；In end of match or
Some special time nodes, handle end by on-site score and read data from venue DBMS storehouse, data sequence is turned to
JSON character strings, are verified, school under .NET platforms using JSON SCHEMA to the integrality and correctness of serialized data
Data are with the Form generation JSON files of JSON character strings after the completion of testing, and are uploaded to data file by data switching center
Race message processing module is counted, by carrier of JSON files by racing data according to sport, stage, unit and type
Classification is transferred to race message processing module, it is easy to accomplish the Classification Management of data, while ensureing number by information checking mechanism
According to accuracy.
Preferably, the race message processing module includes information Store submodule and Information Statistics submodule, wherein,
Described information sub-module stored includes file server, for storing the contest real time data received, when race letter
Cease release module to contest real time data initiate inquire about when, can directly from file server by corresponding JSON file downloads to
Client is parsed；
Described information statistic submodule includes database server, for storing Integrated Services Digital, from file server
Middle reading JSON files, write data into database server, and statistic for receiver medal and integration information write into Databasce clothes
It is engaged in device, when race information issuing module is initiated to inquire about, query SQL sentence example is sent to database server and looked into
Ask and the data of return are generated into JSON character strings, send to race information issuing module and enter row information issue displaying.
As shown in figure 3, race message processing module design principle is as follows：
The design of information Store submodule mainly includes：File server deployment, information Store and information Store update, institute
It is a computer being responsible for centralized storage and data file management to state file server, for storing venue level JSON data
File, enjoys fixed IP and port numbers, manager creates domain controller on file server by file server, strict control
The identity of the computer of access server, creates user account and distributes authority for user, pass through explorer and its file
Filter assemblies limitation read-write user be only capable of uploading JSON files, and cloned by the volume of file server and volume shadow copy function come
Backup-and-restore data.To improve file access speed, file server is set not respectively according to the common code of each individual event
Same path, stores the real-time achievement file of disparity items contest in the form of multiple files.Such design reduces single road
Quantity of documents under footpath, so as to reduce the time of ff.Each individual event venue achievement processing end of race information acquisition module
The files passe path of its fixation is pre-configured with, Games-time generation carries the JSON files of timestamp, and file is with " sport public generation
Code _ small item code _ contest stage _ contest play _ achievement type " name, by contest private network and data switching center, according to
File Transfer Protocol uploads the real-time achievement file of contest to the file server of race information Store submodule.When race information issues mould
When block needs file, directly obtained by file path.Each JSON files include a timestamp, race information gathering
Module need update with project with the stage with play games results file when, only need to produce a new JSON file and upload
, this document comprising update data and new timestamp, race information issuing module user initiate again inquiry when, first
The timestamp of documents is needed, if timestamp does not update, is not required to download JSON files again, if update of time stamp,
Then need to download new data file to the old JSON files locally and before overriding.
As shown in figure 4, Information Statistics submodule mainly includes data base management system and database server, wherein, institute
Stating data base management system is used to deposit backstage management procedure and database operating parameter SQL statement, the database service
Device is used to deposit all Integrated Services Digitals.When the file server of race message processing module receives achievement type for medal
During the JSON files of information and record information type, data base management system backstage management procedure is triggered, and flag is set to 1 table
It is bright to receive data or update the data, it is necessary to database server operation be carried out, while file store path is transmitted as parameter
To backstage management procedure, the file path that program is come according to transmission loads file, and data are obtained according to JSON attribute nodes
The parameter of storehouse operation, and parameter value is transmitted to corresponding parametrization SQL statement generated data storehouse action statement example, to database
Server is write or updated operation.This process can ensure that the data of data place storage are all latest datas.
The present invention is used as data base management system, under .NET platforms, data access from the R2 of SQL Server 2008
Based on the ADO.Net technologies under the framework.ADO.Net is the face for being used to interact with data source provided by Microsoft
To classes lib, there is provided Connection, Command, DataReader, DataAdapter and DataSet this five are main
Class be used for database is attached, control, read, change and access renewal etc. access operate.The technical support connect with
Two kinds of environment are disconnected, when the data to database enter edlin, it may not be necessary to lasting connection status is kept, so as to save net
Network resource.
Data base management system system deployment uses two-node cluster hot backup mode, while listening for two database servers, once
There is state of paralysis and is then switched to standby database at once continuing to run with primary database, it is to avoid contest accident occur.
Preferably, the race information issuing module is based on B/S frameworks, using jQuery frameworks, passes through asynchronous AJAX
Method obtains data needed for information issues the page from race message processing module, and is issued information using unified data structure
To official website, client and third party website.
As shown in figure 5, the race information issuing module design principle is as follows:
The issue of race information initiates inquiry and right by information issue client terminal (official website, third party website, mobile APP)
As a result it is shown, the displaying of information issue is made up of two key elements：Information issues template and information issue data, wherein,
Described information, which issues template and issues developer according to information by information, issues demand, design suitable for official website or
The page style template that various terminals are browsed, is stored in terminal local, and the information for obtaining this domain or foreign lands by above-mentioned design is sent out
JSON data are simultaneously resolved to object by cloth data, and the information for obtaining this domain by JavaScript scripts issues template, by data
Object, which inserts template and can just obtain user, looks into the page, realizes static page mobilism, race information is issued.
User initiates Web request by information issue client terminal, and the parameters such as the date of required data, type are sent into match
Thing information issuing module, race information issuing module initiates AJAX request according to parameter to server, wherein,
When race information issuing module user initiates inquiry first to real time data, the big event of information is looked into according to user
File name needed for the information generation such as code, contest stage and play, type, judges whether this document is deposited to local cache catalogue
If it does not, creating a hiding iframe object by parameter of file absolute path and by by execCommand
Method attribute is set to SaveAs and carries out file download, deposits file after the data file for receiving the return of race message processing module
Put to local cache catalogue.Now data and template are homologous, it is not necessary to cross-domain, so being by AJAX methods setting type parameters
GET, url are that file path, dataType are json, and the character string in JSON files is loaded into internal memory, successful in loading
Character string parsing is object by the interior parseJSON methods by jQuery of call back function, is inserted template and is shown.Work as race
When information issuing module user initiates inquiry again to real time data, it is also desirable to do and once judge, determine after file is present again
The timestamp of local file and server file is contrasted, if server generates renewal, file is re-downloaded and covers this
Ground file.
If asking integrated data to database server, data are looked into using the request of AJAX methods, data are stored in remotely
, it is necessary to solve Cross-domain problem using JSONP attributes on database server.Respectively by url, type, dataType, data parameter
Being set to database server address, GET request type, JSONP return types, SQL statement needs incoming parameter, database service
Device is received after request, by data base management system by the parameter received with parametrization SQL statement and as SQL query statement
Example, and data base querying is carried out according to this sentence, Query Result is in the form of JSON character strings back through jQuery's
ParseJSON () method is deserialized as object, inserts template and enters row information issue displaying.
Information issuing web site develops designer and obtains the information issue data in this domain or foreign lands by above-mentioned design and incite somebody to action
JSON data resolve to object, and the information for obtaining this domain by JavaScript scripts issues template, and data object is inserted into mould
Plate can just obtain user and look into the page, realize static page mobilism, and race information is issued.
Preferably, the data checking mechanisms are that progress of the JSON SCHEMA to JSON files is used under .NET platforms
Verification, end is handled by the event JSON SCHEMA the being pre-created on-site scores for being stored in the project race information acquisition module,
And each event needs the JSON file types uploaded to create JSON SCHEMA according to the event, each type file is created only
One JSON SCHEMA, its verification mode is as follows：
5a) when data sequence is turned to JSON character strings by race information acquisition module and not yet writes JSON files, lead to
Cross passed parameter and locally finding corresponding JSON SCHEMA files, corresponding JSON SCHEMA files are read in internal memory；
A JsonSchemaFactory reality 5b) is created by Default () method of JsonSchemaFactory classes
Example；
It is 5c) using fromString () method of JsonLoader classes, JSON character strings is incoming as parameter, obtain
The JsonNode objects of JSON data；
5d) using fromString () method of JsonLoader classes, the JSON SCHEMA frameworks in internal memory are regard as ginseng
Number is incoming, obtains JsonSchema JsonNode objects；
5e) in 5b) in JsonSchemaFactory examples incoming JSON is passed through using getJsonSchema () method
SCHEMA JsonNode objects produce the JsonSchema objects of instantiation；
5f) instantiation JsonSchema objects are gone by the JsonNode objects of the incoming JSON data of validata () method
Whether checking JSON character strings meet JSON SCHEMA frameworks；
5g) when isSuccess () method return value is 1 in the JsonSchema objects of return, it was demonstrated that the JSON characters
String meets JSON SCHEMA frameworks, into 5h), otherwise into 5i)；
5h) now the JSON character strings of serializing are stored in newly-built JSON files, complete and correct JSON files
Downward previous module is transmitted, and terminates verification；
5i) return and check whether source data is correct, regenerates new JSON, returns to 5a) verify again.
JSON SCHEMA methods for designing are as follows:
Each event need to set up the JSON SCHEMA of this project, by taking following JSON achievements character strings as an example, design the hop count
According to JSON SCHEMA.
Certain JSON achievement character string is as follows：
This section of JSON achievements character string includes sportsman's name, player number, delegation, order coming on the stage, ranking and in detail
Thin performance information, these data should have a respective type format according to contest fact, some data need setting minimum value or
Maximum, some attributes are probably unnecessary, and the corresponding JSON SCHEMA of this JSON character string are as follows：
(1) header information, the first row be JSON SCHEMA there is provided the essential information of this document, " title " is crucial
Word provides title, and " description " keyword provides the description as described in the JSON SCHEMA files or attribute,
" type " keyword is constrained the type of data；
(2) attribute constraint information：Defined since " properties " keyword the Value Types of each attribute, maximum and
Minimum value is constrained, if wherein be true in the presence of " exclusiveMinimum " keyword and its value, representing example value stricti jurise
Effectively, " minLength " keyword is carried example to the character length of character string example when above more than the value of " minimum " keyword
Constraint is supplied.
(3) indispensable attributes information：Indispensable attributes list is deposited after " required " keyword.
The data distribution module provides request and serviced with the reception of data, caching and distribution, and data receiver thread is received
It is parsed during to packet, parsing confirms that its legal and message header identifies the data and needs forwarding, calculates the word of data
Joint number, opens up the space more than byte number as Buffer, then the data is added into Buffer buffering queues, data transmission line
Data in Buffer are written to receiving terminal by receiving terminal in journey traversal SessionList in the way of first in first out.
Data switching center is managed for configuration the Configuration Manager, including basic data management and messaging parameter
Storage communication terminal, data type, message route three tables in configuration, configuration management database, for data switching center
Parameter needed for configuration is managed, and pre-games is united according to contest business demand write-in data by team of Technical Operations Center
One management and maintenance.
As shown in fig. 7, data switching center's workflow in the present invention：
7a), data switching center obtains all terminals and routing rule first, travels through all terminals, receives the sound of terminal
Should after think that the terminal is online, set up with the terminal and be connected and the terminal is added to online waiting list.
7b), create two threads to be respectively intended to receive and distribute, when receiving thread receives request message or packet pair
It is parsed, and dispatch thread judges whether recipient waits online according to data distribution routing rule.
If 7c), receiving terminal is online, data are sent to receiving terminal, if receiving terminal is in off-line state, data are added
Into buffer queue, delay and receiving-end state is judged during by one again.
7d), receiving terminal receive after data to data switching center send receive response, data switching center by data from
Discharged in buffer queue.
The foregoing description of the disclosed embodiments, enables professional and technical personnel in the field to realize or using the present invention.
A variety of modifications to these embodiments will be apparent for those skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, it is of the invention
The embodiments shown herein is not intended to be limited to, and is to fit to and principles disclosed herein and features of novelty phase one
The most wide scope caused.
Claims (6)
1. the race informix processing system based on the network communications technology, it is characterised in that including race information acquisition module,
Race message processing module and race information issuing module, wherein,
The race information acquisition module gathers the real-time achievement data of contest of all individual events and generates JSON files, according to FTP
Communication protocol is uploaded to race message processing module by data switching center；
The race message processing module receives and the real-time achievement data file of contest is stored in into file after competition Information data file
Server, and be the database that data object writes race message processing module by the JSON document analysis related to integrated data
In server, other modules are facilitated to inquire about integrated data；
File server requests and acquisition of the race information issuing module by http protocol to race message processing module
The real-time achievement data of contest, obtains integrated data, and the information of acquisition is carried out exhibition according to business rule to database server
Show.
2. the race informix processing system according to claim 1 based on the network communications technology, it is characterised in that institute
The medium that race information acquisition module is transmitted using JSON files as data storage is stated, by live Ethernet by each contest list
Achievement sequence turns to JSON character strings to item in real time, and JSON files, the JSON are write after being verified by data checking mechanisms
File is uploaded to the file server of race message processing module by data switching center.
3. the race informix processing system according to claim 2 based on the network communications technology, it is characterised in that institute
Stating race message processing module includes information Store submodule and Information Statistics submodule, wherein,
Described information sub-module stored includes file server, for storing the contest real time data received, when race information hair
, can be directly from file server by corresponding JSON file downloads to client when cloth module is initiated to inquire about to contest real time data
End is parsed；
Described information statistic submodule includes database server, for storing Integrated Services Digital, is read from file server
JSON files are taken, are write data into database server, and statistic for receiver medal and integration information write into Databasce server
In, when race information issuing module is initiated to inquire about, query SQL sentence example is sent to database server and inquired about simultaneously
The data of return are generated into JSON character strings, sends to race information issuing module and enters row information issue displaying.
4. the race informix processing system according to claim 1 based on the network communications technology, it is characterised in that institute
State race information issuing module and be based on B/S frameworks, using jQuery frameworks, by asynchronous AJAX methods from race information processing
Module obtains data needed for the information issue page, and information is distributed into official website, client and the using unified data structure
Tripartite website.
5. the race informix processing system according to claim 2 based on the network communications technology, it is characterised in that institute
It is that JSON SCHEMA verifying to JSON files is used under .NET platforms to state data checking mechanisms, by what is be pre-created
Event JSON SCHEMA are stored in the on-site score processing end of the project race information acquisition module, and each event is according to this
Event needs the JSON file types uploaded to create JSON SCHEMA, and each type file creates unique JSON SCHEMA,
Its verification mode is as follows：
5a）When data sequence is turned to JSON character strings by race information acquisition module and not yet writes JSON files, pass through institute
Pass parameter and locally finding corresponding JSON SCHEMA files, corresponding JSON SCHEMA files are read in internal memory；
5b）One JsonSchemaFactory example is created by Default () method of JsonSchemaFactory classes；
5c）It is using fromString () method of JsonLoader classes, JSON character strings is incoming as parameter, obtain JSON numbers
According to JsonNode objects；
5d）Using fromString () method of JsonLoader classes, the JSON SCHEMA frameworks in internal memory are passed as parameter
Enter, obtain JsonSchema JsonNode objects；
5e）In 5b）In JsonSchemaFactory examples incoming JSON is passed through using getJsonSchema () method
SCHEMA JsonNode objects produce the JsonSchema objects of instantiation；
5f）Instantiation JsonSchema objects go checking by the JsonNode objects of the incoming JSON data of validata () method
Whether JSON character strings meet JSON SCHEMA frameworks；
5g）When isSuccess () method return value is 1 in the JsonSchema objects of return, it was demonstrated that the JSON character strings are accorded with
JSON SCHEMA frameworks are closed, into 5h）, otherwise into 5i）；
5h）Now the JSON character strings of serializing are stored in newly-built JSON files, complete and correct JSON files are downward
Previous module is transmitted, and terminates verification；
5i) return and check whether source data is correct, regenerates new JSON, returns to 5a) verify again.
6. the race informix processing system according to claim 1 based on the network communications technology, it is characterised in that institute
Stating data switching center includes data distribution module and Configuration Manager, wherein,
The data distribution module provides request and serviced with the reception of data, caching and distribution, and data receiver thread receives number
It is parsed during according to bag, parsing confirms that its legal and message header identifies the data and needs forwarding, calculates the byte number of data,
The space more than byte number is opened up as Buffer, then the data are added to Buffer buffering queues, data transmission line journey time
Receiving terminal in SessionList is gone through, the data in Buffer are written to receiving terminal in the way of first in first out；
Data switching center is managed for configuration the Configuration Manager, including basic data management and messaging parameter are matched somebody with somebody
Put, communication terminal, data type, message are deposited in configuration management database and route three tables, for matching somebody with somebody to data switching center
Parameter needed for putting is managed, and pre-games is unified according to contest business demand write-in data by team of Technical Operations Center
Management and maintenance.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710131949.9A CN106951476A (en) | 2017-03-07 | 2017-03-07 | Race informix processing system based on the network communications technology |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710131949.9A CN106951476A (en) | 2017-03-07 | 2017-03-07 | Race informix processing system based on the network communications technology |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106951476A true CN106951476A (en) | 2017-07-14 |
Family
ID=59468210
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710131949.9A Pending CN106951476A (en) | 2017-03-07 | 2017-03-07 | Race informix processing system based on the network communications technology |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106951476A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107483467A (en) * | 2017-08-31 | 2017-12-15 | 四川长虹电器股份有限公司 | The JSON message checking methods of Internet interface service |
| CN109360589A (en) * | 2018-10-25 | 2019-02-19 | 天水师范学院 | A kind of competitive sports data statistical approach and system |
| CN110489265A (en) * | 2019-03-07 | 2019-11-22 | 西安博达软件股份有限公司 | A kind of JSON data validation and storage method based on metadata |
| CN111603748A (en) * | 2020-05-20 | 2020-09-01 | 南京风之曲船艇设备有限公司 | iBoat sports training competition system |
| CN111813767A (en) * | 2020-06-30 | 2020-10-23 | 北京玩在一起科技有限公司 | Method and system for processing electricity competition data |
| CN114387940A (en) * | 2022-02-25 | 2022-04-22 | 卡莱特云科技股份有限公司 | Partition display updating method of LED display screen, playing box and display system |
| CN114866359A (en) * | 2022-07-07 | 2022-08-05 | 深圳市泽维电子科技有限公司 | Information unloading processing method, system, terminal and storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105808646A (en) * | 2016-02-26 | 2016-07-27 | 上海全成通信技术有限公司 | Content management checkout method and device in complex page on the basis of json schema |
-
2017
- 2017-03-07 CN CN201710131949.9A patent/CN106951476A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105808646A (en) * | 2016-02-26 | 2016-07-27 | 上海全成通信技术有限公司 | Content management checkout method and device in complex page on the basis of json schema |
Non-Patent Citations (4)
| Title |
|---|
| LIUMIN0470: "《百度文库https://wenku.baidu.com/view/44ff53ac5022aaea998f0fba.html》", 3 January 2015 * |
| 许静等: ""竞赛数据交换平台的研究与实现"", 《微处理机》 * |
| 陈俊宁: ""海上试验场综合数据集成与管理系统设计与实现"", 《知网数据库》 * |
| 高晴等: ""基于网络技术的竞赛信息发布系统研究与设计"", 《微处理机》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107483467A (en) * | 2017-08-31 | 2017-12-15 | 四川长虹电器股份有限公司 | The JSON message checking methods of Internet interface service |
| CN109360589A (en) * | 2018-10-25 | 2019-02-19 | 天水师范学院 | A kind of competitive sports data statistical approach and system |
| CN110489265A (en) * | 2019-03-07 | 2019-11-22 | 西安博达软件股份有限公司 | A kind of JSON data validation and storage method based on metadata |
| CN111603748A (en) * | 2020-05-20 | 2020-09-01 | 南京风之曲船艇设备有限公司 | iBoat sports training competition system |
| CN111813767A (en) * | 2020-06-30 | 2020-10-23 | 北京玩在一起科技有限公司 | Method and system for processing electricity competition data |
| CN114387940A (en) * | 2022-02-25 | 2022-04-22 | 卡莱特云科技股份有限公司 | Partition display updating method of LED display screen, playing box and display system |
| CN114387940B (en) * | 2022-02-25 | 2023-09-15 | 卡莱特云科技股份有限公司 | Partition display updating method, playing box and display system of LED display screen |
| CN114866359A (en) * | 2022-07-07 | 2022-08-05 | 深圳市泽维电子科技有限公司 | Information unloading processing method, system, terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106951476A (en) | Race informix processing system based on the network communications technology | |
| CN104160376B (en) | The offline preparation of virtual machine | |
| CN108647361A (en) | A kind of date storage method, apparatus and system based on block chain | |
| CN103477601B (en) | The method and apparatus working in coordination with caching for network friendliness | |
| CN105208059B (en) | A kind of content distribution method, terminal, server and system | |
| CN100438435C (en) | Method for limiting browser access network address | |
| CN107871242A (en) | Advertisement delivery system and method | |
| CN105872830A (en) | Interaction method and device for live channel | |
| CN107103448A (en) | Data integrated system based on workflow | |
| CN109729166B (en) | Cloud platform is controlled in a kind of number exhibition room intelligence | |
| CN110795072B (en) | Crowd-sourcing competition platform framework system and method based on crowd intelligence | |
| KR20110073282A (en) | Consolidating input messages for social activity summarization | |
| CN103581250B (en) | Data processing, publication, acquisition methods and system | |
| CN109214784A (en) | A kind of method, client, server and the system of fire-fighting inspection management | |
| CN109684530A (en) | Information Push Service system based on web-based management and the application of mobile phone small routine | |
| US20230259938A1 (en) | Blockchain-based data processing method and apparatus, device, readable storage medium and computer program product | |
| CN110490781A (en) | It is a kind of based on the PPT of cloud platform for lecture system and method | |
| CN109729044A (en) | A kind of general internet data acquisition is counter to climb system and method | |
| CN109831334A (en) | Constructing network topology method, apparatus and terminal device | |
| CN100530197C (en) | System for sharing collected data | |
| CN103281211A (en) | Large-scale network node grouping management system and management method | |
| CN115048080A (en) | Science and technology special distributor service cloud platform construction system based on big data | |
| CN104636395A (en) | Count processing method and device | |
| US20100235319A1 (en) | Method and System for Converting Virtual Item | |
| CN107147531B (en) | CDM cluster website management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170714 |